using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace SCM
|
{
|
public class ClsJIT_CallGoodsBill_CLD:DBUtility.ClsXt_BaseBill
|
{
|
public WMSWeb.ClsJIT_CallGoodsBillMain_CLD omodel = new WMSWeb.ClsJIT_CallGoodsBillMain_CLD();
|
public List<WMSWeb.ClsJIT_CallGoodsBillSub_CLD> DetailColl = new List<WMSWeb.ClsJIT_CallGoodsBillSub_CLD>();
|
|
public SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
|
public ClsJIT_CallGoodsBill_CLD()
|
{
|
//base.MvarItemKeyForWeb = "h_v_Xs_SeOrderBillMain_ForWeb"; //需要修改
|
//base.MvarItemKeySubForWeb = "h_v_Xs_SeOrderBillSub_ForWeb";
|
base.MvarItemKeySub = "JIT_CallGoodsBillSub";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey = "JIT_CallGoodsBillMain";
|
base.MvarReportTitle="叫料单";
|
base.BillType="4601";
|
base.HBillSubType = "4601";
|
|
}
|
|
#region 固定代码
|
|
~ClsJIT_CallGoodsBill_CLD()
|
{
|
DetailColl = null;
|
}
|
|
#endregion 自定义方法
|
//修改单据
|
//public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
|
//{
|
// try
|
// {
|
// //
|
// oCn.BeginTran();
|
// //更新主表
|
// oCn.RunProc("UpDate JIT_ComplementGoodsBillMain set " +
|
// " HBillNo='" + omodel.HBillNo + "'" + //固定赋值===============
|
// ",HDate='" + omodel.HDate + "'" +
|
// ",HYear='" + omodel.HYear.ToString() + "'" +
|
// ",HPeriod='" + omodel.HPeriod.ToString() + "'" +
|
// ",HRemark='" + omodel.HRemark + "'" +
|
// ",HUpDater='" + DBUtility.ClsPub.CurUserName + "'" +
|
// ",HUpDateDate=getdate()" +
|
// //========================================
|
// ",HCallManID=" + omodel.HCallManID.ToString() +
|
// ",HSendManID=" + omodel.HSendManID.ToString() +
|
// ",HWareManID=" + omodel.HWareManID.ToString() +
|
// ",HCallType='" + omodel.HCallType.ToString() + "'" +
|
// //",HCurID=" + omodel.HCurID.ToString() +
|
// //",HExRate=" + omodel.HExRate.ToString() +
|
// //",HEmpID=" + omodel.HEmpID.ToString() +
|
// //",HMangerID=" + omodel.HMangerID.ToString() +
|
// //",HDeptID=" + omodel.HDeptID.ToString() +
|
// //",HExplanation='" + omodel.HExplanation + "'" +
|
// //",HInnerBillNo='" + omodel.HInnerBillNo + "'" +
|
// //",HChangeMan='" + omodel.HChangeMan + "'" +
|
// //",HChangeDate='" + omodel.HChangeDate.ToShortDateString() + "'" +
|
// " where HInterID=" + lngBillKey.ToString());
|
// //删除关联
|
// DeleteRelation(ref sReturn, lngBillKey);
|
// //删除子表
|
// DeleteBillSub(lngBillKey);
|
// //插入子表
|
// omodel.HInterID = lngBillKey;
|
// foreach (Model.ClsJIT_ComplementGoodsBillSub_CLD oSub in DetailColl)
|
// {
|
// oCn.RunProc("Insert into JIT_ComplementGoodsBillSub " +
|
// " (HInterID,HEntryID,HCloseMan,HEntryCloseDate,HCloseType,HRemark" +
|
// ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
|
// ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HICMOInterID,HICMOEntryID,HICMOBillNo" +
|
// ",HDeptID,HMaterID,HQty,HProcID,HWHID,HSPID" +
|
// ") 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.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo.ToString() + "'," + oSub.HICMOInterID.ToString() + "," + oSub.HICMOEntryID.ToString() + ",'" + oSub.HICMOBillNo.ToString() + "'" +
|
// "," + oSub.HDeptID.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HWHID.ToString() + "," + oSub.HSPID.ToString() +
|
// ") ");
|
// }
|
// //
|
// //foreach (Model.ClsJIT_ComplementGoodsBillSub_CLD 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
|
// {
|
// //得到mainid
|
// omodel.HInterID = DBUtility.ClsPub.CreateBillID(BillType, ref DBUtility.ClsPub.sExeReturnInfo);
|
// //若MAINDI重复则重新获取
|
// oCn.BeginTran();
|
// //主表
|
// oCn.RunProc("Insert Into JIT_ComplementGoodsBillMain " +
|
// "(HBillType,HBillSubType,HInterID,HBillNo,HDate" +
|
// ",HYear,HPeriod,HRemark,HMaker,HMakeDate" +
|
// ",HBillStatus,HCheckItemNowID,HCheckItemNextID,HCheckFlowID" +
|
// ",HMainSourceBillType,HMainSourceInterID,HMainSourceEntryID,HMainSourceBillNo" +
|
// ",HBacker,HBackDate,HBackRemark,HChecker,HCheckDate,HUpDater,HUpDateDate " +
|
// ",HCloseMan,HCloseDate,HCloseType,HDeleteMan,HDeleteDate " +
|
// ",HPrintQty,HCallManID,HSendManID,HCallType,HWareManID " +
|
// ") " +
|
// " 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.HBillStatus + "'," + omodel.HCheckItemNowID.ToString() + "," + omodel.HCheckItemNextID.ToString() + ", " + omodel.HCheckFlowID.ToString() +
|
// ",'" + omodel.HMainSourceBillType + "'," + omodel.HMainSourceInterID.ToString() + "," + omodel.HMainSourceEntryID.ToString() + ", '" + omodel.HMainSourceBillNo + "'" +
|
// ",'" + omodel.HBacker + "','" + omodel.HBackDate+ "','" + omodel.HBackRemark + "', '" + omodel.HChecker + "','" + omodel.HCheckDate + "', '" + omodel.HUpDater + "'," + omodel.HUpDateTime.ToShortDateString() +
|
// ",'" + omodel.HCloseMan + "','" + omodel.HCloseDate + "','" + omodel.HCloseType + "', '" + omodel.HDeleteMan + "','" + omodel.HDeleteDate + "'"+
|
// "," + omodel.HPrintQty.ToString() + "," + omodel.HCallManID.ToString() + "," + omodel.HSendManID.ToString() + ",'" + omodel.HCallType + "' ," + omodel.HWareManID.ToString() +
|
// ") ");
|
// //插入子表
|
// foreach (Model.ClsJIT_ComplementGoodsBillSub_CLD oSub in DetailColl)
|
// {
|
// oCn.RunProc("Insert into JIT_ComplementGoodsBillSub " +
|
// " (HInterID,HEntryID,HRemark" +
|
// ",HSourceInterID,HSourceEntryID,HSourceBillNo,HSourceBillType,HRelationQty,HRelationMoney" +
|
// ",HSeOrderInterID,HSeOrderEntryID,HSeOrderBillNo,HICMOInterID,HICMOEntryID,HICMOBillNo" +
|
// ",HDeptID,HMaterID,HQty,HProcID,HWHID,HSPID" +
|
// ") values("
|
// + omodel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + ",'" + oSub.HBillNo_bak + "','" + oSub.HRemark + "'" +
|
// "," + oSub.HSourceInterID.ToString() + "," + oSub.HSourceEntryID.ToString() + ",'" + oSub.HSourceBillNo + "','" + oSub.HSourceBillType + "'," + oSub.HRelationQty.ToString() + "," + oSub.HRelationMoney.ToString() +
|
// "," + oSub.HSeOrderInterID.ToString() + "," + oSub.HSeOrderEntryID.ToString() + ",'" + oSub.HSeOrderBillNo + "'," + oSub.HICMOInterID.ToString() + "," + oSub.HICMOEntryID.ToString() + ",'" + oSub.HICMOBillNo + "'" +
|
// "," + oSub.HDeptID.ToString() + "," + oSub.HMaterID.ToString() + "," + oSub.HQty.ToString() + "," + oSub.HProcID.ToString() + "," + oSub.HWHID.ToString() + ", " + oSub.HSPID.ToString() +
|
// ") ");
|
// }
|
// //
|
// //foreach (Model.ClsJIT_ComplementGoodsBillSub_CLD 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)
|
{
|
oWeb.Url = ClsPub1.WEBSURL;
|
try
|
{
|
//查询主表
|
DataSet Ds ;
|
//if (ClsPub1.HPersonL == 1)
|
//{
|
Ds = oWeb.Get_ICMOBillInfo("Select * from JIT_CallGoodsBillMain Where HInterID=" + lngBillKey.ToString(), "JIT_CallGoodsBillMain", ref DBUtility.ClsPub.sExeReturnInfo);
|
//}
|
//else
|
//{
|
// Ds = oWeb.Get_ICMOBillInfo("Select * from JIT_ComplementGoodsBillMain Where HInterID=" + lngBillKey.ToString(), "JIT_CallGoodsBillMain", ref DBUtility.ClsPub.sExeReturnInfo);
|
//}
|
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 = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HBackDate"]);
|
omodel.HBacker = Ds.Tables[0].Rows[0]["HBacker"].ToString().Trim();
|
omodel.HBackRemark = Ds.Tables[0].Rows[0]["HBackRemark"].ToString().Trim();
|
omodel.HCheckDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCheckDate"]);
|
omodel.HChecker = Ds.Tables[0].Rows[0]["HChecker"].ToString().Trim();
|
omodel.HMaker = Ds.Tables[0].Rows[0]["HMaker"].ToString().Trim();
|
omodel.HMakeDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HMakeDate"]);
|
omodel.HUpDateDate = Ds.Tables[0].Rows[0]["HUpDateDate"].ToString().Trim();
|
omodel.HUpDater = Ds.Tables[0].Rows[0]["HUpDater"].ToString().Trim();
|
omodel.HCloseDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HCloseDate"]);
|
omodel.HCloseMan = Ds.Tables[0].Rows[0]["HCloseMan"].ToString().Trim();
|
omodel.HCloseType = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[0]["HCloseType"]);
|
omodel.HDeleteDate = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[0]["HDeleteDate"]);
|
omodel.HDeleteMan = Ds.Tables[0].Rows[0]["HDeleteMan"].ToString().Trim();
|
omodel.HMainSourceBillType = Ds.Tables[0].Rows[0]["HMainSourceBillType"].ToString().Trim();
|
omodel.HMainSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceInterID"]);
|
omodel.HMainSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HMainSourceEntryID"]);
|
omodel.HMainSourceBillNo = Ds.Tables[0].Rows[0]["HMainSourceBillNo"].ToString().Trim();
|
omodel.HPrintQty = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HPrintQty"]);
|
//========================================================
|
omodel.HCallManID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HCallManID"]);
|
omodel.HSendManID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HSendManID"]);
|
omodel.HWareManID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[0]["HWareManID"]);
|
omodel.HCallType = Ds.Tables[0].Rows[0]["HCallType"].ToString().Trim();
|
//
|
|
//循环
|
DataSet DsSub ;
|
//if (ClsPub1.HPersonL == 1)
|
//{
|
DsSub = oWeb.Get_ICMOBillInfo("Select * from JIT_CallGoodsBillSub Where HInterID=" + lngBillKey.ToString(), "JIT_CallGoodsBillSub", ref DBUtility.ClsPub.sExeReturnInfo);
|
//}
|
//else{
|
// DsSub = oWeb.Get_ICMOBillInfo("Select * from JIT_ComplementGoodsBillSub Where HInterID=" + lngBillKey.ToString(), "JIT_CallGoodsBillSub", ref DBUtility.ClsPub.sExeReturnInfo);
|
//}
|
DetailColl.Clear();//清空
|
for (int i = 0; i < DsSub.Tables[0].Rows.Count; i++)
|
{
|
WMSWeb.ClsJIT_CallGoodsBillSub_CLD oSub = new WMSWeb.ClsJIT_CallGoodsBillSub_CLD();
|
// 固定赋值===============================================
|
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.HSeOrderInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderInterID"]);
|
oSub.HSeOrderEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSeOrderEntryID"]);
|
oSub.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HSeOrderBillNo"]);
|
oSub.HICMOInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HICMOInterID"]);
|
oSub.HICMOEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HICMOEntryID"]);
|
oSub.HICMOBillNo = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HICMOBillNo"]);
|
oSub.HDeptID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HDeptID"]);
|
oSub.HMaterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HMaterID"]);
|
oSub.HQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[i]["HQty"]);
|
oSub.HProcID = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[i]["HProcID"]);
|
oSub.HWHID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HWHID"]);
|
oSub.HSPID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[i]["HSPID"]);
|
DetailColl.Add(oSub);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
|
}
|
|
}
|
