using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace WebAPI.DLL
|
{
|
public class ClsEqiupMaterWorkTimes_Ctl : DBUtility.ClsGy_Base_Ctl
|
{
|
|
SQLHelper.ClsCN oCn = new SQLHelper.ClsCN();
|
//原代码 用于 替换子项目
|
public string HOldNumber;
|
public Model.ClsEqiupMaterWorkTimes_Model oModel = new Model.ClsEqiupMaterWorkTimes_Model();
|
//新增
|
public override bool AddNew()
|
{
|
|
try
|
{
|
oCn.BeginTran();
|
|
oCn.RunProc("Insert into " + MvarItemKey + " " +
|
" (HEquipFileNo,HMaterNumber,HWorkTimes" +
|
",HMakeTime,HMakeEmp" +
|
") " +
|
" Values('" + oModel.HEquipNumber + "','" + oModel.HMaterNumber + "'," + oModel.HWorkTimes + ",'" + oModel.HMakeTime + "','" + oModel.HMakeEmp + "'" +
|
")", ref DBUtility.ClsPub.sExeReturnInfo);
|
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//修改
|
public override bool ModifyByID(Int64 sItemID)
|
{
|
try
|
{
|
|
oCn.BeginTran();
|
oCn.RunProc("Update " + MvarItemKey + " set " +
|
" HEquipFileNo='" + oModel.HEquipNumber + "'" +
|
",HMaterNumber='" + oModel.HMaterNumber + "'" +
|
",HWorkTimes='" + oModel.HWorkTimes + "'" +
|
",HModifyEmp ='" + oModel.HMakeEmp + "'" +
|
",HModifyTime=getdate() Where HItemID=" + sItemID, ref DBUtility.ClsPub.sExeReturnInfo);
|
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//构造函数
|
public ClsEqiupMaterWorkTimes_Ctl()
|
{
|
MvarItemKey = "EqiupMaterWorkTimes";
|
MvarReportTitle = "设备节拍设置";
|
oModel = new Model.ClsEqiupMaterWorkTimes_Model();
|
}
|
|
|
|
}
|
}
|
