/// <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
}));
}
