public void EditProductTag()
{
int Product_Tag_ID = tools.CheckInt(Request.Form["Product_Tag_ID"]);
string Product_Tag_Name = tools.CheckStr(Request.Form["Product_Tag_Name"]);
int Product_Tag_IsSupplier = tools.CheckInt(Request.Form["Product_Tag_IsSupplier"]);
int Product_Tag_IsActive = tools.CheckInt(Request.Form["Product_Tag_IsActive"]);
string Tag_ProductID = tools.NullStr(Request["favor_productid"]);
string Product_Tag_Site = Public.GetCurrentSite();
ProductTagInfo entity = new ProductTagInfo();
entity.Product_Tag_ID = Product_Tag_ID;
entity.Product_Tag_Name = Product_Tag_Name;
entity.Product_Tag_IsActive = Product_Tag_IsActive;
entity.Product_Tag_IsSupplier = Product_Tag_IsSupplier;
entity.Product_Tag_Site = Product_Tag_Site;
if (MyBLL.EditProductTag(entity, Public.GetUserPrivilege()))
{
MyBLL.AddProductRelateTag(Tag_ProductID, entity.Product_Tag_ID);
Public.Msg("positive", "操作成功", "操作成功", true, "tag.aspx");
}
else
{
Public.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public void AddProductTag()
{
int Product_Tag_ID = tools.CheckInt(Request.Form["Product_Tag_ID"]);
string Product_Tag_Name = tools.CheckStr(Request.Form["Product_Tag_Name"]);
int Product_Tag_IsSupplier = tools.CheckInt(Request.Form["Product_Tag_IsSupplier"]);
int Product_Tag_IsActive = tools.CheckInt(Request.Form["Product_Tag_IsActive"]);
int Product_Tag_Sort = tools.CheckInt(Request.Form["Product_Tag_Sort"]);
string Product_Tag_Site = pub.GetCurrentSite();
ProductTagInfo entity = new ProductTagInfo();
entity.Product_Tag_ID = Product_Tag_ID;
entity.Product_Tag_Name = Product_Tag_Name;
entity.Product_Tag_IsSupplier = 1;
entity.Product_Tag_IsActive = Product_Tag_IsActive;
entity.Product_Tag_Sort = Product_Tag_Sort;
entity.Product_Tag_Site = Product_Tag_Site;
entity.Product_Tag_SupplierID = tools.NullInt(Session["supplier_id"]);
if (MyBLL.AddProductTag(entity, pub.CreateUserPrivilege("2f1d706e-3356-494d-821c-c4173a923328")))
{
pub.Msg("positive", "操作成功", "操作成功", true, "tag.aspx");
}
else
{
pub.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual bool EditProductTag(ProductTagInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT * FROM product_tag WHERE Product_Tag_ID = " + entity.Product_Tag_ID;
DtAdd = DBHelper.Query(SqlAdd);
try {
if (DtAdd.Rows.Count > 0)
{
DrAdd = DtAdd.Rows[0];
DrAdd["Product_Tag_ID"] = entity.Product_Tag_ID;
DrAdd["Product_Tag_Name"] = entity.Product_Tag_Name;
DrAdd["Product_Tag_IsSupplier"] = entity.Product_Tag_IsSupplier;
DrAdd["Product_Tag_SupplierID"] = entity.Product_Tag_SupplierID;
DrAdd["Product_Tag_IsActive"] = entity.Product_Tag_IsActive;
DrAdd["Product_Tag_Sort"] = entity.Product_Tag_Sort;
DrAdd["Product_Tag_Site"] = entity.Product_Tag_Site;
DBHelper.SaveChanges(SqlAdd, DtAdd);
}
else
{
return(false);
}
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
return(true);
}
public virtual bool AddProductTag(ProductTagInfo entity)
{
string SqlAdd = null;
DataTable DtAdd = null;
DataRow DrAdd = null;
SqlAdd = "SELECT TOP 0 * FROM product_tag";
DtAdd = DBHelper.Query(SqlAdd);
DrAdd = DtAdd.NewRow();
DrAdd["Product_Tag_ID"] = entity.Product_Tag_ID;
DrAdd["Product_Tag_Name"] = entity.Product_Tag_Name;
DrAdd["Product_Tag_IsSupplier"] = entity.Product_Tag_IsSupplier;
DrAdd["Product_Tag_SupplierID"] = entity.Product_Tag_SupplierID;
DrAdd["Product_Tag_IsActive"] = entity.Product_Tag_IsActive;
DrAdd["Product_Tag_Sort"] = entity.Product_Tag_Sort;
DrAdd["Product_Tag_Site"] = entity.Product_Tag_Site;
DtAdd.Rows.Add(DrAdd);
try {
DBHelper.SaveChanges(SqlAdd, DtAdd);
return(true);
}
catch (Exception ex) {
throw ex;
}
finally {
DtAdd.Dispose();
}
}
public virtual bool EditProductTag(ProductTagInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "2fea26b6-bbb2-44d8-9b46-0b1aed1cc47f"))
{
return(MyDAL.EditProductTag(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：2fea26b6-bbb2-44d8-9b46-0b1aed1cc47f错误");
}
}
public virtual bool AddProductTag(ProductTagInfo entity, RBACUserInfo UserPrivilege)
{
if (RBAC.CheckPrivilege(UserPrivilege, "2f1d706e-3356-494d-821c-c4173a923328"))
{
return(MyDAL.AddProductTag(entity));
}
else
{
throw new TradePrivilegeException("没有权限，权限代码：2f1d706e-3356-494d-821c-c4173a923328错误");
}
}
public virtual IList <ProductTagInfo> GetProductTags(QueryInfo Query)
{
int PageSize;
int CurrentPage;
IList <ProductTagInfo> entitys = null;
string SqlList, SqlField, SqlOrder, SqlParam, SqlTable;
SqlDataReader RdrList = null;
try
{
CurrentPage = Query.CurrentPage;
PageSize = Query.PageSize;
SqlTable = "product_tag";
SqlField = "*";
SqlParam = DBHelper.GetSqlParam(Query.ParamInfos);
SqlOrder = DBHelper.GetSqlOrder(Query.OrderInfos);
SqlList = DBHelper.GetSqlPage(SqlTable, SqlField, SqlParam, SqlOrder, CurrentPage, PageSize);
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.HasRows)
{
entitys = new List <ProductTagInfo>();
while (RdrList.Read())
{
ProductTagInfo entity = new ProductTagInfo();
entity.Product_Tag_ID = Tools.NullInt(RdrList["Product_Tag_ID"]);
entity.Product_Tag_Name = Tools.NullStr(RdrList["Product_Tag_Name"]);
entity.Product_Tag_IsSupplier = Tools.NullInt(RdrList["Product_Tag_IsSupplier"]);
entity.Product_Tag_SupplierID = Tools.NullInt(RdrList["Product_Tag_SupplierID"]);
entity.Product_Tag_IsActive = Tools.NullInt(RdrList["Product_Tag_IsActive"]);
entity.Product_Tag_Sort = Tools.NullInt(RdrList["Product_Tag_Sort"]);
entity.Product_Tag_Site = Tools.NullStr(RdrList["Product_Tag_Site"]);
entitys.Add(entity);
}
}
return(entitys);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}
public void EditProductTag()
{
int Product_Tag_ID = tools.CheckInt(Request.Form["Product_Tag_ID"]);
string Product_Tag_Name = tools.CheckStr(Request.Form["Product_Tag_Name"]);
int Product_Tag_IsSupplier = tools.CheckInt(Request.Form["Product_Tag_IsSupplier"]);
int Product_Tag_IsActive = tools.CheckInt(Request.Form["Product_Tag_IsActive"]);
int Product_Tag_Sort = tools.CheckInt(Request.Form["Product_Tag_Sort"]);
//string Tag_ProductID = tools.NullStr(Request["favor_productid"]);
string Product_Tag_Site = pub.GetCurrentSite();
ProductTagInfo entity = GetProductTagByID(Product_Tag_ID);
if (entity == null || entity.Product_Tag_SupplierID != tools.NullInt(Session["supplier_id"]))
{
entity = null;
pub.Msg("error", "错误信息", "记录不存在", true, "tag.aspx");
}
entity.Product_Tag_ID = Product_Tag_ID;
entity.Product_Tag_Name = Product_Tag_Name;
entity.Product_Tag_IsActive = Product_Tag_IsActive;
entity.Product_Tag_IsSupplier = 1;
entity.Product_Tag_Sort = Product_Tag_Sort;
entity.Product_Tag_Site = Product_Tag_Site;
entity.Product_Tag_SupplierID = tools.NullInt(Session["supplier_id"]);
if (MyBLL.EditProductTag(entity, pub.CreateUserPrivilege("2fea26b6-bbb2-44d8-9b46-0b1aed1cc47f")))
{
// MyBLL.AddProductRelateTag(Tag_ProductID, entity.Product_Tag_ID);
pub.Msg("positive", "操作成功", "操作成功", true, "tag.aspx");
}
else
{
pub.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public void DelProductTag()
{
int product_tag_id = tools.CheckInt(Request.QueryString["product_tag_id"]);
ProductTagInfo tagEntity = GetProductTagByID(product_tag_id);
if (tagEntity == null || tagEntity.Product_Tag_SupplierID != tools.NullInt(Session["supplier_id"]))
{
tagEntity = null;
pub.Msg("error", "错误信息", "记录不存在", true, "tag.aspx");
}
tagEntity = null;
if (MyBLL.DelProductTag(product_tag_id, pub.CreateUserPrivilege("7b8b58e2-e509-4e6c-a68e-0361225cefa6")) > 0)
{
MyBLL.AddProductRelateTag("", product_tag_id);
pub.Msg("positive", "操作成功", "操作成功", true, "tag.aspx");
}
else
{
pub.Msg("error", "错误信息", "操作失败，请稍后重试", false, "{back}");
}
}
public virtual ProductTagInfo GetProductTagByValue(string tag_Value)
{
ProductTagInfo entity = null;
SqlDataReader RdrList = null;
try
{
string SqlList;
SqlList = "SELECT * FROM product_tag WHERE Product_Tag_IsActive=1 and Product_Tag_Name = '" + tag_Value + "'";
RdrList = DBHelper.ExecuteReader(SqlList);
if (RdrList.Read())
{
entity = new ProductTagInfo();
entity.Product_Tag_ID = Tools.NullInt(RdrList["Product_Tag_ID"]);
entity.Product_Tag_Name = Tools.NullStr(RdrList["Product_Tag_Name"]);
entity.Product_Tag_IsSupplier = Tools.NullInt(RdrList["Product_Tag_IsSupplier"]);
entity.Product_Tag_SupplierID = Tools.NullInt(RdrList["Product_Tag_SupplierID"]);
entity.Product_Tag_IsActive = Tools.NullInt(RdrList["Product_Tag_IsActive"]);
entity.Product_Tag_Sort = Tools.NullInt(RdrList["Product_Tag_Sort"]);
entity.Product_Tag_Site = Tools.NullStr(RdrList["Product_Tag_Site"]);
}
return(entity);
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (RdrList != null)
{
RdrList.Close();
RdrList = null;
}
}
}