internal bool Insert(ProductManagement_PickingModel m, ObservableCollection <ProductManagement_PickingDetailModel> list)
{
List <string> sqlList = new List <string>();
string date = Date.FormatToD(m.Date);
string sql = "insert into T_PM_ProductInProcess(Guid,Number,ProcessorID,Date,Operator,Remark) VALUES ('" + m.Guid + "','" + m.OrderNO + "','" + m.ProcessorID + "','" + date + "','" + CommonParameters.LoginUserName + "','" + m.Remark + "')";
sqlList.Add(sql);
foreach (ProductManagement_PickingDetailModel mm in list)
{
if (mm.ProductID.Equals(Guid.Empty))
{
continue;
}
else
{
sql = "insert into T_PM_ProductInProcessDetail(Guid,ParentId,ProductID,Date,Operator,QuantityA,QuantityB,QuantityC,OrderGuid) "
+ "VALUES ('" + Guid.NewGuid() + "','" + m.Guid + "','" + mm.ProductID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + CommonParameters.LoginUserName + "','" + mm.QuantityA + "','" + mm.QuantityB + "','" + mm.QuantityD + "','" + m.Guid + "')";
sqlList.Add(sql);
sql = "Insert into T_Warehouse_SparePartsInventory(Guid,ProcessorID,ProductID,Date,Operator,Quantity,Remark,OrderGuid) "
+ " values('" + Guid.NewGuid() + "','" + m.ProcessorID + "','" + mm.ProductID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + CommonParameters.LoginUserName + "','-" + (mm.QuantityA + mm.QuantityB) + "','从抛光收货单录入','" + m.Guid + "')";
sqlList.Add(sql);
sql = "Insert into T_Warehouse_Product(Guid,ProductID,Date,Operator,Quantity,Remark,OrderGuid) "
+ " values('" + Guid.NewGuid() + "','" + mm.ProductID + "','" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss") + "','" + CommonParameters.LoginUserName + "','" + mm.QuantityA + "','从抛光收货单录入,记录损坏数量：" + mm.QuantityB + "','" + m.Guid + "')";
sqlList.Add(sql);
}
}
//更新排名
return(new Helper.SQLite.DBHelper().Transaction(sqlList));
}
private void Button_删除_Click(object sender, RoutedEventArgs e)
{
if (this.DataGrid_ProcessIn.SelectedCells.Count > 0)
{
if (MessageBox.Show("确认删除订单？", "警告", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
ProductManagement_PickingModel m = this.DataGrid_ProcessIn.SelectedCells[0].Item as ProductManagement_PickingModel;
if (new ViewModel.ProductionManagement.DeliveryProcessInConsole().DeleteOrder(m.Guid))
{
InitializeDataGrid();
HalfProductEvent.OnUpdateDataGrid();
SparePartsInventoryEvent.OnUpdateDataGrid();
DeliveryProcessInEvent.OnUpdateDataGrid();
}
}
}
internal bool ReadList(DateTime Start, DateTime End, Guid ProductID, Guid ProcessorID, out List <ProductManagement_PickingModel> data, out string strCount)
{
strCount = "";
string sql_WhereParm = "";
string LastID = string.Empty;
if (ProductID != new Guid())
{
sql_WhereParm += " AND b.ProductID='" + ProductID + "' ";
}
if (ProcessorID != new Guid())
{
sql_WhereParm += " AND a.ProcessorID='" + ProcessorID + "' ";
}
sql_WhereParm += " AND a.Date between '" + Start.ToString("yyyy-MM-dd HH:mm:ss") + "' and '" + End.ToString("yyyy-MM-dd HH:mm:ss") + "'";
bool flag = false;
data = new List <ProductManagement_PickingModel>();
int Count = 0;
int temp = 0;
ProductManagement_PickingModel LastData = new ProductManagement_PickingModel();
string sql = "SELECT " +
" a.Guid,a.Number, "+
" strftime(a.Date) as Date, "+
" a.ProcessorID, "+
" c.Name as ProcessorName, "+
" b.ProductID, "+
" d.Number as ProductNumber, "+
" d.Name as ProductName, "+
" b.QuantityA,b.QuantityB,"+
" a.Remark "+
"FROM " +
" T_PM_ProductInProcess a "+
"LEFT JOIN T_PM_ProductInProcessDetail b ON a.Guid = b.ParentId " +
"LEFT JOIN T_UserInfo_Processors c ON a.ProcessorID = c.GUID " +
"LEFT JOIN T_ProductInfo_Product d ON b.ProductID = d.GUID where a.deleteMark is null " + sql_WhereParm +
" order by a.Date desc";
DataSet ds = new DataSet();
flag = new Helper.SQLite.DBHelper().QueryData(sql, out ds);
if (flag)
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (LastID != dr["Guid"].ToString())
{
if (LastID != string.Empty)
{
data.Add(LastData);
}
LastID = dr[0].ToString();
ProductManagement_PickingModel d = new ProductManagement_PickingModel();
LastData = d;
LastData.Guid = (Guid)dr["Guid"];
LastData.Id = id;
id++;
LastData.Date = dr["Date"].ToString().Split(' ')[0];
LastData.OrderNO = dr["Number"].ToString();
LastData.ProcessorName = dr["ProcessorName"].ToString();
LastData.ProductNumber = dr["ProductNumber"].ToString();
LastData.ProductName = dr["ProductName"].ToString();
LastData.ProcessorID = (Guid)dr["ProcessorID"];
int.TryParse(dr["QuantityA"].ToString(), out temp);
LastData.QuantityA = temp.ToString();
Count += temp;
int.TryParse(dr["QuantityB"].ToString(), out temp);
LastData.QuantityB = temp.ToString();
LastData.Remark = dr["Remark"].ToString();
}
else //旧凭证
{
LastData.ProductNumber += "\n" + dr["ProductNumber"].ToString();
LastData.ProductName += "\n" + dr["ProductName"].ToString();
int.TryParse(dr["QuantityA"].ToString(), out temp);
LastData.QuantityA += "\n" + dr["QuantityA"].ToString();
Count += temp;
int.TryParse(dr["QuantityB"].ToString(), out temp);
LastData.QuantityB += "\n" + dr["QuantityB"].ToString();
}
}
if (ds.Tables[0].Rows.Count != 0)
{
data.Add(LastData);
}
}
strCount = (Count).ToString();
return(flag);
}
internal bool Update(ProductManagement_PickingModel mm, ObservableCollection <ProductManagement_PickingDetailModel> data)
{
throw new NotImplementedException();
}
