public static WorkFlows getFromReader(IDataReader rd)
{
WorkFlows Item = new WorkFlows();
Item.ID = (Int32)(rd["WF_ID"]);
Item.CQ_ID = (Int32)(rd["WF_CQ_ID"]);
Item.Ten = (String)(rd["WF_Ten"]);
Item.MoTa = (String)(rd["WF_MoTa"]);
Item.NgayTao = (DateTime)(rd["WF_NgayTao"]);
Item.NgayCapNhat = (DateTime)(rd["WF_NgayCapNhat"]);
Item.RowId = (Guid)(rd["WF_RowId"]);
Item.Active = (Boolean)(rd["WF_Active"]);
Item.MacDinh = (Boolean)(rd["WF_MacDinh"]);
return(Item);
}
public static WorkFlows SelectById(Int32 WF_ID)
{
WorkFlows Item = new WorkFlows();
SqlParameter[] obj = new SqlParameter[1];
obj[0] = new SqlParameter("WF_ID", WF_ID);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblWorkFlows_Select_SelectById_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
public static WorkFlows Insert(WorkFlows Inserted)
{
WorkFlows Item = new WorkFlows();
SqlParameter[] obj = new SqlParameter[8];
obj[0] = new SqlParameter("WF_CQ_ID", Inserted.CQ_ID);
obj[1] = new SqlParameter("WF_Ten", Inserted.Ten);
obj[2] = new SqlParameter("WF_MoTa", Inserted.MoTa);
obj[3] = new SqlParameter("WF_NgayTao", Inserted.NgayTao);
obj[4] = new SqlParameter("WF_NgayCapNhat", Inserted.NgayCapNhat);
obj[5] = new SqlParameter("WF_RowId", Inserted.RowId);
obj[6] = new SqlParameter("WF_Active", Inserted.Active);
obj[7] = new SqlParameter("WF_MacDinh", Inserted.MacDinh);
using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblWorkFlows_Insert_InsertNormal_linhnx", obj))
{
while (rd.Read())
{
Item = getFromReader(rd);
}
}
return(Item);
}
