/// <summary> /// 清除当天主表数据和明细表数据 /// </summary> public string deleteData() { string tag = "true"; try { DateTime dateTime = DateTime.Now; string date = Convert.ToString(dateTime.ToString("yyyyMMdd")); using (PersistentManager persistentManager = new PersistentManager()) { SortingOrderDao dao = new SortingOrderDao(); SortingOrderDetailBll bll = new SortingOrderDetailBll(); DataTable orderdt = dao.QueryDate(date); string orderidList = UtinString.StringMake(orderdt, "ORDER_ID"); string orderid = UtinString.StringMake(orderidList); dao.deleteOrderDate(date); bll.DeleteOrderId(orderid); } } catch (Exception e) { tag = e.Message; } return(tag); }
/// <summary> /// 确认线路分配 /// </summary> /// <returns></returns> public string UpdateOrderSoringGroupInfo(string SortingCode, string RouteCode, string orderDate) { string tag = "true"; using (PersistentManager persistentManager = new PersistentManager()) { RouteCode = RouteCode.Substring(3, RouteCode.Length - 3); DataTable orderTable = this.QueryOrderId(RouteCode, orderDate);//查询主表Id if (orderTable.Rows.Count > 0) { string orderIdList = UtinString.StringMake(orderTable, "ORDER_ID"); orderIdList = UtinString.StringMake(orderIdList);//取得截取后的主表Id字符 SortingOrderDetailBll orderDetail = new SortingOrderDetailBll(); SortingRouteBll bll = new SortingRouteBll(); string str = orderDetail.UpdateOrderDeatil(SortingCode, orderIdList);//根据主表ID修改明细表分拣分配状态 if (str == "true") { this.UpdateOrderMaster(SortingCode, RouteCode, orderDate);//修改主表分拣线编号 //bll.UpdateRouteAllotState(RouteCode, "1");//修改线路表id } else { tag = str; } } else { tag = "选择的线路没有主订单"; } } return(tag); }
/// <summary> /// 取消线路分配 /// </summary> /// <param name="RouteCode"></param> /// <returns></returns> public string CancelAllotOrder(string RouteCode, string orderDate) { string tag = "true"; using (PersistentManager persistentManager = new PersistentManager()) { RouteCode = RouteCode.Substring(3, RouteCode.Length - 3); DataTable orderTable = this.QueryOrderId(RouteCode, orderDate);//查询主表Id if (orderTable.Rows.Count > 0) { string orderIdList = UtinString.StringMake(orderTable, "ORDER_ID"); orderIdList = UtinString.StringMake(orderIdList);//取得截取后的主表Id字符 SortingOrderDetailBll orderDetail = new SortingOrderDetailBll(); SortingRouteBll bll = new SortingRouteBll(); // bll.UpdateRouteAllotState(RouteCode, "0"); this.UpdateOrderMaster("", RouteCode, orderDate); tag = orderDetail.UpdateOrderDeatil("", orderIdList); } else { tag = "选择取消的线路没有订单!"; } } return(tag); }