public void Update_Row_View(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[2]; prms[0] = new SqlParameter("@id", dm.Id); prms[1] = new SqlParameter("@row_view", dm.Row_View); sh.ExecuteNonQuery("shop_page_update_row_view", prms); }
public bool Check_Row_View_Exist(Common.Page_ManageDatum dm) { if (dl.Check_Row_View_Exist(dm).Rows.Count > 1) { return(true); } else { return(false); } }
public decimal SelectMaxRowview(Common.Page_ManageDatum dm) { DataTable dt = dl.SelectMaxRowview(dm); if (dt.Rows.Count > 0) { return(decimal.Parse(dt.Rows[0][0].ToString()) + 1); } else { return(1); } }
public void Update(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[8]; prms[0] = new SqlParameter("@title", dm.Title); prms[1] = new SqlParameter("@text", dm.Text); prms[2] = new SqlParameter("@id", dm.Id); prms[3] = new SqlParameter("@id_admin", dm.Id_Admin); prms[4] = new SqlParameter("@show_page", dm.Show_Page); prms[5] = new SqlParameter("@MetaKeyword", dm.MetaKeyword); prms[6] = new SqlParameter("@MetaDescription", dm.MetaDescription); prms[7] = new SqlParameter("@Place", dm.Place); sh.ExecuteNonQuery("shop_page_Update", prms); }
public void Insert(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[9]; prms[0] = new SqlParameter("@title", dm.Title); prms[1] = new SqlParameter("@text", dm.Text); prms[2] = new SqlParameter("@date_send", dm.Date_Send); prms[3] = new SqlParameter("@id_admin", dm.Id_Admin); prms[4] = new SqlParameter("@show_page", dm.Show_Page); prms[5] = new SqlParameter("@row_view", dm.Row_View); prms[6] = new SqlParameter("@MetaKeyword", dm.MetaKeyword); prms[7] = new SqlParameter("@MetaDescription", dm.MetaDescription); prms[8] = new SqlParameter("@Place", dm.Place); sh.ExecuteNonQuery("shop_page_insert", prms); }
public void Insert(Common.Page_ManageDatum dm) { dl.Insert(dm); }
public void Update_Page_View(Common.Page_ManageDatum dm) { dl.Update_Page_View(dm); }
public DataTable Select_User_Top(Common.Page_ManageDatum dm) { return(dl.Select_User_Top(dm)); }
public void Update(Common.Page_ManageDatum dm) { dl.Update(dm); }
public DataTable Select_page_One(Common.Page_ManageDatum dm) { return(dl.Select_page_One(dm)); }
public void Delete(Common.Page_ManageDatum dm) { dl.Delete(dm); }
public DataTable Select_User_Top(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@Place", dm.Place); return(sh.ExecuteDataSet("shop_page_select_user_Top", prms)); }
public DataTable SelectMaxRowview(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@Place", dm.Place); return(sh.ExecuteDataSet("shop_page_select_max_rowview", prms)); }
public DataTable Check_Row_View_Exist(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@row_view", dm.Row_View); return(sh.ExecuteDataSet("shop_page_check_row_view", prms)); }
public DataTable Select_page_One(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@id_page", dm.Id); return(sh.ExecuteDataSet("shop_page_select_one", prms)); }
public void Delete(Common.Page_ManageDatum dm) { SqlParameter[] prms = new SqlParameter[1]; prms[0] = new SqlParameter("@id", dm.Id); sh.ExecuteNonQuery("shop_page_delete", prms); }