public JsonResult GetEAN(string materialno)
{
try
{
T_Material_DB t_Material_DB = new T_Material_DB();
string EAN = t_Material_DB.getEAN(materialno);
if (!string.IsNullOrEmpty(EAN))
{
return(Json(new { state = true, obj = EAN }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { state = false }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception)
{
return(Json(new { state = false }, JsonRequestBehavior.AllowGet));
}
}
/// <summary>
/// PDA提交JSON转换成List对象
/// </summary>
/// <param name="ModelListJson"></param>
/// <returns></returns>
protected override List <T_InStockDetailInfo> GetModelListByJson(string UserJson, string ModelListJson)
{
LogNet.LogInfo("SaveT_InStockDetailADF---" + ModelListJson);
int IsQuality = 0;
string strUserNo = string.Empty;
List <T_InStockDetailInfo> modelList = JSONHelper.JsonToObject <List <T_InStockDetailInfo> >(ModelListJson);
UserModel user = JSONHelper.JsonToObject <UserModel>(UserJson);
modelList.ForEach(t => t.ReceiveQty = t.ScanQty);
modelList = modelList.Where(t => t.ReceiveQty > 0).ToList();
//IsQuality = GetIsQuality(modelList[0]);
IsQuality = GetIsQualityByVoucherType(modelList[0]);
string StrongHoldCode = "";
string StrongHoldCodeName = "";
T_WareHouse_DB TWareHouseDB = new T_WareHouse_DB();
TWareHouseDB.GetStrongholdcode(user.ReceiveWareHouseNo, ref StrongHoldCode, ref StrongHoldCodeName);
modelList.ForEach(t => {
t.IsQuality = IsQuality;
foreach (var itemBarCode in t.lstBarCode)
{
//成品入库单做一个调拨的操作
if (t.VoucherType == 50)
{
T_Material_DB MaterialDB = new T_Material_DB();
itemBarCode.MaterialNoID = MaterialDB.GetMaterialNoid(itemBarCode.MaterialNo, "0300");
}
else
{
T_Material_DB MaterialDB = new T_Material_DB();
itemBarCode.MaterialNoID = MaterialDB.GetMaterialNoid(itemBarCode.MaterialNo, StrongHoldCode);
}
}
});
//if (TOOL.RegexMatch.isExists(user.UserNo) == true)
//{
// strUserNo = user.UserNo.Substring(0, user.UserNo.Length - 1);
//}
//else
//{
// strUserNo = user.UserNo;
//}
////确定过账人，根据登录账户以及操作的订单据点来确定
//User_DB _db = new User_DB();
//string strPostUser = _db.GetPostAccountByUserNo(strUserNo, modelList[0].StrongHoldCode);
foreach (var item in modelList)
{
if (item.lstBarCode != null && item.lstBarCode.Count() > 0)
{
item.SupPrdBatch = item.lstBarCode.FirstOrDefault().SupPrdBatch;
item.SupPrdDate = item.lstBarCode.FirstOrDefault().SupPrdDate;
item.StrSupPrdDate = item.lstBarCode.FirstOrDefault().SupPrdDate.ToShortDateString();
item.BatchNo = item.lstBarCode.FirstOrDefault().BatchNo; //item.IsSpcBatch=="Y"?item.FromBatchNo: item.lstBarCode.FirstOrDefault().BatchNo;
item.ReceiveWareHouseNo = user.ReceiveWareHouseNo;
item.ReceiveAreaNo = string.Empty;
item.ReceiveUserNo = user.UserNo;// strPostUser;
item.FromErpWarehouse = user.ReceiveWareHouseNo;
item.ToErpAreaNo = string.Empty;
item.ToBatchNo = item.BatchNo;
//item.PostUser = user.UserNo;
item.PostUser = user.UserName;
item.StrEDate = item.lstBarCode.FirstOrDefault().EDate.ToString("yyyy/MM/dd");
}
//item..PostDate = Convert.ToDateTime(DateTime.Now.ToString("yyyy/MM/dd"));
}
return(modelList);
}
//物料：flag= "0" 入库单：1 出库单 2
public bool GetVoucherNo(string Erpvoucherno, ref string ErrorMsg, string flag = "0")
{
if (string.IsNullOrEmpty(Erpvoucherno))
{
ErrorMsg = "单据号不能为空";
return(false);
}
int WmsVoucherType = 9999; string syncType = "ERP"; int syncExcelVouType = -1; DataSet excelds = null; int StockType = 0;
string tableName = "t_material";
if (Erpvoucherno.Contains("Wgr"))//成品入库单
{
tableName = " T_instock";
StockType = 10;
WmsVoucherType = 50;
}
if (Erpvoucherno.Contains("RE"))//退回处理单
{
tableName = " T_instock";
StockType = 10;
WmsVoucherType = 47;
}
if (Erpvoucherno.Contains("MO"))//生产订单
{
tableName = " T_Product";
StockType = 10;
WmsVoucherType = 51;
}
if (Erpvoucherno.Contains("SM"))//销售出货单
{
tableName = " T_Task";
StockType = 20;
WmsVoucherType = 46;
}
if (Erpvoucherno.Contains("Tra"))//形态转换单
{
StockType = 10;
WmsVoucherType = 52;
}
if (Erpvoucherno.Contains("DC"))//调拨出库单
{
if (flag == "1")
{
tableName = " T_instock";
StockType = 10;
WmsVoucherType = 30;
}
else
{
tableName = " T_Task";
StockType = 20;
WmsVoucherType = 31;
}
}
if (Erpvoucherno.Contains("DR"))//调拨入库单
{
tableName = " T_instock";
StockType = 10;
WmsVoucherType = 30;
}
if (Erpvoucherno.Contains("ZF"))//杂发单
{
StockType = 20;
WmsVoucherType = 0;
}
if (WmsVoucherType == 0 || tableName == "")
{
ErrorMsg = "找不到该单据类型！";
return(false);
}
if (flag != "0")
{
//查看单据是否存在
T_Material_DB DB = new T_Material_DB();
if (DB.GetCount("SELECT count(1) FROM " + tableName + " WHERE erpvoucherno ='" + Erpvoucherno + "'") > 0)
{
return(true);
}
//using (var db = SqlSugarBase.GetInstance())
//{
// if (db.Ado.GetInt("SELECT count(1) FROM " + tableName + " WHERE erpvoucherno ='" + Erpvoucherno + "'") > 0)
// {
// return true;
// }
//}
}
//同步单据
if (SyncErp.SyncJsonFromErp(StockType, string.Empty, Erpvoucherno, WmsVoucherType, ref ErrorMsg))
{
return(true);
}
else
{
return(false);
}
}
//专门给U9用
public bool SaveBarcode(List <Barcode_Model> backmodels, ref string strMsg)
{
try
{
T_Material_DB MDB = new T_Material_DB();
Print_DB print_DB = new Print_DB();
bool flag = false;
string info = "";
backmodels.ForEach(item =>
{
int Materialnoid = MDB.GetMaterialNoid(item.MaterialNo, item.StrongHoldCode);
if (Materialnoid == 0)
{
info = "据点【" + item.StrongHoldCode + "】物料主数据没有物料【" + item.MaterialNo + "】信息！";
flag = true;
}
else
{
item.MaterialNoID = Materialnoid;
}
item.CompanyCode = "";
item.VoucherType = "51";
item.Creater = "U9";
item.RowNo = "1";
item.RowNoDel = "1";
item.BarcodeType = 1;
});
if (flag)
{
strMsg = info;
return(false);
}
if (print_DB.SubBarcodes(backmodels, "sup", 1, ref strMsg))
{
return(true);
}
else
{
return(false);
}
//List<Barcode_Model> listbarcode = new List<Barcode_Model>();
//foreach (var backmodel in backmodels)
//{
// Barcode_Model model = new Barcode_Model();
// model.CompanyCode = "";
// model.ErpVoucherNo = backmodel.ErpVoucherNo;
// model.VoucherType = "51";
// model.StrongHoldCode = backmodel.StrongHoldCode;
// model.StrongHoldName = backmodel.StrongHoldName;
// model.MaterialNoID = backmodel.MaterialNoID;
// model.MaterialNo = backmodel.MaterialNo;
// model.MaterialDesc = backmodel.MaterialDesc;
// model.spec = backmodel.spec;
// model.BatchNo = backmodel.BatchNo;
// model.ProductBatch = backmodel.ProductBatch;//给批号加密成8位
// model.ErpVoucherNo = backmodel.ErpVoucherNo;
// model.Qty = backmodel.Qty;
// model.CusCode = backmodel.CusCode;
// model.CusName = backmodel.CusName;
// model.StoreCondition = backmodel.StoreCondition;
// model.ProtectWay = backmodel.ProtectWay;
// model.LABELMARK = backmodel.LABELMARK;
// model.SerialNo = backmodel.SerialNo;
// model.Creater = "U9";
// model.ReceiveTime = DateTime.Now;
// model.BarCode = "2@" + model.MaterialNo + "@" + model.Qty + "@" + model.SerialNo;
// model.RowNo = "1";
// model.RowNoDel = "1";
// model.BarcodeType = 1;
// listbarcode.Add(model);
//}
//if (print_DB.SubBarcodes(backmodels, "sup", 1, ref strMsg))
//{
// return true;
//}
//else
//{
// return false;
//}
}
catch (Exception ex)
{
strMsg = ex.ToString();
return(false);
}
}
