public virtual SupplierGradeInfo GetSupplierDefaultGrade() { SupplierGradeInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Supplier_Grade WHERE Supplier_Grade_Default = 1 "; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new SupplierGradeInfo(); entity.Supplier_Grade_ID = Tools.NullInt(RdrList["Supplier_Grade_ID"]); entity.Supplier_Grade_Name = Tools.NullStr(RdrList["Supplier_Grade_Name"]); entity.Supplier_Grade_Percent = Tools.NullInt(RdrList["Supplier_Grade_Percent"]); entity.Supplier_Grade_Default = Tools.NullInt(RdrList["Supplier_Grade_Default"]); entity.Supplier_Grade_RequiredCoin = Tools.NullInt(RdrList["Supplier_Grade_RequiredCoin"]); entity.Supplier_Grade_Site = Tools.NullStr(RdrList["Supplier_Grade_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public void EditSupplierGrade() { int Supplier_Grade_ID = tools.CheckInt(Request.Form["Supplier_Grade_ID"]); string Supplier_Grade_Name = tools.CheckStr(Request.Form["Supplier_Grade_Name"]); int Supplier_Grade_Percent = tools.CheckInt(Request.Form["Supplier_Grade_Percent"]); int Supplier_Grade_Default = tools.CheckInt(Request.Form["Supplier_Grade_Default"]); int Supplier_Grade_RequiredCoin = tools.CheckInt(Request.Form["Supplier_Grade_RequiredCoin"]); double Supplier_Grade_CoinRate = tools.CheckFloat(Request.Form["Supplier_Grade_CoinRate"]); if (Supplier_Grade_Name.Length == 0) { Public.Msg("info", "提示信息", "请填写供应商等级名称", false, "{back}"); } SupplierGradeInfo entity = new SupplierGradeInfo(); entity.Supplier_Grade_ID = Supplier_Grade_ID; entity.Supplier_Grade_Name = Supplier_Grade_Name; entity.Supplier_Grade_Percent = Supplier_Grade_Percent; entity.Supplier_Grade_Default = Supplier_Grade_Default; entity.Supplier_Grade_RequiredCoin = Supplier_Grade_RequiredCoin; entity.Supplier_Grade_Site = Public.GetCurrentSite(); if (MyBLL.EditSupplierGrade(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "Supplier_grade_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public virtual bool AddSupplierGrade(SupplierGradeInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT TOP 0 * FROM Supplier_Grade"; DtAdd = DBHelper.Query(SqlAdd); DrAdd = DtAdd.NewRow(); DrAdd["Supplier_Grade_ID"] = entity.Supplier_Grade_ID; DrAdd["Supplier_Grade_Name"] = entity.Supplier_Grade_Name; DrAdd["Supplier_Grade_Percent"] = entity.Supplier_Grade_Percent; DrAdd["Supplier_Grade_Default"] = entity.Supplier_Grade_Default; DrAdd["Supplier_Grade_RequiredCoin"] = entity.Supplier_Grade_RequiredCoin; DrAdd["Supplier_Grade_Site"] = entity.Supplier_Grade_Site; DtAdd.Rows.Add(DrAdd); try { DBHelper.SaveChanges(SqlAdd, DtAdd); return(true); } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } }
public virtual bool EditSupplierGrade(SupplierGradeInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "065594cf-5094-4ce6-b753-3c360d3213bd")) { return(MyDAL.EditSupplierGrade(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:065594cf-5094-4ce6-b753-3c360d3213bd错误"); } }
public virtual bool AddSupplierGrade(SupplierGradeInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "a9ed67d8-d6b1-4518-87ac-f01dadaba761")) { return(MyDAL.AddSupplierGrade(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:a9ed67d8-d6b1-4518-87ac-f01dadaba761错误"); } }
public virtual IList <SupplierGradeInfo> GetSupplierGrades(QueryInfo Query) { int PageSize; int CurrentPage; IList <SupplierGradeInfo> entitys = null; SupplierGradeInfo entity = null; string SqlList, SqlField, SqlOrder, SqlParam, SqlTable; SqlDataReader RdrList = null; try { CurrentPage = Query.CurrentPage; PageSize = Query.PageSize; SqlTable = "Supplier_Grade"; 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 <SupplierGradeInfo>(); while (RdrList.Read()) { entity = new SupplierGradeInfo(); entity.Supplier_Grade_ID = Tools.NullInt(RdrList["Supplier_Grade_ID"]); entity.Supplier_Grade_Name = Tools.NullStr(RdrList["Supplier_Grade_Name"]); entity.Supplier_Grade_Percent = Tools.NullInt(RdrList["Supplier_Grade_Percent"]); entity.Supplier_Grade_Default = Tools.NullInt(RdrList["Supplier_Grade_Default"]); entity.Supplier_Grade_RequiredCoin = Tools.NullInt(RdrList["Supplier_Grade_RequiredCoin"]); entity.Supplier_Grade_Site = Tools.NullStr(RdrList["Supplier_Grade_Site"]); entitys.Add(entity); entity = null; } } return(entitys); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool EditSupplierGrade(SupplierGradeInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Supplier_Grade WHERE Supplier_Grade_ID = " + entity.Supplier_Grade_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Supplier_Grade_ID"] = entity.Supplier_Grade_ID; DrAdd["Supplier_Grade_Name"] = entity.Supplier_Grade_Name; DrAdd["Supplier_Grade_Percent"] = entity.Supplier_Grade_Percent; DrAdd["Supplier_Grade_Default"] = entity.Supplier_Grade_Default; DrAdd["Supplier_Grade_RequiredCoin"] = entity.Supplier_Grade_RequiredCoin; DrAdd["Supplier_Grade_Site"] = entity.Supplier_Grade_Site; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }