public ResResultModel DeleteOrderMake(string itemAppend) { try { MenusDataProxy.ValidateAccess((int)EnumData.EnumOperationAccess.除, true); if (string.IsNullOrWhiteSpace(itemAppend)) { return(ResResult.Response(false, MC.Request_Params_InvalidError, "")); } var items = itemAppend.Split(new char[] { ',' }, StringSplitOptions.RemoveEmptyEntries); var bll = new OrderMake(); var opBll = new OrderProcess(); var effect = 0; foreach (var item in items) { var orderId = Guid.Parse(item); effect += bll.Delete(orderId); effect += opBll.DeleteByOrder(orderId); } return(ResResult.Response(true, MC.M_Save_Ok, "")); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
public ResResultModel GetOrderMakeList(OrderMakeModel model) { try { if (model.PageIndex < 1) { model.PageIndex = 1; } if (model.PageSize < 1) { model.PageSize = 10; } int totalRecord = 0; var bll = new OrderMake(); StringBuilder sqlWhere = null; ParamsHelper parms = null; #region 构造查询条件 new Auth().CreateSearchItem(ref sqlWhere, ref parms); if (!string.IsNullOrWhiteSpace(model.OrderCode)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(500); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and OrderCode like @OrderCode "); var parm = new SqlParameter("@OrderCode", SqlDbType.VarChar, 36); parm.Value = "%" + model.OrderCode + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(model.CustomerCode)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(400); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and CustomerCode like @CustomerCode "); var parm = new SqlParameter("@CustomerCode", SqlDbType.VarChar, 36); parm.Value = "%" + model.CustomerCode + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(model.StaffCode)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and StaffCode like @StaffCode "); var parm = new SqlParameter("@StaffCode", SqlDbType.VarChar, 36); parm.Value = "%" + model.StaffCode + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(model.PayWay)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(200); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and PayWay like @PayWay "); var parm = new SqlParameter("@PayWay", SqlDbType.VarChar, 36); parm.Value = "%" + model.PayWay + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(model.ServiceProduct)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(100); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and ServiceProduct like @ServiceProduct "); var parm = new SqlParameter("@ServiceProduct", SqlDbType.VarChar, 36); parm.Value = "%" + model.ServiceProduct + "%"; parms.Add(parm); } #region 开始与结束日期段 DateTime startDate = DateTime.MinValue; DateTime endDate = DateTime.MinValue; if (!string.IsNullOrWhiteSpace(model.StartDate)) { DateTime.TryParse(model.StartDate, out startDate); } if (!string.IsNullOrWhiteSpace(model.EndDate)) { DateTime.TryParse(model.EndDate, out endDate); } if (startDate != DateTime.MinValue && endDate != DateTime.MinValue) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append(@"and (RecordDate between @StartDate and @EndDate) "); var parm = new SqlParameter("@StartDate", SqlDbType.DateTime); parm.Value = startDate; parms.Add(parm); parm = new SqlParameter("@EndDate", SqlDbType.DateTime); parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59"); parms.Add(parm); } else { if (startDate != DateTime.MinValue) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append(@"and (RecordDate >= @StartDate) "); var parm = new SqlParameter("@StartDate", SqlDbType.DateTime); parm.Value = startDate; parms.Add(parm); } if (endDate != DateTime.MinValue) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append(@"and (RecordDate <= @EndDate) "); var parm = new SqlParameter("@EndDate", SqlDbType.DateTime); parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59"); parms.Add(parm); } } #endregion #endregion var list = bll.GetListByJoin(model.PageIndex, model.PageSize, out totalRecord, sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); return(ResResult.Response(true, "", "{\"total\":" + totalRecord + ",\"rows\":" + JsonConvert.SerializeObject(list) + "}")); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
public string SaveOrderScan(string orderCode, string customerCode, string orderStep, string loginId, string deviceId, string latlng) { try { new CustomException(string.Format("SaveOrderScan--orderCode:{0}--customerCode:{1}--orderStep:{2}--loginId:{3}--deviceId:{4}--latlng:{5}", orderCode, customerCode, orderStep, loginId, deviceId, latlng)); orderCode = orderCode.Trim(); customerCode = customerCode.Trim(); orderStep = orderStep.Trim(); loginId = loginId.Trim(); deviceId = deviceId.Trim(); latlng = latlng.Trim(); var ip = HttpClientHelper.GetClientIp(HttpContext.Current); var currTime = DateTime.Now; var latlngPlace = string.Empty; var ipPlace = string.Empty; var orderId = Guid.Empty; var staffCodeOfTake = string.Empty; var staffCode = string.Empty; var takeTime = DateTime.Parse("1754-01-01"); var reachTime = takeTime; if (orderStep == "已取件") { staffCode = loginId; takeTime = currTime; } else if (orderStep == "已送达") { staffCodeOfTake = loginId; reachTime = currTime; } var oBll = new OrderMake(); var opBll = new OrderProcess(); var effect = 0; var oldOrderInfo = oBll.GetModel(orderCode, customerCode); if (oldOrderInfo != null) { orderId = oldOrderInfo.Id; if (orderStep == "已送达") { oldOrderInfo.StaffCodeOfTake = staffCodeOfTake; oldOrderInfo.ReachTime = reachTime; oBll.Update(oldOrderInfo); } } else { var userId = WebCommon.GetUserId(); if (userId.Equals(Guid.Empty)) { throw new ArgumentException(MC.Login_NotExist); } var appCode = Auth.AppCode; var fuInfo = new FeatureUser().GetModel(userId, "UserProfile"); if (fuInfo != null) { appCode = fuInfo.SiteCode; } orderId = Guid.NewGuid(); oldOrderInfo = new OrderMakeInfo(orderId, appCode, userId, customerCode, orderCode, "", "", "", "", "", "", "", staffCode, staffCodeOfTake, takeTime, reachTime, "", "", 0, 0, 0, 0, 0, "", "", currTime, currTime); effect = oBll.InsertByOutput(oldOrderInfo); } var opInfo = new OrderProcessInfo(Guid.Empty, orderId, loginId, orderStep, "", deviceId, latlng, latlngPlace, ip, ipPlace, currTime, currTime); var oldOpInfo = opBll.GetModel(orderId, orderStep); if (oldOpInfo != null) { opInfo.Id = oldOpInfo.Id; opInfo.Pictures = oldOpInfo.Pictures; if (oldOpInfo.Ip == ip) { opInfo.IpPlace = oldOpInfo.IpPlace; } if (oldOpInfo.Latlng == latlng) { opInfo.LatlngPlace = oldOpInfo.LatlngPlace; } effect = opBll.Update(opInfo); } else { opInfo.Id = Guid.NewGuid(); effect = opBll.InsertByOutput(opInfo); } if (string.IsNullOrWhiteSpace(opInfo.IpPlace) || string.IsNullOrWhiteSpace(opInfo.LatlngPlace)) { new RunQueueAsyn().Insert(new RunQueueInfo(EnumData.EnumRunQueue.BaiduMapRestApi.ToString(), string.Format(@"{{""Latlng"":""{0}"",""Ip"":""{1}"",""OrderProcessId"":""{2}""}}", latlng, ip, opInfo.Id), EnumData.EnumRunQueue.BaiduMapRestApi.ToString(), 0)); } if (effect > 0) { return(ResResult.ResJsonString(true, "", opInfo.Id)); } else { return(ResResult.ResJsonString(false, MC.M_Save_Error, "")); } } catch (Exception ex) { new CustomException("SaveOrderScan--", ex); return(ResResult.ResJsonString(false, ex.Message, "")); } }
public ResResultModel SaveOrderMake(OrderMakeFmModel model) { try { Guid Id = Guid.Empty; if (model.Id != null) { Guid.TryParse(model.Id.ToString(), out Id); } DateTime takeTime = DateTime.MinValue; if (model.TakeTime != null) { DateTime.TryParse(model.TakeTime, out takeTime); } if (takeTime == DateTime.MinValue) { takeTime = DateTime.Parse("1754-01-01"); } DateTime reachTime = DateTime.MinValue; if (!string.IsNullOrWhiteSpace(model.ReachTime)) { DateTime.TryParse(model.ReachTime, out reachTime); } if (reachTime == DateTime.MinValue) { reachTime = DateTime.Parse("1754-01-01"); } int pieceQty = 0; if (!string.IsNullOrWhiteSpace(model.PieceQty)) { int.TryParse(model.PieceQty, out pieceQty); } double weight = 0d; if (!string.IsNullOrWhiteSpace(model.Weight)) { double.TryParse(model.Weight, out weight); } decimal tranPrice = 0; if (!string.IsNullOrWhiteSpace(model.TranPrice)) { decimal.TryParse(model.TranPrice, out tranPrice); } decimal increServicePrice = 0; if (!string.IsNullOrWhiteSpace(model.IncreServicePrice)) { decimal.TryParse(model.IncreServicePrice, out increServicePrice); } decimal totalPrice = 0; if (!string.IsNullOrWhiteSpace(model.TotalPrice)) { decimal.TryParse(model.TotalPrice, out totalPrice); } var currTime = DateTime.Now; var userId = WebCommon.GetUserId(); CustomProfileCommon Profile = new CustomProfileCommon(); var upi = JsonConvert.DeserializeObject <UserProfileInfo>(Profile.UserInfo); var modelInfo = new OrderMakeInfo(Id, upi.SiteCode, userId, model.CustomerCode, model.OrderCode, model.FromName, model.FromAddress, model.FromPhone, model.ToCity, model.ToName, model.ToAddress, model.ToPhone, model.StaffCode, model.StaffCodeOfTake, takeTime, reachTime, model.CargoName, model.ServiceProduct, pieceQty, weight, tranPrice, increServicePrice, totalPrice, model.PayWay, model.Remark, currTime, currTime); var bll = new OrderMake(); int effect = -1; if (Id.Equals(Guid.Empty)) { effect = bll.Insert(modelInfo); } else { var oldInfo = bll.GetModel(Id); modelInfo.RecordDate = oldInfo.RecordDate; effect = bll.Update(modelInfo); } if (effect < 1) { return(ResResult.Response(false, MC.M_Save_Error, "")); } return(ResResult.Response(true, "", "")); } catch (Exception ex) { return(ResResult.Response(false, ex.Message, "")); } }
private void ExportOrderMake(HttpContext context) { var bll = new OrderMake(); StringBuilder sqlWhere = null; ParamsHelper parms = null; #region 构造查询条件 var sOrderCode = context.Request.QueryString["OrderCode"]; var sCustomerCode = context.Request.QueryString["CustomerCode"]; var sStaffCode = context.Request.QueryString["StaffCode"]; var sPayWay = context.Request.QueryString["PayWay"]; var sServiceProduct = context.Request.QueryString["ServiceProduct"]; var sStartDate = context.Request.QueryString["StartDate"]; var sEndDate = context.Request.QueryString["EndDate"]; if (!string.IsNullOrWhiteSpace(sOrderCode)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(500); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and OrderCode like @OrderCode "); var parm = new SqlParameter("@OrderCode", SqlDbType.VarChar, 36); parm.Value = parm.Value = "%" + sOrderCode + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(sCustomerCode)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(400); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and CustomerCode like @CustomerCode "); var parm = new SqlParameter("@CustomerCode", SqlDbType.VarChar, 36); parm.Value = parm.Value = "%" + sCustomerCode + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(sStaffCode)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and StaffCode like @StaffCode "); var parm = new SqlParameter("@StaffCode", SqlDbType.VarChar, 36); parm.Value = parm.Value = "%" + sStaffCode + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(sPayWay)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(200); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and PayWay like @PayWay "); var parm = new SqlParameter("@PayWay", SqlDbType.VarChar, 36); parm.Value = parm.Value = "%" + sPayWay + "%"; parms.Add(parm); } if (!string.IsNullOrWhiteSpace(sServiceProduct)) { if (sqlWhere == null) { sqlWhere = new StringBuilder(100); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append("and ServiceProduct like @ServiceProduct "); var parm = new SqlParameter("@ServiceProduct", SqlDbType.VarChar, 36); parm.Value = parm.Value = "%" + sServiceProduct + "%"; parms.Add(parm); } #region 开始与结束日期段 DateTime startDate = DateTime.MinValue; DateTime endDate = DateTime.MinValue; if (!string.IsNullOrWhiteSpace(sStartDate)) { DateTime.TryParse(sStartDate, out startDate); } if (!string.IsNullOrWhiteSpace(sEndDate)) { DateTime.TryParse(sEndDate, out endDate); } if (startDate != DateTime.MinValue && endDate != DateTime.MinValue) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append(@"and (RecordDate between @StartDate and @EndDate) "); var parm = new SqlParameter("@StartDate", SqlDbType.DateTime); parm.Value = startDate; parms.Add(parm); parm = new SqlParameter("@EndDate", SqlDbType.DateTime); parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59"); parms.Add(parm); } else { if (startDate != DateTime.MinValue) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append(@"and (RecordDate >= @StartDate) "); var parm = new SqlParameter("@StartDate", SqlDbType.DateTime); parm.Value = startDate; parms.Add(parm); } if (endDate != DateTime.MinValue) { if (sqlWhere == null) { sqlWhere = new StringBuilder(300); } if (parms == null) { parms = new ParamsHelper(); } sqlWhere.Append(@"and (RecordDate <= @EndDate) "); var parm = new SqlParameter("@EndDate", SqlDbType.DateTime); parm.Value = DateTime.Parse(endDate.ToString("yyyy-MM-dd") + " 23:59:59"); parms.Add(parm); } } #endregion #endregion var ds = bll.GetExportData(sqlWhere == null ? null : sqlWhere.ToString(), parms == null ? null : parms.ToArray()); var dt = ds.Tables[0]; OpenXmlHelper.Export(context, dt); }