/// <summary> /// 初始化查询条件 /// </summary> private void InitQueryCondition() { try { MetalMaskGlobal.LoadCmbStatus(cmbStatus); MetalMaskGlobal.LoadCmbMaskCode(cmbMaskCode); MetalMaskGlobal.LoadCmbModel(cmbModel); MetalMaskGlobal.LoadCmbVendor(cmbVendor); cmbVendType.SelectedIndex = 0; if (!PaCSGlobal.LoginUserInfo.Venderid.Equals("C660")) { cmbVendor.Properties.ReadOnly = true; cmbVendor.Text = PaCSGlobal.LoginUserInfo.Vendername; } else { cmbVendor.SelectedIndex = 0; } dateEditFrom.Text = PaCSGlobal.GetServerDateTime(3); dateEditTo.Text = PaCSGlobal.GetServerDateTime(3); panelControl1.Enabled = false; } catch (Exception InitQueryCombobox) { XtraMessageBox.Show(this, "System error[InitQueryCombobox]: " + InitQueryCombobox.Message); } }
private void btnDel_Click(object sender, EventArgs e) { try { foreach (string currentLoc in venLocList()) { if (currentLoc != PaCSGlobal.LoginUserInfo.Venderid) { XtraMessageBox.Show(MetalMaskGlobal.ReportBtnClickTip, "提示"); return; } } foreach (string currentStatus in statusCodeList()) { if (!MetalMaskGlobal.CheckStatus(currentStatus, "MBDEL")) { XtraMessageBox.Show("状态" + MetalMaskGlobal.GetStatusNmByCode(currentStatus) + "不能" + MetalMaskGlobal.GetStatusNmByCode("MBDEL"), "提示"); return; } } DeleteForm frmNew = new DeleteForm(barcodeList()); DialogResult dg = frmNew.ShowDialog(); if (dg == DialogResult.OK) { btnApply_Click(sender, e); } } catch (Exception btnClean_Click) { XtraMessageBox.Show(this, "System error[btnClean_Click]: " + btnClean_Click.Message); } }
private void btnDispose_Click(object sender, EventArgs e) { try { //只有所属厂家才能废弃 vendList() foreach (string vend in vendList()) { if (vend != PaCSGlobal.LoginUserInfo.Venderid) { XtraMessageBox.Show("只有所属厂家才能废弃", "提示"); return; } } foreach (string currentStatus in statusCodeList()) { if (!MetalMaskGlobal.CheckStatus(currentStatus, "MBDSU")) { XtraMessageBox.Show("状态" + MetalMaskGlobal.GetStatusNmByCode(currentStatus) + "不能" + MetalMaskGlobal.GetStatusNmByCode("MBDSU"), "提示"); return; } } DisposeForm frmNew = new DisposeForm(barcodeList()); DialogResult dg = frmNew.ShowDialog(); if (dg == DialogResult.OK) { btnApply_Click(sender, e); } } catch (Exception btnClean_Click) { XtraMessageBox.Show(this, "System error[btnClean_Click]: " + btnClean_Click.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { string sql = ""; for (int i = 0; i < gridView1.RowCount; i++) { string BarcodeNo = gridView1.GetRowCellValue(i, gridView1.Columns["BarcodeNo"]).ToString(); string MaskVer = gridView1.GetRowCellValue(i, gridView1.Columns["MaskVer"]).ToString(); string SN = gridView1.GetRowCellValue(i, gridView1.Columns["SN"]).ToString(); string MakerText = gridView1.GetRowCellValue(i, gridView1.Columns["Maker"]).ToString(); string ReasonText = gridView1.GetRowCellValue(i, gridView1.Columns["Reason"]).ToString(); string MakerCode = MakerText.Split(':')[1]; string ReasonCode = ReasonText.Split(':')[1]; string ReasonContents = gridView1.GetRowCellValue(i, gridView1.Columns["ReasonContents"]).ToString(); sql = "update pacsm_rm_tool set tool_ver = '" + MaskVer + "' ,tool_sn = '" + SN + "' ,make_vend_code = '" + MakerCode + "',make_rsn_code='" + ReasonCode + "',make_rsn_cont='" + ReasonContents + "',update_dt = to_char(sysdate,'yyyyMMddhh24miss'),update_user ='******' where tool_gubun_code ='MM' and tool_id = '" + BarcodeNo + "' and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' "; OracleHelper.ExecuteNonQuery(sql); MetalMaskGlobal.WriteLog(BarcodeNo, "U"); } XtraMessageBox.Show("保存成功", "提示"); DialogResult = DialogResult.OK; } catch (Exception btnSave_Click) { XtraMessageBox.Show(this, "System error[btnSave_Click]: " + btnSave_Click.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { string sql = ""; for (int i = 0; i < gridView1.RowCount; i++) { string BarcodeNo = gridView1.GetRowCellValue(i, gridView1.Columns["BarcodeNo"]).ToString(); string Location = gridView1.GetRowCellValue(i, gridView1.Columns["Location*"]).ToString(); if (string.IsNullOrEmpty(Location)) { XtraMessageBox.Show("请选择 Location", "提示"); return; } string LineCode = Location.Split(':')[1]; sql = "update pacsm_rm_tool set TOOL_LINE_CODE = '" + LineCode + "' ,status_code = 'MBINS' ,update_dt = to_char(sysdate,'yyyyMMddhh24miss'),update_user ='******' " + " where tool_gubun_code ='MM' " + " and tool_id = '" + BarcodeNo + "' " + " and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' "; OracleHelper.ExecuteNonQuery(sql); MetalMaskGlobal.WriteLog(BarcodeNo, "U"); } XtraMessageBox.Show("保存成功", "提示"); DialogResult = DialogResult.OK; } catch (Exception btnSave_Click) { XtraMessageBox.Show(this, "System error[btnSave_Click]: " + btnSave_Click.Message); } }
private void DoData(string data) { if (IsRecordExisted(data)) { XtraMessageBox.Show("barcode已经存在", "提示"); return; } DataTable dtData = GetData(data); if (dtData == null) { return;//barcode不存在 } string currentStatus = dtData.Rows[0]["status_code"].ToString(); if (!MetalMaskGlobal.CheckStatus(currentStatus, "MBDEL")) { XtraMessageBox.Show("状态" + MetalMaskGlobal.GetStatusNmByCode(currentStatus) + "不能" + MetalMaskGlobal.GetStatusNmByCode("MBDEL"), "提示"); return; } DataRow dr = dt.NewRow(); dr["BarcodeNo"] = dtData.Rows[0]["BarcodeNo"]; dt.Rows.Add(dr); gridControl1.DataSource = dt; gridView1.Columns[0].Width = 100; gridView1.Columns[0].OptionsColumn.AllowEdit = false; }
private void DoData(string data) { if (IsRecordExisted(data)) { XtraMessageBox.Show("barcode已经存在", "提示"); return; } DataTable dtData = GetData(data); if (dtData == null) { return; //barcode不存在 } string currentStatus = dtData.Rows[0]["status_code"].ToString(); if (!MetalMaskGlobal.CheckStatus(currentStatus, "MBCOT")) { XtraMessageBox.Show("状态" + MetalMaskGlobal.GetStatusNmByCode(currentStatus) + "不能" + MetalMaskGlobal.GetStatusNmByCode("MBCOT"), "提示"); return; } DataRow dr = dt.NewRow(); dr["BarcodeNo"] = dtData.Rows[0]["BarcodeNo"]; dr["ProductModel"] = dtData.Rows[0]["ProductModel"]; dr["Status"] = dtData.Rows[0]["Status"]; dr["Location*"] = dtData.Rows[0]["Location"]; dr["CarryOutReason"] = dtData.Rows[0]["CarryOutReason"]; dr["Recipient"] = dtData.Rows[0]["Recipient"]; dr["Tel"] = dtData.Rows[0]["Tel"]; dt.Rows.Add(dr); gridControl1.DataSource = dt; gridView1.Columns[3].AppearanceCell.BackColor = PaCSGlobal.MustColor; gridView1.Columns[4].AppearanceCell.BackColor = PaCSGlobal.OptionColor; gridView1.Columns[5].AppearanceCell.BackColor = PaCSGlobal.OptionColor; gridView1.Columns[6].AppearanceCell.BackColor = PaCSGlobal.OptionColor; gridView1.Columns[0].Width = 100; gridView1.Columns[0].OptionsColumn.AllowEdit = false; gridView1.Columns[1].Width = 120; gridView1.Columns[1].OptionsColumn.AllowEdit = false; gridView1.Columns[2].Width = 120; gridView1.Columns[2].OptionsColumn.AllowEdit = false; gridView1.Columns[3].Width = 120; gridView1.Columns[3].ColumnEdit = new MetalMaskGlobal().cmbVendor(); gridView1.Columns[4].Width = 150; gridView1.Columns[5].Width = 120; gridView1.Columns[6].Width = 120; }
private void LoadCombobox() { try { DataTable dtReason = MetalMaskGlobal.GetMakerReason(); DataTable dtStoreLoc = MetalMaskGlobal.GetRegisterBinInfo(); DataTable dtMaker = MetalMaskGlobal.GetMakerVendor(); for (int i = 0; i < dtReason.Rows.Count; i++) { ComboxData data = new ComboxData(); data.Text = dtReason.Rows[i]["COMM_CODE_NM"].ToString(); data.Value = dtReason.Rows[i]["COMM_CODE"].ToString(); cmbReason.Properties.Items.Add(data); } for (int i = 0; i < dtStoreLoc.Rows.Count; i++) { cmbStore.Properties.Items.Add(dtStoreLoc.Rows[i]["Bin"].ToString()); } for (int i = 0; i < dtMaker.Rows.Count; i++) { ComboxData data = new ComboxData(); data.Text = dtMaker.Rows[i]["vend_nm"].ToString(); data.Value = dtMaker.Rows[i]["vend_code"].ToString(); cmbMaker.Properties.Items.Add(data); } ComboxData dataOwer = new ComboxData(); dataOwer.Text = PaCSGlobal.LoginUserInfo.Vendername; dataOwer.Value = PaCSGlobal.LoginUserInfo.Venderid; cmbOwerVend.Properties.Items.Add(dataOwer); if (!PaCSGlobal.LoginUserInfo.Venderid.Equals("C660")) { ComboxData dataOwer2 = new ComboxData(); dataOwer2.Text = "SSDP"; dataOwer2.Value = "C660"; cmbOwerVend.Properties.Items.Add(dataOwer2); } cmbOwerVend.SelectedIndex = 0; } catch (Exception LoadCombobox) { XtraMessageBox.Show(this, "System error[LoadCombobox]: " + LoadCombobox.Message); } }
private void DoData(string data) { if (IsRecordExisted(data)) { XtraMessageBox.Show("barcode已经存在", "提示"); return; } DataTable dtData = GetData(data); if (dtData == null) { return;//barcode不存在 } string currentStatus = dtData.Rows[0]["status_code"].ToString(); if (!MetalMaskGlobal.CheckStatus(currentStatus, "MBBIN")) { XtraMessageBox.Show("状态" + MetalMaskGlobal.GetStatusNmByCode(currentStatus) + "不能" + MetalMaskGlobal.GetStatusNmByCode("MBBIN"), "提示"); return; } DataRow dr = dt.NewRow(); dr["BarcodeNo"] = dtData.Rows[0]["BarcodeNo"]; dr["MaskVer"] = dtData.Rows[0]["MaskVer"]; dr["Status"] = dtData.Rows[0]["Status"]; dr["StoreLoc"] = dtData.Rows[0]["StoreLoc"];; dr["Tension"] = dtData.Rows[0]["Tension"]; dt.Rows.Add(dr); gridControl1.DataSource = dt; //gridView1.Columns[3].AppearanceCell.BackColor = PaCSGlobal.MustColor; gridView1.Columns[0].Width = 150; gridView1.Columns[0].OptionsColumn.AllowEdit = false; gridView1.Columns[1].Width = 150; gridView1.Columns[1].OptionsColumn.AllowEdit = false; gridView1.Columns[2].Width = 150; gridView1.Columns[2].OptionsColumn.AllowEdit = false; gridView1.Columns[3].Width = 150; gridView1.Columns[3].OptionsColumn.AllowEdit = false; gridView1.Columns[4].Width = 150; gridView1.Columns[4].OptionsColumn.AllowEdit = false; }
private void btnSave_Click(object sender, EventArgs e) { try { string sql = ""; for (int i = 0; i < gridView1.RowCount; i++) { string BarcodeNo = gridView1.GetRowCellValue(i, gridView1.Columns["BarcodeNo"]).ToString(); string Tension = gridView1.GetRowCellValue(i, gridView1.Columns["Tension*"]).ToString(); if (string.IsNullOrEmpty(Tension)) { XtraMessageBox.Show("请输入 Tension", "提示"); return; } string Times = gridView1.GetRowCellValue(i, gridView1.Columns["本次使用次数*"]).ToString(); if (string.IsNullOrEmpty(Times)) { XtraMessageBox.Show("请输入 本次使用次数", "提示"); return; } int result = 0; bool flag = int.TryParse(Times, out result); if (!flag) { XtraMessageBox.Show("使用次数,请输入正确数字", "提示"); return; } sql = "update pacsm_rm_tool set status_code = 'MBCLN' ,tool_tens_value = '" + Tension + "',TOOL_USE_TIMES =nvl(TOOL_USE_TIMES,0)+'" + Times + "',TOOL_USE_TIMES_ADD = '" + Times + "',update_dt = to_char(sysdate,'yyyyMMddhh24miss'),update_user ='******' " + " where tool_gubun_code ='MM' " + " and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' " + " and tool_id = '" + BarcodeNo + "'"; OracleHelper.ExecuteNonQuery(sql); MetalMaskGlobal.WriteLog(BarcodeNo, "U"); } XtraMessageBox.Show("保存成功", "提示"); DialogResult = DialogResult.OK; } catch (Exception btnSave_Click) { XtraMessageBox.Show(this, "System error[btnSave_Click]: " + btnSave_Click.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { string sql = ""; for (int i = 0; i < gridView1.RowCount; i++) { string BarcodeNo = gridView1.GetRowCellValue(i, gridView1.Columns["BarcodeNo"]).ToString(); string vendLocNm = gridView1.GetRowCellValue(i, gridView1.Columns["Location*"]).ToString(); //不能搬到自己厂家 DataTable dtData = GetData(BarcodeNo); if (vendLocNm.Split(':')[0].Equals(dtData.Rows[0]["Location"])) { XtraMessageBox.Show("不能搬出到自己厂家", "提示"); return; } string vendLocCode = vendLocNm.Split(':')[1]; string CarryOutReason = gridView1.GetRowCellValue(i, gridView1.Columns["CarryOutReason"]).ToString(); string Recipient = gridView1.GetRowCellValue(i, gridView1.Columns["Recipient"]).ToString(); string Tel = gridView1.GetRowCellValue(i, gridView1.Columns["Tel"]).ToString(); sql = "update pacsm_rm_tool set VEND_LOC_CODE = '" + vendLocCode + "' ,status_code = 'MBCOT',caryot_rsn = '" + CarryOutReason + "',CARYOT_RECEIVER='" + Recipient + "',CARYOT_RECEIVER_CONTCT='" + Tel + "',update_dt = to_char(sysdate,'yyyyMMddhh24miss'),update_user ='******' " + " where tool_gubun_code ='MM' " + " and tool_id = '" + BarcodeNo + "' " + " and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' "; OracleHelper.ExecuteNonQuery(sql); MetalMaskGlobal.WriteLog(BarcodeNo, "U"); } XtraMessageBox.Show("保存成功", "提示"); DialogResult = DialogResult.OK; } catch (Exception btnSave_Click) { XtraMessageBox.Show(this, "System error[btnSave_Click]: " + btnSave_Click.Message); } }
private void DoData(string data) { if (IsRecordExisted(data)) { XtraMessageBox.Show("barcode已经存在", "提示"); return; } DataTable dtData = GetData(data); if (dtData == null) { return;//barcode不存在 } string currentStatus = dtData.Rows[0]["status_code"].ToString(); if (!MetalMaskGlobal.CheckStatus(currentStatus, "MBDSU")) { XtraMessageBox.Show("状态" + MetalMaskGlobal.GetStatusNmByCode(currentStatus) + "不能" + MetalMaskGlobal.GetStatusNmByCode("MBDSU"), "提示"); return; } DataRow dr = dt.NewRow(); dr["BarcodeNo"] = dtData.Rows[0]["BarcodeNo"]; //dr["Reason*"] = dtData.Rows[0]["Reason"]; dt.Rows.Add(dr); gridControl1.DataSource = dt; gridView1.Columns[0].Width = 100; gridView1.Columns[1].Width = 100; gridView1.Columns[1].ColumnEdit = new MetalMaskGlobal().cmbDsuReason(); gridView1.Columns[1].AppearanceCell.BackColor = PaCSGlobal.MustColor; }
private void btnSave_Click(object sender, EventArgs e) { try { if (tbProdModel.Text.Equals("")) { XtraMessageBox.Show("请输入 Prod.Model", "提示"); tbProdModel.Focus(); return; } if (tbMaskCode.Text.Equals("")) { XtraMessageBox.Show("请输入 M/Mask Code", "提示"); tbMaskCode.Focus(); return; } if (tbPCBCode.Text.Equals("")) { XtraMessageBox.Show("请输入 PCB Code", "提示"); tbPCBCode.Focus(); return; } if (tbTB.Text.Equals("")) { XtraMessageBox.Show("请输入 T/B", "提示"); tbTB.Focus(); return; } if (tbBarcode.Text.Equals("")) { XtraMessageBox.Show("请输入 Barcode No", "提示"); tbBarcode.Focus(); return; } if (cmbMaker.SelectedIndex == -1) { XtraMessageBox.Show("请选择 Maker", "提示"); cmbMaker.Focus(); return; } if (MetalMaskGlobal.CheckBarcodeExist(tbBarcode.Text.Trim())) { XtraMessageBox.Show("此 BarcodeNo 已存在!", "提示"); tbBarcode.Focus(); return; } string sql = "insert into pacsm_rm_tool(fct_code,plant_code,tool_gubun_code,use_yn,del_yn,CREATE_DT,status_code,tool_id,tool_code,tool_ver,tool_tens_value,CREATE_USER,TOOL_BIN_CODE,make_vend_code,make_rsn_code,make_rsn_cont,TOOL_SN,vend_code,vend_loc_code) " + " values( 'C660A','P631','MM','Y','N',to_char(sysdate,'yyyyMMddhh24miss'),'MBNIN',:tool_id,:tool_code,:tool_ver,:tool_tens_value,:CREATE_USER,:TOOL_BIN_CODE,:make_vend_code,:make_rsn_code,:make_rsn_cont,:TOOL_SN,:vend_code,:vend_loc_code)"; OracleParameter[] cmdParam = new OracleParameter[] { new OracleParameter(":tool_id", OracleType.VarChar, 50), new OracleParameter(":tool_code", OracleType.VarChar, 30), new OracleParameter(":tool_ver", OracleType.VarChar, 50), new OracleParameter(":tool_tens_value", OracleType.VarChar, 50), new OracleParameter(":CREATE_USER", OracleType.VarChar, 50), new OracleParameter(":TOOL_BIN_CODE", OracleType.VarChar, 50), new OracleParameter(":make_vend_code", OracleType.VarChar, 50), new OracleParameter(":make_rsn_code", OracleType.VarChar, 50), new OracleParameter(":make_rsn_cont", OracleType.VarChar, 100), new OracleParameter(":TOOL_SN", OracleType.VarChar, 50), new OracleParameter(":vend_code", OracleType.VarChar, 50), new OracleParameter(":vend_loc_code", OracleType.VarChar, 50) }; cmdParam[0].Value = tbBarcode.Text.Trim(); cmdParam[1].Value = tbMaskCode.Text.Trim(); cmdParam[2].Value = tbMMVer.Text.Trim(); cmdParam[3].Value = tbTension.Text.Trim(); cmdParam[4].Value = PaCSGlobal.LoginUserInfo.Id; string storeLoc = ""; if (cmbStore.SelectedIndex != -1) { storeLoc = cmbStore.Properties.Items[cmbStore.SelectedIndex].ToString(); } else { storeLoc = cmbStore.Text == "-请选择-" ? "" : cmbStore.Text; } cmdParam[5].Value = storeLoc; cmdParam[6].Value = cmbMaker.SelectedIndex == -1?"":(cmbMaker.SelectedItem as ComboxData).Value; cmdParam[7].Value = cmbReason.SelectedIndex == -1?"":(cmbReason.SelectedItem as ComboxData).Value; cmdParam[8].Value = tbContents.Text.Trim(); cmdParam[9].Value = tbSN.Text.Trim(); cmdParam[10].Value = PaCSGlobal.LoginUserInfo.Venderid; cmdParam[11].Value = PaCSGlobal.LoginUserInfo.Venderid; int i = OracleHelper.ExecuteNonQuery(sql, cmdParam); if (i > 0) { XtraMessageBox.Show("保存成功!", "提示"); MetalMaskGlobal.WriteLog(tbBarcode.Text.Trim(), "I");//履历 //如果MetalMask基本信息没有,则保存到基本信息表中 string sql2 = "select * from pacsm_md_tool_equip where tool_gubun_code = 'M' and tool_code = '" + tbMaskCode.Text.Trim() + "'"; DataTable dtResult = OracleHelper.ExecuteDataTable(sql2); if (dtResult.Rows.Count == 0) { string sql3 = "insert into pacsm_md_tool_equip(fct_code,tool_gubun_code,pcb_gubun_code,del_yn,use_yn,fst_reg_dt,fst_reger_id," + " tool_code,rprs_model_code,tb_gubun_code," + " tool_arry_num,tool_ver,tool_leng,tool_heit,tool_thic" + " ) " +//2 " values('C660A','M','M','N','Y',to_char(sysdate,'yyyyMMddhh24miss'),'" + PaCSGlobal.LoginUserInfo.Name + "'," + " :tool_code,:rprs_model_code,:tb_gubun_code," + " :tool_arry_num,:tool_ver,:tool_leng,:tool_heit,:tool_thic)"; OracleParameter[] cmdParam2 = new OracleParameter[] { new OracleParameter(":tool_code", OracleType.VarChar, 30), new OracleParameter(":rprs_model_code", OracleType.VarChar, 50), new OracleParameter(":tb_gubun_code", OracleType.VarChar, 50), new OracleParameter(":tool_arry_num", OracleType.Number, 50), new OracleParameter(":tool_ver", OracleType.VarChar, 50), new OracleParameter(":tool_leng", OracleType.Number, 50), new OracleParameter(":tool_heit", OracleType.Number, 50), new OracleParameter(":tool_thic", OracleType.Number, 50) }; cmdParam[0].Value = tbMaskCode.Text.Trim(); cmdParam[1].Value = tbProdModel.Text.Trim(); cmdParam[2].Value = tbTB.Text.Trim(); cmdParam[3].Value = tbArray.Text.Trim(); cmdParam[4].Value = tbPCBVer.Text.Trim(); cmdParam[5].Value = tbLength.Text.Trim(); cmdParam[6].Value = tbWidth.Text.Trim(); cmdParam[7].Value = tbThickness.Text.Trim(); OracleHelper.ExecuteNonQuery(sql3, cmdParam2); } DialogResult = DialogResult.OK; this.Close(); } } catch (Exception btnSave_Click) { XtraMessageBox.Show(this, "System error[btnSave_Click]: " + btnSave_Click.Message); } }
private void btnSave_Click(object sender, EventArgs e) { try { if (tbProdModel.Text.Equals("")) { XtraMessageBox.Show("请选择 Prod.Model", "提示"); tbProdModel.Focus(); return; } if (cmbStore.SelectedIndex == -1) { XtraMessageBox.Show("请选择 Store Loc.", "提示"); cmbStore.Focus(); return; } if (cmbMaker.SelectedIndex == -1) { XtraMessageBox.Show("请选择 Maker", "提示"); cmbMaker.Focus(); return; } if (tbBarcode.Text.Equals("")) { XtraMessageBox.Show("请输入 Barcode No", "提示"); tbBarcode.Focus(); return; } if (MetalMaskGlobal.CheckBarcodeExist(tbBarcode.Text.Trim())) { XtraMessageBox.Show("此 BarcodeNo 已存在!", "提示"); tbBarcode.Focus(); return; } string sql = "insert into pacsm_rm_tool(tool_gubun_code,del_yn,CREATE_DT,status_code,tool_id,tool_code,tool_ver,tool_tens_value,tool_use_times,CREATE_USER,TOOL_BIN_CODE,make_vend_code,make_rsn_code,make_rsn_cont,TOOL_SN,vend_code,vend_loc_code,attachid) " + " values( 'MM','N',to_char(sysdate,'yyyyMMddhh24miss'),'MBNIN',:tool_id,:tool_code,:tool_ver,:tool_tens_value,:tool_use_times,:CREATE_USER,:TOOL_BIN_CODE,:make_vend_code,:make_rsn_code,:make_rsn_cont,:TOOL_SN,:vend_code,:vend_loc_code,:attachid)"; OracleParameter[] cmdParam = new OracleParameter[] { new OracleParameter(":tool_id", OracleType.VarChar, 50), new OracleParameter(":tool_code", OracleType.VarChar, 30), new OracleParameter(":tool_ver", OracleType.VarChar, 50), new OracleParameter(":tool_tens_value", OracleType.VarChar, 50), new OracleParameter(":CREATE_USER", OracleType.VarChar, 50), new OracleParameter(":TOOL_BIN_CODE", OracleType.VarChar, 50), new OracleParameter(":make_vend_code", OracleType.VarChar, 50), new OracleParameter(":make_rsn_code", OracleType.VarChar, 50), new OracleParameter(":make_rsn_cont", OracleType.VarChar, 100), new OracleParameter(":TOOL_SN", OracleType.VarChar, 50), new OracleParameter(":vend_code", OracleType.VarChar, 50), new OracleParameter(":vend_loc_code", OracleType.VarChar, 50), new OracleParameter(":attachid", OracleType.VarChar, 100), new OracleParameter(":tool_use_times", OracleType.VarChar, 100) }; cmdParam[0].Value = tbBarcode.Text.Trim(); cmdParam[1].Value = tbMaskCode.Text.Trim(); cmdParam[2].Value = tbMMVer.Text.Trim(); cmdParam[3].Value = tbTension.Text.Trim(); cmdParam[4].Value = PaCSGlobal.LoginUserInfo.Id; string storeLoc = ""; if (cmbStore.SelectedIndex != -1) { storeLoc = cmbStore.Properties.Items[cmbStore.SelectedIndex].ToString(); } else { storeLoc = cmbStore.Text == "-请选择-" ? "" : cmbStore.Text; } cmdParam[5].Value = storeLoc; cmdParam[6].Value = cmbMaker.SelectedIndex == -1?"":(cmbMaker.SelectedItem as ComboxData).Value; cmdParam[7].Value = cmbReason.SelectedIndex == -1?"":(cmbReason.SelectedItem as ComboxData).Value; cmdParam[8].Value = tbContents.Text.Trim(); cmdParam[9].Value = tbSN.Text.Trim(); cmdParam[10].Value = cmbOwerVend.SelectedIndex == -1 ? "" : (cmbOwerVend.SelectedItem as ComboxData).Value; cmdParam[11].Value = PaCSGlobal.LoginUserInfo.Venderid; cmdParam[12].Value = btnImage.Text; cmdParam[13].Value = tbUseTimes.Text.Trim(); int i = OracleHelper.ExecuteNonQuery(sql, cmdParam); if (i > 0) { XtraMessageBox.Show("保存成功!", "提示"); MetalMaskGlobal.WriteLog(tbBarcode.Text.Trim(), "I");//履历 DialogResult = DialogResult.OK; this.Close(); } } catch (Exception btnSave_Click) { XtraMessageBox.Show(this, "System error[btnSave_Click]: " + btnSave_Click.Message); } }