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

namespace DAL
{
    public  class ClsCustomerProInfoBill : DBUtility.ClsXt_BaseBill
    {
        public Model.ClsPM_CustomerProInfoBillMain omodel = new Model.ClsPM_CustomerProInfoBillMain();
        public List<Model.ClsPM_CustomerProInfoBillSub> DetailColl = new List<Model.ClsPM_CustomerProInfoBillSub>();

        public ClsCustomerProInfoBill()
        {
            base.MvarItemKeySub = "PM_CustomerProInfoBillSub";
            base.MvarItemKeySub2 = "";
            base.MvarItemKeySub3 = "";
            base.MvarItemKeySub4 = "";
            base.MvarItemKey= "PM_CustomerProInfoBillMain";
            base.MvarReportTitle="客户项目信息";
            base.BillType="1401";
            base.HBillSubType = "1401";

        }

        #region 固定代码

        ~ClsCustomerProInfoBill()
        {
            DetailColl = null;
        }
       
        #endregion   自定义方法
        //修改单据
        public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
        {
            try
            {
                //
                //oCn.BeginTran();
                ////更新主表
                //oCn.RunProc("UpDate Xs_SeOrderBillMain set  " +
                //" HBillNo='" + omodel.HBillNo + "'" +  //固定赋值===============
                //",HDate='" + omodel.HDate + "'" +
                //",HYear='" + omodel.HYear.ToString() + "'" +
                //",HPeriod='" + omodel.HPeriod.ToString() + "'" +
                //",HRemark='" + omodel.HRemark + "'" +
                //",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" +
                //",HUpDateDate=getdate()" +
                //    //========================================
                //",HSSDate='" + omodel.HSSDate.ToShortDateString() + "'" +
                //",HAddress='" + omodel.HAddress + "'" +
                //",HSSID=" + omodel.HSSID.ToString() +
                //",HSellSID=" + omodel.HSellSID.ToString() +
                //",HCusID=" + omodel.HCusID.ToString() +
                //",HCurID=" + omodel.HCurID.ToString() +
                //",HExRate=" + omodel.HExRate.ToString() +
                //",HEmpID=" + omodel.HEmpID.ToString() +
                //",HManagerID=" + omodel.HManagerID.ToString() +
                //",HDeptID=" + omodel.HDeptID.ToString() +
                //",HExplanation='" + omodel.HExplanation + "'" +
                //",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
                //" where HInterID=" + lngBillKey.ToString());

                //保存前控制=========================================
                string HBillNote = "";
                DataSet ds = oCn.RunProcReturn("Exec h_p_PM_CustomerProInfoBill_BeforeSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_PM_CustomerProInfoBill_BeforeSaveCtrl");
                if (ds == null)
                {
                    sReturn = "保存前判断失败！";
                    return false;
                }
                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
                    return false;
                }
                //=========================================================

                oCn.BeginTran();
                string mainSql = "UpDate PM_CustomerProInfoBillMain set  " +
                 "HYear = " + omodel.HYear +
                    ", HPeriod = " + omodel.HPeriod +
                    ",HBillType = '" + this.BillType +
                    "',HBillSubType = '" + omodel.HBillSubType +
                    "',HInterID = " + omodel.HInterID +
                    ",HDate = '" + omodel.HDate +

                    "',HBillNo = '" + omodel.HBillNo +
                    "',HBillStatus = " + omodel.HBillStatus +
                    ",HCheckItemNowID = " + omodel.HCheckItemNowID +
                    ",HCheckItemNextID = " + omodel.HCheckItemNextID +
                    ",HCheckFlowID = " + omodel.HCheckFlowID +
                    ",HRemark = '" + omodel.HRemark +
                    "',HBacker = '" + omodel.HBacker +
                    "',HBackDate = '" + omodel.HBackDate +
                    "',HBackRemark = '" + omodel.HBackRemark +
                    "',HChecker = '" + omodel.HChecker +
                    "',HCheckDate = '" + omodel.HCheckDate +
                    "',HMaker = '" + omodel.HMaker +
                    "',HMakeDate = getdate()" +
                    ",HUpDater = '" + omodel.HUpDater +
                    "',HUpDateDate = '" + omodel.HUpDateDate +
                    "',HCloseMan = '" + omodel.HCloseMan +
                    "',HCloseDate = '" + omodel.HCloseDate +
                    "',HCloseType = '" + omodel.HCloseType +
                    "',HDeleteMan = '" + omodel.HDeleteMan +

                    "',HDeleteDate = '" + omodel.HDeleteDate +
                    "',HMainSourceBillType = '" + omodel.HMainSourceBillType +

                    "',HMainSourceInterID = " + omodel.HMainSourceInterID +
                    ",HMainSourceEntryID = " + omodel.HMainSourceEntryID +
                    ",HMainSourceBillNo = '" + omodel.HMainSourceBillNo +
                    "',HPrintQty = " + omodel.HPrintQty +
                    ",HItemMainID = " + omodel.HItemMainID +
                    ",HIP = '" + omodel.HIP +
                    "',HPassword = '" + omodel.HPassword +
                    "',HWeb = '" + omodel.HWeb +
                    "',HDataBaseIP = '" + omodel.HDataBaseIP +
                    "',HSunflower = '" + omodel.HSunflower +
                    "',HOrgID = '" + omodel.HOrgID +
                    "' where HInterID=" + lngBillKey;

                oCn.RunProc(mainSql);
                //删除关联
                DeleteRelation(ref sReturn, lngBillKey);
                //删除子表
                //DeleteBillSub(lngBillKey);
                //插入子表
                //omodel.HInterID = lngBillKey;
                //foreach (Model.ClsPM_CustomerProInfoBillSub oSub in DetailColl)
                //{
                //    //oCn.RunProc("Insert into Xs_SeOrderBillSub " +
                //    //  " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
                //    //  ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                //    //  ",HMaterID,HUnitID,HQty,HPrice,HMoney,HTaxRate" +
                //    //  ",HTaxMoney,HlineTotal,HlineTotalBB,HDate" +
                //    //  ",HTaxPrice,HDiscountRate,HRelTaxPrice,HOutStockQty,HInvoiceQty" +
                //    //  ") values("
                //    //  + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
                //    //  "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
                //    //  "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HTaxRate.ToString() +
                //    //  "," + oSub.HTaxMoney.ToString() + "," + oSub.HlineTotal.ToString() + "," + oSub.HlineTotalBB.ToString() + ",'" + oSub.HDate.ToShortDateString() + "'" +
                //    //  "," + oSub.HTaxPrice.ToString() + "," + oSub.HDiscountRate.ToString() + "," + oSub.HRelTaxPrice.ToString() + "," + oSub.HOutStockQty.ToString() + "," + oSub.HInvoiceQty.ToString() + 
                //    //  ") ");

                //    string subSql = "Insert into Xs_SeOrderBillSub" +
                //        "(HInterID,HEntryID,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationQty_SellOutCheck,HRelationMoney_SellOutCheck,HRelationQty_ICMO,HRelationQty_SellBack,HRelationQty_SellBackCheck,HRelationMoney,HMaterID,HUnitID,HQty,HPrice,HTaxPrice,HMoney" +
                //        ",HDiscountRate,HRelTaxPrice,HTaxRate,HTaxMoney,HlineTotal,HlineTotalBB,HDate,HOutStockQty,HInvoiceQty,HRemark,HOrderLevID" +
                //        ",HCusMaterNumber,HCusModel,HCusMaterName,HisStockGoods,HWHID,HRemark_TL,HRemark_SJG) " +
                //        "values(" +
                //        "" + omodel.HInterID +
                //        "," + oSub.HEntryID +
                //        "," + oSub.HSourceInterID +
                //        "," + oSub.HSourceEntryID +
                //        ",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) +
                //        "','" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) +
                //        "'," + oSub.HRelationQty +
                       
                //        ")";
                //    oCn.RunProc(subSql);
                //}

                //=========================保存后控制  
                DataSet ds2 = oCn.RunProcReturn("h_p_PM_CustomerProInfoBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_PM_CustomerProInfoBill_AfterSaveCtrl");
                if (ds2 == null)
                {
                    sReturn = "保存后控制判断失败！";
                    oCn.RollBack();
                    return false;
                }
                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
                    oCn.RollBack();
                    return false;
                }
                //============================

