/// <summary>
/// 修改模式
/// </summary>
/// <param name="data"></param>
public Page_ProductionManagement_OutsideProcessBatch(Model_BatchInputOrder data, bool LockProcessors)
{
this.Is_LockProcessors = LockProcessors;
this.OrderData = data;
this.OrderIndex = Helper.DataDefinition.CommonParameters.OrderNoList.IndexOf(OrderData);
this.IS_MODIFY = true;
this.IsOUT = (data.OrderType == "0") ? true : false;
InitializeComponent();
InitializeDataGrid();
InitializeButton();
if (IsOUT)
{
this.DataGridTextColumn_MinorInjuries.Visibility = System.Windows.Visibility.Collapsed;
this.DataGridTextColumn_Injuries.Visibility = System.Windows.Visibility.Collapsed;
this.DataGridTextColumn_Lose.Visibility = System.Windows.Visibility.Collapsed;
this.Label_Title.Content = "外加工单：抛光领货";
}
else
{
this.Label_Title.Content = "外加工单：抛光交货";
}
this.DatePicker_InsertDate.SelectedDate = Convert.ToDateTime(data.Date);
this.TextBox_Number.Text = data.Number;
this.TextBox_Remark.Text = data.Remark;
this.Button_Commit.Content = "修改";
this.TextBox_Processors.Focus();
this.CheckBox_LockProcessors.IsChecked = this.Is_LockProcessors;
}
/// <summary>
/// DataGrid RightKey Modify Click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void MenuItem_Modify_Click(object sender, RoutedEventArgs e)
{
if (this.DataGrid_BatchHistory.SelectedCells.Count > 0)
{
Model_BatchInputOrder m = this.DataGrid_BatchHistory.SelectedCells[0].Item as Model_BatchInputOrder;
if (OrderType == 1)//流水线
{
Helper.Events.PopUpEvent.OnShowPopUp(new Content_ProductionManagement.Page_ProductionManagement_AssemblyLineModuleBatchInput(m));
}
else if (OrderType == 2)//外加工
{
if ((bool)this.CheckBox_LockProcessors.IsChecked)
{
Helper.Events.PopUpEvent.OnShowPopUp(new Content_ProductionManagement.Page_ProductionManagement_OutsideProcessBatch(m, true));
}
else
{
Helper.Events.PopUpEvent.OnShowPopUp(new Content_ProductionManagement.Page_ProductionManagement_OutsideProcessBatch(m, false));
}
}
else if (OrderType == 3)//仓库
{
Helper.Events.PopUpEvent.OnShowPopUp(new Page_Warehouse_Product_BatchIn(m));
}
}
}
public Page_Warehouse_Product_BatchIn(Model_BatchInputOrder Order)
{
this.ORDER = Order;
IS_MODIFY = true;
InitializeComponent();
this.TYPE = int.Parse(Order.OrderType);
this.DatePicker_InsertDate.SelectedDate = Convert.ToDateTime(Order.Date);
this.TextBox_Number.Text = Order.Number;
this.TextBox_Remark.Text = Order.Remark;
this.Button_Commit.Content = "修改";
InitializeDataGrid();
switch (TYPE)
{
case 0:
this.Label_Title.Content = "入库：包装产品";
break;
case 1:
this.Label_Title.Content = "入库：散件产品";
break;
case 2:
this.Label_Title.Content = "出库：包装产品";
break;
case 3:
this.Label_Title.Content = "出库：散件产品";
break;
}
}
public Page_ProductionManagement_AssemblyLineModuleBatchInput(Model_BatchInputOrder data)
{
this.OrderData = data;
this.IS_MODIFY = true;
InitializeComponent();
InitializeDataGrid();
this.TextBox_Number.Text = data.Number;
this.TextBox_Remark.Text = data.Remark;
this.Button_Commit.Content = "修改";
}
internal void ReadOrder(int BacthType, out ObservableCollection <Model_BatchInputOrder> data, int OrderType)
{
data = new ObservableCollection <Model_BatchInputOrder>();
Model_BatchInputOrder m;
DataSet ds = new DataSet();
string TableName = GetTableName(BacthType);
string sql = "select * from " + TableName + " WHERE DeleteMark ISNULL Order By rowid Desc";
if (BacthType == 3 && OrderType > 0)
{
sql = "select * from " + TableName + " WHERE DeleteMark ISNULL AND OrderType='" + (OrderType - 1) + "' Order By rowid Desc";
}
else if (BacthType == 2)//外加工需读取加工商名字
{
string OrderTypeWhereParm = "";
if (OrderType > 0)
{
OrderTypeWhereParm = " AND a.OrderType='" + (OrderType - 1) + "'";
}
sql = "select a.*,b.Name as PName "
+ " from " + TableName + " a "
+ " Left join T_UserInfo_Processors b ON a.ProcessorsID=b.Guid"
+ " WHERE a.DeleteMark ISNULL " + OrderTypeWhereParm + " Order By a.rowid Desc";
}
if (new DBHelper().QueryData(sql, out ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m = new Model_BatchInputOrder();
m.Guid = (Guid)dr["Guid"];
m.Number = dr["Number"].ToString();
m.Name = dr["Name"].ToString();
m.Date = Convert.ToDateTime(dr["Date"].ToString()).ToString("yyyy-MM-dd");
m.Remark = dr["Remark"].ToString();
if (BacthType != 1)
{
m.OrderType = dr["OrderType"].ToString();
}
if (BacthType == 2)
{
m.ProcessorsID = (Guid)dr["ProcessorsID"];
m.ProcessorsName = dr["PName"].ToString();
}
data.Add(m);
}
}
}
/// <summary>
/// 下一单
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Button_NextOrder_Click(object sender, RoutedEventArgs e)
{
int i = 1;
Model_BatchInputOrder NextOrder = Helper.DataDefinition.CommonParameters.OrderNoList[OrderIndex + i];
if (Is_LockProcessors)
{
while (NextOrder.ProcessorsID != this.ProcessorsGuid)
{
i++;
if (OrderIndex + i >= Helper.DataDefinition.CommonParameters.OrderNoList.Count)
{
MessageBox.Show("已到最后一单", "提示");
return;
}
NextOrder = Helper.DataDefinition.CommonParameters.OrderNoList[OrderIndex + i];
}
}
Helper.Events.PopUpEvent.OnShowPopUp(new Page_ProductionManagement_OutsideProcessBatch(NextOrder, Is_LockProcessors));
}
/// <summary>
/// 编辑时读取记录明细
/// </summary>
/// <returns></returns>
internal ObservableCollection <Model_AssemblyLineModuleBatchInput> ReadDatas(Model_BatchInputOrder OrderData)
{
ObservableCollection <Model_AssemblyLineModuleBatchInput> data = new ObservableCollection <Model_AssemblyLineModuleBatchInput>();
Model_AssemblyLineModuleBatchInput m;
DataSet ds = new DataSet();
string sql = "Select a.*,"
+ " p.Guid as PGuid,p.Number as PNumber,p.Name as PName,p.P1,p.P2,p.P3,p.P4,p.P5,p.P6, "
+ " s.Guid as SGuid,s.Number as SNumber,s.Name as SName "
+ " from T_PM_ProductionSchedule a "
+ " left join T_ProductInfo_Product p ON a.ProductID=p.Guid "
+ " left join T_UserInfo_Staff s ON a.StaffID=s.Guid "
+ " WHERE a.Obligate1='" + OrderData.Guid + "' "
+ " AND a.DeleteMark ISNULL "
+ " AND a.Remark<>'自动扣半成品原料' "
;
if (new Helper.SQLite.DBHelper().QueryData(sql, out ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m = new Model_AssemblyLineModuleBatchInput();
//Product Info
m.ProductGuid = (Guid)dr["PGuid"];
m.ProductNumber = dr["PNumber"].ToString();
m.ProductName = dr["PName"].ToString();
for (int i = 0; i < 6; i++)
{
if (dr["P" + (i + 1)].ToString() != "无")
{
m.ProcessList[i] = dr["P" + (i + 1)].ToString();
m.ProcessListStr += dr["P" + (i + 1)].ToString() + ",";
}
}
m.ProcessListStr = m.ProcessListStr.Substring(0, m.ProcessListStr.Length - 1);
//Staff Info
m.StaffGuid = (Guid)dr["SGuid"];
m.StaffNumber = dr["SNumber"].ToString();
m.StaffName = dr["SName"].ToString();
//Input Info
m.Process = dr["Process"].ToString();
m.Quantity = int.Parse(dr["Number"].ToString());
m.Injure = int.Parse(dr["Break"].ToString());
data.Add(m);
}
}
if (data.Count < 20)
{
int COUNT = data.Count;
for (int i = 0; i < 20 - COUNT; i++)
{
data.Add(new Model_AssemblyLineModuleBatchInput {
Id = i + 1
});
}
}
return(data);
}
/// <summary>
/// 编辑时读取记录明细
/// </summary>
/// <returns></returns>
internal ObservableCollection <Model_ProductionManagement_OutsideProcessBatch> ReadDatas(Model_BatchInputOrder OrderData)
{
ObservableCollection <Model_ProductionManagement_OutsideProcessBatch> data = new ObservableCollection <Model_ProductionManagement_OutsideProcessBatch>();
Model_ProductionManagement_OutsideProcessBatch m;
DataSet ds = new DataSet();
string sql = "Select a.*, "
+ " b.Guid as PDGuid,b.Number as PDNumber,b.Name as PDName,b.Material, "
+ " c.Guid as PCGuid,c.Number as PCNumber,c.Name as PCName "
+ " from T_PM_ProcessSchedule a "
+ " Left join T_ProductInfo_Product b ON b.Guid=a.ProductID "
+ " Left Join T_UserInfo_Processors c ON c.Guid=a.ProcessorsID "
+ " WHERE a.Obligate1='" + OrderData.Guid + "' "
//+ " AND a.DeleteMark ISNULL "
//+ " AND a.OrderType='" + ((OrderData.OrderType == "0") ? "出单" : "入单") + "'"
;
if (new Helper.SQLite.DBHelper().QueryData(sql, out ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m = new Model_ProductionManagement_OutsideProcessBatch();
//Product Info
m.ProductGuid = (Guid)dr["PDGuid"];
m.ProductNumber = dr["PDNumber"].ToString();
m.ProductName = dr["PDName"].ToString();
m.Material = dr["Material"].ToString();
//Processors Info
m.ProcessorsGuid = (Guid)dr["PCGuid"];
m.ProcessorsNumber = dr["PCNumber"].ToString();
m.ProcessorsName = dr["PCName"].ToString();
//Input Info
m.Quantity = int.Parse(dr["Quantity"].ToString());
m.MinorInjuries = int.Parse(dr["MinorInjuries"].ToString());
m.Injuries = int.Parse(dr["Injuries"].ToString());
m.Lose = int.Parse(dr["Lose"].ToString());
m.Remark = dr["Remark"].ToString();
data.Add(m);
}
}
if (data.Count < 20)
{
int COUNT = data.Count;
for (int i = 0; i < 20 - COUNT; i++)
{
data.Add(new Model_ProductionManagement_OutsideProcessBatch {
Id = i + 1
});
}
}
return(data);
}