public List <string> GetAmountQtySql(T_StockInfo model, ref string NewSerialNo, ref string NewBaecode)
{
//int barcodeID = GetTableID("Seq_Outbarcode_Id");
//string SeqSerialNo = base.GetTableID("SEQ_SERIAL_NO").ToString();
//NewSerialNo = System.DateTime.Now.ToString("yyyyMMdd") + SeqSerialNo.PadLeft(6, '0');
List <string> lstSql = new List <string>();
var seed = Guid.NewGuid().GetHashCode();
//NewSerialNo = DateTime.Now.ToString("yyMMddHHmmss") + new Random(seed).Next(0, 99999999).ToString().PadLeft(8, '0') + "01";
NewSerialNo = "1" + DateTime.Now.ToString("MMdd") + getSqu(Guid.NewGuid().ToString("N"));
//"1@" + barcodelistnew[i].StrongHoldCode + "@" + barcodelistnew[i].MaterialNo + "@" + barcodelistnew[i].BatchNo + "@" + barcodelistnew[i].Qty + "@" + barcodelistnew[i].SerialNo;
//NewSerialNo = DateTime.Now.ToString("yyMMdd") + "77" + new Random(seed).Next(0, 999999).ToString().PadLeft(6, '0');//奥碧虹
string strSqlCount = "SELECT COUNT(1) from T_OUTBARCODE where serialno = '" + NewSerialNo + "'";
int i = base.GetScalarBySql(strSqlCount).ToInt32();
if (i > 0)
{
NewSerialNo = "1" + DateTime.Now.ToString("MMdd") + getSqu(Guid.NewGuid().ToString("N"));
//NewSerialNo = DateTime.Now.ToString("yyMMddHHmmss") + new Random(seed).Next(0, 99999999).ToString().PadLeft(8, '0') + "01";
//NewSerialNo = DateTime.Now.ToString("yyMMdd") + "77" + new Random(seed).Next(0, 999999).ToString().PadLeft(6, '0');//奥碧虹
}
//string BarCode = "1@" + model.StrongHoldCode + "@" + model.MaterialNo + "@" + model.BatchNo + "@" + model.Qty + "@" + NewSerialNo;
string BarCode = "2@" + model.MaterialNo + "@" + model.Qty + "@" + NewSerialNo;
NewBaecode = BarCode;
//string BarCode =""+model.BarCodeType+"" + model.MaterialNo.PadLeft(16, '0') + "" + model.BatchNo.PadLeft(11, '0') + ""+NewSerialNo+"";
string strSql = "insert into t_Outbarcode ( spec,Voucherno, Rowno, Erpvoucherno, Vouchertype, Materialno, Materialdesc, Cuscode," +
"Cusname, Supcode, Supname, Outpackqty, Innerpackqty, Voucherqty, Qty, Nopack, Printqty, Barcode, " +
"Barcodetype, Serialno, Barcodeno, Outcount, Innercount, Mantissaqty, Isrohs, Outbox_Id, " +
"Inner_Id, Abatchqty, Isdel, Creater, Createtime, Materialnoid, Strongholdcode, " +
"Strongholdname, Companycode, Productdate, Supprdbatch, Supprddate, Productbatch, Edate, Storecondition," +
"Specialrequire, Batchno, Barcodemtype, Rownodel, Protectway, Boxweight, Unit, Labelmark, Boxdetail, Matebatch," +
"Mixdate, Relaweight,Ean,ProjectNo,TracNo,erpwarehousename)" +
"select spec,voucherno,rowno,erpvoucherno,vouchertype, Materialno, Materialdesc, Cuscode," +
"Cusname, Supcode, Supname, Outpackqty, Innerpackqty, Voucherqty, '" + model.AmountQty + "',Nopack, Printqty," +
"'" + BarCode + "'," +
"Barcodetype, '" + NewSerialNo + "', Barcodeno, Outcount, Innercount, Mantissaqty, Isrohs,'" + model.ID + "',Inner_Id, " +
"Abatchqty, Isdel, Creater, getdate(), Materialnoid, Strongholdcode, " +
"Strongholdname, Companycode, Productdate, Supprdbatch, Supprddate, Productbatch, Edate, Storecondition," +
"Specialrequire, Batchno, Barcodemtype, Rownodel, Protectway, Boxweight, Unit, Labelmark, Boxdetail, Matebatch," +
"Mixdate, Relaweight,ean,ProjectNo,TracNo,erpwarehousename from t_Outbarcode where serialno = '" + model.SerialNo + "'";
lstSql.Add(strSql);
if (model.lstJBarCode != null && model.lstJBarCode.Count > 0)
{
foreach (var item in model.lstJBarCode)
{
strSql = "UPDATE T_OUTBARCODE set fserialno = '" + BarCode + "',qty = qty - '" + model.AmountQty + "' WHERE barcode = '" + item.Barcode + "'";
lstSql.Add(strSql);
}
}
return(lstSql);
}
//扫描序列号和EAN
public JsonResult getbarcode(T_StockInfo model)
{
if (currentUser == null)
{
return(Json(new { state = false, obj = "Cookie失效，重新登陆！" }, JsonRequestBehavior.AllowGet));
}
model.ScanType = 3;
List <T_StockInfo> modelList = new List <T_StockInfo>();
List <T_OutStockDetailInfo> outStockDetailList = new List <T_OutStockDetailInfo>();
string strError = "";
T_OutStockDetail_Func fun = new T_OutStockDetail_Func();
int ID = 0;
bool isSuccess = fun.GetReviewStockModel(currentUser, model, ref modelList, ref outStockDetailList, ref ID, ref strError);
if (isSuccess && model.Barcode.Contains("@") && outStockDetailList.Count > 0)
{
for (int i = 0; i < outStockDetailList.Count; i++)
{
if (outStockDetailList[i].ID == ID)
{
outStockDetailList[i].isLight = true;
}
else
{
outStockDetailList[i].isLight = false;
}
}
return(Json(new { state = isSuccess, obj = outStockDetailList, type = "1" }, JsonRequestBehavior.AllowGet));
}
if (isSuccess && !model.Barcode.Contains("@") && modelList.Count > 0)
{
return(Json(new { state = isSuccess, obj = modelList, type = "2" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { state = isSuccess, obj = strError }, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 写入条码表
/// </summary>
/// <param name="model"></param>
/// <param name="NewSerialNo"></param>
/// <returns></returns>
public string GetAmountQtySql(T_StockInfo model, ref string NewSerialNo)
{
int barcodeID = GetTableID("Seq_Outbarcode_Id");
string SeqSerialNo = base.GetTableID("SEQ_SERIAL_NO").ToString();
NewSerialNo = System.DateTime.Now.ToString("yyyyMMdd") + SeqSerialNo.PadLeft(6, '0');
string strSql = "insert into t_Outbarcode (Id, Voucherno, Rowno, Erpvoucherno, Vouchertype, Materialno, Materialdesc, Cuscode," +
"Cusname, Supcode, Supname, Outpackqty, Innerpackqty, Voucherqty, Qty, Nopack, Printqty, Barcode, " +
"Barcodetype, Serialno, Barcodeno, Outcount, Innercount, Mantissaqty, Isrohs, Outbox_Id, " +
"Inner_Id, Abatchqty, Isdel, Creater, Createtime, Materialnoid, Strongholdcode, " +
"Strongholdname, Companycode, Productdate, Supprdbatch, Supprddate, Productbatch, Edate, Storecondition," +
"Specialrequire, Batchno, Barcodemtype, Rownodel, Protectway, Boxweight, Unit, Labelmark, Boxdetail, Matebatch," +
"Mixdate, Relaweight,Ean)" +
"select '" + barcodeID + "',voucherno,rowno,erpvoucherno,vouchertype, Materialno, Materialdesc, Cuscode," +
"Cusname, Supcode, Supname, Outpackqty, Innerpackqty, Voucherqty, '" + model.AmountQty + "',Nopack, Printqty," +
"Barcodetype || '@' || Strongholdcode || '@' || materialno || '@' || ean || '@' || to_char(edate,'yyyy/MM/dd') || '@'|| Batchno ||'@' || " + model.AmountQty + " || '@' || '" + NewSerialNo + "'," +
"Barcodetype, '" + NewSerialNo + "', Barcodeno, Outcount, Innercount, Mantissaqty, Isrohs,'" + model.ID + "',Inner_Id, " +
"Abatchqty, Isdel, Creater, getdate(), Materialnoid, Strongholdcode, " +
"Strongholdname, Companycode, Productdate, Supprdbatch, Supprddate, Productbatch, Edate, Storecondition," +
"Specialrequire, Batchno, Barcodemtype, Rownodel, Protectway, Boxweight, Unit, Labelmark, Boxdetail, Matebatch," +
"Mixdate, Relaweight,ean from t_Outbarcode where serialno = '" + model.SerialNo + "'";
return(strSql);
}
//装箱SQL
private List <string> GetBoxAmountSql(UserModel userModel, T_StockInfo OldModel, T_StockInfo NewModel)
{
List <string> lstSql = new List <string>();
string strSql = string.Empty;
strSql = "update t_stock set Qty = Qty + '" + NewModel.Qty + "' where serialno = '" + OldModel.SerialNo + "'";
lstSql.Add(strSql);
strSql = GetStockTransSql(userModel, NewModel);
lstSql.Add(strSql);
strSql = "delete t_stock where serialno = '" + NewModel.SerialNo + "'";
lstSql.Add(strSql);
if (!string.IsNullOrEmpty(OldModel.PalletNo))
{
strSql = "update t_Palletdetail set Qty = qty + '" + NewModel.Qty + "' where serialno = '" + OldModel.SerialNo + "'";
lstSql.Add(strSql);
strSql = "delete t_Palletdetail where Serialno = '" + NewModel.SerialNo + "' and Qty = 0";
lstSql.Add(strSql);
}
return(lstSql);
}
/// <summary>
/// 质检扫描--------------add by cym 2017-12-14
/// </summary>
/// <param name="BarCode"></param>
/// <returns></returns>
public string GetOutBarCodeInfoForQuanADF_Product(string BarCode)
{
BaseMessage_Model <T_StockInfo> model = new BaseMessage_Model <T_StockInfo>();
try
{
string strError = string.Empty;
string SerialNo = string.Empty;
string BarCodeType = string.Empty;
T_OutBarCodeInfo BarCodeInfo = new T_OutBarCodeInfo();
T_OutBarCode_Func tfunc = new T_OutBarCode_Func();
//验证条码正确性
if (tfunc.GetSerialNoByBarCode(BarCode, ref SerialNo, ref BarCodeType, ref strError) == false)
{
model.HeaderStatus = "E";
model.Message = strError;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
if (BarCodeType == "2")
{
model.HeaderStatus = "E";
model.Message = "托盘条码不支持整托操作！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
T_StockInfo stockModel = new T_StockInfo();
BarCodeInfo.SerialNo = SerialNo;
//读取条码库存数据
if (GetBarCodeIsStock(BarCodeInfo.SerialNo, ref stockModel, ref strError) == false)
{
model.HeaderStatus = "E";
model.Message = strError;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
//update by cym 2018-1-4
if (stockModel.Status != 1)
{
model.HeaderStatus = "E";
model.Message = "该条码不是待检状态，不能取样！";
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
model.HeaderStatus = "S";
model.ModelJson = stockModel;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
catch (Exception ex)
{
model.HeaderStatus = "E";
model.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <T_StockInfo> >(model));
}
}
/// <summary>
/// 获取物料根据拣货规则以及批次对应的楼层，以及物料分类对应的主管
/// </summary>
/// <param name="modelList"></param>
/// <param name="pickRuleModelList"></param>
/// <param name="strError"></param>
/// <returns></returns>
private bool GetFloorForModelList(ref List <T_OutStockCreateInfo> modelList, List <T_PickRuleInfo> pickRuleModelList, List <T_UserGroupInfo> userGroupList, ref string strError)
{
bool bSucc = false;
string strBatchNo = string.Empty;
int pickRule = 0;
string PickLeaderUserNo = string.Empty;
string PickGroupNo = string.Empty;
T_PickRuleInfo _pickModel = new T_PickRuleInfo();
T_UserGroupInfo _userGroupModel = new T_UserGroupInfo();
T_StockInfo _stockModel = new T_StockInfo();
foreach (var item in modelList)
{
strBatchNo = item.IsSpcBatch == "Y" ? item.FromBatchno : string.Empty;
_pickModel = pickRuleModelList == null ? null : pickRuleModelList.Find(t => t.MaterialClassCode == item.MainTypeCode);
if (_pickModel != null)
{
pickRule = _pickModel.PickRuleCode;
}
_userGroupModel = userGroupList == null ? null: userGroupList.FindLast(t => t.MainTypeCode == item.MainTypeCode && t.WarehouseNo.Contains(item.FromErpWareHouse));
if (_userGroupModel == null)
{
strError = "请先设置物料所属分类拣货组长！" + "订单号：" + item.ErpVoucherNo + " 物料编码：" + item.MaterialNo + " 项次：" + item.RowNo + " 项序:" + item.RowNoDel + "";
bSucc = false;
break;
}
else
{
PickLeaderUserNo = _userGroupModel.PickLeaderUserNo; //拣货组长
PickGroupNo = _userGroupModel.PickGroupNo; //拣货组
}
if (GetFloorByMaterialNoID(item.MaterialNoID, strBatchNo, pickRule, ref _stockModel, ref strError, item.StrongHoldCode, item.FromErpWareHouse) == false)
{
strError = strError + "订单号：" + item.ErpVoucherNo + " 物料编码：" + item.MaterialNo + " 项次：" + item.RowNo + " 项序:" + item.RowNoDel + "";
bSucc = false;
break;
}
else
{
item.PickLeaderUserNo = PickLeaderUserNo;
item.PickGroupNo = PickGroupNo;
item.FloorType = _stockModel.FloorType;
item.HeightArea = _stockModel.HeightArea;
bSucc = true;
}
}
return(bSucc);
}
private string GetStockTransSql(UserModel user, T_StockInfo model)
{
string strSql = "INSERT INTO t_Stocktrans ( Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, Status, Isdel, Creater, Createtime, " +
"Batchno, Sn, Oldstockid, Taskdetailesid, Checkid, Transferdetailsid, Unit, Unitname, Palletno, Receivestatus, Islimitstock, " +
"Materialnoid, Strongholdcode, Strongholdname, Companycode, Edate, Supcode, Supname, Productdate, Supprdbatch, Supprddate, Isquality)" +
"SELECT A.Barcode,A.Serialno,A.Materialno,A.Materialdesc,A.Warehouseid,A.Houseid,A.Areaid,A.Qty, " +
"A.Status,A.Isdel,'" + user.UserName + "',A.Createtime,A.Batchno,A.Sn,a.Oldstockid,A.Taskdetailesid,A.Checkid,A.Transferdetailsid,A.Unit,A.Unitname,A.Palletno,A.Receivestatus," +
"A.Islimitstock,A.Materialnoid,A.Strongholdcode,A.Strongholdname,A.Companycode,A.Edate,A.Supcode,A.Supname,A.Productdate,A.Supprdbatch," +
"A.Supprddate,A.Isquality FROM T_STOCK A WHERE A.Serialno = '" + model.SerialNo + "'";
return(strSql);
}
private string GetStockPRDSql(UserModel user, T_StockInfo model)
{
string strSql = "INSERT INTO t_stockprd (Id, Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, Status, Isdel, Creater, Createtime, " +
"Batchno, Sn, Oldstockid, Taskdetailesid, Checkid, Transferdetailsid, Unit, Unitname, Palletno, Receivestatus, Islimitstock, " +
"Materialnoid, Strongholdcode, Strongholdname, Companycode, Edate, Supcode, Supname, Productdate, Supprdbatch, Supprddate, Isquality)" +
"SELECT SEQ_STOCKPRD_ID.Nextval, Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, " +
" Status, Isdel,'" + user.UserName + "', Createtime, Batchno, Sn, Oldstockid, Taskdetailesid, Checkid, Transferdetailsid, Unit, Unitname, Palletno, Receivestatus," +
" Islimitstock, Materialnoid, Strongholdcode, Strongholdname, Companycode, Edate, Supcode, Supname, Productdate, Supprdbatch," +
" Supprddate, Isquality FROM T_STOCK A WHERE Serialno = '" + model.SerialNo + "'";
return(strSql);
}
public override void GetOutStockCreateSplitList(ref List <T_OutStockCreateInfo> modelList, List <Stock.T_StockInfo> stockList)
{
List <T_OutStockCreateInfo> newModelScatList = new List <T_OutStockCreateInfo>();
List <T_StockInfo> newStockList = new List <T_StockInfo>();
//根据零拣区汇总库存数量
newStockList = StockGroupBy(stockList);
T_StockInfo itemScatModel = new T_StockInfo();
foreach (var item in modelList)
{
T_OutStockCreateInfo modelScat = new T_OutStockCreateInfo();
//单个物料零散区总库存数量
itemScatModel = stockList.Find(t => t.MaterialNoID == item.MaterialNoID &&
t.StrongHoldCode == item.StrongHoldCode && t.HouseProp == 2 && t.Qty > 0);
//零拣区没有库存，直接到整箱区
if (itemScatModel == null)
{
item.HouseProp = 1;
newModelScatList.Add(item);
continue;
}
if (item.RemainQty.ToDecimal() <= itemScatModel.Qty)
{
itemScatModel.Qty = itemScatModel.Qty - item.RemainQty.ToDecimal();
item.HouseProp = itemScatModel.HouseProp;
newModelScatList.Add(item);
}
else if (item.RemainQty > itemScatModel.Qty)
{
itemScatModel.Qty = 0;
modelScat = item;
modelScat.HouseProp = itemScatModel.HouseProp;
modelScat.RemainQty = item.RemainQty - itemScatModel.Qty;
newModelScatList.Add(modelScat);
//剩余的拣货数量拆分到整箱区
T_OutStockCreateInfo modelPack = new T_OutStockCreateInfo();
modelPack = item;
modelPack.HouseProp = 1;
modelPack.RemainQty = item.RemainQty - modelScat.RemainQty;
newModelScatList.Add(modelPack);
}
}
modelList = newModelScatList;
}
public string GetAmountQtyInsertPalletSql(T_StockInfo model, UserModel user, string NewSerialNo, string PalletNo)
{
int palletDetailID = GetTableID("Seq_Pallet_Detail_Id");
string strSql = "insert into t_Palletdetail(Id, Headerid, Palletno, Materialno, Materialdesc, Serialno, Creater, Createtime, " +
"Isdel, Rowno, Voucherno, Erpvoucherno, Partno, Materialnoid, Qty, Barcode, Strongholdcode, " +
"Strongholdname, Companycode, Batchno, Rownodel)" +
"select '" + palletDetailID + "',(select id from t_Pallet where palletno = '" + PalletNo + "'),'" + PalletNo + "',Materialno, Materialdesc, Serialno,'" + user.UserNo + "', getdate()," +
"'1',Rowno, Voucherno, Erpvoucherno, '" + model.PalletNo + "', Materialnoid, Qty, Barcode, Strongholdcode, " +
"Strongholdname, Companycode, Batchno, Rownodel from t_Outbarcode where serialno = '" + NewSerialNo + "'";
return(strSql);
}
/// <summary>
/// 根据任务ID获取任务数据
/// </summary>
/// <param name="TaskNo"></param>
/// <returns></returns>
public BaseMessage_Model <T_InStockTaskDetailsInfo> GetInTaskDetailListByHeaderID(string TaskNo, UserModel user, List <T_InStockDetailInfo> lstModel)
{
int HeadID = 0;
bool bSucc = false;
string strErrMsg = string.Empty;
BaseMessage_Model <T_InStockTaskDetailsInfo> baseMessage = new BaseMessage_Model <T_InStockTaskDetailsInfo>();
T_InTaskDetails_DB tdb = new T_InTaskDetails_DB();
T_InTaskDetails_Func tfunc = new T_InTaskDetails_Func();
T_AreaInfo areaModel = new T_AreaInfo();
T_Area_Func areaFunc = new T_Area_Func();
HeadID = tdb.GetIDByTaskNo(TaskNo);
List <T_InStockTaskDetailsInfo> lstTaskDetail = new List <T_InStockTaskDetailsInfo>();
bSucc = tfunc.GetModelListByHeaderID(ref lstTaskDetail, HeadID, ref strErrMsg);
if (bSucc == false)
{
baseMessage.HeaderStatus = "E";
baseMessage.Message = strErrMsg;
return(baseMessage);
}
//任务表体数据
foreach (var item in lstTaskDetail)
{
item.lstStockInfo = new List <T_StockInfo>();
//根据任务表体数据查找收货数据，存在多行
var lstInDetail = lstModel.FindAll(t => t.MaterialNo == item.MaterialNo);
foreach (var itemInDetail in lstInDetail)
{
areaFunc.GetAreaModelBySql(0, itemInDetail.lstSerialNo.FirstOrDefault().AreaNo, ref areaModel, ref strErrMsg);
foreach (var itemSerialNo in itemInDetail.lstSerialNo)
{
T_StockInfo stock = new T_StockInfo();
stock.SerialNo = itemSerialNo.SerialNo;
item.lstStockInfo.Add(stock);
}
}
item.AreaID = areaModel.ID;
item.WarehouseID = areaModel.WarehouseID;
item.HouseID = areaModel.HouseID;
item.ScanQty = item.lstStockInfo.Count;
}
string Result = tfunc.SaveModelListSqlToDBADF(JSONHelper.ObjectToJson <UserModel>(user), JSONHelper.ObjectToJson <List <T_InStockTaskDetailsInfo> >(lstTaskDetail));
return(JSONHelper.JsonToObject <BaseMessage_Model <T_InStockTaskDetailsInfo> >(Result));
}
/// <summary>
/// 写入库存新条码信息
/// </summary>
/// <param name="model"></param>
/// <param name="user"></param>
/// <param name="NewSerialNo"></param>
/// <returns></returns>
public string GetAmountQtyInsertStockSql(T_StockInfo model, UserModel user, string NewSerialNo)
{
int stockID = GetTableID("Seq_Stock_Id");
string strSql = "insert into t_Stock(Id, Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, Status, Isdel," +
"Creater, Createtime, Batchno, Oldstockid, Unit, Unitname, " +
"Receivestatus, Islimitstock, Materialnoid, Strongholdcode, Strongholdname, Companycode," +
"Edate, Supcode, Supname, Productdate, Supprdbatch, Supprddate, Isquality,Stocktype,ean)" +
"select '" + stockID + "',barcode,serialno,materialno,Materialdesc,'" + model.WareHouseID + "', '" + model.HouseID + "', '" + model.AreaID + "', Qty ,'" + model.Status + "','1'," +
"'" + user.UserNo + "',getdate(),batchno,'" + model.ID + "',unit,'" + model.UnitName + "','" + model.ReceiveStatus + "','" + model.IsLimitStock + "',Materialnoid," +
"Strongholdcode, Strongholdname, Companycode,Edate, Supcode, Supname, Productdate, Supprdbatch,Supprddate, '" + model.IsQuality + "',1,ean from t_Outbarcode where serialno = '" + NewSerialNo + "'";
return(strSql);
}
private List <string> GetUnBoxAmountSql(T_StockInfo model, UserModel userModel, ref string NewSerialNo)
{
T_QualityDetail_DB _db = new T_QualityDetail_DB();
string strSql = string.Empty;
List <string> lstSql = new List <string>();
//strSql = _db.GetAmountQtySql(model, ref NewSerialNo);//生成条码表拆零条码
string NewBaecode = "";
lstSql.AddRange(_db.GetAmountQtySql(model, ref NewSerialNo, ref NewBaecode));
strSql = _db.GetAmountQtyInsertStockSql(model, userModel, NewSerialNo);
lstSql.Add(strSql);
strSql = "update t_stock set Qty = Qty - '" + model.AmountQty + "' where serialno = '" + model.SerialNo + "'";
lstSql.Add(strSql);
strSql = "update t_outbarcode set Qty = Qty - '" + model.AmountQty + "' where serialno = '" + model.SerialNo + "'";
lstSql.Add(strSql);
//被拆零的记录在出入库记录表
strSql = GetTaskTransSql_update(userModel, model, model.AmountQty);
lstSql.Add(strSql);
//拆零出来的记录在出入库记录表
strSql = GetTaskTransSql_update1(userModel, model, model.AmountQty, NewSerialNo, NewBaecode);
lstSql.Add(strSql);
strSql = "delete t_stock where serialno = '" + model.SerialNo + "' and qty =0";
lstSql.Add(strSql);
//拆零的条码需要把托盘拆掉
if (!string.IsNullOrEmpty(model.PalletNo))
{
//strSql = _db.GetAmountQtyInsertPalletSql(model, userModel, NewSerialNo, model.PalletNo);
//lstSql.Add(strSql);
strSql = "update t_Palletdetail set Qty = qty - '" + model.AmountQty + "' where barcode = '" + model.Barcode + "'";
lstSql.Add(strSql);
strSql = "delete t_Palletdetail where barcode = '" + model.Barcode + "' and Qty = 0";
lstSql.Add(strSql);
strSql = "delete t_Pallet where palletno = '" + model.PalletNo + "' and (select count(1) from t_Palletdetail where palletno = '" + model.PalletNo + "')=0";
lstSql.Add(strSql);
}
return(lstSql);
}
private T_OutStockTaskDetailsInfo CreateNewOutStockModelToADF(T_StockInfo stockModel, T_OutStockTaskDetailsInfo itemModel)
{
T_OutStockTaskDetailsInfo model = new T_OutStockTaskDetailsInfo();
model.ID = itemModel.ID;
model.HeaderID = itemModel.HeaderID;
model.CompanyCode = itemModel.CompanyCode;
model.StrongHoldCode = itemModel.StrongHoldCode;
model.StrongHoldName = itemModel.StrongHoldName;
model.MaterialNo = itemModel.MaterialNo;
model.MaterialDesc = itemModel.MaterialDesc;
model.MaterialNoID = itemModel.MaterialNoID;
model.ErpVoucherNo = itemModel.ErpVoucherNo;
model.VoucherNo = itemModel.VoucherNo;
model.TaskNo = itemModel.TaskNo;
model.TaskQty = itemModel.TaskQty;
model.RemainQty = itemModel.RemainQty;
model.RePickQty = itemModel.RePickQty;
model.AreaNo = stockModel.AreaNo;
model.HeightArea = itemModel.HeightArea;
model.FloorType = stockModel.FloorType;
model.IsSpcBatch = itemModel.IsSpcBatch;
model.ScanQty = itemModel.ScanQty;
model.FromBatchNo = itemModel.FromBatchNo;
model.FromErpAreaNo = itemModel.FromErpAreaNo;
model.FromErpWarehouse = itemModel.FromErpWarehouse;
model.ToBatchNo = stockModel.BatchNo;//itemModel.ToBatchNo
model.ToErpAreaNo = itemModel.ToErpAreaNo;
model.ToErpWarehouse = itemModel.ToErpWarehouse;
model.TaskType = itemModel.TaskType;
model.DepartmentCode = itemModel.DepartmentCode;
model.DepartmentName = itemModel.DepartmentName;
model.EDate = itemModel.EDate;
model.PickGroupNo = itemModel.PickGroupNo;
model.PickLeaderUserNo = itemModel.PickLeaderUserNo;
model.Status = itemModel.Status;
model.StrStatus = itemModel.StrStatus;
model.StrVoucherType = itemModel.StrVoucherType;
model.StockQty = stockModel.Qty;
model.SortArea = stockModel.SortArea;
model.ERPVoucherType = itemModel.ERPVoucherType;
model.Unit = itemModel.Unit;
model.BatchNo = stockModel.BatchNo;
model.HouseProp = itemModel.HouseProp;
model.RowNo = itemModel.RowNo;
return(model);
}
private string GetTaskTransSql_update(UserModel user, T_StockInfo model, decimal qty)
{
int id = base.GetTableIDBySqlServer("T_TASKTRANSDETAIL");
string strSql = "insert into t_tasktrans( Serialno,towarehouseID,TohouseID, ToareaID, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,batchno,Fromareaid,Fromwarehouseid,Fromhouseid,barcode,status,materialdoc,houseprop,ean)" +
" values ('" + model.SerialNo + "',0,0,0," +
" '" + model.MaterialNo + "','" + model.MaterialDesc + "','','','" + (model.Qty - qty) + "','200'," +
" 0 ,'" + user.UserName + "',getdate(),'" + model.ID + "', " +
"'" + model.Unit + "','" + model.UnitName + "','" + model.PartNo + "','" + model.MaterialNoID + "','" + model.ErpVoucherNo + "'," +
" '','" + model.StrongHoldCode + "','" + model.StrongHoldName + "','" + model.CompanyCode + "'," +
" '" + model.SupPrdBatch + "','" + model.EDate + "' ,'" + model.TaskNo + "'," +
" '" + model.BatchNo + "', '" + model.AreaID + "','" + model.WareHouseID + "','" + model.HouseID + "' ,'" + model.Barcode + "','" + model.Status + "','','','" + model.EAN + "') ";
return(strSql);
}
private string GetTaskTransSql(UserModel user, T_StockInfo model, T_OutStockTaskDetailsInfo detailModel)
{
int id = base.GetTableIDBySqlServer("T_TASKTRANSDETAIL");
string strSql = "insert into t_tasktrans( Serialno,towarehouseID,TohouseID, ToareaID, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,batchno,Fromareaid,Fromwarehouseid,Fromhouseid,barcode,status,materialdoc,houseprop,ean)" +
" values ('" + model.SerialNo + "',(select id from t_Warehouse a where Warehouseno = '" + model.ToErpWarehouse + "'),(select HOUSEID from v_Area a where warehouseno = '" + model.ToErpWarehouse + "' and AREANO = '" + model.ToErpAreaNo + "'),(select ID from v_Area a where warehouseno = '" + model.ToErpWarehouse + "' and AREANO = '" + model.ToErpAreaNo + "')," +
" '" + model.MaterialNo + "','" + model.MaterialDesc + "','" + detailModel.SupCusCode + "','" + detailModel.SupCusName + "','" + model.Qty + "','2'," +
" (select vouchertype from t_task where id = '" + detailModel.HeaderID + "') ,'" + user.UserName + "',getdate(),'" + model.ID + "', " +
"'" + detailModel.Unit + "','" + detailModel.UnitName + "','" + detailModel.PartNo + "','" + detailModel.MaterialNoID + "','" + detailModel.ErpVoucherNo + "'," +
" '" + detailModel.VoucherNo + "','" + detailModel.StrongHoldCode + "','" + detailModel.StrongHoldName + "','" + detailModel.CompanyCode + "'," +
" '" + model.SupPrdBatch + "','" + model.EDate + "' ,'" + detailModel.TaskNo + "'," +
" '" + model.BatchNo + "', '" + model.AreaID + "','" + model.WareHouseID + "','" + model.HouseID + "' ,'" + model.Barcode + "','" + model.Status + "','" + detailModel.MaterialDoc + "','" + detailModel.HouseProp + "','" + model.EAN + "') ";
return(strSql);
}
private List <string> GetTaskTransSqlList(UserModel user, T_StockInfo model, T_OutStockTaskDetailsInfo detailModel)
{
int id = base.GetTableIDBySqlServerTaskTrans("t_tasktrans");
List <string> lstSql = new List <string>();
string strSql = "SET IDENTITY_INSERT t_tasktrans on ;insert into t_tasktrans(id, Serialno, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,batchno,barcode,status,materialdoc,houseprop,ean,FromWarehouseNo,FromWarehouseName,FromHouseNo,FromAreaNo,ToWarehouseNo,ToWarehouseName,ToHouseNo,ToAreaNo,PalletNo,IsPalletOrBox)" +
" values ('" + id + "' , '" + model.SerialNo + "'," +
" '" + model.MaterialNo + "','" + model.MaterialDesc + "','" + detailModel.SupCusCode + "','" + detailModel.SupCusName + "','" + model.Qty + "','2'," +
" (select vouchertype from t_task where id = '" + detailModel.HeaderID + "') ,'" + user.UserName + "',getdate(),'" + model.ID + "', " +
"'" + detailModel.Unit + "','" + detailModel.UnitName + "','" + detailModel.PartNo + "','" + detailModel.MaterialNoID + "','" + detailModel.ErpVoucherNo + "'," +
" '" + detailModel.VoucherNo + "','" + detailModel.StrongHoldCode + "','" + detailModel.StrongHoldName + "','" + detailModel.CompanyCode + "'," +
" '" + model.SupPrdBatch + "','" + model.StrEDate + "' ,'" + detailModel.TaskNo + "'," +
" '" + model.BatchNo + "' ,'" + model.Barcode + "','" + model.Status + "','" + detailModel.MaterialDoc + "','" + detailModel.HouseProp + "','" + model.EAN + "'," +
" (select WAREHOUSENO from T_WAREHOUSE where id ='" + model.WareHouseID + "')," +
" (select WAREHOUSENAME from T_WAREHOUSE where id ='" + model.WareHouseID + "'), " +
" (select HOUSENO from T_HOUSE where id='" + model.HouseID + "')," +
" (select AREANO from T_AREA where id ='" + model.AreaID + "')," +
" (select WAREHOUSENO from T_WAREHOUSE where id ='" + user.PickWareHouseID + "'),(select WAREHOUSENAME from T_WAREHOUSE where warehouseno ='" + user.PickWareHouseID + "')," +
" (select HOUSENO from T_HOUSE where id='" + user.PickHouseID + "')," +
" (select AREANO from T_AREA where id ='" + user.PickAreaID + "'),'" + model.PalletNo + "','" + model.IsPalletOrBox + "' ) SET IDENTITY_INSERT t_tasktrans off ";//,(select ID from v_Area a where warehouseno = '" + model.ToErpWarehouse + "' and AREANO = '" + model.ToErpAreaNo + "'),'" + model.AreaID + "','" + model.WareHouseID + "','" + model.HouseID + "'
lstSql.Add(strSql);
if (model.lstJBarCode != null && model.lstJBarCode.Count > 0)
{
foreach (var item in model.lstJBarCode)
{
strSql = "insert into T_TASKTRANSDETAIL( Serialno,towarehouseID,TohouseID, ToareaID, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,batchno,Fromareaid,Fromwarehouseid,Fromhouseid,barcode,status,materialdoc,houseprop,ean,headerid)" +
" values ( '" + item.SerialNo + "',(select id from t_Warehouse a where Warehouseno = '" + model.ToErpWarehouse + "'),(select HOUSEID from v_Area a where warehouseno = '" + model.ToErpWarehouse + "' and AREANO = '" + model.ToErpAreaNo + "'),(select ID from v_Area a where warehouseno = '" + model.ToErpWarehouse + "' and AREANO = '" + model.ToErpAreaNo + "')," +
" '" + model.MaterialNo + "','" + model.MaterialDesc + "','" + detailModel.SupCusCode + "','" + detailModel.SupCusName + "','" + item.Qty + "','2'," +
" (select vouchertype from t_task where id = '" + detailModel.HeaderID + "') ,'" + user.UserName + "',getdate(),'" + model.ID + "', " +
"'" + detailModel.Unit + "','" + detailModel.UnitName + "','" + detailModel.PartNo + "','" + detailModel.MaterialNoID + "','" + detailModel.ErpVoucherNo + "'," +
" '" + detailModel.VoucherNo + "','" + detailModel.StrongHoldCode + "','" + detailModel.StrongHoldName + "','" + detailModel.CompanyCode + "'," +
" '" + model.SupPrdBatch + "','" + model.StrEDate + "' ,'" + detailModel.TaskNo + "'," +
" '" + model.BatchNo + "', '" + model.AreaID + "','" + model.WareHouseID + "','" + model.HouseID + "' ,'" + item.Barcode + "','" + model.Status + "','" + detailModel.MaterialDoc + "','" + detailModel.HouseProp + "','" + item.EAN + "','" + id + "') ";
lstSql.Add(strSql);
}
}
return(lstSql);
}
public bool SaveBarCodeToStock(UserModel userModel, T_StockInfo OldModel, T_StockInfo NewModel, ref string NewSerialNo, ref string strErrMsg)
{
List <string> lstSql = new List <string>();
string strSql = string.Empty;
//newmodel没有serialno需要重新生成新的条码，标示拆箱操作
//装箱
if (NewModel != null)
{
lstSql = GetBoxAmountSql(userModel, OldModel, NewModel);
}
else
{
//拆箱
lstSql = GetUnBoxAmountSql(OldModel, userModel, ref NewSerialNo);
}
return(base.SaveModelListBySqlToDB(lstSql, ref strErrMsg));
}
public string GetAmountQtyInsertStockSql(T_StockInfo model, UserModel user, string NewSerialNo)
{
int stockID = 0;
string strSql = string.Empty;
//整箱区拣货直接插入库存
//if (model.HouseProp == 1)
//{
// strSql = "insert into t_Stock( Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, Status, Isdel," +
// "Creater, Createtime, Batchno, Oldstockid, Unit, Unitname, " +
// "Receivestatus, Islimitstock, Materialnoid, Strongholdcode, Strongholdname, Companycode," +
// "Edate, Supcode, Supname, Productdate, Supprdbatch, Supprddate, Isquality,Stocktype,ean)" +
// "select barcode,serialno,materialno,Materialdesc,'" + model.WareHouseID + "', '" + model.HouseID + "', '" + model.AreaID + "', Qty ,'" + model.Status + "','1'," +
// "'" + user.UserNo + "',getdate(),batchno,'" + model.ID + "',unit,'" + model.UnitName + "','" + model.ReceiveStatus + "','" + model.IsLimitStock + "',Materialnoid," +
// "Strongholdcode, Strongholdname, Companycode,Edate, Supcode, Supname, Productdate, Supprdbatch,Supprddate, '3',1,ean from t_Outbarcode where serialno = '" + NewSerialNo + "'";
//}
//else if(model.HouseProp==2)
//{
// stockID = GetTableID("Seq_Stock_Id");
// strSql = "insert into t_Stock(Id, Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, Status, Isdel," +
// "Creater, Createtime, Batchno, Oldstockid, Unit, Unitname, " +
// "Receivestatus, Islimitstock, Materialnoid, Strongholdcode, Strongholdname, Companycode," +
// "Edate, Supcode, Supname, Productdate, Supprdbatch, Supprddate, Isquality,Stocktype,Taskdetailesid,houseprop,ean)" +
// "select '" + stockID + "',barcode,serialno,materialno,Materialdesc,'" + model.WareHouseID + "', '" + model.HouseID + "', '" + model.AreaID + "', Qty ,'" + model.Status + "','1'," +
// "'" + user.UserNo + "',getdate(),batchno,'" + model.ID + "',unit,'" + model.UnitName + "','" + model.ReceiveStatus + "','" + model.IsLimitStock + "',Materialnoid," +
// "Strongholdcode, Strongholdname, Companycode,Edate, Supcode, Supname, Productdate, Supprdbatch,Supprddate, '" + model.IsQuality + "',1,'" + model.TaskDetailesID + "','" + model.HouseProp + "',ean from t_Outbarcode where serialno = '" + NewSerialNo + "'";
//}
strSql = "insert into t_Stock( spec,Barcode, Serialno, Materialno, Materialdesc, Warehouseid, Houseid, Areaid, Qty, Status, Isdel," +
"Creater, Createtime, Batchno, Oldstockid, Unit, Unitname, " +
"Receivestatus, Islimitstock, Materialnoid, Strongholdcode, Strongholdname, Companycode," +
"Edate, Supcode, Supname, Productdate, Supprdbatch, Supprddate, Isquality,Stocktype,ean,BARCODETYPE,ProjectNo,TracNo,IsAmount)" +
"select spec, barcode,serialno,materialno,Materialdesc,'" + model.WareHouseID + "', '" + model.HouseID + "', '" + model.AreaID + "', Qty ,'" + model.Status + "','1'," +
"'" + user.UserNo + "',getdate(),batchno,'" + model.ID + "',unit,'" + model.UnitName + "','" + model.ReceiveStatus + "','" + model.IsLimitStock + "','" + model.MaterialNoID + "'," +
"'" + model.StrongHoldCode + "', '" + model.StrongHoldName + "', Companycode,Edate, Supcode, Supname, Productdate, Supprdbatch,Supprddate, '3',1,ean,BARCODETYPE,ProjectNo,TracNo,2 from t_Outbarcode where serialno = '" + NewSerialNo + "'";
return(strSql);
}
private string GetTaskTransSql(UserModel user, T_StockInfo model, T_OutStockTaskDetailsInfo detailModel)
{
string strSql = string.Empty;
strSql = "insert into t_tasktrans( Serialno, Materialno, Materialdesc, Supcuscode, " +
"Supcusname, Qty, Tasktype, Vouchertype, Creater, Createtime,TaskdetailsId, Unit, Unitname,partno,materialnoid,erpvoucherno,voucherno," +
"Strongholdcode,Strongholdname,Companycode,Supprdbatch,Edate,taskno,status,batchno,barcode,houseprop,ean,Fromerpwarehouse,ISAMOUNT,ToWarehouseNo,ToWarehouseName,ToHouseNo,ToAreaNo,PalletNo)" +
" values ('" + model.SerialNo + "'," +
" '" + model.MaterialNo + "','" + model.MaterialDesc + "','" + detailModel.CustomerCode + "','" + detailModel.CustomerName + "','" + model.Qty + "','12'," +
" (select vouchertype from t_outstock where id = '" + detailModel.HeaderID + "') ,'" + user.UserName + "',getdate(),'" + model.TaskDetailesID + "', " +
"'" + detailModel.Unit + "','" + detailModel.UnitName + "','" + detailModel.PartNo + "','" + model.MaterialNoID + "','" + detailModel.ErpVoucherNo + "'," +
" '" + detailModel.VoucherNo + "','" + detailModel.StrongHoldCode + "','" + detailModel.StrongHoldName + "','" + detailModel.CompanyCode + "'," +
" '" + model.SupPrdBatch + "','" + model.StrEDate + "' ,'" + detailModel.TaskNo + "','" + model.Status + "','" + model.FromBatchNo + "','" + model.Barcode + "','" + model.HouseProp + "','" + model.EAN + "','" + detailModel.FromErpWarehouse + "','" + model.IsAmount + "'," +
" (select WAREHOUSENO from T_WAREHOUSE where id ='" + model.WareHouseID + "') ," +
" (select WAREHOUSENAME from T_WAREHOUSE where id ='" + model.WareHouseID + "')," +
" (select HOUSENO from T_HOUSE where id='" + model.HouseID + "')," +
" (select AREANO from T_AREA where id ='" + model.AreaID + "'),'" + model.PalletNo + "' ) ";
return(strSql);
}
public string GetBarcodeModelForJADF(string SerialNo)
{
BaseMessage_Model <List <T_StockInfo> > messageModel = new BaseMessage_Model <List <T_StockInfo> >();
try
{
string strErrMsg = string.Empty;
T_OutBarCodeInfo model = new T_OutBarCodeInfo();
if (!GetOutBarCodeInfoBySerialNo(SerialNo, ref model, ref strErrMsg))
{
messageModel.HeaderStatus = "E";
messageModel.Message = strErrMsg;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_StockInfo> > >(messageModel));
}
T_StockInfo smodel = new T_StockInfo();
List <T_StockInfo> smodelList = new List <T_StockInfo>();
smodel.MaterialNo = model.MaterialNo;
smodel.ProjectNo = model.ProjectNo == null?"": model.ProjectNo;
smodel.TracNo = model.TracNo == null ? "" : model.TracNo;
smodel.BarCodeType = model.BarcodeType;
smodel.SerialNo = model.SerialNo;
smodel.Barcode = model.BarCode;
smodel.fserialno = model.fserialno;
smodelList.Add(smodel);
messageModel.HeaderStatus = "S";
messageModel.ModelJson = smodelList;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_StockInfo> > >(messageModel));
}
catch (Exception ex)
{
messageModel.HeaderStatus = "E";
messageModel.Message = ex.Message;
return(JSONHelper.ObjectToJson <BaseMessage_Model <List <T_StockInfo> > >(messageModel));
}
}
//获取楼层编号
private bool GetFloorByMaterialNoID(int MaterialNoID, string BatchNo, int PickRule, ref T_StockInfo model, ref string strError, string StrongholdCode, string WareHouseNo)
{
try
{
T_Stock_DB _db = new T_Stock_DB();
model = _db.GetFloorForStock(MaterialNoID, BatchNo, PickRule, StrongholdCode, WareHouseNo);
if (model.FloorType == 0)
{
strError = "请先设置货位" + model.AreaNo + "对应的楼层编号！";
return(false);
}
return(true);
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
/// <summary>
/// 获取条码库存数据
/// </summary>
/// <param name="SerialNo"></param>
/// <param name="model"></param>
/// <param name="strErrMsg"></param>
/// <returns></returns>
private bool GetBarCodeIsStock(string SerialNo, ref T_StockInfo model, ref string strErrMsg)
{
T_Stock_Func tfunc = new T_Stock_Func();
return(tfunc.GetStockByBarCode(SerialNo, ref model, ref strErrMsg));
}
public bool SaveT_Stock(UserInfo user, ref T_StockInfo t_stock, ref string strError)
{
T_Stock_Func tfunc = new T_Stock_Func();
return(tfunc.SaveModelBySqlToDB(user, ref t_stock, ref strError));
}
public bool DeleteT_StockByModel(UserInfo user, T_StockInfo model, ref string strError)
{
T_Stock_Func tfunc = new T_Stock_Func();
return(tfunc.DeleteModelByModel(user, model, ref strError));
}
public bool GetT_StockByID(ref T_StockInfo model, ref string strError)
{
T_Stock_Func tfunc = new T_Stock_Func();
return(tfunc.GetModelByID(ref model, ref strError));
}
public JsonResult scanEAN(T_StockInfo model)
{
if (currentUser == null)
{
return(Json(new { state = false, obj = "Cookie失效，重新登陆！" }, JsonRequestBehavior.AllowGet));
}
if (model.Barcode.Contains("@"))
{
return(Json(new { state = false, obj = "扫描物料标签不能修改数量！" }, JsonRequestBehavior.AllowGet));
}
else
{
model.ScanType = 3;
}
List <T_OutStockDetailInfo> outStockDetailList = new List <T_OutStockDetailInfo>();
string strError = "";
T_OutStockDetail_Func fun = new T_OutStockDetail_Func();
//重新构造库存类
T_StockInfo modelnew = new T_StockInfo();
modelnew.ErpVoucherNo = model.ErpVoucherNo;
modelnew.Barcode = model.Barcode;
List <T_StockInfo> modelList = new List <T_StockInfo>();
int ID = 0;
bool isSuccessF = fun.GetReviewStockModel(currentUser, model, ref modelList, ref outStockDetailList, ref ID, ref strError);
if (isSuccessF && modelList != null && modelList.Count > 0)
{
//第二次进来带了materialnoid
if (model.MaterialNoID != 0)
{
foreach (T_StockInfo item in modelList)
{
if (item.MaterialNoID == model.MaterialNoID)
{
modelnew = item;
break;
}
}
if (modelnew.MaterialNoID == 0)
{
return(Json(new { state = false, obj = "没有找到对应的条码！" }, JsonRequestBehavior.AllowGet));
}
}
else
{
modelnew = modelList[0];
}
}
else
{
return(Json(new { state = isSuccessF, obj = strError }, JsonRequestBehavior.AllowGet));
}
if (model.ScanQty > modelnew.Qty)
{
return(Json(new { state = false, obj = "提交数量不能超过库存数量！" }, JsonRequestBehavior.AllowGet));
}
modelnew.Barcode = model.Barcode;
modelnew.ErpVoucherNo = model.ErpVoucherNo;
modelnew.ScanQty = model.ScanQty;
modelnew.ScanQty = model.ScanQty;
bool isSuccess = fun.SaveT_OutStockReviewDetailENA(currentUser, modelnew, ref outStockDetailList, ref ID, ref strError);
if (isSuccess)
{
for (int i = 0; i < outStockDetailList.Count; i++)
{
if (outStockDetailList[i].ID == ID)
{
outStockDetailList[i].isLight = true;
}
else
{
outStockDetailList[i].isLight = false;
}
}
return(Json(new { state = isSuccess, obj = outStockDetailList }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { state = isSuccess, obj = strError }, JsonRequestBehavior.AllowGet));
}
}
public bool GetT_StockListByPage(ref List <T_StockInfo> modelList, UserInfo user, T_StockInfo t_stock, ref DividPage page, ref string strError)
{
T_Stock_Func tfunc = new T_Stock_Func();
return(tfunc.GetModelListByPage(ref modelList, user, t_stock, ref page, ref strError));
}
public bool UpdateT_StockStatus(UserInfo user, ref T_StockInfo t_stock, int NewStatus, ref string strError)
{
T_Stock_Func tfunc = new T_Stock_Func();
return(tfunc.UpdateModelStatus(user, ref t_stock, NewStatus, ref strError));
}
