/// <summary>
/// 根据角色ID取得角色信息
/// </summary>
/// <param name="RoleId"></param>
/// <returns></returns>
public RoleInfo GetRoleById(string RoleId)
{
RoleInfo info = new RoleInfo();
using (DbDataReader reader = DataBaseManage.ExecuteReader(_SelectSql + " where roleid='" + RoleId + "'"))
{
if (reader.Read())
{
info = BuilderEntity(reader);
}
}
return(info);
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <param name="MoudleId"></param>
/// <returns></returns>
public int GetPowerValue(string RoleId, string MoudleId)
{
RoleMoudleInfo info = new RoleMoudleInfo();
string sql = "Select sum(powervalue) powervalue From rolemoudleinfo where roleid in(" + RoleId + ") and moudleid='" + MoudleId + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader.Read())
{
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
}
}
return(int.Parse(info.PowerValue.ToString()));
}
/// <summary>
///
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
public DictTypeInfo GetDictTypeInfo(string Code)
{
DictTypeInfo info = null;
string sql = _SelectSql2 + string.Format(" Where code = '{0}'", Code);
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader.Read())
{
info = BuilderDictType(reader);
}
}
return(info);
}
/// <summary>
///
/// </summary>
/// <param name="MoudleId"></param>
/// <returns></returns>
public string GetCurrentLocation(string MoudleId)
{
string strSQL = "select CONCAT((Select moudlename From moudleinfo Where moudleid =t.parentid ),'>>',t.moudlename) Location from moudleinfo t Where t.moudleid='" + MoudleId + "'";
string Location = "";
using (DbDataReader reader = DataBaseManage.ExecuteReader(strSQL))
{
while (reader.Read())
{
Location = (reader.IsDBNull(reader.GetOrdinal("Location"))) ? "" : reader["Location"].ToString();
}
}
return(Location);
}
/// <summary>
///
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
public DictInfo GetDictInfo(string Code, string Type)
{
DictInfo info = null;
string sql = _SelectSql + string.Format(" where code='{0}' and Type='{1}'", Code, Type);
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader.Read())
{
info = BuilderEntity(reader);
}
}
return(info);
}
/// <summary>
///
/// </summary>
/// <param name="MoudleId"></param>
/// <returns></returns>
public MoudleInfo GetMoudleInfo(string MoudleId)
{
MoudleInfo info = null;
string sql = _SelectSql + " where moudleid='" + MoudleId + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader.Read())
{
info = BuilderEntity(reader);
}
}
return(info);
}
/// <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);
}
/// <summary>
///
/// </summary>
/// <param name="Code"></param>
/// <returns></returns>
public PostInfo GetPostInfo(string Code)
{
PostInfo info = null;
string Sql = _SelectSql + string.Format(" where code = '{0}'", Code.Trim());
using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql))
{
if (reader.Read())
{
info = BuilderEntity(reader);
}
}
return(info);
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <syslogInfo> GetsyslogList(string Where)
{
List <syslogInfo> list = new List <syslogInfo>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
syslogInfo ent = new syslogInfo();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <BuGastankRepair> GetBuGastankRepairList(string Where)
{
List <BuGastankRepair> list = new List <BuGastankRepair>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
BuGastankRepair ent = new BuGastankRepair();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <BuScheduleApply> GetBuScheduleApplyList(string Where)
{
List <BuScheduleApply> list = new List <BuScheduleApply>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
BuScheduleApply ent = new BuScheduleApply();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <BuWFRelationship> GetBuWFRelationshipList(string Where)
{
List <BuWFRelationship> list = new List <BuWFRelationship>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
BuWFRelationship ent = new BuWFRelationship();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
/// 得到列表
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public List <BuWorkFlow> GetBuWorkFlowList(string Where)
{
List <BuWorkFlow> list = new List <BuWorkFlow>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(DalSql + Where))
{
while (reader.Read())
{
BuWorkFlow ent = new BuWorkFlow();
SetEnt(ent, reader);
list.Add(ent);
}
}
return(list);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <DeptInfo> GetDeptAll()
{
List <DeptInfo> list = new List <DeptInfo>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(_SelectSql))
{
if (reader != null)
{
while (reader.Read())
{
list.Add(BuilderEntity(reader));
}
}
}
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="strUsl"></param>
/// <returns></returns>
public string Exists(string strUsl)
{
string Sql = string.Format("select moudleid from moudleinfo Where url = '{0}'", strUsl);
using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql))
{
if (reader.Read())
{
return((reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString());
}
else
{
return("");
}
}
}
/// <summary>
/// 取得所有角色
/// </summary>
/// <returns></returns>
public List <RoleInfo> GetRoleAll()
{
List <RoleInfo> ListInfo = new List <RoleInfo>();
using (DbDataReader reader = DataBaseManage.ExecuteReader(_SelectSql))
{
if (reader != null)
{
while (reader.Read())
{
ListInfo.Add(BuilderEntity(reader));
}
}
}
return(ListInfo);
}
/// <summary>
///
/// </summary>
/// <param name="PowerId"></param>
/// <returns></returns>
public PowerInfo GetPowerInfo(string PowerId)
{
string Sql = "Select powerid, powername, powervalue, moudleid From powerinfo where powerid='" + PowerId + "'";
PowerInfo info = new PowerInfo();
using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql))
{
if (reader.Read())
{
info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? "" : reader["moudleid"].ToString();
info.PowerId = (reader.IsDBNull(reader.GetOrdinal("powerid"))) ? "" : reader["powerid"].ToString();
info.PowerName = (reader.IsDBNull(reader.GetOrdinal("powername"))) ? "" : reader["powername"].ToString();
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
}
}
return(info);
}
/// <summary>
/// 根据用户代码取得单个用户信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public UserInfo GetUserInfoByUserCode(string UserCode)
{
UserInfo info = null;
string sql = _SelectSql + " where usercode='" + UserCode + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader != null)
{
while (reader.Read())
{
info = BuilderEntity(reader);
}
}
}
return(info);
}
/// <summary>
///
/// </summary>
/// <returns></returns>
public List <MoudleInfo> GetMoudleAll()
{
List <MoudleInfo> list = new List <MoudleInfo>();
string sql = _SelectSql + " order by Sort";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader != null)
{
while (reader.Read())
{
list.Add(BuilderEntity(reader));
}
}
}
return(list);
}
/// <summary>
/// 根据部门类型取得部门列表
/// </summary>
/// <param name="Type">部门类型</param>
/// <returns></returns>
public List <DeptInfo> GetDeptByType(string Type)
{
List <DeptInfo> list = new List <DeptInfo>();
string Sql = _SelectSql + string.Format(" where DEPTTYPE='{0}'", Type);
using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql))
{
if (reader != null)
{
while (reader.Read())
{
list.Add(BuilderEntity(reader));
}
}
}
return(list);
}
/// <summary>
/// 取得所有用户
/// </summary>
/// <returns></returns>
public List <UserInfo> GetUserAll()
{
List <UserInfo> list = new List <UserInfo>();
string sql = _SelectSql + " where ISENABLE ='Y' ";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
if (reader != null)
{
while (reader.Read())
{
list.Add(BuilderEntity(reader));
}
}
}
return(list);
}
/// <summary>
///
/// </summary>
/// <param name="RoleId"></param>
/// <returns></returns>
public List <RoleMoudleInfo> GetRoleMoudle(string RoleId)
{
List <RoleMoudleInfo> ListInfo = new List <RoleMoudleInfo>();
RoleMoudleInfo info = null;
string sql = "Select roleid, moudleid,powervalue From rolemoudleinfo where roleid='" + RoleId.ToString() + "'";
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql))
{
while (reader.Read())
{
info = new RoleMoudleInfo();
info.MoudleId = (reader.IsDBNull(reader.GetOrdinal("moudleid"))) ? int.Parse("0") : int.Parse(reader["moudleid"].ToString());
info.RoleId = (reader.IsDBNull(reader.GetOrdinal("roleid"))) ? int.Parse("0") : int.Parse(reader["roleid"].ToString());
info.PowerValue = (reader.IsDBNull(reader.GetOrdinal("powervalue"))) ? int.Parse("0") : int.Parse(reader["powervalue"].ToString());
ListInfo.Add(info);
}
}
return(ListInfo);
}
/// <summary>
///
/// </summary>
/// <param name="Condition"></param>
/// <returns></returns>
public List <DictInfo> GetDictInfoByCondition(DictInfo Condition)
{
List <DictInfo> list = new List <DictInfo>();
StringBuilder Sql = new StringBuilder();
Sql.Append(_SelectSql);
Sql.Append(" where 1=1 ");
if (Condition != null)
{
if (Condition.Code.Trim() != "")
{
Sql.Append(" and code='" + Condition.Code.Trim() + "'");
}
if (Condition.Name.Trim() != "")
{
Sql.Append(" and Name like '%" + Condition.Name.Trim() + "%'");
}
if (Condition.TypeCode != "")
{
Sql.Append(" and Type = '" + Condition.TypeCode + "'");
}
if (Condition.IsEnable != "")
{
Sql.Append(" and isenable = '" + Condition.IsEnable + "'");
}
else
{
Sql.Append(" and isenable='Y' ");
}
}
Sql.Append(" Order By Type,Sort ");
using (DbDataReader reader = DataBaseManage.ExecuteReader(Sql.ToString()))
{
if (reader != null)
{
while (reader.Read())
{
list.Add(BuilderEntity(reader));
}
}
}
return(list);
}
/// <summary>
/// 根据RelationshipId得到 BuWFRelationship 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuWFRelationship GetBuWFRelationship(int RelationshipId)
{
BuWFRelationship ent = null;
string sql = DalSql;
sql = sql + " And RelationshipId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("RelationshipId", RelationshipId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuWFRelationship();
SetEnt(ent, reader);
}
}
return(ent);
}
/// <summary>
/// 根据WorkflowGUID得到 BuWorkFlow 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuWorkFlow GetBuWorkFlow(string WorkflowGUID)
{
BuWorkFlow ent = null;
string sql = DalSql;
sql = sql + " And WorkflowGUID";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("WorkflowGUID", WorkflowGUID)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuWorkFlow();
SetEnt(ent, reader);
}
}
return(ent);
}
/// <summary>
/// 根据ProcessId得到 BuWFProcess 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuWFProcess GetBuWFProcess(int ProcessId)
{
BuWFProcess ent = null;
string sql = DalSql;
sql = sql + " And ProcessId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("ProcessId", ProcessId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuWFProcess();
SetEnt(ent, reader);
}
}
return(ent);
}
/// <summary>
/// 根据TypeId得到 BuTypeInfo 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuTypeInfo GetBuTypeInfo(int TypeId)
{
BuTypeInfo ent = null;
string sql = DalSql;
sql = sql + " And TypeId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("TypeId", TypeId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuTypeInfo();
SetEnt(ent, reader);
}
}
return(ent);
}
/// <summary>
/// 根据ApplyId得到 BuScheduleApply 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuScheduleApply GetBuScheduleApply(string ApplyId)
{
BuScheduleApply ent = null;
string sql = DalSql;
sql = sql + " And ApplyId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("ApplyId", ApplyId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuScheduleApply();
SetEnt(ent, reader);
}
}
return(ent);
}
/// <summary>
/// 根据Id得到
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public syslogInfo Getsyslog(long ID)
{
syslogInfo ent = null;
string sql = DalSql;
sql = sql + " And ID=@ID ";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("ID", ID)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new syslogInfo();
SetEnt(ent, reader);
}
}
return(ent);
}
/// <summary>
/// 根据GasRepairId得到 BuGastankRepair 实体
/// </summary>
/// <param name="ent"></param>
/// <returns></returns>
public BuGastankRepair GetBuGastankRepair(int GasRepairId)
{
BuGastankRepair ent = null;
string sql = DalSql;
sql = sql + " And GasRepairId";
MySqlParameter[] paras = new MySqlParameter[]
{
new MySqlParameter("GasRepairId", GasRepairId)
};
using (DbDataReader reader = DataBaseManage.ExecuteReader(sql, paras))
{
if (reader.Read())
{
ent = new BuGastankRepair();
SetEnt(ent, reader);
}
}
return(ent);
}
