protected override DataRow GetGridRow(object obj) { qty = (SMTRptLineQtyTimePeriod)obj; DataRow row = this.DtSource.NewRow(); row["MOCode"] = qty.MOCode; row["ItemCode"] = qty.ProductCode; row["ShiftDay"] = FormatHelper.ToDateString(qty.ShiftDay); row["TimePeriodCode"] = qty.TPCode; row["TimePeriodDescription"] = qty.TPDescription; row["TargetQty"] = String.Format("{0:#,#}", qty.CurrentQty); row["ActualQty"] = String.Format("{0:#,#}", qty.ActualQty); row["DifferenceQty"] = String.Format("{0:#,#}", qty.CurrentQty - qty.ActualQty); row["TPComPassRate"] = Math.Round(qty.TPComPassRate * 100, 2).ToString() + " %"; row["MaintainUser"] = qty.MaintainUser; row["MaintainDate"] = FormatHelper.ToDateString(qty.MaintainDate); row["MaintainTime"] = FormatHelper.ToTimeString(qty.MaintainTime); //if (qty.ActualQty < qty.CurrentQty && qty.MaintainDate == 0) //{ // DateTime dtEnd = Convert.ToDateTime(FormatHelper.ToDateString(qty.Day) + " " + FormatHelper.ToTimeString(qty.TPEndTime)); // if (dtEnd < DateTime.Now) // { // row.Style.ForeColor = Color.Red; // } //} return(row); }
protected override string[] FormatExportRecord(object obj) { SMTRptLineQtyTimePeriod qty = (SMTRptLineQtyTimePeriod)obj; return(new string[] { qty.MOCode, qty.ProductCode, FormatHelper.ToDateString(qty.ShiftDay), qty.TPCode, qty.TPDescription, qty.CurrentQty.ToString(), qty.ActualQty.ToString(), (qty.CurrentQty - qty.ActualQty).ToString(), Math.Round(qty.TPComPassRate * 100, 2).ToString() + " %", qty.MaintainUser, FormatHelper.ToDateString(qty.MaintainDate), FormatHelper.ToTimeString(qty.MaintainTime) }); }