private void MenuItem_HalfProductIn_Click(object sender, RoutedEventArgs e)
{
Model_ProductionBookkeeping m = this.DataGrid_ProductionBookkeeping.SelectedCells[0].Item as Model_ProductionBookkeeping;
if (m.IsTurn != 0)
{
MessageBox.Show("此行数据已经添加到半成品仓库中，请勿重复添加！");
return;
}
else
{
WarehouseHalpProductModel mm = new WarehouseHalpProductModel();
mm.ProductID = m.ProductGuid;
mm.Quantity = m.P4Num;
if (new WarehouseHalfProductConsole().Insert(mm) && new ProductionBookkeepingConsole().UpdateTurn(m))
{
MessageBox.Show("成功添加" + m.ProductName + "到半成品仓库！");
InitializeData();
HalfProductEvent.OnUpdateDataGrid();
}
else
{
MessageBox.Show("添加失败，请联系管理员！");
}
}
}
private void Button_Delete_Click(object sender, RoutedEventArgs e)
{
if (this.DataGrid_ProductionBookkeeping.SelectedCells.Count > 0)
{
if (MessageBox.Show("确认删除记录？", "警告", MessageBoxButton.YesNo) == MessageBoxResult.Yes)
{
Model_ProductionBookkeeping m = this.DataGrid_ProductionBookkeeping.SelectedCells[0].Item as Model_ProductionBookkeeping;
if (new ProductionBookkeepingConsole().Delete(m.Guid))
{
_data.Remove(m);
}
}
}
}
internal bool Update(Model_ProductionBookkeeping m)
{
string sql = "Update T_PM_ProductionBookkeeping Set "
+ " ProductID='" + m.ProductGuid + "', "
+ " P1Num=" + m.P1Num + ", "
+ " P2Num=" + m.P2Num + ", "
+ " P3Num=" + m.P3Num + ", "
+ " P4Num=" + m.P4Num + ", "
+ " P5Num=" + m.P5Num + ", "
+ " P6Num=" + m.P6Num + ", "
+ " Remark='" + m.Remark + "' "
+ " Where Guid='" + m.Guid + "' AND DeleteMark ISNULL";
return(new Helper.SQLite.DBHelper().SingleExecution(sql));
}
private void DataGrid_ProductionBookkeeping_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
string newValue = (e.EditingElement as TextBox).Text.Trim();
if (newValue != _oldValue)
{
int NewValueInt = 0;
string Header = e.Column.Header.ToString();
Model_ProductionBookkeeping m = this.DataGrid_ProductionBookkeeping.SelectedCells[0].Item as Model_ProductionBookkeeping;
Model_ProductionBookkeeping mdata = _data[_data.IndexOf(m)];
switch (Header)
{
case "①":
int.TryParse(newValue, out NewValueInt);
mdata.P1Num = NewValueInt;
mdata.P1Diff = mdata.P2Num - mdata.P1Num;
break;
case "②":
int.TryParse(newValue, out NewValueInt);
mdata.P2Num = NewValueInt;
mdata.P1Diff = mdata.P2Num - mdata.P1Num;
mdata.P2Diff = mdata.P3Num - mdata.P2Num;
break;
case "③":
int.TryParse(newValue, out NewValueInt);
mdata.P3Num = NewValueInt;
mdata.P2Diff = mdata.P3Num - mdata.P2Num;
mdata.P3Diff = mdata.P4Num - mdata.P3Num;
break;
case "④":
int.TryParse(newValue, out NewValueInt);
mdata.P4Num = NewValueInt;
mdata.P3Diff = mdata.P4Num - mdata.P3Num;
break;
case "备注":
mdata.Remark = newValue;
break;
}
new ProductionBookkeepingConsole().Update(mdata);
}
}
internal bool ReadData(string DateStr, string Parm, out ObservableCollection <Model_ProductionBookkeeping> data)
{
string DateParm = "";
if (!DateStr.StartsWith("0000"))
{
DateParm = " AND a.AddDate BETWEEN '" + DateStr + "' AND datetime('" + DateStr + "','+1 day') ";
}
data = new ObservableCollection <Model_ProductionBookkeeping>();
Model_ProductionBookkeeping m;
string sql = "Select a.*,b.Number,b.Name,b.P1,b.P2,b.P3,b.P4,b.P5,b.P6 "
+ " from T_PM_ProductionBookkeeping a"
+ " Left Join T_ProductInfo_Product b ON a.ProductID=b.Guid"
+ " Where a.DeleteMark ISNULL"
+ " AND b.Number LIKE '%" + Parm + "%' "
+ DateParm
+ " Order By a.AddDate desc"
;
DataSet ds = new DataSet();
if (new Helper.SQLite.DBHelper().QueryData(sql, out ds))
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m = new Model_ProductionBookkeeping();
m.Guid = (Guid)dr["Guid"];
m.ProductGuid = (Guid)dr["ProductID"];
m.ProductNumber = dr["Number"].ToString();
m.ProductName = dr["Name"].ToString();
for (int i = 1; i < 7; i++)
{
m.ProductProcess[i - 1] = dr["P" + i].ToString();
if (dr["P" + i].ToString() != "无")
{
m.ProductProcessStr += dr["P" + i].ToString() + "-";
}
}
m.ProductProcessStr = m.ProductProcessStr.Substring(0, m.ProductProcessStr.Length - 1);
m.P1Num = int.Parse(dr["P1Num"].ToString());
m.P2Num = int.Parse(dr["P2Num"].ToString());
m.P3Num = int.Parse(dr["P3Num"].ToString());
m.P4Num = int.Parse(dr["P4Num"].ToString());
m.P5Num = int.Parse(dr["P5Num"].ToString());
m.P6Num = int.Parse(dr["P6Num"].ToString());
m.P1Diff = m.P2Num - m.P1Num;
m.P2Diff = m.P3Num - m.P2Num;
m.P3Diff = m.P4Num - m.P3Num;
m.P4Diff = m.P5Num - m.P4Num;
m.P5Diff = m.P6Num - m.P5Num;
m.IsTurn = int.Parse(dr["IsTurn"].ToString());
m.DisPlayIsTurn = m.IsTurn == 0 ? "否" : "是";
m.Remark = dr["Remark"].ToString();
m.AddDate = Convert.ToDateTime(dr["AddDate"].ToString()).ToString("yyyy-MM-dd");
data.Add(m);
}
}
if (data.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 更新状态，表示已经入了半成品库
/// </summary>
/// <param name="m"></param>
/// <returns></returns>
internal bool UpdateTurn(Model_ProductionBookkeeping m)
{
string sql = "update T_PM_ProductionBookkeeping set isTurn = 1 Where Guid='" + m.Guid + "'";
return(new Helper.SQLite.DBHelper().SingleExecution(sql));
}
