/// <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>
/// 后台查询数据
/// </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);
}
}
private void ckClipBorad_CheckedChanged(object sender, EventArgs e)
{
btnSave.Enabled = false;
SecuGlobal.GridViewInitial(grdView1, gridControl1);
if (ckClipBorad.Checked)
{
SecuGlobal.showOK(panelStatus, lblStatus, "剪贴板方式：打开EXCEL-复制要上载的数据<标题栏除外>，然后点击批量上载");
}
else
{
SecuGlobal.showOK(panelStatus, lblStatus, "Excel方式");
}
}
private void showData(string vendCode, string sec_sn)
{
SecuGlobal.GridViewInitial(gridView1, grdControl1);
string sql = " select serial_NO ,vendor ,sec_sn ,add_datetime from " + SecuGlobal.tbSnSecuHist + " " +
" where vendor = '" + vendCode + "' and sec_sn = '" + sec_sn + "' and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' order by serial_no ";
DataTable dt = OracleHelper.ExecuteDataTable(sql);
grdControl1.DataSource = dt;
gridView1.Columns["SERIAL_NO"].SummaryItem.SummaryType = SummaryItemType.Count;
gridView1.Columns["SERIAL_NO"].SummaryItem.DisplayFormat = "All： {0:f0} ";
}
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);
}
}
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);
}
}
/// <summary>
/// 后台查询数据并且显示
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
try
{
getVariable();
DataTable dt = null;
this.Invoke((MethodInvoker) delegate
{
switch (queryType)
{
case "SUMMARY":
dt = OracleHelper.ExecuteDataTable(getSqlSummary(ls_req_vendor, ls_sdate, ls_edate, ls_material_code, ls_plant));
if (dt != null)
{
dt = setDtHeader(dt);
}
SecuGlobal.GridViewInitial(grdView1, gridControl1);
gridControl1.DataSource = dt;
grdView1.BestFitColumns();
grdView1.Columns["描述"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Near;
grdView1.Columns["描述"].SummaryItem.SummaryType = SummaryItemType.Count;
grdView1.Columns["描述"].SummaryItem.DisplayFormat = "All: {0:f0}";
break;
case "DETAIL":
dt = OracleHelper.ExecuteDataTable(getSqlDetail(ls_req_vendor, ls_sdate, ls_edate));
SecuGlobal.GridViewInitial(grdView1, gridControl1);
gridControl1.DataSource = dt;
grdView1.BestFitColumns();
grdView1.Columns["REQ_VENDOR"].SummaryItem.SummaryType = SummaryItemType.Count;
grdView1.Columns["REQ_VENDOR"].SummaryItem.DisplayFormat = "All: {0:f0}";
break;
}
SecuGlobal.showOK(panelStatus, lblStatus, "OK");
});
}
catch (Exception err)
{
XtraMessageBox.Show(this, "System error[ShowData]: " + err.Message);
}
}
/// <summary>
/// 根据选择内容，获取截取字符串
/// 设置基本信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void radioGroup2_SelectedIndexChanged_1(object sender, EventArgs e)
{
tbQty.Text = "";
switch (is_security_type)
{
case "SAMSUNG":
if (radioGroup2.SelectedIndex == 0) //整箱
{
strUnitType = "BOX";
tbQty.Text = "20000";
getScanSplitValue("353");
}
else if (radioGroup2.SelectedIndex == 1) //整卷
{
strUnitType = "ROLL";
tbQty.Text = "2500";
getScanSplitValue("354");
}
else //单个
{
strUnitType = "ONE";
tbQty.Text = "1";
SecuGlobal.GridViewInitial(grdScanSetting, grdControl2);
}
break;
case "XEROX":
if (radioGroup2.SelectedIndex == 1) //整卷
{
strUnitType = "ROLL";
tbQty.Text = "10000";
getScanSplitValue("355");
}
else if (radioGroup2.SelectedIndex == 2) //单个
{
strUnitType = "ONE";
tbQty.Text = "1";
}
break;
}
clear();
SecuGlobal.showOK(panelStatus, lblStatus, "投入类型为:" + is_security_type + " < " + strUnitType + " >");
}
/// <summary>
/// 后台加载数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void backgroundWorker2_DoWork(object sender, DoWorkEventArgs e)
{
try
{
this.Invoke((MethodInvoker) delegate
{
doc_no = this.gridView1.GetRowCellValue(this.gridView1.FocusedRowHandle, this.gridView1.Columns["申请单号"]).ToString();
SecuGlobal.GridViewInitial(gridView2, gridControl2); //清除
DataTable dt = OracleHelper.ExecuteDataTable(getSql2(doc_no, plantCode));
dt = setDtHeader1(dt);
girdView2DataLoading(dt); //加载数据到GridView2 中
});
}
catch (Exception err)
{
XtraMessageBox.Show(this, "System error[ShowData]: " + err.Message);
}
}
/// <summary>
/// 后台查询数据
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e)
{
try
{
this.Invoke((MethodInvoker) delegate
{
getVariable(); //获取变量信息
if (vend4.Equals(""))
{
SecuGlobal.showNG(panelStatus, lblStatus, "vendor code 4 为空");
return;
}
SecuGlobal.GridViewInitial(gridView1, gridControl1);
DataTable dt = OracleHelper.ExecuteDataTable(getSql(ls_plant, vend4, ls_sdate, ls_edate)); //ls_plant - %
if (dt == null)
{
SecuGlobal.showOK(panelStatus, lblStatus, "没有查询到符合条件的数据");
return;
}
dt = setDtHeader(dt); //更改标题栏和显示顺序
gridControl1.DataSource = dt;
gridView1.BestFitColumns();
gridView1.Columns["申请单号"].SummaryItem.SummaryType = SummaryItemType.Count;
gridView1.Columns["申请单号"].SummaryItem.DisplayFormat = "All:{0:f0} ";
GridCheckMarksSelection selection = new GridCheckMarksSelection(gridView1); // 增加CHECKBOX
selection.CheckMarkColumn.VisibleIndex = 0;
selection.SelectionChanged += selection_SelectionChanged;
SecuGlobal.showOK(panelStatus, lblStatus, "OK");
});
}
catch (Exception err)
{
SecuGlobal.showNG(panelStatus, lblStatus, err.Message);
}
}
/// <summary>
/// 显示数据到GRID，申请单号为查询条件
/// </summary>
/// <param name="doc_no"></param>
private void showData(string doc_no)
{
try
{
SecuGlobal.showOK(panelStatus, lblStatus, "正在查询数据，请稍等...");
SecuGlobal.GridViewInitial(gridView2, gridControl1);
string sql = " select fct_code, doc_no, doc_seq, item, qty, " +
" box_no, roll_no, lot_no, " +
" security_start, security_end, security_type, " +
" unit, gr_date, gr_time, " +
" gr_user, gr_ip " +
" from " + SecuGlobal.tbSecurityInTest + " " +
" where doc_no = '" + doc_no + "' and FCT_CODE = '" + PaCSGlobal.LoginUserInfo.Fct_code + "'" +
" order by doc_seq desc ";
DataTable dt = OracleHelper.ExecuteDataTable(sql);
if (dt == null)
{
return;
}
dt = setDtHeader(dt);
gridControl1.DataSource = dt;
gridView2.BestFitColumns();
gridView2.Columns["Doc No"].SummaryItem.SummaryType = SummaryItemType.Count;
gridView2.Columns["Doc No"].SummaryItem.DisplayFormat = "All： {0:f0} ";
gridView2.Columns["Qty"].AppearanceCell.TextOptions.HAlignment = DevExpress.Utils.HorzAlignment.Far;
gridView2.Columns["Qty"].Width = 100;
gridView2.Columns["Qty"].SummaryItem.SummaryType = SummaryItemType.Sum;
gridView2.Columns["Qty"].SummaryItem.DisplayFormat = "{0:f0} ";
SecuGlobal.showOK(panelStatus, lblStatus, "OK");
}
catch (Exception showData)
{
SecuGlobal.showNG(panelStatus, lblStatus, showData.Message);
}
}
/// <summary>
/// 添加信息
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tbRemark.Text) || string.IsNullOrEmpty(cbDept.Text) || string.IsNullOrEmpty(cbMeterial.Text) || string.IsNullOrEmpty(tbUser.Text))
{
SecuGlobal.showNG(panelStatus, lblStatus, "请填写基本信息");
return;
}
if (bFirstAdd) // 判断是否是第一次写入数据
{
SecuGlobal.GridViewInitial(gridView1, gridControl1);
}
if (gridView1.RowCount > 0) // 一个申请单号中不允许添加不同类型的CODE
{
string bufAssyCode = cbMeterial.Text;
for (int i = 0; i < gridView1.RowCount; i++)
{
object val = gridView1.GetRowCellValue(i, gridView1.Columns["材料"]);
if (val.ToString().Equals(bufAssyCode))
{
SecuGlobal.showNG(panelStatus, lblStatus, "已经添加的材料信息" + bufAssyCode);
return;
}
}
}
getVariable();
if (reqQty <= 0)
{
SecuGlobal.showNG(panelStatus, lblStatus, "请确认申请数量");
return;
}
add();//添加数据到GridView
SecuGlobal.showOK(panelStatus, lblStatus, "OK");
bFirstAdd = false;
}