/// <summary> /// 残损回退 /// </summary> /// <param name="row"></param> /// <returns></returns> public void RollbackDamage(DataSet1.T_OCRX_DAMAGERow row) { row.ROLLBACK = "Y"; row.ROLLBACKREASON = row1.CTOSERRORMSG; row.UPDATEDBY = Config.UserId; OCRX.DAL.cctdbDAL.UpdateDamageStatus(row); }
private void dgvDmgInfo_CellContentClick(object sender, DataGridViewCellEventArgs e) { if (dgvDmgInfo.Columns[e.ColumnIndex].Name == "Rollback") { try { decimal dockid = decimal.Parse(dgvDmgInfo.Rows[e.RowIndex].Cells[1].Value.ToString()); DataSet1.T_OCRX_CNTDataTable dt = bll.SelectCnt(dockid); row = dt[0]; row2 = dt.Count > 1 ? dt[1] : null; bll.row1 = row; bll.row2 = row2; this.Cursor = Cursors.WaitCursor; if (row == null) { MessageBox.Show("该记录不存在"); return; } fmExcepInput fm = new fmExcepInput(); fm.reason = row.CTOSERRORMSG; DialogResult drs = fm.ShowDialog(); //DialogResult drs = MessageBox.Show("确认转异常处理?", "提示", MessageBoxButtons.YesNo, MessageBoxIcon.Question, MessageBoxDefaultButton.Button2); if (drs == DialogResult.No || drs == DialogResult.Cancel) { return; } row.CTOSERRORMSG = fm.reason; if (row2 != null) { row2.CTOSERRORMSG = fm.reason; } bll.Rollback(); DataSet1.T_OCRX_DAMAGERow damageRow = damage[e.RowIndex]; bll.RollbackDamage(damageRow); MessageBox.Show("回退成功."); this.button1.PerformClick(); } catch (Exception ex) { MessageBox.Show(ex.Message); } finally { this.Cursor = Cursors.Default; } } }
/// <summary> /// 删除残损记录 /// </summary> /// <param name="row"></param> public static void DeleteDamage(DataSet1.T_OCRX_DAMAGERow row) { SqlHelper.Oracle.ExecuteObjectTypedParams(Config.ConnectionString, "OCR.pkg_ocrx.p_delete_damage", CommandType.StoredProcedure, row); }
/// <summary> /// 更新残损记录状态 /// </summary> /// <param name="row"></param> public static void UpdateDamageStatus(DataSet1.T_OCRX_DAMAGERow row) { OCRDbContext.Runner.ExecuteObjectTypedParams(Config.ConnectionString, "OCR.pkg_ocrx.p_update_damagecntx", CommandType.StoredProcedure, row); }
/// <summary> /// 插入残损记录 /// </summary> /// <param name="row"></param> public static void InsertDamage(DataSet1.T_OCRX_DAMAGERow row) { OCRDbContext.Runner.ExecuteObjectTypedParams(Config.ConnectionString, "OCR.pkg_ocrx.p_insert_damage", CommandType.StoredProcedure, row); }
/// <summary> /// 删除单个箱残损信息 /// </summary> /// <returns></returns> public void DeleteDamageInfo(DataSet1.T_OCRX_DAMAGERow row) { OCRX.DAL.cctdbDAL.DeleteDamage(row); }
/// <summary> /// 更新单个箱残损信息 /// </summary> /// <returns></returns> public void UpdateDamageInfo(DataSet1.T_OCRX_DAMAGERow row) { OCRX.DAL.cctdbDAL.UpdateDamageInfo(row); }
/// <summary> /// 新增单个箱残损信息 /// </summary> /// <returns></returns> public void InsertDamageInfo(DataSet1.T_OCRX_DAMAGERow row) { OCRX.DAL.cctdbDAL.InsertDamage(row); }