using System;
|
using System.Collections.Generic;
|
using System.Linq;
|
using System.Web;
|
|
namespace WebAPI.DLL
|
{
|
public class ClsGy_DuSubsidyItemBill : DBUtility.ClsXt_BaseBill
|
{
|
public Model.ClsGy_DuSubsidyItem_Model omodel = new Model.ClsGy_DuSubsidyItem_Model();
|
|
public ClsGy_DuSubsidyItemBill()
|
{
|
base.MvarItemKeySub = "";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "Gy_DuSubsidyItem";
|
base.MvarReportTitle = "扣补资料";
|
base.BillType = "";
|
base.HBillSubType = "";
|
}
|
|
//新增单据
|
public override bool AddBill(ref string sReturn)
|
{
|
try
|
{
|
//若MAINDI重复则重新获取
|
oCn.BeginTran();
|
//主表
|
oCn.RunProc("Insert Into Gy_DuSubsidyItem " +
|
"(HNumber,HName,HHelpCode,HRemark,HStopflag,HUseFlag,HShortNumber,HParentID,HLevel,HEndFlag,HSno,HType,HCaption,HSQLColumnName,HDataType,HDefaultValue" +
|
",HLength,HSys,HSearch,HMustSave,HSearchTable,HTable" +
|
") " +
|
" values('" + omodel.HNumber + "','" + omodel.HName + "','" +
|
omodel.HHelpCode + "','" + omodel.HRemark + "','" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "','未使用','" +
|
omodel.HNumber + "',0,0,0" + "," + omodel.HSno.ToString() + ",'"+ omodel.HType + "','" + omodel.HCaption + "','"+ omodel.HSQLColumnName + "','" +
|
omodel.HDataType + "','" + omodel.HDefaultValue + "',"+ omodel.HLength.ToString() + ",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_DuSubsidyItem set " +
|
" HNumber='" + omodel.HNumber + "'" + //固定赋值===============
|
",HName='" + omodel.HName + "'" +
|
",HHelpCode='" + omodel.HHelpCode + "'" +
|
",HRemark='" + omodel.HRemark + "'" +
|
",HStopflag='" + Convert.ToString(omodel.HStopflag ? 1 : 0) + "'" +
|
",HShortNumber='" + omodel.HNumber + "'" +
|
",HSno=" + omodel.HSno.ToString() +
|
",HType='" + omodel.HType + "'" +
|
",HCaption='" + omodel.HCaption + "'" +
|
",HSQLColumnName='" + omodel.HSQLColumnName + "'" +
|
",HDataType='" + omodel.HDataType + "'" +
|
",HDefaultValue='" + omodel.HDefaultValue + "'" +
|
",HLength=" + omodel.HLength.ToString() +
|
|
" where HItemID=" + lngBillKey.ToString());
|
sReturn = "修改单据成功！";
|
oCn.Commit();
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
}
|
}
|
