public static NhomTin Insert(Int32?id, Int32?n_id, Int32?t_id) { NhomTin Item = new NhomTin(); SqlParameter[] obj = new SqlParameter[2]; if (n_id != null) { obj[0] = new SqlParameter("NT_N_ID", n_id); } else { obj[0] = new SqlParameter("NT_N_ID", DBNull.Value); } if (t_id != null) { obj[1] = new SqlParameter("NT_T_ID", t_id); } else { obj[1] = new SqlParameter("NT_T_ID", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static NhomTin SelectById(Int32 NT_ID) { NhomTin Item = new NhomTin(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("NT_ID", NT_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static NhomTin Insert(NhomTin Inserted) { NhomTin Item = new NhomTin(); SqlParameter[] obj = new SqlParameter[2]; obj[0] = new SqlParameter("NT_N_ID", Inserted.N_ID); obj[1] = new SqlParameter("NT_T_ID", Inserted.T_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssNhomTin_Insert_InsertNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
/// <summary> /// hampv /// </summary> /// <param name="ROLE_ID"></param> /// <param name="FN_List"></param> /// <param name="NguoiTao"></param> /// <returns></returns> public static NhomTin UpdateByTIN_IdDanhmucList(string TIN_ID, string DM_List) { NhomTin Item = new NhomTin(); SqlParameter[] obj = new SqlParameter[3]; obj[0] = new SqlParameter("TIN_ID", TIN_ID); obj[1] = new SqlParameter("DM_List", DM_List); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "sp_tblRssNhomTin_Update_UpdateByDM_IdDanhmucList_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static NhomTin getFromReader(IDataReader rd) { NhomTin Item = new NhomTin(); Tin _Item = new Tin(); _Item = TinDal.getFromReader(rd); if (rd.FieldExists("NT_ID")) { Item.ID = (Int32)(rd["NT_ID"]); } if (rd.FieldExists("NT_N_ID")) { Item.N_ID = (Int32)(rd["NT_N_ID"]); } if (rd.FieldExists("NT_T_ID")) { Item.T_ID = (Int32)(rd["NT_T_ID"]); } Item._Tin = _Item; return(Item); }