public List <COrderList> GetUnStartOrderList(string resName) { int dayshift = PublicFunc.GetDayShift(resName); DateTime mesdailydate = PublicFunc.GetDailyDate(resName); SqlCommand cmd = PmConnections.SchCmd(); cmd.CommandText = "SELECT * FROM User_MesDailyData WHERE pmResName = '" + resName + "' and datatype = 'P' and mesdailyDate ='" + mesdailydate.Date + "' and TaskFinishState < '4' and dayShift = '" + dayshift + "' ORDER BY mesdailyDate,planStartTime"; //cmd.CommandText = "SELECT * FROM User_MesDailyData WHERE pmResName = '" + resName + "' and datatype = 'P'and TaskFinishState < '4' and dayShift = '" + shift + "'ORDER BY dailyDate,planStartTime"; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable returndata = new DataTable(); da.Fill(returndata); da.Dispose(); cmd.Connection.Close(); if (returndata.Rows.Count < 1) { return(null); } else { List <COrderList> LiReturnData = new List <COrderList>(); foreach (DataRow item in returndata.Rows) { DataRow checkeddata = PublicFunc.CheckEmptyVal(returndata, item); COrderList li = new COrderList { MesResName = checkeddata["MesResName"].ToString(), MesOpName = checkeddata["MesOpName"].ToString(), MesOperator = checkeddata["bgPerson"].ToString(), WorkID = checkeddata["WorkID"].ToString(), PlanStartTime = PublicFunc.ForMatDateTimeStr(Convert.ToDateTime(checkeddata["PlanStartTime"]), 1), Planendtime = PublicFunc.ForMatDateTimeStr(Convert.ToDateTime(checkeddata["Planendtime"]), 1), PmResName = checkeddata["PmResName"].ToString(), PmOpName = checkeddata["PmOpName"].ToString(), ProductID = checkeddata["ProductID"].ToString(), TaskFinishState = Convert.ToInt32(checkeddata["TaskFinishState"]), FinishedQty = Convert.ToDouble(checkeddata["FinishedQty"]), Plannedqty = Convert.ToDouble(checkeddata["Plannedqty"]), FailedQty = Convert.ToDouble(checkeddata["FailQty"]), AllFinishedQty = Convert.ToDouble(checkeddata["AllFinishedQty"]), JobQty = Convert.ToDouble(checkeddata["JobQty"]), ItemAttr1 = checkeddata["ItemAttr1"].ToString(), ItemAttr2 = checkeddata["ItemAttr2"].ToString(), ItemAttr3 = checkeddata["ItemAttr3"].ToString(), ItemAttr4 = checkeddata["ItemAttr4"].ToString(), DayShift = Convert.ToInt32(checkeddata["DayShift"]), ItemDesp = checkeddata["itemDesp"].ToString(), WorkHours = Convert.ToDouble(checkeddata["workHour"]), SetupTime = Convert.ToDouble(checkeddata["setupTime"]), OrderUID = Convert.ToInt32(checkeddata["UID"]), BomComused = Convert.ToDouble(checkeddata["AllJobTaskqty"]) / Convert.ToDouble(checkeddata["JobQty"]), CanReport = true, CanReportQty = Convert.ToDouble(checkeddata["AllJobTaskqty"]) - Convert.ToDouble(checkeddata["AllFinishedQty"]) - Convert.ToDouble(checkeddata["FailQty"]), ChangeResName = string.Empty, ReportTime = Convert.ToDateTime(checkeddata["updateDatetime"]), JobDemandDay = Convert.ToDateTime(checkeddata["jobDemandDay"]), ScrappedQty = Convert.ToDouble(checkeddata["ScrappedQty"]), Ajustment = Convert.ToBoolean(checkeddata["adjustment"]), UnitPrice = Convert.ToDouble(checkeddata["unitPrice"]), MesSetupStartTime = Convert.ToDateTime(checkeddata["setupStartTime"]), MesSetupEndTime = Convert.ToDateTime(checkeddata["setupEndTime"]), MesStartTime = Convert.ToDateTime(checkeddata["startDateTime"]), MesEndTime = Convert.ToDateTime(checkeddata["endDateTime"]), UserComment = checkeddata["userComment"].ToString() }; LiReturnData.Add(li); } //public DateTime MesStartTime { get; set; } //public DateTime MesEndTime { get; set; } //public DateTime MesSetupStartTime { get; set; } //public DateTime MesSetupEndtime { get; set; } bool hasoutput = false; foreach (COrderList c in LiReturnData) { if (c.TaskFinishState != 0 && c.TaskFinishState != 3) { hasoutput = true; } else { continue; } } if (hasoutput == true) { foreach (COrderList c in LiReturnData) { if (c.TaskFinishState != 0) { c.CanReport = true; } else { c.CanReport = false; } } } return(LiReturnData); } }