public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into m_detail_postion(detail_postion_cd, detail_postion_name, registration_user_cd, registration_date_time, factory_cd) ");
sql.Append("values(:detail_postion_cd,:detail_postion_name, :registration_user_cd,now(),:factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode);
sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
DetailPositionVo outVo = new DetailPositionVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void BindUpdateCavityData()
{
int selectedrowindex = Detail_Position_dgv.SelectedCells[0].RowIndex;
DetailPositionVo vo = (DetailPositionVo)Detail_Position_dgv.Rows[selectedrowindex].DataBoundItem;
AddDetailPositionForm addform = new AddDetailPositionForm();
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 vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update m_detail_postion set detail_postion_cd=:detail_postion_cd,detail_postion_name=:detail_postion_name, location_id=:location_id");
sql.Append(" where detail_postion_id =:detail_postion_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode);
sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName);
sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId);
sqlParameter.AddParameterInteger("location_id", inVo.LocationId);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
DetailPositionVo outVo = new DetailPositionVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void GridBind()
{
Detail_Position_dgv.DataSource = null;
try
{
DetailPositionVo vo = new DetailPositionVo
{
DetailPositionCode = DetailPositionCode_txt.Text,
DetailPositionName = DetailPositionName_txt.Text,
LocationCd = locationcd_cbm.Text,
};
ValueObjectList <DetailPositionVo> volist = (ValueObjectList <DetailPositionVo>)DefaultCbmInvoker.Invoke(new GetDetailPositionCbm(), vo);
if (volist.GetList() != null && volist.GetList().Count > 0)
{
Detail_Position_dgv.AutoGenerateColumns = false;
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
Detail_Position_dgv.DataSource = bindingsource;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
Detail_Position_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DetailPositionVo> voList = new ValueObjectList <DetailPositionVo>();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select dt.detail_postion_id,l.location_cd, dt.detail_postion_cd, dt.detail_postion_name, dt.registration_user_cd,dt.registration_date_time,dt.factory_cd
from m_detail_postion dt left join m_location l on dt.location_id = l.location_id
Where 1=1 ");
if (inVo.DetailPositionId > 0)
{
sql.Append(" and dt.detail_postion_id = :detail_postion_id ");
sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId);
}
if (!string.IsNullOrEmpty(inVo.DetailPositionCode))
{
sql.Append(" and dt.detail_postion_cd = :detail_postion_cd ");
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode);
}
if (!string.IsNullOrEmpty(inVo.DetailPositionName))
{
sql.Append(" and dt.detail_postion_name = :detail_postion_name ");
sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName);
}
if (!string.IsNullOrEmpty(inVo.LocationCd))
{
sql.Append(" and l.location_cd = :location_cd ");
sqlParameter.AddParameterString("location_cd", inVo.LocationCd);
}
//create command
//DbCommandAdaptor
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DetailPositionVo outVo = new DetailPositionVo
{
DetailPositionCode = dataReader["detail_postion_cd"].ToString(),
DetailPositionId = int.Parse(dataReader["detail_postion_id"].ToString()),
DetailPositionName = dataReader["detail_postion_name"].ToString(),
LocationCd = dataReader["location_cd"].ToString(),
RegistrationUserCode = dataReader["registration_user_cd"].ToString(),
RegistrationDateTime = DateTime.Parse(dataReader["registration_date_time"].ToString()),
FactoryCode = dataReader["factory_cd"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
try
{
//VARIABLE
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder query = new StringBuilder();
ValueObjectList <DetailPositionVo> listVo = new ValueObjectList <DetailPositionVo>();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
//QUERY STRING
query.Append("Select * from m_detail_postion where 1=1 ");
if (inVo.detail_postion_id > 0 || inVo != null)
{
query.Append("and detail_postion_id='").Append(inVo.detail_postion_id).Append("' ");
}
if (string.IsNullOrEmpty(inVo.detail_postion_cd))
{
query.Append("and detail_postion_cd='").Append(inVo.detail_postion_cd).Append("' ");
}
query.Append("order by detail_postion_id");
//GET SQL ADAPTER
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, query.ToString());
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
DetailPositionVo outVo = new DetailPositionVo
{
detail_postion_id = (int)datareader["detail_postion_id"],
location_id = (int)datareader["location_id"],
detail_postion_cd = datareader["detail_postion_cd"].ToString(),
detail_postion_name = datareader["detail_postion_name"].ToString(),
registration_user_cd = datareader["registration_user_cd"].ToString(),
registration_date_time = (DateTime)datareader["registration_date_time"],
factory_cd = datareader["factory_cd"].ToString()
};
listVo.add(outVo);
}
//CLEAR AND CLOSE CONNECTION
query.Clear();
datareader.Close();
base.CloseConnection(trxContext);
return(listVo);
}
catch
{
throw new NotImplementedException();
}
}
private bool checkdate()
{
if (DetailPositionCode_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, DetailPositionCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
DetailPositionCode_txt.Focus();
return(false);
}
if (DetailPositionCode_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, DetailPositionCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
DetailPositionCode_txt.Focus();
return(false);
}
if (location_cmb.Text.Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, location_lbl.Text);
popUpMessage.Warning(messageData, Text);
location_cmb.Focus();
return(false);
}
DetailPositionCode_txt.Text = DetailPositionCode_txt.Text.Trim();
DetailPositionName_txt.Text = DetailPositionName_txt.Text.Trim();
DetailPositionVo outVo = new DetailPositionVo(),
inVo = new DetailPositionVo {
DetailPositionId = vo.DetailPositionId, DetailPositionCode = DetailPositionCode_txt.Text
};
try
{
outVo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new CheckDetailPositionCbm(), inVo);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, DetailPositionCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
DetailPositionCode_txt.Focus();
return(false);
}
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return(false);
}
return(true);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from m_detail_postion Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (inVo.DetailPositionId > 0)
{
sql.Append(" and detail_postion_id = :detail_postion_id ");
sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId);
}
if (!string.IsNullOrEmpty(inVo.DetailPositionCode))
{
sql.Append(" and detail_postion_cd = :detail_postion_cd ");
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode);
}
if (!string.IsNullOrEmpty(inVo.DetailPositionName))
{
sql.Append(" and detail_postion_name = :detail_postion_name ");
sqlParameter.AddParameterString("detail_postion_name", inVo.DetailPositionName);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
DetailPositionVo outVo = new DetailPositionVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (Detail_Position_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = Detail_Position_dgv.SelectedCells[0].RowIndex;
DetailPositionVo vo = (DetailPositionVo)Detail_Position_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.DetailPositionCode);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
DetailPositionVo outVo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new DeleteDetailPositionCbm(), 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)
{
if (checkdate())
{
DetailPositionVo outvo = new DetailPositionVo();
DetailPositionVo invo = new DetailPositionVo
{
LocationId = ((LocationVo)this.location_cmb.SelectedItem).LocationId,
DetailPositionId = vo.DetailPositionId,
DetailPositionCode = DetailPositionCode_txt.Text,
DetailPositionName = DetailPositionName_txt.Text,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
if (invo.DetailPositionId > 0)
{
outvo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new UpdateDetailPositionCbm(), invo);
}
else
{
outvo = (DetailPositionVo)DefaultCbmInvoker.Invoke(new AddDetailPositionCbm(), invo);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
ValueObjectList <DetailPositionVo> voList = new ValueObjectList <DetailPositionVo>();
StringBuilder sql = new StringBuilder();
//CREATE SQL ADAPTER AND PARAMETER LIST
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select distinct detail_postion_id, detail_postion_cd, detail_postion_name from m_detail_postion where 1=1 ");
if (!string.IsNullOrEmpty(inVo.detail_postion_cd))
{
sql.Append("and detail_postion_cd='").Append(inVo.detail_postion_cd).Append("' ");
}
if (!string.IsNullOrEmpty(inVo.detail_postion_name))
{
sql.Append("and detail_postion_name='").Append(inVo.detail_postion_name).Append("' ");
}
sql.Append("order by detail_postion_id");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
sql.Clear();
//EXECUTE READER FROM COMMAND
IDataReader datareader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (datareader.Read())
{
DetailPositionVo outVo = new DetailPositionVo
{
detail_postion_id = (int)datareader["detail_postion_id"],
detail_postion_cd = datareader["detail_postion_cd"].ToString(),
detail_postion_name = datareader["detail_postion_name"].ToString()
};
voList.add(outVo);
}
datareader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DetailPositionVo inVo = (DetailPositionVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as DetailPositionCounter ");
sql.Append(" from m_detail_postion");
sql.Append(" Where 1=1 ");
if (!string.IsNullOrEmpty(inVo.DetailPositionCode))
{
sql.Append(" and UPPER(detail_postion_cd) = UPPER(:detail_postion_cd) ");
sqlParameter.AddParameterString("detail_postion_cd", inVo.DetailPositionCode);
}
if (inVo.DetailPositionId > 0)
{
sql.Append(" and detail_postion_id != :detail_postion_id "); ///?????
sqlParameter.AddParameterInteger("detail_postion_id", inVo.DetailPositionId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
DetailPositionVo outVo = new DetailPositionVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DetailPositionCounter"].ToString());
}
dataReader.Close();
return(outVo);
}
