public IList <OrderMakeInfo> GetList(int pageIndex, int pageSize, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by LastUpdatedDate desc) as RowNumber,
Id,AppCode,UserId,CustomerCode,OrderCode,FromName,FromAddress,FromPhone,ToCity,ToName,ToAddress,ToPhone,StaffCode,StaffCodeOfTake,TakeTime,ReachTime,CargoName,ServiceProduct,PieceQty,Weight,TranPrice,IncreServicePrice,TotalPrice,PayWay,Remark,RecordDate,LastUpdatedDate
from OrderMake " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <OrderMakeInfo> list = new List <OrderMakeInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderMakeInfo model = new OrderMakeInfo();
model.Id = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1);
model.AppCode = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
model.UserId = reader.IsDBNull(3) ? Guid.Empty : reader.GetGuid(3);
model.CustomerCode = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.OrderCode = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
model.FromName = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
model.FromAddress = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
model.FromPhone = reader.IsDBNull(8) ? string.Empty : reader.GetString(8);
model.ToCity = reader.IsDBNull(9) ? string.Empty : reader.GetString(9);
model.ToName = reader.IsDBNull(10) ? string.Empty : reader.GetString(10);
model.ToAddress = reader.IsDBNull(11) ? string.Empty : reader.GetString(11);
model.ToPhone = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
model.StaffCode = reader.IsDBNull(13) ? string.Empty : reader.GetString(13);
model.StaffCodeOfTake = reader.IsDBNull(14) ? string.Empty : reader.GetString(14);
model.TakeTime = reader.IsDBNull(15) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(15);
model.ReachTime = reader.IsDBNull(16) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(16);
model.CargoName = reader.IsDBNull(17) ? string.Empty : reader.GetString(17);
model.ServiceProduct = reader.IsDBNull(18) ? string.Empty : reader.GetString(18);
model.PieceQty = reader.IsDBNull(19) ? 0 : reader.GetInt32(19);
model.Weight = reader.IsDBNull(20) ? 0D : reader.GetDouble(20);
model.TranPrice = reader.IsDBNull(21) ? 0 : reader.GetDecimal(21);
model.IncreServicePrice = reader.IsDBNull(22) ? 0 : reader.GetDecimal(22);
model.TotalPrice = reader.IsDBNull(23) ? 0 : reader.GetDecimal(23);
model.PayWay = reader.IsDBNull(24) ? string.Empty : reader.GetString(24);
model.Remark = reader.IsDBNull(25) ? string.Empty : reader.GetString(25);
model.RecordDate = reader.IsDBNull(26) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(26);
model.LastUpdatedDate = reader.IsDBNull(27) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(27);
list.Add(model);
}
}
}
return(list);
}
public OrderMakeInfo GetModelByJoin(Guid id)
{
OrderMakeInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 Id,UserId,CustomerCode,OrderCode,FromName,FromAddress,FromPhone,ToCity,ToName,ToAddress,ToPhone,StaffCode,StaffCodeOfTake,TakeTime,ReachTime,CargoName,ServiceProduct,PieceQty,Weight,TranPrice,IncreServicePrice,TotalPrice,PayWay,Remark,RecordDate,LastUpdatedDate
from OrderMake
where Id = @Id " );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier)
};
parms[0].Value = id;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new OrderMakeInfo();
model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0);
model.UserId = reader.IsDBNull(1) ? Guid.Empty : reader.GetGuid(1);
model.CustomerCode = reader.IsDBNull(2) ? string.Empty : reader.GetString(2);
model.OrderCode = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
model.FromName = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.FromAddress = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
model.FromPhone = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
model.ToCity = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
model.ToName = reader.IsDBNull(8) ? string.Empty : reader.GetString(8);
model.ToAddress = reader.IsDBNull(9) ? string.Empty : reader.GetString(9);
model.ToPhone = reader.IsDBNull(10) ? string.Empty : reader.GetString(10);
model.StaffCode = reader.IsDBNull(11) ? string.Empty : reader.GetString(11);
model.StaffCodeOfTake = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
model.TakeTime = reader.IsDBNull(13) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(13);
model.ReachTime = reader.IsDBNull(14) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(14);
model.CargoName = reader.IsDBNull(15) ? string.Empty : reader.GetString(15);
model.ServiceProduct = reader.IsDBNull(16) ? string.Empty : reader.GetString(16);
model.PieceQty = reader.IsDBNull(17) ? 0 : reader.GetInt32(17);
model.Weight = reader.IsDBNull(18) ? 0D : reader.GetDouble(18);
model.TranPrice = reader.IsDBNull(19) ? 0 : reader.GetDecimal(19);
model.IncreServicePrice = reader.IsDBNull(20) ? 0 : reader.GetDecimal(20);
model.TotalPrice = reader.IsDBNull(21) ? 0 : reader.GetDecimal(21);
model.PayWay = reader.IsDBNull(22) ? string.Empty : reader.GetString(22);
model.Remark = reader.IsDBNull(23) ? string.Empty : reader.GetString(23);
model.RecordDate = reader.IsDBNull(24) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(24);
model.LastUpdatedDate = reader.IsDBNull(25) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(25);
model.STakeTime = model.TakeTime.ToString("yyyy-MM-dd") == "1754-01-01" ? "" : model.TakeTime.ToString("yyyy-MM-dd HH:mm:ss");
model.SReachTime = model.ReachTime.ToString("yyyy-MM-dd") == "1754-01-01" ? "" : model.ReachTime.ToString("yyyy-MM-dd HH:mm:ss");
}
}
}
return(model);
}
public IList <OrderMakeInfo> GetList()
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select Id,AppCode,UserId,CustomerCode,OrderCode,FromName,FromAddress,FromPhone,ToCity,ToName,ToAddress,ToPhone,StaffCode,StaffCodeOfTake,TakeTime,ReachTime,CargoName,ServiceProduct,PieceQty,Weight,TranPrice,IncreServicePrice,TotalPrice,PayWay,Remark,RecordDate,LastUpdatedDate
from OrderMake
order by LastUpdatedDate desc " );
IList <OrderMakeInfo> list = new List <OrderMakeInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString()))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderMakeInfo model = new OrderMakeInfo();
model.Id = reader.IsDBNull(0) ? Guid.Empty : reader.GetGuid(0);
model.AppCode = reader.IsDBNull(1) ? string.Empty : reader.GetString(1);
model.UserId = reader.IsDBNull(2) ? Guid.Empty : reader.GetGuid(2);
model.CustomerCode = reader.IsDBNull(3) ? string.Empty : reader.GetString(3);
model.OrderCode = reader.IsDBNull(4) ? string.Empty : reader.GetString(4);
model.FromName = reader.IsDBNull(5) ? string.Empty : reader.GetString(5);
model.FromAddress = reader.IsDBNull(6) ? string.Empty : reader.GetString(6);
model.FromPhone = reader.IsDBNull(7) ? string.Empty : reader.GetString(7);
model.ToCity = reader.IsDBNull(8) ? string.Empty : reader.GetString(8);
model.ToName = reader.IsDBNull(9) ? string.Empty : reader.GetString(9);
model.ToAddress = reader.IsDBNull(10) ? string.Empty : reader.GetString(10);
model.ToPhone = reader.IsDBNull(11) ? string.Empty : reader.GetString(11);
model.StaffCode = reader.IsDBNull(12) ? string.Empty : reader.GetString(12);
model.StaffCodeOfTake = reader.IsDBNull(13) ? string.Empty : reader.GetString(13);
model.TakeTime = reader.IsDBNull(14) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(14);
model.ReachTime = reader.IsDBNull(15) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(15);
model.CargoName = reader.IsDBNull(16) ? string.Empty : reader.GetString(16);
model.ServiceProduct = reader.IsDBNull(17) ? string.Empty : reader.GetString(17);
model.PieceQty = reader.IsDBNull(18) ? 0 : reader.GetInt32(18);
model.Weight = reader.IsDBNull(19) ? 0D : reader.GetDouble(19);
model.TranPrice = reader.IsDBNull(20) ? 0 : reader.GetDecimal(20);
model.IncreServicePrice = reader.IsDBNull(21) ? 0 : reader.GetDecimal(21);
model.TotalPrice = reader.IsDBNull(22) ? 0 : reader.GetDecimal(22);
model.PayWay = reader.IsDBNull(23) ? string.Empty : reader.GetString(23);
model.Remark = reader.IsDBNull(24) ? string.Empty : reader.GetString(24);
model.RecordDate = reader.IsDBNull(25) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(25);
model.LastUpdatedDate = reader.IsDBNull(26) ? DateTime.Parse("1754-01-01") : reader.GetDateTime(26);
list.Add(model);
}
}
}
return(list);
}
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, ""));
}
}
public int Update(OrderMakeInfo model)
{
return(dal.Update(model));
}
public int InsertByOutput(OrderMakeInfo model)
{
return(dal.InsertByOutput(model));
}
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 int InsertByOutput(OrderMakeInfo model)
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"insert into OrderMake (Id,AppCode,UserId,CustomerCode,OrderCode,FromName,FromAddress,FromPhone,ToCity,ToName,ToAddress,ToPhone,StaffCode,StaffCodeOfTake,TakeTime,ReachTime,CargoName,ServiceProduct,PieceQty,Weight,TranPrice,IncreServicePrice,TotalPrice,PayWay,Remark,RecordDate,LastUpdatedDate)
values
(@Id,@AppCode,@UserId,@CustomerCode,@OrderCode,@FromName,@FromAddress,@FromPhone,@ToCity,@ToName,@ToAddress,@ToPhone,@StaffCode,@StaffCodeOfTake,@TakeTime,@ReachTime,@CargoName,@ServiceProduct,@PieceQty,@Weight,@TranPrice,@IncreServicePrice,@TotalPrice,@PayWay,@Remark,@RecordDate,@LastUpdatedDate)
" );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@AppCode", SqlDbType.Char, 6),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@CustomerCode", SqlDbType.VarChar, 36),
new SqlParameter("@OrderCode", SqlDbType.VarChar, 36),
new SqlParameter("@FromName", SqlDbType.NVarChar, 50),
new SqlParameter("@FromAddress", SqlDbType.NVarChar, 256),
new SqlParameter("@FromPhone", SqlDbType.VarChar, 20),
new SqlParameter("@ToCity", SqlDbType.NVarChar, 50),
new SqlParameter("@ToName", SqlDbType.NVarChar, 50),
new SqlParameter("@ToAddress", SqlDbType.NVarChar, 256),
new SqlParameter("@ToPhone", SqlDbType.VarChar, 20),
new SqlParameter("@StaffCode", SqlDbType.VarChar, 36),
new SqlParameter("@StaffCodeOfTake", SqlDbType.VarChar, 36),
new SqlParameter("@TakeTime", SqlDbType.DateTime),
new SqlParameter("@ReachTime", SqlDbType.DateTime),
new SqlParameter("@CargoName", SqlDbType.NVarChar, 256),
new SqlParameter("@ServiceProduct", SqlDbType.NVarChar, 256),
new SqlParameter("@PieceQty", SqlDbType.Int),
new SqlParameter("@Weight", SqlDbType.Float),
new SqlParameter("@TranPrice", SqlDbType.Decimal),
new SqlParameter("@IncreServicePrice", SqlDbType.Decimal),
new SqlParameter("@TotalPrice", SqlDbType.Decimal),
new SqlParameter("@PayWay", SqlDbType.NVarChar, 30),
new SqlParameter("@Remark", SqlDbType.NVarChar, 256),
new SqlParameter("@RecordDate", SqlDbType.DateTime),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.AppCode;
parms[2].Value = model.UserId;
parms[3].Value = model.CustomerCode;
parms[4].Value = model.OrderCode;
parms[5].Value = model.FromName;
parms[6].Value = model.FromAddress;
parms[7].Value = model.FromPhone;
parms[8].Value = model.ToCity;
parms[9].Value = model.ToName;
parms[10].Value = model.ToAddress;
parms[11].Value = model.ToPhone;
parms[12].Value = model.StaffCode;
parms[13].Value = model.StaffCodeOfTake;
parms[14].Value = model.TakeTime;
parms[15].Value = model.ReachTime;
parms[16].Value = model.CargoName;
parms[17].Value = model.ServiceProduct;
parms[18].Value = model.PieceQty;
parms[19].Value = model.Weight;
parms[20].Value = model.TranPrice;
parms[21].Value = model.IncreServicePrice;
parms[22].Value = model.TotalPrice;
parms[23].Value = model.PayWay;
parms[24].Value = model.Remark;
parms[25].Value = model.RecordDate;
parms[26].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.AfdDbConnString, CommandType.Text, sb.ToString(), parms));
}
