public void EditOrdersDelivery() { int Orders_Delivery_ID = tools.CheckInt(Request.Form["Orders_Delivery_ID"]); int Orders_Delivery_OrdersID = tools.CheckInt(Request.Form["Orders_Delivery_OrdersID"]); int Orders_Delivery_DeliveryStatus = tools.CheckInt(Request.Form["Orders_Delivery_DeliveryStatus"]); int Orders_Delivery_SysUserID = tools.CheckInt(Request.Form["Orders_Delivery_SysUserID"]); string Orders_Delivery_DocNo = tools.CheckStr(Request.Form["Orders_Delivery_DocNo"]); string Orders_Delivery_Name = tools.CheckStr(Request.Form["Orders_Delivery_Name"]); double Orders_Delivery_Amount = tools.CheckFloat(Request.Form["Orders_Delivery_Amount"]); string Orders_Delivery_Note = tools.CheckStr(Request.Form["Orders_Delivery_Note"]); OrdersDeliveryInfo entity = new OrdersDeliveryInfo(); entity.Orders_Delivery_ID = Orders_Delivery_ID; entity.Orders_Delivery_OrdersID = Orders_Delivery_OrdersID; entity.Orders_Delivery_DeliveryStatus = Orders_Delivery_DeliveryStatus; entity.Orders_Delivery_SysUserID = Orders_Delivery_SysUserID; entity.Orders_Delivery_DocNo = Orders_Delivery_DocNo; entity.Orders_Delivery_Name = Orders_Delivery_Name; entity.Orders_Delivery_Amount = Orders_Delivery_Amount; entity.Orders_Delivery_Note = Orders_Delivery_Note; entity.Orders_Delivery_Addtime = DateTime.Now; entity.Orders_Delivery_Site = Public.GetCurrentSite(); if (MyBLL.EditOrdersDelivery(entity, Public.GetUserPrivilege())) { Public.Msg("positive", "操作成功", "操作成功", true, "Orders_Delivery_list.aspx"); } else { Public.Msg("error", "错误信息", "操作失败,请稍后重试", false, "{back}"); } }
public virtual IList <OrdersDeliveryInfo> GetOrdersDeliverys(QueryInfo Query) { int PageSize; int CurrentPage; IList <OrdersDeliveryInfo> entitys = null; OrdersDeliveryInfo entity = null; string SqlList, SqlField, SqlOrder, SqlParam, SqlTable; SqlDataReader RdrList = null; try { CurrentPage = Query.CurrentPage; PageSize = Query.PageSize; SqlTable = "Orders_Delivery"; 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 <OrdersDeliveryInfo>(); while (RdrList.Read()) { entity = new OrdersDeliveryInfo(); entity.Orders_Delivery_ID = Tools.NullInt(RdrList["Orders_Delivery_ID"]); entity.Orders_Delivery_OrdersID = Tools.NullInt(RdrList["Orders_Delivery_OrdersID"]); entity.Orders_Delivery_DeliveryStatus = Tools.NullInt(RdrList["Orders_Delivery_DeliveryStatus"]); entity.Orders_Delivery_SysUserID = Tools.NullInt(RdrList["Orders_Delivery_SysUserID"]); entity.Orders_Delivery_DocNo = Tools.NullStr(RdrList["Orders_Delivery_DocNo"]); entity.Orders_Delivery_Name = Tools.NullStr(RdrList["Orders_Delivery_Name"]); entity.Orders_Delivery_companyName = Tools.NullStr(RdrList["Orders_Delivery_companyName"]); entity.Orders_Delivery_Code = Tools.NullStr(RdrList["Orders_Delivery_Code"]); entity.Orders_Delivery_Amount = Tools.NullDbl(RdrList["Orders_Delivery_Amount"]); entity.Orders_Delivery_Note = Tools.NullStr(RdrList["Orders_Delivery_Note"]); entity.Orders_Delivery_ReceiveStatus = Tools.NullInt(RdrList["Orders_Delivery_ReceiveStatus"]); entity.Orders_Delivery_Addtime = Tools.NullDate(RdrList["Orders_Delivery_Addtime"]); entity.Orders_Delivery_Site = Tools.NullStr(RdrList["Orders_Delivery_Site"]); //运输单详情新加字段 entity.Orders_Delivery_DriverMobile = Tools.NullStr(RdrList["Orders_Delivery_DriverMobile"]); entity.Orders_Delivery_PlateNum = Tools.NullStr(RdrList["Orders_Delivery_PlateNum"]); entity.Orders_Delivery_TransportType = Tools.NullStr(RdrList["Orders_Delivery_TransportType"]); entitys.Add(entity); entity = null; } } return(entitys); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool AddOrdersDelivery(OrdersDeliveryInfo entity, RBACUserInfo UserPrivilege) { if (RBAC.CheckPrivilege(UserPrivilege, "800fdc63-fa5d-44de-927e-8d4560c2f238")) { return(MyDAL.AddOrdersDelivery(entity)); } else { throw new TradePrivilegeException("没有权限,权限代码:800fdc63-fa5d-44de-927e-8d4560c2f238错误"); } }
public virtual OrdersDeliveryInfo GetOrdersDeliveryByOrdersID(int Orders_ID, int Delivery_Status) { OrdersDeliveryInfo entity = null; SqlDataReader RdrList = null; try { string SqlList; SqlList = "SELECT * FROM Orders_Delivery WHERE Orders_Delivery_OrdersID = " + Orders_ID + ""; if (Delivery_Status > 0) { SqlList += " AND Orders_Delivery_DeliveryStatus=" + Delivery_Status; } SqlList += " ORDER BY Orders_Delivery_ID DESC"; RdrList = DBHelper.ExecuteReader(SqlList); if (RdrList.Read()) { entity = new OrdersDeliveryInfo(); entity.Orders_Delivery_ID = Tools.NullInt(RdrList["Orders_Delivery_ID"]); entity.Orders_Delivery_OrdersID = Tools.NullInt(RdrList["Orders_Delivery_OrdersID"]); entity.Orders_Delivery_DeliveryStatus = Tools.NullInt(RdrList["Orders_Delivery_DeliveryStatus"]); entity.Orders_Delivery_SysUserID = Tools.NullInt(RdrList["Orders_Delivery_SysUserID"]); entity.Orders_Delivery_DocNo = Tools.NullStr(RdrList["Orders_Delivery_DocNo"]); entity.Orders_Delivery_Name = Tools.NullStr(RdrList["Orders_Delivery_Name"]); entity.Orders_Delivery_companyName = Tools.NullStr(RdrList["Orders_Delivery_companyName"]); entity.Orders_Delivery_Code = Tools.NullStr(RdrList["Orders_Delivery_Code"]); entity.Orders_Delivery_Amount = Tools.NullDbl(RdrList["Orders_Delivery_Amount"]); entity.Orders_Delivery_Note = Tools.NullStr(RdrList["Orders_Delivery_Note"]); entity.Orders_Delivery_ReceiveStatus = Tools.NullInt(RdrList["Orders_Delivery_ReceiveStatus"]); entity.Orders_Delivery_Addtime = Tools.NullDate(RdrList["Orders_Delivery_Addtime"]); entity.Orders_Delivery_Site = Tools.NullStr(RdrList["Orders_Delivery_Site"]); //运输单详情新加字段 entity.Orders_Delivery_DriverMobile = Tools.NullStr(RdrList["Orders_Delivery_DriverMobile"]); entity.Orders_Delivery_PlateNum = Tools.NullStr(RdrList["Orders_Delivery_PlateNum"]); entity.Orders_Delivery_TransportType = Tools.NullStr(RdrList["Orders_Delivery_TransportType"]); } return(entity); } catch (Exception ex) { throw ex; } finally { if (RdrList != null) { RdrList.Close(); RdrList = null; } } }
public virtual bool EditOrdersDelivery(OrdersDeliveryInfo entity) { string SqlAdd = null; DataTable DtAdd = null; DataRow DrAdd = null; SqlAdd = "SELECT * FROM Orders_Delivery WHERE Orders_Delivery_ID = " + entity.Orders_Delivery_ID; DtAdd = DBHelper.Query(SqlAdd); try { if (DtAdd.Rows.Count > 0) { DrAdd = DtAdd.Rows[0]; DrAdd["Orders_Delivery_ID"] = entity.Orders_Delivery_ID; DrAdd["Orders_Delivery_OrdersID"] = entity.Orders_Delivery_OrdersID; DrAdd["Orders_Delivery_DeliveryStatus"] = entity.Orders_Delivery_DeliveryStatus; DrAdd["Orders_Delivery_SysUserID"] = entity.Orders_Delivery_SysUserID; DrAdd["Orders_Delivery_DocNo"] = entity.Orders_Delivery_DocNo; DrAdd["Orders_Delivery_Name"] = entity.Orders_Delivery_Name; DrAdd["Orders_Delivery_companyName"] = entity.Orders_Delivery_companyName; DrAdd["Orders_Delivery_Code"] = entity.Orders_Delivery_Code; DrAdd["Orders_Delivery_Amount"] = entity.Orders_Delivery_Amount; DrAdd["Orders_Delivery_Note"] = entity.Orders_Delivery_Note; DrAdd["Orders_Delivery_Addtime"] = entity.Orders_Delivery_Addtime; DrAdd["Orders_Delivery_Site"] = entity.Orders_Delivery_Site; DrAdd["Orders_Delivery_ReceiveStatus"] = entity.Orders_Delivery_ReceiveStatus; //运输单详情新加字段 DrAdd["Orders_Delivery_DriverMobile"] = entity.Orders_Delivery_DriverMobile; DrAdd["Orders_Delivery_PlateNum"] = entity.Orders_Delivery_PlateNum; DrAdd["Orders_Delivery_TransportType"] = entity.Orders_Delivery_TransportType; DBHelper.SaveChanges(SqlAdd, DtAdd); } else { return(false); } } catch (Exception ex) { throw ex; } finally { DtAdd.Dispose(); } return(true); }
public virtual bool EditOrdersDelivery(OrdersDeliveryInfo entity, RBACUserInfo UserPrivilege) { return(MyDAL.EditOrdersDelivery(entity)); }