/// <summary>
/// selects user record for updation and show user form
/// </summary>
private void UpdateWorkContentType()
{
int selectedrowindex = ProdutionWorkContentType_dgv.SelectedCells[0].RowIndex;
ProdutionWorkContentTypeVo vo = (ProdutionWorkContentTypeVo)ProdutionWorkContentType_dgv.Rows[selectedrowindex].DataBoundItem;
AddProdutionWorkContentTypeForm addform = new AddProdutionWorkContentTypeForm();
addform.vo = vo;
if (addform.ShowDialog() == DialogResult.OK)
{
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)
{
ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("Update m_prodution_work_content_type_master set prodution_work_content_type_cd=:prodution_work_content_type_cd,prodution_work_content_type_name=:prodution_work_content_type_name");
sql.Append(" where prodution_work_content_type_id=:prodution_work_content_type_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode);
sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName);
sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <ProdutionWorkContentTypeVo> voList = new ValueObjectList <ProdutionWorkContentTypeVo>();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select prodution_work_content_type_id,prodution_work_content_type_cd,prodution_work_content_type_name,registration_user_cd,registration_date_time,factory_cd from m_prodution_work_content_type_master");
sql.Append(" Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (inVo.ProdutionWorkContentTypeId > 0)
{
sql.Append(" and prodution_work_content_type_id = :prodution_work_content_type_id ");
sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId);
}
if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeCode))
{
sql.Append(" and prodution_work_content_type_cd = :prodution_work_content_type_cd ");
sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode);
}
if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeName))
{
sql.Append(" and prodution_work_content_type_name = :prodution_work_content_type_name ");
sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName);
}
//create command
//DbCommandAdaptor
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo
{
ProdutionWorkContentTypeCode = dataReader["prodution_work_content_type_cd"].ToString(),
ProdutionWorkContentTypeId = int.Parse(dataReader["prodution_work_content_type_id"].ToString()),
ProdutionWorkContentTypeName = dataReader["prodution_work_content_type_name"].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);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (ProdutionWorkContentType_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = ProdutionWorkContentType_dgv.SelectedCells[0].RowIndex;
ProdutionWorkContentTypeVo vo = (ProdutionWorkContentTypeVo)ProdutionWorkContentType_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.ProdutionWorkContentTypeCode);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
ProdutionWorkContentTypeVo outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new DeleteProdutionWorkContentTypeCbm(), vo, false);
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());
}
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from m_prodution_work_content_type_master Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (inVo.ProdutionWorkContentTypeId > 0)
{
sql.Append(" and prodution_work_content_type_id = :prodution_work_content_type_id ");
sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId);
}
if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeCode))
{
sql.Append(" and prodution_work_content_type_cd = :prodution_work_content_type_cd ");
sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode);
}
if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeName))
{
sql.Append(" and prodution_work_content_type_name = :prodution_work_content_type_name ");
sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private bool CheckDate()
{
if (ProdutionWorkContentTypeCode_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, ProdutionWorkContentTypeCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
ProdutionWorkContentTypeCode_txt.Focus();
return(false);
}
if (ProdutionWorkContentTypeName_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, ProdutionWorkContentTypeName_lbl.Text);
popUpMessage.Warning(messageData, Text);
ProdutionWorkContentTypeName_txt.Focus();
return(false);
}
ProdutionWorkContentTypeCode_txt.Text = ProdutionWorkContentTypeCode_txt.Text.Trim();
ProdutionWorkContentTypeName_txt.Text = ProdutionWorkContentTypeName_txt.Text.Trim();
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo(),
inVo = new ProdutionWorkContentTypeVo {
ProdutionWorkContentTypeId = vo.ProdutionWorkContentTypeId, ProdutionWorkContentTypeCode = ProdutionWorkContentTypeCode_txt.Text
};
try
{
outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new CheckProdutionWorkContentTypeCbm(), inVo, false);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, ProdutionWorkContentTypeCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
ProdutionWorkContentTypeCode_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)
{
ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as CountNum ");
sql.Append(" from m_work_content_type");
sql.Append(" Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (!string.IsNullOrEmpty(inVo.ProdutionWorkContentTypeCode))
{
sql.Append(" and UPPER(work_content_type_cd) = UPPER(:prodution_work_content_type_cd) ");
sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode);
}
if (inVo.ProdutionWorkContentTypeId > 0)
{
sql.Append(" and work_content_type_id != :prodution_work_content_type_id ");
sqlParameter.AddParameterInteger("prodution_work_content_type_id", inVo.ProdutionWorkContentTypeId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["CountNum"].ToString());
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
ProdutionWorkContentTypeVo inVo = (ProdutionWorkContentTypeVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(" insert into ");
sql.Append(" m_work_content_type( ");
sql.Append(" work_content_type_cd, ");
sql.Append(" work_content_type_name, ");
sql.Append(" registration_user_cd, ");
sql.Append(" registration_date_time, ");
sql.Append(" factory_cd) ");
sql.Append(" values( ");
sql.Append(" :prodution_work_content_type_cd, ");
sql.Append(" :prodution_work_content_type_name, ");
sql.Append(" :registration_user_cd, ");
sql.Append(" :registrationdatetime, ");
sql.Append(" :factorycd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("prodution_work_content_type_cd", inVo.ProdutionWorkContentTypeCode);
sqlParameter.AddParameterString("prodution_work_content_type_name", inVo.ProdutionWorkContentTypeName);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("registration_user_cd", UserData.GetUserData().UserCode);
sqlParameter.AddParameterString("factorycd", UserData.GetUserData().FactoryCode);
//execute SQL
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Ok_btn_Click(object sender, EventArgs e)
{
if (CheckDate())
{
ProdutionWorkContentTypeVo outVo = new ProdutionWorkContentTypeVo();
ProdutionWorkContentTypeVo inVo = new ProdutionWorkContentTypeVo
{
ProdutionWorkContentTypeId = vo.ProdutionWorkContentTypeId,
ProdutionWorkContentTypeCode = ProdutionWorkContentTypeCode_txt.Text,
ProdutionWorkContentTypeName = ProdutionWorkContentTypeName_txt.Text,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
if (inVo.ProdutionWorkContentTypeId > 0)
{
outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new UpdateProdutionWorkContentTypeCbm(), inVo, false);
}
else
{
outVo = (ProdutionWorkContentTypeVo)base.InvokeCbm(new AddProdutionWorkContentTypeCbm(), inVo, false);
}
IntSuccess = outVo.AffectedCount;
}
catch (Com.Nidec.Mes.Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
