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

    }
}