public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
JigRepairInformationVo inVo = (JigRepairInformationVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update t_jig_repair_info set jig_repair_cd=:jig_repair_cd,
model_id=:model_id,
line_id=:line_id,
process_id=:process_id,
jig_cause_id=:jig_cause_id,
time_from=:time_from,
time_to=:time_to,
jig_current_status=:jig_current_status,
jig_response_id=:jig_response_id,
repair_result=:repair_result,
jig_after_repair_status=:jig_after_repair_status,
place=:place
");
sql.Append(" where jig_repair_id =:jig_repair_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("jig_repair_id", inVo.JigRepairId);
sqlParameter.AddParameter("jig_repair_cd", inVo.JigRepairCode);
sqlParameter.AddParameter("model_id", inVo.ModelId);
sqlParameter.AddParameter("line_id", inVo.LineId);
sqlParameter.AddParameter("process_id", inVo.ProcessId);
sqlParameter.AddParameter("jig_cause_id", inVo.JigCauseId);
sqlParameter.AddParameter("time_from", inVo.TimeFrom);
sqlParameter.AddParameter("time_to", inVo.TimeTo);
sqlParameter.AddParameter("jig_current_status", inVo.JigCurrentStatus);
sqlParameter.AddParameter("jig_response_id", inVo.JigResponseId);
sqlParameter.AddParameter("repair_result", inVo.JigRepairResult);
sqlParameter.AddParameter("jig_after_repair_status", inVo.JigAfterRepairStatus);
sqlParameter.AddParameter("place", inVo.JigPlace);
sqlParameter.AddParameter("registration_user_cd", inVo.RegistrationUserCode);
sqlParameter.AddParameter("factory_cd", inVo.FactoryCode);
//execute SQL
JigRepairInformationVo outVo = new JigRepairInformationVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void update_btn_Click(object sender, EventArgs e)
{
if (jig_repair_information_dgv.SelectedCells.Count > 0)
{
JigRepairInformationVo selectedvo = (JigRepairInformationVo)jig_repair_information_dgv.CurrentRow.DataBoundItem;
if (new AddJigRepairInformationForm { jvo = selectedvo }.ShowDialog() == DialogResult.OK)
{
//search_btn_Click(null, null);
selectdata();
}
}
}
private void buttonCommon1_Click(object sender, EventArgs e) // ok buttion
{
if (checkdata())
{
JigRepairInformationVo outVo = new JigRepairInformationVo();
JigRepairInformationVo inVo = new JigRepairInformationVo
{
JigRepairId = jvo.JigResponseId,
TimeFrom = this.timefrom_dtp.Value,
TimeTo = this.timeto_dtp.Value,
LineId = ((LineVo)this.line_cmb.SelectedItem).LineId,
JigCauseId = ((JigCauseVo)this.jigause_cmb.SelectedItem).JigCauseId,
ModelId = ((ModelVo)this.model_cmb.SelectedItem).ModelId,
ProcessWorkId = ((ProcessWorkVo)this.process_work_cmb.SelectedItem).ProcessId,
JigResponseId = ((JigResponseVo)this.jigresponse_cmb.SelectedItem).JigResponseId,
JigRepairCode = jig_code_txt.Text,
RegistrationUserCode = UserData.GetUserData().UserCode,
FactoryCode = UserData.GetUserData().FactoryCode,
//---------------
JigRepairResult = resuft_cmb.Text,
JigPlace = place_txt.Text,
JigCauseCode = jig_code_txt.Text,
JigAfterRepairStatus = afterstatus_txt.Text,
JigCurrentStatus = beforestatus_txt.Text
};
try
{
if (inVo.JigRepairId > 0)
{
outVo = (JigRepairInformationVo)DefaultCbmInvoker.Invoke(new UpdateJigRepairInformationCbm(), inVo);
}
else
{
outVo = (JigRepairInformationVo)DefaultCbmInvoker.Invoke(new AddJigRepairInformationCbm(), inVo);
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo.AffectedCount > 0)
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
JigRepairInformationVo inVo = (JigRepairInformationVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <JigRepairInformationVo> voList = new ValueObjectList <JigRepairInformationVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT a.jig_repair_id, a.jig_repair_cd, c.model_name, c.model_cd, b.line_name, g.process_name, e.jig_cause_name, f.jig_response_name,
a.time_from, a.time_to, a.jig_current_status, a.jig_after_repair_status, a.repair_result, a.place,b.line_cd,a.registration_user_cd,a.registration_date_time,a.factory_cd
from t_jig_repair_info a
left join m_line b on b.line_id = a.line_id
left join m_model c on c.model_id = a.model_id
left join m_process g on g.process_id = a.process_id
left join m_jig_cause e on e.jig_cause_id = a.jig_cause_id
left join m_jig_response f on f.jig_response_id = a.jig_response_id
WHERE ");
sql.Append(@"time_from >= :starttime and time_from <= :endtime"); //
sqlParameter.AddParameterDateTime("starttime", inVo.TimeFrom);
sqlParameter.AddParameterDateTime("endtime", inVo.TimeTo.AddDays(1));
if (!String.IsNullOrEmpty(inVo.ModelCode))
{
sql.Append(" and model_cd =:model_cd ");
sqlParameter.AddParameterString("model_cd", inVo.ModelCode);
}
if (!String.IsNullOrEmpty(inVo.ProcessName))
{
sql.Append(" and process_name =:process_name ");
sqlParameter.AddParameterString("process_name", inVo.ProcessName);
}
if (!String.IsNullOrEmpty(inVo.LineCode))
{
sql.Append(" and line_cd =:line_cd ");
sqlParameter.AddParameterString("line_cd", inVo.LineCode);
}
if (!String.IsNullOrEmpty(inVo.JigRepairCode))
{
sql.Append(" and jig_repair_cd =:jig_repair_cd ");
sqlParameter.AddParameterString("jig_repair_cd", inVo.JigRepairCode);
}
if (!String.IsNullOrEmpty(inVo.JigCauseName))
{
sql.Append(" and jig_cause_name = :jig_cause_name ");
sqlParameter.AddParameterString("jig_cause_name", inVo.JigCauseName);
}
if (!String.IsNullOrEmpty(inVo.JigResponseName))
{
sql.Append(" and jig_response_name= :jig_response_name ");
sqlParameter.AddParameterString("jig_response_name", inVo.JigResponseName);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
JigRepairInformationVo outVo = new JigRepairInformationVo
{
// , h., i., k., o.prodution_work_content_name
JigRepairId = int.Parse(dataReader["jig_repair_id"].ToString()),
JigRepairCode = dataReader["jig_repair_cd"].ToString(),
ProcessName = dataReader["process_name"].ToString(),
LineCode = dataReader["line_cd"].ToString(),
JigCauseName = dataReader["jig_cause_name"].ToString(),
JigResponseName = dataReader["jig_response_name"].ToString(),
TimeTo = DateTime.Parse(dataReader["time_to"].ToString()),
TimeFrom = DateTime.Parse(dataReader["time_from"].ToString()),
ModelName = dataReader["model_name"].ToString(),
ModelCode = dataReader["model_cd"].ToString(),
JigCurrentStatus = dataReader["jig_current_status"].ToString(),
JigAfterRepairStatus = (dataReader["jig_after_repair_status"].ToString()),
JigRepairResult = dataReader["repair_result"].ToString(),
JigPlace = dataReader["place"].ToString(),
RegistrationUserCode = dataReader["registration_user_cd"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
