public static RoleFunction getFromReader(IDataReader rd) { RoleFunction Item = new RoleFunction(); Item.ID = (Int32)(rd["RF_ID"]); Item.FN_ID = (Int32)(rd["RF_FN_ID"]); Item.ROLE_ID = (Int32)(rd["RF_ROLE_ID"]); Item.Active = (Boolean)(rd["RF_Active"]); Item.RowId = (Guid)(rd["RF_RowId"]); Item.NguoiTao = (String)(rd["RF_NguoiTao"]); Item.NgayTao = (DateTime)(rd["RF_NgayTao"]); Item.NgayCapNhat = (DateTime)(rd["RF_NgayCapNhat"]); return(Item); }
public static RoleFunction SelectById(Int32 RF_ID) { RoleFunction Item = new RoleFunction(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("RF_ID", RF_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblRoleFunction_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static RoleFunction UpdateByRoleIdFunctionList(string ROLE_ID, string FN_List, string NguoiTao) { RoleFunction Item = new RoleFunction(); SqlParameter[] obj = new SqlParameter[3]; obj[0] = new SqlParameter("ROLE_ID", ROLE_ID); obj[1] = new SqlParameter("FN_List", FN_List); obj[2] = new SqlParameter("NguoiTao", NguoiTao); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblRoleFunction_Update_UpdateByRoleIdFunctionList_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static RoleFunction Insert(RoleFunction Inserted) { RoleFunction Item = new RoleFunction(); SqlParameter[] obj = new SqlParameter[7]; obj[0] = new SqlParameter("RF_FN_ID", Inserted.FN_ID); obj[1] = new SqlParameter("RF_ROLE_ID", Inserted.ROLE_ID); obj[2] = new SqlParameter("RF_Active", Inserted.Active); obj[3] = new SqlParameter("RF_RowId", Inserted.RowId); obj[4] = new SqlParameter("RF_NguoiTao", Inserted.NguoiTao); obj[5] = new SqlParameter("RF_NgayTao", Inserted.NgayTao); obj[6] = new SqlParameter("RF_NgayCapNhat", Inserted.NgayCapNhat); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblRoleFunction_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }