private void Transfer_btn_Click(object sender, EventArgs e)
{
TransferVo transOutVo = new TransferVo();
TransferVo transVo = new TransferVo()
{
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
transOutVo = (TransferVo)DefaultCbmInvoker.Invoke(new GetRoleCbm(), transVo);
string role = transOutVo.RegistrationUserCode;
if (role != "mgr")
{
TranferRequestForm transre = new TranferRequestForm();
transre.ShowDialog();
}
else
{
TranferInfoForm transinfo = new TranferInfoForm();
transinfo.ShowDialog();
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from t_transfer_detail_info Where 1 = 1");
if (inVo.AssetID > 0)
{
sql.Append(" and asset_id = :asset_id ");
sqlParameter.AddParameterInteger("asset_id", inVo.AssetID);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
TransferVo outVo = new TransferVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into t_transfer_detail_info(transfer_device_id, asset_id, registration_user_cd, registration_date_time, factory_cd) ");
sql.Append("values(:transfer_device_id,:asset_id, :registration_user_cd,now(),:factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("transfer_device_id", inVo.TransferDeviceId);
sqlParameter.AddParameterInteger("asset_id", inVo.AssetID);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
TransferVo outVo = new TransferVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Remove_btn_Click(object sender, EventArgs e)
{
if (this.TitleText == CommonConstants.MODE_ADD)
{
AftTrans_dgv.Rows.RemoveAt(AftTrans_dgv.CurrentRow.Index);
GridBind();
}
else if (TitleText == CommonConstants.MODE_UPDATE)
{
if (AftTrans_dgv.RowCount > 0)
{
//int selectedrowindex = AftTrans_dgv.SelectedCells[0].RowIndex;
TransferVo vo = new TransferVo()
{
AssetID = int.Parse(AftTrans_dgv.CurrentRow.Cells["AssetID"].Value.ToString()),
AssetCode = AftTrans_dgv.CurrentRow.Cells["AssetCode"].Value.ToString(),
AssetName = AftTrans_dgv.CurrentRow.Cells["AssetName"].Value.ToString(),
AssetNo = int.Parse(AftTrans_dgv.CurrentRow.Cells["AssetNo"].Value.ToString())
};
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.AssetCode);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
TransferVo outVo = (TransferVo)DefaultCbmInvoker.Invoke(new DeleteTransferDetailCbm(), 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());
}
}
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update t_transfer_device");
if (!String.IsNullOrEmpty(inVo.TransferStatus))
{
sql.Append(" set trans_status = :trans_status, transfer_dept_approver = :transfer_dept_approver");
}
if (!String.IsNullOrEmpty(inVo.DestinationStatus))
{
sql.Append(" set destination_status = :destination_status, destination_dept_approver = :destination_dept_approver");
}
if (!String.IsNullOrEmpty(inVo.ApproveStatus))
{
sql.Append(" set approve_status = :approve_status, account_approver = :account_approver");
}
sql.Append(" where transfer_device_id = :transfer_device_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterInteger("transfer_device_id", inVo.TransferDeviceId);
if (!String.IsNullOrEmpty(inVo.TransferStatus))
{
sqlParameter.AddParameterString("trans_status", inVo.TransferStatus);
sqlParameter.AddParameterString("transfer_dept_approver", inVo.TransferApprover);
}
if (!String.IsNullOrEmpty(inVo.DestinationStatus))
{
sqlParameter.AddParameterString("destination_status", inVo.DestinationStatus);
sqlParameter.AddParameterString("destination_dept_approver", inVo.DestinationApprover);
}
if (!String.IsNullOrEmpty(inVo.ApproveStatus))
{
sqlParameter.AddParameterString("approve_status", inVo.ApproveStatus);
sqlParameter.AddParameterString("account_approver", inVo.Accounter);
}
//execute SQL
//int a = sqlCommandAdapter.ExecuteNonQuery(sqlParameter);
TransferVo outVo = new TransferVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <TransferVo> voList = new ValueObjectList <TransferVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select a.transfer_device_id, a.transfer_device_cd, a.transfer_content, a.transfer_dept, a.trans_status, a.transfer_dept_approver, a.destination_dept, a.destination_status, a.destination_dept_approver, a.account_approver, a.approve_status, b.user_name from t_transfer_device a
left join m_mes_user b on b.user_cd = b.registration_user_cd
where 1 = 1");
sql.Append(@" and a.transfer_dept = (select dept_cd from m_user_location where user_location_name = :user_location_name)");
sqlParameter.AddParameterString("user_location_name", inVo.UserName);
if (!String.IsNullOrEmpty(inVo.DestinationDept))
{
sql.Append(@" and a.destination_dept = :destination_dept");
sqlParameter.AddParameterString("destination_dept", inVo.DestinationDept);
}
else
{
sql.Append(@" or a.destination_dept = (select dept_cd from m_user_location where user_location_name = :user_location_name)");
sqlParameter.AddParameterString("user_location_name", inVo.UserName);
}
sql.Append(" order by a.transfer_device_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
TransferVo outVo = new TransferVo
{
TransferDeviceId = int.Parse(dataReader["transfer_device_id"].ToString()),
TransferDeviceCode = dataReader["transfer_device_cd"].ToString(),
TransferContent = dataReader["transfer_content"].ToString(),
TransferDept = dataReader["transfer_dept"].ToString(),
TransferStatus = dataReader["trans_status"].ToString(),
TransferApprover = dataReader["transfer_dept_approver"].ToString(),
DestinationDept = dataReader["destination_dept"].ToString(),
DestinationStatus = dataReader["destination_status"].ToString(),
DestinationApprover = dataReader["destination_dept_approver"].ToString(),
Accounter = dataReader["account_approver"].ToString(),
ApproveStatus = dataReader["approve_status"].ToString(),
UserName = dataReader["user_name"].ToString()
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void Search_btn_Click(object sender, EventArgs e)
{
TransferVo trvos = new TransferVo()
{
UserName = UserData.GetUserData().UserName,
DestinationDept = Destination_cmb.Text
};
ValueObjectList <TransferVo> listvo = (ValueObjectList <TransferVo>)DefaultCbmInvoker.Invoke(new LoadTransferListCbm(), trvos);
TranferInfo_dgv.DataSource = listvo.GetList();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <TransferVo> voList = new ValueObjectList <TransferVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select a.asset_id AssetID, a.asset_cd AssetCode, a.asset_name AssetName, a.asset_no AssetNo from t_transfer_detail_info b
left join m_asset a on a.asset_id = b.asset_id
left join t_transfer_device c on c.transfer_device_id = b.transfer_device_id
where 1 = 1");
if (!String.IsNullOrEmpty(inVo.TransferDeviceCode))
{
sql.Append(@" and c.transfer_device_cd =:transfer_device_cd");
sqlParameter.AddParameterString("transfer_device_cd", inVo.TransferDeviceCode);
}
sql.Append(" order by a.asset_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
DataSet da = sqlCommandAdapter.ExecuteDataSet(sqlParameter);
//IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
//while (dataReader.Read())
//{
// TransferVo outVo = new TransferVo
// {
// AssetCode = dataReader["asset_cd"].ToString(),
// AssetName = dataReader["asset_name"].ToString(),
// AssetNo = int.Parse(dataReader["asset_no"].ToString()),
// AssetID = int.Parse(dataReader["asset_id"].ToString())
// };
// voList.add(outVo);
//}
TransferVo outVo2 = new TransferVo
{
dt = da.Tables[0]
};
//dataReader.Close();
return(outVo2);
}
private void View_btn_Click(object sender, EventArgs e)
{
if (TranferInfo_dgv.SelectedCells.Count > 0)
{
TransferVo uvo = (TransferVo)TranferInfo_dgv.CurrentRow.DataBoundItem;
if (new TranferRequestForm {
TransVo = uvo
}.ShowDialog() != DialogResult.OK)
{
GridBind();
setColor();
}
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <TransferVo> voList = new ValueObjectList <TransferVo>();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select a.asset_id, a.asset_cd, a.asset_name, a.asset_no from t_warehouse_main b
left join m_asset a on a.asset_id = b.asset_id
left join m_location c on c.location_id = b.before_location_id
where 1 = 1");
if (!String.IsNullOrEmpty(inVo.LocationCd))
{
sql.Append(@" and c.location_cd =:location_cd");
sqlParameter.AddParameterString("location_cd", inVo.LocationCd);
}
if (!String.IsNullOrEmpty(inVo.AssetCode))
{
sql.Append(@" and a.asset_cd = :asset_cd");
sqlParameter.AddParameterString("asset_cd", inVo.AssetCode);
}
sql.Append(" order by a.asset_cd");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
TransferVo outVo = new TransferVo
{
AssetCode = dataReader["asset_cd"].ToString(),
AssetName = dataReader["asset_name"].ToString(),
AssetNo = int.Parse(dataReader["asset_no"].ToString()),
AssetID = int.Parse(dataReader["asset_id"].ToString())
};
voList.add(outVo);
}
dataReader.Close();
return(voList);
}
private void Update_btn_Click(object sender, EventArgs e)
{
TransferVo upVo = new TransferVo();
TransferVo chkVo = new TransferVo();
for (int i = 0; i < AftTrans_dgv.Rows.Count; i++)
{
try
{
chkVo = (TransferVo)DefaultCbmInvoker.Invoke(new Cbm.CheckAssetTransferCbm(), new TransferVo()
{
AssetID = int.Parse(AftTrans_dgv["AssetID", i].Value.ToString())
});
if (chkVo.AffectedCount == 0)
{
upVo = (TransferVo)DefaultCbmInvoker.Invoke(new AddDetailRequestCbm(), new TransferVo()
{
TransferDetailId = this.TransVo.TransferDetailId,
TransferDeviceId = int.Parse(TransferCd_txt.Text.Substring(6)),
AssetID = int.Parse(AftTrans_dgv["AssetID", i].Value.ToString()),
RegistrationDateTime = DateTime.Now,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
});
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
if (upVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + asset_code_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
private void GridBind()
{
TransferVo transOutVo = new TransferVo();
TransferVo transVo = new TransferVo()
{
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
transOutVo = (TransferVo)DefaultCbmInvoker.Invoke(new GetRoleCbm(), transVo);
string role = transOutVo.RegistrationUserCode;
switch (role)
{
case "account":
TransferVo trvo = new TransferVo()
{
UserName = UserData.GetUserData().UserName
};
ValueObjectList <TransferVo> vo = (ValueObjectList <TransferVo>)DefaultCbmInvoker.Invoke(new LoadAllTransferListCbm(), trvo);
TranferInfo_dgv.DataSource = vo.GetList();
break;
default:
TransferVo trvos = new TransferVo()
{
UserName = UserData.GetUserData().UserName
};
ValueObjectList <TransferVo> listvo = (ValueObjectList <TransferVo>)DefaultCbmInvoker.Invoke(new LoadTransferListCbm(), trvos);
TranferInfo_dgv.DataSource = listvo.GetList();
break;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
TransferVo voNoList = new TransferVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT case when MAX(transfer_device_id) is null then 0 else MAX(transfer_device_id) end transfer_device_id from t_transfer_device");
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
string transfer_device_id = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
inVo.TransferDeviceID = int.Parse(transfer_device_id);
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
TransferVo voNoList = new TransferVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"select dept_cd from m_user_location where user_location_name = :user_location_name");
sqlParameter.AddParameterString("user_location_name", inVo.UserName);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
string dept_cd = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
inVo.DeptCD = dept_cd;
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
TransferVo voNoList = new TransferVo();
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append(@"SELECT role_cd FROM m_mes_user_role WHERE user_cd = :user_cd");
sqlParameter.AddParameterString("user_cd", inVo.RegistrationUserCode);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
string user_cd = sqlCommandAdapter.ExecuteScalar(sqlParameter).ToString();
inVo.RegistrationUserCode = user_cd;
return(inVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
TransferVo inVo = (TransferVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as AssetCount from t_transfer_detail_info where 1 = 1 and asset_id = :asset_id ");
sqlParameter.AddParameterInteger("asset_id", inVo.AssetID);
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
TransferVo outVo = new TransferVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["AssetCount"].ToString());
}
dataReader.Close();
return(outVo);
}
private void AccountReject_btn_Click(object sender, EventArgs e)
{
TransferVo trvos = new TransferVo()
{
TransferDeviceId = TransVo.TransferDeviceId,
ApproveStatus = "Rejected",
Accounter = UserData.GetUserData().UserName
};
try
{
TransferVo listvo = (TransferVo)DefaultCbmInvoker.Invoke(new UpdateStatusTransferListCbm(), trvos);
AccountReject_ptb.Visible = true;
AccountApprove_btn.Enabled = true;
AccountReject_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
private void Send_btn_Click(object sender, EventArgs e)
{
//List Request
if (Checkdata())
{
TransferVo outVo = new TransferVo();
TransferVo inVo = new TransferVo()
{
TransferDeviceId = this.TransVo.TransferDeviceId,
TransferDeviceCode = TransferCd_txt.Text,
TransferContent = TransferContent_txt.Text,
TransferDept = Transfer_cmb.Text,
DestinationDept = Destination_cmb.Text,
RegistrationDateTime = DateTime.Now,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
outVo = (TransferVo)DefaultCbmInvoker.Invoke(new AddListRequestCbm(), inVo);
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
//Detail Request
TransferVo outVo1 = new TransferVo();
for (int i = 0; i < AftTrans_dgv.Rows.Count; i++)
{
try
{
outVo1 = (TransferVo)DefaultCbmInvoker.Invoke(new AddDetailRequestCbm(), new TransferVo()
{
TransferDetailId = this.TransVo.TransferDetailId,
TransferDeviceId = int.Parse(TransferCd_txt.Text.Substring(6)),
AssetID = int.Parse(AftTrans_dgv["AssetID", i].Value.ToString()),
RegistrationDateTime = DateTime.Now,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
});
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, asset_code_lbl.Text + " : " + asset_code_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
return;
}
}
}
private void ViewStatus()
{
if (transChk == "Approved")
{
TransferAppr_ptb.Visible = true;
}
else if (transChk == "Rejected")
{
TransferReject_ptb.Visible = true;
}
if (desChk == "Approved")
{
DestinationAppr_ptb.Visible = true;
}
else if (desChk == "Rejected")
{
DestinationReject_ptb.Visible = true;
}
if (accChk == "Approved")
{
AccountAppr_ptb.Visible = true;
AccountApprove_btn.Enabled = false;
AccountReject_btn.Enabled = false;
Account_lbl.Text = "Approved By:";
}
else if (accChk == "Rejected")
{
AccountReject_ptb.Visible = true;
AccountApprove_btn.Enabled = true;
AccountReject_btn.Enabled = false;
Account_lbl.Text = "Rejected By:";
}
//Get User Dept
TransferVo trOutvo = new TransferVo();
TransferVo trvo = new TransferVo()
{
UserName = UserData.GetUserData().UserName,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
trOutvo = (TransferVo)DefaultCbmInvoker.Invoke(new GetUserDeptCbm(), trvo);
usr_dept = trOutvo.DeptCD;
//Get Role to show Approve - Reject button
trOutvo = (TransferVo)DefaultCbmInvoker.Invoke(new GetRoleCbm(), trvo);
string role = trOutvo.RegistrationUserCode;
switch (role)
{
case "mgr":
AccountApprove_btn.Enabled = false;
AccountReject_btn.Enabled = false;
if (String.IsNullOrEmpty(TransCheckUser_txt.Text) && usr_dept == Transfer_cmb.Text)
{
TransferApprove_btn.Enabled = true;
TransferReject_btn.Enabled = true;
DesApprove_btn.Enabled = false;
DesReject_btn.Enabled = false;
}
else if (String.IsNullOrEmpty(DestinationCheckUser_txt.Text) && usr_dept == Destination_cmb.Text)
{
TransferApprove_btn.Enabled = false;
TransferReject_btn.Enabled = false;
DesApprove_btn.Enabled = true;
DesReject_btn.Enabled = true;
}
if (TransferReject_ptb.Visible == true)
{
TransferReject_btn.Enabled = false;
TransferApprove_btn.Enabled = true;
}
if (DestinationReject_ptb.Visible == true)
{
DesApprove_btn.Enabled = false;
DesReject_btn.Enabled = true;
}
break;
case "account":
if (AccountReject_ptb.Visible == true)
{
AccountApprove_btn.Enabled = true;
AccountReject_btn.Enabled = false;
}
break;
default:
AccountApprove_btn.Enabled = false;
AccountReject_btn.Enabled = false;
TransferApprove_btn.Enabled = false;
TransferReject_btn.Enabled = false;
DesApprove_btn.Enabled = false;
DesReject_btn.Enabled = false;
break;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void TranferRequestForm_Load(object sender, EventArgs e)
{
ValueObjectList <LocationVo> locationvolist = null;
try
{
locationvolist = (ValueObjectList <LocationVo>)DefaultCbmInvoker.Invoke(getDeptCbm, new LocationVo());
}
catch (Framework.ApplicationException ex)
{
logger.Error(ex.GetMessageData());
popUpMessage.ApplicationError(ex.GetMessageData(), Text);
return;
}
Transfer_cmb.DisplayMember = "LocationCode";
BindingSource b1 = new BindingSource(locationvolist.GetList(), null);
Transfer_cmb.DataSource = b1;
Transfer_cmb.Text = "";
Destination_cmb.DisplayMember = "LocationCode";
BindingSource b2 = new BindingSource(locationvolist.GetList(), null);
Destination_cmb.DataSource = b2;
Destination_cmb.Text = "";
if (TransVo.TransferDeviceId > 0)
{
Add_btn.Enabled = true;
Remove_btn.Enabled = true;
Send_btn.Enabled = false;
transChk = TransVo.TransferStatus;
desChk = TransVo.DestinationStatus;
accChk = TransVo.ApproveStatus;
RequestAppr_ptb.Visible = true;
RequestUser_txt.Text = TransVo.UserName;
TransCheckUser_txt.Text = TransVo.TransferApprover;
DestinationCheckUser_txt.Text = TransVo.DestinationApprover;
Accounter_lbl.Text = TransVo.Accounter;
Transfer_cmb.Text = TransVo.TransferDept;
Destination_cmb.Text = TransVo.DestinationDept;
TransferContent_txt.Text = TransVo.TransferContent;
TransferCd_txt.Text = TransVo.TransferDeviceCode;
this.TitleText = CommonConstants.MODE_UPDATE;
if (!String.IsNullOrEmpty(accChk))
{
Account_lbl.Visible = true;
Accounter_lbl.Visible = true;
}
if (transChk == "Approved" && desChk == "Approved")
{
AccountCheckUser_lbl.Visible = true;
AccountApprove_btn.Visible = true;
AccountReject_btn.Visible = true;
}
if (String.IsNullOrEmpty(TransCheckUser_txt.Text) && TransVo.UserName == UserData.GetUserData().UserName)
{
Update_btn.Enabled = true;
}
if (transChk == "Rejected" && TransVo.UserName == UserData.GetUserData().UserName || desChk == "Rejected" && TransVo.UserName == UserData.GetUserData().UserName || accChk == "Rejected" && TransVo.UserName == UserData.GetUserData().UserName)
{
Add_btn.Enabled = true;
Remove_btn.Enabled = true;
}
TransferVo trvos = new TransferVo()
{
TransferDeviceCode = TransferCd_txt.Text
};
try
{
TransferVo listvo = (TransferVo)DefaultCbmInvoker.Invoke(new LoadAfterTransCbm(), trvos);
dt = new DataTable();
dt = listvo.dt;
AftTrans_dgv.DataSource = dt;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
ViewStatus();
}
else
{
Add_btn.Enabled = true;
Remove_btn.Enabled = true;
TransferVo gettrans = new TransferVo();
gettrans = (TransferVo)DefaultCbmInvoker.Invoke(new Cbm.GetTransferCodeCbm(), new TransferVo());
int transId = gettrans.TransferDeviceID;
if (transId == 0)
{
TransferCd_txt.Text = "DEVTR-1";
}
else
{
TransferCd_txt.Text = "DEVTR-" + (transId + 1);
}
this.TitleText = Com.Nidec.Mes.GlobalMasterMaintenance.CommonConstants.MODE_ADD;
}
}
private void GridBind()
{
BefTrans_dgv.DataSource = null;
TransferVo trvos = new TransferVo()
{
AssetCode = assetcodetrim,
LocationCd = Transfer_cmb.Text,
TransferDeviceCode = TransferCd_txt.Text
};
try
{
//Load After Trans
if (TitleText == CommonConstants.MODE_UPDATE)
{
TransferVo Aftvo = (TransferVo)DefaultCbmInvoker.Invoke(new LoadAfterTransCbm(), trvos);
dt = new DataTable();
dt = Aftvo.dt;
AftTrans_dgv.DataSource = Aftvo.dt;
}
//Load Before Trans
ValueObjectList <TransferVo> listvo = (ValueObjectList <TransferVo>)DefaultCbmInvoker.Invoke(new LoadBeforeTransCbm(), trvos);
BefTrans_dgv.DataSource = listvo.GetList();
for (int i = 0; i < BefTrans_dgv.RowCount; i++)
{
for (int j = 0; j < AftTrans_dgv.RowCount; j++)
{
if (BefTrans_dgv["colAssetCode", i].Value.ToString().Contains(AftTrans_dgv["AssetCode", j].Value.ToString()) && BefTrans_dgv["colAssetName", i].Value.ToString().Contains(AftTrans_dgv["AssetName", j].Value.ToString()) && BefTrans_dgv["colAssetNo", i].Value.ToString().Contains(AftTrans_dgv["AssetNo", j].Value.ToString()))
{
BefTrans_dgv.Rows[i].DefaultCellStyle.BackColor = Color.LightGray;
BefTrans_dgv.Rows[i].DefaultCellStyle.ForeColor = Color.Gray;
}
}
TransferVo outVoA = new TransferVo();
TransferVo inVoA = new TransferVo()
{
AssetID = int.Parse(BefTrans_dgv["colAssetID", i].Value.ToString())
};
try
{
outVoA = (TransferVo)DefaultCbmInvoker.Invoke(new Cbm.CheckAssetTransferCbm(), inVoA);
if (outVoA.AffectedCount == 1)
{
BefTrans_dgv.Rows[i].DefaultCellStyle.BackColor = Color.LightGray;
BefTrans_dgv.Rows[i].DefaultCellStyle.ForeColor = Color.Gray;
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
