using System;
|
using System.Collections.Generic;
|
using System.ComponentModel;
|
using System.Data;
|
using System.Drawing;
|
using System.Text;
|
using System.Threading;
|
using System.Windows.Forms;
|
|
namespace SCM
|
{
|
public partial class Xs_SeOrderAutoSortBill : Form
|
{
|
public Xs_SeOrderAutoSortBill()
|
{
|
InitializeComponent();
|
}
|
|
|
SCM.WMSWeb.WebService1 oWeb = new SCM.WMSWeb.WebService1();
|
|
private void txtHProcID_TextChanged(object sender, EventArgs e)
|
{
|
|
}
|
|
private void label4_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void yd_Click(object sender, EventArgs e)
|
{
|
Display_UnSort();
|
}
|
|
private void Display_UnSort()
|
{
|
DataSet DSet;
|
string sSql = "";
|
string sWhere = "";
|
//过滤条件
|
sSql = "EXEC h_p_Xs_SeOrderAutoSortBill_UnSort '',0 ";
|
|
//
|
DSet = oWeb.getDataSetBySQL(sSql, "h_p_Xs_SeOrderAutoSortBill_UnSort", ref DBUtility.ClsPub.sExeReturnInfo);
|
//生成首行标题
|
if (DSet == null)
|
{
|
MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//
|
grdSourceBill.DataSource = DSet.Tables[0].DefaultView;
|
|
////设置合计列
|
//string sTotalCol = "";
|
//sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
|
//string[] sT;
|
//sT = sTotalCol.Split(Convert.ToChar(","));
|
//oSumGrid.BuildTotalCols(sT);
|
//冻结
|
int FrCol = 0;
|
string s = "是";
|
ClsPub1.DisplayGrid(grdSourceBill, this.Name, s, FrCol);
|
//画线
|
//GraphLine();
|
//Total();
|
}
|
|
private void Xs_SeOrderAutoSortBill_Load(object sender, EventArgs e)
|
{
|
//设置动态URL
|
oWeb.Url = SCM.ClsPub1.WEBSURL;
|
oWeb.Timeout = 30000;
|
}
|
|
private void pc_Click(object sender, EventArgs e)
|
{
|
//if (CheckSetupData() == false)
|
//{
|
// return;
|
//}
|
if (MessageBox.Show("是否启动裁切排产？", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question) == DialogResult.Cancel)
|
{
|
//this.DateSetup(false);
|
return;
|
}
|
else
|
{
|
this.DateSetup(true);
|
}
|
}
|
|
//排程
|
private bool DateSetup(bool bAuto)
|
{
|
|
//得到一个内码
|
//HRelationInterID = DBUtility.ClsPub.CreateBillID(ModName, ref DBUtility.ClsPub.sExeReturnInfo);
|
//HBillNo = "";
|
//弹出前置非模式窗体，显示进度
|
DBUtility.Xt_ProcessWait oWait = new DBUtility.Xt_ProcessWait();
|
oWait.lblCaption.Text = "正在排产请稍候...";
|
oWait.lblHCount.Text = "";
|
oWait.lblHMaterName.Text = "";
|
oWait.pb1.Maximum = grdSourceBill.RowCount;
|
oWait.pb1.Value = 0;
|
oWait.Show();
|
//grdMain.RowCount = 0;
|
////清空未锁定 排程记录
|
//Sub_DeleteBillUnLock();
|
//按任务单优先级 循环
|
for (int i = 0; i < grdSourceBill.RowCount; i++)
|
{
|
// //如果锁定计划，则不需要再排程
|
// if (DBUtility.ClsPub.isBool(grdSourceBill.Rows[i].Cells[HLockedCol].Value) == true)
|
// {
|
// continue;
|
// }
|
// //找到本任务单 可用生产资源
|
// lMainID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HICMOInterIDCol].Value);
|
// sICMOBillNo = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HICMOBillNoCol].Value);
|
// dEndDate = DBUtility.ClsPub.isDate(grdSourceBill.Rows[i].Cells[HLastEndDateCol].Value);
|
// sProdTimes = DBUtility.ClsPub.isSingle(grdSourceBill.Rows[i].Cells[HProdTimesCol].Value);
|
// sPlanQty = DBUtility.ClsPub.isSingle(grdSourceBill.Rows[i].Cells[HPlanQtyCol].Value);
|
// lHGroupID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HGroupIDCol].Value);
|
// sGroupName = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HGroupNameCol].Value);
|
// lMaterID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HMaterIDCol].Value);
|
// sMaterNumber = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HMaterNumberCol].Value);
|
// sMaterName = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HMaterNameCol].Value);
|
// sMaterModel = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HMaterModelCol].Value);
|
// sWorkQty = DBUtility.ClsPub.isSingle(grdSourceBill.Rows[i].Cells[HWorkQtyCol].Value);
|
// sYX = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HYXCol].Value);
|
// //
|
// if (sICMOBillNo == "WORK155356")
|
// {
|
// sICMOBillNo = sICMOBillNo;
|
// }
|
// //剩余需求工时
|
// iLeftQty = sPlanQty;
|
// if (sWorkQty <= 0)
|
// {
|
// sLeftProdTimes = 0;
|
// }
|
// else
|
// {
|
// sLeftProdTimes = iLeftQty / sWorkQty;
|
// }
|
// //若本任务单已有安排资源（上次排程或者手工排程） 则不再寻找资源，直接排程
|
// if (DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceIDCol].Value) != 0 &&
|
// DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceNameCol].Value) != ""
|
// )
|
// {
|
// //获取该生产资源的剩余工时进行排程。
|
// lSourceID = DBUtility.ClsPub.isLong(grdSourceBill.Rows[i].Cells[HSourceIDCol].Value);
|
// sSourceName = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceNameCol].Value);
|
// sSourceNumber = DBUtility.ClsPub.isStrNull(grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value);
|
// //
|
// ds = Sc_ICMOSortBillFun.GetWorkSourceByICMO(oCn, lMaterID, dEndDate, lSourceID, sLeftProdTimes);
|
// }
|
// else //没有资源则 自动找到资源
|
// {
|
// //
|
// ds = Sc_ICMOSortBillFun.GetWorkSourceByICMO(oCn, lMaterID, dEndDate, sLeftProdTimes);
|
// }
|
// if (ds == null || ds.Tables[0].Rows.Count == 0) //没有可以排的资源
|
// {
|
// //跳到下一单 本单红色显示
|
// grdSourceBill.Rows[i].DefaultCellStyle.BackColor = Color.Brown;
|
// continue;
|
// }
|
// else
|
// {
|
// grdSourceBill.Rows[i].DefaultCellStyle.BackColor = Color.White;
|
// //开始排单
|
// bFind = false;
|
// //超交货期 仍然排程
|
// for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
|
// {
|
// //判断资源剩余工时，是否大于 生产周期
|
// if (DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[j]["剩余工时"]) > sLeftProdTimes)
|
// {
|
// if (iLeftQty > 0)
|
// {
|
// //在本资源上生产
|
// //获取该生产资源的剩余工时进行排程。
|
// lSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[j]["HitemID"]);
|
// sSourceName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["资源名称"]);
|
// sSourceNumber = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["资源代码"]);
|
// grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = lSourceID;
|
// grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = sSourceName;
|
// grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value = sSourceNumber;
|
// dsSub = Sc_ICMOSortBillFun.GetWorkSourceTimeBySource(oCn, lSourceID);
|
// if (dsSub == null || dsSub.Tables[0].Rows.Count == 0)
|
// {
|
// continue;
|
// }
|
// if (dsSub != null)//不加班排程
|
// {
|
// //将数据排到网格中
|
// grdMain.RowCount = grdMain.RowCount + 1; // grdmain 新增一行
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOBillNoCol].Value = sICMOBillNo;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOInterIDCol].Value = lMainID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecLeftQtyCol].Value = iLeftQty;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupIDCol].Value = lHGroupID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupNameCol].Value = sGroupName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterIDCol].Value = lMaterID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNameCol].Value = sMaterName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNumberCol].Value = sMaterNumber;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterModelCol].Value = sMaterModel;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanEndDateCol].Value = dEndDate;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanQtyCol].Value = sPlanQty;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceIDCol].Value = lSourceID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNameCol].Value = sSourceName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNumberCol].Value = sSourceNumber;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecYXCol].Value = sYX;
|
// Sc_ICMOSortBillFun.SetInfoToGrid(grdMain, dsSub, null, grdMain.RowCount - 1, ref iLeftQty, sWorkQty, false, oClsGridValues);
|
// }
|
// bFind = true;
|
// }
|
// }
|
// }
|
// if (!bFind)
|
// {
|
// for (int j = 0; j < ds.Tables[0].Rows.Count; j++)
|
// {
|
// //判断资源最大剩余工时，是否大于 生产周期
|
// if (DBUtility.ClsPub.isSingle(ds.Tables[0].Rows[j]["最大剩余工时"]) > sLeftProdTimes)
|
// {
|
// if (iLeftQty > 0)
|
// {
|
|
// //在本资源上生产
|
// grdMain.RowCount = grdMain.RowCount + 1;
|
// //获取该生产资源的剩余工时进行排程。
|
// lSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[j]["HitemID"]);
|
// sSourceName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["资源名称"]);
|
// sSourceNumber = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[j]["资源代码"]);
|
// grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = lSourceID;
|
// grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = sSourceName;
|
// grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value = sSourceNumber;
|
// dsSub = Sc_ICMOSortBillFun.GetWorkSourceTimeBySource(oCn, lSourceID);
|
// if (dsSub == null || dsSub.Tables[0].Rows.Count == 0)
|
// {
|
// continue;
|
// }
|
// if (dsSub != null)//加班排程
|
// {
|
// //将数据排到网格中
|
// grdMain.RowCount = grdMain.RowCount + 1; // grdmain 新增一行
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOBillNoCol].Value = sICMOBillNo;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOInterIDCol].Value = lMainID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecLeftQtyCol].Value = iLeftQty;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupIDCol].Value = lHGroupID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupNameCol].Value = sGroupName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterIDCol].Value = lMaterID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNameCol].Value = sMaterName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNumberCol].Value = sMaterNumber;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterModelCol].Value = sMaterModel;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanEndDateCol].Value = dEndDate;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanQtyCol].Value = sPlanQty;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceIDCol].Value = lSourceID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNameCol].Value = sSourceName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNumberCol].Value = sSourceNumber;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecYXCol].Value = sYX;
|
// Sc_ICMOSortBillFun.SetInfoToGrid(grdMain, dsSub, null, grdMain.RowCount - 1, ref iLeftQty, sWorkQty, true, oClsGridValues);
|
// }
|
// }
|
// bFind = true;
|
// }
|
// }
|
// }
|
// if (!bFind)
|
// {
|
// //如果没有找到合适资源则，直接排最后一个剩余最大的资源。
|
// //获取该生产资源的剩余工时进行排程。
|
// lSourceID = DBUtility.ClsPub.isLong(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["HitemID"]);
|
// sSourceName = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["资源名称"]);
|
// sSourceNumber = DBUtility.ClsPub.isStrNull(ds.Tables[0].Rows[ds.Tables[0].Rows.Count - 1]["资源代码"]);
|
// grdSourceBill.Rows[i].Cells[HSourceIDCol].Value = lSourceID;
|
// grdSourceBill.Rows[i].Cells[HSourceNameCol].Value = sSourceName;
|
// grdSourceBill.Rows[i].Cells[HSourceNumberCol].Value = sSourceNumber;
|
|
// //获取该生产资源的剩余工时进行排程。
|
// dsSub = Sc_ICMOSortBillFun.GetWorkSourceTimeBySource(oCn, lSourceID);
|
// if (dsSub == null || dsSub.Tables[0].Rows.Count == 0)
|
// {
|
// continue;
|
// }
|
// if (dsSub != null)//加班排程
|
// {
|
// //将数据排到网格中
|
// grdMain.RowCount = grdMain.RowCount + 1; // grdmain 新增一行
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOBillNoCol].Value = sICMOBillNo;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecICMOInterIDCol].Value = lMainID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecLeftQtyCol].Value = iLeftQty;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupIDCol].Value = lHGroupID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecGroupNameCol].Value = sGroupName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterIDCol].Value = lMaterID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNameCol].Value = sMaterName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterNumberCol].Value = sMaterNumber;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecMaterModelCol].Value = sMaterModel;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanEndDateCol].Value = dEndDate;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecPlanQtyCol].Value = sPlanQty;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceIDCol].Value = lSourceID;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNameCol].Value = sSourceName;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecSourceNumberCol].Value = sSourceNumber;
|
// grdMain.Rows[grdMain.RowCount - 1].Cells[HSecYXCol].Value = sYX;
|
// Sc_ICMOSortBillFun.SetInfoToGrid(grdMain, dsSub, null, grdMain.RowCount - 1, ref iLeftQty, sWorkQty, true, oClsGridValues);
|
// }
|
// }
|
// }
|
// //
|
// //保存生成派工单
|
// SaveSingeBill(i, grdMain.RowCount - 1, HRelationInterID, oClsGridValues);
|
//////更新生产订单
|
|
////写入 进度等待框
|
Thread.Sleep(100);
|
Application.DoEvents();
|
oWait.pb1.Value = i + 1;
|
oWait.lblHCount.Text = oWait.pb1.Value.ToString() + "/" + oWait.pb1.Maximum.ToString();
|
oWait.lblHMaterName.Text = "";
|
Application.DoEvents();
|
}
|
oWeb.getRunProc(" EXEC h_p_Xs_SeOrderAutoSortBill_ToSort 1 " , ref DBUtility.ClsPub.sExeReturnInfo);
|
////
|
oWait.Close();
|
Display_Sort();
|
Display_UnSort();
|
return true;
|
}
|
|
private void Display_Sort()
|
{
|
DataSet DSet;
|
string sSql = "";
|
string sWhere = "";
|
//过滤条件
|
sSql = "EXEC h_p_Xs_SeOrderAutoSortBill_Sort '',0 ";
|
|
//
|
DSet = oWeb.getDataSetBySQL(sSql, "h_p_Xs_SeOrderAutoSortBill_Sort", ref DBUtility.ClsPub.sExeReturnInfo);
|
//生成首行标题
|
if (DSet == null)
|
{
|
MessageBox.Show("没有返回任何结果,请在过滤框中点击【恢复】按钮,尝试再次查询！" + DBUtility.ClsPub.sExeReturnInfo);
|
return;
|
}
|
//
|
grdMain.DataSource = DSet.Tables[0].DefaultView;
|
|
////设置合计列
|
//string sTotalCol = "";
|
//sTotalCol = DBUtility.Gy_BaseFun.GetTotalCols(DSet);
|
//string[] sT;
|
//sT = sTotalCol.Split(Convert.ToChar(","));
|
//oSumGrid.BuildTotalCols(sT);
|
//冻结
|
int FrCol = 0;
|
string s = "是";
|
ClsPub1.DisplayGrid(grdMain, this.Name, s, FrCol);
|
//画线
|
//GraphLine();
|
//Total();
|
}
|
|
private void timer1_Tick(object sender, EventArgs e)
|
{
|
timer1.Enabled = false;
|
initGrid();
|
}
|
|
//
|
private void initGrid()
|
{
|
ClsPub1.initGridList(grdMain, this.Name);
|
ClsPub1.initGridList(grdSourceBill, this.Name + "grdSourceBill");
|
ClsPub1.initGridList(grdSourceStatus, this.Name + "grdSourceStatus");
|
grdMain.ReadOnly = true;
|
grdSourceBill.ReadOnly = true;
|
grdSourceStatus.ReadOnly = true;
|
}
|
|
private void tc_Click(object sender, EventArgs e)
|
{
|
this.Close();
|
}
|
|
private void xs_Click(object sender, EventArgs e)
|
{
|
|
}
|
|
private void sx_Click(object sender, EventArgs e)
|
{
|
Display_Sort();
|
Display_UnSort();
|
}
|
|
}
|
}
|
