/// <summary>
/// 查看日志列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-09</remarks>
public DataTable GetList(E_Log data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@StartDate", SqlDbType.SmallDateTime),
new SqlParameter("@EndDate", SqlDbType.SmallDateTime),
new SqlParameter("@PageIndex", SqlDbType.Int),
new SqlParameter("@PageSize", SqlDbType.Int),
new SqlParameter("@TotalCount", SqlDbType.Int)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.UserID;
parms[2].Value = data.Page.StartDate;
parms[3].Value = data.Page.EndDate;
parms[4].Value = data.Page.PageIndex;
parms[5].Value = data.Page.PageSize;
parms[6].Direction = ParameterDirection.Output;
DataTable dt = DbHelperSQL.RunProcedureTable("ProcEP_B_LogS_ListSelect", parms);
if (dt != null)
{
data.Page.TotalCount = Convert.ToInt32(parms[6].Value);
}
return(dt);
}
/// <summary>
/// 数据绑定
/// </summary>
protected void databind()
{
//------绑定用户列表------
E_User data = new E_User();
data.EnterpriseID = EnterpriceID;
data.Page = new MLMGC.DataEntity.E_Page();
data.Page.PageIndex = 1;
data.Page.PageSize = 1000;
DataTable dt = new T_User().GetEPList(data).Tables[0];
ddlObject.Items.Add(new ListItem("", ""));
foreach (DataRow dr in dt.Rows)
{
ddlObject.Items.Add(new ListItem(string.Format("{0}", dr["TrueName"]), dr["UserID"].ToString()));
}
//---------绑定数据列表-----------
string start = Requests.GetQueryString("start");
string end = Requests.GetQueryString("end");
int userid = Requests.GetQueryInt("userid", 0);
ddlObject.SelectedValue = userid.ToString();
E_Log log = new E_Log();
log.EnterpriseID = EnterpriceID;
log.UserID = userid;
log.Page = new MLMGC.DataEntity.E_Page();
log.Page.PageIndex = pageIndex;
log.Page.PageSize = pageSize;
if (start != "")
{
log.Page.StartDate = Convert.ToDateTime(start);
txtStartDate.Text = start;
}
if (end != "")
{
log.Page.EndDate = Convert.ToDateTime(end);
txtEndDate.Text = end;
}
DataTable dtList = new T_Log().GetList(log);
rpList.DataSource = dtList;
rpList.DataBind();
//设置分页样式
pageList1.PageSize = pageSize;
pageList1.CurrentPageIndex = pageIndex;
pageList1.RecordCount = log.Page.TotalCount;
pageList1.CustomInfoHTML = string.Format("共有记录 <span class='red_font'>{0}</span> 条", pageList1.RecordCount);
pageList1.TextAfterPageIndexBox = " 页/" + pageList1.PageCount + " ";
}
/// <summary>
/// 删除指定日期之前的日志
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-09</remarks>
public bool Delete(E_Log data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@Type", SqlDbType.TinyInt)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.Type;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_Log_Delete", parms, out ReturnValue);
return(ReturnValue >= 0);
}
protected void Delete(int type)
{
E_Log data = new E_Log();
data.EnterpriseID = EnterpriceID;
data.Type = type;
bool flag = new T_Log().Delete(data);
if (flag)
{
Jscript.AlertAndRedirect(this, "删除成功", "LogList.aspx");
}
else
{
Jscript.ShowMsg("删除失败", this);
}
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-09</remarks>
public bool Add(E_Log data)
{
SqlParameter[] parms =
{
new SqlParameter("@EnterpriseID", SqlDbType.Int),
new SqlParameter("@UserID", SqlDbType.Int),
new SqlParameter("@LogTitle", SqlDbType.VarChar,512),
new SqlParameter("@IP", SqlDbType.VarChar, 64)
};
parms[0].Value = data.EnterpriseID;
parms[1].Value = data.UserID;
parms[2].Value = data.LogTitle;
parms[3].Value = data.IP;
int ReturnValue;
DbHelperSQL.RunProcedures("ProcEP_B_Log_Insert", parms, out ReturnValue);
return(ReturnValue > 0);
}
/// <summary>
/// 删除指定日期之前的日志
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-09</remarks>
public bool Delete(E_Log data)
{
return(dal.Delete(data));
}
/// <summary>
/// 查看日志列表
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-09</remarks>
public DataTable GetList(E_Log data)
{
return(dal.GetList(data));
}
/// <summary>
/// 添加日志
/// </summary>
/// <param name="data"></param>
/// <returns></returns>
/// <remarks>tianzhenyun 2012-01-09</remarks>
public bool Add(E_Log data)
{
return(dal.Add(data));
}
