/// <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("废弃成功！", "提示");
}
