public int Update(RequestForUpdate requestForUpdate)
{
string sql =
"UPDATE RequestForUpdate " +
"SET " +
" CustomerID = @CustomerID"
+ ", CustomerName = @CustomerName"
+ ", RequestUpdateRoleID = @RequestUpdateRoleID"
+ ", RequestUpdateFileID = @RequestUpdateFileID"
+ ", RequestResult = @RequestResult"
+ ", CreateDate = @CreateDate"
+ " WHERE ID = @ID";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ID", requestForUpdate.ID)
, new SqlParameter("@CustomerID", ToDBValue(requestForUpdate.CustomerID))
, new SqlParameter("@CustomerName", ToDBValue(requestForUpdate.CustomerName))
, new SqlParameter("@RequestUpdateRoleID", ToDBValue(requestForUpdate.RequestUpdateRoleID))
, new SqlParameter("@RequestUpdateFileID", ToDBValue(requestForUpdate.RequestUpdateFileID))
, new SqlParameter("@RequestResult", ToDBValue(requestForUpdate.RequestResult))
, new SqlParameter("@CreateDate", ToDBValue(requestForUpdate.CreateDate))
};
return(SqlHelper.ExecuteNonQuery(sql, para));
}
public RequestForUpdate ToModel(SqlDataReader reader)
{
RequestForUpdate requestForUpdate = new RequestForUpdate();
requestForUpdate.ID = (int)ToModelValue(reader, "ID");
requestForUpdate.CustomerID = (string)ToModelValue(reader, "CustomerID");
requestForUpdate.CustomerName = (string)ToModelValue(reader, "CustomerName");
requestForUpdate.RequestUpdateRoleID = (int?)ToModelValue(reader, "RequestUpdateRoleID");
requestForUpdate.RequestUpdateFileID = (int?)ToModelValue(reader, "RequestUpdateFileID");
requestForUpdate.RequestResult = (int?)ToModelValue(reader, "RequestResult");
requestForUpdate.CreateDate = (DateTime?)ToModelValue(reader, "CreateDate");
return(requestForUpdate);
}
public RequestForUpdate Add
(RequestForUpdate requestForUpdate)
{
string sql = "INSERT INTO RequestForUpdate (ID, CustomerID, CustomerName, RequestUpdateRoleID, RequestUpdateFileID, RequestResult, CreateDate) VALUES (@ID, @CustomerID, @CustomerName, @RequestUpdateRoleID, @RequestUpdateFileID, @RequestResult, @CreateDate)";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@ID", ToDBValue(requestForUpdate.ID)),
new SqlParameter("@CustomerID", ToDBValue(requestForUpdate.CustomerID)),
new SqlParameter("@CustomerName", ToDBValue(requestForUpdate.CustomerName)),
new SqlParameter("@RequestUpdateRoleID", ToDBValue(requestForUpdate.RequestUpdateRoleID)),
new SqlParameter("@RequestUpdateFileID", ToDBValue(requestForUpdate.RequestUpdateFileID)),
new SqlParameter("@RequestResult", ToDBValue(requestForUpdate.RequestResult)),
new SqlParameter("@CreateDate", ToDBValue(requestForUpdate.CreateDate)),
};
SqlHelper.ExecuteNonQuery(sql, para);
return(requestForUpdate);
}
public int Update(RequestForUpdate requestForUpdate)
{
return(new RequestForUpdateDAL().Update(requestForUpdate));
}
public RequestForUpdate Add(RequestForUpdate requestForUpdate)
{
return(new RequestForUpdateDAL().Add(requestForUpdate));
}
