public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PlanWorkingStatusVo inVo = (PlanWorkingStatusVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <PlanWorkingStatusVo> voList = new ValueObjectList <PlanWorkingStatusVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select plan_section, total_no, plan_data_no, plan_data_div from t_plan_status_machine where plan_id in(select max(plan_id) from t_plan_status_machine group by plan_section) order by plan_section ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
PlanWorkingStatusVo outVo = new PlanWorkingStatusVo
{
TotalNo = int.Parse(dataReader["total_no"].ToString()),
PlanNo = int.Parse(dataReader["plan_data_no"].ToString()),
Rate = double.Parse(dataReader["plan_data_div"].ToString()),
PlanSection = dataReader["plan_section"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
PlanWorkingStatusVo inVo = (PlanWorkingStatusVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into t_plan_status_machine(plan_section, plan_datetime_add, total_no, plan_data_no, plan_data_div, registration_user_cd, registration_date_time, factory_cd) ");
sql.Append("values(:plan_section, :plan_datetime_add, :total_no, :plan_data_no, :plan_data_div, :registration_user_cd,now(), :factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("plan_section", inVo.PlanSection);
sqlParameter.AddParameterDateTime("plan_datetime_add", inVo.DateTimeAdd);
sqlParameter.AddParameterInteger("total_no", inVo.TotalNo);
sqlParameter.AddParameterInteger("plan_data_no", inVo.PlanNo);
sqlParameter.AddParameter("plan_data_div", inVo.Rate);
sqlParameter.AddParameterDateTime("registration_date_time", inVo.RegistrationDateTime);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
PlanWorkingStatusVo outVo = new PlanWorkingStatusVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void update_btn_Click(object sender, EventArgs e)
{
if (checkdata())
{
PlanWorkingStatusVo outVo = new PlanWorkingStatusVo();
PlanWorkingStatusVo inVo = new PlanWorkingStatusVo()
{
PlanId = addplanworking.PlanId,
PlanSection = ((LocationVo)this.section_cbm.SelectedItem).LocationCode,
DateTimeAdd = datetime_add_dtp.Value,
TotalNo = Int16.Parse(total_machine_txt.Text),
PlanNo = Int16.Parse(plan_machine_txt.Text),
Rate = Double.Parse(rate_txt.Text),
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationDateTime = DateTime.Now
};
try
{
outVo = (PlanWorkingStatusVo)DefaultCbmInvoker.Invoke(new AddPlanWorkingStatusCbm(), inVo);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, section_cbm.Text + " : " + section_cbm.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
}
