private void LoadProcessWork(int pMachineId)
{
ProcessWorkVo outVo = null;
try
{
outVo = (ProcessWorkVo)DefaultCbmInvoker.Invoke(new GetProcessWorkMasterMntCbm(), new ProcessWorkVo());
outVo.ProcessWorkListVo.ForEach(t => t.ProcessWorkName = string.Concat(t.ProcessWorkCode + " ", t.ProcessWorkName));
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
ProcessWorkMachineVo processMachineLineInVo = new ProcessWorkMachineVo();
processMachineLineInVo.MachineId = pMachineId;
ProcessWorkMachineVo processWorkMachineOutVo = (ProcessWorkMachineVo)DefaultCbmInvoker.Invoke(new GetProcessWorkMachineMasterMntCbm(), processMachineLineInVo);
if (processWorkMachineOutVo != null && pMachineId > 0)
{
foreach (ProcessWorkVo item in outVo.ProcessWorkListVo)
{
item.IsExists = processWorkMachineOutVo.ProcessWorkMachineListVo.Exists(t => t.ProcessWorkId == item.ProcessWorkId) ? "True" : "False";
}
}
BindingSource bindingSource = new BindingSource(outVo.ProcessWorkListVo, null);
ProcessWork_dgv.AutoGenerateColumns = false;
ProcessWork_dgv.DataSource = bindingSource;
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
MachineVo machineInVo = (MachineVo)inList.FirstOrDefault();
ProcessWorkMachineVo processWorkMachineInVo = (ProcessWorkMachineVo)inList.Skip(1).FirstOrDefault();
MachineVo machineOutVo = (MachineVo)updateMachineMasterMntCbm.Execute(trxContext, machineInVo);
if (machineOutVo.AffectedCount > 0)
{
ProcessWorkMachineVo deleteInVo = new ProcessWorkMachineVo();
deleteInVo.MachineId = machineInVo.MachineId;
ProcessWorkMachineVo deleteOutVo = (ProcessWorkMachineVo)deleteProcessWorkMachineMasterMntCbm.Execute(trxContext, deleteInVo);
foreach (ProcessWorkMachineVo curInVo in processWorkMachineInVo.ProcessWorkMachineListVo)
{
curInVo.MachineId = machineInVo.MachineId;
ProcessWorkMachineVo processWorkLineOutVo = (ProcessWorkMachineVo)addProcessWorkMachineMasterMntCbm.Execute(trxContext, curInVo);
}
}
return(machineOutVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
List <ValueObject> inList = ((ValueObjectList <ValueObject>)vo).GetList();
MachineVo machineInVo = (MachineVo)inList.FirstOrDefault();
ProcessWorkMachineVo processWorkMachineInVo = (ProcessWorkMachineVo)inList.Skip(1).FirstOrDefault();
MachineVo machineOutVo = (MachineVo)addMachineMasterMntCbm.Execute(trxContext, machineInVo);
int count = 0;
if (machineOutVo != null && machineOutVo.MachineId > 0)
{
count += 1;
foreach (ProcessWorkMachineVo curInVo in processWorkMachineInVo.ProcessWorkMachineListVo)
{
curInVo.MachineId = machineOutVo.MachineId;
ProcessWorkMachineVo processWorkMachineOutVo = (ProcessWorkMachineVo)addProcessWorkMachineMasterMntCbm.Execute(trxContext, curInVo);
}
}
machineOutVo.AffectedCount = count;
return(machineOutVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select pwm.process_work_id, pwm.machine_id,ls.machine_name");
sqlQuery.Append(" from m_processwork_machine pwm ");
sqlQuery.Append(" inner join m_machine ls on ls.machine_id = pwm.machine_id ");
sqlQuery.Append(" where 1 = 1 ");
if (inVo.ProcessWorkId > 0)
{
sqlQuery.Append(" and pwm.process_work_id = :processworkid ");
}
if (inVo.MachineName != null)
{
sqlQuery.Append(" and machine_name like :machinename ");
}
sqlQuery.Append(" order by machine_name ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
if (inVo.ProcessWorkId > 0)
{
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
}
if (inVo.MachineName != null)
{
sqlParameter.AddParameterString("machinename", inVo.MachineName + "%");
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo();
while (dataReader.Read())
{
ProcessWorkMachineVo currOutVo = new ProcessWorkMachineVo
{
MachineId = Convert.ToInt32(dataReader["machine_id"]),
MachineName = dataReader["machine_name"].ToString(),
};
outVo.ProcessWorkMachineListVo.Add(currOutVo);
}
dataReader.Close();
return(outVo);
}
public ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
MachineVo deleteMachineOutVo = (MachineVo)deleteMachineMasterMntCbm.Execute(trxContext, vo);
if (deleteMachineOutVo.AffectedCount > 0)
{
ProcessWorkMachineVo inVo = new ProcessWorkMachineVo();
inVo.MachineId = ((MachineVo)vo).MachineId;
ProcessWorkMachineVo deleteProcessWorkMachineOutVo = (ProcessWorkMachineVo)deleteProcessWorkMachineMasterMntCbm.Execute(trxContext, inVo);
}
return(deleteMachineOutVo);
}
/// <summary>
/// checks duplicate Process Code
/// </summary>
/// <param name="processVo"></param>
/// <returns></returns>
private ProcessWorkMachineVo DuplicateCheck(ProcessWorkMachineVo pwmachineVo)
{
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo();
try
{
outVo = (ProcessWorkMachineVo)base.InvokeCbm(new CheckProcessWorkMachineMasterMntCbm(), pwmachineVo, false);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
return(outVo);
}
private void ProcessWork_lst_SelectedIndexChanged(object sender, EventArgs e)
{
if (isProcessListLoading)
{
return;
}
if (ProcessWork_lst.SelectedIndex < 0)
{
return;
}
if (Machine_chlst.Items.Count == 0)
{
LoadMachineListBox();
}
this.Cursor = Cursors.WaitCursor;
ProcessWorkMachineVo inVo = new ProcessWorkMachineVo();
//inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedIndex);
inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedValue.ToString());
ProcessWorkMachineVo checkVo = (ProcessWorkMachineVo)base.InvokeCbm(new GetProcessWorkMachineMasterMntCbm(), new ProcessWorkMachineVo(), false);
Machine_chlst.ClearSelected();
//for (int i = 0; i < Machine_chlst.Items.Count - 1; i++)
//{
// var machine = (MachineVo)Machine_chlst.Items[i];
// if (checkVo.ProcessWorkMachineListVo.Exists(x => x.MachineId == machine.MachineId))
// {
// Machine_chlst.SetItemCheckState(i, CheckState.Indeterminate);
// }
//}
ProcessWorkMachineVo outVo = (ProcessWorkMachineVo)base.InvokeCbm(new GetProcessWorkMachineMasterMntCbm(), inVo, false);
for (int i = 0; i < Machine_chlst.Items.Count; i++)
{
var machine = (MachineVo)Machine_chlst.Items[i];
Machine_chlst.SetItemChecked(i, outVo.ProcessWorkMachineListVo.Exists(x => x.MachineId == machine.MachineId));
}
this.Cursor = Cursors.Default;
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Delete from m_processwork_machine");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.ProcessWorkId > 0)
{
sqlQuery.Append(" AND process_work_id = :processworkid");
}
if (inVo.MachineId > 0)
{
sqlQuery.Append(" AND machine_id = :machineid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.ProcessWorkId > 0)
{
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
}
if (inVo.MachineId > 0)
{
sqlParameter.AddParameterInteger("machineid", inVo.MachineId);
}
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Select Count(*) as WorkCount from m_processwork_machine");
sqlQuery.Append(" where factory_cd = :faccd ");
if (inVo.MachineId >= 0)
{
sqlQuery.Append(" and machine_id = :machineid");
}
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("faccd", UserData.GetUserData().FactoryCode);
if (inVo.MachineId >= 0)
{
sqlParameter.AddParameterInteger("machineid", inVo.MachineId);
}
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["WorkCount"]);
}
dataReader.Close();
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject arg)
{
ProcessWorkMachineVo inVo = (ProcessWorkMachineVo)arg;
StringBuilder sqlQuery = new StringBuilder();
sqlQuery.Append("Insert into m_processwork_machine");
sqlQuery.Append(" ( ");
sqlQuery.Append(" process_work_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(" :processworkid ,");
sqlQuery.Append(" :machineid ,");
sqlQuery.Append(" :registrationusercode ,");
sqlQuery.Append(" :registrationdatetime,");
sqlQuery.Append(" :factorycode ");
sqlQuery.Append(" ); ");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sqlQuery.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("machineid", inVo.MachineId);
sqlParameter.AddParameterInteger("processworkid", inVo.ProcessWorkId);
sqlParameter.AddParameterString("registrationusercode", UserData.GetUserData().UserCode);
sqlParameter.AddParameterDateTime("registrationdatetime", trxContext.ProcessingDBDateTime);
sqlParameter.AddParameterString("factorycode", UserData.GetUserData().FactoryCode);
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo {
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private ProcessWorkMachineVo GetSelectedProcessWork()
{
BindingSource bsProcessWork = (BindingSource)ProcessWork_dgv.DataSource;
ProcessWorkMachineVo processWorkMachineInVo = new ProcessWorkMachineVo();
if (bsProcessWork != null && bsProcessWork.List.Count > 0)
{
foreach (ProcessWorkVo processWorkVo in bsProcessWork.List)
{
if (processWorkVo.IsExists == "True")
{
ProcessWorkMachineVo addVo = new ProcessWorkMachineVo()
{
ProcessWorkId = processWorkVo.ProcessWorkId
};
processWorkMachineInVo.ProcessWorkMachineListVo.Add(addVo);
}
}
}
return(processWorkMachineInVo);
}
/// <summary>
/// inserts/updates process on ok click
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Ok_btn_Click(object sender, EventArgs e)
{
try
{
if (CheckMandatory())
{
ProcessWorkMachineVo inVo = new ProcessWorkMachineVo();
inVo.ProcessWorkId = Convert.ToInt32(ProcessWork_lst.SelectedValue);
ProcessWorkMachineVo outDeleteCheckVo = (ProcessWorkMachineVo)base.InvokeCbm(new GetProcessWorkMachineMasterMntCbm(), inVo, false);
if (outDeleteCheckVo.ProcessWorkMachineListVo.Count > 0)
{
ProcessWorkMachineVo outDeleteVo = (ProcessWorkMachineVo)base.InvokeCbm(new DeleteProcessWorkMachineMasterMntCbm(), inVo, false);
IntDelSuccess = outDeleteVo.AffectedCount;
}
ProcessWorkMachineVo outVo = new ProcessWorkMachineVo();
inVo.FactoryCode = UserData.GetUserData().FactoryCode;
inVo.RegistrationUserCode = UserData.GetUserData().UserCode;
foreach (var item in Machine_chlst.CheckedItems)
{
var machine = (MachineVo)item;
inVo.MachineId = machine.MachineId;
if (Properties.Settings.Default.MACHINE_PER_PROCESSWORK_CONSTRAINT)
{
ProcessWorkMachineVo checkVo = DuplicateCheck(inVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, Machine_lbl.Text + " : " + Machine_chlst.Text);
logger.Info(messageData);
popUpMessage.ApplicationError(messageData, Text);
return;
}
}
outVo = (ProcessWorkMachineVo)base.InvokeCbm(new AddProcessWorkMachineMasterMntCbm(), inVo, false);
}
IntSuccess = outVo.AffectedCount;
if ((IntSuccess > 0) || (IntDelSuccess > 0))
{
messageData = new MessageData("mmci00002", Properties.Resources.mmci00002, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
private void Save_btn_Click(object sender, EventArgs e)
{
if (Machine_dgv.RowCount > 0 && Machine_dgv.Columns["colRemarks"].Visible == true)
{
if (processWorkList.Count == 0)
{
GetProcessWork();
}
this.StartProgress(Properties.Resources.mmci00009);
string previousMachineCode = string.Empty;
int uploadedCount = 0;
int insertedCount = 0;
MachineVo machineVo = new MachineVo();
ProcessWorkMachineVo processWorkMachineVo = new ProcessWorkMachineVo();
foreach (DataRow row in excelUploadDt.Rows)
{
if (!string.IsNullOrEmpty(row["MachineCode"].ToString()) && previousMachineCode != row["MachineCode"].ToString())
{
machineVo = new MachineVo();
processWorkMachineVo = new ProcessWorkMachineVo();
machineVo.MachineCode = row["MachineCode"].ToString();
machineVo.MachineName = row["MachineName"].ToString();
uploadedCount += 1;
DataRow[] processWorkCodeList = excelUploadDt.Select("MachineCode = '" + machineVo.MachineCode + "'");
foreach (DataRow item in processWorkCodeList)
{
ProcessWorkMachineVo addVo = new ProcessWorkMachineVo();
if (processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault() != null)
{
addVo.ProcessWorkId = processWorkList.Where(t => t.ProcessWorkCode == item["ProcessWorkCode"].ToString()).FirstOrDefault().ProcessWorkId;
processWorkMachineVo.ProcessWorkMachineListVo.Add(addVo);
}
}
ValueObjectList <ValueObject> inVoList = new ValueObjectList <ValueObject>();
inVoList.add(machineVo);
inVoList.add(processWorkMachineVo);
MachineVo outVo = null;
try
{
outVo = (MachineVo)base.InvokeCbm(new AddMachineMasterAndProcessworkCbm(), inVoList, false);
}
catch (Framework.ApplicationException exception)
{
this.CompleteProgress();
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
if (outVo != null && outVo.AffectedCount > 0)
{
insertedCount += outVo.AffectedCount;
}
}
previousMachineCode = row["MachineCode"].ToString();
}
this.CompleteProgress();
if (insertedCount > 0 && uploadedCount > 0 && insertedCount == uploadedCount)
{
messageData = new MessageData("mmci00010", Properties.Resources.mmci00010, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
GridBind(FormConditionVo());
}
}
else
{
messageData = new MessageData("mmci00016", Properties.Resources.mmci00016, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
private void Upload_btn_Click(object sender, EventArgs e)
{
OpenFileDialog openDialog_dlg = new OpenFileDialog();
openDialog_dlg.Filter = "Excel Files(*.xls) |*.xls";
if (openDialog_dlg.ShowDialog() == DialogResult.OK)
{
this.StartProgress(Properties.Resources.mmci00009);
try
{
excelUploadDt = new ExcelUpload().ReadExcel(openDialog_dlg.FileName, Properties.Settings.Default.EXCEL_SHEET_MACHINE_MASTER);
}
catch (Framework.ApplicationException exception)
{
this.CompleteProgress();
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
MachineVo machineVo = new MachineVo();
ProcessWorkMachineVo processWorkMachineVo = new ProcessWorkMachineVo();
Machine_dgv.DataSource = null;
excelUploadDt.Columns.Add("Remarks");
var sch = StringCheckHelper.GetInstance();
bool inputDataNG = false;
foreach (DataRow row in excelUploadDt.Rows)
{
if (row["MachineCode"] == null || string.IsNullOrWhiteSpace(row["MachineCode"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmce00011, MachineCode_lbl.Text);
inputDataNG = true;
continue;
}
if (!sch.IsASCII(row["MachineCode"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmci00017, MachineCode_lbl.Text);
inputDataNG = true;
continue;
}
if (row["MachineName"] == null || string.IsNullOrWhiteSpace(row["MachineName"].ToString()))
{
row["Remarks"] = string.Format(Properties.Resources.mmce00011, MachineName_lbl.Text);
inputDataNG = true;
continue;
}
var duplicates = excelUploadDt.AsEnumerable().GroupBy(r => r["MachineCode"]).Where(gr => gr.Count() > 1).ToList();
if (duplicates.Any() && duplicates.Select(dupl => dupl.Key).ToList().FirstOrDefault().ToString() == row["MachineCode"].ToString())
{
row["Remarks"] = string.Format(Properties.Resources.mmce00009, MachineCode_lbl.Text + " : " + row["MachineCode"].ToString());
inputDataNG = true;
continue;
}
machineVo = new MachineVo();
processWorkMachineVo = new ProcessWorkMachineVo();
machineVo.MachineCode = row["MachineCode"].ToString();
machineVo.MachineName = row["MachineName"].ToString();
if (!ValidateProcessWorkCodeInExcel(excelUploadDt, machineVo.MachineCode))
{
row["Remarks"] = string.Format(Properties.Resources.mmci00019);
inputDataNG = true;
continue;
}
MachineVo checkVo = DuplicateCheck(machineVo);
if (checkVo != null && checkVo.AffectedCount > 0)
{
row["Remarks"] = string.Format(Properties.Resources.mmce00012, MachineCode_lbl.Text + " : " + machineVo.MachineCode);
inputDataNG = true;
continue;
}
}
Machine_dgv.AutoGenerateColumns = false;
isExcelUpload = true;
Machine_dgv.Columns["colRemarks"].Visible = true;
Machine_dgv.DataSource = excelUploadDt;
if (inputDataNG)
{
Save_btn.Enabled = false;
}
else
{
Save_btn.Enabled = true;
}
this.CompleteProgress();
}
}
