public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct model from t_ovenmachine order by model ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
RangeVo outVo = new RangeVo
{
Model = dataReader["model"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select count(*) count_process from m_ovenmachinels12_range where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and range_model = :range_model ");
sqlParameter.AddParameterString("range_model", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Process))
{
sql.Append(@" and range_process = :range_process ");
sqlParameter.AddParameterString("range_process", inVo.Process);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
RangeVo outVo = new RangeVo();
outVo.Count = int.Parse(sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString());
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from m_ovenmachine_range Where 1=1 ");
if (inVo.RangeId > 0)
{
sql.Append(" and ovenmachine_range_id = :ovenmachine_range_id ");
sqlParameter.AddParameterInteger("ovenmachine_range_id", inVo.RangeId);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
RangeVo outVo = new RangeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void BindUpdateCavityData()
{
int selectedrowindex = RangeOven_dgv.SelectedCells[0].RowIndex;
RangeVo vo = (RangeVo)RangeOven_dgv.Rows[selectedrowindex].DataBoundItem;
AddRangeLS12Form addform = new AddRangeLS12Form();
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)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append(@"update m_ovenmachine_range set range_lower=:range_lower,range_upper=:range_upper,registration_user_cd=:registration_user_cd,registration_date_time = now()");
sql.Append(" where range_model=:range_model and range_line=:range_line and range_barcode=:range_barcode ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameter("ovenmachine_range_id", inVo.RangeId);
sqlParameter.AddParameterString("range_model", inVo.Model);
sqlParameter.AddParameterString("range_line", inVo.Line);
sqlParameter.AddParameterString("range_barcode", inVo.Barcode);
sqlParameter.AddParameterString("range_lower", inVo.Lower);
sqlParameter.AddParameterString("range_upper", inVo.Upper);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUser);
//execute SQL
RangeVo outVo = new RangeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void GridBind()
{
RangeOven_dgv.DataSource = null;
try
{
RangeVo vo = new RangeVo
{
Model = range_model_cbm.Text,
Process = range_process_cbm.Text
};
ValueObjectList <RangeVo> volist = (ValueObjectList <RangeVo>)DefaultCbmInvoker.Invoke(new SearchRangeLS12Cbm(), vo);
if (volist.GetList() != null && volist.GetList().Count > 0)
{
RangeOven_dgv.AutoGenerateColumns = false;
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
RangeOven_dgv.DataSource = bindingsource;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
RangeOven_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)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into m_ovenmachinels12_range(range_model,range_process,range_lower,range_upper, registration_user_cd, registration_date_time) ");
sql.Append("values(:range_model,:range_process,:range_lower,:range_upper, :registration_user_cd, now())");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("range_model", inVo.Model);
sqlParameter.AddParameterString("range_process", inVo.Process);
sqlParameter.AddParameterString("range_lower", inVo.Lower);
sqlParameter.AddParameterString("range_upper", inVo.Upper);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUser);
//execute SQL
RangeVo outVo = new RangeVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select * from m_ovenmachine_range where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and range_model = :range_model ");
sqlParameter.AddParameterString("range_model", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Line))
{
sql.Append(@" and range_line = :range_line ");
sqlParameter.AddParameterString("range_line", inVo.Line);
}
sql.Append(" order by range_model,range_line,range_barcode ");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
RangeVo outVo = new RangeVo
{
RangeId = int.Parse(dataReader["ovenmachine_range_id"].ToString()),
Model = dataReader["range_model"].ToString(),
Line = dataReader["range_line"].ToString(),
Barcode = dataReader["range_barcode"].ToString(),
Lower = dataReader["range_lower"].ToString(),
Upper = dataReader["range_upper"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
RangeVo inVo = (RangeVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <RangeVo> voList = new ValueObjectList <RangeVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select distinct barcode from t_ovenmachine where 1=1 ");
if (!String.IsNullOrEmpty(inVo.Model))
{
sql.Append(@" and model = :model ");
sqlParameter.AddParameterString("model", inVo.Model);
}
if (!String.IsNullOrEmpty(inVo.Line))
{
sql.Append(@" and line_cd = :line_cd ");
sqlParameter.AddParameterString("line_cd", inVo.Line);
}
sql.Append(" order by barcode");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
RangeVo outVo = new RangeVo
{
Barcode = dataReader["barcode"].ToString(),
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (RangeOven_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = RangeOven_dgv.SelectedCells[0].RowIndex;
RangeVo vo = (RangeVo)RangeOven_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.Model + " and process = " + vo.Process);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
RangeVo outVo = (RangeVo)DefaultCbmInvoker.Invoke(new DeleteRangeCbm(), 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())
{
int fail = 0;
int a = vo.RangeId;
RangeVo outvo = new RangeVo();
try
{
if (vo.RangeId > 0)
{
outvo = (RangeVo)DefaultCbmInvoker.Invoke(new UpdateRangeLS12Cbm(), new RangeVo
{
RangeId = vo.RangeId,
Model = model_cbm.Text,
Line = process_cbm.Text,
Lower = lower_txt.Text,
Upper = upper_txt.Text,
RegistrationUser = UserData.GetUserData().UserCode
});
IntSuccess = outvo.AffectedCount;
}
else
{
int countDem = 0;
RangeVo checkBarcode = (RangeVo)DefaultCbmInvoker.Invoke(new CheckBarcodeRangeLS12Cbm(), new RangeVo()
{
Model = model_cbm.Text,
Process = process_cbm.Text,
});
countDem = countDem + 1;
if (checkBarcode.Count == 0)//kiểm tra barcode có trùng trong database
{
outvo = (RangeVo)DefaultCbmInvoker.Invoke(new AddRangeLS12Cbm(), new RangeVo
{
RangeId = vo.RangeId,
Model = model_cbm.Text,
Process = process_cbm.Text,
Lower = lower_txt.Text,
Upper = upper_txt.Text,
RegistrationUser = UserData.GetUserData().UserCode
});
IntSuccess = outvo.AffectedCount;
}
else
{
messageData = new MessageData("mmcc00005", "Process have set temperature", "Warning");
popUpMessage.ApplicationError(messageData, Text);
}
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
if (fail > 0)
{
}
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
private void Ok_btn_Click(object sender, EventArgs e)
{
if (checkdate())
{
int fail = 0;
int a = vo.RangeId;
RangeVo outvo = new RangeVo();
try
{
int countCheckTrue = 0;
foreach (TreeNode aNode in Barcode_tv.Nodes)
{
if (aNode.Checked == true)
{
countCheckTrue = countCheckTrue + 1;
}
}
if (vo.RangeId > 0)
{
foreach (TreeNode aNode in Barcode_tv.Nodes)
{
if (aNode.Checked == true)
{
outvo = (RangeVo)DefaultCbmInvoker.Invoke(new UpdateRangeCbm(), new RangeVo
{
//RangeId = vo.RangeId,
Model = model_cbm.Text,
Barcode = aNode.Text,
Line = line_cbm.Text,
Lower = lower_txt.Text,
Upper = upper_txt.Text,
RegistrationUser = UserData.GetUserData().UserCode
});
IntSuccess = outvo.AffectedCount;
}
}
}
else
{
int countDem = 0;
string duplicate_barcode = "";
foreach (TreeNode aNode in Barcode_tv.Nodes)
{
RangeVo checkBarcode = (RangeVo)DefaultCbmInvoker.Invoke(new CheckBarcodeRangeCbm(), new RangeVo()
{
Model = model_cbm.Text,
Barcode = aNode.Text,
Line = line_cbm.Text,
});
if (aNode.Checked == true)
{
countDem = countDem + 1;
if (checkBarcode.Count == 0)//kiểm tra barcode có trùng trong database
{
outvo = (RangeVo)DefaultCbmInvoker.Invoke(new AddRangeCbm(), new RangeVo
{
RangeId = vo.RangeId,
Model = model_cbm.Text,
Barcode = aNode.Text,
Line = line_cbm.Text,
Lower = lower_txt.Text,
Upper = upper_txt.Text,
RegistrationUser = UserData.GetUserData().UserCode
});
IntSuccess = outvo.AffectedCount;
}
else
{
duplicate_barcode = duplicate_barcode + aNode.Text.Trim() + " & ";
if (countDem == countCheckTrue)
{
messageData = new MessageData("mmcc00005", "Duplicate key Barcode: " + duplicate_barcode.Substring(0, duplicate_barcode.Length - 2), barcode_lbl.Text);
popUpMessage.Warning(messageData, Text);
Barcode_tv.Focus();
fail = fail + 1;
//return;
}
}
}
}
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if ((IntSuccess > 0) || (IntSuccess == 0))
{
if (fail > 0)
{
}
this.DialogResult = DialogResult.OK;
this.Close();
}
}
}
