public DataTable CheckRowviewExist(Common.Product_GroupingDatum dm)
{
SqlParameter[] prms = new SqlParameter[2];
prms[0] = new SqlParameter("@id_root", dm.Id_root);
prms[1] = new SqlParameter("@rowview", dm.Rowview);
return(sh.ExecuteDataSet("shop_group_chech_rowview", prms));
}
public void Update(Common.Product_GroupingDatum dm)
{
SqlParameter[] prms = new SqlParameter[6];
prms[0] = new SqlParameter("@title", dm.Title);
prms[1] = new SqlParameter("@id", dm.Id);
prms[2] = new SqlParameter("@rowview", dm.Rowview);
prms[3] = new SqlParameter("@MetaKeyword", dm.MetaKeyword);
prms[4] = new SqlParameter("@MetaDescription", dm.MetaDescription);
prms[5] = new SqlParameter("@Path", dm.Path);
sh.ExecuteNonQuery("shop_group_update_node", prms);
}
public decimal SelectMaxRowview(Common.Product_GroupingDatum 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 InsertGroup(Common.Product_GroupingDatum dm)
{
dl.InsertGroup(dm);
}
public void Delete(Common.Product_GroupingDatum dm)
{
dl.Delete(dm);
}
public void Update(Common.Product_GroupingDatum dm)
{
dl.Update(dm);
}
public DataTable Select_back_node(Common.Product_GroupingDatum dm)
{
return(dl.Select_back_node(dm));
}
public DataTable CheckRowviewExist(Common.Product_GroupingDatum dm)
{
return(dl.CheckRowviewExist(dm));
}
public DataTable SelectAll(Common.Product_GroupingDatum dm)
{
return(dl.SelectAll(dm));
}
public void Delete(Common.Product_GroupingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id", dm.Id);
sh.ExecuteNonQuery("shop_group_delete_node", prms);
}
public DataTable Select_back_node(Common.Product_GroupingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id", dm.Id);
return(sh.ExecuteDataSet("shop_group_select_back_node", prms));
}
public DataTable SelectMaxRowview(Common.Product_GroupingDatum dm)
{
SqlParameter[] prms = new SqlParameter[1];
prms[0] = new SqlParameter("@id_root", dm.Id_root);
return(sh.ExecuteDataSet("shop_group_select_max_rowview", prms));
}
