private void Button_删除_Click(object sender, System.Windows.RoutedEventArgs e)
{
if (this.DataGrid_List.SelectedCells.Count > 0)
{
if (MessageBox.Show("确认删除订单？", "警告", MessageBoxButton.YesNo) == MessageBoxResult.No)
{
return;
}
Model_圆片订单 m = this.DataGrid_List.SelectedCells[0].Item as Model_圆片订单;
if (new ViewModel.Orders.Vm_Order_圆片().Delete(m.Guid))
{
MessageBox.Show("删除成功");
InitDataGrid();
Helper.Events.MeansOfProduction.Event_圆片.OnUpdate圆片库存();
}
}
}
public bool Add(Model_圆片订单 data)
{
List <string> sqls = new List <string>();
sqls.Add("Insert into T_Order_Wafer values('" + data.Guid + "'," + data.OrderType + ",'" + data.单号 + "','" + data.单日期 + "','" + data.备注 + "')");
foreach (Model_圆片仓库 m in data.明细)
{
if (m.Guid != new Guid() && m.数量 != 0)
{
if (data.OrderType == 0)
{
m.数量 = -m.数量;
sqls.Add("Insert into T_Warehouse_HalfProduct(Guid,ProductID,Date,Operator,Quantity,OrderGuid) values('" + Guid.NewGuid() + "','" + m.半成品Guid + "','" + data.单日期 + "',''," + m.半成品数量 + ",'" + data.Guid + "')");
}
sqls.Add("Insert into T_Warehouse_Wafer values('" + Guid.NewGuid() + "','" + data.Guid + "','" + m.Guid + "'," + m.数量 + "," + m.损耗数量 + ",'" + m.半成品Guid + "'," + m.半成品数量 + ")");
}
}
if (sqls.Count == 1)//无明细记录返回false
{
return(false);
}
return(new Helper.SQLite.DBHelper().Transaction(sqls));
}
public List <Model_圆片订单> ReadList(int inOut, DateTime start, DateTime end)
{
List <Model_圆片订单> data = new List <Model_圆片订单>();
string sql = "SELECT "
+ " a.*,"
+ " b.Quantity,b.LossQuantity,b.HalfProductGuid,b.HalfProductQuantity,"
+ " c.Number,c.Diameter,c.Thickness, "
+ " d.Number as PNumber,d.Name as PName "
+ "FROM "
+ " T_Order_Wafer a "
+ "Left join T_Warehouse_Wafer b on a.Guid=b.OrderGuid "
+ "Left join T_ProductInfo_Wafer c on b.WaferGuid=c.Guid "
+ "Left Join T_ProductInfo_Product d ON d.Guid=b.HalfProductGuid "
+ "where a.OrderType=" + inOut + " "
+ " AND a.Date Between '" + start.ToString("yyyy-MM-dd 00:00:00") + "' And '" + end.ToString("yyyy-MM-dd 23:59:59") + "' "
+ "Order By a.Date,c.Number "
;
DataSet ds = new DataSet();
if (new Helper.SQLite.DBHelper().QueryData(sql, out ds))
{
int rowid = 1;
Guid lastOrderGuid = new Guid();
Model_圆片订单 m = new Model_圆片订单 {
序号 = 0
};
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (lastOrderGuid != dr.Field <Guid>("Guid"))
{
if (lastOrderGuid != new Guid())
{
data.Add(m);
}
m = new Model_圆片订单 {
序号 = rowid++
};
lastOrderGuid = dr.Field <Guid>("Guid");
m.Guid = lastOrderGuid;
m.OrderType = inOut;
m.单号 = dr.Field <string>("OrderNo");
m.单日期 = dr.Field <DateTime>("Date").ToString("yyyy-MM-dd");
m.备注 = dr.Field <string>("Remark");
m.编号s += dr.Field <string>("Number");
m.直径s += dr.Field <string>("Diameter");
m.厚度s += dr.Field <string>("Thickness");
m.数量s += inOut == 1 ? dr.Field <Int64?>("Quantity") : -dr.Field <Int64?>("Quantity");
m.损耗数量s += dr.Field <Int64?>("LossQuantity");
m.半成品数量s += dr.Field <Int64?>("HalfProductQuantity");
m.入库半成品编号s += dr.Field <string>("PNumber");
m.半成品品名s += dr.Field <string>("PName");
}
else
{
m.编号s += "\n" + dr.Field <string>("Number");
m.直径s += "\n" + dr.Field <string>("Diameter");
m.厚度s += "\n" + dr.Field <string>("Thickness");
m.数量s += "\n" + (inOut == 1 ? dr.Field <Int64?>("Quantity") : -dr.Field <Int64?>("Quantity"));
m.损耗数量s += "\n" + dr.Field <Int64?>("LossQuantity");
m.半成品数量s += "\n" + dr.Field <Int64?>("HalfProductQuantity");
m.入库半成品编号s += "\n" + dr.Field <string>("PNumber");
m.半成品品名s += "\n" + dr.Field <string>("PName");
}
}
if (m.序号 != 0)
{
data.Add(m);
}
}
return(data);
}
