/// <summary> /// 生成DOCNO号 /// </summary> /// <returns></returns> private string GetDocNo() { if (string.IsNullOrEmpty(tbDocno.Text)) { docno = TonerGlobal.GenerateDocNo(); } else { //if("追加扫描的docno中,有入库的碳粉,不能追加扫描") docno = tbDocno.Text.Trim(); } return(docno); }
/// <summary> /// 厂家 废弃 /// </summary> private void Dispose(string data) { string sql = "update pacsd_pm_box set final_move_type = '551',final_move_code = 'MOVE0601',final_doc_no = :final_doc_no," + " last_doc_no = final_doc_no,operation_window = 'SCRAP',box_case_status = :box_case_status,box_status = :box_status," + " update_date = to_char(sysdate,'yyyyMMdd'),update_time = to_char(sysdate,'hh24miss'),update_user = :update_user,update_ip = :update_ip " + " where box_label = '" + data + "' " + " and fct_code = '" + PaCSGlobal.LoginUserInfo.Fct_code + "' "; OracleParameter[] cmdParam = new OracleParameter[] { new OracleParameter(":final_doc_no", OracleType.VarChar, 50), new OracleParameter(":update_user", OracleType.VarChar, 50), new OracleParameter(":update_ip", OracleType.VarChar, 50), new OracleParameter(":box_case_status", OracleType.VarChar, 50), new OracleParameter(":box_status", OracleType.VarChar, 50) }; cmdParam[0].Value = TonerGlobal.GenerateDocNo(); cmdParam[1].Value = PaCSGlobal.LoginUserInfo.Id; cmdParam[2].Value = PaCSGlobal.GetClientIp(); DataTable dtStatus = TonerGlobal.GetCommInfoByCode("MOVE0601"); if (dtStatus.Rows.Count > 0) { cmdParam[3].Value = dtStatus.Rows[0]["BOX_CASE_STATUS"].ToString(); cmdParam[4].Value = dtStatus.Rows[0]["BOX_STATUS"].ToString(); } else { cmdParam[3].Value = ""; cmdParam[4].Value = ""; } int i = OracleHelper.ExecuteNonQuery(sql, cmdParam); //插入prog表 TonerGlobal.InsertIntoProg(data); //提示成功语音 PaCSGlobal.PlayWavOk(); XtraMessageBox.Show("废弃成功!", "提示"); }