private void BindUpdateCavityData()
{
int selectedrowindex = ProcessWDetails_dgv.SelectedCells[0].RowIndex;
ProcessWorksVo vo = (ProcessWorksVo)ProcessWDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddProcessWForm addform = new AddProcessWForm();
addform.vo = vo;
addform.ShowDialog();
if (addform.IntSuccess > 0)
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
else if (addform.IntSuccess == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorksVo inVo = (ProcessWorksVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Update m_process_work");
sqlQuery.Append(" Set ");
sqlQuery.Append(" process_work_name = :processworkname, ");
sqlQuery.Append(" process_id = :processid, ");
sqlQuery.Append(" model_id = :modelid, ");
sqlQuery.Append(" machine_id = :machineid ");
sqlQuery.Append(" Where ");
sqlQuery.Append(" process_work_id = :processworkid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
sqlParameter.AddParameterString("processworkname", inVo.ProcessWorkName);
sqlParameter.AddParameterInteger("processid", inVo.AssyID);
sqlParameter.AddParameterInteger("modelid", inVo.ModelID);
sqlParameter.AddParameterInteger("machineid", inVo.MachineID);
ProcessWorksVo outVo = new ProcessWorksVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProcessWorksVo inVo = (ProcessWorksVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <ProcessWorksVo> voList = new ValueObjectList <ProcessWorksVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select pw.process_work_id, pw.process_work_cd, pw.process_work_name, md.model_cd, pr.process_name, mc.machine_name from m_process_work pw left join m_process pr on pr.process_id = pw.process_id left join m_machine mc on mc.machine_id = pw.machine_id left join m_model md on md.model_id = pw.model_id order by pw.process_work_id");
// sqlParameter.AddParameterInteger("model_id", inVo.LineId);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
//while (dataReader.Read())
//{
// LineVo outVo = new LineVo
// {
// LineId = int.Parse(dataReader["line_id"].ToString()),
// LineCode = dataReader["line_cd"].ToString()
// };
// voList.add(outVo);
//}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorksVo inVo = (ProcessWorksVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_process_work");
sqlQuery.Append(" ( ");
sqlQuery.Append(" process_work_cd, ");
sqlQuery.Append(" process_work_name, ");
sqlQuery.Append(" process_id, ");
sqlQuery.Append(" is_phantom,");
sqlQuery.Append(" model_id ,");
sqlQuery.Append(" machine_id ,");
sqlQuery.Append(" registration_user_cd, ");
sqlQuery.Append(" registration_date_time, ");
sqlQuery.Append(" factory_cd ");
sqlQuery.Append(" ) ");
sqlQuery.Append("VALUES ");
sqlQuery.Append(" ( ");
sqlQuery.Append(" :processworkcd ,");
sqlQuery.Append(" :processworkname ,");
sqlQuery.Append(" :processid ,");
sqlQuery.Append(" :isphantom ,");
sqlQuery.Append(" :modelid ,");
sqlQuery.Append(" :machineid ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" now() ,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("processworkcd", inVo.ProcessWorkCode);
sqlParameter.AddParameterString("processworkname", inVo.ProcessWorkName);
sqlParameter.AddParameterInteger("processid", inVo.AssyID);
sqlParameter.AddParameterString("isphantom", inVo.IsPhantom);
sqlParameter.AddParameterInteger("modelid", inVo.ModelID);
sqlParameter.AddParameterInteger("machineid", inVo.MachineID);
sqlParameter.AddParameterString("registrationusercode", inVo.RegistrationUserCode);
//sqlParameter.AddParameterDateTime("registrationdatetime", inVo.RegistrationDateTime);
sqlParameter.AddParameterString("factorycode", inVo.FactoryCode);
ProcessWorksVo outVo = new ProcessWorksVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorksVo inVo = (ProcessWorksVo)arg;
StringBuilder sqlQuery = new StringBuilder();
ValueObjectList <ProcessWorksVo> voList = new ValueObjectList <ProcessWorksVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlQuery.Append("Select pw.process_work_id, pw.process_work_cd, pw.process_work_name, md.model_cd, pr.process_name, mc.machine_name from m_process_work pw left join m_process pr on pr.process_id = pw.process_id left join m_machine mc on mc.machine_id = pw.machine_id left join m_model md on md.model_id = pw.model_id where 1 = 1");
if (!String.IsNullOrEmpty(inVo.ProcessWorkCode))
{
sqlQuery.Append(" and pw.process_work_cd like :processworkcd ");
sqlParameter.AddParameterString("processworkcd", "%" + inVo.ProcessWorkCode + "%");
}
if (!String.IsNullOrEmpty(inVo.ProcessWorkName))
{
sqlQuery.Append(" and pw.process_work_name like :processworkname ");
sqlParameter.AddParameterString("processworkname", "%" + inVo.ProcessWorkName + "%");
}
if (inVo.MachineID != 0)
{
sqlQuery.Append(" and mc.machine_id = :machine_id ");
sqlParameter.AddParameterInteger("machine_id", inVo.MachineID);
}
sqlQuery.Append(" order by pw.process_work_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
ProcessWorksVo OutVo = new ProcessWorksVo();
{
OutVo.ProcessWorkId = ConvertDBNull <int>(dataReader, "process_work_id");
OutVo.ProcessWorkCode = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["process_work_cd"]);
OutVo.ProcessWorkName = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["process_work_name"]);
OutVo.Assy = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["process_name"]);
OutVo.Model = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["model_cd"]);
OutVo.Machine = DBDataCheckHelper.ConvertDBNullToStringNull(dataReader["machine_name"]);
}
voList.add(OutVo);
}
dataReader.Close();
return(voList);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (ProcessWDetails_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = ProcessWDetails_dgv.SelectedCells[0].RowIndex;
ProcessWorksVo vo = (ProcessWorksVo)ProcessWDetails_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.ProcessWorkCode);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
ProcessWorksVo outVo = (ProcessWorksVo)DefaultCbmInvoker.Invoke(new DeleteProcessWorkCbm(), vo);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmci00003", Properties.Resources.mmci00003, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
else if (outVo.AffectedCount == 0)
{
messageData = new MessageData("mmci00007", Properties.Resources.mmci00007, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind();
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
}
}
private void Ok_btn_Click(object sender, EventArgs e)
{
ProcessWorksVo outvo = new ProcessWorksVo();
ProcessWorksVo invo = new ProcessWorksVo
{
ProcessWorkId = vo.ProcessWorkId,
ProcessWorkCode = ProcessCode_txt.Text,
ProcessWorkName = ProcessName_txt.Text,
ModelID = ((ModelVo)Model_cmb.SelectedItem).ModelId,
AssyID = ((ProcessVo)Assy_cmb.SelectedItem).ProcessId,
MachineID = ((MachineVo)Machine_cmb.SelectedItem).MachineId,
IsPhantom = "0",
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
if (invo.ProcessWorkId > 0)
{
outvo = (ProcessWorksVo)DefaultCbmInvoker.Invoke(new UpdateProcessWorkCbm(), invo);
}
else
{
outvo = (ProcessWorksVo)DefaultCbmInvoker.Invoke(new AddProcessWorkCbm(), invo);
}
}
catch (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 arg)
{
ProcessWorksVo inVo = (ProcessWorksVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as WorkCount from m_process_work");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.ProcessWorkCode != null)
{
sqlQuery.Append(" and process_work_cd = :processworkcd");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.ProcessWorkCode != null)
{
sqlParameter.AddParameterString("processworkcd", inVo.ProcessWorkCode);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessWorksVo outVo = new ProcessWorksVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["WorkCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorksVo inVo = (ProcessWorksVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete From m_process_work");
sqlQuery.Append(" Where ");
sqlQuery.Append(" process_work_id = :processworkid ;");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
ProcessWorksVo outVo = new ProcessWorksVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
