/// <summary> /// 获取问题实体 /// </summary> /// <param name="issueID"></param> /// <returns></returns> public GameIssueInfo GetGameIssueInfo(int issueID) { string sqlQuery = string.Format("(NOLOCK) WHERE IssueID= {0}", issueID); GameIssueInfo gameIssue = aideGameIssueProvider.GetObject <GameIssueInfo>(sqlQuery); return(gameIssue); }
/// <summary> /// 更新问题 /// </summary> /// <param name="gameIssue"></param> public void UpdateGameIssue(GameIssueInfo gameIssue) { StringBuilder sqlQuery = new StringBuilder( ); sqlQuery.Append("UPDATE GameIssueInfo SET ") .Append("IssueTitle=@IssueTitle ,") .Append("IssueContent=@IssueContent,") .Append("Nullity= @Nullity ,") .Append("ModifyDate= @ModifyDate ") .Append("WHERE IssueID= @IssueID"); var prams = new List <DbParameter>( ); prams.Add(Database.MakeInParam("IssueTitle", gameIssue.IssueTitle)); prams.Add(Database.MakeInParam("IssueContent", gameIssue.IssueContent)); prams.Add(Database.MakeInParam("Nullity", gameIssue.Nullity)); prams.Add(Database.MakeInParam("ModifyDate", gameIssue.ModifyDate)); prams.Add(Database.MakeInParam("IssueID", gameIssue.IssueID)); // SqlParameter[] ad = { new SqlParameter("", "") }; Database.ExecuteNonQuery(CommandType.Text, sqlQuery.ToString( ), prams.ToArray( )); }
private void GameIssueDataBind() { if (StrCmd == "add") { litInfo.Text = "新增"; } else { litInfo.Text = "更新"; } if (IntParam <= 0) { return; } //获取问题信息 GameIssueInfo issue = aideNativeWebFacade.GetGameIssueInfo(IntParam); if (issue == null) { ShowError("问题信息不存在"); Redirect("IssueList.aspx"); return; } CtrlHelper.SetText(txtIssueTitle, issue.IssueTitle); rbtnNullity.SelectedValue = issue.Nullity.ToString().Trim(); CtrlHelper.SetText(txtIssueContent, issue.IssueContent); }
public GameIssueInfo GetIssueByIssueID(int typeID, int issueID, byte mode) { GameIssueInfo result; switch (mode) { case 1: { GameIssueInfo gameIssueInfo = base.Database.ExecuteObject <GameIssueInfo>(string.Format("SELECT * FROM GameIssueInfo(NOLOCK) WHERE TypeID={0} AND Nullity=0 AND IssueID>{1} ORDER BY CollectDate ASC", typeID, issueID)); result = gameIssueInfo; break; } case 2: { GameIssueInfo gameIssueInfo = base.Database.ExecuteObject <GameIssueInfo>(string.Format("SELECT * FROM GameIssueInfo(NOLOCK) WHERE TypeID={0} AND Nullity=0 AND IssueID<{1} ORDER BY CollectDate DESC", typeID, issueID)); result = gameIssueInfo; break; } default: { GameIssueInfo gameIssueInfo = base.Database.ExecuteObject <GameIssueInfo>(string.Format("SELECT * FROM GameIssueInfo(NOLOCK) WHERE Nullity=0 AND IssueID={0}", issueID)); result = gameIssueInfo; break; } } return(result); }
/// <summary> /// 增加问题 /// </summary> /// <param name="info"></param> /// <returns></returns> public Message InsertGameIssueInfo(GameIssueInfo info) { List <DbParameter> parms = new List <DbParameter>(); parms.Add(Database.MakeInParam("issueTitle", info.IssueTitle)); parms.Add(Database.MakeInParam("issueContent", info.IssueContent)); parms.Add(Database.MakeInParam("nullity", info.Nullity)); parms.Add(Database.MakeInParam("collectDate", info.CollectDate)); parms.Add(Database.MakeInParam("modifyDate", info.ModifyDate)); return(MessageHelper.GetMessage(Database, "NET_PW_InsertGameIssueInfo", parms)); }
/// <summary> /// 增加页面标题 /// </summary> protected override void AddHeaderTitle() { GameIssueInfo issure = FacadeManage.aideNativeWebFacade.GetIssueByIssueID(IntParam, 0); if (issure != null) { AddMetaTitle(issure.IssueTitle + " - " + ApplicationSettings.Get("title")); } AddMetaKeywords(ApplicationSettings.Get("keywords")); AddMetaDescription(ApplicationSettings.Get("description")); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GameIssueInfo issure = webFacade.GetIssueByIssueID(issueID, 0); if (issure != null) { title = issure.IssueTitle; content = Utility.HtmlDecode(issure.IssueContent); } GameIssueInfo issure1 = webFacade.GetIssueByIssueID(issueID, 1); if (issure1 != null) { this.linLast1.Title = "上一篇新闻:" + issure1.IssueTitle; this.linLast1.HRef = "/Service/IssueView.aspx?XID=" + issure1.IssueID; this.linLast2.Title = "上一篇新闻:" + issure1.IssueTitle; this.linLast2.HRef = "/Service/IssueView.aspx?XID=" + issure1.IssueID; } else { this.linLast1.Title = "已经是第一篇了!"; this.linLast1.Disabled = true; this.linLast1.Visible = false; this.linLast2.Title = "已经是第一篇了!"; this.linLast2.Disabled = true; this.linLast2.Visible = false; } GameIssueInfo issure2 = webFacade.GetIssueByIssueID(issueID, 2); if (issure2 != null) { this.linNext1.Title = "下一篇新闻:" + issure2.IssueTitle; this.linNext1.HRef = "/Service/IssueView.aspx?XID=" + issure2.IssueID; this.linNext2.Title = "下一篇新闻:" + issure2.IssueTitle; this.linNext2.HRef = "/Service/IssueView.aspx?XID=" + issure2.IssueID; } else { this.linNext1.Title = "已经是最后一篇了!"; this.linNext1.Disabled = true; this.linNext1.Visible = false; this.linNext2.Title = "已经是最后一篇了!"; this.linNext2.Disabled = true; this.linNext2.Visible = false; } } Themes.Standard.Common_Header sHeader = (Themes.Standard.Common_Header) this.FindControl("sHeader"); sHeader.title = "客服中心"; }
private void ProcessData() { if (!IsValid) { return; } GameIssueInfo issue = new GameIssueInfo(); issue.IssueTitle = CtrlHelper.GetText(txtIssueTitle); issue.IssueContent = CtrlHelper.GetText(txtIssueContent); issue.TypeID = CtrlHelper.GetSelectValue(ddlTypeID, 1); issue.Nullity = Convert.ToByte(rbtnNullity.SelectedValue.Trim()); if (string.IsNullOrEmpty(issue.IssueContent)) { ShowError("请输入问题内容"); return; } Message msg = new Message(); if (StrCmd == "add") { //判断权限 AuthUserOperationPermission(Permission.Add); msg = FacadeManage.aideNativeWebFacade.InsertGameIssue(issue); } else { //判断权限 AuthUserOperationPermission(Permission.Edit); issue.IssueID = IntParam; msg = FacadeManage.aideNativeWebFacade.UpdateGameIssue(issue); } if (msg.Success) { if (StrCmd == "add") { ShowInfo("问题信息增加成功", "IssueList.aspx", 1200); } else { ShowInfo("问题信息修改成功", "IssueList.aspx", 1200); } } else { ShowError(msg.Content); } }
public void InsertGameIssue(GameIssueInfo gameIssue) { System.Data.DataRow dataRow = this.aideGameIssueProvider.NewRow(); dataRow["IssueID"] = gameIssue.IssueID; dataRow["IssueTitle"] = gameIssue.IssueTitle; dataRow["IssueContent"] = gameIssue.IssueContent; dataRow["TypeID"] = gameIssue.TypeID; dataRow["Nullity"] = gameIssue.Nullity; dataRow["Hot"] = gameIssue.Hot; dataRow["CollectDate"] = gameIssue.CollectDate; dataRow["ModifyDate"] = gameIssue.ModifyDate; this.aideGameIssueProvider.Insert(dataRow); }
/// <summary> /// 新增问题 /// </summary> /// <param name="gameIssue"></param> public void InsertGameIssue(GameIssueInfo gameIssue) { DataRow dr = aideGameIssueProvider.NewRow( ); dr[GameIssueInfo._IssueID] = gameIssue.IssueID; dr[GameIssueInfo._IssueTitle] = gameIssue.IssueTitle; dr[GameIssueInfo._IssueContent] = gameIssue.IssueContent; dr[GameIssueInfo._Nullity] = gameIssue.Nullity; dr[GameIssueInfo._CollectDate] = gameIssue.CollectDate; dr[GameIssueInfo._ModifyDate] = gameIssue.ModifyDate; aideGameIssueProvider.Insert(dr); }
public void UpdateGameIssue(GameIssueInfo gameIssue) { System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(); stringBuilder.Append("UPDATE GameIssueInfo SET ").Append("IssueTitle=@IssueTitle ,").Append("IssueContent=@IssueContent,").Append("TypeID=@TypeID,").Append("Nullity= @Nullity ,").Append("Hot= @Hot ,").Append("ModifyDate= @ModifyDate ").Append("WHERE IssueID= @IssueID"); System.Collections.Generic.List <System.Data.Common.DbParameter> list = new System.Collections.Generic.List <System.Data.Common.DbParameter>(); list.Add(base.Database.MakeInParam("IssueTitle", gameIssue.IssueTitle)); list.Add(base.Database.MakeInParam("IssueContent", gameIssue.IssueContent)); list.Add(base.Database.MakeInParam("TypeID", gameIssue.TypeID)); list.Add(base.Database.MakeInParam("Nullity", gameIssue.Nullity)); list.Add(base.Database.MakeInParam("Hot", gameIssue.Hot)); list.Add(base.Database.MakeInParam("ModifyDate", gameIssue.ModifyDate)); list.Add(base.Database.MakeInParam("IssueID", gameIssue.IssueID)); base.Database.ExecuteNonQuery(System.Data.CommandType.Text, stringBuilder.ToString(), list.ToArray()); }
public ActionResult QuestionInfo() { int num = TypeUtil.ObjectToInt(base.Request["param"]); GameIssueInfo gameIssueInfo = new GameIssueInfo(); if (num > 0) { gameIssueInfo = FacadeManage.aideNativeWebFacade.GetGameIssueInfo(num); if (gameIssueInfo == null) { return(Redirect("/Customer/QuestionList")); } } return(View(gameIssueInfo)); }
/// <summary> /// 新增问题 /// </summary> /// <param name="gameIssue"></param> public string AddGameIssue(HttpRequest req) { GameIssueInfo info = new GameIssueInfo(); string content = req["issueContent"]; info.IssueTitle = content.Length > 20 ? content.Substring(0, 20) + "..." : content; info.IssueContent = req["issueContent"]; info.QQ = req["qq"]; info.Nullity = 0; info.CollectDate = DateTime.Now; info.ModifyDate = DateTime.Now; try { aideNativeWebFacade.InsertGameIssueInfo(info); return(JsonResultHelper.GetSuccessJson("保存成功!")); } catch (Exception ex) { return(JsonResultHelper.GetErrorJson(ex.Message)); } }
private void ProcessData() { GameIssueInfo issue = new GameIssueInfo(); issue.IssueTitle = CtrlHelper.GetText(txtIssueTitle); issue.IssueContent = CtrlHelper.GetText(txtIssueContent); issue.Nullity = Convert.ToByte(rbtnNullity.SelectedValue.Trim()); Message msg = new Message(); if (StrCmd == "add") { //判断权限 AuthUserOperationPermission(Permission.Add); msg = aideNativeWebFacade.InsertGameIssue(issue); } else { //判断权限 AuthUserOperationPermission(Permission.Edit); issue.IssueID = IntParam; msg = aideNativeWebFacade.UpdateGameIssue(issue); } if (msg.Success) { if (StrCmd == "add") { ShowInfo("问题信息增加成功", "IssueList.aspx", 1200); } else { ShowInfo("问题信息修改成功", "IssueList.aspx", 1200); } } else { ShowError(msg.Content); } }
/// <summary> /// 获取问题实体 /// </summary> /// <param name="issueID"></param> /// <param name="mode">模式选择, 0=当前主题, 1=上一主题, 2=下一主题</param> /// <returns></returns> public GameIssueInfo GetIssueByIssueID(int issueID, byte mode) { GameIssueInfo Issue = null; switch (mode) { case 2: Issue = Database.ExecuteObject <GameIssueInfo>(string.Format("SELECT * FROM GameIssueInfo(NOLOCK) WHERE Nullity=-0 AND IssueID<{0} ORDER BY CollectDate DESC", issueID)); break; case 1: Issue = Database.ExecuteObject <GameIssueInfo>(string.Format("SELECT * FROM GameIssueInfo(NOLOCK) WHERE Nullity=0 AND IssueID>{0} ORDER BY CollectDate ASC", issueID)); break; case 0: default: Issue = Database.ExecuteObject <GameIssueInfo>(string.Format("SELECT * FROM GameIssueInfo(NOLOCK) WHERE Nullity=0 AND IssueID={0}", issueID)); break; } return(Issue); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { GameIssueInfo issure = FacadeManage.aideNativeWebFacade.GetIssueByIssueID(IntParam, 0); if (issure != null) { title = issure.IssueTitle; content = Utility.HtmlDecode(issure.IssueContent); } GameIssueInfo issure1 = FacadeManage.aideNativeWebFacade.GetIssueByIssueID(1, IntParam, 1); if (issure1 != null) { this.linLast.Title = "上一篇新闻:" + issure1.IssueTitle; this.linLast.HRef = "/Service/FaqInfo.aspx?param=" + issure1.IssueID; } else { this.linLast.Title = "已经是第一篇了!"; this.linLast.Disabled = true; this.linLast.Visible = false; } GameIssueInfo issure2 = FacadeManage.aideNativeWebFacade.GetIssueByIssueID(1, IntParam, 2); if (issure2 != null) { this.linNext.Title = "下一篇新闻:" + issure2.IssueTitle; this.linNext.HRef = "/Service/FaqInfo.aspx?param=" + issure2.IssueID; } else { this.linNext.Title = "已经是最后一篇了!"; this.linNext.Disabled = true; this.linNext.Visible = false; } } }
public Message InsertGameIssueInfo(GameIssueInfo info) { return(aideNativeWebDataProvider.InsertGameIssueInfo(info)); }
/// <summary> /// 更新问题 /// </summary> /// <param name="gameIssue"></param> public Message UpdateGameIssue(GameIssueInfo gameIssue) { aideNativeWebData.UpdateGameIssue(gameIssue); return(new Message(true)); }
/// <summary> /// 新增问题 /// </summary> /// <param name="gameIssue"></param> public Message InsertGameIssue(GameIssueInfo gameIssue) { aideNativeWebData.InsertGameIssue(gameIssue); return(new Message(true)); }
public JsonResult DoQuestionInfo(GameIssueInfo entity) { if (entity == null) { return(Json(new { IsOk = false, Msg = "没有提交任何数据" })); } if (string.IsNullOrEmpty(entity.IssueTitle)) { return(Json(new { IsOk = false, Msg = "请输入问题标题" })); } if (string.IsNullOrEmpty(entity.IssueContent)) { return(Json(new { IsOk = false, Msg = "请输入问题内容" })); } Message message = new Message(); if (entity.IssueID < 1) { if (user != null) { AdminPermission adminPermission = new AdminPermission(user, user.MoudleID); if (!adminPermission.GetPermission(2L)) { return(Json(new { IsOk = false, Msg = "没有权限", Url = "/NoPower/Index" })); } } message = (message = FacadeManage.aideNativeWebFacade.InsertGameIssue(entity)); } else { if (user != null) { AdminPermission adminPermission2 = new AdminPermission(user, user.MoudleID); if (!adminPermission2.GetPermission(4L)) { return(Json(new { IsOk = false, Msg = "没有权限", Url = "/NoPower/Index" })); } } message = FacadeManage.aideNativeWebFacade.UpdateGameIssue(entity); } if (message.Success) { return(Json(new { IsOk = true, Msg = "操作成功" })); } return(Json(new { IsOk = false, Msg = message.Content })); }