public Model.RequestInfo GetRequest(int reqId)
{
Model.RequestInfo request = null;
string cmdText = @"select r.reqID,r.SiteID,r.UID,r.CreateTime,
w.displayName as UserName,
w.dept as UserDept,
w.mail as UserMail,
w.site as UserSite,
r.FormID,f.FormName,r.ExpectDay,r.FlowType,
r.Detail,r.FormFile,r.AttFile,
r.Remark
from request r
inner join form f on r.FormID=f.FormID
left join WinADUser w on r.uid=w.userid
where r.reqID=@RequestId";
SqlParameter param = new SqlParameter("@RequestId", reqId);
using (SqlDataReader reader = SqlHelper.ExecuteReader(cmdText, param))
{
if (reader.Read())
{
request = ReaderToRequestEntity(reader);
}
}
return(request);
}
// public bool Update(Model.RequestInfo request)
// {
// string cmdText = @"update Request Set [Title]=@Title,[UID]=@UID,
// [content]=@Detail,[deptId]=@DepartmentId,[workcellid]=@WorkcellId,
// [FileName]=@FileName,[QuotFile]=@QuotFile,amt=@amt where reqId=@RequestId";
// SqlParameter[] parameters = new SqlParameter[]{
// new SqlParameter("@RequestId",request.ReqID),
// new SqlParameter("@Title",request.Title),
// new SqlParameter("@UID",request.User.UID),
// new SqlParameter("@Detail",request.Detail),
// new SqlParameter("@FileName",request.FileName),
// new SqlParameter("@DepartmentId",request.DeptId),
// new SqlParameter("@WorkcellId",request.WcId),
// new SqlParameter("@QuotFile",request.QuotFile),
// new SqlParameter("@amt",request.Amt)
// };
// if (parameters[8].Value == null)
// {
// parameters[8].Value = DBNull.Value;
// }
// if (parameters[9].Value == null)
// {
// parameters[9].Value = DBNull.Value;
// }
// return SqlHelper.ExecuteNonQuery(cmdText, parameters) > 0;
// }
private Model.RequestInfo ReaderToRequestEntity(SqlDataReader reader)
{
Model.RequestInfo request = new Model.RequestInfo();
request.ReqID = int.Parse(reader["reqId"].ToString());
request.SiteID = int.Parse(reader["SiteID"].ToString());
request.User = new Model.UserInfo
{
UID = reader["uid"].ToString().ToLower(),
DisplayName = reader["UserName"].ToString(),
Department = reader["UserDept"].ToString(),
Email = reader["UserMail"].ToString()
};
request.CreateTime = DateTime.Parse(reader["CreateTime"].ToString());
request.ExpectDay = DateTime.Parse(reader["ExpectDay"].ToString());
request.FormID = int.Parse(reader["FormID"].ToString());
request.FlowType = int.Parse(reader["FlowType"].ToString());
request.Detail = reader["Detail"].ToString();
request.FormName = reader["FormName"].ToString();
if (reader["FormFile"] != DBNull.Value)
{
request.FormFile = reader["FormFile"].ToString();
}
if (reader["AttFile"] != DBNull.Value)
{
request.AttFile = reader["AttFile"].ToString();
}
request.Remark = reader["Remark"].ToString();
return(request);
}
public int Create(Model.RequestInfo requestInfo)
{
string cmdText = @"insert into Request (SiteID,UID,CreateTime,FormID,ExpectDay,FlowType,Detail,
FormFile,AttFile,Remark) values (@SiteID,@UID,@CreateTime,@FormID,@ExpectDay,@FlowType,@Detail,
@FormFile,@AttFile,@Remark); select @@identity;";
SqlParameter[] parameters =
{
new SqlParameter("@SiteID", requestInfo.SiteID),
new SqlParameter("@UID", requestInfo.User.UID),
new SqlParameter("@CreateTime", requestInfo.CreateTime),
new SqlParameter("@FormID", requestInfo.FormID),
new SqlParameter("@ExpectDay", requestInfo.ExpectDay),
new SqlParameter("@FlowType", requestInfo.FlowType),
new SqlParameter("@Detail", requestInfo.Detail),
new SqlParameter("@FormFile", requestInfo.FormFile),
new SqlParameter("@AttFile", requestInfo.AttFile ?? ""),
new SqlParameter("@Remark", requestInfo.Remark)
};
object obj = SqlHelper.ExecuteScalar(cmdText, parameters);
return(obj == null ? -1 : Convert.ToInt32(obj));
}
