public List <PrdEditDetail> getArrayForAssemblingDetail(ref String[] arrTimeWork)
{
arrTimeWork = new String[] {
"19", "20", "21", "22", "23", "00", "01", "02", "03", "04", "05", "06", "Night小計",
"07", "08", "09", "10", "11", "12", "13", "14", "15", "16", "17", "18", "Morning小計",
"Day合計"
};
//String[,] arrMCCode = new String[27, 4];
List <PrdEditDetail> listMCCode = new List <PrdEditDetail>();
for (var i = 0; i < arrTimeWork.Length; i++)
{
int outNum = 0;
PrdEditDetail prdDetail = new PrdEditDetail();
prdDetail.index = (arrTimeWork[i]);
if (int.TryParse(arrTimeWork[i], out outNum))
{
prdDetail.dateHr = (arrTimeWork[i] + ":30");
}
else if (arrTimeWork[i].Contains("小計"))
{
prdDetail.dateHr = ("小計");
}
else if (arrTimeWork[i].Contains("合計"))
{
prdDetail.dateHr = ("日合計");
}
listMCCode.Add(prdDetail);
}
return(listMCCode);
}
/// <summary>
/// 取得此項目的資料
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public String GetAssemblingDetailByDate(string code, string date)
{
AlAssmblingDetailQryModel qm = new AlAssmblingDetailQryModel();
qm.Q_MCCode = code;
qm.Q_Date = date;
var dt = AlDataService.Instance.AlAssmblingDetail_getDayList(qm);
List <PrdClass> data = new List <PrdClass>();
PrdClass dataList = null;
if (dt != null && dt.Rows.Count > 0)
{
string codeIdxPast = null, codexPast = null;
String[] arrTimeWork = null;
var listLine = HryDataService.Instance.getArrayForAssemblingDetail(ref arrTimeWork);
Int32 sumMorning = 0, sumNighting = 0, index = 0;;
PrdEditDetail itemLine = null;
for (var i = 0; i < dt.Rows.Count; i++)
{
var row = dt.Rows[i];
string codeIdx = Convert.ToString(row[AppDataName.ALA_MCID]);
string codex = Convert.ToString(row[AppDataName.ALA_MCName]);
var hh = Convert.ToDateTime(row[AppDataName.ALAD_DATE]).Hour.ToString();
hh = (hh.Length == 1) ? String.Concat("0", hh) : hh;
index = -1;
#region 第一筆
if (codeIdxPast.isNullOrEmpty())
{
index = Array.IndexOf(arrTimeWork, hh);
if (index >= 0)
{
itemLine = listLine[index];
itemLine.item = Convert.ToString(row[AppDataName.ALAD_ITEM]).Replace("\0", string.Empty);
itemLine.qty = Convert.ToString(row[AppDataName.ALAD_QTY]);
listLine[index] = itemLine;
if (Convert.ToInt32(hh) >= 7 && Convert.ToInt32(hh) <= 18)
{
sumMorning += Convert.ToInt32(itemLine.qty);
}
if ((Convert.ToInt32(hh) >= 19 && Convert.ToInt32(hh) <= 23) || (Convert.ToInt32(hh) >= 0 && Convert.ToInt32(hh) <= 6))
{
sumNighting += Convert.ToInt32(itemLine.qty);
}
}
codeIdxPast = codeIdx;
codexPast = codex;
continue;
}
#endregion
#region 一條LINE
if (!codeIdxPast.equalIgnoreCase(codeIdx))
{
//早班
index = Array.IndexOf(arrTimeWork, "Morning小計");
itemLine = listLine[index];
itemLine.qty = Convert.ToString(sumMorning);
listLine[index] = itemLine;
//晚班
index = Array.IndexOf(arrTimeWork, "Night小計");
itemLine = listLine[index];
itemLine.qty = Convert.ToString(sumNighting);
listLine[index] = itemLine;
//整天
index = Array.IndexOf(arrTimeWork, "Day合計");
itemLine = listLine[index];
itemLine.qty = Convert.ToString(sumMorning + sumNighting);
listLine[index] = itemLine;
dataList = new PrdClass(codexPast, listLine);
data.Add(dataList);
sumMorning = 0;
sumNighting = 0;
codeIdxPast = codeIdx;
codexPast = codex;
listLine = HryDataService.Instance.getArrayForAssemblingDetail(ref arrTimeWork);
}
#endregion
#region 一筆
index = Array.IndexOf(arrTimeWork, hh);
if (index >= 0)
{
itemLine = listLine[index];
itemLine.item = Convert.ToString(row[AppDataName.ALAD_ITEM]).Replace("\0", string.Empty);
itemLine.qty = Convert.ToString(row[AppDataName.ALAD_QTY]);
listLine[index] = itemLine;
if (Convert.ToInt32(hh) >= 7 && Convert.ToInt32(hh) <= 18)
{
sumMorning += Convert.ToInt32(itemLine.qty);
}
if ((Convert.ToInt32(hh) >= 19 && Convert.ToInt32(hh) <= 23) || (Convert.ToInt32(hh) >= 0 && Convert.ToInt32(hh) <= 6))
{
sumNighting += Convert.ToInt32(itemLine.qty);
}
}
#endregion
}
//早班
index = Array.IndexOf(arrTimeWork, "Morning小計");
itemLine = listLine[index];
itemLine.qty = Convert.ToString(sumMorning);
listLine[index] = itemLine;
//晚班
index = Array.IndexOf(arrTimeWork, "Night小計");
itemLine = listLine[index];
itemLine.qty = Convert.ToString(sumNighting);
listLine[index] = itemLine;
//整天
index = Array.IndexOf(arrTimeWork, "Day合計");
itemLine = listLine[index];
itemLine.qty = Convert.ToString(sumMorning + sumNighting);
listLine[index] = itemLine;
dataList = new PrdClass(codexPast, listLine);
data.Add(dataList);
}
return(JsonConvert.SerializeObject(data));
//return "value";
}
