public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RateNGVo inVo = (RateNGVo)vo;
StringBuilder sql = new StringBuilder();
RateNGVo voList = new RateNGVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("insert into m_rate_ng (rate_ng_cd, rate_ng_model, rate_ng_line , rate_ng_ratio) ");
sql.Append("values (:rate_ng_cd, :rate_ng_model, :rate_ng_line , :rate_ng_ratio) ");
sqlParameter.AddParameter("rate_ng_cd", inVo.RateCode);
sqlParameter.AddParameter("rate_ng_model", inVo.RateModel);
sqlParameter.AddParameter("rate_ng_line", inVo.RateLine);
sqlParameter.AddParameter("rate_ng_ratio", inVo.RateRatio);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
voList = new RateNGVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter),
};
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RateNGVo inVo = (RateNGVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RateNGVo> voList = new ValueObjectList <RateNGVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select distinct rate_ng_model from m_rate_ng where 1=1");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
//execute SQL
while (dataReader.Read())
{
RateNGVo outVo1 = new RateNGVo
{
RateModel = dataReader["rate_ng_model"].ToString(),
};
voList.add(outVo1);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RateNGVo inVo = (RateNGVo)vo;
StringBuilder sql = new StringBuilder();
RateNGVo voList = new RateNGVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from m_rate_ng where 1=1");
if (inVo.RatelId > 0)
{
sql.Append(" and rate_ng_id = :rate_ng_id");
sqlParameter.AddParameter("rate_ng_id", inVo.RatelId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
voList = new RateNGVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter),
};
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RateNGVo inVo = (RateNGVo)vo;
StringBuilder sql = new StringBuilder();
RateNGVo voList = new RateNGVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select rate_ng_id, rate_ng_model,rate_ng_line,rate_ng_cd, rate_ng_ratio from m_rate_ng where 1=1");
if (!string.IsNullOrEmpty(inVo.RateCode))
{
sql.Append(" and rate_ng_cd = :rate_ng_cd ");
sqlParameter.AddParameter("rate_ng_cd", inVo.RateCode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
DataSet ds = sqlCommandAdapter.ExecuteDataSet(sqlParameter);
//execute SQL
RateNGVo outVo1 = new RateNGVo
{
dt = ds.Tables[0],
};
return(outVo1);
}
private void Ok_btn_Click(object sender, EventArgs e)
{
if (checkdate())
{
RateNGVo outvo = new RateNGVo();
RateNGVo invo = new RateNGVo
{
RatelId = this.RatelId,
RateModel = model_cmb.Text,
RateLine = line_cmb.Text,
RateCode = RateCode_txt.Text,
RateRatio = Ratio_txt.Text
};
try
{
if (invo.RatelId > 0)
{
outvo = (RateNGVo)DefaultCbmInvoker.Invoke(new UpdateRateNGCbm(), invo);
}
else
{
outvo = (RateNGVo)DefaultCbmInvoker.Invoke(new InsertRateNGCbm(), invo);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outvo.AffectedCount > 0)
{
if (UpdateText_lbl.Text == "Add")
{
messageData = new MessageData("mmci00001", Properties.Resources.mmci00001);
popUpMessage.Information(messageData, "Notice");
ResetControlValues.ResetControlValue(this);
}
else
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002);
popUpMessage.Information(messageData, "Notice");
Close();
}
}
}
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (RateNG_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = RateNG_dgv.CurrentCell.RowIndex;
//RateNGVo vo = (RateNGVo)RateNG_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, RateNG_dgv.Rows[selectedrowindex].Cells["rate_ng_cd"].Value.ToString());
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
RateNGVo outVo = (RateNGVo)DefaultCbmInvoker.Invoke(new DeleteRateNGCbm(), new RateNGVo()
{
RatelId = int.Parse(RateNG_dgv.Rows[selectedrowindex].Cells["rate_ng_id"].Value.ToString())
});
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 bool checkdate()
{
if (RateCode_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, RankCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
RateCode_txt.Focus();
return(false);
}
if (Ratio_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, RankName_lbl.Text);
popUpMessage.Warning(messageData, Text);
Ratio_txt.Focus();
return(false);
}
RateCode_txt.Text = RateCode_txt.Text.Trim();
Ratio_txt.Text = Ratio_txt.Text.Trim();
RateNGVo outVo = new RateNGVo(), inVo = new RateNGVo {
RateCode = RateCode_txt.Text, RateModel = model_cmb.Text, RateLine = line_cmb.Text
};
try
{
outVo = (RateNGVo)DefaultCbmInvoker.Invoke(new CheckRateNGCbm(), inVo);
if (outVo.AffectedCount > 0 && RatelId == 0)
{
messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, RankCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
RateCode_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)
{
RateNGVo inVo = (RateNGVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RateNGVo> voList = new ValueObjectList <RateNGVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select rate_ng_ratio from m_rate_ng where 1=1 ");
if (!string.IsNullOrEmpty(inVo.RateModel))
{
sql.Append(@" and rate_ng_model =:rate_ng_model");
sqlParameter.AddParameterString("rate_ng_model", inVo.RateModel);
}
if (!string.IsNullOrEmpty(inVo.RateLine))
{
sql.Append(@" and rate_ng_line =:rate_ng_line");
sqlParameter.AddParameterString("rate_ng_line", inVo.RateLine);
}
if (!string.IsNullOrEmpty(inVo.RateCode))
{
sql.Append(@" and rate_ng_cd =:rate_ng_cd");
sqlParameter.AddParameterString("rate_ng_cd", inVo.RateCode);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
string a = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
RateNGVo outVo = new RateNGVo
{
RateRatio = a,
};
return(outVo);
}
private void GridBind()
{
RateNG_dgv.DataSource = null;
try
{
RateNGVo vo = new RateNGVo
{
RateCode = RateNGCode_txt.Text,
};
RateNGVo volist = (RateNGVo)DefaultCbmInvoker.Invoke(new SearchRateNGCbm(), vo);
if (volist.dt != null && volist.dt.Rows.Count > 0)
{
RateNG_dgv.DataSource = volist.dt;
RateNG_dgv.Columns["rate_ng_id"].Visible = false;
RateNG_dgv.Columns["rate_ng_cd"].HeaderText = "Rate Code";
RateNG_dgv.Columns["rate_ng_model"].HeaderText = "Model";
RateNG_dgv.Columns["rate_ng_line"].HeaderText = "Line";
RateNG_dgv.Columns["rate_ng_ratio"].HeaderText = "Ratio";
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
RateNG_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
