/// <summary> /// 获取权限 1增加 2删除 3修改 4查询 /// </summary> /// <returns></returns> //public bool GetQx() //{ //} /// <summary> /// 添加日志 /// </summary> public void AddLog(int OperateID, int OperateType, DateTime OperateTime, string Remark) { try { Model.OperationLogInfo operlog = new Model.OperationLogInfo(); operlog.OperateID = OperateID; operlog.OperateType = OperateType; operlog.OperateTime = OperateTime; operlog.Remark = Remark; int result = new BLL.OperationLogInfo().Add(operlog); } catch (Exception ec) { Page.ClientScript.RegisterStartupScript(GetType(), "<script>alert('" + ec.Message + "')</script>", ""); throw; } }
/// <summary> /// 删除记录 /// </summary> /// <returns></returns> public bool delRecord(string flag) { bool result = false; switch (flag) { case "1": result = new BLL.OperationLogInfo().DeleteList(" select ID from OperationLogInfo where OperateType=1 and OperateTime >= '" + txtqs.Text.Trim() + "' and OperateTime <= '" + txtjs.Text.Trim() + "' "); break; case "2": result = new BLL.OperationLogInfo().DeleteList(" select ID from OperationLogInfo where OperateType=2 and OperateTime >= '" + txtqs.Text.Trim() + "' and OperateTime <= '" + txtjs.Text.Trim() + "'"); break; case "3": result = new BLL.OperationLogInfo().DeleteList(" select ID from OperationLogInfo where OperateType=3 and OperateTime >= '" + txtqs.Text.Trim() + "' and OperateTime <= '" + txtjs.Text.Trim() + "'"); break; case "4": result = new BLL.UserChartInfo().DeleteList(" select GRID from GameRoundInfo where GRStartTime>=" + GetConversion(txtqs.Text.Trim()) + " and GRStartTime<=" + GetConversion(txtjs.Text.Trim()) + " "); result = new BLL.GameRoundInfo().DeleteList(" select GRID from GameRoundInfo where GRStartTime>=" + GetConversion(txtqs.Text.Trim()) + " and GRStartTime<=" + GetConversion(txtjs.Text.Trim()) + " "); break; case "5": break; case "6": break; } return(result); }