public Entity.News[] Select_News(int p_News_ClassID, int p_News_LanguageID, int p_PageSize, int p_PageIndex) { DataTable o_DataTable = d_News.Select_News(p_News_ClassID, p_News_LanguageID, p_PageSize, p_PageIndex, ref g_TotalCount, ref g_TotalPage); if (o_DataTable == null) return null; else { Entity.News[] e_News = new Entity.News[o_DataTable.Rows.Count]; int i = 0; foreach (DataRow o_DataRow in o_DataTable.Rows) { e_News[i] = new Entity.News(); e_News[i].News_ID = Convert.ToInt32(o_DataRow["News_ID"].ToString()); e_News[i].News_ClassID = Convert.ToInt32(o_DataRow["News_ClassID"].ToString()); e_News[i].News_LanguageID = Convert.ToInt32(o_DataRow["News_LanguageID"].ToString()); e_News[i].News_Title = o_DataRow["News_Title"].ToString(); e_News[i].News_Intro = o_DataRow["News_Intro"].ToString(); e_News[i].News_Content = o_DataRow["News_Content"].ToString(); e_News[i].News_AddTime = DateTime.Parse(o_DataRow["News_AddTime"].ToString()); i++; } return e_News; } }
public int Create(Entity.News obj) { using (var context = MasterDBContext()) { return(context.StoredProcedure("News_Create") .Parameter("Name", obj.Name) .Parameter("Avatar", obj.Avatar) .Parameter("Sapo", obj.Sapo) .Parameter("Description", obj.Description) .Parameter("Active", obj.Active) .Parameter("CategoryId", obj.CategoryId) .QuerySingle <int>()); } }
public void Insert_News(int p_News_ClassID, int p_News_LanguageID, string p_News_Title, string p_News_Intro, string p_News_Content) { p_News_Title = FilterUtility.FilterSQL(p_News_Title); p_News_Content = FilterUtility.FilterSQL(p_News_Content); Entity.News o_News = new Entity.News(); o_News.News_ClassID = p_News_ClassID; o_News.News_LanguageID = p_News_LanguageID; o_News.News_Title = p_News_Title; o_News.News_Intro = p_News_Intro; o_News.News_Content = p_News_Content; o_News.News_AddTime = DateTime.Now; d_News.Insert_News(o_News); }
public Entity.News Select_News(int p_News_ID) { DataTable o_DataTable = d_News.Select_News(p_News_ID); if (o_DataTable == null) return null; else { Entity.News e_News = new Entity.News(); DataRow o_DataRow = o_DataTable.Rows[0]; e_News.News_ID = Convert.ToInt32(o_DataRow["News_ID"].ToString()); e_News.News_ClassID = Convert.ToInt32(o_DataRow["News_ClassID"].ToString()); e_News.News_LanguageID = Convert.ToInt32(o_DataRow["News_LanguageID"].ToString()); e_News.News_Title = o_DataRow["News_Title"].ToString(); e_News.News_Intro = o_DataRow["News_Intro"].ToString(); e_News.News_Content = o_DataRow["News_Content"].ToString(); e_News.News_AddTime = DateTime.Parse(o_DataRow["News_AddTime"].ToString()); return e_News; } }