using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
|
namespace WebAPI.DLL
|
{
|
public class ClsGy_WorkPayTypeBill : DBUtility.ClsXt_BaseBill
|
{
|
public Model.ClsGy_WorkPayType_Model omodel = new Model.ClsGy_WorkPayType_Model();
|
|
public ClsGy_WorkPayTypeBill()
|
{
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "Gy_WorkPayType";
|
base.MvarReportTitle = "工资类型";
|
base.BillType = "";
|
base.HBillSubType = "";
|
}
|
|
//新增单据
|
public override bool AddBill(ref string sReturn)
|
{
|
try
|
{
|
//若MAINDI重复则重新获取
|
oCn.BeginTran();
|
//主表
|
oCn.RunProc("Insert Into Gy_WorkPayType " +
|
"(HNumber,HName,HHelpCode,HRemark,HStopflag,HUseFlag,HShortNumber,HParentID,HLevel,HEndFlag" +
|
") " +
|
" values('" + omodel.HNumber + "','" + omodel.HName + "','" +
|
omodel.HHelpCode + "','" + 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_WorkPayType set " +
|
" HNumber='" + omodel.HNumber + "'" + //固定赋值===============
|
",HName='" + omodel.HName + "'" +
|
",HHelpCode='" + omodel.HHelpCode + "'" +
|
",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);
|
}
|
}
|
|
}
|
}
|
