public string GetMaterialModelADF(string MaterialNo)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.GetMaterialModelBySqlADF(MaterialNo));
}
public bool GetAllT_MaterialByHeaderID(ref List <T_MaterialInfo> modelList, int headerID, ref string strError)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.GetModelListByHeaderID(ref modelList, headerID, ref strError));
}
public bool UpdateT_MaterialStatus(UserInfo user, ref T_MaterialInfo t_material, int NewStatus, ref string strError)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.UpdateModelStatus(user, ref t_material, NewStatus, ref strError));
}
public bool GetT_MaterialByID(ref T_MaterialInfo model, ref string strError)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.GetModelByID(ref model, ref strError));
}
public bool GetT_MaterialListByPage(ref List <T_MaterialInfo> modelList, UserInfo user, T_MaterialInfo t_material, ref DividPage page, ref string strError)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.GetModelListByPage(ref modelList, user, t_material, ref page, ref strError));
}
public bool DeleteT_MaterialByModel(UserInfo user, T_MaterialInfo model, ref string strError)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.DeleteModelByModelSql(user, model, ref strError));
}
public bool SaveT_Material(UserInfo user, ref T_MaterialInfo t_material, ref string strError)
{
T_Material_Func tfunc = new T_Material_Func();
return(tfunc.SaveModelBySqlToDB(user, ref t_material, ref strError));
}
public JsonResult Print(string IDs, string Path)
{
try
{
List <Barcode_Model> barcodelist = new List <Barcode_Model>();
var Isxls = System.IO.Path.GetExtension(Path).ToString().ToLower();
DataTable dt = new DataTable();
if (Isxls == ".xls")
{
dt = ImportExcelFile(Path);
}
if (Isxls == ".xlsx")
{
dt = ImportExcelFilexlsx(Path);
}
barcodelist = Print_DB.ConvertToModel <Barcode_Model>(dt);
List <Barcode_Model> barcodelistnew = new List <Barcode_Model>();
List <Barcode_Model> barcodelistnewsub = new List <Barcode_Model>();
List <Barcode_Model> barcodelistnewAll = new List <Barcode_Model>();
string[] ids = IDs.Split(',');
for (int i = 0; i < ids.Length; i++)
{
if (ids[i] != "")
{
List <Barcode_Model> barcodes = new List <Barcode_Model>();
barcodes.AddRange(barcodelist.Where(P => P.RowNo == ids[i]));
//单张条码
//Barcode_Model model = (Barcode_Model)DeepCopy(barcodes[0]);
//barcodelistnew.Add(model);
//多张条码
if (barcodes.Count == 1 && barcodes[0].BoxCount >= 1)
{
for (int j = 0; j < barcodes[0].BoxCount; j++)
{
Barcode_Model model = (Barcode_Model)DeepCopy(barcodes[0]);
barcodelistnew.Add(model);
}
}
}
}
if (barcodelistnew != null && barcodelistnew.Count > 0)
{
string strMsg = "";
PrintInController printIn = new PrintInController();
List <string> squence = printIn.GetSerialnos(barcodelistnew.Count, "外", ref strMsg);
int k = 0;
DateTime time = DateTime.Now;
for (int i = 0; i < barcodelistnew.Count; i++)
{
barcodelistnew[i].CompanyCode = "SHJC";
barcodelistnew[i].BarcodeType = 1;
barcodelistnew[i].SerialNo = squence[k++];
barcodelistnew[i].Creater = currentUser.UserNo;
barcodelistnew[i].ReceiveTime = time;
barcodelistnew[i].BarCode = "1@" + barcodelistnew[i].StrongHoldCode + "@" + barcodelistnew[i].MaterialNo + "@" + barcodelistnew[i].BatchNo + "@" + barcodelistnew[i].Qty + "@" + barcodelistnew[i].SerialNo;
//查物料
T_Material_Func funM = new T_Material_Func();
string strErrMsg = "";
List <T_MaterialInfo> modelList = funM.GetMaterialModelBySql(barcodelistnew[i].MaterialNo, ref strErrMsg);
if (modelList == null || modelList.Count == 0)
{
//失败
return(Json(new { state = false, obj = "没有该物料号" + barcodelistnew[i].MaterialNo }, JsonRequestBehavior.AllowGet));
}
if (modelList[0].sku == "是")
{
for (int kk = 0; kk < barcodelistnew[i].Qty; kk++)
{
Barcode_Model modelsub = (Barcode_Model)DeepCopy(barcodelistnew[i]);
modelsub.fserialno = barcodelistnew[i].SerialNo;
barcodelistnewsub.Add(modelsub);
}
}
}
//本体打印
DateTime timesub = DateTime.Now.AddSeconds(5);
if (barcodelistnewsub != null && barcodelistnewsub.Count > 0)
{
List <string> squencesub = printIn.GetSerialnos(barcodelistnewsub.Count, "内", ref strMsg);
int ksub = 0;
for (int isub = 0; isub < barcodelistnewsub.Count; isub++)
{
barcodelistnewsub[isub].CompanyCode = "SHJC";
barcodelistnewsub[isub].BarcodeType = 2;
barcodelistnewsub[isub].SerialNo = squencesub[ksub++];
barcodelistnewsub[isub].Creater = currentUser.UserNo;
barcodelistnewsub[isub].ReceiveTime = timesub;
barcodelistnewsub[isub].Qty = 1;
barcodelistnewsub[isub].BarCode = "2@" + barcodelistnewsub[isub].StrongHoldCode + "@" + barcodelistnewsub[isub].MaterialNo + "@" + barcodelistnewsub[isub].BatchNo + "@1@" + barcodelistnewsub[isub].SerialNo;
}
}
barcodelistnewAll.AddRange(barcodelistnew);
barcodelistnewAll.AddRange(barcodelistnewsub);
Print_DB func = new Print_DB();
if (func.SubBarcodesNoPrint(barcodelistnewAll, ref strMsg))
{
if (barcodelistnewsub != null && barcodelistnewsub.Count > 0)
{
return(Json(new { state = true, obj = time.ToString("yyyy/MM/dd HH:mm:ss"), obj1 = timesub.ToString("yyyy/MM/dd HH:mm:ss") }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { state = true, obj = time.ToString("yyyy/MM/dd HH:mm:ss"), obj1 = "" }, JsonRequestBehavior.AllowGet));
}
}
else
{
//失败
return(Json(new { state = false, obj = strMsg }, JsonRequestBehavior.AllowGet));
}
}
else
{
//失败
return(Json(new { state = false, obj = "数据为空" }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { state = false, obj = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public JsonResult SaveBarcode(string erpvoucherno, string materialno, string materialdesc, string ean, string batch, string edate, string num, string everynum, string receivetime, string RowNO, string RowNODel, string MaterialNoID, string StrongHoldCode, string CompanyCode, string Createname, string WarehouseName, string TracNo, string ProjectNo, string flag = "")//flag=1 是预留释放打印
{
//查物料
T_Material_Func funM = new T_Material_Func();
string strErrMsg = "";
List <T_MaterialInfo> modelList = funM.GetMaterialModelBySql(materialno, ref strErrMsg);
if (modelList == null || modelList.Count == 0)
{
//失败
return(Json(new { state = false, obj = "没有该物料号" + materialno }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrEmpty(Userno))
{
return(Json(new { state = false, obj = "Cookie失效，重新登陆！" }, JsonRequestBehavior.AllowGet));
}
try
{
DateTime time1 = DateTime.Now;
DateTime time2 = DateTime.Now.AddSeconds(1);
string err = "";
//计算外箱数量,和尾箱数量,和尾箱里面的个数
int outboxnum = 0;
int inboxnum = 0;
decimal tailnum = 0;
GetBoxInfo(ref outboxnum, ref tailnum, ref inboxnum, num, everynum);
if (outboxnum == 0)
{
return(Json(new { state = false, obj = "打印数量为0" }, JsonRequestBehavior.AllowGet));
}
Print_DB print_DB = new Print_DB();
List <string> squence = GetSerialnos(outboxnum + inboxnum, "外", ref err); //外箱码序列号
List <string> squenceforin = GetSerialnos(Int16.Parse(num), "内", ref err); //本体序列号
//int matenoid = selectItem.MaterialNoID;
sq = "";
//存放打印条码内容
List <Barcode_Model> listbarcode = new List <Barcode_Model>();
int k = 0;
int kIn = 0;
//执行打印外箱命令
for (int i = 0; i < outboxnum; i++)
{
Barcode_Model model = new Barcode_Model();
model.CompanyCode = CompanyCode;
model.StrongHoldCode = StrongHoldCode;
model.MaterialNoID = Convert.ToInt32(MaterialNoID);
model.MaterialNo = materialno;
model.MaterialDesc = materialdesc;
model.BatchNo = DateTime.Now.ToString("yyyyMMdd");
model.ErpVoucherNo = erpvoucherno;
//model.EDate = Convert.ToDateTime(edate);
model.Qty = Convert.ToDecimal(everynum);
model.SerialNo = squence[k++];
model.Creater = Userno;
//model.EAN = ean;
//model.ReceiveTime = string.IsNullOrEmpty(receivetime) ? DateTime.Now : Convert.ToDateTime(receivetime);
model.ReceiveTime = time1;
model.BarCode = "1@" + model.StrongHoldCode + "@" + model.MaterialNo + "@" + model.BatchNo + "@" + model.Qty + "@" + model.SerialNo;
model.RowNo = RowNO;
model.RowNoDel = RowNODel;
model.BarcodeType = 1;
model.ProductClass = Createname;
model.WorkNo = WarehouseName;
model.TracNo = TracNo;
model.ProjectNo = ProjectNo;
model.originalCode = flag;
listbarcode.Add(model);
if (modelList[0].sku == "是")
{
//本体打印
for (int ii = 0; ii < Convert.ToDecimal(everynum); ii++)
{
Barcode_Model modelIn1 = new Barcode_Model();
modelIn1.CompanyCode = CompanyCode;
modelIn1.StrongHoldCode = StrongHoldCode;
modelIn1.MaterialNoID = Convert.ToInt32(MaterialNoID);
modelIn1.MaterialNo = materialno;
modelIn1.MaterialDesc = materialdesc;
modelIn1.BatchNo = DateTime.Now.ToString("yyyyMMdd");
modelIn1.ErpVoucherNo = erpvoucherno;
modelIn1.Qty = 1;
modelIn1.SerialNo = squenceforin[kIn++];
modelIn1.Creater = Userno;
modelIn1.ReceiveTime = time2;
//modelIn1.ReceiveTime = string.IsNullOrEmpty(receivetime) ? DateTime.Now : Convert.ToDateTime(receivetime);
modelIn1.BarCode = "2@" + modelIn1.StrongHoldCode + "@" + modelIn1.MaterialNo + "@" + modelIn1.BatchNo + "@" + modelIn1.Qty + "@" + modelIn1.SerialNo;
modelIn1.RowNo = RowNO;
modelIn1.RowNoDel = RowNODel;
modelIn1.BarcodeType = 2;
modelIn1.ProductClass = Createname;
modelIn1.WorkNo = WarehouseName;
modelIn1.TracNo = TracNo;
modelIn1.ProjectNo = ProjectNo;
modelIn1.fserialno = model.SerialNo;
modelIn1.originalCode = flag;
listbarcode.Add(modelIn1);
}
}
}
if (inboxnum == 1)
{
Barcode_Model model = new Barcode_Model();
model.CompanyCode = CompanyCode;
model.StrongHoldCode = StrongHoldCode;
model.MaterialNoID = Convert.ToInt32(MaterialNoID);
model.MaterialNo = materialno;
model.MaterialDesc = materialdesc;
model.BatchNo = DateTime.Now.ToString("yyyyMMdd");
model.ErpVoucherNo = erpvoucherno;
//model.EDate = Convert.ToDateTime(edate);
model.Qty = Convert.ToDecimal(tailnum);
model.SerialNo = squence[k++];
model.Creater = Userno;
//model.EAN = ean;
//model.ReceiveTime = string.IsNullOrEmpty(receivetime) ? DateTime.Now : Convert.ToDateTime(receivetime);
model.ReceiveTime = time1;
model.BarCode = "1@" + model.StrongHoldCode + "@" + model.MaterialNo + "@" + model.BatchNo + "@" + model.Qty + "@" + model.SerialNo;
model.RowNo = RowNO;
model.RowNoDel = RowNODel;
model.BarcodeType = 1;
model.ProductClass = Createname;
model.WorkNo = WarehouseName;
model.TracNo = TracNo;
model.ProjectNo = ProjectNo;
model.originalCode = flag;
listbarcode.Add(model);
if (modelList[0].sku == "是")
{
//本体打印
for (int ii = 0; ii < Convert.ToDecimal(tailnum); ii++)
{
Barcode_Model modelIn2 = new Barcode_Model();
modelIn2.CompanyCode = CompanyCode;
modelIn2.StrongHoldCode = StrongHoldCode;
modelIn2.MaterialNoID = Convert.ToInt32(MaterialNoID);
modelIn2.MaterialNo = materialno;
modelIn2.MaterialDesc = materialdesc;
modelIn2.BatchNo = DateTime.Now.ToString("yyyyMMdd");
modelIn2.ErpVoucherNo = erpvoucherno;
modelIn2.Qty = 1;
modelIn2.SerialNo = squenceforin[kIn++];
modelIn2.Creater = Userno;
modelIn2.ReceiveTime = time2;
//modelIn2.ReceiveTime = string.IsNullOrEmpty(receivetime) ? DateTime.Now : Convert.ToDateTime(receivetime);
modelIn2.BarCode = "2@" + modelIn2.StrongHoldCode + "@" + modelIn2.MaterialNo + "@" + modelIn2.BatchNo + "@" + modelIn2.Qty + "@" + modelIn2.SerialNo;
modelIn2.RowNo = RowNO;
modelIn2.RowNoDel = RowNODel;
modelIn2.BarcodeType = 2;
modelIn2.ProductClass = Createname;
modelIn2.WorkNo = WarehouseName;
modelIn2.TracNo = TracNo;
modelIn2.ProjectNo = ProjectNo;
modelIn2.fserialno = model.SerialNo;
modelIn2.originalCode = flag;
listbarcode.Add(modelIn2);
}
}
}
if (print_DB.SubBarcodes(listbarcode, "sup", 1, ref err))
{
string serialnosB = "";
string serialnosS = "";
for (int i = 0; i < listbarcode.Count; i++)
{
if (listbarcode[i].BarcodeType == 1)
{
serialnosB += listbarcode[i].SerialNo + ",";
}
else
{
serialnosS += listbarcode[i].SerialNo + ",";
}
}
if (serialnosS == "")
{
return(Json(new { state = true, obj = time1.ToString("yyyy/MM/dd HH:mm:ss") }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { state = true, obj = time1.ToString("yyyy/MM/dd HH:mm:ss"), objS = time2.ToString("yyyy/MM/dd HH:mm:ss") }, JsonRequestBehavior.AllowGet));
}
//return Json(new { state = true, obj = serialnosB, objS = serialnosS }, JsonRequestBehavior.AllowGet);
}
else
{
return(Json(new { state = false, obj = err }, JsonRequestBehavior.AllowGet));
}
}
catch (Exception ex)
{
return(Json(new { state = false, obj = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
public ActionResult SaveBarcode(string data)
{
var objT_InStockDetailInfo = JsonConvert.DeserializeObject <T_InStockDetailInfo>(data);
string EveryQty = objT_InStockDetailInfo.EveryQty,
num = objT_InStockDetailInfo.num,
Userno = objT_InStockDetailInfo.Userno,
erpvoucherno = objT_InStockDetailInfo.ErpVoucherNo,
materialno = objT_InStockDetailInfo.MaterialNo,
materialdesc = objT_InStockDetailInfo.MaterialDesc,
RowNO = objT_InStockDetailInfo.RowNo,
RowNODel = objT_InStockDetailInfo.RowNoDel,
MaterialNoID = objT_InStockDetailInfo.MaterialNoID.ToString(),
StrongHoldCode = objT_InStockDetailInfo.StrongHoldCode,
CompanyCode = objT_InStockDetailInfo.CompanyCode,
Createname = objT_InStockDetailInfo.Creater,
WarehouseName = objT_InStockDetailInfo.WareHouseNo,
TracNo = objT_InStockDetailInfo.TracNo,
ProjectNo = objT_InStockDetailInfo.ProjectNo,
BatchNo = objT_InStockDetailInfo.FromBatchNo;
T_InStock_Func InFunc = new T_InStock_Func();
string strMsg = "";
T_InStockInfo InStockInfo = new T_InStockInfo()
{
ID = objT_InStockDetailInfo.HeaderID
};
InFunc.GetModelByID(ref InStockInfo, ref strMsg);
//查物料
T_Material_Func funM = new T_Material_Func();
string strErrMsg = "";
List <T_MaterialInfo> modelList = funM.GetMaterialModelBySql(materialno, ref strErrMsg);
if (modelList == null || modelList.Count == 0)//失败
{
return(Json(new { state = false, obj = "没有该物料号" + materialno }, JsonRequestBehavior.AllowGet));
}
if (string.IsNullOrEmpty(Userno))
{
return(Json(new { state = false, obj = "Cookie失效，重新登陆！" }, JsonRequestBehavior.AllowGet));
}
try
{
DateTime time1 = DateTime.Now;
DateTime time2 = DateTime.Now.AddSeconds(1);
string err = "";
//计算外箱数量,和尾箱数量,和尾箱里面的个数
int outboxnum = 0;
int inboxnum = 0;
decimal tailnum = 0;
GetBoxInfo(ref outboxnum, ref tailnum, ref inboxnum, num, EveryQty);
if (outboxnum == 0)
{
return(Json(new { state = false, obj = "打印数量为0" }, JsonRequestBehavior.AllowGet));
}
Print_DB print_DB = new Print_DB();
List <string> squence = GetSerialnos((outboxnum + inboxnum).ToString(), "外", ref err); //外箱码序列号
List <string> squenceforin = GetSerialnos(num, "内", ref err); //本体序列号
List <Barcode_Model> listbarcode = new List <Barcode_Model>(); //存放打印条码内容
T_Product_DB proDB = new T_Product_DB();
int k = 0;
for (int i = 0; i < outboxnum; i++)//执行打印外箱命令
{
Barcode_Model model = new Barcode_Model();
model.CompanyCode = CompanyCode;
model.StrongHoldCode = StrongHoldCode;
model.MaterialNoID = Convert.ToInt32(MaterialNoID);
model.MaterialNo = materialno;
model.MaterialDesc = materialdesc;
//model.BatchNo = DateTime.Now.ToString("yyyyMMdd");
model.BatchNo = BatchNo;
model.ProductBatch = objT_InStockDetailInfo.ProductBatch;//给批号加密成8位
model.ErpVoucherNo = erpvoucherno;
model.Qty = Convert.ToDecimal(EveryQty);
model.SerialNo = squence[k++];
model.Creater = Userno;
model.ReceiveTime = time1;
model.BarCode = "2@" + model.MaterialNo + "@" + model.Qty + "@" + model.SerialNo;
model.RowNo = RowNO;
model.RowNoDel = RowNODel;
model.BarcodeType = 1;
model.ProductClass = Createname;
model.WorkNo = WarehouseName;
model.TracNo = TracNo;
model.ProjectNo = ProjectNo;
model.SupCode = InStockInfo.SupplierNo;
model.SupName = InStockInfo.SupplierName;
model.StoreCondition = InStockInfo.StrVoucherType;
model.department = InStockInfo.DepartmentCode;
model.departmentname = InStockInfo.DepartmentName;
model.ProtectWay = objT_InStockDetailInfo.sale_vouchertypename;
model.LABELMARK = objT_InStockDetailInfo.Customer_voucherno;
model.CusCode = objT_InStockDetailInfo.SupplierNo;
model.CusName = objT_InStockDetailInfo.SUPPLIERSHORTNAME;
model.erpwarehousename = objT_InStockDetailInfo.ErpWarehouseName;
model.StoreCondition = objT_InStockDetailInfo.CustomerItemCode;
model.spec = objT_InStockDetailInfo.spec;
if (erpvoucherno.Substring(0, 2) == "DC")
{
model.dimension = erpvoucherno;
model.VoucherType = "30";
}
listbarcode.Add(model);
}
if (inboxnum == 1)
{
Barcode_Model model = new Barcode_Model();
model.CompanyCode = CompanyCode;
model.StrongHoldCode = StrongHoldCode;
model.MaterialNoID = Convert.ToInt32(MaterialNoID);
model.MaterialNo = materialno;
model.MaterialDesc = materialdesc;
//model.BatchNo = DateTime.Now.ToString("yyyyMMdd");
model.BatchNo = BatchNo;
model.ProductBatch = objT_InStockDetailInfo.ProductBatch;//给批号加密成8位
model.ErpVoucherNo = erpvoucherno;
model.Qty = Convert.ToDecimal(tailnum);
model.SerialNo = squence[k++];
model.Creater = Userno;
model.ReceiveTime = time1;
model.BarCode = "2@" + model.MaterialNo + "@" + model.Qty + "@" + model.SerialNo;
model.RowNo = RowNO;
model.RowNoDel = RowNODel;
model.BarcodeType = 1;
model.ProductClass = Createname;
model.WorkNo = WarehouseName;
model.TracNo = TracNo;
model.ProjectNo = ProjectNo;
model.SupCode = InStockInfo.SupplierNo;
model.SupName = InStockInfo.SupplierName;
model.StoreCondition = InStockInfo.StrVoucherType;
model.department = InStockInfo.DepartmentCode;
model.departmentname = InStockInfo.DepartmentName;
model.ProtectWay = objT_InStockDetailInfo.sale_vouchertypename;
model.LABELMARK = objT_InStockDetailInfo.Customer_voucherno;
model.CusCode = objT_InStockDetailInfo.SupplierNo;
model.CusName = objT_InStockDetailInfo.SUPPLIERSHORTNAME;
model.erpwarehousename = objT_InStockDetailInfo.ErpWarehouseName;
model.StoreCondition = objT_InStockDetailInfo.CustomerItemCode;
model.spec = objT_InStockDetailInfo.spec;
if (erpvoucherno.Substring(0, 2) == "DC")
{
model.dimension = erpvoucherno;
model.VoucherType = "30";
}
listbarcode.Add(model);
}
if (print_DB.SubBarcodes(listbarcode, "sup", 1, ref err))
{
string serialnosS = "";
for (int i = 0; i < listbarcode.Count; i++)
{
if (listbarcode[i].BarcodeType != 1)
{
serialnosS += listbarcode[i].SerialNo + ",";
}
}
if (serialnosS == "")
{
return(Json(new { state = true, obj = time1.ToString("yyyy/MM/dd HH:mm:ss") }, JsonRequestBehavior.AllowGet));
}
return(Json(new { state = true, obj = time1.ToString("yyyy/MM/dd HH:mm:ss"), objS = time2.ToString("yyyy/MM/dd HH:mm:ss") }, JsonRequestBehavior.AllowGet));
}
return(Json(new { state = false, obj = err }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { state = false, obj = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
