/// <summary> /// 加總機台日夜班數量總合 /// </summary> /// <param name="idt">所有資料</param> /// <param name="iselectDate">日期</param> /// <returns>機台日夜班數量總合</returns> private Dictionary <string, SumValueClass> SumTotalValue(DataTable idt, string iselectDate) { if (idt == null || idt.Rows.Count == 0) { return(null); } Dictionary <string, SumValueClass> mTotalList = new Dictionary <string, SumValueClass>(); int mYear = Convert.ToInt32(iselectDate.Substring(0, 4)); int mMonth = Convert.ToInt32(iselectDate.Substring(4, 2)); int mDay = Convert.ToInt32(iselectDate.Substring(6, 2)); DateTime NTime = new DateTime(mYear, mMonth, mDay, SEVEN, 00, 00);//取資料日期的早上7點 foreach (DataRow item in idt.Rows) { string MCID = item[AppDataName.ALA_MCID].ToString(); bool IsDay = Convert.ToDateTime(item[AppDataName.ALAD_DATE]) < NTime ? false : true;//True : 日班,False:夜班 if (!mTotalList.ContainsKey(MCID)) { SumValueClass mNewSumValue = new SumValueClass { Day_Value = 0, Night_Value = 0 }; mTotalList.Add(MCID, mNewSumValue); } SumQtyValue(IsDay, mTotalList[MCID], item); } return(mTotalList); }
/// <summary> /// 加總日夜班的值 /// </summary> /// <param name="iType">True:日班 , False:夜班</param> /// <param name="iSumValue">日夜班的值Class</param> /// <param name="iDr">該筆資料總合</param> private void SumQtyValue(bool iType, SumValueClass iSumValue, DataRow iDr) { int mQty = ChangeQtyValueType(iDr[AppDataName.ALAD_QTY].ToString()); if (iType) { iSumValue.Day_Value += mQty; } else { iSumValue.Night_Value += mQty; } iSumValue.ProductName = iDr[AppDataName.ALAD_ITEM].ToString(); }