public void Add(M_ViewLog model) { SqlParameter[] commandParameters = new SqlParameter[] { new SqlParameter("@UserId", model.UserId), new SqlParameter("@UserName", model.UserName), new SqlParameter("@ModelType", model.ModelType), new SqlParameter("@InfoId", model.InfoId), new SqlParameter("@AddTime", model.AddTime) }; SqlHelper.ExecuteNonQuery(SqlHelper.ConnectionStringKy, CommandType.StoredProcedure, "Up_ViewLog_Add", commandParameters); }
protected void Page_Load(object sender, EventArgs e) { Response.Cache.SetNoStore(); if (!string.IsNullOrEmpty(Request.Form["tablename"]) && !string.IsNullOrEmpty(Request.Form["paramstr"]) && !string.IsNullOrEmpty(Request.Form["id"]) & !string.IsNullOrEmpty(Request.Form["pageindex"]) && !string.IsNullOrEmpty(Request.Form["pagecount"])) { try { TableName = Request.Form["tablename"]; ParamStr = Request.Form["paramstr"]; InfoId = int.Parse(Request.Form["id"]); PageIndex = int.Parse(Request.Form["pageindex"]); PageCount = int.Parse(Request.Form["pagecount"]); } catch { } } if (ParamStr.Length == 0 || InfoId == 0) { return; } DataRow dr = CreateBll.GetInfoById(TableName, InfoId); if (!UserBll.IsLogin()) { HiddenContent = CreateBll.Info_Ajax(ParamStr, dr, PageIndex, PageCount,0); Response.Write(HiddenContent); return; } int pointCount = int.Parse(dr["pointcount"].ToString()); M_User userLoginModel = UserBll.GetCookie(); M_User userModel = UserBll.GetUser(userLoginModel.UserID); int userId = userModel.UserID; string userName = userModel.LogName; string userGroupId = userModel.GroupID.ToString(); decimal goldNum = userModel.YellowBoy; DateTime userExpirtTime = userModel.ExpireTime; userLoginModel = null; M_UserGroup userGroupModel = UserGroupBll.GetModel(userModel.GroupID); string powerStr = userGroupModel.ColumnPower; int payType = (int)dr["chargetype"]; string title = (string)dr["title"]; int reduceType = int.Parse(UserGroupBll.Power_UserGroup("ChargingType", 0, powerStr));//重复计费方式 int dayViewCount = int.Parse(UserGroupBll.Power_UserGroup("SmashMoney", 0, powerStr));//有效期每天最大浏览次数 int chargeHourCount = (int)dr["chargehourcount"]; int chargViewCount = (int)dr["chargeviewcount"]; int modelId = (int)dr["modelid"]; string msg = string.Empty; bool isPay = false;//是否付费 isPay = userLogBll.CheckIsPay(payType, modelId, InfoId, userId, chargeHourCount, chargViewCount); if (!isPay) { HiddenContent = CreateBll.Info_Ajax(ParamStr, dr, PageIndex, PageCount, 1); Response.Write(HiddenContent); return; } else { HiddenContent = CreateBll.Info_Ajax(ParamStr, dr, PageIndex, PageCount, 2); if (PageIndex == 1) { M_ViewLog viewLogModel = new M_ViewLog(); viewLogModel.UserId = userModel.UserID; viewLogModel.UserName = userModel.LogName; viewLogModel.ModelType = modelId; viewLogModel.InfoId = InfoId; viewLogModel.AddTime = DateTime.Now; viewLogBll.Add(viewLogModel); } Response.Write(HiddenContent); return; } }
protected void Page_Load(object sender, EventArgs e) { DownLoadBll.ClearDownCount(); if (!string.IsNullOrEmpty(Request.QueryString["SId"])) { try { SId = int.Parse(Request.QueryString["SId"]); } catch { } } if (!string.IsNullOrEmpty(Request.QueryString["AId"])) { try { AId = int.Parse(Request.QueryString["AId"]); } catch { } } DataRow adr = DownAddressBll.GetAddressPath(AId,SId); if (adr == null) { Function.ShowMsg(0,"<li>访问的内容不存在或已经被删除</li>"); } int Id = (int)adr["downloaddataid"]; DataRow dr = CreateBll.GetInfoById("kydownloaddata", Id); if (dr == null) { Function.ShowMsg(0,"<li>访问的内容不存在或已经被删除</li>"); return; } bool server_isOpened = adr["isopened"].ToString() == string.Empty ||(bool)adr["isopened"]?true:false; if (!server_isOpened) { Function.ShowMsg(0,"<li>所属服务器已经被管理员禁用</li>"); return; } InfoModel = InfoModelBll.GetModel(3); if (InfoModel == null) { Function.ShowMsg(0,"<li>所属内容模型不存在或已经被删除</li>"); return; } CheckUrl(); int chId = (int)dr["chid"]; int colId = (int)dr["colid"]; string title = (string)dr["title"]; int pointCount = (int)dr["pointcount"]; int payType = (int)dr["chargetype"]; int isOpened = (int)dr["isopened"]; string groupIdStr = (string)dr["groupidstr"]; bool colIsOpened = (bool)dr["colisopened"]; int chargeHourCount = (int)dr["chargehourcount"]; int chargViewCount = (int)dr["chargeviewcount"]; if (pointCount > 0 || isOpened == 0 || (isOpened == 2 && !colIsOpened)) { M_User userLoginModel = UserBll.GetCookie(); M_User userModel = UserBll.GetUser(userLoginModel.UserID); int userId = userModel.UserID; string userName = userModel.LogName; string userGroupId = userModel.GroupID.ToString(); decimal goldNum = userModel.YellowBoy; DateTime userExpirtTime = userModel.ExpireTime; userLoginModel = null; M_UserGroup userGroupModel = UserGroupBll.GetModel(userModel.GroupID); string powerStr = userGroupModel.ColumnPower; #region 继承栏目认证 if (isOpened == 2 && !colIsOpened) { bool isAccess = UserGroupBll.Power_ColumnPower(chId, colId, powerStr, 1); if (!isAccess) { Function.ShowMsg(0,"<li>您所在的用户组无法访问该内容,请联系系统管理员</li>"); } } #endregion #region 内容认证 if (isOpened == 0 && groupIdStr.IndexOf("|" + userGroupId + "|") == -1) { Function.ShowMsg(0,"<li>您所在的用户组无法访问该内容,请联系系统管理员</li>"); } #endregion #region 收费 if (pointCount > 0) { int reduceType = int.Parse(UserGroupBll.Power_UserGroup("ChargingType", 0, powerStr));//重复计费方式 int dayViewCount = int.Parse(UserGroupBll.Power_UserGroup("SmashMoney", 0, powerStr));//有效期每天最大浏览次数 string msg = string.Empty; bool isPay = false;//是否付费 isPay = userLogBll.CheckIsPay(payType, ModelId, Id, userId, chargeHourCount, chargViewCount); if (!isPay) { bool flag = userLogBll.CheckReducePointCondition(reduceType, userId, goldNum, pointCount, userExpirtTime, dayViewCount, ref msg); if (!flag)//不满足扣费条件 { Function.ShowMsg(0,"<li>" + msg + "</li>"); } else { //flag = userLogBll.ReducePoint(reduceType,pointCount,ModelId,Id,title,userId,userExpirtTime); flag = userLogBll.ReducePoint(reduceType, pointCount, ModelId, Id, title, userId, userExpirtTime, userName, dayViewCount); if (!flag) { Function.ShowMsg(0,"<li>扣费失败</li>"); } } } M_ViewLog viewLogModel = new M_ViewLog(); viewLogModel.UserId = userModel.UserID; viewLogModel.UserName = userModel.LogName; viewLogModel.ModelType = 1; viewLogModel.InfoId = Id; viewLogModel.AddTime = DateTime.Now; viewLogBll.Add(viewLogModel); } #endregion DownLoadBll.SetDownCount(Id); Response.Redirect(GetUrl(adr)); } else { DownLoadBll.SetDownCount(Id); Response.Redirect(GetUrl(adr)); } }
public void Add(M_ViewLog model) { this.dal.Add(model); }