/// <summary>
/// 添加操作日志
/// </summary>
/// <param name="log"></param>
/// <returns></returns>
public int InsertLog(OPLog log)
{
string sql = "";
sql = "INSERT INTO OPLog(UID,Module,What,IpAddress,CreateTime) VALUES(@UID,@Module,@What,@IpAddress,GETDATE())";
SqlParameter[] param = new SqlParameter[]
{
new SqlParameter("@UID", log.UID),
new SqlParameter("@Module", log.Module),
new SqlParameter("@What", ChangeValue.Base64Str(1, log.What)),
new SqlParameter("@IpAddress", log.IpAddress)
};
return(SqlHelper.ExecuteNonQuery(SqlHelper.DBConnStr, CommandType.Text, sql, param));
}
/// <summary>
/// 日志列表
/// </summary>
/// <param name="dic"></param>
/// <returns></returns>
public PagedList <OPLog> GetList(Dictionary <string, string> dic)
{
string sql = "";
try
{
int pageIndex = Convert.ToInt32(dic["pageIndex"]);
int pageSize = Convert.ToInt32(dic["pageSize"]);
string txtName = dic["txtName"];
string selName = dic["selName"].ToString();
string txtIP = dic["txtAdderss"];
string selIP = dic["selAdderss"].ToString();
string beginTime = dic["CreateTime"];
string endTime = dic["EndTime"];
string what = dic["txtWhat"];
List <SqlParameter> listParam = new List <SqlParameter>();
string whereSql = " WHERE 1=1 ";
if (selName == "1" && !string.IsNullOrEmpty(txtName))
{
whereSql += " AND u.UserName LIKE '%" + txtName + "%'";
}
else if (selName == "2" && !string.IsNullOrEmpty(txtName))
{
whereSql += " AND u.UserName =@UserName";
listParam.Add(new SqlParameter("@UserName", txtName));
}
if (selIP == "1" && !string.IsNullOrEmpty(txtIP))
{
whereSql += " AND l.IpAddress LIKE '%" + txtIP + "%'";
}
else if (selIP == "2" && !string.IsNullOrEmpty(txtIP))
{
whereSql += " AND l.IpAddress =@IpAddress";
listParam.Add(new SqlParameter("@IpAddress", txtIP));
}
if (!string.IsNullOrEmpty(beginTime) && !string.IsNullOrEmpty(endTime))
{
whereSql += " AND l.CreateTime BETWEEN '" + beginTime + "' AND '" + endTime + "' ";
}
else
{
if (!string.IsNullOrEmpty(beginTime))
{
whereSql += " AND l.CreateTime > '" + beginTime + "'";
}
if (!string.IsNullOrEmpty(endTime))
{
whereSql += " AND l.CreateTime < '" + endTime + "'";
}
}
if (!string.IsNullOrEmpty(what))
{
whereSql += " AND l.What LIKE '%" + ChangeValue.Base64Str(1, what) + "%'";
listParam.Add(new SqlParameter("@What", ChangeValue.Base64Str(1, what)));
}
SqlParameter[] param = listParam.ToArray();
sql = "SELECT * FROM ( SELECT ROW_NUMBER () OVER (ORDER BY l.ID DESC) PageNum ,l.*,u.UserName,l.What ShowWhat FROM OPLog l with(nolock) LEFT JOIN UserInfo u ON u.ID = l.UID " + whereSql + " ) temp WHERE temp.PageNum BETWEEN " + ((pageIndex - 1) * pageSize + 1) + " AND " + pageIndex * pageSize;
sql += " SELECT COUNT(0) FROM OPLog l LEFT JOIN UserInfo u ON u.ID = l.UID " + whereSql;
DataSet ds = SqlHelper.ExecuteDataset(SqlHelper.DBConnStr, CommandType.Text, sql, param);
DataSetConvert convert = new DataSetConvert(ds);
List <OPLog> list = convert.Get_ListModel <OPLog>();
return(new PagedList <OPLog>(list, pageIndex, pageSize, Convert.ToInt32(ds.Tables[1].Rows[0][0])));
}
catch (Exception ex)
{
Logger.ErrorLog(ex, new Dictionary <string, string>()
{
{ "Function", "OPLogDAL.GetList(Dictionary<string,string> dic)" },
{ "SQL", sql }
});
throw ex;
}
}
