public static string GetBoxContentStr(VoucherType type, Barcode_Model barcode)
{
PrintLibrary.Barcode_Model PrintInfo = GetPrintBarcodeByServiceBarcode(barcode);
if (PrintInfo == null)
{
return(string.Empty);
}
switch (type)
{
case VoucherType.采购订单:
return(PrintLibrary.PrintLibrary_Func.GetPurchaseReceiveInnerContentStr(GetPrintBarcodeByServiceBarcode(barcode), Print_Var.OutboxDPI));
case VoucherType.任意单据:
case VoucherType.送货单:
return(PrintLibrary.PrintLibrary_Func.GetDeliveryReceiceOutContentStr(PrintInfo, Print_Var.OutboxDPI));
case VoucherType.无过账快速入:
case VoucherType.需过账快速入:
PrintInfo.DELIVERYNO = barcode.TrackNo;
return(PrintLibrary.PrintLibrary_Func.GetDeliveryReceiceOutContentStr(PrintInfo, Print_Var.OutboxDPI));
case VoucherType.生产订单:
return(PrintLibrary.PrintLibrary_Func.GetProductionOrderOutContentStr(PrintInfo, Print_Var.OutboxDPI));
case VoucherType.生产退料:
//return PrintLibrary.PrintLibrary_Func.GetProductionReturnOutContentStr(PrintInfo, Print_Var.OutboxDPI);
case VoucherType.检验退料单:
return(PrintLibrary.PrintLibrary_Func.GetQualityReturnOutContentStr(PrintInfo, Print_Var.OutboxDPI));
default:
return(string.Empty);
}
}
public bool GetBarCodeInfoForQueryStock(string strBarCode, ref Barcode_Model Barcode_Model)
{
try
{
string strSerialNo = string.Empty;
if (MaterialBarcodeDecode.InvalidBarcode(strBarCode) == false)
{
strSerialNo = strBarCode;
}
else
{
strSerialNo = MaterialBarcodeDecode.GetSerialNo(strBarCode);
}
ReceiveGoods_DB RGD = new ReceiveGoods_DB();
Barcode_Model = RGD.GetBarCodeInfo(strSerialNo);
if (Barcode_Model == null || string.IsNullOrEmpty(Barcode_Model.SERIALNO))
{
return(false);
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
private bool PrintRow(Barcode_Model barcode, int iPrintQty, ref string sPrintCode)
{
string strError = string.Empty;
barcode.PRINTQTY = iPrintQty;
if (!Print_Func.PrintBarcode(barcode, ref strError))
{
//return false;
}
string strOnce = Print_Func.GetBoxContentStr(_type, barcode);
if (string.IsNullOrEmpty(strOnce))
{
return(Common.Common_Func.ErrorMessage("外箱标签 " + barcode.SERIALNO + " 打印失败", "打印失败"));
}
string strContent = string.Empty;
for (int i = 1; i <= iPrintQty; i++)
{
strContent += strOnce;
}
sPrintCode += strContent;
return(true);
}
private bool PrintRow(Barcode_Model barcode, int iPrintQty, ref string sPrintCode)
{
VoucherType type = (VoucherType)barcode.VOUCHERTYPE.ToInt32();
string strLogo = Print_Func.GetBoxLogoStr(type);
string strClear = Print_Func.GetBoxClearStr(type);
string strOnce = Print_Func.GetBoxContentStr(type, barcode);
if (string.IsNullOrEmpty(strOnce))
{
return(Common.Common_Func.ErrorMessage("外箱标签 " + barcode.SERIALNO + " 打印失败", "打印失败"));
}
string strContent = string.Empty;
for (int i = 1; i <= iPrintQty; i++)
{
strContent += strOnce;
}
sPrintCode += strLogo;
sPrintCode += strContent;
sPrintCode += strClear;
return(true);
}
private List <Barcode_Model> CreateProductionReturnDetails(IRfcTable rtb)
{
List <Barcode_Model> lstBarcode = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstBarcode = new List <Barcode_Model>();
}
Barcode_Model barcode;
foreach (var itemRtb in rtb)
{
barcode = new Barcode_Model();
barcode.DELIVERYNO = itemRtb.GetString("BEDNR");
barcode.CreateTime = string.Empty;
barcode.ROWNO = itemRtb.GetString("BSPOS");
barcode.TrackNo = itemRtb.GetString("AUFNR");
barcode.VOUCHERNO = itemRtb.GetString("BEDNR");
barcode.MATERIALNO = itemRtb.GetString("MATNR");
barcode.MATERIALDESC = itemRtb.GetString("MAKTX");
barcode.ClaimArriveTime = string.Empty;
barcode.Unit = string.Empty;
barcode.CURRENTLYDELIVERYNUM = itemRtb.GetInt("MENGE");
barcode.ClaimDeliveryNum = 0;
barcode.ReadyDeliveryNum = 0;
barcode.WaitDeliveryNum = 0;
barcode.InRoadDeliveryNum = 0;
barcode.ReceiveTime = string.Empty;
barcode.DeliveryAddress = string.Empty;
barcode.CorrespondDepartment = itemRtb.GetString("DEPARTMENT");
barcode.WorkCode = string.Empty;
barcode.JingxinName = string.Empty;
barcode.Plant = itemRtb.GetString("WERKS");
barcode.PRDVERSION = string.Empty;
barcode.Reason = itemRtb.GetString("PMTXT");
barcode.ReserveNumber = itemRtb.GetString("RSNUM");
barcode.ReserveRowNo = itemRtb.GetString("RSPOS");
barcode.ISROHS = 1;
if (!string.IsNullOrEmpty(barcode.TrackNo))
{
barcode.TrackNo = barcode.TrackNo.TrimStart('0');
}
if (Common.Common_Func.IsAllZero(barcode.ReserveNumber))
{
barcode.ReserveNumber = string.Empty;
}
if (Common.Common_Func.IsAllZero(barcode.ReserveRowNo))
{
barcode.ReserveRowNo = string.Empty;
}
lstBarcode.Add(barcode);
}
}
return(lstBarcode);
}
private void GetQueryMain()
{
if (queryMain == null)
{
queryMain = new Barcode_Model(); bsMain.DataSource = queryMain;
}
queryMain.VOUCHERTYPE = _type.ToInt32().ToString();
}
public FrmPrintRecordQuery()
{
InitializeComponent();
Common.Common_Func.DelDataGridViewSortable(dgvList);
queryMain = new Barcode_Model();
}
private void GetQueryMain()
{
if (queryMain == null)
{
queryMain = new Barcode_Model(); bsMain.DataSource = queryMain;
}
//queryMain.Supplier = supplier.SupplierCode;
}
public FrmOutBarcodeRePrint()
{
InitializeComponent();
Common.Common_Func.DelDataGridViewSortable(dgvList);
_type = VoucherType.任意单据;
queryMain = new Barcode_Model();
}
public int GetArrivalRowNo(Barcode_Model model)
{
string strSql = string.Format(@"select a.ivouchrowno from pu_arrbody a
join pu_ArrHead b on a.id = b.id
join copypolist c on a.iposid = c.id
where c.cordercode = '{0}' and c.ivouchrowno = '{1}' and b.ccode = '{2}'", model.VOUCHERNO, model.ROWNO, model.ArrivalCode);
return(OperationSql.ExecuteScalarForU8(CommandType.Text, strSql, null).ToInt32());
}
private void GetQueryMain()
{
if (queryMain == null)
{
queryMain = new Barcode_Model(); bsMain.DataSource = queryMain;
}
queryMain.BARCODETYPE = 10;
queryMain.VOUCHERTYPE = queryMain.iVoucherType >= 1 ? queryMain.iVoucherType.ToString() : string.Empty;
}
private void InitMainQuery()
{
_serverMainPage = new DividPage();
queryMain = new Barcode_Model();
lstMain = new List <Barcode_Model>();
pageList.GetShowCountsByDGV(dgvList);
bsMain.DataSource = queryMain;
}
/// <summary>
/// 获取上架任务
/// </summary>
/// <returns></returns>
public List <Task_Model> GetTaskInfo(UserInfo userModel, Barcode_Model barcodeMdl)
{
try
{
List <Task_Model> lstTask = new List <Task_Model>();
string strSql = string.Empty;
if (string.IsNullOrEmpty(barcodeMdl.SERIALNO))
{
strSql = string.Format("select * from V_GETTASKINFO where F_USERINWAREHOUSE(warehouse_id,'{0}')>0", userModel.WarehouseCode);
}
else
{
if (barcodeMdl.VOUCHERTYPE == "50" || barcodeMdl.VOUCHERTYPE == "60")
{
strSql = string.Format("select * from V_GETTASKINFO a where F_USERINWAREHOUSE(a.warehouse_id,'{0}')>0 and taskno = '{1}'", userModel.WarehouseCode, barcodeMdl.DELIVERYNO);
}
else
{
//strSql = string.Format("select * from V_GETTASKINFO a where F_USERINWAREHOUSE(a.warehouse_id,'{0}')>0 and deliveryno = '{1}'", userModel.WarehouseCode, barcodeMdl.DELIVERYNO);
strSql = string.Format(@"SELECT ID,TaskNo,'生产订单' VoucherTypeName
, IsShelvePost, IsQuality, CreateDateTime, DeliveryNo MaterialDoc
, VoucherType, DeliveryNo, (select top 1 username from T_USER where T_USER.userno =[T_TASK].receiveuserno and isdel = 1) ReceiveUserName
FROM[T_TASK] where deliveryno = '{0}'", barcodeMdl.DELIVERYNO);
}
}
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
while (dr.Read())
{
Task_Model TM = new Task_Model();
TM.ID = Convert.ToInt32(dr["ID"]);
TM.TaskNo = dr["taskno"].ToDBString();
TM.ReceiveUserName = dr["receiveusername"].ToDBString();
TM.VoucherTypeName = dr["vouchertypename"].ToDBString();
TM.IsShelvePost = dr["isshelvepost"].ToInt32();
TM.IsQuality = dr["IsQuality"].ToInt32();
TM.CreateDateTime = dr["CreateDateTime"].ToDateTime();
TM.MaterialDoc = dr["materialdoc"].ToDBString();
TM.VoucherType = dr["VoucherType"].ToInt32();
TM.DeliveryNo = dr["deliveryno"].ToDBString();
lstTask.Add(TM);
}
}
return(lstTask);
}
catch (Exception ex)
{
throw ex;
}
}
public FrmOutBarcodeRePrint(VoucherType type, Barcode_Model barcode)
{
InitializeComponent();
Common.Common_Func.DelDataGridViewSortable(dgvList);
_type = type;
queryMain = barcode;
SetForm();
}
public string GetTaskInfo(string strUserJson, string strBarcode)
{
TaskHead_Model taskHeadModel = new TaskHead_Model();
try
{
string strBarcodeJson = string.Empty;
Barcode_Model barcodeMdl = new Barcode_Model();
UserInfo userModel = JSONUtil.JSONHelper.JsonToObject <UserInfo>(strUserJson);
if (userModel == null || string.IsNullOrEmpty(userModel.UserNo))
{
return(GetFailJson(ref taskHeadModel, "没有用户信息！"));
}
if (string.IsNullOrEmpty(strBarcode))
{
//return GetFailJson(ref taskHeadModel, "请扫描或输入条码！");
barcodeMdl = new Barcode_Model();
barcodeMdl.Status = "S";
}
else
{
ReceiveGoods.ReceiveGoods_Func RGF = new ReceiveGoods.ReceiveGoods_Func();
strBarcodeJson = RGF.GetBarCodeInfo(strBarcode);
barcodeMdl = JSONUtil.JSONHelper.JsonToObject <Barcode_Model>(strBarcodeJson);
}
if (barcodeMdl.Status == "E")
{
return(GetFailJson(ref taskHeadModel, barcodeMdl.Message));
}
Task_DB TDB = new Task_DB();
List <Task_Model> lstTask = new List <Task_Model>();
lstTask = TDB.GetTaskInfo(userModel, barcodeMdl);
if (lstTask == null || lstTask.Count <= 0)
{
return(GetFailJson(ref taskHeadModel, "没有上架任务！"));
}
taskHeadModel.lstTaskInfo = lstTask;
taskHeadModel.Status = "S";
return(JSONUtil.JSONHelper.ObjectToJson <TaskHead_Model>(taskHeadModel));
}
catch (Exception ex)
{
return(GetFailJson(ref taskHeadModel, ex.Message));
}
}
public string GetStockInfoByMaterialNo(string strBarcodeOrMaterialNo, string strUserJson)
{
StockHead_Model stockHeadModel = new StockHead_Model();
try
{
bool bSucc = false;
if (string.IsNullOrEmpty(strBarcodeOrMaterialNo))
{
stockHeadModel.Status = "E";
stockHeadModel.Message = "请先扫描条码或输入物料编号！";
return(JSONUtil.JSONHelper.ObjectToJson <StockHead_Model>(stockHeadModel));
}
UserInfo userModel = JSONUtil.JSONHelper.JsonToObject <UserInfo>(strUserJson);
if (userModel == null || string.IsNullOrEmpty(userModel.UserNo))
{
stockHeadModel.Status = "E";
stockHeadModel.Message = "没有获取用户信息！";
return(JSONUtil.JSONHelper.ObjectToJson <StockHead_Model>(stockHeadModel));
}
Barcode_Model Barcode_Model = new Barcode_Model();
ReceiveGoods.ReceiveGoods_Func RGF = new ReceiveGoods.ReceiveGoods_Func();
bSucc = RGF.GetBarCodeInfoForQueryStock(strBarcodeOrMaterialNo, ref Barcode_Model);
if (bSucc == true)
{
stockHeadModel.lstStockInfo = GetStockByMaterialNo(Barcode_Model.MATERIALNO);
}
else
{
stockHeadModel.lstStockInfo = GetStockByMaterialNo(strBarcodeOrMaterialNo);
}
if (stockHeadModel.lstStockInfo == null || stockHeadModel.lstStockInfo.Count == 0)
{
stockHeadModel.Status = "E";
stockHeadModel.Message = "您扫描的物料或条码没有库存！";
return(JSONUtil.JSONHelper.ObjectToJson <StockHead_Model>(stockHeadModel));
}
stockHeadModel.Status = "S";
return(JSONUtil.JSONHelper.ObjectToJson <StockHead_Model>(stockHeadModel));
}
catch (Exception ex)
{
stockHeadModel.Status = "E";
stockHeadModel.Message = "Web异常:" + ex.Message;
return(JSONUtil.JSONHelper.ObjectToJson <StockHead_Model>(stockHeadModel));
}
}
public static bool GetOutBarcodeListByBarcode(Barcode_Model parameter, ref List <Barcode_Model> lstOutBarcode, ref string strError)
{
try
{
return(WMSWebService.service.GetOutBarcodeListByBarcode(parameter, ref lstOutBarcode, ref strError));
}
catch (Exception ex)
{
strError = ex.Message;
return(false);
}
}
public Barcode_Model GetBarCodeInfo(string strSerialNo)
{
try
{
string strSql = string.Format("select supcode,SUPNAME,ID,VOUCHERTYPE,DELIVERYNO,VOUCHERNO,ROWNO,QTY, OUTPACKQTY,BARCODE,BARCODETYPE,SERIALNO,MATERIALNO,MATERIALDESC,MATERIALSTD,BATCHNO,ROWNO,TrayID,ISNULL(iFlag,0) iFlag,[ProductLineNo] cProductLineCode,SoCode,ArrivalCode from t_outbarcode where serialno = '{0}'", strSerialNo);
Barcode_Model barcodeMdl = new Barcode_Model();
using (SqlDataReader dr = OperationSql.ExecuteReader(System.Data.CommandType.Text, strSql))
{
if (dr.Read())
{
barcodeMdl.ID = dr["id"].ToDecimal();
barcodeMdl.DELIVERYNO = dr["DELIVERYNO"].ToDBString();
barcodeMdl.VOUCHERNO = dr["VOUCHERNO"].ToDBString();
barcodeMdl.ROWNO = dr["ROWNO"].ToDBString();
barcodeMdl.OUTPACKQTY = dr["OUTPACKQTY"].ToDecimal();
barcodeMdl.labeltype = dr["BARCODETYPE"].ToDBString();
barcodeMdl.QTY = dr["QTY"].ToDecimal();
barcodeMdl.BARCODE = dr["barcode"].ToDBString();
barcodeMdl.SERIALNO = dr["serialno"].ToDBString();
barcodeMdl.MATERIALNO = dr["materialno"].ToDBString();
barcodeMdl.MATERIALDESC = dr["materialdesc"].ToDBString();
barcodeMdl.MATERIALSTD = dr["materialstd"].ToDBString();//规格型号
barcodeMdl.BATCHNO = dr["batchno"].ToDBString();
//barcodeMdl.ROWNO = dr["rowno"].ToDBString();
barcodeMdl.VOUCHERTYPE = dr["VOUCHERTYPE"].ToDBString();
barcodeMdl.TrayID = dr["TrayID"].ToInt32();
barcodeMdl.iFlag = dr["iFlag"].ToInt32();
barcodeMdl.cProductLineCode = dr["cProductLineCode"].ToDBString();//产线
barcodeMdl.SoCode = dr["SoCode"].ToDBString();
barcodeMdl.ArrivalCode = dr["ArrivalCode"].ToDBString();
barcodeMdl.SUPCODE = dr["SUPCODE"].ToDBString();
barcodeMdl.SUPNAME = dr["SUPNAME"].ToDBString();
}
}
if (barcodeMdl.TrayID != 0)
{
Tray_Func tf = new Tray_Func();
Tray_Model tray = new Tray_Model();
if (tf.GetTrayInfoByTrayID(barcodeMdl, ref tray))
{
barcodeMdl.tray_Model = tray;
}
}
return(barcodeMdl);
}
catch (Exception ex)
{
throw ex;
}
}
private void InitMainQuery()
{
parameter = new Barcode_Model();
parameter.PRINTQTY = _type == VoucherType.送货单 ? 2 : 1;
lstBarcode = new List <Barcode_Model>();
_serverMainPage = new DividPage();
queryMain = new Barcode_Model();
lstMain = new List <Barcode_Model>();
//pageList.GetShowCountsByDGV(dgvList);
pageList.dDividPage.CurrentPageShowCounts = 1000;
bsCreate.DataSource = parameter;
bsMain.DataSource = queryMain;
}
private void RePrint()
{
Barcode_Model query = new Barcode_Model();
if (parameter != null)
{
//query.VOUCHERTYPE = parameter.VOUCHERTYPE;
//query.VOUCHERNO = parameter.VOUCHERNO;
query.DELIVERYNO = parameter.DELIVERYNO;
}
using (FrmOutBarcodeRePrint frm = new FrmOutBarcodeRePrint(_type, query))
{
frm.ShowDialog();
}
}
private List <Barcode_Model> CreateProductionDetails(IRfcTable rtb)
{
List <Barcode_Model> lstBarcode = null;
if (rtb != null)
{
if (rtb.RowCount > 0)
{
lstBarcode = new List <Barcode_Model>();
}
Barcode_Model barcode;
foreach (var itemRtb in rtb)
{
barcode = new Barcode_Model();
barcode.DELIVERYNO = itemRtb.GetString("AUFNR").TrimStart('0');
barcode.CreateTime = string.Empty;
barcode.ROWNO = string.Empty;
barcode.VOUCHERNO = itemRtb.GetString("AUFNR").TrimStart('0');
barcode.MATERIALNO = itemRtb.GetString("MATNR");
barcode.MATERIALDESC = itemRtb.GetString("MAKTX");
barcode.ClaimArriveTime = string.Empty;
barcode.Unit = string.Empty;
barcode.CURRENTLYDELIVERYNUM = itemRtb.GetInt("GAMNG");
barcode.ClaimDeliveryNum = 0;
barcode.ReadyDeliveryNum = 0;
barcode.WaitDeliveryNum = 0;
barcode.InRoadDeliveryNum = 0;
barcode.ReceiveTime = string.Empty;
barcode.DeliveryAddress = string.Empty;
barcode.CorrespondDepartment = string.Empty;
barcode.WorkCode = string.Empty;
barcode.JingxinName = string.Empty;
barcode.Plant = itemRtb.GetString("WERKS");
barcode.AndalaNo = string.Empty;
barcode.TrackNo = string.Empty;
barcode.Reason = string.Empty;
barcode.PRDVERSION = string.Empty;
barcode.ReserveNumber = string.Empty;
barcode.ReserveRowNo = string.Empty;
barcode.ISROHS = 1;
lstBarcode.Add(barcode);
}
}
return(lstBarcode);
}
/// <summary>
/// 获取表格数据
/// </summary>
/// <returns></returns>
public ActionResult GetData(string path)
{
try
{
if (string.IsNullOrEmpty(path))
{
return(Json(new { Result = -1, ResultValue = "获取不到数据！" }, JsonRequestBehavior.AllowGet));
}
List <Barcode_Model> barcodelist = new List <Barcode_Model>();
DataTable dt = ImportExcelFilexlsx(path);
for (int i = 0; i < dt.Rows.Count; i++)
{
Barcode_Model barcode = new Barcode_Model();
barcode.MaterialNo = dt.Rows[i][0].ToString();
barcode.MaterialDesc = dt.Rows[i][1].ToString();
barcode.spec = dt.Rows[i][2].ToString();
barcode.StoreCondition = dt.Rows[i][3].ToString();//客户型号
barcode.BatchNo = dt.Rows[i][4].ToString();
barcode.ProductBatch = dt.Rows[i][5].ToString();
barcode.StrongHoldCode = dt.Rows[i][6].ToString();
barcode.warehouseno = dt.Rows[i][7].ToString();
barcode.warehousename = dt.Rows[i][8].ToString();
barcode.department = dt.Rows[i][9].ToString();//部门编码
barcode.departmentname = dt.Rows[i][10].ToString();
barcode.CusCode = dt.Rows[i][11].ToString();
barcode.CusName = dt.Rows[i][12].ToString();
barcode.ProtectWay = dt.Rows[i][13].ToString(); //单据类型
barcode.LABELMARK = dt.Rows[i][14].ToString(); //客户订单号
barcode.Qty = Convert.ToDecimal(dt.Rows[i][15]);
barcode.Unit = dt.Rows[i][16].ToString();
barcode.InnerPackQty = Convert.ToDecimal(dt.Rows[i][17]);
barcodelist.Add(barcode);
}
if (barcodelist == null || barcodelist.Count == 0)
{
return(Json(new { Result = -1, ResultValue = "获取不到数据！" }, JsonRequestBehavior.AllowGet));
}
return(Json(new { Result = 1, Data = barcodelist }, JsonRequestBehavior.AllowGet));
}
catch (Exception ex)
{
return(Json(new { Result = -1, ResultValue = ex.ToString() }, JsonRequestBehavior.AllowGet));
}
}
private void PrintLabel()
{
int StartX = nbStartX.Value.ToInt32();
int StartY = nbStartY.Value.ToInt32();
int Width = nbWidth.Value.ToInt32();
int Heigh = nbHeigh.Value.ToInt32();
string BasicFontName = txtBasicFontName.Text;
int BasicFontSize = nbBasicFontSize.Value.ToInt32();;
int BaiscColMargin = nbBaiscColMargin.Value.ToInt32();
int BasicRowHeigh = nbBasicRowHeigh.Value.ToInt32();
int MinRowMargin = nbMinRowMargin.Value.ToInt32();
int PictrueTopPad = nbPictrueTopPad.Value.ToInt32();
int PictrueRightPad = nbPictrueRightPad.Value.ToInt32();
int CheckedMargin = nbCheckedMargin.Value.ToInt32();
int CheckedOffset = nbCheckedOffset.Value.ToInt32();
Barcode_Model barcode = new Barcode_Model();
barcode.CUSNAME = "京信通信";
barcode.SUPCODE = "600212";
barcode.SUPNAME = "深圳市威凌科技有限公司";
barcode.MATERIALNO = "102001-000055-00";
barcode.MATERIALDESC = "DB15,直针焊板带螺母(三排) DB15,直针焊板带螺母(三排)";
barcode.VOUCHERNO = "4700286343";
barcode.ROWNO = "00010";
barcode.QTY = 500;
barcode.PRDVERSION = "TEST VER.";
barcode.BATCHNO = "20140714";
barcode.INNERCOUNT = 5;
barcode.INNERPACKQTY = 100;
barcode.MANTISSAQTY = 0;
barcode.OUTCOUNT = 10;
barcode.BATCHQTY = 5000;
barcode.BARCODENO = 1;
barcode.SERIALNO = "201507140044";
barcode.BARCODE = "10@102001-000055-00@201507140044";
barcode.BPlatedSilver = true;
PrintLibrary.PrintLibrary_Func.PrintTest(Print_Func.GetPrintBarcodeByServiceBarcode(barcode), Print_Var.OutboxPrinter, 200, StartX, StartY, Width, Heigh, BasicFontName, BasicFontSize, BaiscColMargin, BasicRowHeigh, MinRowMargin, PictrueTopPad, PictrueRightPad, CheckedMargin, CheckedOffset);
}
private void InitMainQuery()
{
//supplier = null;
parameter = new Barcode_Model()
{
PRINTQTY = 1
};
lstBarcode = new List <Barcode_Model>();
_serverMainPage = new DividPage();
queryMain = new Barcode_Model();
lstMain = new List <Barcode_Model>();
//pageList.GetShowCountsByDGV(dgvList);
pageList.dDividPage.CurrentPageShowCounts = 1000;
bsCreate.DataSource = parameter;
bsMain.DataSource = queryMain;
}
internal bool IsChecking(Barcode_Model barcodeMdl, ref string strErrorMsg)
{
string strSql = "";
if (barcodeMdl.iFlag != 0 && barcodeMdl.iFlag != 10)
{
if (barcodeMdl.labeltype.Equals("10") || barcodeMdl.labeltype.Equals("14"))
{
strSql = string.Format("select a.serialno from T_OUTBARCODE a join T_INNERBARCODE b on a.id=b.outbox_id where b.serialno = '{0}'", barcodeMdl.SERIALNO);
string oSerialno = OperationSql.ExecuteScalar(CommandType.Text, strSql, null).ToDBString();
if (string.IsNullOrEmpty(oSerialno))
{
return(false);
}
barcodeMdl.SERIALNO = oSerialno;
}
strSql = string.Format("select b.areastatus,b.CheckID [ACheckID],a.status,a.CheckID [SCheckID] from t_stock a join T_AREA b on a.areano=b.areano where serialno='{0}'", barcodeMdl.SERIALNO);
using (SqlDataReader sdr = OperationSql.ExecuteReader(CommandType.Text, strSql, null))
{
if (sdr.Read())
{
if (sdr[0].ToInt32() != 1 && !string.IsNullOrEmpty(sdr[1].ToString()))
{
strErrorMsg = "该条码所在货位正在盘点！";
return(true);
}
if (sdr[2].ToInt32() != 1 && !string.IsNullOrEmpty(sdr[3].ToString()))
{
strErrorMsg = "该物料正在盘点！";
return(true);
}
}
else
{
if (barcodeMdl.iFlag != 4 && barcodeMdl.iFlag != 5)
{
strErrorMsg = "该条码库存有误！";
return(true);
}
}
}
}
return(false);
}
private void SetCreateInfo()
{
Barcode_Model row = lstMain[dgvList.CurrentCell.RowIndex];
if (row == null)
{
return;
}
parameter = row;
parameter.PRINTQTY = 1;
bsCreate.DataSource = parameter;
bsCreate.ResetBindings(false);
bsCreate.EndEdit();
txtNQty.Focus();
txtNQty.SelectAll();
}
private bool PrintRow(Barcode_Model barcode, int iPrintQty, ref string sPrintCode)
{
string strOnce = Print_Func.GetBoxContentStr(VoucherType.任意单据, barcode);
if (string.IsNullOrEmpty(strOnce))
{
return(Common.Common_Func.ErrorMessage("外箱标签 " + barcode.SERIALNO + " 打印失败", "打印失败"));
}
string strContent = string.Empty;
for (int i = 1; i <= iPrintQty; i++)
{
strContent += strOnce;
}
sPrintCode += strContent;
return(true);
}
private void BindList()
{
string strErrMsg = string.Empty;
if (areainfo == null)
{
strErrMsg = "请先输入一个有效的货位！";
MessageBox.Show(strErrMsg);
return;
}
try
{
barcode = WMS.Common.WMSWebService.service.GetCheckBarcodeInfo(txtBarcode.Text.Trim(), ref strErrMsg);
if (barcode == null || !string.IsNullOrEmpty(strErrMsg))
{
if (string.IsNullOrEmpty(strErrMsg))
{
strErrMsg = "条码有误！";
}
throw new Exception(strErrMsg);
}
if (!WMS.Common.WMSWebService.service.SaveCheckOmitAdd(barcode.SERIALNO, areainfo, ref strErrMsg))
{
throw new Exception(strErrMsg);
}
barcode.AreaNo = areainfo.AreaNo;
lstBarcode.Add(barcode);
chensDataGridView1.DataSource = lstBarcode;
chensDataGridView1.Refresh();
}
catch (Exception ex)
{
strErrMsg = ex.Message;
MessageBox.Show(strErrMsg);
}
finally
{
txtBarcode.SelectAll();
txtBarcode.Focus();
}
}
private void GetCreatePara()
{
if (parameter == null)
{
parameter = new Barcode_Model();
}
int index = dgvList.CurrentCell.RowIndex;
if (index < 0)
{
index = 0;
}
Barcode_Model row = lstMain[index];
parameter.BARCODETYPE = 20;
parameter.VOUCHERNO = row.VOUCHERNO;
parameter.WaitDeliveryNum = row.WaitDeliveryNum;
parameter.CURRENTLYDELIVERYNUM = row.CURRENTLYDELIVERYNUM;
parameter.ROWNO = row.ROWNO;
parameter.VOUCHERQTY = row.CURRENTLYDELIVERYNUM;
parameter.DELIVERYNO = row.DELIVERYNO;
parameter.PRDVERSION = row.PRDVERSION;
parameter.CUSNAME = "京信通信";
parameter.SUPNAME = row.SUPNAME;
parameter.SUPCODE = row.SUPCODE;
parameter.VOUCHERTYPE = _type.ToInt32().ToString();
parameter.ISROHS = row.ISROHS;
parameter.PLATEDGOLD = parameter.BPlatedGold ? 2 : 1;
parameter.PLATEDSILVER = parameter.BPlatedSilver ? 2 : 1;
parameter.PLATEDTIN = parameter.BPlatedTin ? 2 : 1;
parameter.OTHERS = parameter.BPlatedOther ? 2 : 1;
parameter.OPERATOR = Common_Var.CurrentUser.UserName;
parameter.TrackNo = null;
parameter.ReserveNumber = null;
parameter.ReserveRowNo = null;
parameter.SHOWSUP = parameter.BSHOWSUP ? 2 : 1;
parameter.OUTPACKQTY = parameter.INNERPACKQTY;
}
private void ClearForm()
{
lstBarcode = new List <Barcode_Model>();
parameter = new Barcode_Model();
bsCreate.DataSource = parameter;
txtMaterialNo.Enabled = true;
btnGetMaterial.Enabled = true;
txtMaterialDesc.Enabled = false;
txtBatchNo.Enabled = false;
txtSupCode.Enabled = false;
txtSupName.Enabled = false;
txtOutPackQty.Enabled = false;
cbxPlatedSilver.Enabled = false;
cbxPlatedTin.Enabled = false;
cbxOther.Enabled = false;
txtPrintQty.Enabled = false;
tsmiPrint.Enabled = false;
bsCreate.ResetBindings(false);
bsCreate.EndEdit();
}
