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