/// <summary> /// 更新一条数据 /// </summary> public bool Update(eChartProject.Model.eChart.server_contents_answers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update server_contents_answers set "); strSql.Append("MessageID=@MessageID,"); strSql.Append("Answer=@Answer,"); strSql.Append("isDeleted=@isDeleted"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@MessageID", MySqlDbType.Int32, 11), new MySqlParameter("@Answer", MySqlDbType.VarChar, 4000), new MySqlParameter("@isDeleted", MySqlDbType.Bit, 1), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.MessageID; parameters[1].Value = model.Answer; parameters[2].Value = model.isDeleted; parameters[3].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string selectid = Request.Form["selectid"]; if (selectid.Contains(Nodetype.message.ToString())) { selectid = selectid.Remove(0, Nodetype.message.ToString().Length); //get answer eChartProject.Model.eChart.server_contents_answers modelans = new eChartProject.Model.eChart.server_contents_answers(); DataSet ds = abll.GetList(" messageID=" + int.Parse(selectid)); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string strAnswer = ds.Tables[0].Rows[0]["Answer"].ToString(); Response.Write(strAnswer); Response.End(); } } } catch { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string foldername = Request.Form["foldername"]; string selectid = Request.Form["selectid"]; string message = Request.Form["message"]; if (selectid.Contains("root")) { selectid = selectid.Remove(0, "root".Length); eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders(); model.Foldername = foldername.Trim(); model.ParentID = int.Parse(selectid); model.isDeleted = 1; model.isOffline = 0; Fbll.Add(model); Response.Write("success"); Response.End(); } else if (selectid.Contains("folder")) { selectid = selectid.Remove(0, "folder".Length); //insert message eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.Question = message.Trim(); model.FolderID = int.Parse(selectid); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 0; model.RelatedID = 0; model.sortOrder = SortOrderHelper.GetSortOrder(model.FolderID); model.isDeleted = 1; bll.Add(model); //insert answer eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers(); ansmodel.Answer = ""; ansmodel.MessageID = bll.GetMaxId() - 1; ansmodel.isDeleted = 0; abll.Add(ansmodel); Response.Write("success"); Response.End(); } } catch { } } }
public void PasteFromCopy() { try { if (toID.Contains(Nodetype.message.ToString())) { int iMsgID = int.Parse(toID.Remove(0, Nodetype.message.ToString().Length)); int iToFolderID = int.Parse(ID.Remove(0, Nodetype.folder.ToString().Length)); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model = bll.GetModel(iMsgID); model.FolderID = iToFolderID; model.sortOrder = SortOrderHelper.GetSortOrder(iToFolderID); bll.Add(model); int newID = bll.GetMaxId() - 1; //add variation DataSet ds = bll.GetList(" relatedid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { model.ID = int.Parse(dr["ID"].ToString()); model.RelatedID = newID; model.Question = dr["Question"].ToString(); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 1;//设置成true model.isDeleted = 1; model.FolderID = null; model.sortOrder = null; bll.Add(model); } } eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers(); //if answer exist, update answer ,else if answer not exist,add answer ds = abll.GetList(" messageid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //insert answer with answer content ansmodel.Answer = ds.Tables[0].Rows[0]["answer"].ToString(); ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } else { //insert answer without content ansmodel.Answer = ""; ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } } } catch { } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string ruleid = Request.Form["ruleid"]; RuleBll.Delete(int.Parse(ruleid)); string selectid = Request.Form["selectid"]; string answer = Request.Form["answer"]; selectid = selectid.Remove(0, Nodetype.message.ToString().Length); eChartProject.Model.eChart.server_contents_answers modelans = new eChartProject.Model.eChart.server_contents_answers(); DataSet ds = abll.GetList(" messageID=" + int.Parse(selectid)); //update the answer of message if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string ID = ds.Tables[0].Rows[0]["ID"].ToString(); modelans.ID = int.Parse(ID); modelans.Answer = answer.Trim(); modelans.MessageID = int.Parse(selectid); modelans.isDeleted = 0; abll.Update(modelans); } //if all rule deleted, update the message ispublic tag to true eChartProject.Model.eChart.server_contents_rule modelrule = new eChartProject.Model.eChart.server_contents_rule(); DataSet dsRule = RuleBll.GetList(" messageID=" + int.Parse(selectid)); if (dsRule != null && dsRule.Tables != null && dsRule.Tables.Count > 0 && dsRule.Tables[0].Rows.Count == 0) { eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.isPublic = 1; model.ID = int.Parse(selectid); bll.UpdateByIsPublic(model); } Response.Write("success"); Response.End(); } catch { } } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(eChartProject.Model.eChart.server_contents_answers model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into server_contents_answers("); strSql.Append("MessageID,Answer,isDeleted)"); strSql.Append(" values ("); strSql.Append("@MessageID,@Answer,@isDeleted)"); MySqlParameter[] parameters = { new MySqlParameter("@MessageID", MySqlDbType.Int32, 11), new MySqlParameter("@Answer", MySqlDbType.VarChar, 4000), new MySqlParameter("@isDeleted", MySqlDbType.Bit, 1) }; parameters[0].Value = model.MessageID; parameters[1].Value = model.Answer; parameters[2].Value = model.isDeleted; DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public eChartProject.Model.eChart.server_contents_answers GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,MessageID,Answer,isDeleted from server_contents_answers "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; eChartProject.Model.eChart.server_contents_answers model = new eChartProject.Model.eChart.server_contents_answers(); DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters); if (ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["ID"] != null && ds.Tables[0].Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if (ds.Tables[0].Rows[0]["MessageID"] != null && ds.Tables[0].Rows[0]["MessageID"].ToString() != "") { model.MessageID = int.Parse(ds.Tables[0].Rows[0]["MessageID"].ToString()); } if (ds.Tables[0].Rows[0]["Answer"] != null && ds.Tables[0].Rows[0]["Answer"].ToString() != "") { model.Answer = ds.Tables[0].Rows[0]["Answer"].ToString(); } if (ds.Tables[0].Rows[0]["isDeleted"] != null && ds.Tables[0].Rows[0]["isDeleted"].ToString() != "") { model.isDeleted = int.Parse(ds.Tables[0].Rows[0]["isDeleted"].ToString()); } return(model); } else { return(null); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string folderMsgname = Request.Form["human"]; string selectid = Request.Form["selectid"]; string answer = Request.Form["answer"]; string isPrivate = Request.Form["isPrivate"]; if (selectid.Contains(Nodetype.folder.ToString())) { selectid = selectid.Remove(0, Nodetype.folder.ToString().Length); eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders(); model.Foldername = folderMsgname.Trim(); model.FolderID = int.Parse(selectid); Fbll.UpdateByFolderName(model); Response.Write("success"); Response.End(); } else if (selectid.Contains(Nodetype.message.ToString())) { selectid = selectid.Remove(0, Nodetype.message.ToString().Length); //update message eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.Question = folderMsgname.Trim(); model.ID = int.Parse(selectid); if (!string.IsNullOrEmpty(isPrivate) & isPrivate == "true") { model.isPublic = 0; bll.UpdateByIsPublic(model); } else if (!string.IsNullOrEmpty(isPrivate) & isPrivate == "false") { model.isPublic = 1; bll.UpdateByIsPublic(model); } bll.UpdateByQuestion(model); //update answer eChartProject.Model.eChart.server_contents_answers modelans = new eChartProject.Model.eChart.server_contents_answers(); DataSet ds = abll.GetList(" messageID=" + int.Parse(selectid)); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string ID = ds.Tables[0].Rows[0]["ID"].ToString(); modelans.ID = int.Parse(ID); modelans.Answer = answer.Trim(); modelans.MessageID = int.Parse(selectid); modelans.isDeleted = 0; if (abll.Update(modelans)) { //send answer to ROBORT INTERFACE DataTable dt = new DataTable(); dt.Columns.Add("uri"); dt.Columns.Add("question"); dt.Columns.Add("answer"); string qus = "\"" + model.Question + GetQuestionAndVariations(modelans.MessageID) + "\""; dt.Rows.Add(modelans.MessageID, qus, "\"" + Utils.ConvertInvaidCharacter(HttpUtility.HtmlDecode(Utils.StrFormatD(Utils.RemoveHtml(answer.Trim())))) + "\""); Robot.SAVETOROBOT(dt); } Response.Write("success"); Response.End(); } } } catch { } } }
public void PasteFromCut() { if (toID.Contains(Nodetype.message.ToString())) { int iMsgID = int.Parse(toID.Remove(0, Nodetype.message.ToString().Length)); int iToFolderID = int.Parse(ID.Remove(0, Nodetype.folder.ToString().Length)); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model = bll.GetModel(iMsgID); model.FolderID = iToFolderID; model.sortOrder = SortOrderHelper.GetSortOrder(iToFolderID); bll.Add(model); int newID = bll.GetMaxId() - 1; //add variation DataSet ds = bll.GetList(" relatedid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { model.ID = int.Parse(dr["ID"].ToString()); model.RelatedID = newID; model.Question = dr["Question"].ToString(); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 1;//设置成true model.isDeleted = 1; model.FolderID = null; model.sortOrder = null; bll.Add(model); } } eChartProject.Model.eChart.server_contents_answers ansmodel = new eChartProject.Model.eChart.server_contents_answers(); //if answer exist, update answer ,else if answer not exist,add answer string ans = string.Empty; ds = abll.GetList(" messageid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //insert answer with answer content ans = ds.Tables[0].Rows[0]["answer"].ToString(); ansmodel.Answer = ds.Tables[0].Rows[0]["answer"].ToString(); ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } else { //insert answer ansmodel.Answer = ""; ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Add(ansmodel); } int newAnsID = abll.GetMaxId() - 1; //if rule exist, update rule eChartProject.Model.eChart.server_contents_rule rulemodel = new eChartProject.Model.eChart.server_contents_rule(); ds = RuleBll.GetList(" messageid = " + iMsgID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { //insert rule rulemodel.MessageID = newID; rulemodel.Rule1 = dr["Rule1"].ToString(); RuleBll.Add(rulemodel); int newRuleID = RuleBll.GetMaxId() - 1; //update answer ansmodel.ID = newAnsID; ansmodel.Answer = ans.Replace("<img id=\"" + dr["ID"].ToString() + "\" img=\"\" src=\"../App_Themes/DefaultTheme/images/database_add.png\" />", "<img id=\"" + newRuleID + "\" img=\"\" src=\"../App_Themes/DefaultTheme/images/database_add.png\" />"); ansmodel.MessageID = newID; ansmodel.isDeleted = 0; abll.Update(ansmodel); ans = ansmodel.Answer; } } bll.Delete(iMsgID); } }