                //
                //foreach (Model.ClsXs_SeOrderBillSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Xs_SeOrderBill_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 AddBill(ref string sReturn)
        {
            try
            {
                //保存前控制=========================================
                string HBillNote = "";
                DataSet ds = oCn.RunProcReturn("Exec h_p_PM_CustomerProInfoBill_BeforeSaveCtrl  " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "','" + HBillNote + "',1 ", "h_p_PM_CustomerProInfoBill_BeforeSaveCtrl ");
                if (ds == null)
                {
                    sReturn = "保存前判断失败！";
                    return false;
                }
                if (DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败！" + DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[0]["HBackRemark"]);
                    return false;
                }
                //=========================================================

                ////得到mainid
                //omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                //omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
                ////若MAINDI重复则重新获取
                //if (IsExistBillNo(ref DBUtility.ClsPub.sExeReturnInfo, omodel.HBillNo, Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew, omodel.HInterID))
                //{
                //    omodel.HBillNo = DBUtility.ClsPub.CreateBillCode(BillType, ref DBUtility.ClsPub.sExeReturnInfo, true);
                //}
                //if (IsExistMainID(ref DBUtility.ClsPub.sExeReturnInfo, omodel.HInterID, Pub_Class.ClsPub.Enum_BillStatus.BillStatus_AddNew))
                //{
                //    omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                //}
                ////
                //oCn.BeginTran();
                ////主表
                //oCn.RunProc("Insert Into Xs_SeOrderBillMain   " +
                //"(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
                //",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
                //",HAddress,HSSID,HSellSID,HCusID,HCurID,HExRate,HSSDate" +
                //",HEmpID,HManagerID,HDeptID,HExplanation,HInnerBillNo" +
                //") " +
                //" values('" + this.BillType + "','"  + this.HBillSubType + "'," +omodel.HInterID.ToString() + ",'" + omodel.HBillNo + "','" + omodel.HDate + "'" +
                //", " + omodel.HYear.ToString() + "," + omodel.HPeriod.ToString() + ",'" + omodel.HRemark + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
                //",'" + omodel.HAddress + "'," + omodel.HSSID.ToString() + "," + omodel.HSellSID.ToString() + "," + omodel.HCusID.ToString() + "," + omodel.HCurID.ToString() + "," + omodel.HExRate.ToString() + ",'" + omodel.HSSDate.ToShortDateString() + "'" +
                //", " + omodel.HEmpID.ToString() + "," + omodel.HManagerID.ToString() + "," + omodel.HDeptID.ToString() + ",'" + omodel.HExplanation + "','" + omodel.HInnerBillNo + "'"+
                //") ");

                oCn.BeginTran();

                //检查主表内码是否重复，若重复则重新生成并继续检查，直到不再重复
                while (true)
                {
                    ds = oCn.RunProcReturn("select * from PM_CustomerProInfoBillMain where HInterID = " + omodel.HInterID, "PM_CustomerProInfoBillMain  ");
                    if (ds != null && ds.Tables[0].Rows.Count > 0)
                    {
                        omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
                    }
                    else
                    {
                        break;
                    }
                }

                //插入主表
                string mainSql = "Insert Into PM_CustomerProInfoBillMain" +
                    "(HYear,HPeriod,HBillType,HBillSubType,HInterID,HDate" +
                    ",HBillNo,HBillStatus,HCheckItemNowID,HCheckItemNextID,HCheckFlowID,HRemark,HBacker,HBackDate,HBackRemark ,HChecker ,HCheckDate,HMaker,HMakeDate,HUpDater,HUpDateDate,HCloseMan,HCloseDate,HCloseType,HDeleteMan,HDeleteDate,HMainSourceBillType,HMainSourceInterID" +
                    ",HMainSourceEntryID,HMainSourceBillNo,HPrintQty,HItemMainID,HIP,HPassword,HWeb,HDataBaseIP,HSunflower,HOrgID) " +
                    "values(" +
                    "" + omodel.HYear +
                    "," + omodel.HPeriod +
                    ",'" + this.BillType +
                    "','" + omodel.HBillSubType +
                    "'," + omodel.HInterID +
                    ",'" + omodel.HDate +

                    "','" + omodel.HBillNo +
                    "'," + omodel.HBillStatus +
                    "," + omodel.HCheckItemNowID +
                    "," + omodel.HCheckItemNextID +
                    "," + omodel.HCheckFlowID +
                    ",'" + omodel.HRemark +
                    "','" + omodel.HBacker +
                    "','" + omodel.HBackDate +
                    "','" + omodel.HBackRemark +
                    "','" + omodel.HChecker +
                    "','" + omodel.HCheckDate +
                    "','" + omodel.HMaker +
                    "',getdate()" +
                    ",'" + omodel.HUpDater +
                    "','" + omodel.HUpDateDate +
                    "','" + omodel.HCloseMan +
                    "','" + omodel.HCloseDate +
                    "','" + omodel.HCloseType +
                    "','" + omodel.HDeleteMan +

                    "','" + omodel.HDeleteDate +
                    "','" + omodel.HMainSourceBillType +

                    "'," + omodel.HMainSourceInterID +
                    "," + omodel.HMainSourceEntryID +
                    ",'" + omodel.HMainSourceBillNo +
                    "'," + omodel.HPrintQty +
                    "," + omodel.HItemMainID +
                    ",'" + omodel.HIP +
                    "','" + omodel.HPassword +
                    "','" + omodel.HWeb +
                    "','" + omodel.HDataBaseIP +
                    "','" + omodel.HSunflower +
                    "','" + omodel.HOrgID +
                    "')";
                    
                oCn.RunProc(mainSql);
                //插入子表
                foreach (Model.ClsPM_CustomerProInfoBillSub oSub in DetailColl)
                {
                    //oCn.RunProc("Insert into Xs_SeOrderBillSub " +
                    //  " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
                    //  ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
                    //  ",HMaterID,HUnitID,HQty,HPrice,HMoney,HTaxRate" +
                    //  ",HTaxMoney,HlineTotal,HlineTotalBB,HDate" +
                    //  ",HTaxPrice,HDiscountRate,HRelTaxPrice,HOutStockQty,HInvoiceQty" +
                    //  ") values("
                    //  + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HCloseMan + "','" + oSub.HEntryCloseDate.ToShortDateString() + "'," + Convert.ToString(oSub.HCloseType ? 1 : 0) + ",'" + oSub.HRemark + "'" +
                    //  "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
                    //  "," + oSub.HMaterID.ToString() + "," + oSub.HUnitID.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HPrice.ToString() + "," + oSub.HMoney.ToString() + "," + oSub.HTaxRate.ToString() +
                    //  "," + oSub.HTaxMoney.ToString() + "," + oSub.HlineTotal.ToString() + "," + oSub.HlineTotalBB.ToString() + ",'" + oSub.HDate.ToShortDateString() + "'" +
                    //  "," + oSub.HTaxPrice.ToString() + "," + oSub.HDiscountRate.ToString() + "," + oSub.HRelTaxPrice.ToString() + "," + oSub.HOutStockQty.ToString() + "," + oSub.HInvoiceQty.ToString() +
                    //  ") ");
                    string subSql = "Insert into PM_CustomerProInfoBillSub " +
                        "(HInterID,HBillNo_bak,HCloseMan,HEntryCloseDate,HCloseType,HRemark ,HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney,HItemSubID" 
                        +
                        "values(" +
                        "" + omodel.HInterID +
                        "," + oSub.HBillNo_bak +
                        "," + oSub.HEntryID +
                        "," + oSub.HCloseMan +
                        "," + oSub.HEntryCloseDate +
                        "," + oSub.HCloseType +
                        "," + oSub.HRemark +
                        "," + oSub.HSourceInterID +
                        "," + oSub.HSourceEntryID +
                        ",'" + (oSub.HSourceBillNo == null ? "" : oSub.HSourceBillNo) +
                           "','" + (oSub.HSourceBillType == null ? "" : oSub.HSourceBillType) +
                        "," + oSub.HRelationQty +
                        "," + oSub.HRelationMoney +
                        "," + oSub.HItemSubID +
                        ")";
                    oCn.RunProc(subSql);
                }

                //=========================保存后控制  
                DataSet ds2 = oCn.RunProcReturn("h_p_PM_CustomerProInfoBill_AfterSaveCtrl " + omodel.HInterID.ToString() + ", '" + omodel.HBillNo + "',1 ", "h_p_PM_CustomerProInfoBill_AfterSaveCtrl");
                if (ds2 == null)
                {
                    sReturn = "保存后控制判断失败！";
                    oCn.RollBack();
                    return false;
                }
                if (DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBack"]) != "0")
                {
                    sReturn = "保存失败2！" + DBUtility.ClsPub.isStrNull(ds2.Tables[0].Rows[0]["HBackRemark"]);
                    oCn.RollBack();
                    return false;
                }
                //============================


                //
                //foreach (Model.ClsXs_SeOrderBillSub oSub in DetailColl)
                //{
                //    Ds = oCn.RunProcReturn("exec h_p_Xs_SeOrderBill_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 PM_CustomerProInfoBillMain Where HInterID=" + lngBillKey.ToString(), "PM_CustomerProInfoBillMain");
                if(Ds.Tables[0].Rows.Count==0)
                {
                    sReturn = "单据未找到！";
                    return false;
                }
                //固定赋值===========================================
                omodel.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HYear"]);
                omodel.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPeriod"]);
                omodel.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillType"]);
                omodel.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBillSubType"]);
                omodel.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HInterID"]);
                omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["HDate"]);
                omodel.HBillNo = Ds.Tables[0].Rows[0]["HBillNo"].ToString().Trim();
                omodel.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HBillStatus"]);
                omodel.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNowID"]);
                omodel.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckItemNextID"]);
                omodel.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckFlowID"]);
                omodel.HRemark = Ds.Tables[0].Rows[0]["HRemark"].ToString().Trim();
                omodel.HBackDate = Ds.Tables[0].Rows[0]["HBackDate"].ToString().Trim();
                omodel.HBacker = Ds.Tables[0].Rows[0]["HBacker"].ToString().Trim();
                omodel.HCheckDate = Ds.Tables[0].Rows[0]["HCheckDate"].ToString().Trim();
                omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim();
                omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim();
                omodel.HMakeDate = Ds.Tables[0].Rows[0]["HMakeDate"].ToString().Trim();
                omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim();
                omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim();
                omodel.HCloseDate = Ds.Tables[0].Rows[0]["HCloseDate"].ToString().Trim();
                omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim();
                omodel.HCloseType = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCloseType"]);
                omodel.HDeleteDate = Ds.Tables[0].Rows[0]["HDeleteDate"].ToString().Trim();
                omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim();
                omodel.HMainSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMainSourceBillType"]);
                omodel.HMainSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceInterID"]);
                //========================================================
                omodel.HMainSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceEntryID"]);
                omodel.HMainSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMainSourceBillNo"]);
                omodel.HPrintQty = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HPrintQty"]);
                omodel.HItemMainID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemMainID"]);
                omodel.HOrgID = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HOrgID"]);
                omodel.HIP = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HIP"]);
                omodel.HPassword = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HPassword"]);
                omodel.HWeb = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HWeb"]);
                omodel.HDataBaseIP = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDataBaseIP"]);
                omodel.HSunflower = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSunflower"]);
                omodel.HPrintQty = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[0]["HPrintQty"]);
                //

                //循环
                DataSet DsSub ;
                DsSub = oCn.RunProcReturn("Select * from PM_CustomerProInfoBillSub Where HInterID=" + lngBillKey.ToString(), "PM_CustomerProInfoBillSub ");
                DetailColl.Clear();//清空
                for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
                {
                    Model.ClsPM_CustomerProInfoBillSub oSub = new Model.ClsPM_CustomerProInfoBillSub();
                    // 固定赋值===============================================
                    oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HInterID"]);
                    oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HEntryID"]);
                    oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceInterID"]);
                    oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSourceEntryID"]);
                    oSub.HSourceBillType = DsSub.Tables[0].Rows[i]["HSourceBillType"].ToString().Trim();
                    oSub.HSourceBillNo = DsSub.Tables[0].Rows[i]["HSourceBillNo"].ToString().Trim();
                    oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationQty"]);
                    oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HRelationMoney"]); 
                    oSub.HCloseMan =  DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HCloseMan"]);
                    oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[i]["HCloseType"]);
                    oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HEntryCloseDate"]);
                    oSub.HRemark = DsSub.Tables[0].Rows[i]["HRemark"].ToString().Trim();
                    //===================================================
                    oSub.HBillNo_bak = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HBillNo_bak"]);
                    oSub.HItemSubID = DBUtility.ClsPub.isInt(DsSub.Tables[0].Rows[i]["HItemSubID"]);
                    //===================================================
                    DetailColl.Add(oSub);
                }
                sReturn = "显示单据成功！";
                return true;
            }
            catch (Exception e)
            {
                sReturn = e.Message;
                throw (e);
            }
        }

     
    }

}