/// <summary> /// /// </summary> /// <param name="reader"></param> /// <returns></returns> private DeptInfo BuilderEntity(DbDataReader reader) { DeptInfo info = new DeptInfo(); info.DeptId = (reader.IsDBNull(reader.GetOrdinal("deptid"))) ? "" : reader["deptid"].ToString(); info.DeptName = (reader.IsDBNull(reader.GetOrdinal("deptname"))) ? "" : reader["deptname"].ToString(); info.ParentId = (reader.IsDBNull(reader.GetOrdinal("parentid"))) ? "" : reader["parentid"].ToString(); info.Remark = (reader.IsDBNull(reader.GetOrdinal("remark"))) ? "" : reader["remark"].ToString(); info.DeptType = (reader.IsDBNull(reader.GetOrdinal("DEPTTYPE"))) ? "" : reader["DEPTTYPE"].ToString(); return(info); }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool ModifyDept(DeptInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Update deptinfo "); sql.Append(" Set deptname = '" + info.DeptName + "',"); sql.Append(" parentid = '" + info.ParentId + "', "); sql.Append(" remark = '" + info.Remark + "', "); sql.Append(" DEPTTYPE = '" + info.DeptType + "' "); sql.Append(" Where deptid = '" + info.DeptId + "'"); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="MoudleId"></param> /// <returns></returns> public DeptInfo GetDeptInfo(string DeptId) { DeptInfo info = null; string sql = _SelectSql + " where deptid='" + DeptId + "'"; using (DbDataReader reader = DataBaseManage.ExecuteReader(sql)) { if (reader.Read()) { info = BuilderEntity(reader); } } return(info); }
public bool CreateDept(DeptInfo info) { StringBuilder sql = new StringBuilder(); sql.Append(" Insert Into deptinfo "); sql.Append(" ( deptid,deptname, parentid, remark,DEPTTYPE) "); sql.Append(" Values( "); sql.Append(" '" + info.DeptId + "',"); sql.Append(" '" + info.DeptName + "',"); sql.Append(" '" + info.ParentId + "',"); sql.Append(" '" + info.Remark + "',"); sql.Append(" '" + info.DeptType + "'"); sql.Append(" ) "); return(DataBaseManage.ExecuteSql(sql.ToString()) > 0); }
/// <summary> /// /// </summary> /// <param name="user"></param> /// <returns></returns> public bool ModifyDept(DeptInfo info) { return(_dept.ModifyDept(info)); }
public bool CreateDept(DeptInfo info) { return(_dept.CreateDept(info)); }