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