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