using System;
using System.Collections.Generic;
using System.Text;
using System.Data;

namespace DAL
{
    public  class ClsXt_ModuleParameter:DBUtility.ClsXt_BaseBill
    {
        public Model.ClsXt_ModuleParameterMain omodel = new Model.ClsXt_ModuleParameterMain();
        public List<Model.ClsXt_ModuleParameterSub> DetailColl = new List<Model.ClsXt_ModuleParameterSub>();

        public ClsXt_ModuleParameter()
        {
            base.MvarItemKeySub = "Xt_ModuleParameterSub";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey="Xt_ModuleParameterMain";
            base.MvarReportTitle="模块参数设置";
            base.BillType = "8002";
            base.HBillSubType = "8002";

        }

        #region 固定代码

        ~ClsXt_ModuleParameter()
        {
            DetailColl = null;
        }
       
        #endregion   自定义方法
        //修改单据
        
        //新增单据
        public override bool AddBill(ref string sReturn)
        {
            try
            {
                //得到mainid
                omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                //若MAINDI重复则重新获取
                oCn.BeginTran();
                //主表
                oCn.RunProc("Insert Into Xt_ModuleParameterMain   " +
                "(HInterID,HBillType,HUserID,HModuleName,HFreezeCol" +
                ",HFontSize,HHeadHeight,HContextHeight,HSortFlag,HSelTotal" +
                ") " +
                " values( " + omodel.HInterID.ToString() + ",'" + omodel.HBillType + "','" + omodel.HUserID.ToString () + "','" + omodel.HModuleName + "'," + omodel.HFreezeCol.ToString() +
                ", " + omodel.HFontSize.ToString() + "," + omodel.HHeadHeight.ToString() + "," + omodel.HContextHeight.ToString() + ",'" + omodel.HSortFlag + "','" + omodel.HSelTotal + "'" +
                ")");
                //插入子表
                foreach (Model.ClsXt_ModuleParameterSub oSub in DetailColl)
                {
                    oCn.RunProc("Insert into Xt_ModuleParameterSub " +
                      " (HInterID,HEntryID,HCellName,HHideFlag,HDuiQi" +
                      ",HDecimal,HEditFlag" +
                      ") values("+ omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCellName + "'," + Convert.ToString(oSub.HHideFlag ? 1 : 0) + ",'" + oSub.HDuiQi.ToString() + "'" +
                      "," + oSub.HDecimal.ToString() + ",'" + oSub.HEditFlag + "'" +
                      ") ");
                }
                //
                //foreach (Model.ClsXt_ModuleParameterSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Xt_ModuleParameter_Qty " + oSub.HICMOInterID, "");
                //    if (Ds.Tables[0].Rows.Count == 0)
                //        return;
                //    if (DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBool"]) == "Y")
                //    {
                //        sReturn = "汇报数量超过计划数量！不允许保存";
                //        return false;
                //    }
                //}
                //
                sReturn = "新增单据成功！";
                oCn.Commit();
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                oCn.RollBack();
                throw (e);
            }
        }
        //显示单据
        public override bool ShowBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //查询主表
                DataSet Ds ;
                Ds = oCn.RunProcReturn("Select * from Xt_ModuleParameterMain Where HInterID=" + lngBillKey.ToString(), "Xt_ModuleParameterMain");
                if(Ds.Tables[0].Rows.Count==0)
                {
                    sReturn = "单据未找到！";
                    return false;
                }
                //固定赋值===========================================
              
                //========================================================
                omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]);
                omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]);
                omodel.HUserID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HUserID"]);
                omodel.HModuleName = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HModuleName"]);
                omodel.HFreezeCol = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HFreezeCol"]);
                omodel.HFontSize = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HFontSize"]);
                omodel.HHeadHeight = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HHeadHeight"]);
                omodel.HContextHeight = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HContextHeight"]);
                omodel.HSortFlag = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSortFlag"]);
                omodel.HSelTotal = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSelTotal"]);
                //
                
                //循环
                DataSet DsSub ;
                DsSub = oCn.RunProcReturn("Select * from Xt_ModuleParameterSub Where HInterID=" + lngBillKey.ToString() + " order by HEntryID ", "Xt_ModuleParameterSub");
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsXt_ModuleParameterSub oSub = new Model.ClsXt_ModuleParameterSub();
                    // 固定赋值===============================================
                   
                    //===================================================
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
                    oSub.HCellName = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCellName"]);
                    oSub.HHideFlag = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HHideFlag"]);
                    oSub.HDuiQi = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HDuiQi"]);
                    oSub.HEditFlag = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HEditFlag"]);
                    oSub.HDecimal = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HDecimal"]);
                    DetailColl.Add(oSub);
                }
                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

        //审核
        //public bool CheckBill(Int64 lngBillKey, ref string sReturn)
        //{

        //    try
        //    {
        //        string HChecker = DBUtility.ClsPub.CurUserName;
        //        string HCheckDate = DBUtility.ClsPub.GetServerDate(-1);
        //        oCn.RunProc(" Update Xt_ModuleParameterMain set HChecker='" + HChecker + "',HCheckDate='" + HCheckDate + "' Where HInterID=" + lngBillKey.ToString());
        //        oCn.RunProc("exec h_p_Gy_Employee_Update " + lngBillKey.ToString());
        //        sReturn = "";
        //        return true;
        //    }
        //    catch (Exception e)
        //    {
        //        sReturn = e.Message;
        //        throw (e);
        //    }
        //}
       
        
    }

}