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);
}
