private void GridBind()
{
DeptDetails_dgv.DataSource = null;
try
{
DepartmentVo vo = new DepartmentVo
{
DepartmentCode = DeptCode_txt.Text,
DepartmentName = DeptName_txt.Text
};
ValueObjectList <DepartmentVo> volist = (ValueObjectList <DepartmentVo>)DefaultCbmInvoker.Invoke(new GetDepartmentVCBCbm(), vo);
if (volist.GetList() != null && volist.GetList().Count > 0)
{
DeptDetails_dgv.AutoGenerateColumns = false;
BindingSource bindingsource = new BindingSource(volist.GetList(), null);
DeptDetails_dgv.DataSource = bindingsource;
}
else
{
messageData = new MessageData("mmci00006", Properties.Resources.mmci00006, null);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
DeptDetails_dgv.ClearSelection();
Update_btn.Enabled = false;
Delete_btn.Enabled = false;
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
}
}
private void BindUpdateCavityData()
{
int selectedrowindex = DeptDetails_dgv.SelectedCells[0].RowIndex;
DepartmentVo vo = (DepartmentVo)DeptDetails_dgv.Rows[selectedrowindex].DataBoundItem;
AddDepartmentForm addform = new AddDepartmentForm();
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)
{
DepartmentVo inVo = (DepartmentVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("insert into vcb_department(vcb_department_cd, vcb_department_name, registration_user_cd, registration_date_time, factory_cd) ");
sql.Append("values(:vcb_department_cd,:vcb_department_name, :registration_user_cd,now(),:factory_cd)");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("vcb_department_cd", inVo.DepartmentCode);
sqlParameter.AddParameterString("vcb_department_name", inVo.DepartmentName);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
DepartmentVo outVo = new DepartmentVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
protected override void BtnAdd_Click(object sender, EventArgs e)
{
DepartmentVo depVo = new DepartmentVo();
departmentVoList.Add(depVo);
this.gridControl1.RefreshDataSource();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DepartmentVo inVo = (DepartmentVo)vo;
StringBuilder sql = new StringBuilder();
sql.Append("update vcb_department set vcb_department_cd =:vcb_department_cd,vcb_department_name =:vcb_department_name");
sql.Append(" where vcb_department_id =:vcb_department_id");
//create command
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//create parameter
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sqlParameter.AddParameterString("vcb_department_cd", inVo.DepartmentCode);
sqlParameter.AddParameterString("vcb_department_name", inVo.DepartmentName);
sqlParameter.AddParameterInteger("vcb_department_id", inVo.DepartmentId);
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
sqlParameter.AddParameterString("registration_user_cd", inVo.RegistrationUserCode);
//execute SQL
DepartmentVo outVo = new DepartmentVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DepartmentVo inVo = (DepartmentVo)vo;
StringBuilder sql = new StringBuilder();
ValueObjectList <DepartmentVo> voList = new ValueObjectList <DepartmentVo>();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("select vcb_department_id, vcb_department_cd, vcb_department_name, registration_user_cd,registration_date_time,factory_cd from vcb_department");
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.DepartmentId > 0)
{
sql.Append(" and vcb_department_id = :vcb_department_id ");
sqlParameter.AddParameterInteger("vcb_department_id", inVo.DepartmentId);
}
if (!string.IsNullOrEmpty(inVo.DepartmentCode))
{
sql.Append(" and vcb_department_cd = :vcb_department_cd ");
sqlParameter.AddParameterString("vcb_department_cd", inVo.DepartmentCode);
}
if (!string.IsNullOrEmpty(inVo.DepartmentName))
{
sql.Append(" and vcb_department_name = :vcb_department_name ");
sqlParameter.AddParameterString("vcb_department_name", inVo.DepartmentName);
}
//create command
//DbCommandAdaptor
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
while (dataReader.Read())
{
DepartmentVo outVo = new DepartmentVo
{
DepartmentCode = dataReader["vcb_department_cd"].ToString(),
DepartmentId = int.Parse(dataReader["vcb_department_id"].ToString()),
DepartmentName = dataReader["vcb_department_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);
}
public void Update(UserDepartmentPB pb, bool resetState = true)
{
SupporterVo vo = null;
//UserDepartmentPB pb = res.MyDepartments;
switch (pb.DepartmentType)
{
//没奖励的时候也要会动！
case DepartmentTypePB.Support:
MainVo = new SupporterVo(pb);
break;
case DepartmentTypePB.Active:
Active = new SupporterVo(pb);
SetAniState(resetState?1:0, 0, 0, 0); //resetState表示从挥手变成待机 pb.Awards.Count>0?1:resetState?0:2
break;
case DepartmentTypePB.Financial:
Financial = new SupporterVo(pb);
SetAniState(0, resetState?1:0, 0, 0);
break;
case DepartmentTypePB.Resource:
Resource = new SupporterVo(pb);
SetAniState(0, 0, resetState?1:0, 0);
break;
case DepartmentTypePB.Transmission:
Transmission = new SupporterVo(pb);
SetAniState(0, 0, 0, resetState?1:0);
break;
}
DepartmentVo dpVo = new DepartmentVo();
dpVo.UserDepartmentPb = pb;
dpVo.RulePb = MyDepartmentData.GetDepartmentRule(dpVo.UserDepartmentPb.DepartmentType, dpVo.UserDepartmentPb.Level);
for (int i = 0; i < GlobalData.DepartmentData.MyDepartments.Count; i++)
{
if (GlobalData.DepartmentData.MyDepartments[i].UserDepartmentPb.DepartmentType == dpVo.UserDepartmentPb.DepartmentType)
{
GlobalData.DepartmentData.MyDepartments[i] = dpVo;
break;
}
}
}
protected override void BtnDel_Click(object sender, EventArgs e)
{
DepartmentVo vo = (DepartmentVo)this.gridView1.GetRow(this.gridView1.FocusedRowHandle);
if (vo == null)
{
return;
}
departmentVoList.Remove(vo);
if (DeleteDao.DeleteByID(vo.Id, typeof(DepartmentVo)) > 0)
{
XtraMessageBox.Show("删除成功");
RefreshDepartment();
}
this.gridControl1.RefreshDataSource();
}
public override ValueObject Execute(TransactionContext trxContext, ValueObject vo)
{
DepartmentVo inVo = (DepartmentVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("delete from vcb_department Where 1=1 ");
if (!String.IsNullOrEmpty(inVo.FactoryCode))
{
sql.Append(" and factory_cd = :factory_cd ");
sqlParameter.AddParameterString("factory_cd", inVo.FactoryCode);
}
if (inVo.DepartmentId > 0)
{
sql.Append(" and vcb_department_id = :vcb_department_id ");
sqlParameter.AddParameterInteger("vcb_department_id", inVo.DepartmentId);
}
if (!string.IsNullOrEmpty(inVo.DepartmentCode))
{
sql.Append(" and vcb_department_cd = :vcb_department_cd ");
sqlParameter.AddParameterString("vcb_department_cd", inVo.DepartmentCode);
}
if (!string.IsNullOrEmpty(inVo.DepartmentName))
{
sql.Append(" and vcb_department_name = :vcb_department_name ");
sqlParameter.AddParameterString("vcb_department_name", inVo.DepartmentName);
}
//create command
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
DepartmentVo outVo = new DepartmentVo
{
AffectedCount = sqlCommandAdapter.ExecuteNonQuery(sqlParameter)
};
return(outVo);
}
private void Delete_btn_Click(object sender, EventArgs e)
{
if (DeptDetails_dgv.SelectedRows.Count > 0)
{
int selectedrowindex = DeptDetails_dgv.SelectedCells[0].RowIndex;
DepartmentVo vo = (DepartmentVo)DeptDetails_dgv.Rows[selectedrowindex].DataBoundItem;
messageData = new MessageData("mmcc00004", Properties.Resources.mmcc00004, vo.DepartmentCode);
logger.Info(messageData);
DialogResult dialogResult = popUpMessage.ConfirmationOkCancel(messageData, Text);
if (dialogResult == DialogResult.OK)
{
try
{
DepartmentVo outVo = (DepartmentVo)DefaultCbmInvoker.Invoke(new DeleteDepartmentVCBCbm(), 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 bool checkdate()
{
if (DeptCode_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, DeptCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
DeptCode_txt.Focus();
return(false);
}
if (DeptName_txt.Text.Trim().Length == 0)
{
messageData = new MessageData("mmcc00005", Properties.Resources.mmcc00005, DeptName_lbl.Text);
popUpMessage.Warning(messageData, Text);
DeptName_txt.Focus();
return(false);
}
DeptCode_txt.Text = DeptCode_txt.Text.Trim();
DeptName_txt.Text = DeptName_txt.Text.Trim();
DepartmentVo outVo = new DepartmentVo(),
inVo = new DepartmentVo {
DepartmentId = vo.DepartmentId, DepartmentCode = DeptCode_txt.Text
};
try
{
outVo = (DepartmentVo)DefaultCbmInvoker.Invoke(new CheckDepartmentVCBCbm(), inVo);
if (outVo.AffectedCount > 0)
{
messageData = new MessageData("mmcc00006", Properties.Resources.mmcc00006, DeptCode_lbl.Text);
popUpMessage.Warning(messageData, Text);
DeptCode_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)
{
DepartmentVo inVo = (DepartmentVo)vo;
StringBuilder sql = new StringBuilder();
DbCommandAdaptor sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, string.Empty);
DbParameterList sqlParameter = sqlCommandAdapter.CreateParameterList();
sql.Append("Select Count(*) as DepartmentCount ");
sql.Append(" from vcb_department");
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.DepartmentCode))
{
sql.Append(" and UPPER(vcb_department_cd) = UPPER(:vcb_department_cd) ");
sqlParameter.AddParameterString("vcb_department_cd", inVo.DepartmentCode);
}
if (inVo.DepartmentId > 0)
{
sql.Append(" and vcb_department_id != :vcb_department_id "); ///?????
sqlParameter.AddParameterInteger("vcb_department_id", inVo.DepartmentId);
}
sqlCommandAdapter = base.GetDbCommandAdaptor(trxContext, sql.ToString());
//execute SQL
IDataReader dataReader = sqlCommandAdapter.ExecuteReader(trxContext, sqlParameter);
DepartmentVo outVo = new DepartmentVo();
while (dataReader.Read())
{
outVo.AffectedCount = Convert.ToInt32(dataReader["DepartmentCount"].ToString());
}
dataReader.Close();
return(outVo);
}
private void Ok_btn_Click(object sender, EventArgs e)
{
if (checkdate())
{
DepartmentVo outvo = new DepartmentVo();
DepartmentVo invo = new DepartmentVo
{
DepartmentId = vo.DepartmentId,
DepartmentCode = DeptCode_txt.Text,
DepartmentName = DeptName_txt.Text,
FactoryCode = UserData.GetUserData().FactoryCode,
RegistrationUserCode = UserData.GetUserData().UserCode
};
try
{
if (invo.DepartmentId > 0)
{
outvo = (DepartmentVo)DefaultCbmInvoker.Invoke(new UpdateDepartmentVCBCbm(), invo);
}
else
{
outvo = (DepartmentVo)DefaultCbmInvoker.Invoke(new AddDepartmentVCBCbm(), invo);
}
{
messageData = new MessageData("mmce00001", Properties.Resources.mmce00001, DeptCode_lbl.Text + " : " + DeptCode_txt.Text);
logger.Info(messageData);
popUpMessage.Information(messageData, Text);
}
}
catch (Framework.ApplicationException exception)
{
popUpMessage.ApplicationError(exception.GetMessageData(), Text);
logger.Error(exception.GetMessageData());
return;
}
}
}
