public virtual bool EditOrdersBackApply(OrdersBackApplyInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "1f9e3d6c-2229-4894-891b-13e73dd2e593")) { return(MyDAL.EditOrdersBackApply(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:1f9e3d6c-2229-4894-891b-13e73dd2e593错误"); } }
public virtual bool AddOrdersBackApply(OrdersBackApplyInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "a0cbae74-b212-4983-b6b5-9e3e44835aa7")) { return(MyDAL.AddOrdersBackApply(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:a0cbae74-b212-4983-b6b5-9e3e44835aa7错误"); } }
public virtual OrdersBackApplyInfo GetOrdersBackApplyByID(int ID) { OrdersBackApplyInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_BackApply WHERE Orders_BackApply_ID = " + ID; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersBackApplyInfo(); entity.Orders_BackApply_ID = Tools.NullInt(RdrList["Orders_BackApply_ID"]); entity.Orders_BackApply_OrdersCode = Tools.NullStr(RdrList["Orders_BackApply_OrdersCode"]); entity.Orders_BackApply_MemberID = Tools.NullInt(RdrList["Orders_BackApply_MemberID"]); entity.Orders_BackApply_Name = Tools.NullStr(RdrList["Orders_BackApply_Name"]); entity.Orders_BackApply_Type = Tools.NullInt(RdrList["Orders_BackApply_Type"]); entity.Orders_BackApply_DeliveryWay = Tools.NullInt(RdrList["Orders_BackApply_DeliveryWay"]); entity.Orders_BackApply_AmountBackType = Tools.NullInt(RdrList["Orders_BackApply_AmountBackType"]); entity.Orders_BackApply_Amount = Tools.NullDbl(RdrList["Orders_BackApply_Amount"]); entity.Orders_BackApply_Note = Tools.NullStr(RdrList["Orders_BackApply_Note"]); entity.Orders_BackApply_Account = Tools.NullStr(RdrList["Orders_BackApply_Account"]); entity.Orders_BackApply_AdminNote = Tools.NullStr(RdrList["Orders_BackApply_AdminNote"]); entity.Orders_BackApply_SupplierNote = Tools.NullStr(RdrList["Orders_BackApply_SupplierNote"]); entity.Orders_BackApply_SupplierTime = Tools.NullDate(RdrList["Orders_BackApply_SupplierTime"]); entity.Orders_BackApply_AdminTime = Tools.NullDate(RdrList["Orders_BackApply_AdminTime"]); entity.Orders_BackApply_Status = Tools.NullInt(RdrList["Orders_BackApply_Status"]); entity.Orders_BackApply_Addtime = Tools.NullDate(RdrList["Orders_BackApply_Addtime"]); entity.Orders_BackApply_Site = Tools.NullStr(RdrList["Orders_BackApply_Site"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool EditOrdersBackApply(OrdersBackApplyInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Orders_BackApply WHERE Orders_BackApply_ID = " + entity.Orders_BackApply_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Orders_BackApply_ID"] = entity.Orders_BackApply_ID; DrAdd["Orders_BackApply_OrdersCode"] = entity.Orders_BackApply_OrdersCode; DrAdd["Orders_BackApply_MemberID"] = entity.Orders_BackApply_MemberID; DrAdd["Orders_BackApply_Name"] = entity.Orders_BackApply_Name; DrAdd["Orders_BackApply_Type"] = entity.Orders_BackApply_Type; DrAdd["Orders_BackApply_DeliveryWay"] = entity.Orders_BackApply_DeliveryWay; DrAdd["Orders_BackApply_AmountBackType"] = entity.Orders_BackApply_AmountBackType; DrAdd["Orders_BackApply_Amount"] = entity.Orders_BackApply_Amount; DrAdd["Orders_BackApply_Note"] = entity.Orders_BackApply_Note; DrAdd["Orders_BackApply_Account"] = entity.Orders_BackApply_Account; DrAdd["Orders_BackApply_SupplierNote"] = entity.Orders_BackApply_SupplierNote; DrAdd["Orders_BackApply_AdminNote"] = entity.Orders_BackApply_AdminNote; DrAdd["Orders_BackApply_SupplierTime"] = entity.Orders_BackApply_SupplierTime; DrAdd["Orders_BackApply_AdminTime"] = entity.Orders_BackApply_AdminTime; DrAdd["Orders_BackApply_Status"] = entity.Orders_BackApply_Status; DrAdd["Orders_BackApply_Addtime"] = entity.Orders_BackApply_Addtime; DrAdd["Orders_BackApply_Site"] = entity.Orders_BackApply_Site; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }
public virtual bool AddOrdersBackApply(OrdersBackApplyInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT TOP 0 * FROM Orders_BackApply"; DtAdd = DBHelper.Query(SqlAdd); DrAdd = DtAdd.NewRow(); DrAdd["Orders_BackApply_ID"] = entity.Orders_BackApply_ID; DrAdd["Orders_BackApply_OrdersCode"] = entity.Orders_BackApply_OrdersCode; DrAdd["Orders_BackApply_MemberID"] = entity.Orders_BackApply_MemberID; DrAdd["Orders_BackApply_Name"] = entity.Orders_BackApply_Name; DrAdd["Orders_BackApply_Type"] = entity.Orders_BackApply_Type; DrAdd["Orders_BackApply_DeliveryWay"] = entity.Orders_BackApply_DeliveryWay; DrAdd["Orders_BackApply_AmountBackType"] = entity.Orders_BackApply_AmountBackType; DrAdd["Orders_BackApply_Amount"] = entity.Orders_BackApply_Amount; DrAdd["Orders_BackApply_Note"] = entity.Orders_BackApply_Note; DrAdd["Orders_BackApply_Account"] = entity.Orders_BackApply_Account; DrAdd["Orders_BackApply_SupplierNote"] = entity.Orders_BackApply_SupplierNote; DrAdd["Orders_BackApply_AdminNote"] = entity.Orders_BackApply_AdminNote; DrAdd["Orders_BackApply_SupplierTime"] = entity.Orders_BackApply_SupplierTime; DrAdd["Orders_BackApply_AdminTime"] = entity.Orders_BackApply_AdminTime; DrAdd["Orders_BackApply_Status"] = entity.Orders_BackApply_Status; DrAdd["Orders_BackApply_Addtime"] = entity.Orders_BackApply_Addtime; DrAdd["Orders_BackApply_Site"] = entity.Orders_BackApply_Site; DtAdd.Rows.Add(DrAdd); try { DBHelper.SaveChanges(SqlAdd, DtAdd); entity.Orders_BackApply_ID = GetLastOrderBackApply(); return(true); } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } }
public virtual IList <OrdersBackApplyInfo> GetOrdersBackApplys(QueryInfo Query) { int PageSize; int CurrentPage; IList <OrdersBackApplyInfo> entitys = null; OrdersBackApplyInfo entity = null; string SqlList, SqlField, SqlOrder, SqlParam, SqlTable; SqlDataReader RdrList = null; try { CurrentPage = Query.CurrentPage; PageSize = Query.PageSize; SqlTable = "Orders_BackApply"; 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 <OrdersBackApplyInfo>(); while (RdrList.Read()) { entity = new OrdersBackApplyInfo(); entity.Orders_BackApply_ID = Tools.NullInt(RdrList["Orders_BackApply_ID"]); entity.Orders_BackApply_OrdersCode = Tools.NullStr(RdrList["Orders_BackApply_OrdersCode"]); entity.Orders_BackApply_MemberID = Tools.NullInt(RdrList["Orders_BackApply_MemberID"]); entity.Orders_BackApply_Name = Tools.NullStr(RdrList["Orders_BackApply_Name"]); entity.Orders_BackApply_Type = Tools.NullInt(RdrList["Orders_BackApply_Type"]); entity.Orders_BackApply_DeliveryWay = Tools.NullInt(RdrList["Orders_BackApply_DeliveryWay"]); entity.Orders_BackApply_AmountBackType = Tools.NullInt(RdrList["Orders_BackApply_AmountBackType"]); entity.Orders_BackApply_Amount = Tools.NullDbl(RdrList["Orders_BackApply_Amount"]); entity.Orders_BackApply_Note = Tools.NullStr(RdrList["Orders_BackApply_Note"]); entity.Orders_BackApply_Account = Tools.NullStr(RdrList["Orders_BackApply_Account"]); entity.Orders_BackApply_AdminNote = Tools.NullStr(RdrList["Orders_BackApply_AdminNote"]); entity.Orders_BackApply_SupplierNote = Tools.NullStr(RdrList["Orders_BackApply_SupplierNote"]); entity.Orders_BackApply_SupplierTime = Tools.NullDate(RdrList["Orders_BackApply_SupplierTime"]); entity.Orders_BackApply_AdminTime = Tools.NullDate(RdrList["Orders_BackApply_AdminTime"]); entity.Orders_BackApply_Status = Tools.NullInt(RdrList["Orders_BackApply_Status"]); entity.Orders_BackApply_Addtime = Tools.NullDate(RdrList["Orders_BackApply_Addtime"]); entity.Orders_BackApply_Site = Tools.NullStr(RdrList["Orders_BackApply_Site"]); entitys.Add(entity); entity = null; } } return(entitys); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }