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