private void SetPNum(int p, int Quantity, int BreakNum, ref AssemblyLineDetailsListModel d)
{
switch (p)
{
case 1:
d.P1Num = Quantity;
break;
case 2:
d.P2Num = Quantity;
break;
case 3:
d.P3Num = Quantity;
break;
case 4:
d.P4Num = Quantity;
break;
case 5:
d.P5Num = Quantity;
break;
case 6:
d.P6Num = Quantity;
break;
}
}
internal bool ReadList(string Type, string Screening, int LimitStart, int Limit, out List <AssemblyLineDetailsListModel> Outdata)
{
Outdata = new List <AssemblyLineDetailsListModel>();
string WhereParm = "";
if (!Type.StartsWith("全部"))
{
WhereParm += " AND b.Type='" + Type + "' ";
}
if (Screening != "")
{
WhereParm += " AND (b.Number LIKE '%" + Screening + "%' OR b.Name LIKE '%" + Screening + "%') ";
}
Guid LastGuid = new Guid();
AssemblyLineDetailsListModel LastD = new AssemblyLineDetailsListModel();
List <string> ProcessList = new List <string>();
List <AssemblyLineDetailsListModel> data = new List <AssemblyLineDetailsListModel>();
string sql = " SELECT "
+ " a.ProductID, "
+ " b.Number, "
+ " b.Name, "
+ " b.P1, "
+ " b.P2, "
+ " b.P3, "
+ " b.P4, "
+ " b.P5, "
+ " b.P6, "
+ " a.Process, "
+ " total(a.Number), "
+ " total(a.Break) "
+ " FROM "
+ " T_PM_ProductionSchedule a "
+ " left join T_ProductInfo_Product b ON a.ProductID=b.Guid "
+ " WHERE b.DeleteMark IS NULL AND a.DeleteMark IS NULL " + WhereParm
+ " GROUP BY "
+ " a.ProductID, "
+ " a.Process "
+ " order by b.Number"
;
DataSet ds = new DataSet();
if (new Helper.SQLite.DBHelper().QueryData(sql, out ds))
{
int id = 1;
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (LastGuid != (Guid)dr["ProductID"])//新的Product，新建
{
if (LastGuid != new Guid())
{
CalculateProcessList(ProcessList, LastGuid, ref LastD);
data.Add(LastD);
}
ProcessList.Clear();
for (int i = 1; i < 7; i++)
{
ProcessList.Add(dr["P" + i].ToString());
}
AssemblyLineDetailsListModel d = new AssemblyLineDetailsListModel();
LastGuid = (Guid)dr["ProductID"];
LastD = d;
LastD.Id = id++;
LastD.ProductID = (Guid)dr["ProductID"];
LastD.ProductNumber = dr["Number"].ToString();
LastD.ProductName = dr["Name"].ToString();
SetPNum(Helper.DataDefinition.Process.FiveProcessList.IndexOf(dr["Process"].ToString()) + 1, int.Parse(dr["total(a.Number)"].ToString()), int.Parse(dr["total(a.Break)"].ToString()), ref LastD);
}
else//旧的Product，累加
{
SetPNum(Helper.DataDefinition.Process.FiveProcessList.IndexOf(dr["Process"].ToString()) + 1, int.Parse(dr["total(a.Number)"].ToString()), int.Parse(dr["total(a.Break)"].ToString()), ref LastD);
}
}
if (ds.Tables[0].Rows.Count != 0)
{
CalculateProcessList(ProcessList, LastGuid, ref LastD);
data.Add(LastD);
}
for (int i = LimitStart; i < LimitStart + Limit; i++)
{
if (i < data.Count)
{
Outdata.Add(data[i]);
}
}
return(true);
}
return(false);
}
/// <summary>
/// 处理外加工数量相减
/// </summary>
/// <param name="d"></param>
private void CalculateProcessList(List <string> ProcessList, Guid ProductGuid, ref AssemblyLineDetailsListModel d)
{
int Out = 0, In = 0;
int Break = 0;
string sql = "select total(Quantity),total(MinorInjuries+Injuries+Lose) as Break,OrderType from T_PM_ProcessSchedule where DeleteMark IS NULL AND ProductID='" + ProductGuid + "' GROUP BY OrderType ";
DataSet ds = new DataSet();
new Helper.SQLite.DBHelper().QueryData(sql, out ds);
foreach (DataRow dr in ds.Tables[0].Rows)
{
if (dr["OrderType"].ToString() == "入单")
{
In = int.Parse(dr["total(Quantity)"].ToString());
Break = int.Parse(dr["Break"].ToString());
}
else if (dr["OrderType"].ToString() == "出单")
{
Out = int.Parse(dr["total(Quantity)"].ToString());
}
}
string LastProcess = "";
for (int i = 0; i < 6; i++)
{
if (ProcessList[i] == "抛光" && i > 0)
{
LastProcess = ProcessList[i - 1];
}
}
switch (Helper.DataDefinition.Process.FiveProcessList.IndexOf("抛光") + 1)
{
case 1:
d.P1Num += In;
break;
case 2:
d.P2Num += In;
break;
case 3:
d.P3Num += In;
break;
case 4:
d.P4Num += In;
break;
case 5:
d.P5Num += In;
break;
case 6:
d.P6Num += In;
break;
}
switch (Helper.DataDefinition.Process.FiveProcessList.IndexOf(LastProcess) + 1)
{
case 1:
d.P1Num -= Out;
break;
case 2:
d.P2Num -= Out;
break;
case 3:
d.P3Num -= Out;
break;
case 4:
d.P4Num -= Out;
break;
case 5:
d.P5Num -= Out;
break;
case 6:
d.P6Num -= Out;
break;
}
}
