/// <summary>
/// 绑定部门数据
/// </summary>
/// <param name="entity">数据源</param>
/// <param name="pageno">页数</param>
/// <param name="pagesize">页大小</param>
/// <param name="icnt">条数</param>
/// <returns></returns>
internal List<EapDepartment> GetDEPARTMENTList(EapDepartment entity, int pageno, int pagesize, out int icnt)
{
StringBuilder sql = new StringBuilder(200);
string DEPARTMENT_TYPE = "";
if (entity.DEPARTMENT_TYPE != "全部")
{
DEPARTMENT_TYPE = entity.DEPARTMENT_TYPE;
}
OracleParameter[] para = new OracleParameter[]
{
new OracleParameter(":DEPARTMENT_CODE",entity.DEPARTMENT_CODE),
new OracleParameter(":DEPARTMENT_NAME",entity.DEPARTMENT_NAME),
new OracleParameter(":DEPARTMENT_TYPE",DEPARTMENT_TYPE),
new OracleParameter(":ASSEMBLY_LINE",entity.ASSEMBLY_LINE),
new OracleParameter(":STATUS",entity.STATUS)
};
sql.Append("select DEPARTMENT_ID,DEPARTMENT_CODE,DEPARTMENT_NAME,DEPARTMENT_TYPE,ASSEMBLY_LINE,STATUS,STATUS as STATUS_FALSE ");
sql.Append(" from t_eap_department ");
sql.Append(" where DEPARTMENT_CODE like '%'||:DEPARTMENT_CODE||'%' ");
sql.Append(" and DEPARTMENT_NAME like '%'||:DEPARTMENT_NAME||'%' ");
sql.Append(" and DEPARTMENT_TYPE like '%'||:DEPARTMENT_TYPE||'%' ");
sql.Append(" and STATUS=:STATUS ");
sql.Append(" order by DEPARTMENT_ID ");
return Oracle.GetOracle().QueryToPage<EapDepartment>(sql, para, pageno, pagesize, out icnt);
}
public frmDepartmentManageEdit(EditMode em_value, EapDepartment entity_value)
{
InitializeComponent();
Func.FormatForm(this);
//绑定值
entity = entity_value;
em = em_value;
}
private EapDepartment GetAddEntity()
{
EapDepartment ret_entity = new EapDepartment();
ret_entity.DEPARTMENT_ID = Bll.GetBll().GetDEPARTMENT_ID();
ret_entity.DEPARTMENT_CODE = txtDEPARTMENT_CODE.Text;
ret_entity.DEPARTMENT_NAME = txtDEPARTMENT_NAME.Text;
ret_entity.DEPARTMENT_TYPE = cmbDEPARTMENT_TYPE.Text;
ret_entity.ASSEMBLY_LINE = cmbASSEMBLY_LINE.Text;
ret_entity.STATUS = decimal.Parse(((EapItem)cmbStatus.SelectedItem).ID);
return(ret_entity);
}
/// <summary>
/// 绑定数据
/// </summary>
private void BindData()
{
EapDepartment entity = new EapDepartment();
entity.DEPARTMENT_CODE = txtDEPARTMENT_CODE.Text;
entity.DEPARTMENT_NAME = txtDEPARTMENT_NAME.Text;
entity.DEPARTMENT_TYPE = cmbDEPARTMENT_TYPE.Text;
entity.STATUS = chbSTATUS.Checked?0:1;
int count = 0;
List <EapDepartment> list = Bll.GetBll().GetDEPARTMENTList(entity, page.PageNo, page.PageSize, out count);
page.RecordCount = count;
dgv.DataSource = list;
}
/// <summary>
/// 保存部门
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
internal string UpdateDEPARTMENT(EapDepartment entity)
{
StringBuilder sql = new StringBuilder(200);
OracleParameter[] para = new OracleParameter[]
{
new OracleParameter(":DEPARTMENT_ID",entity.DEPARTMENT_ID),
new OracleParameter(":DEPARTMENT_CODE",entity.DEPARTMENT_CODE),
new OracleParameter(":DEPARTMENT_NAME",entity.DEPARTMENT_NAME),
new OracleParameter(":DEPARTMENT_TYPE",entity.DEPARTMENT_TYPE),
new OracleParameter(":STATUS",entity.STATUS),
};
sql.Append(" update t_eap_department ");
sql.Append(" set DEPARTMENT_CODE=:DEPARTMENT_CODE,DEPARTMENT_NAME=:DEPARTMENT_NAME,STATUS=:STATUS,DEPARTMENT_TYPE=:DEPARTMENT_TYPE ");
sql.Append(" where DEPARTMENT_ID=:DEPARTMENT_ID ");
return Oracle.GetOracle().ExecSql(sql, para);
}
/// <summary>
/// 新增部门
/// </summary>
/// <param name="entity"></param>
/// <returns></returns>
internal string AddDEPARTMENT(EapDepartment entity)
{
StringBuilder sql = new StringBuilder(200);
OracleParameter[] para = new OracleParameter[]
{
new OracleParameter(":DEPARTMENT_ID",entity.DEPARTMENT_ID),
new OracleParameter(":DEPARTMENT_CODE",entity.DEPARTMENT_CODE),
new OracleParameter(":DEPARTMENT_NAME",entity.DEPARTMENT_NAME),
new OracleParameter(":DEPARTMENT_TYPE",entity.DEPARTMENT_TYPE),
new OracleParameter(":STATUS",entity.STATUS),
};
sql.Append(" insert into t_eap_department ");
sql.Append(" (DEPARTMENT_ID,DEPARTMENT_CODE,DEPARTMENT_NAME,DEPARTMENT_TYPE,STATUS) ");
sql.Append(" values ");
sql.Append(" (:DEPARTMENT_ID,:DEPARTMENT_CODE,:DEPARTMENT_NAME,:DEPARTMENT_TYPE,:STATUS) ");
return Oracle.GetOracle().ExecSql(sql, para);
}
/// <summary>
/// 修改
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnUpate_Click(object sender, EventArgs e)
{
if (dgv.SelectedCells.Count == 0)
{
Func.ShowMessage(MessageType.Warning, "没有选中一条数据");
return;
}
EapDepartment entity = new EapDepartment();
entity.DEPARTMENT_ID = Int32.Parse(dgv.Rows[dgv.CurrentCell.RowIndex].Cells["DEPARTMENT_ID"].Value.ToString());
entity.DEPARTMENT_CODE = dgv.Rows[dgv.CurrentCell.RowIndex].Cells["DEPARTMENT_CODE"].Value.ToString();
entity.DEPARTMENT_NAME = dgv.Rows[dgv.CurrentCell.RowIndex].Cells["DEPARTMENT_NAME"].Value.ToString();
entity.DEPARTMENT_TYPE = dgv.Rows[dgv.CurrentCell.RowIndex].Cells["DEPARTMENT_TYPE"].Value.ToString();
entity.ASSEMBLY_LINE = dgv.Rows[dgv.CurrentCell.RowIndex].Cells["ASSEMBLY_LINE"].Value.ToString();
entity.STATUS = decimal.Parse(dgv.Rows[dgv.CurrentCell.RowIndex].Cells["STATUS"].Value.ToString());
frmDepartmentManageEdit frm = new frmDepartmentManageEdit(EditMode.Edit, entity);
frm.MdiParent = this.MdiParent;
frm.WindowState = FormWindowState.Maximized;
frm.Show();
}
/// <summary>
/// 保存
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnEnter_Click(object sender, EventArgs e)
{
if (txtDEPARTMENT_CODE.Text.Trim() == string.Empty)
{
Func.ShowMessage(MessageType.Warning, "部门编号不能为空");
txtDEPARTMENT_CODE.Focus();
return;
}
if (txtDEPARTMENT_NAME.Text.Trim() == string.Empty)
{
Func.ShowMessage(MessageType.Warning, "部门名称不能为空");
txtDEPARTMENT_NAME.Focus();
return;
}
if (cmbASSEMBLY_LINE.Text.Trim() == string.Empty)
{
Func.ShowMessage(MessageType.Warning, "装配线不能为空");
cmbASSEMBLY_LINE.Focus();
return;
}
string ret;
if (em == EditMode.Edit)
{
if (Bll.GetBll().RepeatDEPARTMENT(txtDEPARTMENT_NAME.Text.Trim(), entity.DEPARTMENT_ID))
{
Func.ShowMessage(MessageType.Warning, "部门名称重复，请重新输入");
txtDEPARTMENT_NAME.Focus();
return;
}
entity.DEPARTMENT_CODE = txtDEPARTMENT_CODE.Text;
entity.DEPARTMENT_NAME = txtDEPARTMENT_NAME.Text;
entity.DEPARTMENT_TYPE = cmbDEPARTMENT_TYPE.Text;
entity.ASSEMBLY_LINE = cmbASSEMBLY_LINE.Text;
entity.STATUS = decimal.Parse(((EapItem)cmbStatus.SelectedItem).ID);
ret = Bll.GetBll().UpdateDEPARTMENT(entity);
if (ret != string.Empty)
{
Func.ShowMessage(MessageType.Information, "新增失败" + ret);
return;
}
Func.ShowMessage(MessageType.Information, "保存成功");
//成功写入日志
Log.Write(MessageType.Information, "修改部门成功,问题id[" + entity.DEPARTMENT_ID + "], " + log + " 新数据：部门编号[" + txtDEPARTMENT_CODE.Text + "],部门名称[" + txtDEPARTMENT_NAME.Text + "],类型[" + cmbDEPARTMENT_TYPE.Text + "],装配线[" + cmbASSEMBLY_LINE.Text + "],状态[" + cmbStatus.Text + "] ", Config.GetConfig().user.USER_ID);
this.Close();
}
else
{
if (Bll.GetBll().RepeatDEPARTMENT(txtDEPARTMENT_NAME.Text.Trim(), 0))
{
Func.ShowMessage(MessageType.Warning, "部门名称重复，请重新输入");
txtDEPARTMENT_NAME.Focus();
return;
}
entity = GetAddEntity();
ret = Bll.GetBll().AddDEPARTMENT(entity);
if (ret != string.Empty)
{
Func.ShowMessage(MessageType.Information, "新增失败" + ret);
return;
}
//成功写入日志
Log.Write(MessageType.Information, "新增部门成功,id=[" + entity.DEPARTMENT_ID + "],部门编号[" + entity.DEPARTMENT_CODE + "],部门名称[" + entity.DEPARTMENT_NAME + "],部门类型[" + entity.DEPARTMENT_TYPE + "],部门状态[" + entity.STATUS + "]", Config.GetConfig().user.USER_ID);
Func.ShowMessage(MessageType.Information, "新增成功");
this.Close();
}
}
/// <summary>
/// 新增部门
/// </summary>
/// <param name="entity">数据集</param>
/// <returns></returns>
internal string AddDEPARTMENT(EapDepartment entity)
{
return(DalOracle.GetDalOracle().AddDEPARTMENT(entity));
}
/// <summary>
/// 绑定部门数据
/// </summary>
/// <param name="entity">数据源</param>
/// <param name="pageno">页数</param>
/// <param name="pagesize">页大小</param>
/// <param name="icnt">条数</param>
/// <returns></returns>
internal List <EapDepartment> GetDEPARTMENTList(EapDepartment entity, int pageno, int pagesize, out int icnt)
{
return(DalOracle.GetDalOracle().GetDEPARTMENTList(entity, pageno, pagesize, out icnt));
}