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;
//}
}
