public static Adv Update(Adv Updated) { Adv Item = new Adv(); SqlParameter[] obj = new SqlParameter[11]; obj[0] = new SqlParameter("A_ID", Updated.ID); obj[1] = new SqlParameter("A_Loai", Updated.Loai); obj[2] = new SqlParameter("A_Ten", Updated.Ten); obj[3] = new SqlParameter("A_NoiDung", Updated.NoiDung); obj[4] = new SqlParameter("A_MaViTri", Updated.MaViTri); obj[5] = new SqlParameter("A_ThuTu", Updated.ThuTu); obj[6] = new SqlParameter("A_Active", Updated.Active); obj[7] = new SqlParameter("A_Files", Updated.Files); obj[8] = new SqlParameter("A_FilesMime", Updated.FilesMime); obj[9] = new SqlParameter("A_Urls", Updated.Urls); obj[10] = new SqlParameter("A_Clicks", Updated.Clicks); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssAdv_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static Adv getFromReader(IDataReader rd) { Adv Item = new Adv(); if (rd.FieldExists("A_ID")) { Item.ID = (Int32)(rd["A_ID"]); } if (rd.FieldExists("A_Loai")) { Item.Loai = (Int32)(rd["A_Loai"]); } if (rd.FieldExists("A_Ten")) { Item.Ten = (String)(rd["A_Ten"]); } if (rd.FieldExists("A_NoiDung")) { Item.NoiDung = (String)(rd["A_NoiDung"]); } if (rd.FieldExists("A_MaViTri")) { Item.MaViTri = (String)(rd["A_MaViTri"]); } if (rd.FieldExists("A_ThuTu")) { Item.ThuTu = (Int32)(rd["A_ThuTu"]); } if (rd.FieldExists("A_Active")) { Item.Active = (Boolean)(rd["A_Active"]); } if (rd.FieldExists("A_Files")) { Item.Files = (String)(rd["A_Files"]); } if (rd.FieldExists("A_FilesMime")) { Item.FilesMime = (String)(rd["A_FilesMime"]); } if (rd.FieldExists("A_Urls")) { Item.Urls = (String)(rd["A_Urls"]); } if (rd.FieldExists("A_Clicks")) { Item.Clicks = (Int32)(rd["A_Clicks"]); } return(Item); }
public static Adv SelectById(Int32 A_ID) { Adv Item = new Adv(); SqlParameter[] obj = new SqlParameter[1]; obj[0] = new SqlParameter("A_ID", A_ID); using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssAdv_Select_SelectById_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }
public static Adv Update(Int32?id, Int32?loai, String ten, String noidung, String mavitri, Int32?thutu, Boolean?active, String files, String filesmime, String urls, Int32?clicks) { Adv Item = new Adv(); SqlParameter[] obj = new SqlParameter[11]; if (id != null) { obj[0] = new SqlParameter("A_ID", id); } else { obj[0] = new SqlParameter("A_ID", DBNull.Value); } if (loai != null) { obj[1] = new SqlParameter("A_Loai", loai); } else { obj[1] = new SqlParameter("A_Loai", DBNull.Value); } if (ten != null) { obj[2] = new SqlParameter("A_Ten", ten); } else { obj[2] = new SqlParameter("A_Ten", DBNull.Value); } if (noidung != null) { obj[3] = new SqlParameter("A_NoiDung", noidung); } else { obj[3] = new SqlParameter("A_NoiDung", DBNull.Value); } if (mavitri != null) { obj[4] = new SqlParameter("A_MaViTri", mavitri); } else { obj[4] = new SqlParameter("A_MaViTri", DBNull.Value); } if (thutu != null) { obj[5] = new SqlParameter("A_ThuTu", thutu); } else { obj[5] = new SqlParameter("A_ThuTu", DBNull.Value); } if (active != null) { obj[6] = new SqlParameter("A_Active", active); } else { obj[6] = new SqlParameter("A_Active", DBNull.Value); } if (files != null) { obj[7] = new SqlParameter("A_Files", files); } else { obj[7] = new SqlParameter("A_Files", DBNull.Value); } if (filesmime != null) { obj[8] = new SqlParameter("A_FilesMime", filesmime); } else { obj[8] = new SqlParameter("A_FilesMime", DBNull.Value); } if (urls != null) { obj[9] = new SqlParameter("A_Urls", urls); } else { obj[9] = new SqlParameter("A_Urls", DBNull.Value); } if (clicks != null) { obj[10] = new SqlParameter("A_Clicks", clicks); } else { obj[10] = new SqlParameter("A_Clicks", DBNull.Value); } using (IDataReader rd = SqlHelper.ExecuteReader(DAL.con(), CommandType.StoredProcedure, "tblRss_sp_tblRssAdv_Update_UpdateNormal_linhnx", obj)) { while (rd.Read()) { Item = getFromReader(rd); } } return(Item); }