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
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);
|
|
}
|
|
|
|
}
|
|
}
|