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);
}
