using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
|
namespace WebAPI.DLL
|
{
|
public class ClsGy_WorkTypeBill : DBUtility.ClsXt_BaseBill
|
{
|
public Model.ClsGy_WorkType_Model omodel = new Model.ClsGy_WorkType_Model();
|
public List<Model.ClsGy_WorkTypeSub> DetailColl = new List<Model.ClsGy_WorkTypeSub>();
|
|
public ClsGy_WorkTypeBill()
|
{
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "Gy_WorkType";
|
base.MvarReportTitle = "工种设置";
|
base.BillType = "";
|
base.HBillSubType = "";
|
}
|
|
#region 固定代码
|
|
~ClsGy_WorkTypeBill()
|
{
|
DetailColl = null;
|
}
|
|
#endregion 自定义方法
|
|
//新增单据
|
public override bool AddBill(ref string sReturn)
|
{
|
try
|
{
|
//若MAINDI重复则重新获取
|
oCn.BeginTran();
|
//主表
|
oCn.RunProc("Insert Into Gy_WorkType " +
|
"(HNumber,HName,HPayMoney,HDayMoney,HHelpCode,HForEmp,HRemark,HStopflag,HUseFlag,HShortNumber,HParentID,HLevel,HEndFlag" +
|
") " +
|
" values('" + omodel.HNumber+"','"+ omodel.HName + "','" + omodel.HPayMoney + "','" + omodel.HDayMoney + "','"+
|
omodel.HHelpCode + "','" + omodel.HForEmp + "','" + omodel.HRemark + "','" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "','未使用','"+
|
omodel.HNumber + "',0,0,0" +
|
") ");
|
sReturn = "新增单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
|
//修改单据
|
public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//
|
oCn.BeginTran();
|
//更新主表
|
oCn.RunProc("UpDate Gy_WorkType set " +
|
" HNumber='" + omodel.HNumber + "'" + //固定赋值===============
|
",HName='" + omodel.HName + "'" +
|
",HPayMoney='" + omodel.HPayMoney + "'" +
|
",HDayMoney='" + omodel.HDayMoney + "'" +
|
",HHelpCode='" + omodel.HHelpCode + "'" +
|
",HForEmp='" + omodel.HForEmp + "'" +
|
",HRemark='" + omodel.HRemark + "'" +
|
",HStopflag='" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "'" +
|
|
" where HItemID=" + lngBillKey.ToString());
|
sReturn = "修改单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
}
|
}
|
