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