/// <summary> /// 新建单据在选择业务单据号后的处理 /// </summary> /// <param name="dtSource">数据源</param> /// <param name=QSConstValue.VALUEMEMBER>实际输入的值</param> /// <param name="errorInfo">错误信息</param> /// <returns>True False</returns> protected bool DoAfterSelVouchType(KgmGrid grid, EditControlInterface con, string inputvalue, out string errorInfo) { errorInfo = string.Empty; ////设置过滤条件 //string rowfilter = string.Format(" AND A.MODULEID = '{0}' AND (CVOUCHID = '{1}' OR CVOUCHNAME = '{1}' OR CSOURCE = '{1}')", QSCommonValue.OP_Module.ModuleId, inputvalue); ////根据过滤条件读取单据信息 ////ADO ////DataTable dtVouchType = bll.GetVouchModel(rowfilter); ////API //VouchModel model = new VouchModel(); //model.Condition = rowfilter; //model.DBNAME = QSCommonValue.BarDbConfigInfo.U8DatabaseName; //string jsonData = WebAPIUtil.ConvertObjToJson(model); //DataTable dtVouchType = WebAPIUtil.PostAPIByJsonToGeneric<DataTable>("api/basic/GetVouchModel", jsonData); //if (dtVouchType == null || dtVouchType.Rows.Count == 0) //{ // errorInfo = "未能获取到业务类型信息,请确认编码是否正确!"; // return false; //} ////循环赋值 //if (!AppUtil.SetValueToGirdSource(grid, dtVouchType.Rows[0], false)) //{ // return false; //} return(true); }
/// <summary> /// 新建单据在选择业务单据号后的处理 /// </summary> /// <param name="dtSource">数据源</param>f /// <param name=QSConstValue.VALUEMEMBER>实际输入的值</param> /// <param name="errorInfo">错误信息</param> /// <returns>True False</returns> protected bool DoAfterSelOrderNo(KgmGrid grid, EditControlInterface con, string inputvalue, out string errorInfo) { errorInfo = string.Empty; string biztype = string.Empty; try { biztype = grid.GetRowCellData("CVOUCHID", QSConstValue.VALUEMEMBER).ToString(); if (string.IsNullOrEmpty(biztype)) { errorInfo = "业务类型不能为空!"; return(false); } } catch { } //设置过滤条件 string rowfilter = string.Format(" AND ORDERNO = '{0}' ", inputvalue); //根据过滤条件读取单据信息 //ADO //DataTable dtorderList = bll.GetSourceList(rowfilter, bU8Sys); //API SYS_SourceList model = new SYS_SourceList(); model.Condition = rowfilter; model.Bu8sys = bU8Sys; string jsonData = WebAPIUtil.ConvertObjToJson(model); DataTable dtorderList = WebAPIUtil.PostAPIByJsonToGeneric <DataTable>("api/basic/GetSourceList", jsonData); if (dtorderList == null || dtorderList.Rows.Count == 0) { errorInfo = "未能获取到单据信息,请确认单据是否正确!"; return(false); } //循环赋值 if (!AppUtil.SetValueToGirdSource(grid, dtorderList.Rows[0], false)) { return(false); } con.EditValue = dtorderList.Rows[0]["ORDERID"].ToString(); con.EditText = dtorderList.Rows[0]["ORDERNO"].ToString(); //列表内的客户设置为不可用 //grid.SetRowCellData("CCUSCODE", new string[] { QSConstValue.BEDIT }, new object[] { false }); return(true); }
/// <summary> /// 新建单据在选择业务单据号后的处理 /// </summary> /// <param name="dtSource">数据源</param> /// <param name=QSConstValue.VALUEMEMBER>实际输入的值</param> /// <param name="errorInfo">错误信息</param> /// <returns>True False</returns> protected bool DoAfterSelOrderNo(KgmGrid grid, EditControlInterface con, string inputvalue, out string errorInfo) { errorInfo = string.Empty; var biztype = string.Empty; try { biztype = grid.GetRowCellData("CVOUCHID", QSConstValue.VALUEMEMBER).ToString(); if (string.IsNullOrEmpty(biztype)) { errorInfo = "业务类型不能为空!"; return(false); } } catch (Exception ex) { AppUtil.ShowError(ex.ToString()); } //设置过滤条件 string rowfilter = string.Format(" AND ORDERNO = '{0}' ", inputvalue); //根据过滤条件读取单据信息 //DataTable dtorderList = tbll.GetTVInfo(rowfilter); string jsonData = WebAPIUtil.ConvertObjToJson(rowfilter); DataTable dtorderList = WebAPIUtil.PostAPIByJsonToGeneric <DataTable>("api/tray/GetTVInfo", jsonData); if (dtorderList == null || dtorderList.Rows.Count == 0) { errorInfo = "未能获取到单据信息,请确认单据是否正确!"; return(false); } //循环赋值 if (!AppUtil.SetValueToGirdSource(grid, dtorderList.Rows[0], false)) { return(false); } return(true); }
/// <summary> /// 判断当前grid中的控件是否可以编辑 /// </summary> /// <param name="con"></param> /// <returns></returns> public static bool KgmGridCanEdit(Resco.Controls.SmartGrid.CustomEditEventArgs e) { EditControlInterface con = e.Control as EditControlInterface; if (string.IsNullOrEmpty(con.EditText) && string.IsNullOrEmpty(con.EditValue == null ? "" : con.EditValue.ToString())) { return(false); } if (!string.IsNullOrEmpty(con.EditValue.ToString()) && con.EditValue.ToString().ToLower() == e.Cell.Row[QSConstValue.VALUEMEMBER].ToString().ToLower() && con.EditText.ToString().ToLower() == e.Cell.Row[QSConstValue.DISPLAYMEMBER].ToString().ToLower()) { return(false); } if (string.IsNullOrEmpty(con.EditText.ToString().ToLower())) { con.EditValue = con.EditText = string.Empty; return(false); } return(true); }
/// <summary> /// 扫描条码后处理 /// </summary> /// <param name="dtSource">数据源</param> /// <param name=QSConstValue.VALUEMEMBER>实际输入的值</param> /// <param name="errorInfo">错误信息</param> /// <returns>True False</returns> protected bool DoAfterScanBarcode(KgmGrid grid, Resco.Controls.SmartGrid.CustomEditEventArgs e, EditControlInterface con, string inputValue, out string errorInfo) { errorInfo = string.Empty; ////ADO ////dttray = bll.GetSingleTableInfo("TRAY_INFO", "ID", "TRAYNO", "", string.Format(" AND TRAYNO = '{0}'", inputValue), string.Empty, true, ""); ////API //Kgm_FilterModel model = new Kgm_FilterModel(); //model.tableName = "TRAY_INFO"; //model.valueMember = "ID"; //model.displayMember = "TRAYNO"; //model.filedName = string.Empty; //model.where = string.Format(" AND TRAYNO = '{0}'", inputValue); //model.dbName = string.Empty; //model.bDistinct = true; //model.sortFiled = string.Empty; //string jsonData = WebAPIUtil.ConvertObjToJson(model); //DataTable dttray = WebAPIUtil.PostAPIByJsonToGeneric<DataTable>("api/basic/GetSingleTableInfo", jsonData); //if (dttray == null || dttray.Rows.Count == 0) //{ // errorInfo = "未能获取到对应的信息,请确认条码是否正确!"; // return false; //} //if (!AppUtil.SetValueToGirdSource(grid, dttray.Rows[0], false)) //{ // errorInfo = "未能获取到对应的信息,请确认条码是否正确!"; // return false; //} //else { // DataTable dtbarcode = bll.BarcodeAnalyze(QSCommonValue.TempScanHead["OPERORDER"].ToString(), inputValue, QSCommonValue.BarDbConfigInfo.BarcodeDatabaseName); // if (dtbarcode == null || dtbarcode.Rows.Count == 0) // { // errorInfo = "未能获取到对应的解析信息,请确认条码是否正确!"; // return false; // } // if (dtbarcode.Columns.Count == 1) // { // errorInfo = dtbarcode.Rows[0][0].ToString(); // return false; // } // if (!AppUtil.SetValueToGirdSource(grid, dtbarcode.Rows[0], false)) // { // return false; // } //} //con.EditValue = con.EditText = inputValue; return(true); }
/// <summary> /// 选取基础档案后的处理 /// </summary> /// <param name="grid"></param> /// <param name="currentrow"></param> /// <param name="con"></param> /// <param name="inputValue"></param> /// <param name="errorInfo"></param> /// <returns></returns> protected bool DoAfterSelBasicDoc(KgmGrid grid, Resco.Controls.SmartGrid.CustomEditEventArgs e, EditControlInterface con, string inputValue, out string errorInfo) { errorInfo = string.Empty; ////判断是否是buttonclick将信息带出来 如果是则直接取editvalue //string value = con.EditValue.ToString().ToUpper() == e.Cell.Row[QSConstValue.VALUEMEMBER].ToString().ToUpper() ? value = con.EditText : con.EditValue.ToString(); //string shineValue = e.Cell.Row[QSConstValue.ROWSHINEVALUE].ToString(); //if (e.Cell.Row[QSConstValue.ROWMAPPINGVALUE].ToString().ToUpper() == "CPOSCODE" || e.Cell.Row[QSConstValue.ROWMAPPINGVALUE].ToString().ToUpper() == "CIPOSCODE") //{ // if (value.Length != 6) // { // value = QSCommonValue.TempScanHead["CWHCODE"].ToString() + value; // } //} ////根据填写的信息,读取档案信息带出值 //Kgm_FilterModel filter = AppUtil.InitFilterModel(e, string.Format(" AND {0} = '{1}' ", shineValue, value)); //if (filter.tableName.ToLower() == "list_main") //{ // string ordertype = QSCommonValue.OP_Module.ModuleMenu == "扫描入库" ? "入库通知" : "出库通知"; // filter.where += string.Format(" AND ORDERTYPE = '{0}'", ordertype); //} ////ADO ////DataTable dtBasic = bll.GetSingleTableInfo(filter); ////API //string jsonData = WebAPIUtil.ConvertObjToJson(filter); //DataTable dtBasic = WebAPIUtil.PostAPIByJsonToGeneric<DataTable>("api/basic/GetSingleTableInfo", jsonData); //if (dtBasic == null || dtBasic.Rows.Count == 0) //{ // errorInfo = "未能获取信息,请输入正确的编码!"; // e.Cell.Row[QSConstValue.VALUEMEMBER] = e.Cell.Row[QSConstValue.DISPLAYMEMBER] = string.Empty; // return false; //} //con.EditValue = dtBasic.Rows[0][QSConstValue.VALUEMEMBER].ToString(); //con.EditText = dtBasic.Rows[0][QSConstValue.DISPLAYMEMBER].ToString(); return(true); }
/// <summary> /// 称重后处理 /// </summary> /// <param name="dtSource">数据源</param> /// <param name=QSConstValue.VALUEMEMBER>实际输入的值</param> /// <param name="errorInfo">错误信息</param> /// <returns>True False</returns> protected bool DoAfterWeight(KgmGrid grid, Resco.Controls.SmartGrid.CustomEditEventArgs e, EditControlInterface con, string inputValue, out string errorInfo) { errorInfo = string.Empty; //重量如果是IP地址,则读取SOCKET string patten = @"((?:(?:25[0-5]|2[0-4]\d|((1\d{2})|([1-9]?\d)))\.){3}(?:25[0-5]|2[0-4]\d|((1\d{2})|([1-9]?\d))))"; System.Text.RegularExpressions.Regex r = new System.Text.RegularExpressions.Regex(patten); if (r.Match(inputValue).Success) { //读取socket OpenWifi(inputValue); } else { con.EditValue = con.EditText = inputValue; } return(true); }
/// <summary> /// 出库校验 /// </summary> /// <param name="grid"></param> /// <param name="currentrow"></param> /// <param name="con"></param> /// <param name="inputValue"></param> /// <param name="errorInfo"></param> /// <returns></returns> protected bool DoAfterSelOutCheck(KgmGrid grid, Resco.Controls.SmartGrid.CustomEditEventArgs e, EditControlInterface con, string inputValue, out string errorInfo) { errorInfo = string.Empty; //判断是否是buttonclick将信息带出来 如果是则直接取editvalue string shineValue = e.Cell.Row[QSConstValue.ROWSHINEVALUE].ToString(); string shineText = e.Cell.Row[QSConstValue.ROWSHINETEXT].ToString(); //改用调用API方式 SYS_SingleTableInfo filter = AppUtil.InitFilterModelAPI(e, string.Format(" AND ({0} = '{1}') ", shineValue, inputValue, shineText)); string jsonData = WebAPIUtil.ConvertObjToJson(filter); DataTable dtBasic = WebAPIUtil.PostAPIByJsonToGeneric <DataTable>("api/basicdocument/GetSingleTableInfo", jsonData); if (dtBasic == null || dtBasic.Rows.Count == 0) { errorInfo = "未能获取信息,请输入正确的编码!"; e.Cell.Row[QSConstValue.VALUEMEMBER] = e.Cell.Row[QSConstValue.DISPLAYMEMBER] = string.Empty; return(false); } con.EditValue = dtBasic.Rows[0][QSConstValue.VALUEMEMBER].ToString(); con.EditText = dtBasic.Rows[0][QSConstValue.DISPLAYMEMBER].ToString(); return(true); }
/// <summary> /// 扫描条码后处理 /// </summary> /// <param name="dtSource">数据源</param> /// <param name=QSConstValue.VALUEMEMBER>实际输入的值</param> /// <param name="errorInfo">错误信息</param> /// <returns>True False</returns> protected bool DoAfterScanBarcode(KgmGrid grid, Resco.Controls.SmartGrid.CustomEditEventArgs e, EditControlInterface con, string inputValue, out string errorInfo) { errorInfo = string.Empty; con.EditValue = con.EditText = inputValue; return(true); }