/// <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)); }