public override void AfterBarItemClick(AfterBarItemClickEventArgs e) { base.AfterBarItemClick(e); //客户回签签单打印 传Fid ,不需要自动打印,加一个按钮打印 //补打标签 if (e.BarItemKey.EqualsIgnoreCase("SZXY_tbGridPrintNoBD")) { this.Model.DataObject["FFormId"] = this.View.BusinessInfo.GetForm().Id; Utils.Save(View, new DynamicObject[] { this.Model.DataObject }, Kingdee.BOS.Orm.OperateOption.Create(), Context); string F_SZXY_ForLabel = Convert.ToString(this.Model.GetValue("F_SZXY_ForLabel"));//输入的补打标签 DynamicObject OrgObj = this.Model.GetValue("F_SZXY_OrgId") as DynamicObject; if (OrgObj != null && !F_SZXY_ForLabel.IsNullOrEmptyOrWhiteSpace()) { long orgid = Convert.ToInt64(OrgObj["Id"]); //如果输入的是分切条码号 string SelSql = $" /*dialect*/select T1.F_SZXY_CBNO1,T1.F_SZXY_CUST,T4.FNAME " + $" from SZXY_t_KHHQDEntry T1 " + $"left join SZXY_t_KHHQD T2 on t1.fid=T2.fid " + $"left join T_BD_MATERIAL T3 on T3.FMATERIALID = T1.F_SZXY_MATERIAL " + $"left join T_BD_MATERIAL_L T4 on t3.FMATERIALID = T4.FMATERIALID " + $"where T1.F_SZXY_CBNO1='{F_SZXY_ForLabel}' "; DataSet SelSqlds = DBServiceHelper.ExecuteDataSet(this.Context, SelSql); //如果输入的是生产订单号加行号 string SelSql1 = $"/*dialect*/select " + $"T1.F_SZXY_CBNO1 ,T1.F_SZXY_CUST,T4.FNAME " + $" from SZXY_t_KHHQDEntry T1 " + $"left join SZXY_t_KHHQD T2 on t1.fid=T2.fid " + $"left join T_BD_MATERIAL T3 on T3.FMATERIALID = T1.F_SZXY_MATERIAL " + $"left join T_BD_MATERIAL_L T4 on t3.FMATERIALID = T4.FMATERIALID " + $" where T1.F_SZXY_MONOE+CAST(T1.F_SZXY_MOLINENOE as varchar(50))='{F_SZXY_ForLabel}' " + $" group by T1.F_SZXY_CBNO1 ,F_SZXY_CUST,T4.FNAME "; DataSet SelSqlds1 = DBServiceHelper.ExecuteDataSet(this.Context, SelSql1); string InType = ""; if (SelSqlds.Tables[0].Rows.Count > 0) { InType = "BarNo"; Logger.Debug("输入的是条码号", SelSql); } if (SelSqlds1.Tables[0].Rows.Count > 0) { InType = "BillNo"; Logger.Debug("输入的是生产订单号", SelSql1); } if (InType == "") { this.View.ShowWarnningMessage("没有匹配到信息,请输入条码号或者生产订单号+行号!"); return; } //是否指定标签模板 string PJSQL = " "; //DynamicObject PrintTemp = this.Model.GetValue("F_SZXY_LabelPrint") as DynamicObject; //if (PrintTemp != null) //{ // string PId = Convert.ToString(PrintTemp["Id"]); // if (!PId.IsNullOrEmptyOrWhiteSpace()) // { // PJSQL = $" and T1.Fid={PId} "; // } //} string MacInfo = Utils.GetMacAddress(); Logger.Debug("当前MAC地址", MacInfo); #region //条码号 orgid = Convert.ToInt64(OrgObj["Id"]); StringBuilder STR = new StringBuilder(); DataSet PrintModelDS = null; int ckb = 0; if (InType == "BarNo" && SelSqlds.Tables[0].Rows.Count > 0 && !F_SZXY_ForLabel.IsNullOrEmptyOrWhiteSpace() && orgid != 0) { for (int i = 0; i < SelSqlds.Tables[0].Rows.Count; i++) { string F_SZXY_CUSTID = Convert.ToString(SelSqlds.Tables[0].Rows[i]["F_SZXY_CUST"]); string FNAME = Convert.ToString(SelSqlds.Tables[0].Rows[i]["FNAME"]); if (!MacInfo.IsNullOrEmptyOrWhiteSpace()) { if (i == 0) { PrintModelDS = XYStraddleCut.getPrintModel(this.View, Context, PJSQL, orgid.ToString(), MacInfo, F_SZXY_CUSTID, FNAME, F_SZXY_ForLabel, "BarNo", ref ckb); } STR.Append($"'{F_SZXY_ForLabel}',"); } } if (STR.ToString() != "" && !STR.ToString().IsNullOrEmptyOrWhiteSpace()) { string BarNoStr = STR.ToString(); BarNoStr = BarNoStr.Substring(0, BarNoStr.Length - 1); if (PrintModelDS != null) { XYStraddleCut.Print(PrintModelDS, ckb, Context, this.View, BarNoStr, "BarNo"); } } } //生产订单号+行号 if (InType == "BillNo" && SelSqlds1.Tables[0].Rows.Count > 0 && !F_SZXY_ForLabel.IsNullOrEmptyOrWhiteSpace() && orgid > 0) { if (SelSqlds1 != null && SelSqlds1.Tables.Count > 0 && SelSqlds1.Tables[0].Rows.Count > 0) { int j = 0; for (int i = 0; i < SelSqlds1.Tables[0].Rows.Count; i++) { string F_SZXY_CUSTID = Convert.ToString(SelSqlds1.Tables[0].Rows[i]["F_SZXY_CUST"]); string FNAME = Convert.ToString(SelSqlds1.Tables[0].Rows[i]["FNAME"]); string F_SZXY_BARCODEE = Convert.ToString(SelSqlds1.Tables[0].Rows[i]["F_SZXY_CBNO1"]); if (!MacInfo.IsNullOrEmptyOrWhiteSpace() && !F_SZXY_BARCODEE.IsNullOrEmptyOrWhiteSpace() && F_SZXY_BARCODEE != "") { if (j == 0) { j++; PrintModelDS = XYStraddleCut.getPrintModel(this.View, Context, PJSQL, orgid.ToString(), MacInfo, F_SZXY_CUSTID, FNAME, F_SZXY_BARCODEE, "BillNo", ref ckb); } STR.Append($"'{F_SZXY_BARCODEE}',"); } } if (STR.ToString() != "") { string BarNoStr = STR.ToString(); BarNoStr = BarNoStr.Substring(0, BarNoStr.Length - 1); if (PrintModelDS != null) { XYStraddleCut.Print(PrintModelDS, ckb, Context, this.View, $"'{F_SZXY_ForLabel}'", "BillNo"); } } } Logger.Debug($"箱号匹配到:{SelSqlds.Tables[0].Rows.Count}条数据", $" 生产订单号+行号匹配到:{SelSqlds1.Tables[0].Rows.Count}条数据"); #endregion } } } }
public override void AfterBarItemClick(AfterBarItemClickEventArgs e) { base.AfterBarItemClick(e); if (e.BarItemKey.EqualsIgnoreCase("SZXY_tbGridPrintNo")) { this.Model.DataObject["FFormId"] = this.View.BusinessInfo.GetForm().Id; Utils.Save(View, new DynamicObject[] { this.Model.DataObject }, Kingdee.BOS.Orm.OperateOption.Create(), Context); string F_SZXY_ForLabel = Convert.ToString(this.Model.GetValue("F_SZXY_ForLabel"));//补打标签 if (this.Model.GetValue("F_SZXY_OrgId") is DynamicObject OrgObj && !F_SZXY_ForLabel.IsNullOrEmptyOrWhiteSpace()) { long orgid = Convert.ToInt64(OrgObj["Id"]); //如果输入的是箱号 string SelSql = $"/*dialect*/select T1.F_SZXY_BOXNOE from SZXY_t_XYDCJXXBEntry T1 left join SZXY_t_XYDCJXXB T2 on t1.fid=T2.fid " + $"where T1.F_SZXY_BOXNOE='{F_SZXY_ForLabel}'" + $" group by T1.F_SZXY_BOXNOE"; DataSet SelSqlds = DBServiceHelper.ExecuteDataSet(this.Context, SelSql); if (SelSqlds.Tables[0].Rows.Count > 0 && SelSqlds != null && SelSqlds.Tables.Count > 0) { } else { this.View.ShowWarnningMessage("没有找到此箱号的信息"); return; } string MacInfo = Utils.GetMacAddress(); Logger.Debug("当前MAC地址", MacInfo); DataSet PrintModelDS = null; int ckb = 0; orgid = Convert.ToInt64(OrgObj["Id"]); //是否指定标签模板 string PJSQL = " "; DynamicObject PrintTemp = this.Model.GetValue("F_SZXY_Tagtype") as DynamicObject; if (PrintTemp != null) { string PId = Convert.ToString(PrintTemp["Id"]); if (!PId.IsNullOrEmptyOrWhiteSpace()) { PJSQL = $" and T1.Fid={PId} "; } } if (!MacInfo.IsNullOrEmptyOrWhiteSpace()) { PrintModelDS = getPrintModel(this.View, Context, PJSQL, orgid.ToString(), MacInfo, F_SZXY_ForLabel, ref ckb); if (PrintModelDS != null) { XYStraddleCut.Print(PrintModelDS, ckb, Context, this.View, $"'{F_SZXY_ForLabel}'", "XH"); } else { View.ShowWarnningMessage("没有匹配到模板!"); return; } Logger.Debug($" 箱号匹配到:{SelSqlds.Tables[0].Rows.Count}条数据。", ""); } } } }
public override void DataChanged(DataChangedEventArgs e) { base.DataChanged(e); int m = e.Row; string WhereSql = ""; DynamicObject billobj = this.Model.DataObject; string InNO = Convert.ToString(this.Model.GetValue("F_SZXY_BoxNo", m)); //获取输入的编号 string MONO = Convert.ToString(this.Model.GetValue("F_SZXY_MONO", m)); //获取输入的任务单行号 string XQty = Convert.ToString(this.Model.GetValue("F_SZXY_BoxQty")); //获取输入的箱数 string flag = ""; //客户订单号获取客户PO号、日期获取包装日期、业务员、客户 //扫包装箱号 if (e.Field.Key.EqualsIgnoreCase("F_SZXY_BoxNo")) { flag = "XH"; if (!MONO.IsNullOrEmptyOrWhiteSpace()) { return; } if (!XQty.IsNullOrEmptyOrWhiteSpace() && Convert.ToInt32(XQty) > 0 && !InNO.IsNullOrEmptyOrWhiteSpace() && billobj["F_SZXY_OrgId"] is DynamicObject orgobj) { string orgname = string.Empty; if (InNO.Length <= 2) { this.View.ShowWarnningMessage("请检查输入的编号是否有误!"); return; } //string no1 = InNO.Remove(1, 1); //int Currindex = no1.IndexOf('S'); //if (!InNO.IsNullOrEmptyOrWhiteSpace()) //{ // if (Currindex == 0) // { WhereSql = $" T1.F_SZXY_CTNNO='{InNO}' "; // } //} SetBillValue(Context, orgobj, WhereSql, this.View, e.Row); this.Model.BatchCreateNewEntryRow("F_SZXY_KHHQDEntity", 1); this.View.GetControl <EntryGrid>("F_SZXY_KHHQDEntity").SetEnterMoveNextColumnCell(true); this.View.SetEntityFocusRow("F_SZXY_KHHQDEntity", e.Row + 1); this.View.UpdateView("F_SZXY_KHHQDEntity"); } else { this.View.ShowWarnningMessage("请检查输入的箱数!"); return; } } //扫生产订单号 if (e.Field.Key.EqualsIgnoreCase("F_SZXY_MoNO")) { flag = "DDH"; if (!MONO.IsNullOrEmptyOrWhiteSpace() && billobj["F_SZXY_OrgId"] is DynamicObject orgobj) { WhereSql = $" T1.F_SZXY_PUDNO+CAST(T1.F_SZXY_PUDLINENO as nvarchar(50))='{MONO}' "; if (!XQty.IsNullOrEmptyOrWhiteSpace() && Convert.ToInt32(XQty) > 0) { SetBillValue(Context, orgobj, WhereSql, this.View, e.Row); //调用打印 #region //if (this.Model.GetValue("F_SZXY_OrgId") is DynamicObject OrgDO) //{ // //是否指定标签模板 // string PJSQL = ""; // long orgid = Convert.ToInt64(OrgDO["Id"]); // int ckb = 0; // string CustId = ""; // string Material = ""; // string MacInfo = Utils.GetMacAddress(); // Logger.Debug("当前MAC地址", MacInfo); // if (this.Model.DataObject["SZXY_KHHQDEntry"] is DynamicObjectCollection Entry) // { // foreach (var Row in Entry.Where(we => !Convert.ToString(we["F_SZXY_CBNO1"]).IsNullOrEmptyOrWhiteSpace())) // { // if (Row["F_SZXY_Material"] is DynamicObject MATERIALObj) // { // Material = MATERIALObj["Name"].ToString(); // } // if (Row["F_SZXY_CUST"] is DynamicObject CustIdObj) // { // CustId = CustIdObj["Id"].ToString(); // } // DataSet PrintModelDS = XYStraddleCut.getPrintModel(this.View, Context, PJSQL, orgid.ToString(), MacInfo, CustId, Material, KBNO, "BarNo", ref ckb); // if (PrintModelDS != null) // { // XYStraddleCut.Print(PrintModelDS, ckb, Context, this.View, $"'{KBNO}'", "BarNo"); // } // } // } #endregion } else { this.View.ShowWarnningMessage("请检查输入的箱数!"); return; } } } if (e.Field.Key.EqualsIgnoreCase("F_SZXY_CBNO")) { if (true) //if (flag == "XH") { string KBNO = Convert.ToString(this.Model.GetValue("F_SZXY_CBNO")); if (this.Model.GetValue("F_SZXY_OrgId") is DynamicObject OrgDO) { long orgid = Convert.ToInt64(OrgDO["Id"]); if (KBNO.IsNullOrEmptyOrWhiteSpace()) { return; } #region int ckb = 0; string CustId = ""; string Material = ""; string MacInfo = Utils.GetMacAddress(); Logger.Debug("当前MAC地址", MacInfo); if (this.Model.DataObject["SZXY_KHHQDEntry"] is DynamicObjectCollection Entry) { foreach (var Row in Entry.Where(we => Convert.ToString(we["F_SZXY_CBNO1"]) == KBNO)) { if (Row["F_SZXY_Material"] is DynamicObject MATERIALObj) { Material = MATERIALObj["Name"].ToString(); } if (Row["F_SZXY_CUST"] is DynamicObject CustIdObj) { CustId = CustIdObj["Id"].ToString(); } break; } } //是否指定标签模板 string PJSQL = " "; DataSet PrintModelDS = XYStraddleCut.getPrintModel(this.View, Context, PJSQL, orgid.ToString(), MacInfo, CustId, Material, KBNO, "BarNo", ref ckb); if (PrintModelDS != null) { XYStraddleCut.Print(PrintModelDS, ckb, Context, this.View, $"'{KBNO}'", "BarNo"); } #endregion } } } }
public override void AfterBarItemClick(AfterBarItemClickEventArgs e) { base.AfterBarItemClick(e); if (e.BarItemKey.EqualsIgnoreCase("SZXY_tbGridPrintNo")) { this.Model.DataObject["FFormId"] = this.View.BusinessInfo.GetForm().Id; Utils.Save(View, new DynamicObject[] { this.Model.DataObject }, Kingdee.BOS.Orm.OperateOption.Create(), Context); #region if (this.Model.GetValue("F_SZXY_OrgId") is DynamicObject OrgObj) { long orgid = Convert.ToInt64(OrgObj["Id"]); //是否指定标签模板 string PJSQL = " "; //DynamicObject PrintTemp = this.Model.GetValue("F_SZXY_LabelPrint") as DynamicObject; //if (PrintTemp != null) //{ // string PId = Convert.ToString(PrintTemp["Id"]); // if (!PId.IsNullOrEmptyOrWhiteSpace()) // { // PJSQL = $" and T1.Fid={PId} "; // } //} string MacInfo = Utils.GetMacAddress(); Logger.Debug("当前MAC地址", MacInfo); string F_SZXY_CustId = ""; string material = ""; string CustName = ""; DynamicObjectCollection entry1 = this.Model.DataObject["SZXY_CPCHBGDEntry"] as DynamicObjectCollection; if (entry1 != null) { StringBuilder STR = new StringBuilder(); DataSet PrintModelDS = null; int ckb = 0; foreach (var item in entry1.Where(m => !Convert.ToString(m["F_SZXY_Barcode"]).IsNullOrEmptyOrWhiteSpace())) { string BarNo = Convert.ToString(item["F_SZXY_Barcode"]); if (item["F_SZXY_CustId"] is DynamicObject cust) { F_SZXY_CustId = Convert.ToString(cust["Id"]); CustName = Convert.ToString(cust["Name"]); } if (item["F_SZXY_Material"] is DynamicObject Mat) { material = Convert.ToString(Mat["Name"]); } if (!MacInfo.IsNullOrEmptyOrWhiteSpace()) { Logger.Debug("调用匹配模板前客户为", CustName); PrintModelDS = XYStraddleCut.getPrintModel(this.View, Context, PJSQL, orgid.ToString(), MacInfo, F_SZXY_CustId, material, BarNo, "BarNo", ref ckb); if (PrintModelDS != null) { XYStraddleCut.Print(PrintModelDS, ckb, Context, this.View, $"'{BarNo}'", "BarNo"); } } } } #endregion } } }