using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsA3_SellOutBill:DBUtility.ClsXt_BaseBill { public Model.ClsA3_SellOutBillMain omodel = new Model.ClsA3_SellOutBillMain(); public List DetailColl = new List(); public ClsA3_SellOutBill() { base.MvarItemKeySub = " "; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey=" "; base.MvarReportTitle="发货单"; base.BillType="1401"; base.HBillSubType = "1401"; } #region 固定代码 ~ClsA3_SellOutBill() { DetailColl = null; } #endregion 自定义方法 //显示单据 public bool ShowBill(string lngBillKey, ref string sReturn) { try { //查询主表 DataSet Ds; Ds = oCn.RunProcReturn("Select top 1 * from h_v_Kf_SellOutBillList_A3 Where HMainID='" + lngBillKey + "'", "h_v_Kf_SellOutBillList_A3"); 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.isStrNull(Ds.Tables[0].Rows[0]["hmainid"]); omodel.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[0]["日期"]); omodel.HBillNo = Ds.Tables[0].Rows[0]["单据号"].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]["表头备注"].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.HAddress = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["交货地址"]); //omodel.HSSID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSSID"]); //omodel.HSellSID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSellSID"]); omodel.HSupID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["客户代码"]); omodel.HEmpID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["业务员代码"]); //omodel.HMangerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMangerID"]); omodel.HDeptID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["部门代码"]); omodel.HCheckerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCheckerID"]); //omodel.HExplanation = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HExplanation"]); omodel.HInnerBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["内部编号"]); // Ds = oCn.RunProcReturn("Select top 1 * from A3_SellOutBill_CheckExtend Where HBillNo='" + lngBillKey + "'", "A3_SellOutBill_CheckExtend"); if (Ds.Tables[0].Rows.Count != 0) { omodel.HCheckerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]); omodel.HAccManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAccManager"]); omodel.HAccManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HAccManagerNote"]); omodel.HLstManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLstManager"]); omodel.HLstManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLstManagerNote"]); } else { omodel.HCheckerID = 0; omodel.HAccManager = ""; omodel.HAccManagerNote = ""; omodel.HLstManager = ""; omodel.HLstManagerNote = ""; } //循环 DataSet DsSub ; DsSub = oCn.RunProcReturn("Select * from h_v_Kf_SellOutBillList_A3 Where HMainID='" + lngBillKey.ToString() + " order by HEntryID ", "h_v_Kf_SellOutBillList_A3"); DetailColl.Clear();//清空 for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) { Model.ClsA3_SellOutBillSub oSub = new Model.ClsA3_SellOutBillSub(); // 固定赋值=============================================== oSub.HInterID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["hmainid"]); oSub.HEntryID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["hsubid"]); //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]["表体备注"].ToString().Trim(); //=================================================== oSub.HMaterID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["物料代码"]); oSub.HUnitID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["计量单位代码"]); oSub.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["实发数量"]); oSub.HQtyMust = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["应发数量"]); oSub.HPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["单价"]); oSub.HMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["金额"]); oSub.HWHID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["发货仓库代码"]); //oSub.HTaxRate = DBUtility.ClsPub.isSingle(DsSub.Tables[0].Rows[i]["税率"]); //oSub.HTaxMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["税额"]); //oSub.HlineTotal = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HlineTotal"]); //oSub.HlineTotalBB = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HlineTotalBB"]); //oSub.HDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[i]["HDate"]); DetailColl.Add(oSub); } sReturn = "显示单据成功！"; return true; } catch (Exception e) { sReturn = e.Message; throw (e); } } } }