宜昌华友原料库管理软件
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

90 lines
2.1 KiB

/***************************************************************************
*
* 功能: 持久层基类
* 作者: Siasun
* 日期: 2013/4/11
*
* 修改日期:
* 修改人:
* 修改内容:
*
* *************************************************************************/
namespace SiaSun.LMS.Persistence
{
using System;
using System.Collections;
using System.Collections.Generic;
using IBatisNet.Common;
using IBatisNet.DataMapper;
using IBatisNet.Common.Exceptions;
using SiaSun.LMS.Model;
/// <summary>
/// STORAGE_LIST
/// </summary>
public class P_STORAGE_LIST : P_Base_House
{
public P_STORAGE_LIST ()
{
//
// TODO: 此处添加STORAGE_LIST的构造函数
//
}
/// <summary>
/// 得到列表
/// </summary>
public IList<STORAGE_LIST> GetList()
{
return ExecuteQueryForList<STORAGE_LIST>("STORAGE_LIST_SELECT",null);
}
/// <summary>
/// 得到列表
/// </summary>
public IList<STORAGE_LIST> GetListStorageID(int STORAGE_ID)
{
return this.ExecuteQueryForList<STORAGE_LIST>("STORAGE_LIST_SELECT_BY_STORAGE_ID", STORAGE_ID);
}
/// <summary>
/// 新建
/// </summary>
public int Add(STORAGE_LIST storage_list)
{
//int id = this.GetPrimaryID("STORAGE_LIST","STORAGE_LIST_ID");
//storage_list.STORAGE_LIST_ID = id;
return ExecuteInsert("STORAGE_LIST_INSERT",storage_list);
}
/// <summary>
/// 修改
/// </summary>
public int Update(STORAGE_LIST storage_list)
{
return ExecuteUpdate("STORAGE_LIST_UPDATE",storage_list);
}
/// <summary>
/// 得到明细
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public STORAGE_LIST GetModel(System.Int32 STORAGE_LIST_ID)
{
return ExecuteQueryForObject<STORAGE_LIST>("STORAGE_LIST_SELECT_BY_ID",STORAGE_LIST_ID);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
public int Delete(System.Int32 STORAGE_LIST_ID)
{
return ExecuteDelete("STORAGE_LIST_DELETE",STORAGE_LIST_ID);
}
}
}