public RequirementTrack GetDemandByID(int id) { RequirementTrack rt = new RequirementTrack(); string sql = "select * from RequirementTrack where reqDel=0 and id=" + id; DataTable dt = MySqlHelper.mySqlExecuteQuery(sql, null, false); rt = (from y in dt.AsEnumerable() select new RequirementTrack { Id = id, ReqTitle = y.Field <string>("ReqTitle"), ReqAttach = y.Field <string>("ReqAttach"), ReqContent = y.Field <string>("ReqContent"), ReqHospital = y.Field <string>("ReqHospital"), ReqSource = y.Field <string>("ReqSource"), ReqAssignDev = y.Field <string>("ReqAssignDev"), ReqRegistrer = y.Field <string>("ReqRegistrer"), ReqDeveloper = y.Field <string>("ReqDeveloper"), ReqStatus = y.Field <string>("ReqStatus"), ReqTime = y.Field <DateTime?>("ReqTime").ToString(), ReqReplyTime = y.Field <DateTime?>("ReqReplyTime").ToString(), ReqRemark = y.Field <string>("ReqRemark"), ReqDel = y.Field <int>("ReqDel"), ReqHospitalParent = y.Field <string>("ReqHospitalParent"), ReqResult = y.Field <string>("ReqResult"), ReqReviewRemark = y.Field <string>("ReqReviewRemark"), ReqFillBackReason = y.Field <string>("ReqFillBackReason"), ReqReviewTime = y.Field <DateTime?>("ReqReviewTime").ToString(), ReqServiceName = y.Field <string>("ReqServiceName"), ReqServiceId = y.Field <string>("ReqServiceId"), ReqTestSTime = y.Field <DateTime?>("ReqTestSTime").ToString(), ReqTester = y.Field <string>("ReqTester"), ReqTestETime = y.Field <DateTime?>("ReqTestETime").ToString(), ReqTestReviewResult = y.Field <string>("ReqTestReviewResult"), ReqTestReviewTime = y.Field <DateTime?>("ReqTestReviewTime").ToString(), ReqTestReviewer = y.Field <string>("ReqTestReviewer"), ReqClass = y.Field <int>("ReqClass"), ReqFunModule = y.Field <string>("ReqFunModule"), ReqEndResult = y.Field <string>("ReqEndResult"), ReqEndReviewer = y.Field <string>("ReqEndReviewer"), ReqEndTime = y.Field <DateTime?>("ReqEndTime").ToString(), }).FirstOrDefault <RequirementTrack>(); return(rt); }
public List <RequirementTrack> GetDemandBySerach(string Source, string StarTime, string EndTime, string Hospital, string ZDR, string Area, string Status) { //try //{ string sTime = DateTime.Now.AddDays(-7).ToString("yyyy-MM-dd"); string eTime = DateTime.Now.ToString("yyyy-MM-dd"); if (string.IsNullOrEmpty(StarTime)) { StarTime = sTime; } if (string.IsNullOrEmpty(EndTime)) { EndTime = eTime; } string strSql = "select * from RequirementTrack where reqDel=0 and reqclass=1 "; if (!string.IsNullOrEmpty(Source) && Source != "全部") { strSql += " and ReqSource='" + Source + "'"; } if (!string.IsNullOrEmpty(StarTime)) { strSql += " and ReqTime>'" + Convert.ToDateTime(StarTime).ToString("yyyy-MM-dd 00:00:00") + "'"; } if (!string.IsNullOrEmpty(EndTime)) { strSql += " and ReqTime<'" + Convert.ToDateTime(EndTime).ToString("yyyy-MM-dd 23:59:00") + "'"; } if (!string.IsNullOrEmpty(Hospital)) { strSql += " and ReqHospital like '%" + Hospital + "%'"; } if (!string.IsNullOrEmpty(ZDR)) { strSql += " and ReqAssignDev like '%" + ZDR.Trim() + "%'"; } if (!string.IsNullOrEmpty(ZDR)) { strSql += " and ReqDeveloper like '%" + ZDR.Trim() + "%'"; } if (!string.IsNullOrEmpty(Area)) { strSql += " and ReqHospitalParent like '%" + Area + "%'"; } if (!string.IsNullOrEmpty(Status) && Status != "全部") { string[] arr = Status.Split(','); string temp = null; for (int i = 0; i < arr.Length; i++) { if (i == 0) { temp += "'" + arr[i].Trim() + "'"; } else { temp += ",'" + arr[i].Trim() + "'"; } } strSql += " and ReqStatus in (" + temp + ")"; } strSql += " order by ReqTime desc"; DataTable dt = MySqlHelper.mySqlExecuteQuery(strSql, null, false); List <RequirementTrack> reqList = new List <RequirementTrack>(); foreach (DataRow dr in dt.Rows) { RequirementTrack item = new RequirementTrack(); if (dr["Id"] != null && dr["Id"] != DBNull.Value) { item.Id = Convert.ToInt32(dr["Id"]); } if (dr["ReqHospital"] != null && dr["ReqHospital"] != DBNull.Value) { item.ReqHospital = Convert.ToString(dr["ReqHospital"]); } if (dr["ReqHospitalParent"] != null && dr["ReqHospitalParent"] != DBNull.Value) { item.ReqHospitalParent = Convert.ToString(dr["ReqHospitalParent"]); } else { item.ReqHospitalParent = ""; } if (dr["ReqTitle"] != null && dr["ReqTitle"] != DBNull.Value) { item.ReqTitle = Convert.ToString(dr["ReqTitle"]); } if (dr["ReqContent"] != null && dr["ReqContent"] != DBNull.Value) { item.ReqContent = Convert.ToString(dr["ReqContent"]); } if (dr["ReqSource"] != null && dr["ReqSource"] != DBNull.Value) { item.ReqSource = Convert.ToString(dr["ReqSource"]); } if (dr["ReqRegistrer"] != null && dr["ReqRegistrer"] != DBNull.Value) { item.ReqRegistrer = Convert.ToString(dr["ReqRegistrer"]); } if (dr["ReqAssignDev"] != null && dr["ReqAssignDev"] != DBNull.Value) { item.ReqAssignDev = Convert.ToString(dr["ReqAssignDev"]); } if (dr["ReqDeveloper"] != null && dr["ReqDeveloper"] != DBNull.Value) { item.ReqDeveloper = Convert.ToString(dr["ReqDeveloper"]); } if (dr["ReqStatus"] != null && dr["ReqStatus"] != DBNull.Value) { item.ReqStatus = Convert.ToString(dr["ReqStatus"]); } if (dr["ReqTime"] != null && dr["ReqTime"] != DBNull.Value) { item.ReqTime = Convert.ToDateTime(dr["ReqTime"]).ToString("yyyy-MM-dd"); } if (dr["ReqReplyTime"] != null && dr["ReqReplyTime"] != DBNull.Value) { item.ReqReplyTime = Convert.ToDateTime(dr["ReqReplyTime"]).ToString("yyyy-MM-dd"); } if (dr["ReqRemark"] != null && dr["ReqRemark"] != DBNull.Value) { item.ReqRemark = Convert.ToString(dr["ReqRemark"]); } if (dr["ReqServiceId"] != null && dr["ReqServiceId"] != DBNull.Value) { item.ReqServiceId = Convert.ToString(dr["ReqServiceId"]); } else { item.ReqServiceId = ""; } if (dr["ReqServiceName"] != null && dr["ReqServiceName"] != DBNull.Value) { item.ReqServiceName = Convert.ToString(dr["ReqServiceName"]); } else { item.ReqServiceName = ""; } if (dr["ReqResult"] != null && dr["ReqResult"] != DBNull.Value) { item.ReqResult = Convert.ToString(dr["ReqResult"]); } else { item.ReqResult = ""; } if (dr["ReqReviewer"] != null && dr["ReqReviewer"] != DBNull.Value) { item.ReqReviewer = Convert.ToString(dr["ReqReviewer"]); } else { item.ReqReviewer = ""; } if (dr["ReqReviewTime"] != null && dr["ReqReviewTime"] != DBNull.Value) { item.ReqReviewTime = Convert.ToString(dr["ReqReviewTime"]); } else { item.ReqReviewTime = ""; } if (dr["ReqTester"] != null && dr["ReqTester"] != DBNull.Value) { item.ReqTester = Convert.ToString(dr["ReqTester"]); } else { item.ReqTester = ""; } if (dr["ReqTestETime"] != null && dr["ReqTestETime"] != DBNull.Value) { item.ReqTestETime = Convert.ToString(dr["ReqTestETime"]); } else { item.ReqTestETime = ""; } if (dr["ReqTestReviewer"] != null && dr["ReqTestReviewer"] != DBNull.Value) { item.ReqTestReviewer = Convert.ToString(dr["ReqTestReviewer"]); } else { item.ReqTestReviewer = ""; } if (dr["ReqTestSTime"] != null && dr["ReqTestSTime"] != DBNull.Value) { item.ReqTestSTime = Convert.ToString(dr["ReqTestSTime"]); } else { item.ReqTestSTime = ""; } if (dr["ReqTestReviewTime"] != null && dr["ReqTestReviewTime"] != DBNull.Value) { item.ReqTestReviewTime = Convert.ToString(dr["ReqTestReviewTime"]); } else { item.ReqTestReviewTime = ""; } if (dr["ReqTestReviewResult"] != null && dr["ReqTestReviewResult"] != DBNull.Value) { item.ReqTestReviewResult = Convert.ToString(dr["ReqTestReviewResult"]); } else { item.ReqTestReviewResult = ""; } if (dr["ReqEndResult"] != null && dr["ReqEndResult"] != DBNull.Value) { item.ReqEndResult = Convert.ToString(dr["ReqEndResult"]); } else { item.ReqEndResult = ""; } if (dr["ReqEndReviewer"] != null && dr["ReqEndReviewer"] != DBNull.Value) { item.ReqEndReviewer = Convert.ToString(dr["ReqEndReviewer"]); } else { item.ReqEndReviewer = ""; } if (dr["ReqEndTime"] != null && dr["ReqEndTime"] != DBNull.Value) { item.ReqEndTime = Convert.ToString(dr["ReqEndTime"]); } else { item.ReqEndTime = ""; } reqList.Add(item); } return(reqList); //} //catch //{ // return null; //} }