宜昌华友原料库管理软件
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.

114 lines
3.0 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>
/// IO_CONTROL
/// </summary>
public class P_IO_CONTROL : P_Base_House
{
public P_IO_CONTROL ()
{
//
// TODO: 此处添加IO_CONTROL的构造函数
//
}
/// <summary>
/// 得到列表
/// </summary>
public IList<IO_CONTROL> GetList()
{
return ExecuteQueryForList<IO_CONTROL>("IO_CONTROL_SELECT",null);
}
/// <summary>
/// 得到列表
/// </summary>
public IList<IO_CONTROL> GetListrRetrunTask()
{
return ExecuteQueryForList<IO_CONTROL>("IO_CONTROL_SELECT_RETURN_TASK", null);
}
/// <summary>
/// 新建
/// </summary>
public int Add(IO_CONTROL io_control)
{
//int id = this.GetPrimaryID("IO_CONTROL","IO_CONTROL_ID");
//io_control.CONTROL_ID = id;
return ExecuteInsert("IO_CONTROL_INSERT",io_control);
}
/// <summary>
/// 修改
/// </summary>
public int Update(IO_CONTROL io_control)
{
return ExecuteUpdate("IO_CONTROL_UPDATE",io_control);
}
/// <summary>
/// 得到明细
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IO_CONTROL GetModel(System.Int32 CONTROL_ID)
{
return ExecuteQueryForObject<IO_CONTROL>("IO_CONTROL_SELECT_BY_ID",CONTROL_ID);
}
public IO_CONTROL GetModel_BY_STOCK_BARCODE(string STOCK_BARCODE)
{
return ExecuteQueryForObject<IO_CONTROL>("IO_CONTROL_SELECT_BY_STOCK_BARCODE", STOCK_BARCODE);
}
public IList<IO_CONTROL> GetModel_BY_END_DEVICE_CODE(string END_DEVICE_CODE)
{
return ExecuteQueryForList<IO_CONTROL>("IO_CONTROL_SELECT_BY_END_DEVICE_CODE", END_DEVICE_CODE);
}
/// <summary>
/// 得到明细
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public IO_CONTROL GetModelManageID(System.Int32 MANAGE_ID)
{
return ExecuteQueryForObject<IO_CONTROL>("IO_CONTROL_SELECT_BY_MANAGE_ID", MANAGE_ID);
}
/// <summary>
/// 删除
/// </summary>
/// <param name="id"></param>
public int DeleteManageID(System.Int32 MANAGE_ID)
{
return ExecuteDelete("IO_CONTROL_DELETE", MANAGE_ID);
}
/// <summary>
/// 删除控制ID
/// </summary>
/// <param name="id"></param>
public int DeleteControlID(System.Int32 CONTROL_ID)
{
return ExecuteDelete("IO_CONTROL_DELETE_BY_CONTROL_ID", CONTROL_ID);
}
}
}