/// <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);
}
}
