public void DoOrderReceipt(OrderReceiptRecordInfo model)
{
DateTime currTime = DateTime.Now;
OrderReceipt orbBll = new OrderReceipt();
var orbModel = orbBll.GetModel(model.OrderId);
OrderReceiptProduct orpBll = new OrderReceiptProduct();
var orpModel = orpBll.GetModel(model.OrderId, model.ProductId);
orpModel.ReceiptQty += model.Qty;
orpBll.UpdateQty(model.OrderId, model.ProductId, orpModel.ReceiptQty);
StockProduct spBll = new StockProduct();
StockProductInfo spModel = null;
spModel = spBll.GetModel(Guid.Empty, model.ProductId);
if (spModel == null)
{
var stepCode = (int)EnumData.EnumStep.收货;
var stepName = EnumData.EnumStep.收货.ToString();
spModel = new StockProductInfo(Guid.Empty, model.ProductId, model.Qty, orpModel.ReceiptQty, 0, stepCode.ToString(), stepName, EnumData.EnumIsDisable.启用.ToString(), "", "", currTime);
spBll.Insert(spModel);
}
else
{
spModel.UnQty += model.Qty;
spModel.LastUpdatedDate = currTime;
spBll.Update(spModel);
}
}
public IList <OrderReceiptRecordInfo> GetList()
{
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select Id,OrderId,UserId,ProductId,PackageId,StockLocationId,Unit,Qty,LPN,LastUpdatedDate
from OrderReceiptRecord
order by LastUpdatedDate desc " );
IList <OrderReceiptRecordInfo> list = new List <OrderReceiptRecordInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString()))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderReceiptRecordInfo model = new OrderReceiptRecordInfo();
model.Id = reader.GetGuid(0);
model.OrderId = reader.GetGuid(1);
model.UserId = reader.GetGuid(2);
model.ProductId = reader.GetGuid(3);
model.PackageId = reader.GetGuid(4);
model.StockLocationId = reader.GetGuid(5);
model.Unit = reader.GetString(6);
model.Qty = reader.GetDouble(7);
model.LPN = reader.GetString(8);
model.LastUpdatedDate = reader.GetDateTime(9);
list.Add(model);
}
}
}
return(list);
}
public int Update(OrderReceiptRecordInfo model)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"update OrderReceiptRecord set OrderId = @OrderId,UserId = @UserId,ProductId = @ProductId,PackageId = @PackageId,StockLocationId = @StockLocationId,Unit = @Unit,Qty = @Qty,LPN = @LPN,LastUpdatedDate = @LastUpdatedDate
where Id = @Id
" );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier),
new SqlParameter("@OrderId", SqlDbType.UniqueIdentifier),
new SqlParameter("@UserId", SqlDbType.UniqueIdentifier),
new SqlParameter("@ProductId", SqlDbType.UniqueIdentifier),
new SqlParameter("@PackageId", SqlDbType.UniqueIdentifier),
new SqlParameter("@StockLocationId", SqlDbType.UniqueIdentifier),
new SqlParameter("@Unit", SqlDbType.NVarChar, 10),
new SqlParameter("@Qty", SqlDbType.Float),
new SqlParameter("@LPN", SqlDbType.VarChar, 36),
new SqlParameter("@LastUpdatedDate", SqlDbType.DateTime)
};
parms[0].Value = model.Id;
parms[1].Value = model.OrderId;
parms[2].Value = model.UserId;
parms[3].Value = model.ProductId;
parms[4].Value = model.PackageId;
parms[5].Value = model.StockLocationId;
parms[6].Value = model.Unit;
parms[7].Value = model.Qty;
parms[8].Value = model.LPN;
parms[9].Value = model.LastUpdatedDate;
return(SqlHelper.ExecuteNonQuery(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms));
}
public IList <OrderReceiptRecordInfo> GetList(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"select count(*) from OrderReceiptRecord ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms);
if (totalRecords == 0)
{
return(new List <OrderReceiptRecordInfo>());
}
sb.Clear();
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,OrderId,UserId,ProductId,PackageId,StockLocationId,Unit,Qty,LPN,LastUpdatedDate
from OrderReceiptRecord " );
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <OrderReceiptRecordInfo> list = new List <OrderReceiptRecordInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderReceiptRecordInfo model = new OrderReceiptRecordInfo();
model.Id = reader.GetGuid(1);
model.OrderId = reader.GetGuid(2);
model.UserId = reader.GetGuid(3);
model.ProductId = reader.GetGuid(4);
model.PackageId = reader.GetGuid(5);
model.StockLocationId = reader.GetGuid(6);
model.Unit = reader.GetString(7);
model.Qty = reader.GetDouble(8);
model.LPN = reader.GetString(9);
model.LastUpdatedDate = reader.GetDateTime(10);
list.Add(model);
}
}
}
return(list);
}
public IList <OrderReceiptRecordInfo> GetList(string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(500);
sb.Append(@"select Id,OrderId,UserId,ProductId,PackageId,StockLocationId,Unit,Qty,LPN,LastUpdatedDate
from OrderReceiptRecord ");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.Append("order by LastUpdatedDate desc ");
IList <OrderReceiptRecordInfo> list = new List <OrderReceiptRecordInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderReceiptRecordInfo model = new OrderReceiptRecordInfo();
model.Id = reader.GetGuid(0);
model.OrderId = reader.GetGuid(1);
model.UserId = reader.GetGuid(2);
model.ProductId = reader.GetGuid(3);
model.PackageId = reader.GetGuid(4);
model.StockLocationId = reader.GetGuid(5);
model.Unit = reader.GetString(6);
model.Qty = reader.GetDouble(7);
model.LPN = reader.GetString(8);
model.LastUpdatedDate = reader.GetDateTime(9);
list.Add(model);
}
}
}
return(list);
}
public OrderReceiptRecordInfo GetModel(Guid id)
{
OrderReceiptRecordInfo model = null;
StringBuilder sb = new StringBuilder(300);
sb.Append(@"select top 1 Id,OrderId,UserId,ProductId,PackageId,StockLocationId,Unit,Qty,LPN,LastUpdatedDate
from OrderReceiptRecord
where Id = @Id " );
SqlParameter[] parms =
{
new SqlParameter("@Id", SqlDbType.UniqueIdentifier)
};
parms[0].Value = id;
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), parms))
{
if (reader != null)
{
if (reader.Read())
{
model = new OrderReceiptRecordInfo();
model.Id = reader.GetGuid(0);
model.OrderId = reader.GetGuid(1);
model.UserId = reader.GetGuid(2);
model.ProductId = reader.GetGuid(3);
model.PackageId = reader.GetGuid(4);
model.StockLocationId = reader.GetGuid(5);
model.Unit = reader.GetString(6);
model.Qty = reader.GetDouble(7);
model.LPN = reader.GetString(8);
model.LastUpdatedDate = reader.GetDateTime(9);
}
}
}
return(model);
}
public int Update(OrderReceiptRecordInfo model)
{
return(dal.Update(model));
}
public int InsertByOutput(OrderReceiptRecordInfo model)
{
return(dal.InsertByOutput(model));
}
public IList <OrderReceiptRecordInfo> GetListByJoin(int pageIndex, int pageSize, out int totalRecords, string sqlWhere, params SqlParameter[] cmdParms)
{
StringBuilder sb = new StringBuilder(1500);
sb.Append(@"select count(*) from Order_Receipt_Record orr
left join Order_Receipt_Base orb on orb.Id = orr.OrderId
left join Customer c on c.Id = orb.CustomerId
left join Product p on p.Id = orr.ProductId
left join Package pk on pk.Id = orr.PackageId
left join StockLocation sl on sl.Id = orr.StockLocationId
");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
totalRecords = (int)SqlHelper.ExecuteScalar(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms);
if (totalRecords == 0)
{
return(new List <OrderReceiptRecordInfo>());
}
sb.Clear();
int startIndex = (pageIndex - 1) * pageSize + 1;
int endIndex = pageIndex * pageSize;
sb.Append(@"select * from(select row_number() over(order by orr.LastUpdatedDate desc) as RowNumber,
orr.Id,orr.OrderId,orr.UserId,orr.ProductId,orr.PackageId,orr.StockLocationId,orr.Unit,orr.Qty,orr.LPN,orr.LastUpdatedDate
,orb.OrderNum,(case orb.Status when 0 then '其它' when 1 then '新建' else '其它' end) OrderStatus,c.Coded CustomerCode,c.Named CustomerName,p.ProductCode,p.ProductName,pk.PackageCode
,sl.Code StockLocationCode,sl.Named StockLocationName
from Order_Receipt_Record orr
left join Order_Receipt_Base orb on orb.Id = orr.OrderId
left join Customer c on c.Id = orb.CustomerId
left join Product p on p.Id = orr.ProductId
left join Package pk on pk.Id = orr.PackageId
left join StockLocation sl on sl.Id = orr.StockLocationId
");
if (!string.IsNullOrEmpty(sqlWhere))
{
sb.AppendFormat(" where 1=1 {0} ", sqlWhere);
}
sb.AppendFormat(@")as objTable where RowNumber between {0} and {1} ", startIndex, endIndex);
IList <OrderReceiptRecordInfo> list = new List <OrderReceiptRecordInfo>();
using (SqlDataReader reader = SqlHelper.ExecuteReader(SqlHelper.WmsDbConnString, CommandType.Text, sb.ToString(), cmdParms))
{
if (reader != null && reader.HasRows)
{
while (reader.Read())
{
OrderReceiptRecordInfo model = new OrderReceiptRecordInfo();
model.Id = reader.GetGuid(1);
model.OrderId = reader.GetGuid(2);
model.UserId = reader.GetGuid(3);
model.ProductId = reader.GetGuid(4);
model.PackageId = reader.GetGuid(5);
model.StockLocationId = reader.GetGuid(6);
model.Unit = reader.GetString(7);
model.Qty = reader.GetDouble(8);
model.LPN = reader.GetString(9);
model.LastUpdatedDate = reader.GetDateTime(10);
model.OrderNum = reader.IsDBNull(11) ? "" : reader.GetString(11);
model.OrderStatus = reader.IsDBNull(12) ? "" : reader.GetString(12);
model.CustomerCode = reader.IsDBNull(13) ? "" : reader.GetString(13);
model.CustomerName = reader.IsDBNull(14) ? "" : reader.GetString(14);
model.ProductCode = reader.IsDBNull(15) ? "" : reader.GetString(15);
model.ProductName = reader.IsDBNull(16) ? "" : reader.GetString(16);
model.PackageCode = reader.IsDBNull(17) ? "" : reader.GetString(17);
model.StockLocationCode = reader.IsDBNull(18) ? "" : reader.GetString(18);
model.StockLocationName = reader.IsDBNull(19) ? "" : reader.GetString(19);
list.Add(model);
}
}
}
return(list);
}
public ResResultModel SaveOrderReceiptRecord(PdaOrderReceiptRecordModel model)
{
try
{
if (string.IsNullOrWhiteSpace(model.OrderNum))
{
return(ResResult.Response(false, "收货单号不能为空字符串", null));
}
Guid Id = Guid.Empty;
if (model.Id != null)
{
Guid.TryParse(model.Id.ToString(), out Id);
}
Guid orderId = Guid.Empty;
Guid productId = Guid.Empty;
Guid packageId = Guid.Empty;
Guid stockLocationId = Guid.Empty;
if (model.OrderId != null && !string.IsNullOrWhiteSpace(model.OrderId.ToString()))
{
Guid.TryParse(model.OrderId.ToString(), out orderId);
}
if (model.ProductId != null && !string.IsNullOrWhiteSpace(model.ProductId.ToString()))
{
Guid.TryParse(model.ProductId.ToString(), out productId);
}
if (model.PackageId != null && !string.IsNullOrWhiteSpace(model.PackageId.ToString()))
{
Guid.TryParse(model.PackageId.ToString(), out packageId);
}
if (model.StockLocationId != null && !string.IsNullOrWhiteSpace(model.StockLocationId.ToString()))
{
Guid.TryParse(model.StockLocationId.ToString(), out stockLocationId);
}
if (orderId.Equals(Guid.Empty))
{
return(ResResult.Response(false, "参数值不正确，请正确操作", null));
}
if (productId.Equals(Guid.Empty))
{
return(ResResult.Response(false, "参数值不正确，请正确操作", null));
}
if (packageId.Equals(Guid.Empty))
{
return(ResResult.Response(false, "参数值不正确，请正确操作", null));
}
if (stockLocationId.Equals(Guid.Empty))
{
return(ResResult.Response(false, "参数值不正确，请正确操作", null));
}
var currentTime = DateTime.Now;
var modelInfo = new OrderReceiptRecordInfo();
modelInfo.Id = Id;
modelInfo.UserId = Guid.Empty;
modelInfo.OrderId = orderId;
modelInfo.ProductId = productId;
modelInfo.PackageId = packageId;
modelInfo.StockLocationId = stockLocationId;
modelInfo.Unit = model.Unit;
modelInfo.Qty = model.Qty;
modelInfo.LPN = model.LPN;
modelInfo.LastUpdatedDate = currentTime;
var bll = new OrderReceiptRecord();
int effect = -1;
using (TransactionScope scope = new TransactionScope())
{
if (Id.Equals(Guid.Empty))
{
bll.Insert(modelInfo);
bll.DoOrderReceipt(modelInfo);
}
else
{
bll.Update(modelInfo);
bll.DoOrderReceipt(modelInfo);
}
scope.Complete();
effect = 1;
}
if (effect < 1)
{
return(ResResult.Response(false, "调用失败，数据库操作异常", null));
}
return(ResResult.Response(true, "调用成功", ""));
}
catch (Exception ex)
{
return(ResResult.Response(false, ex.Message, null));
}
}
