/// <summary> /// 获取资材编号,添加到ComboBox /// </summary> private void getAssyList() { try { string sql = "select MATERIAL_CODE from " + SecuGlobal.tbMaster + " where barcode_flag = 'Y' and " + "FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' order by MATERIAL_CODE "; OracleDataReader odr = OracleHelper.ExecuteReader(sql); if (odr.HasRows) { cbAssyAdd.Properties.Items.Clear(); while (odr.Read()) { cbAssyAdd.Properties.Items.Add(odr["MATERIAL_CODE"]); } } else { SecuGlobal.showNG(panelStatus, lblStatus, "没有Master信息,请联系仓库担当"); } } catch (Exception getAssyList) { SecuGlobal.showNG(panelStatus, lblStatus, getAssyList.Message); } }
/// <summary> /// 申请单删除 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnDelete_Click(object sender, EventArgs e) { try { SecuGlobal.showOK(panelStatus, lblStatus, "正在删除申请单数据,请稍等..."); if (gridView2.RowCount <= 0) { SecuGlobal.showNG(panelStatus, lblStatus, "没有申请单信息"); return; } DialogResult dr = MessageBox.Show("确认删除吗?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { if (bReqDocDelete()) { SecuGlobal.showOK(panelStatus, lblStatus, "OK"); } } } catch (Exception btnDelete_Click) { SecuGlobal.showNG(panelStatus, lblStatus, btnDelete_Click.Message); } }
private bool bAnalysisData() { int a = 0; if (gridView1.RowCount <= 0) { SecuGlobal.showNG(panelStatus, lblStatus, "没有要保存的数据!"); return(false); } for (int i = 0; i < gridView1.RowCount; i++) { object valAssy = gridView1.GetRowCellValue(i, gridView1.Columns["材料"]); object valReq = gridView1.GetRowCellValue(i, gridView1.Columns["申请数量"]); if (valReq.ToString().Equals("0")) { SecuGlobal.showNG(panelStatus, lblStatus, valAssy + ": 发料数不能为零"); return(false); } if (!int.TryParse(valReq.ToString(), out a)) { SecuGlobal.showNG(panelStatus, lblStatus, valAssy + ": 发料数量不是有效数字"); return(false); } } return(true); }
/// <summary> /// INSERT OK 之后,显示对应的数据 /// </summary> /// <param name="buf"></param> private void ShowData(string buf) { try { StringBuilder sql = new StringBuilder("select fct_code, material_code," + " (select b.description from " + SecuGlobal.tb_fpp_itemmaster + " b where a.material_code = b.matnr) description," + " barcode_flag, board_count, update_date, update_time, update_user" + " from " + SecuGlobal.tbMaster + " a where 1=1 "); if (!string.IsNullOrEmpty(buf)) { sql.Append(" and material_code = '" + buf + "'"); } sql.Append(" and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' order by update_date desc,update_time desc"); SecuGlobal.GridViewInitial(grdView1, gridControl1); DataTable dt = OracleHelper.ExecuteDataTable(sql.ToString()); dt = setDtHeader(dt); gridControl1.DataSource = dt; setGirdView(); } catch (Exception ShowData) { SecuGlobal.showNG(panelStatus, lblStatus, ShowData.Message); } }
/// <summary> /// 验证扫描的SN范围计算的数量和设定的数量是否一致 /// </summary> /// <returns></returns> private bool QtyInputCheck_Roll() { int li_sec_calc_sum = 0; if (inputType.Equals("ROLL")) { if (secuType.Equals("SAMSUNG")) { string sql1 = "select to_number(substr('" + ls_sn_to + "',8,8)) - to_number(substr('" + ls_sn_from + "',8,8)) + 1 from dual"; li_sec_calc_sum = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql1)); } else if (secuType.Equals("XEROX")) { string sql2 = "select to_number(substr('" + ls_sn_to + "',3,7)) - to_number(substr('" + ls_sn_from + "',3,7)) + 1 from dual"; li_sec_calc_sum = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql2)); } if (!li_sec_calc_sum.Equals(li_sec_cnt)) { SecuGlobal.showNG(panelStatus, lblStatus, "计算数量与设定数量不一致,不允许保存!"); return(false); } } else { return(false); } return(true); }
/// <summary> /// 成卷/ONE 选择 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void rdType_SelectedIndexChanged(object sender, EventArgs e) { secuType = ""; tbQty.Text = ""; if (rdType.SelectedIndex == 0) { secuType = "SAMSUNG"; if (rdInput.SelectedIndex == 1) { tbQty.Text = "2500"; } else { tbQty.Text = "1"; } } else if (rdType.SelectedIndex == 1) { secuType = "XEROX"; if (rdInput.SelectedIndex == 1) { tbQty.Text = "10000"; } else { tbQty.Text = "1"; } } else { SecuGlobal.showNG(panelStatus, lblStatus, "获取类型异常错误"); } SecuGlobal.showOK(panelStatus, lblStatus, "Ready ! 当前类型:" + secuType + "投入类型:" + inputType); }
private void MeterialGi_Load(object sender, EventArgs e) { SecuGlobal.setDate(dateEditFrom, dateEditTo); if (PaCSGlobal.LoginUserInfo.Fct_code.Equals("C660A")) { cbPlant.Text = "SSDP"; } else { cbPlant.Text = "SESC"; } plantInsert = cbPlant.Text; string bufVend = SecuGlobal.getPopVendorInfo(PaCSGlobal.LoginUserInfo.Venderid, PaCSGlobal.LoginUserInfo.Fct_code); if (!bufVend.Equals("")) { cbVendor.Text = bufVend; } else { cbVendor.Text = PaCSGlobal.LoginUserInfo.Venderid + ":" + PaCSGlobal.LoginUserInfo.Vendername; //苏州法人 } if (!bGetInfo(bufVend.Substring(0, 4))) { SecuGlobal.showNG(panelStatus, lblStatus, "材料信息/line 信息获取失败"); return; } SecuGlobal.showOK(panelStatus, lblStatus, "Ready"); }
/// <summary> /// 出库取消操作判定 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private bool bCheckCancleQty(string ls_company, string ls_doc_no, string li_doc_seq) { try { int ll_doc_qty = 0, ll_have_bk_doc_qty = 0; string sql = "select nvl(doc_qty,0) from " + SecuGlobal.tbSecurityDoc + " where " + "company = '" + ls_company + "' and doc_no = '" + ls_doc_no + "' and doc_seq = '" + li_doc_seq + "' " + "and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; ll_doc_qty = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql).ToString()); string sql1 = "select nvl(sum(doc_qty),0) ll_have_bk_doc_qty from " + SecuGlobal.tbSecurityDoc + " where " + "bk_company = '" + ls_company + "' and bk_doc_no = '" + ls_doc_no + "' and bk_doc_seq = '" + li_doc_seq + "' " + "and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; ll_have_bk_doc_qty = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql1).ToString()); if (ll_have_bk_doc_qty == ll_doc_qty) { SecuGlobal.showNG(panelStatus, lblStatus, "本条记录已全部返退,不能再进行返退!"); return(false);; } tbDocQty.Text = (ll_doc_qty - ll_have_bk_doc_qty).ToString(); //可以返退的数量 return(true); } catch (Exception) { return(false); } }
/// <summary> /// 后台查询数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { try { this.Invoke((MethodInvoker) delegate { btnQuery.Enabled = false; SecuGlobal.GridViewInitial(gridView1, gridControl1); SecuGlobal.GridViewInitial(gridView2, gridControl2); DataTable dt = null; dt = OracleHelper.ExecuteDataTable(getSql(plantCode, vendorCode4, dFrom, dTo, status)); //vendorCode4 BP3A if (dt == null) { return; } dt = setDtHeader(dt); //更改标题栏和显示顺序 gridControl1.DataSource = dt; gridView1.BestFitColumns(); gridView1.Columns["申请单号"].SummaryItem.SummaryType = SummaryItemType.Count; gridView1.Columns["申请单号"].SummaryItem.DisplayFormat = "All:{0:f0} "; btnQuery.Enabled = true; }); } catch (Exception err) { SecuGlobal.showNG(panelStatus, lblStatus, err.Message); } }
/// <summary> /// 获取Meterial Code /// LOAD 事件中加载 /// </summary> private void getMeterialCode() { try { string sql = " select material_code from " + SecuGlobal.tbMaster + " where " + " FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' order by material_code "; OracleDataReader odr = OracleHelper.ExecuteReader(sql); if (odr.HasRows) { while (odr.Read()) { cbMeterial.Properties.Items.Add(odr["material_code"]); } } else { SecuGlobal.showNG(panelStatus, lblStatus, "没有找到MASTER 信息"); } } catch (Exception getVendorCode) { SecuGlobal.showNG(panelStatus, lblStatus, getVendorCode.Message); } }
/// <summary> /// 查询库存信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cbMeterial_SelectedIndexChanged(object sender, EventArgs e) { try { if (cbMeterial.SelectedIndex != -1) { meterialCode = cbMeterial.Properties.Items[cbMeterial.SelectedIndex].ToString(); } else { SecuGlobal.showNG(panelStatus, lblStatus, "请选择材料信息"); return; } DataTable dt = OracleHelper.ExecuteDataTable(getSql(ls_company, ls_plant, meterialCode)); //ls_company ('BP3A') ls_plant('SSDP') if (dt != null) { foreach (DataRow dr in dt.Rows) { barcode = dr["barcode_flag"].ToString(); assyDesc = dr["description"].ToString(); txtRemain.Text = dr["stock_qty"].ToString(); remain = txtRemain.Text.Trim(); } } SecuGlobal.showOK(panelStatus, lblStatus, "材料选择改变,请确认信息" + meterialCode); } catch (Exception error) { SecuGlobal.showNG(panelStatus, lblStatus, error.Message); } }
private void btnDoorPrint_Click(object sender, EventArgs e) { if (string.IsNullOrEmpty(doc_no)) { SecuGlobal.showNG(panelStatus, lblStatus, "请首先选择申请单信息"); return; } printReqDoc(doc_no); }
/// <summary> /// 申请单入库 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnGr_Click(object sender, EventArgs e) { try { SecuGlobal.showOK(panelStatus, lblStatus, "正在进行入库,请稍等..."); bRun = true; btnGr.Enabled = false; if (gridView2.RowCount == 0 || grCount.Equals(0)) { SecuGlobal.showNG(panelStatus, lblStatus, "请选择申请单信息"); return; } DialogResult dlg = MessageBox.Show("您确认要进行入库:" + doc_no + "?", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dlg == DialogResult.OK) { int iCount = 0; for (int i = 0; i < gridView2.RowCount; i++) { for (int j = 0; j < gridView2.Columns.Count; j++) { if ((bool)gridView2.GetRowCellValue(i, gridView2.Columns[0])) { iCount += 1; break; } } } if (iCount == 0) { SecuGlobal.showNG(panelStatus, lblStatus, "请选中要入库的信息"); return; } if (!bgrDataUpload()) //失败 { return; } doc_no = ""; btnQuery_Click(sender, e); } SecuGlobal.showOK(panelStatus, lblStatus, "OK"); } catch (Exception btnGr_Click) { SecuGlobal.showNG(panelStatus, lblStatus, btnGr_Click.Message); } finally { bRun = false; btnGr.Enabled = true; } }
private void btnExport_Click(object sender, EventArgs e) { //showData("C660", "75619"); //显示数据 if (gridView1.RowCount <= 0) { SecuGlobal.showNG(panelStatus, lblStatus, "没有数据"); return; } PaCSGlobal.ExportGridToFile(gridView1, "Input Sn"); }
/// <summary> /// 分析基本条件 /// </summary> /// <param name="scandata"></param> /// <returns></returns> private bool bAnalysisData_Comm(string scandata) { if (cbLine.SelectedIndex == -1 || cbMaterialCode.SelectedIndex == -1) { SecuGlobal.showNG(panelStatus, lblStatus, "请选择基本信息- line / 材料"); return(false); } ls_item = cbMaterialCode.Text.Trim(); // 投入材料 li_sec_cnt = System.Convert.ToInt32(tbQty.Text.Trim()); // 投入数量 if (li_sec_cnt == 0) { SecuGlobal.showNG(panelStatus, lblStatus, "投入数量不能为零"); return(false); } ls_line = cbLine.Text.Trim().Substring(0, 4); if (string.IsNullOrEmpty(ls_line) || (string.IsNullOrEmpty(ls_item)) || ls_item.Equals("ALL")) { SecuGlobal.showNG(panelStatus, lblStatus, "请选择LINE 信息 或者 材料CODE 信息"); return(false); } string sql = "select count(*) from " + SecuGlobal.tbSnSecuHist + " where serial_no = '" + scandata + "' and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; int li_cnt = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql)); if (li_cnt > 0) { SecuGlobal.showNG(panelStatus, lblStatus, "序列号重复扫描!"); return(false); } string sql1 = "select count(*) from " + SecuGlobal.tbSecurityInSnTest + " where serial_no = '" + scandata + "' and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; int li_cnt1 = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql1)); if (li_cnt1 <= 0) { SecuGlobal.showNG(panelStatus, lblStatus, "没有发料的序列号!"); return(false); } if (secuType.Equals("SAMSUNG") && !scandata.Length.Equals(15)) { SecuGlobal.showNG(panelStatus, lblStatus, "错误的序列号:" + scandata); return(false); } if (secuType.Equals("XEROX") && !scandata.Length.Equals(9)) { SecuGlobal.showNG(panelStatus, lblStatus, "错误的序列号:" + scandata); return(false); } return(true); }
private void btnExport_Click(object sender, EventArgs e) { if (grdView1.RowCount <= 0) { SecuGlobal.showNG(panelStatus, lblStatus, "没有数据,请先查询!"); } SecuGlobal.showOK(panelStatus, lblStatus, "数据导出中,请稍等..."); PaCSGlobal.ExportGridToFile(grdView1, "Security Invoice Info"); SecuGlobal.showOK(panelStatus, lblStatus, "OK"); }
/// <summary> /// 数据查询 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnApply_Click(object sender, EventArgs e) { try { SecuGlobal.showOK(panelStatus, lblStatus, "正在查询数据,请稍等..."); backgroundWorker1.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); } catch (Exception ex) { SecuGlobal.showNG(panelStatus, lblStatus, ex.Message); } }
/// <summary> /// 加载Vendor信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void StockQuery_Load(object sender, EventArgs e) { setDicVendor(PaCSGlobal.LoginUserInfo.Fct_code); if (dicVendor.Count <= 0) { SecuGlobal.showNG(panelStatus, lblStatus, "没有找到VENDOR 信息,请联系管理员"); return; } SecuGlobal.setAllVendorInfo(PaCSGlobal.LoginUserInfo.Fct_code, cbVendor); SecuGlobal.showOK(panelStatus, lblStatus, "Ready"); }
/// <summary> /// 后台查询数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { try { getVariable(); DataTable dt = OracleHelper.ExecuteDataTable(getSql(company, ls_material_code, ls_plant)); if (dt != null) { dt.Columns["plant"].ColumnName = "厂家"; dt.Columns["material_code"].ColumnName = "材料"; dt.Columns["description"].ColumnName = "材料描述"; dt.Columns["stock_qty"].ColumnName = "厂家库存"; dt.Columns["trans_qty"].ColumnName = "厂家转移库存"; } string vendorDesc = ""; foreach (DataRow dr in dt.Rows) { dicVendor.TryGetValue(dr["COMPANY"].ToString(), out vendorDesc); dr["COMPANY"] = vendorDesc; } this.Invoke((MethodInvoker) delegate { gridControl1.DataSource = dt; grdView1.BestFitColumns(); grdView1.Columns["材料"].SummaryItem.SummaryType = SummaryItemType.Count; grdView1.Columns["材料"].SummaryItem.DisplayFormat = "All:{0:f0}"; grdView1.Columns["厂家库存"].SummaryItem.SummaryType = SummaryItemType.Sum; grdView1.Columns["厂家库存"].SummaryItem.DisplayFormat = "{0:f0}"; grdView1.Columns["厂家转移库存"].SummaryItem.SummaryType = SummaryItemType.Sum; grdView1.Columns["厂家转移库存"].SummaryItem.DisplayFormat = "{0:f0}"; //指定列对齐方式 grdView1.Columns["材料描述"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near; grdView1.Columns["厂家库存"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; grdView1.Columns["厂家转移库存"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far; SecuGlobal.showOK(panelStatus, lblStatus, "OK"); }); } catch (Exception err) { //XtraMessageBox.Show(this, "System error[ShowData]: " + err.Message); SecuGlobal.showNG(panelStatus, lblStatus, err.Message); } }
/// <summary> /// 获取截取字符串的必要条件 /// </summary> /// <param name="type"></param> private void getScanSplitValue(string type) { try { string sql = "select code 描述,etc1 开始长度,etc2 截取长度 from " + SecuGlobal.tb_code + " where FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' and lang_key = 'EN' and prefix = '" + type + "' order by seq_no"; DataTable dt = OracleHelper.ExecuteDataTable(sql); grdControl2.DataSource = dt; grdScanSetting.Columns["描述"].Width = 120; } catch (Exception getScanSplitValue) { SecuGlobal.showNG(panelStatus, lblStatus, getScanSplitValue.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { backgroundWorker2.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); btnSave.Enabled = false; } catch (Exception btnSave_Click) { SecuGlobal.showNG(panelStatus, lblStatus, btnSave_Click.Message); //是否要做Rollback? } }
private void btnOpenFile_Click(object sender, EventArgs e) { try { if (ckClipBorad.Checked) //从剪切板获取数据 - 某些EXCEL 格式异常,采用此方式进行 { if (!bGetDataClipboradAndAnalysis()) { return; } else { btnSave.Enabled = true; // 遍历上传的数据,如果都可用,则Save Enabled = TRUE SecuGlobal.showOK(panelStatus, lblStatus, "数据读取和分析OK ,请按保存按钮上传数据..."); return; } } SecuGlobal.showOK(panelStatus, lblStatus, "文件打开中,请稍等..."); SecuGlobal.GridViewInitial(grdView1, gridControl1); OpenFileDialog fd = new OpenFileDialog(); fd.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx"; //过滤文件类型 fd.InitialDirectory = Application.StartupPath + "\\Temp\\"; fd.ShowReadOnly = true; DialogResult r = fd.ShowDialog(); if (r == DialogResult.OK) { excelFileName = fd.FileName; excelFirstTable = GetExcelFirstTableName(excelFileName); DataTable dt = dtImportExcel(excelFileName, excelFirstTable); gridControl1.DataSource = dt; if (!bAnalysisUploadData(dt)) { return; } btnSave.Enabled = true; // 遍历上传的数据,如果都可用,则Save Enabled = TRUE SecuGlobal.showOK(panelStatus, lblStatus, "数据读取和分析OK ,请按保存按钮上传数据..."); } } catch (Exception btnOpenFile_Click) { SecuGlobal.showNG(panelStatus, lblStatus, btnOpenFile_Click.Message); } }
/// <summary> /// 选中对应申请单之后,数据显示到控件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void selection_SelectionChanged(object sender, EventArgs e) { iCount = 0; for (int i = 0; i < gridView1.RowCount; i++) { if ((bool)gridView1.GetRowCellValue(i, gridView1.Columns[0])) { type = gridView1.GetRowCellValue(i, gridView1.Columns["移库类型"]).ToString(); string assy = gridView1.GetRowCellValue(i, gridView1.Columns["材料"]).ToString(); cbMaterial.Text = assy; tbDesc.Text = gridView1.GetRowCellValue(i, gridView1.Columns["材料描述"]).ToString(); barCode = gridView1.GetRowCellValue(i, gridView1.Columns["条形码"]).ToString(); string sql = "select nvl(sum(STOCK_QTY),0) stock_qty from " + SecuGlobal.tbSecurityStock + " where " + "material_code = '" + assy + "' AND company = '" + vend4 + "' AND PLANT = '" + plantInsert + "' and " + "FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; //plantInsert -SSDP OR SESC tbStockQty.Text = OracleHelper.ExecuteScalar(sql).ToString(); SecuGlobal.showOK(panelStatus, lblStatus, "选中材料是:" + assy); if (ckCancle.Checked) // 出库取消模式下,不是NOR 的不允许取消 { string mov = gridView1.GetRowCellValue(i, gridView1.Columns["移库方向"]).ToString(); if (!mov.Equals("NOR") || type.Equals("GR")) { SecuGlobal.showNG(panelStatus, lblStatus, "此记录不能做出库取消,请再次确认"); gridView1.SetRowCellValue(i, gridView1.Columns[0], false); return; } else { btnSave.Enabled = true; bk_docno = gridView1.GetRowCellValue(i, gridView1.Columns["申请单号"]).ToString(); //RTN 记录单号 ls_bk_company = gridView1.GetRowCellValue(i, gridView1.Columns["厂家"]).ToString(); //RTN 厂家信息 if (!bCheckCancleQty(ls_bk_company, bk_docno, "1")) { SecuGlobal.showNG(panelStatus, lblStatus, "数据取消分析NG,请在确认"); btnSave.Enabled = false; return; } SecuGlobal.showOK(panelStatus, lblStatus, "数据可以取消,请继续..."); } } iCount += 1; break; } } }
/// <summary> /// 遍历EXCEL(DataTable) /// 如果数据已经存在那么ERROR 提示 /// </summary> /// <param name="dt"></param> /// <returns>True(数据可用) 否则False</returns> private bool bAnalysisUploadData(DataTable dt) { bool b = false; string ls_sec_boxno = ""; string ls_sec_start = ""; string ls_sec_end = ""; string strSql = ""; int iCounts; foreach (DataRow dr in dt.Rows) { ls_sec_boxno = Convert.ToString(dr[5]); ls_sec_start = Convert.ToString(dr[3]); ls_sec_end = Convert.ToString(dr[4]); strSql = "select count(*) from " + SecuGlobal.tbSecurityInvoice + " where sec_boxno = '" + ls_sec_boxno + "' " + "and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; iCounts = System.Convert.ToInt32(OracleHelper.ExecuteScalar(strSql)); if (iCounts >= 1) { SecuGlobal.showNG(panelStatus, lblStatus, "已经上载的箱号:" + ls_sec_boxno); break; } strSql = "select * from " + SecuGlobal.tbSecurityInvoice + " where '" + ls_sec_start + "' between sec_start and sec_end " + "and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; iCounts = System.Convert.ToInt32(OracleHelper.ExecuteScalar(strSql)); if (iCounts >= 1) { SecuGlobal.showNG(panelStatus, lblStatus, "已上载的防伪标签号:" + ls_sec_start); break; } strSql = "select * from " + SecuGlobal.tbSecurityInvoice + " where '" + ls_sec_end + "' between sec_start and sec_end " + "and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; iCounts = System.Convert.ToInt32(OracleHelper.ExecuteScalar(strSql)); if (iCounts >= 1) { SecuGlobal.showNG(panelStatus, lblStatus, "已上载的防伪标签号:" + ls_sec_end); break; } b = true; } return(b); }
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e) { this.Invoke((MethodInvoker) delegate { SecuGlobal.showOK(panelStatus, lblStatus, "数据上传中,请耐心等待..."); try { //MessageBox.Show(grdView1.RowCount.ToString()); for (int i = 0; i < grdView1.RowCount; i++) { StringBuilder sql = new StringBuilder("insert into " + SecuGlobal.tbSecurityInvoice + "(sec_boxno,sec_itemcd,sec_rollfrom,sec_rollto,sec_start,sec_end,sec_cnt,delivery_date,invoice_no,add_date,add_time,add_user,add_ip,FCT_CODE) " + "values (:sec_boxno,:sec_itemcd,:sec_rollfrom,:sec_rollto,:sec_start,:sec_end,:sec_cnt,:delivery_date,:invoice_no," + "to_char(sysdate,'yyyymmdd'),to_char(sysdate,'hh24miss'),:add_user,:add_ip,:FCT_CODE)"); OracleParameter[] parameters = new OracleParameter[] { new OracleParameter(":sec_boxno", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[5]))), new OracleParameter(":sec_itemcd", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[0]))), new OracleParameter(":sec_rollfrom", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[1]))), new OracleParameter(":sec_rollto", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[2]))), new OracleParameter(":sec_start", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[3]))), new OracleParameter(":sec_end", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[4]))), new OracleParameter(":sec_cnt", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[6]))), new OracleParameter(":delivery_date", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[7]))), new OracleParameter(":invoice_no", Convert.ToString(grdView1.GetRowCellValue(i, grdView1.Columns[8]))), //new OracleParameter(":add_date", to_char(sysdate,'yyyymmdd')), //new OracleParameter(":add_time", "to_char(sysdate,'hh24miss')"), new OracleParameter(":add_user", PaCSTools.PaCSGlobal.LoginUserInfo.Name), new OracleParameter(":add_ip", PaCSTools.PaCSGlobal.GetClientIp()), new OracleParameter(":FCT_CODE", PaCSTools.PaCSGlobal.LoginUserInfo.Fct_code) }; OracleHelper.ExecuteNonQuery(sql.ToString(), parameters); } SecuGlobal.showOK(panelStatus, lblStatus, "数据保存 OK"); } catch (Exception DoWork) { SecuGlobal.showNG(panelStatus, lblStatus, DoWork.Message); // rollback ? } finally { if (ckClipBorad.Checked) //剪贴板模式恢复到EXCEL模式, { //System.Windows.Forms.Clipboard.Clear(); //剪贴板不能清空,否则会导致数据显示异常 ckClipBorad.Checked = false; } } }); }
/// <summary> /// 拆分的ASSY CODE 进行判定,然后判断 /// 申请单号获取 /// </summary> /// <returns></returns> private bool AnalysisCondition(string data) { try { string sql = "select count(*) from " + SecuGlobal.tbSecurityInTest + " where scan_data = '" + data + "' " + "and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'"; int a = System.Convert.ToInt32(OracleHelper.ExecuteScalar(sql)); if (a > 0) { SecuGlobal.showNG(panelStatus, lblStatus, "数据已经上传,请在确认!"); return(false); } if (string.IsNullOrEmpty(cbAssyAdd.Text)) { SecuGlobal.showNG(panelStatus, lblStatus, "请选择材料信息"); return(false); } workDate = PaCSGlobal.GetServerDateTime(2); if (string.IsNullOrEmpty(workDate) || !workDate.Length.Equals(8)) { SecuGlobal.showNG(panelStatus, lblStatus, "当前日期获取失败,请联系管理担当"); return(false); } //doc_no = GetDocNo(workDate); if (string.IsNullOrEmpty(doc_no)) { SecuGlobal.showNG(panelStatus, lblStatus, "申请单号获取失败,请联系管理担当"); return(false); } if (string.IsNullOrEmpty(strUnitType)) { SecuGlobal.showNG(panelStatus, lblStatus, "类型获取失败,BOX/ROLL/ONE?"); return(false); } return(true); } catch (Exception) { return(false); } }
/// <summary> /// 保存数据 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnSave_Click(object sender, EventArgs e) { try { if (!bGetValues()) { return; } if (!bAnalysis()) { return; } DialogResult dr = MessageBox.Show("是否保存修改的内容", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr != DialogResult.OK) { SecuGlobal.showOK(panelStatus, lblStatus, "用户取消作业"); return; } if (!bInsertData()) //数据写入到TB_SECURITY_DOC { return; } int li_check = iUpdateStockQty(); // 更新库存数量tb_security_stock if (li_check == 0) { if (ckCancle.Checked) { ckCancle.Checked = false; } btnApply_Click(sender, e); SecuGlobal.showOK(panelStatus, lblStatus, "OK"); Reset(); //数据初始化 } else { SecuGlobal.showNG(panelStatus, lblStatus, "库存数量更新失败,请联系管理员"); } } catch (Exception er) { SecuGlobal.showNG(panelStatus, lblStatus, er.Message); } }
private void btnQuery_Click(object sender, EventArgs e) { try { SecuGlobal.showOK(panelStatus, lblStatus, "数据查询中,请稍等..."); SecuGlobal.GridViewInitial(grdView1, gridControl1); backgroundWorker1.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); } catch (Exception ex) { SecuGlobal.showNG(panelStatus, lblStatus, ex.Message); } }
private void btnQuery_Click(object sender, EventArgs e) { try { SecuGlobal.showOK(panelStatus, lblStatus, "正在查询数据,请稍等..."); getVariable(); backgroundWorker1.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); SecuGlobal.showOK(panelStatus, lblStatus, "Ready"); } catch (Exception btnQuery_Click) { SecuGlobal.showNG(panelStatus, lblStatus, btnQuery_Click.Message); } }
private void btnQuery_Click(object sender, EventArgs e) { try { getVariable(); if (xtraTabControl1.SelectedTabPage == xtraTabPage1) { DialogResult dr = MessageBox.Show("当前页面 - < 部门库存查询 >,继续请按OK", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { backgroundWorker1.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); } } else if (xtraTabControl1.SelectedTabPage == xtraTabPage2) { DialogResult dr = MessageBox.Show("当前页面 - < 每卷使用明细查询 >,继续请按OK", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { backgroundWorker2.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); } } else if (xtraTabControl1.SelectedTabPage == xtraTabPage3) { DialogResult dr = MessageBox.Show("当前页面 - < 范围段明细查询 >,继续请按OK", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { backgroundWorker3.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); } } else { DialogResult dr = MessageBox.Show("当前页面 - < 报废未返回序列号 >,继续请按OK", "提示", MessageBoxButtons.OKCancel, MessageBoxIcon.Question); if (dr == DialogResult.OK) { backgroundWorker4.RunWorkerAsync(); SplashScreenManager.ShowForm(typeof(WaitLoading)); } } } catch (Exception ex) { SecuGlobal.showNG(panelStatus, lblStatus, ex.Message); } }