public DataTable GetLogStat() { DataTable dtTotal = new DataTable("LogTotal"); DataColumn dc = new DataColumn("Desc"); dtTotal.Columns.Add(dc); dc = new DataColumn("Total"); dtTotal.Columns.Add(dc); string sql = "select * from " + DBHelperProxy.FormatFunction("gettables"); DataTable dt = DBHelperProxy.GetDataTable(sql); DataRow drr; foreach (DataRow dr in dt.Rows) { drr = dtTotal.NewRow(); drr["Desc"] = dr["table_name"]; drr["Total"] = DBHelperProxy.ExecuteScalar(string.Format("select count(*) as total from " + DBHelperProxy.FormatTable("{0}"), dr["Name"].ToString())); dtTotal.Rows.Add(drr); } return(dtTotal); }
public DataTable GetLoginLogs(string year, string month, string deptid, string username) { string sql = "Select LoginTime,UserID,U.LoginName,L.IP,U.UserName,U.DeptName From LoginLog L Inner Join " + DBHelperProxy.FormatTable("User") + " U On L.UserID=U.ID Where 1=1"; if (!string.IsNullOrEmpty(year)) { sql += " and " + DBHelperProxy.FormatFunction("getyear", "LoginTime") + " =" + year; } if (!string.IsNullOrEmpty(month)) { sql += " and " + DBHelperProxy.FormatFunction("getmonth", "LoginTime") + " =" + month; } if (!string.IsNullOrEmpty(deptid)) { sql += " and U.DeptID=" + deptid; } if (!string.IsNullOrEmpty(username)) { sql += " and U.UserName='******'"; } sql += " Order By L.ID Desc"; return(DBHelperProxy.GetDataTable(sql)); }
public DataTable GetOperateLogs(string tablename, string oType, string year, string month) { string sql = "Select ID,UnitID,OperateType,UserID,UserName,TableBind,OperateTime,OperateContent From " + DBHelperProxy.FormatTable("OperateLog") + " Where 1=1 "; if (!string.IsNullOrEmpty(tablename)) { sql += " and TableBind='" + tablename + "'"; } if (!string.IsNullOrEmpty(oType)) { sql += " and OperateType=" + oType; } if (!string.IsNullOrEmpty(year)) { sql += " and " + DBHelperProxy.FormatFunction("getyear", "OperateTime") + " =" + year; } if (!string.IsNullOrEmpty(month)) { sql += " and " + DBHelperProxy.FormatFunction("getmonth", "OperateTime") + " =" + month; } sql += " Order By ID Desc"; return(DBHelperProxy.GetDataTable(sql)); }
public DataTable GetLoginStat(string year, string month, string deptid) { string sql = "Select Count(*) as Total,U.LoginName,U.UserName,U.DeptName from LoginLog L Inner Join " + DBHelperProxy.FormatTable("User") + " U On L.UserID=U.ID Where 1=1"; if (!string.IsNullOrEmpty(year)) { sql += " and " + DBHelperProxy.FormatFunction("getyear", "LoginTime") + " =" + year; } if (!string.IsNullOrEmpty(month)) { sql += " and " + DBHelperProxy.FormatFunction("getmonth", "LoginTime") + " =" + month; } if (!string.IsNullOrEmpty(deptid)) { sql += " and U.DeptID=" + deptid; } sql += " Group by L.UserID,U.LoginName,U.Username,U.DeptName Order by Total desc"; return(DBHelperProxy.GetDataTable(sql)); }