internal Model_ProductionManagement_OutsideProcessBatch ReadProductInfo(string ProductNumber)
{
Model_ProductionManagement_OutsideProcessBatch m = new Model_ProductionManagement_OutsideProcessBatch();
string sql = "SELECT GUID,Name,Material,P1,P2,P3,P4,P5,P6 FROM T_ProductInfo_Product WHERE NUMBER='" + ProductNumber + "' AND DELETEMARK ISNULL";
DataSet ds = new DataSet();
bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m.ProductGuid = (Guid)dr["GUID"];
m.ProductNumber = ProductNumber;
m.ProductName = dr["Name"].ToString();
m.Material = dr["Material"].ToString();
for (int i = 1; i < 7; i++)
{
if (dr["P" + i].ToString() == "抛光")
{
m.HasPolishing = true;
}
}
}
}
return(m);
}
/// <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);
}
internal Model_ProductionManagement_OutsideProcessBatch ReadProcessorsInfo(string ProcessorsNumber)
{
Model_ProductionManagement_OutsideProcessBatch m = new Model_ProductionManagement_OutsideProcessBatch();
string sql = "SELECT GUID,Name FROM T_UserInfo_Processors WHERE NUMBER='" + ProcessorsNumber + "' AND DELETEMARK ISNULL";
DataSet ds = new DataSet();
bool flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
foreach (DataRow dr in ds.Tables[0].Rows)
{
m.ProcessorsGuid = (Guid)dr["GUID"];
m.ProcessorsNumber = ProcessorsNumber;
m.ProcessorsName = dr["Name"].ToString();
}
}
return(m);
}
private void DataGrid_CellEditEnding(object sender, DataGridCellEditEndingEventArgs e)
{
Model_ProductionManagement_OutsideProcessBatch model = this.DataGrid.SelectedCells[0].Item as Model_ProductionManagement_OutsideProcessBatch;
string newValue = (e.EditingElement as TextBox).Text.Trim();
string Header = e.Column.Header.ToString();
if (Header == "产品编号")
{
Model_ProductionManagement_OutsideProcessBatch m = new OutsideProcessBatchInputConsole().ReadProductInfo(newValue);
if (m.ProductGuid == new Guid())
{
DataGrid.CurrentCell = new DataGridCellInfo(DataGrid.SelectedCells[0].Item, DataGrid.Columns[0]);
data[data.IndexOf(model)].ProductGuid = new Guid();
data[data.IndexOf(model)].ProductName = "";
data[data.IndexOf(model)].Material = "";
}
else if (m.HasPolishing == false)
{
DataGrid.CurrentCell = new DataGridCellInfo(DataGrid.SelectedCells[0].Item, DataGrid.Columns[0]);
data[data.IndexOf(model)].ProductGuid = new Guid();
data[data.IndexOf(model)].ProductName = "";
data[data.IndexOf(model)].Material = "";
data[data.IndexOf(model)].Remark = "该产品没有抛光工序，请重新录入。";
}
else
{
data[data.IndexOf(model)].ProductGuid = m.ProductGuid;
data[data.IndexOf(model)].ProductName = m.ProductName;
data[data.IndexOf(model)].Material = m.Material;
if (data[data.IndexOf(model)].Remark == "该产品没有抛光工序，请重新录入。")
{
data[data.IndexOf(model)].Remark = "";
}
}
}
}