public bool UpdateIServer() { int id = int.Parse(lblQuestionId.Text.ToString()); M_IServer iserver = serverBll.SeachById(id); B_User buser = new B_User(); iserver.UserId = buser.GetUserByName(hfusername.Value.Trim()).UserID; iserver.State = DropDownList1.SelectedValue.ToString(); iserver.Priority = DropDownList2.SelectedValue.ToString(); iserver.Root = DropDownList3.SelectedValue.ToString(); iserver.Type = DropDownList4.SelectedValue.ToString(); iserver.ReadCount = int.Parse(lblReadCount.Text.ToString()); iserver.SubTime = DataConverter.CDate(lblSubTime.Text.ToString()); if (DropDownList1.SelectedValue.ToString().Equals("已解决")) { iserver.SolveTime = DateTime.Now; } else { if (lblSolveTime.Text.ToString() == "") { iserver.SolveTime = DateTime.MinValue; } else { iserver.SolveTime = DataConverter.CDate(lblSolveTime.Text.ToString()); } } return(serverBll.Update(iserver)); }
private void SendEmailToUser(int userid, int QuestionId) { if (!UserEmail.Value.Trim().Equals("")) { // throw new Exception(userid +"*********"+QuestionId); MailInfo mailInfo = new MailInfo(); mailInfo.IsBodyHtml = true; M_UserInfo info = buser.GetUserByUserID(userid); //mailInfo.FromName = SiteConfig.SiteInfo.SiteName; mailInfo.FromName = info.UserName; M_IServer iserver = serverBll.SeachById(QuestionId); MailAddress address = new MailAddress(UserEmail.Value); mailInfo.ToAddress = address; string url = SiteConfig.SiteInfo.SiteUrl; if (!string.IsNullOrEmpty(url) && url.Substring(url.Length - 1) == ",") { url = url.Substring(0, url.Length - 1); } string EmailContent = "亲爱的[" + info.UserName + "]:<br/>您于" + iserver.SubTime.ToShortDateString() + "提交的问题已经处理!<br/>标题:<strong>" + iserver.Title + "</strong><br/>内容:" + textarea1.Value.ToString() + "<br/><br/>点此查看回复:<br/><a href='" + url + "/user/iServer/FiServerInfo?QuestionId=" + iserver.QuestionId + "'>" + url + "/user/iServer/FiServerInfo.aspx?QuestionId=" + iserver.QuestionId + "</a><br/><br/>" + SiteConfig.SiteInfo.SiteName + "<br/>" + DateTime.Now.ToLongDateString().ToString(); mailInfo.MailBody = EmailContent; mailInfo.Subject = SiteConfig.SiteInfo.SiteName + "有问必答_回复信息"; if (SendMail.Send(mailInfo) == ZoomLa.Components.SendMail.MailState.Ok) { //发送成功 } } }
public void Question_Add() { M_IServer isMod = new M_IServer(); isMod.UserId = mu.UserID; isMod.UserName = mu.UserName; isMod.Title = Request.Form["title_t"]; isMod.Content = Request.Form["txtContent"]; isMod.Priority = Request.Form["Priority"]; isMod.Type = Request.Form["Type"]; isMod.Root = "网页表单"; isMod.State = "未解决"; if (SafeSC.CheckIDS(Request.Form["CCUser_Hid"])) { isMod.CCUser = Request.Form["CCUser_Hid"]; } isMod.RequestTime = DataConverter.CDate(Request.QueryString["mydate_t"]); if (!string.IsNullOrEmpty(Request["OrderID"])) { isMod.OrderType = DataConverter.CLng(Request["OrderID"]); } isMod.Path = Request.Form["attach_hid"]; isMod.QuestionId = isBll.Insert(isMod); if (isMod.QuestionId > 0) { function.WriteSuccessMsg("提交成功", "FiServer?OrderID=" + isMod.OrderType); return; } else { function.WriteErrMsg("提交失败-可能是由于系统未开放功能所致"); return; } }
private void SendEmailToAdmin(int userid, int QuestionId) { string address = SiteConfig.MailConfig.MailServerList; string[] s = address.Split(','); for (int i = 0; i < s.Length; i++) { MailInfo mailInfo = new MailInfo(); mailInfo.IsBodyHtml = true; M_UserInfo info = buser.GetUserByUserID(userid); mailInfo.FromName = info.UserName; M_IServer iserver = serverBll.SeachById(QuestionId); string url = SiteConfig.SiteInfo.SiteUrl; if (!string.IsNullOrEmpty(url) && url.Substring(url.Length - 1) == ",") { url = url.Substring(0, url.Length - 1); } string admEmail = SiteConfig.SiteInfo.WebmasterEmail; mailInfo.ToAddress = new MailAddress(s[i]); string EmailContent = "亲爱的管理员:<br/>会员[" + info.UserName + "]的问题已经处理!<br/>标题:<strong>" + iserver.Title + "</strong><br/>内容:" + textarea1.Value.ToString() + "<br/><br/>点此查看回复:<br/><a href='" + url + "BiServerInfo.aspx?QuestionId=" + iserver.QuestionId + "'>" + url + "BiServerInfo.aspx?QuestionId=" + iserver.QuestionId + "</a><br/><br/>" + SiteConfig.SiteInfo.SiteName + "<br/>" + DateTime.Now.ToLongDateString().ToString(); mailInfo.MailBody = EmailContent; mailInfo.Subject = SiteConfig.SiteInfo.SiteName + "有问必答_回复信息"; if (SendMail.Send(mailInfo) == SendMail.MailState.Ok) { //成功 } } }
public ActionResult FiServerInfo() { string Menu = Request.QueryString["menu"] ?? ""; string Path = Request.QueryString["filepath"]; if (Menu.Equals("filedown") && !string.IsNullOrEmpty(Path)) { FileInfo file = new FileInfo(function.VToP(Path)); if (file.Exists) { SafeSC.DownFile(Path); } else { function.WriteErrMsg("文件不存在"); return(null); } } M_IServer serverMod = isBll.SelReturnModel(Mid); if (serverMod == null) { function.WriteErrMsg("问题不存在"); return(null); } //回复列表 ViewBag.replydt = repBll.SeachById(serverMod.QuestionId); //更新已读状态 repBll.GetUpdataState(1, serverMod.QuestionId); return(View(serverMod)); }
protected void LinkButton1_Click(object sender, EventArgs e) { B_User buser = new B_User(); M_IServer iserver = new M_IServer(); string strName = txtUserName.Text.Trim(); iserver.UserId = buser.GetUserByName(strName).UserID; iserver.Title = txtTitle.Text.ToString(); iserver.Content = textarea1.Value; iserver.Priority = this.DropDownList2.SelectedValue.ToString(); iserver.Type = this.DropDownList4.SelectedValue.ToString(); iserver.SubTime = DateTime.Now; iserver.Root = this.DropDownList3.SelectedValue.ToString(); iserver.State = this.DropDownList1.SelectedValue.ToString(); iserver.Path = Attach_Hid.Value; if (Request.Form["OrderID"] != null) { iserver.OrderType = DataConverter.CLng(Request.Form["OrderID"]); } else { iserver.OrderType = 0; } if (iserver.State.ToString().Equals("已解决")) { iserver.SolveTime = DateTime.Now; } if (strName == null || strName == "" || iserver.UserId <= 0) { function.WriteErrMsg("请输入正确的会员登录帐号"); return; } if (txtTitle.Text == "" || this.textarea1.Value == "" || txtTitle.Text == null || this.textarea1.Value == null) { function.WriteErrMsg("请输入标题或内容!"); return; } else { if (new B_IServer().Add(iserver)) { if (Request.Form["OrderID"] != null) { //Orderlistinfo.aspx?id=8 function.WriteSuccessMsg("添加成功!", "../Shop/Orderlistinfo.aspx?id=" + Request.Form["OrderID"]); } else { function.WriteSuccessMsg("添加成功!", "BiServer.aspx"); } } else { function.WriteErrMsg("添加失败"); return; } } }
protected void resultsRepeater_w_ItemCommand(object source, RepeaterCommandEventArgs e) { switch (e.CommandName) { case "Del": M_IServer model = Serverbll.SeachById(DataConverter.CLng(e.CommandArgument)); Serverbll.DeleteById(model.QuestionId); MyBind(); break; default: break; } }
public string IServer_API() { string action = Request["action"] ?? ""; M_IServer isMod = isBll.SelReturnModel(Mid); if (isMod == null) { return(""); } if (isMod.UserId != mu.UserID) { return("你无权操作该内容"); } switch (action) { //case "state": // { // int state = DataConverter.CLng(Request["state"]); // isBll.UpdateState(Mid,state); // } // break; case "solve": { isMod.State = isBll.GetStatus(3); isMod.SolveTime = DateTime.Now; isBll.UpdateByID(isMod); } break; case "close": { isBll.UpdateState(Mid, -1); } break; case "udel": //用户删除 { isBll.DeleteById(Mid); } break; } return(Success.ToString()); }
protected void Page_Load(object sender, EventArgs e) { B_Admin b_Admin = new B_Admin(); if (string.IsNullOrEmpty(Request.QueryString["QuestionId"])) { function.WriteErrMsg("不存在"); } int QuestionId = int.Parse(Request.QueryString["QuestionId"]); if (!string.IsNullOrEmpty(Request.QueryString["menu"]) && Request.QueryString["menu"] == "filedown") { string path = Request.QueryString["filepath"]; SafeSC.DownFile(path); //if (path != "") //{ // string filepath = Server.MapPath(path); // System.IO.FileInfo file = new System.IO.FileInfo(filepath); // if (file.Exists) // { // Response.Clear(); // Response.AddHeader("Content-Disposition", "attachment; filename=" + Server.UrlEncode(file.Name)); // Response.AddHeader("Content-Length", file.Length.ToString()); // Response.ContentType = "application/octet-stream"; // Response.Filter.Close(); // Response.WriteFile(file.FullName); // Response.End(); // } // else // { // Response.Write("<script>alert('该文件不存在!')</script>"); // } //} } if (!IsPostBack) { MyBind(QuestionId); M_IServer iserver = serverBll.SeachById(QuestionId); iserver.ReadCount = iserver.ReadCount + 1; serverBll.Update(iserver); } Call.SetBreadCrumb(Master, "<li><a href='" + CustomerPageAction.customPath2 + "I/Main.aspx'>工作台</a></li><li><a href='BiServer.aspx'>有问必答</a></li><li class='active'>问题详情</li>"); }
/// <summary> /// 绑定方法 /// </summary> /// <param name="QuestionId"></param> public void MyBind(int QuestionId) { B_User buser = new B_User(); M_IServer iserver = new M_IServer(); iserver = serverBll.SeachById(QuestionId); if (iserver == null) { function.WriteErrMsg("不存在"); } lblQuestionId.Text = iserver.QuestionId.ToString(); lblUserName.InnerHtml = " <a onclick=\"opentitle('../User/Userinfo.aspx?id=" + iserver.UserId + "','查看会员')\" href='###' title='查看会员'>" + GetUserName(iserver.UserId.ToString()) + "</a>"; hfusername.Value = GetUserName(iserver.UserId.ToString()); DropDownList1.Text = iserver.State.ToString(); DropDownList2.Text = iserver.Priority.ToString(); DropDownList3.Text = iserver.Root.ToString(); DropDownList4.Text = iserver.Type.ToString(); lblSubTime.Text = iserver.SubTime.ToString(); lblReadCount.Text = BaseClass.Htmlcode(iserver.ReadCount.ToString()); if (iserver.SolveTime == DateTime.MinValue) { lblSolveTime.Text = ""; } else { lblSolveTime.Text = iserver.SolveTime.ToString(); } if (!string.IsNullOrEmpty(iserver.Path)) { Quest_Attch_Hid.Value = iserver.Path.Trim('|'); Attch_Tr.Visible = true; } lblSubTime_R.Text = iserver.SubTime.ToString(); lblTitle_R.Text = BaseClass.Htmlcode(iserver.Title); lblName.Text = GetUserName(iserver.UserId.ToString()); lblConent.Text = iserver.Content.ToString(); lblSubTime_V.Text = iserver.SubTime.ToString(); lblUserName_V.Text = GetUserName(iserver.UserId.ToString()); UserEmail.Value = buser.GetUserByUserID(iserver.UserId).Email; resultsRepeater.DataSource = B_IServerReply.SeachById(QuestionId); resultsRepeater.DataBind(); }
public IActionResult FiServerInfo() { string Menu = RequestEx["menu"]; string Path = RequestEx["filepath"]; if (Menu.Equals("filedown") && !string.IsNullOrEmpty(Path)) { } M_IServer serverMod = isBll.SelReturnModel(Mid); if (serverMod == null) { return(WriteErr("问题不存在")); return(null); } //回复列表 ViewBag.replydt = repBll.SeachById(serverMod.QuestionId); //更新已读状态 repBll.GetUpdataState(1, serverMod.QuestionId); return(View(serverMod)); }
public bool UpdateByID(M_IServer model) { return(DBCenter.UpdateByID(model, model.QuestionId)); }
public bool UpdateByID(M_IServer model) { return(Sql.UpdateByIDs(strTableName, PK, model.QuestionId.ToString(), initMod.GetFieldAndPara(), initMod.GetParameters())); }
// 更新问题信息 public bool Update(M_IServer model) { UpdateByID(model); return(true); }
//添加问题 public bool Add(M_IServer model) { return(AddQuestion(model) > 0); }
public int AddQuestion(M_IServer model) { return(Sql.insertID(model.TbName, initMod.GetParameters(), initMod.GetParas(), initMod.GetFields())); }
public int Insert(M_IServer model) { return(DBCenter.Insert(model)); }