/// <summary>
/// 根据ID查询一条审批记录
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public Examine GetExaminById(int id)
{
IUserInfoService userService = new DAL.Power.UserInfoService();
string sql = "usp_GetExaminById";
Examine e = new Examine();
using (SqlDataReader reader = DBHelper.ExecuteReaderProc(sql, new SqlParameter("@Id", id)))
{
if (reader.Read())
{
e.EID = Convert.ToInt32(reader["EID"]);
e.EndTime = Convert.ToDateTime(reader["EndTime"]);
e.ExamineIdea = reader["ExamineIdea"].ToString();
e.ExamineUID = userService.GetAllUserById(Convert.ToInt32(reader["ExamineUID"]));
e.IsApproved = reader["IsApprove"].ToString();
e.RequisitionType = reader["RequisitionType"].ToString();
e.RequisitionID = Convert.ToInt32(reader["RequisitionID"]);
reader.Close();
return(e);
}
else
{
reader.Close();
return(null);
}
}
return(e);
}
/// <summary>
/// 根据审批类型查询审批记录
/// </summary>
/// <param name="type"></param>
/// <returns></returns>
public IList <Examine> SearchExamineByType(string type)
{
IUserInfoService userService = new DAL.Power.UserInfoService();
string sql = "usp_SearchExamineByType";
IList <Examine> list = new List <Examine>();
using (DataTable dt = DBHelper.GetDataTableProc(sql, new SqlParameter("@Type", type)))
{
foreach (DataRow row in dt.Rows)
{
Examine e = new Examine();
e.EID = Convert.ToInt32(row["EID"]);
e.EndTime = Convert.ToDateTime(row["EndTime"]);
e.ExamineIdea = row["ExamineIdea"].ToString();
e.ExamineUID = userService.GetAllUserById(Convert.ToInt32(row["ExamineUID"]));
e.IsApproved = row["IsApprove"].ToString();
e.RequisitionType = row["RequisitionType"].ToString();
e.RequisitionID = Convert.ToInt32(row["RequisitionID"]);
list.Add(e);
}
}
return(list);
}
