using System;
|
using System.Collections.Generic;
|
using System.Text;
|
using System.Data;
|
|
namespace DAL
|
{
|
public class ClsSc_WorkBillAutoSortBill:DBUtility.ClsXt_BaseBill
|
{
|
public long HRelationInterID;
|
public Model.ClsSc_WorkBillAutoSortBillMain omodel = new Model.ClsSc_WorkBillAutoSortBillMain();
|
public List<Model.ClsSc_WorkBillAutoSortBillMain> MainColl = new List<Model.ClsSc_WorkBillAutoSortBillMain>();
|
public List<Model.ClsSc_WorkBillAutoSortBillMain> Main2Coll = new List<Model.ClsSc_WorkBillAutoSortBillMain>();
|
public List<Model.ClsSc_WorkBillAutoSortBillSub> DetailColl = new List<Model.ClsSc_WorkBillAutoSortBillSub>();
|
public List<Model.ClsSc_WorkBillAutoSortBillMain> MainICMOColl = new List<Model.ClsSc_WorkBillAutoSortBillMain>();
|
|
public ClsSc_WorkBillAutoSortBill()
|
{
|
base.MvarItemKeySub = "Sc_WorkBillAutoSortBillSub";
|
base.MvarItemKeySub2 = "";
|
base.MvarItemKeySub3 = "";
|
base.MvarItemKeySub4 = "";
|
base.MvarItemKey="Sc_WorkBillAutoSortBillMain";
|
base.MvarReportTitle="排程派工单";
|
base.BillType = "3749";
|
base.HBillSubType = " ";
|
|
}
|
|
#region 固定代码
|
|
~ClsSc_WorkBillAutoSortBill()
|
{
|
DetailColl = null;
|
}
|
|
#endregion 自定义方法
|
//修改单据
|
public override bool ModifyBill(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
throw (e);
|
}
|
}
|
//新增单据
|
public bool AddBill(Int64 sDeptID, Int64 HRelationInterID, ref string sReturn)
|
{
|
try
|
{
|
//得到mainid
|
//若MAINDI重复则重新获取
|
Int64 MainID = 0;
|
oCn.BeginTran();
|
//按部门删除
|
//oCn.RunProc("update Sc_ICMOSortBillMain set HDeleteMan='System',HDeleteDate=getdate() where HDeleteMan='' and HDeptID=" + sDeptID.ToString());
|
//
|
foreach (Model.ClsSc_WorkBillAutoSortBillMain oModel in MainColl)
|
{
|
//主表
|
oCn.RunProc("Insert Into Sc_WorkBillAutoSortBillMain " +
|
"(HBillType,HBillSubType,HInterID,HBillNo,HDate,HMaker,HMakeDate" +
|
",HYear,HPeriod,HRemark,HICMOStatus,HDeptID,HDeptNumber" +
|
",HMaterID,HMaterNumber,HSourceID,HSourceNumber" +
|
",HUnitID,HUnitNumber,HWorkerID,HWorkerNumber" +
|
",HGroupID,HGroupNumber,HYX,HWorkQty,HWorkTimes,HReadyQty" +
|
",HPlanBeginDate,HPlanEndDate,HLastBeginDate,HLastEndDate" +
|
",HPlanQty,HProcID,HProdTimes,HRelationQty,HKTQ" +
|
",HOrderNeedQty,HReadyTimes,HSourceInterID,HSourceEntryID" +
|
",HSourceBillNo,HSourceBillType,HICMOInterID,HICMOBillNo" +
|
",HOrderCommitDate,HProcPlanInterID,HProcPlanEntryID,HProcPlanBillNo" +
|
",HSeOrderBillNo,HSeOrderInterID,HSeOrderEntryID,HRelationInterID" +
|
",HSplitPlanQty,HSplitRelationQty,HSplitNO,HLocked,HSourceQty" +
|
",HWorkShopID,HOrderLev" +
|
") " +
|
" values('" + this.BillType + "','" + this.HBillSubType + "'," + oModel.HInterID.ToString() + ",'" + oModel.HBillNo + "','" + oModel.HDate + "','" + DBUtility.ClsPub.CurUserName + "',getdate()" +
|
"," + oModel.HYear.ToString() + "," + oModel.HPeriod.ToString() + ",'" + oModel.HRemark + "'," + oModel.HICMOStatus.ToString() + "," + oModel.HDeptID.ToString() + ",'" + oModel.HDeptNumber + "'" +
|
"," + oModel.HMaterID.ToString() + ",'" + oModel.HMaterNumber + "'," + oModel.HSourceID.ToString() + ",'" + oModel.HSourceNumber + "'" +
|
"," + oModel.HUnitID.ToString() + ",'" + oModel.HUnitNumber + "'," + oModel.HWorkerID.ToString() + ",'" + oModel.HWorkerNumber + "'" +
|
"," + oModel.HGroupID.ToString() + ",'" + oModel.HGroupNumber + "','" + oModel.HYX.ToString() + "'," + oModel.HWorkQty.ToString() + "," + oModel.HWorkTimes.ToString() + "," + oModel.HReadyQty.ToString() +
|
",'" + oModel.HPlanBeginDate.ToShortDateString() + "','" + oModel.HPlanEndDate.ToShortDateString() + "','" + oModel.HLastBeginDate.ToShortDateString() + "','" + oModel.HLastEndDate.ToShortDateString() + "'" +
|
"," + oModel.HPlanQty.ToString() + "," + oModel.HProcID.ToString() + "," + oModel.HProdTimes.ToString() + "," + oModel.HRelationQty.ToString() + "," + Convert.ToString(oModel.HKTQ ? 1 : 0) +
|
"," + oModel.HOrderNeedQty.ToString() + "," + oModel.HReadyTimes.ToString() + "," + oModel.HSourceInterID.ToString() + "," + oModel.HSourceEntryID.ToString() +
|
",'" + oModel.HSourceBillNo + "','" + oModel.HSourceBillType + "'," + oModel.HICMOInterID.ToString() + ",'" + oModel.HICMOBillNo + "'" +
|
",'" + oModel.HOrderCommitDate.ToShortDateString() + "'," + oModel.HProcPlanInterID.ToString() + "," + oModel.HProcPlanEntryID.ToString() + ",'" + oModel.HProcPlanBillNo + "'" +
|
",'" + oModel.HSeOrderBillNo + "'," + oModel.HSeOrderInterID.ToString() + "," + oModel.HSeOrderEntryID.ToString() + "," + HRelationInterID.ToString() +
|
"," + oModel.HSplitPlanQty.ToString() + "," + oModel.HSplitRelationQty.ToString() + ",'" + oModel.HSplitNO + "'," + Convert.ToString(oModel.HLocked ? 1 : 0) + "," + oModel.HSourceQty.ToString() +
|
"," + oModel.HWorkShopID.ToString() + ",'" + DBUtility.ClsPub.isStrNull( oModel.Horderlev) + "'" +
|
") ");
|
MainID = oModel.HInterID;
|
|
//插入子表
|
foreach (Model.ClsSc_WorkBillAutoSortBillSub oSub in DetailColl)
|
{
|
oCn.RunProc("Insert into Sc_WorkBillAutoSortBillSub " +
|
" (HInterID,HEntryID,HLocked,HMasterDate" +
|
",HDate,HQty,HTimes,HUseTimes,HStatusTag" +
|
",HiForeColor,HiBackColor,HRemark,HRelationInterID,HBTimes,HETimes,HInStockDays" +
|
") values("
|
+ oModel.HInterID.ToString() + "," + oSub.HEntryID.ToString() + "," + Convert.ToString(oSub.HLocked ? 1 : 0) + ",'" + oSub.HMasterDate.ToShortDateString() + "'" +
|
",'" + oSub.HDate.ToShortDateString() + "'," + oSub.HQty.ToString() + "," + oSub.HTimes.ToString() + "," + oSub.HUseTimes.ToString() + "," + oSub.HStatusTag.ToString() +
|
"," + oSub.HiForeColor.ToString() + "," + oSub.HiBackColor.ToString() + ",'" + oSub.HRemark + "'," + HRelationInterID.ToString() +",'"+ DBUtility.ClsPub.isDate( oSub.HBTimes) + "','" +DBUtility.ClsPub.isDate( oSub.HETimes)+"',"+ oSub.HInStockDays.ToString() +
|
") ");
|
}
|
}
|
//
|
//
|
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 h_v_Sc_WorkBillAutoSortBillMain Where HDeleteMan='' and HRelationInterID=" + lngBillKey.ToString(), "Sc_WorkBillAutoSortBillMain");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
MainColl.Clear();
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillMain oMain = new Model.ClsSc_WorkBillAutoSortBillMain();
|
//固定赋值===========================================
|
oMain.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HInterID"]);
|
oMain.HBillNo = Ds.Tables[0].Rows[i]["HBillNo"].ToString().Trim();
|
oMain.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HDate"]);
|
oMain.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HYear"]);
|
oMain.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HPeriod"]);
|
oMain.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HCheckItemNowID"]);
|
oMain.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HCheckItemNextID"]);
|
oMain.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HCheckFlowID"]);
|
oMain.HRemark = Ds.Tables[0].Rows[i]["HRemark"].ToString().Trim();
|
oMain.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[i]["HBillStatus"]);
|
oMain.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HBillType"]);
|
oMain.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HBillSubType"]);
|
oMain.HMaker = Ds.Tables[0].Rows[i]["HMaker"].ToString().Trim();
|
oMain.HMakeDate = Ds.Tables[0].Rows[i]["HMakeDate"].ToString().Trim();
|
oMain.HUpDateDate = Ds.Tables[0].Rows[i]["HUpDateDate"].ToString().Trim();
|
oMain.HUpDater = Ds.Tables[0].Rows[i]["HUpDater"].ToString().Trim();
|
oMain.HBackDate = Ds.Tables[0].Rows[i]["HBackDate"].ToString().Trim();
|
oMain.HBacker = Ds.Tables[0].Rows[i]["HBacker"].ToString().Trim();
|
oMain.HCheckDate = Ds.Tables[0].Rows[i]["HCheckDate"].ToString().Trim();
|
oMain.HChecker = Ds.Tables[0].Rows[i]["HChecker"].ToString().Trim();
|
oMain.HCloseDate = Ds.Tables[0].Rows[i]["HCloseDate"].ToString().Trim();
|
oMain.HCloseMan = Ds.Tables[0].Rows[i]["HCloseMan"].ToString().Trim();
|
oMain.HDeleteDate = Ds.Tables[0].Rows[i]["HDeleteDate"].ToString().Trim();
|
oMain.HDeleteMan = Ds.Tables[0].Rows[i]["HDeleteMan"].ToString().Trim();
|
//========================================================
|
//==
|
oMain.HICMOStatus = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOStatus"]);
|
oMain.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HDeptID"]);
|
oMain.HDeptNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HDeptNumber"]);
|
oMain.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HMaterID"]);
|
oMain.HMaterNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HMaterNumber"]);
|
oMain.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSourceID"]);
|
oMain.HSourceNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceNumber"]);
|
oMain.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HUnitID"]);
|
oMain.HUnitNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HUnitNumber"]);
|
oMain.HWorkerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HWorkerID"]);
|
oMain.HWorkerNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HWorkerNumber"]);
|
oMain.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HGroupID"]);
|
oMain.HGroupNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HGroupNumber"]);
|
oMain.HYX = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HYX"]);
|
oMain.HSourceQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HSourceQty"]);
|
oMain.HWorkQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HWorkQty"]);
|
oMain.HWorkTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HWorkTimes"]);
|
oMain.HReadyQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HReadyQty"]);
|
oMain.HPlanBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanBeginDate"]);
|
oMain.HPlanEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanEndDate"]);
|
oMain.HLastBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastBeginDate"]);
|
oMain.HLastEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastEndDate"]);
|
oMain.HPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HPlanQty"]);
|
oMain.HProcID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcID"]);
|
oMain.HProdTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HProdTimes"]);
|
oMain.HRelationQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HRelationQty"]);
|
oMain.HKTQ = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HKTQ"]);
|
oMain.HReadyTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HReadyTimes"]);
|
oMain.HOrderNeedQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HOrderNeedQty"]);
|
oMain.HSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSourceInterID"]);
|
oMain.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSourceEntryID"]);
|
oMain.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillNo"]);
|
oMain.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillType"]);
|
oMain.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOInterID"]);
|
oMain.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HICMOBillNo"]);
|
oMain.HOrderCommitDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HOrderCommitDate"]);
|
oMain.HProcPlanInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcPlanInterID"]);
|
oMain.HProcPlanEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcPlanEntryID"]);
|
oMain.HProcPlanBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HProcPlanBillNo"]);
|
oMain.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSeOrderBillNo"]);
|
oMain.HSeOrderInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSeOrderInterID"]);
|
oMain.HSeOrderEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSeOrderEntryID"]);
|
oMain.HRelationInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HRelationInterID"]);
|
oMain.HSplitPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HSplitPlanQty"]);
|
oMain.HSplitRelationQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HSplitRelationQty"]);
|
oMain.HSplitNO = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSplitNO"]);
|
oMain.HLocked = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HLocked"]);
|
//
|
//if (oMain.HLocked == true) //显示锁定的排程计划
|
//{
|
//循环
|
DataSet DsSub;
|
DsSub = oCn.RunProcReturn("Select * from Sc_WorkBillAutoSortBillSub Where HInterID=" + oMain.HInterID.ToString() + " order by HEntryID ", "Sc_WorkBillAutoSortBillSub");
|
DetailColl.Clear();//清空
|
for (int r = 0; r < DsSub.Tables[0].Rows.Count; r++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillSub oSub = new Model.ClsSc_WorkBillAutoSortBillSub();
|
// 固定赋值===============================================
|
oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HInterID"]);
|
oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HEntryID"]);
|
//oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HSourceInterID"]);
|
//oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HSourceEntryID"]);
|
//oSub.HSourceBillType = DsSub.Tables[0].Rows[r]["HSourceBillType"].ToString().Trim();
|
//oSub.HSourceBillNo = DsSub.Tables[0].Rows[r]["HSourceBillNo"].ToString().Trim();
|
//oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[r]["HRelationQty"]);
|
//oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[r]["HRelationMoney"]);
|
oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[r]["HCloseMan"]);
|
oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HCloseType"]);
|
//oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HEntryCloseDate"]);
|
oSub.HRemark = DsSub.Tables[0].Rows[r]["HRemark"].ToString().Trim();
|
//===================================================
|
oSub.HLocked = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HLocked"]);
|
oSub.HMasterDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HMasterDate"]);
|
oSub.HDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HDate"]);
|
oSub.HQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HQty"]);
|
oSub.HTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HTimes"]);
|
oSub.HUseTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HUseTimes"]);
|
oSub.HStatusTag = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HStatusTag"]);
|
oSub.HiForeColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiForeColor"]);
|
oSub.HiBackColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiBackColor"]);
|
oSub.HRelationInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HRelationInterID"]);
|
DetailColl.Add(oSub);
|
}
|
//}
|
MainColl.Add(oMain);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
//throw (e);
|
}
|
}
|
|
|
//显示单据
|
public bool ShowBillByICMO(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select * from h_v_Sc_WorkBillAutoSortBillMain_ICMO Where HDeleteMan='' and HRelationInterID=" + lngBillKey.ToString(), "h_v_Sc_WorkBillAutoSortBillMain_ICMO");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
MainColl.Clear();
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillMain oMain = new Model.ClsSc_WorkBillAutoSortBillMain();
|
//固定赋值===========================================
|
oMain.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HInterID"]);
|
oMain.HBillNo = Ds.Tables[0].Rows[i]["HBillNo"].ToString().Trim();
|
oMain.HDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HDate"]);
|
oMain.HYear = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HYear"]);
|
oMain.HPeriod = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HPeriod"]);
|
oMain.HCheckItemNowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HCheckItemNowID"]);
|
oMain.HCheckItemNextID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HCheckItemNextID"]);
|
oMain.HCheckFlowID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HCheckFlowID"]);
|
oMain.HRemark = Ds.Tables[0].Rows[i]["HRemark"].ToString().Trim();
|
oMain.HBillStatus = DBUtility.ClsPub.isInt(Ds.Tables[0].Rows[i]["HBillStatus"]);
|
oMain.HBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HBillType"]);
|
oMain.HBillSubType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HBillSubType"]);
|
oMain.HMaker = Ds.Tables[0].Rows[i]["HMaker"].ToString().Trim();
|
oMain.HMakeDate = Ds.Tables[0].Rows[i]["HMakeDate"].ToString().Trim();
|
oMain.HUpDateDate = Ds.Tables[0].Rows[i]["HUpDateDate"].ToString().Trim();
|
oMain.HUpDater = Ds.Tables[0].Rows[i]["HUpDater"].ToString().Trim();
|
oMain.HBackDate = Ds.Tables[0].Rows[i]["HBackDate"].ToString().Trim();
|
oMain.HBacker = Ds.Tables[0].Rows[i]["HBacker"].ToString().Trim();
|
oMain.HCheckDate = Ds.Tables[0].Rows[i]["HCheckDate"].ToString().Trim();
|
oMain.HChecker = Ds.Tables[0].Rows[i]["HChecker"].ToString().Trim();
|
oMain.HCloseDate = Ds.Tables[0].Rows[i]["HCloseDate"].ToString().Trim();
|
oMain.HCloseMan = Ds.Tables[0].Rows[i]["HCloseMan"].ToString().Trim();
|
oMain.HDeleteDate = Ds.Tables[0].Rows[i]["HDeleteDate"].ToString().Trim();
|
oMain.HDeleteMan = Ds.Tables[0].Rows[i]["HDeleteMan"].ToString().Trim();
|
//========================================================
|
//==
|
oMain.HICMOStatus = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOStatus"]);
|
oMain.HDeptID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HDeptID"]);
|
oMain.HDeptNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HDeptNumber"]);
|
oMain.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HMaterID"]);
|
oMain.HMaterNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HMaterNumber"]);
|
oMain.HSourceID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSourceID"]);
|
oMain.HSourceNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceNumber"]);
|
oMain.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HUnitID"]);
|
oMain.HUnitNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HUnitNumber"]);
|
oMain.HWorkerID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HWorkerID"]);
|
oMain.HWorkerNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HWorkerNumber"]);
|
oMain.HGroupID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HGroupID"]);
|
oMain.HGroupNumber = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HGroupNumber"]);
|
oMain.HYX = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HYX"]);
|
oMain.HWorkQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HWorkQty"]);
|
oMain.HWorkTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HWorkTimes"]);
|
oMain.HReadyQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HReadyQty"]);
|
oMain.HPlanBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanBeginDate"]);
|
oMain.HPlanEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanEndDate"]);
|
oMain.HLastBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastBeginDate"]);
|
oMain.HLastEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastEndDate"]);
|
oMain.HPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HPlanQty"]);
|
oMain.HProcID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcID"]);
|
oMain.HProdTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HProdTimes"]);
|
oMain.HRelationQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HRelationQty"]);
|
oMain.HKTQ = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HKTQ"]);
|
oMain.HReadyTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HReadyTimes"]);
|
oMain.HOrderNeedQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HOrderNeedQty"]);
|
oMain.HSourceInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSourceInterID"]);
|
oMain.HSourceEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSourceEntryID"]);
|
oMain.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillNo"]);
|
oMain.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillType"]);
|
oMain.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOInterID"]);
|
oMain.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HICMOBillNo"]);
|
oMain.HOrderCommitDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HOrderCommitDate"]);
|
oMain.HProcPlanInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcPlanInterID"]);
|
oMain.HProcPlanEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HProcPlanEntryID"]);
|
oMain.HProcPlanBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HProcPlanBillNo"]);
|
oMain.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSeOrderBillNo"]);
|
oMain.HSeOrderInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSeOrderInterID"]);
|
oMain.HSeOrderEntryID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HSeOrderEntryID"]);
|
oMain.HRelationInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HRelationInterID"]);
|
oMain.HSplitPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HSplitPlanQty"]);
|
oMain.HSplitRelationQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HSplitRelationQty"]);
|
oMain.HSplitNO = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSplitNO"]);
|
oMain.HLocked = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HLocked"]);
|
//
|
//if (oMain.HLocked == true) //显示锁定的排程计划
|
//{
|
//循环
|
DataSet DsSub;
|
DsSub = oCn.RunProcReturn("Select * from Sc_WorkBillAutoSortBillSub Where HInterID=" + oMain.HInterID.ToString() + " order by hinterid,hentryid", "Sc_WorkBillAutoSortBillSub");
|
DetailColl.Clear();//清空
|
for (int r = 0; r < DsSub.Tables[0].Rows.Count; r++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillSub oSub = new Model.ClsSc_WorkBillAutoSortBillSub();
|
// 固定赋值===============================================
|
oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HInterID"]);
|
oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HEntryID"]);
|
//oSub.HSourceInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HSourceInterID"]);
|
//oSub.HSourceEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HSourceEntryID"]);
|
//oSub.HSourceBillType = DsSub.Tables[0].Rows[r]["HSourceBillType"].ToString().Trim();
|
//oSub.HSourceBillNo = DsSub.Tables[0].Rows[r]["HSourceBillNo"].ToString().Trim();
|
//oSub.HRelationQty = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[r]["HRelationQty"]);
|
//oSub.HRelationMoney = DBUtility.ClsPub.isDoule(DsSub.Tables[0].Rows[r]["HRelationMoney"]);
|
oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[r]["HCloseMan"]);
|
oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HCloseType"]);
|
//oSub.HEntryCloseDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HEntryCloseDate"]);
|
oSub.HRemark = DsSub.Tables[0].Rows[r]["HRemark"].ToString().Trim();
|
//===================================================
|
oSub.HLocked = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HLocked"]);
|
oSub.HMasterDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HMasterDate"]);
|
oSub.HDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HDate"]);
|
oSub.HQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HQty"]);
|
oSub.HTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HTimes"]);
|
oSub.HUseTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HUseTimes"]);
|
oSub.HStatusTag = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HStatusTag"]);
|
oSub.HiForeColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiForeColor"]);
|
oSub.HiBackColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiBackColor"]);
|
oSub.HRelationInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HRelationInterID"]);
|
|
DetailColl.Add(oSub);
|
}
|
//}
|
MainColl.Add(oMain);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
throw (e);
|
}
|
}
|
|
//显示单据 工序排程
|
public bool ShowBillByProc(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select distinct hicmointerid,hicmobillno,hmaterid,hunitid,hplanqty,hprodtimes,HYX,hreadyqty,hplanbegindate,hplanenddate,hlastbegindate,hlastenddate ,hseorderbillno,HOrderCommitDate,HSourceBillNo,HSourceBillType,HLocked,HRemark,HHangUp,Horderlev,FKFQty HOrderNeedQty,HWorkShopID from h_v_Sc_WorkBillAutoSortBillMain Where HDeleteMan='' and HRelationInterID=" + lngBillKey.ToString(), "h_v_Sc_WorkBillAutoSortBillMain");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
MainColl.Clear();
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillMain oMain = new Model.ClsSc_WorkBillAutoSortBillMain();
|
//固定赋值===========================================
|
//oMain.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HInterID"]);
|
oMain.HRemark = Ds.Tables[0].Rows[i]["HRemark"].ToString().Trim();
|
oMain.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HMaterID"]);
|
oMain.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HUnitID"]);
|
oMain.HYX = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HYX"]);
|
oMain.HReadyQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HReadyQty"]);
|
oMain.HPlanBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanBeginDate"]);
|
oMain.HPlanEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanEndDate"]);
|
oMain.HLastBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastBeginDate"]);
|
oMain.HLastEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastEndDate"]);
|
oMain.HPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HPlanQty"]);
|
oMain.HProdTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HProdTimes"]);
|
oMain.HOrderNeedQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HOrderNeedQty"]);
|
oMain.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillNo"]);
|
oMain.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillType"]);
|
oMain.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HICMOBillNo"]);
|
oMain.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOInterID"]);
|
oMain.HOrderCommitDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HOrderCommitDate"]);
|
oMain.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSeOrderBillNo"]);
|
oMain.HLocked = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HLocked"]);
|
oMain.HHangUp = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HHangUp"]);
|
oMain.Horderlev = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["Horderlev"]);
|
oMain.HWorkShopID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HWorkShopID"]);
|
//
|
//if (oMain.HLocked == true) //显示锁定的排程计划
|
//{
|
|
//}
|
MainColl.Add(oMain);
|
}
|
//查询主表数据
|
DataSet DsMain;
|
DsMain = oCn.RunProcReturn("Select HProcPlanInterID,HProcPlanEntryID,HWorkQty,HProcID,HSourceID,hinterid,hicmointerid,hicmobillno,hmaterid,hunitid,hplanqty,hprodtimes,HYX,hreadyqty,hplanbegindate,hplanenddate,hlastbegindate,hlastenddate ,hseorderbillno,HOrderCommitDate,HSourceBillNo,HSourceBillType,HLocked,HRemark,HHangUp,Horderlev,FKFQty HOrderNeedQty,HWorkShopID from h_v_Sc_WorkBillAutoSortBillMain Where HDeleteMan='' and HRelationInterID=" + lngBillKey.ToString(), "h_v_Sc_WorkBillAutoSortBillMain");
|
if (DsMain.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
Main2Coll.Clear();
|
for (int i = 0; i < DsMain.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillMain oMain2 = new Model.ClsSc_WorkBillAutoSortBillMain();
|
//固定赋值===========================================
|
oMain2.HInterID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HInterID"]);
|
oMain2.HRemark = DsMain.Tables[0].Rows[i]["HRemark"].ToString().Trim();
|
oMain2.HMaterID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HMaterID"]);
|
oMain2.HUnitID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HUnitID"]);
|
oMain2.HYX = DBUtility.ClsPub.isStrNull(DsMain.Tables[0].Rows[i]["HYX"]);
|
oMain2.HReadyQty = DBUtility.ClsPub.isDoule(DsMain.Tables[0].Rows[i]["HReadyQty"]);
|
oMain2.HPlanBeginDate = DBUtility.ClsPub.isDate(DsMain.Tables[0].Rows[i]["HPlanBeginDate"]);
|
oMain2.HPlanEndDate = DBUtility.ClsPub.isDate(DsMain.Tables[0].Rows[i]["HPlanEndDate"]);
|
oMain2.HLastBeginDate = DBUtility.ClsPub.isDate(DsMain.Tables[0].Rows[i]["HLastBeginDate"]);
|
oMain2.HLastEndDate = DBUtility.ClsPub.isDate(DsMain.Tables[0].Rows[i]["HLastEndDate"]);
|
oMain2.HPlanQty = DBUtility.ClsPub.isDoule(DsMain.Tables[0].Rows[i]["HPlanQty"]);
|
oMain2.HWorkQty = DBUtility.ClsPub.isDoule(DsMain.Tables[0].Rows[i]["HWorkQty"]);
|
oMain2.HProdTimes = DBUtility.ClsPub.isDoule(DsMain.Tables[0].Rows[i]["HProdTimes"]);
|
oMain2.HOrderNeedQty = DBUtility.ClsPub.isDoule(DsMain.Tables[0].Rows[i]["HOrderNeedQty"]);
|
oMain2.HSourceBillNo = DBUtility.ClsPub.isStrNull(DsMain.Tables[0].Rows[i]["HSourceBillNo"]);
|
oMain2.HSourceBillType = DBUtility.ClsPub.isStrNull(DsMain.Tables[0].Rows[i]["HSourceBillType"]);
|
oMain2.HICMOBillNo = DBUtility.ClsPub.isStrNull(DsMain.Tables[0].Rows[i]["HICMOBillNo"]);
|
oMain2.HICMOInterID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HICMOInterID"]);
|
oMain2.HProcPlanInterID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HProcPlanInterID"]);
|
oMain2.HProcPlanEntryID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HProcPlanEntryID"]);
|
oMain2.HOrderCommitDate = DBUtility.ClsPub.isDate(DsMain.Tables[0].Rows[i]["HOrderCommitDate"]);
|
oMain2.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(DsMain.Tables[0].Rows[i]["HSeOrderBillNo"]);
|
oMain2.HLocked = DBUtility.ClsPub.isBool(DsMain.Tables[0].Rows[i]["HLocked"]);
|
oMain2.HHangUp = DBUtility.ClsPub.isBool(DsMain.Tables[0].Rows[i]["HHangUp"]);
|
oMain2.Horderlev = DBUtility.ClsPub.isStrNull(DsMain.Tables[0].Rows[i]["Horderlev"]);
|
oMain2.HProcID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HProcID"]);
|
oMain2.HSourceID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HSourceID"]);
|
oMain2.HWorkShopID = DBUtility.ClsPub.isLong(DsMain.Tables[0].Rows[i]["HWorkShopID"]);
|
//
|
//if (oMain2.HLocked == true) //显示锁定的排程计划
|
//{
|
|
//}
|
Main2Coll.Add(oMain2);
|
}
|
//循环
|
DataSet DsSub;
|
DsSub = oCn.RunProcReturn("Select * from Sc_WorkBillAutoSortBillSub Where HRelationInterID=" + lngBillKey.ToString() + " order by HInterID,HEntryID ", "Sc_WorkBillAutoSortBillSub");
|
DetailColl.Clear();//清空
|
for (int r = 0; r < DsSub.Tables[0].Rows.Count; r++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillSub oSub = new Model.ClsSc_WorkBillAutoSortBillSub();
|
// 固定赋值===============================================
|
oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HInterID"]);
|
oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HEntryID"]);
|
oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[r]["HCloseMan"]);
|
oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HCloseType"]);
|
oSub.HRemark = DsSub.Tables[0].Rows[r]["HRemark"].ToString().Trim();
|
//===================================================
|
oSub.HLocked = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HLocked"]);
|
oSub.HMasterDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HMasterDate"]);
|
oSub.HDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HDate"]);
|
oSub.HBTimes = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HBTimes"]);
|
oSub.HETimes = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HETimes"]);
|
oSub.HQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HQty"]);
|
oSub.HTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HTimes"]);
|
oSub.HUseTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HUseTimes"]);
|
oSub.HStatusTag = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HStatusTag"]);
|
oSub.HiForeColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiForeColor"]);
|
oSub.HiBackColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiBackColor"]);
|
oSub.HRelationInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HRelationInterID"]);
|
DetailColl.Add(oSub);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
|
//显示单据 工序排程
|
public bool ShowBillByProc_t(Int64 lngBillKey, ref string sReturn)
|
{
|
try
|
{
|
//查询主表
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select HinterID,hicmointerid,hicmobillno,hmaterid,hunitid,hplanqty,hprodtimes,HYX,hreadyqty,hplanbegindate,hplanenddate,hlastbegindate,hlastenddate,horderneedqty ,hseorderbillno,HOrderCommitDate,HSourceBillNo,HSourceBillType,HLocked,HRemark,HHangUp,Horderlev from h_v_Sc_WorkBillAutoSortBillMain Where HDeleteMan='' and HRelationInterID=" + lngBillKey.ToString(), "Sc_WorkBillAutoSortBillMain");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
sReturn = "单据未找到！";
|
return false;
|
}
|
MainColl.Clear();
|
DetailColl.Clear();//清空
|
for (int i = 0; i < Ds.Tables[0].Rows.Count; i++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillMain oMain = new Model.ClsSc_WorkBillAutoSortBillMain();
|
//固定赋值===========================================
|
oMain.HInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HInterID"]);
|
oMain.HRemark = Ds.Tables[0].Rows[i]["HRemark"].ToString().Trim();
|
oMain.HMaterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HMaterID"]);
|
oMain.HUnitID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HUnitID"]);
|
oMain.HYX = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HYX"]);
|
oMain.HReadyQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HReadyQty"]);
|
oMain.HPlanBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanBeginDate"]);
|
oMain.HPlanEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HPlanEndDate"]);
|
oMain.HLastBeginDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastBeginDate"]);
|
oMain.HLastEndDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HLastEndDate"]);
|
oMain.HPlanQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HPlanQty"]);
|
oMain.HProdTimes = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HProdTimes"]);
|
oMain.HOrderNeedQty = DBUtility.ClsPub.isDoule(Ds.Tables[0].Rows[i]["HOrderNeedQty"]);
|
oMain.HSourceBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillNo"]);
|
oMain.HSourceBillType = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSourceBillType"]);
|
oMain.HICMOBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HICMOBillNo"]);
|
oMain.HICMOInterID = DBUtility.ClsPub.isLong(Ds.Tables[0].Rows[i]["HICMOInterID"]);
|
oMain.HOrderCommitDate = DBUtility.ClsPub.isDate(Ds.Tables[0].Rows[i]["HOrderCommitDate"]);
|
oMain.HSeOrderBillNo = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["HSeOrderBillNo"]);
|
oMain.HLocked = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HLocked"]);
|
oMain.HHangUp = DBUtility.ClsPub.isBool(Ds.Tables[0].Rows[i]["HHangUp"]);
|
oMain.Horderlev = DBUtility.ClsPub.isStrNull(Ds.Tables[0].Rows[i]["Horderlev"]);
|
//
|
//if (oMain.HLocked == true) //显示锁定的排程计划
|
//{
|
//循环
|
DataSet DsSub;
|
DsSub = oCn.RunProcReturn("Select * from Sc_WorkBillAutoSortBillSub Where HInterID=" + oMain.HInterID.ToString() + " order by HMakeDate", "Sc_WorkBillAutoSortBillSub");
|
for (int r = 0; r < DsSub.Tables[0].Rows.Count; r++)
|
{
|
Model.ClsSc_WorkBillAutoSortBillSub oSub = new Model.ClsSc_WorkBillAutoSortBillSub();
|
// 固定赋值===============================================
|
oSub.HInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HInterID"]);
|
oSub.HEntryID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HEntryID"]);
|
oSub.HCloseMan = DBUtility.ClsPub.isStrNull(DsSub.Tables[0].Rows[r]["HCloseMan"]);
|
oSub.HCloseType = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HCloseType"]);
|
oSub.HRemark = DsSub.Tables[0].Rows[r]["HRemark"].ToString().Trim();
|
//===================================================
|
oSub.HLocked = DBUtility.ClsPub.isBool(DsSub.Tables[0].Rows[r]["HLocked"]);
|
oSub.HMasterDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HMasterDate"]);
|
oSub.HDate = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HDate"]);
|
oSub.HBTimes = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HBTimes"]);
|
oSub.HETimes = DBUtility.ClsPub.isDate(DsSub.Tables[0].Rows[r]["HETimes"]);
|
oSub.HQty = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HQty"]);
|
oSub.HTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HTimes"]);
|
oSub.HUseTimes = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HUseTimes"]);
|
oSub.HStatusTag = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HStatusTag"]);
|
oSub.HiForeColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiForeColor"]);
|
oSub.HiBackColor = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HiBackColor"]);
|
oSub.HRelationInterID = DBUtility.ClsPub.isLong(DsSub.Tables[0].Rows[r]["HRelationInterID"]);
|
DetailColl.Add(oSub);
|
}
|
//}
|
MainColl.Add(oMain);
|
}
|
sReturn = "显示单据成功！";
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
return false;
|
}
|
}
|
|
public bool DeleteBillUnlock(Int64 sDeptID)
|
{
|
try
|
{
|
oCn.RunProcReturn("exec h_p_Sc_DeleteWorkAutoBillList '" + DBUtility.ClsPub.CurUserName + "'," + sDeptID.ToString() + ",'" + DBUtility.ClsPub.GetServerDate(0) + "'", "h_p_Sc_DeleteWorkAutoBillList");
|
return true;
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
|
|
//得到该部门HRelationInterID
|
public Int64 GetRelationInterIDByDept(Int64 sDeptID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select isnull(max(HRelationInterID),0) HRelationInterID from Sc_WorkBillAutoSortBillMain Where HDeptID=" + sDeptID + " and Hdeleteman='' ", "Sc_WorkBillAutoSortBillMain");
|
if (DS.Tables[0].Rows.Count == 0)
|
return 0;
|
else
|
{
|
|
return DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HRelationInterID"]);
|
}
|
}
|
catch (Exception e)
|
{
|
return 0;
|
}
|
}
|
|
|
//得到该部门该操作员 HRelationInterID
|
public Int64 GetRelationInterIDByDeptUser(Int64 sDeptID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("Select isnull(max(HRelationInterID),0) HRelationInterID from Sc_WorkBillAutoSortBillMain Where HDeptID=" + sDeptID + " and HMaker='" + DBUtility.ClsPub.CurUserName + "' and Hdeleteman='' ", "Sc_WorkBillAutoSortBillMain");
|
if (DS.Tables[0].Rows.Count == 0)
|
return 0;
|
else
|
{
|
return DBUtility.ClsPub.isLong(DS.Tables[0].Rows[0]["HRelationInterID"]);
|
}
|
}
|
catch (Exception e)
|
{
|
return 0;
|
}
|
}
|
|
|
|
//设置本行 资源 ，拆分汇报数量
|
public bool GetSourceRelationQty(Int64 ICMOInterID, Int64 sSourceID, ref Single RelationQty, ref Single SplitRelationQty)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_Sc_SetSourceStockInQty " + ICMOInterID.ToString() + "," + sSourceID.ToString(), "xt_xtgnb");
|
if (DS.Tables[0].Rows.Count == 0)
|
{
|
RelationQty = 0;
|
SplitRelationQty = 0;
|
return false;
|
}
|
else
|
{
|
RelationQty = DBUtility.ClsPub.isSingle(DS.Tables[0].Rows[0]["RelationQty"]);
|
SplitRelationQty = DBUtility.ClsPub.isSingle(DS.Tables[0].Rows[0]["SplitRelationQty"]);
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
RelationQty = 0;
|
SplitRelationQty = 0;
|
return false;
|
}
|
}
|
|
//设置本行 资源 产能，拆分汇报数量
|
public Single GetSourceWorkQty(Int64 sMaterID, Int64 sProcID, Int64 sSourceID)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_Sc_SetSourceWorkQty " + sMaterID.ToString() + "," + sProcID.ToString() + "," + sSourceID.ToString(), "xt_xtgnb");
|
if (DS.Tables[0].Rows.Count == 0)
|
return 0;
|
else
|
{
|
return DBUtility.ClsPub.isSingle(DS.Tables[0].Rows[0]["HWorkQty"]);
|
}
|
}
|
catch (Exception e)
|
{
|
return 0;
|
}
|
}
|
|
//设置本行 资源 产能
|
public Single GetSourceWorkQty(Int64 sMaterID, Int64 sProcID, Int64 sSourceID,bool IsNew)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_Sc_SetSourceWorkQty_New " + sMaterID.ToString() + "," + sProcID.ToString() + "," + sSourceID.ToString(), "xt_xtgnb");
|
if (DS.Tables[0].Rows.Count == 0)
|
return 0;
|
else
|
{
|
return DBUtility.ClsPub.isSingle(DS.Tables[0].Rows[0]["HWorkQty"]);
|
}
|
}
|
catch (Exception e)
|
{
|
return 0;
|
}
|
}
|
|
//设置本行 资源 产能
|
public Single GetLineSourceWorkQty(Int64 sMaterID, Int64 sProcID, Int64 sSourceID, bool IsNew)
|
{
|
DataSet DS;
|
try
|
{
|
DS = oCn.RunProcReturn("exec h_p_Sc_SetLineSourceWorkQty_New " + sMaterID.ToString() + "," + sProcID.ToString() + "," + sSourceID.ToString(), "xt_xtgnb");
|
if (DS.Tables[0].Rows.Count == 0)
|
return 0;
|
else
|
{
|
return DBUtility.ClsPub.isSingle(DS.Tables[0].Rows[0]["HWorkQty"]);
|
}
|
}
|
catch (Exception e)
|
{
|
return 0;
|
}
|
}
|
|
//根据信息 设置---是否缺料，确认时间
|
public bool Sub_SetStatusByInfo(Int64 lSourceID, Int64 lSourceInterID, DateTime dDate, Int64 HStatus, ref string sReturn)
|
{
|
try
|
{
|
oCn.BeginTran();
|
//
|
oCn.RunProc("exec h_p_Sc_SetICMOStatus_ReadyMater " + lSourceID.ToString() + "," + lSourceInterID.ToString() + ",'" + dDate.ToShortDateString() + "'," + HStatus.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'");
|
//
|
oCn.Commit();
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
return false;
|
}
|
}
|
|
//根据信息 设置 计划执行
|
public bool Sub_SetStartByInfo(Int64 lSourceID, Int64 lSourceInterID, DateTime dDate, Int64 HStatus, ref string sReturn)
|
{
|
try
|
{
|
oCn.BeginTran();
|
//
|
oCn.RunProc("exec h_p_Sc_SetICMOStatus_ReadyStart " + lSourceID.ToString() + "," + lSourceInterID.ToString() + ",'" + dDate.ToShortDateString() + "'," + HStatus.ToString() + ",'" + DBUtility.ClsPub.CurUserName + "'");
|
//
|
oCn.Commit();
|
//
|
return true;
|
}
|
catch (Exception e)
|
{
|
sReturn = e.Message;
|
oCn.RollBack();
|
return false;
|
}
|
}
|
|
//挂起本任务单
|
public bool SetICMOBill_HangUp(Int64 HICMOInterID)
|
{
|
DataSet DS;
|
try
|
{
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select * from Sc_WorkBillAutoSortBillMain Where hicmointerid=" + HICMOInterID.ToString(), "Sc_WorkBillAutoSortBillMain");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
else
|
{
|
oCn.RunProcReturn("update Sc_WorkBillAutoSortBillMain set HHangUp=1 Where hicmointerid=" + HICMOInterID.ToString(), "Sc_WorkBillAutoSortBillMain");
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
|
//反挂起本任务单
|
public bool SetICMOBill_UnHangUp(Int64 HICMOInterID)
|
{
|
DataSet DS;
|
try
|
{
|
DataSet Ds;
|
Ds = oCn.RunProcReturn("Select * from Sc_WorkBillAutoSortBillMain Where HHangUp=1 and hicmointerid=" + HICMOInterID.ToString(), "Sc_WorkBillAutoSortBillMain");
|
if (Ds.Tables[0].Rows.Count == 0)
|
{
|
return false;
|
}
|
else
|
{
|
oCn.RunProcReturn("update Sc_WorkBillAutoSortBillMain set HHangUp=0 Where hicmointerid=" + HICMOInterID.ToString(), "Sc_WorkBillAutoSortBillMain");
|
return true;
|
}
|
}
|
catch (Exception e)
|
{
|
return false;
|
}
|
}
|
|
|
|
}
|
}
|
