public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
CheckWorkCenterReasonVo inVo = (CheckWorkCenterReasonVo)vo;
CheckWorkCenterReasonVo outVo = new CheckWorkCenterReasonVo();
StringBuilder sqlQuery = new StringBuilder();
//create SQL query
sqlQuery.Append(" select count(defective_reason) as defective_reason from t_prod_report_defective_info a ");
sqlQuery.Append(" left join m_defective_reason b on b.defective_reason_id = a.defective_reason ");
sqlQuery.Append(" left join t_prod_report_dtl x on x.production_report_dtl_id = a.production_report_dtl_id ");
sqlQuery.Append(" left join t_prod_report c on c.production_report_id = x.production_report_id ");
sqlQuery.Append(" left join sap_mo d on d.sap_manufacturing_order_number = c.mo_number ");
sqlQuery.Append(" left join m_process_work e on e.process_work_cd = d.sap_work_center ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo != null)
{
sqlQuery.Append(" and b.defective_reason_cd = :defective_reason_cd ");
sqlQuery.Append(" and e.process_work_id = :sap_work_center ");
}
else
{
return(outVo);
}
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo != null)
{
sqlParameter.AddParameterString("defective_reason_cd", inVo.Defective_Reason_ID);
sqlParameter.AddParameterInteger("sap_work_center", inVo.Work_Center);
}
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
outVo.Flag = Convert.ToInt32(dataReader["defective_reason"]);
}
dataReader.Close();
return(outVo);
}
private void ProcessWork_dgv_CellValueChanged(object sender, DataGridViewCellEventArgs e)
{
if (rowbool && (!Convert.ToBoolean(ProcessWork_dgv.Rows[e.RowIndex].Cells["colSelect"].Value)))
{
CheckWorkCenterReasonVo InVo = new CheckWorkCenterReasonVo();
CheckWorkCenterReasonVo outVo = new CheckWorkCenterReasonVo();
InVo.Defective_Reason_ID = DefectiveReasonCode_txt.Text;
InVo.Flag = 0;
InVo.Work_Center = Convert.ToInt32(ProcessWork_dgv.Rows[SelectOldRow].Cells["colProcessWorkId"].Value.ToString().Trim());
outVo = (CheckWorkCenterReasonVo)base.InvokeCbm(new Cbm.DefectiveReason.CheckWorkCenterReasonCbm(), InVo, false);
if (outVo.Flag > 0)
{
ProcessWork_dgv.Rows[SelectOldRow].Cells["colSelect"].Value = true;
}
}
}
