using System; using System.Collections.Generic; using System.Text; using System.Data; namespace DAL { public class ClsA3_SeOrderBill:DBUtility.ClsXt_BaseBill { public Model.ClsA3_SeOrderBillMain omodel = new Model.ClsA3_SeOrderBillMain(); public List DetailColl = new List(); public ClsA3_SeOrderBill() { base.MvarItemKeySub = " "; base.MvarItemKeySub2 = ""; base.MvarItemKeySub3 = ""; base.MvarItemKeySub4 = ""; base.MvarItemKey=" "; base.MvarReportTitle="销售订单"; base.BillType="1401"; base.HBillSubType = "1401"; } #region 固定代码 ~ClsA3_SeOrderBill() { DetailColl = null; } #endregion 自定义方法 //显示单据 public bool ShowBill(string lngBillKey, ref string sReturn) { try { //查询主表 DataSet Ds; Ds = oCn.RunProcReturn("Select top 1 * from h_v_Xs_SeOrderBillList_A3 Where HMainID='" + lngBillKey + "'", "h_v_Xs_SeOrderBillList_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.HInnerBillNo = Ds.Tables[0].Rows[0]["内部编号"].ToString().Trim(); omodel.HRemark = Ds.Tables[0].Rows[0]["表头备注"].ToString().Trim(); //======================================================== omodel.HAddress = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["交货地址"]); omodel.HSSID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HSSID"]); omodel.HCusID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["客户代码"]); omodel.HCurID = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["币别代码"]); omodel.HExRate = DBUtility.ClsPub.isSingle(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"]); // Ds = oCn.RunProcReturn("Select top 1 * from A3_SeOrderBill_CheckExtend Where HBillNo='" + lngBillKey + "'", "A3_SeOrderBill_CheckExtend"); if (Ds.Tables[0].Rows.Count != 0) { omodel.HCheckerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HItemID"]); omodel.HManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HManager"]); omodel.HManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HManagerNote"]); omodel.HFstManager = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HFstManager"]); omodel.HFstManagerNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HFstManagerNote"]); omodel.HProdMan = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdMan"]); omodel.HProdManNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdManNote"]); omodel.HLstRequester = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLstRequester"]); omodel.HLstRequesterNote = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HLstRequesterNote"]); omodel.HRequesterSign = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HRequesterSign"]); omodel.HProdManSign = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HProdManSign"]); 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.HManager = ""; omodel.HManagerNote = ""; omodel.HFstManager = ""; omodel.HFstManagerNote = ""; omodel.HProdMan = ""; omodel.HProdManNote = ""; omodel.HLstRequester = ""; omodel.HLstRequesterNote = ""; omodel.HRequesterSign = ""; omodel.HProdManSign = ""; omodel.HLstManager = ""; omodel.HLstManagerNote = ""; } //循环 DataSet DsSub ; DsSub = oCn.RunProcReturn("Select * from h_v_Xs_SeOrderBillList_A3 Where HMainID='" + lngBillKey.ToString() + " order by HEntryID ", "h_v_Xs_SeOrderBillList_A3"); DetailColl.Clear();//清空 for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++) { Model.ClsA3_SeOrderBillSub oSub = new Model.ClsA3_SeOrderBillSub(); // 固定赋值=============================================== 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.HPrice = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["单价"]); oSub.HMoney = DBUtility.ClsPub.isDoule(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.HColor = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["颜色"]); oSub.HLastCL = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["后处理方式"]); oSub.HSumMQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["总米数"]); oSub.HColor = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["颜色"]); oSub.HLastCL = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["后处理方式"]); oSub.HUnitWeight = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["米重"]); oSub.HGuiGe = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["规格"]); oSub.HPieceQty = 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); } } } }