public DataTable GetData(string where)
{
StringBuilder sb = new StringBuilder();
sb.Append(" select a.* ");
sb.Append(",(select username from userinfo t where a.fsr=t.usercode ) fsrmc ");
sb.Append(" from AYJZ_XXTS a where 1=1 ");
sb.Append(where);
DataSet ds = DataBaseManage.ExecuteDataSet(sb.ToString());
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(new DataTable());
}
public DataTable GetData(string where)
{
StringBuilder sb = new StringBuilder();
sb.Append(" select a.* ");
sb.Append(",(select username from userinfo t where a.usercode=t.usercode ) username ");
sb.Append(",(select MOUDLENAME from moudleinfo t where a.MOUDLEID=t.MOUDLEID ) MOUDLENAME ");
sb.Append(" from syslog a where 1=1 ");
sb.Append(where);
DataSet ds = DataBaseManage.ExecuteDataSet(sb.ToString());
if (ds != null && ds.Tables.Count > 0)
{
return(ds.Tables[0]);
}
return(new DataTable());
}
/// <summary>
/// 根据DeptID取得user信息
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataTable GetUserInfoByDeptID(string deptid)
{
string sql = _SelectSql + " where deptid='" + deptid + "'";
return(DataBaseManage.ExecuteDataSet(sql).Tables[0]);
}
