protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string action = Request.Form["action"]; string selectid = Request.Form["selectid"]; if (selectid.Contains("message")) { selectid = selectid.Remove(0, "message".Length); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.ID = int.Parse(selectid); model.sortOrder = managerMsgSortOrder(model.ID, action); bll.UpdateBySortOrder(model); Response.Write("success"); Response.End(); } } catch { } } }
/// <summary> /// 更新一条数据(只更新sortOrder) /// </summary> public bool UpdateBySortOrder(eChartProject.Model.eChart.server_contents_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update server_contents_message set "); strSql.Append("sortOrder=@sortOrder"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@sortOrder", MySqlDbType.Bit, 1), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.sortOrder; parameters[1].Value = model.ID; int rows = DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public eChartProject.Model.eChart.server_contents_message GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,FolderID,isOffLine,isPublic,isVariations,sortOrder,Question,RelatedID,isDeleted from server_contents_message "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); 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]["FolderID"] != null && ds.Tables[0].Rows[0]["FolderID"].ToString() != "") { model.FolderID = int.Parse(ds.Tables[0].Rows[0]["FolderID"].ToString()); } if (ds.Tables[0].Rows[0]["isOffLine"] != null && ds.Tables[0].Rows[0]["isOffLine"].ToString() != "") { model.isOffLine = ds.Tables[0].Rows[0]["isOffLine"].ToString().ToUpper() == "TRUE"?1:0; } if (ds.Tables[0].Rows[0]["isPublic"] != null && ds.Tables[0].Rows[0]["isPublic"].ToString() != "") { model.isPublic = ds.Tables[0].Rows[0]["isPublic"].ToString().ToUpper() == "TRUE" ? 1 : 0;; } if (ds.Tables[0].Rows[0]["isVariations"] != null && ds.Tables[0].Rows[0]["isVariations"].ToString() != "") { model.isVariations = ds.Tables[0].Rows[0]["isVariations"].ToString().ToUpper() == "TRUE" ? 1 : 0;; } if (ds.Tables[0].Rows[0]["sortOrder"] != null && ds.Tables[0].Rows[0]["sortOrder"].ToString() != "") { model.sortOrder = int.Parse(ds.Tables[0].Rows[0]["sortOrder"].ToString()); } if (ds.Tables[0].Rows[0]["Question"] != null && ds.Tables[0].Rows[0]["Question"].ToString() != "") { model.Question = ds.Tables[0].Rows[0]["Question"].ToString(); } if (ds.Tables[0].Rows[0]["RelatedID"] != null && ds.Tables[0].Rows[0]["RelatedID"].ToString() != "") { model.RelatedID = int.Parse(ds.Tables[0].Rows[0]["RelatedID"].ToString()); } if (ds.Tables[0].Rows[0]["isDeleted"] != null && ds.Tables[0].Rows[0]["isDeleted"].ToString() != "") { model.isDeleted = ds.Tables[0].Rows[0]["isDeleted"].ToString().ToUpper() == "TRUE" ? 1 : 0;; } return(model); } else { return(null); } }
/// <summary> /// Update sortOrder field that which message's sortorder is smaller than the deleted Message /// </summary> /// <param name="id"></param> /// <returns></returns> private bool UpdateSortOrderBelow(int id) { eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); DataSet ds; ds = bll.GetList("ID = " + id + " ORDER BY SORTORDER DESC"); if (ds != null & ds.Tables.Count != 0 & ds.Tables[0].Rows.Count > 0) { int msgid = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); int order = int.Parse(ds.Tables[0].Rows[0]["sortOrder"].ToString()); int folderid = int.Parse(ds.Tables[0].Rows[0]["FolderID"].ToString()); DataSet dsRow; dsRow = bll.GetList("FolderID = " + folderid + " ORDER BY SORTORDER DESC"); if (dsRow != null & dsRow.Tables.Count != 0 & dsRow.Tables[0].Rows.Count > 0) { foreach (DataRow dr in dsRow.Tables[0].Rows) { if (int.Parse(dr["sortOrder"].ToString()) > order) { model.ID = int.Parse(dr["ID"].ToString()); model.sortOrder = int.Parse(dr["sortOrder"].ToString()) - 1; bll.UpdateBySortOrder(model); } } } } return(true); }
/// <summary> /// 增加一条数据 /// </summary> public void Add(eChartProject.Model.eChart.server_contents_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into server_contents_message("); strSql.Append("FolderID,isOffLine,isPublic,isVariations,sortOrder,Question,RelatedID,isDeleted)"); strSql.Append(" values ("); strSql.Append("@FolderID,@isOffLine,@isPublic,@isVariations,@sortOrder,@Question,@RelatedID,@isDeleted)"); MySqlParameter[] parameters = { new MySqlParameter("@FolderID", MySqlDbType.Int32, 11), new MySqlParameter("@isOffLine", MySqlDbType.Bit, 1), new MySqlParameter("@isPublic", MySqlDbType.Bit, 1), new MySqlParameter("@isVariations", MySqlDbType.Bit, 1), new MySqlParameter("@sortOrder", MySqlDbType.Int32, 11), new MySqlParameter("@Question", MySqlDbType.VarChar, 1000), new MySqlParameter("@RelatedID", MySqlDbType.Int32, 11), new MySqlParameter("@isDeleted", MySqlDbType.Bit, 1) }; parameters[0].Value = model.FolderID; parameters[1].Value = model.isOffLine; parameters[2].Value = model.isPublic; parameters[3].Value = model.isVariations; parameters[4].Value = model.sortOrder; parameters[5].Value = model.Question; parameters[6].Value = model.RelatedID; parameters[7].Value = model.isDeleted; DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); }
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 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 { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string selectid = Request.Form["selectid"]; if (selectid.Contains("folder")) { selectid = selectid.Remove(0, "folder".Length); eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders(); model.FolderID = int.Parse(selectid); //model.isDeleted = 0; //Fbll.UpdateByIsDelete(model); Fbll.Delete(model.FolderID); DeleteAllMessageInFolder(selectid); Response.Write("success"); Response.End(); } else if (selectid.Contains("message")) { selectid = selectid.Remove(0, "message".Length); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.ID = int.Parse(selectid); //model.isDeleted = 0; //bll.UpdateByIsdeleted(model); if (UpdateSortOrderBelow(model.ID)) { if (bll.Delete(model.ID)) { //send answer to ROBORT INTERFACE DataTable dt = new DataTable(); dt.Columns.Add("uri"); dt.Columns.Add("question"); dt.Columns.Add("answer"); dt.Rows.Add(model.ID, null, null); Robot.SAVETOROBOT(dt); } } Response.Write("success"); Response.End(); } } catch { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string onoroffstr = Request.Form["onoroff"]; int onoroff = 0; string selectid = Request.Form["selectid"]; if (onoroffstr == "true") { onoroff = 1; } else { onoroff = 0; } if (selectid.Contains("folder")) { selectid = selectid.Remove(0, "folder".Length); eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders(); model.FolderID = int.Parse(selectid); model.isOffline = onoroff; Fbll.UpdateByIsOffline(model); SetOnOfflineAllMessageInFolder(selectid, onoroff); Response.Write("success"); Response.End(); } else if (selectid.Contains("message")) { selectid = selectid.Remove(0, "message".Length); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.ID = int.Parse(selectid); model.isOffLine = onoroff; bll.UpdateByIsoffline(model); Response.Write("success"); Response.End(); } } catch { } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string varContent = Request.Form["varContent"]; string selectid = Request.Form["selectid"]; if (selectid.Contains(Nodetype.message.ToString())) { selectid = selectid.Remove(0, Nodetype.message.ToString().Length); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.Question = varContent.Trim(); //model.FolderID = int.Parse(selectid); model.isOffLine = 0; model.isPublic = 1; model.isVariations = 1;//设置成true model.RelatedID = int.Parse(selectid); //model.sortOrder = SortOrderHelper.GetSortOrder(model.FolderID); model.isDeleted = 1; bll.Add(model); DataSet ds = abll.GetList(" messageID=" + model.RelatedID); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //send answer to ROBORT INTERFACE DataTable dt = new DataTable(); dt.Columns.Add("uri"); dt.Columns.Add("question"); dt.Columns.Add("answer"); string qus = GetQuestionAndVariations(model.RelatedID); dt.Rows.Add(model.RelatedID, qus, HttpUtility.HtmlDecode(Utils.StrFormatD(Utils.RemoveHtml(ds.Tables[0].Rows[0]["answer"].ToString().Trim())))); Robot.SAVETOROBOT(dt); } Response.Write("success"); Response.End(); } } catch { } } }
/// <summary> /// GetSortOrder /// </summary> /// <param name="folderid"></param> /// <returns></returns> public static int?GetSortOrder(int?folderid) { eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); DataSet ds; ds = bll.GetList("FolderID = " + folderid + " ORDER BY SORTORDER DESC"); if (ds != null & ds.Tables.Count != 0 & ds.Tables[0].Rows.Count > 0) { return(int.Parse(ds.Tables[0].Rows[0]["sortorder"].ToString()) + 1); } else { return(0); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(eChartProject.Model.eChart.server_contents_message model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update server_contents_message set "); strSql.Append("FolderID=@FolderID,"); strSql.Append("isOffLine=@isOffLine,"); strSql.Append("isPublic=@isPublic,"); strSql.Append("isVariations=@isVariations,"); strSql.Append("sortOrder=@sortOrder,"); strSql.Append("Question=@Question,"); strSql.Append("RelatedID=@RelatedID,"); strSql.Append("isDeleted=@isDeleted"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@FolderID", MySqlDbType.Int32, 11), new MySqlParameter("@isOffLine", MySqlDbType.Bit, 1), new MySqlParameter("@isPublic", MySqlDbType.Bit, 1), new MySqlParameter("@isVariations", MySqlDbType.Bit, 1), new MySqlParameter("@sortOrder", MySqlDbType.Int32, 11), new MySqlParameter("@Question", MySqlDbType.VarChar, 1000), new MySqlParameter("@RelatedID", MySqlDbType.Int32, 11), new MySqlParameter("@isDeleted", MySqlDbType.Bit, 1), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.FolderID; parameters[1].Value = model.isOffLine; parameters[2].Value = model.isPublic; parameters[3].Value = model.isVariations; parameters[4].Value = model.sortOrder; parameters[5].Value = model.Question; parameters[6].Value = model.RelatedID; parameters[7].Value = model.isDeleted; parameters[8].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 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> /// update the other message's sortorder when a message move up or down /// that they must in on foler /// </summary> /// <param name="id"></param> /// <param name="sortOrder"></param> /// <param name="action"></param> /// <returns></returns> private int UpdateMsgOrderBefore(int id, int sortOrder, string action) { eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); DataSet ds; int moveStep = 0; if (action == "up") { sortOrder--; moveStep = 1; } else { sortOrder++; moveStep = -1; } ds = bll.GetList("FolderID = " + id + " and SORTORDER =" + (sortOrder)); if (sortOrder >= 0 && ds != null & ds.Tables.Count != 0 & ds.Tables[0].Rows.Count > 0) { if (ds.Tables[0].Rows[0]["isDeleted"].ToString().ToUpper() == "FALSE" & ds.Tables[0].Rows[0]["isOffline"].ToString().ToUpper() == "TRUE") { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); model.sortOrder = sortOrder + moveStep; bll.UpdateBySortOrder(model); UpdateMsgOrderBefore(id, sortOrder, action); } else { model.ID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); model.sortOrder = sortOrder + moveStep; bll.UpdateBySortOrder(model); return(sortOrder); //UpdateMsgOrderBefore(id, sortOrder); } } else { sortOrder--; return(sortOrder); } return(0); }
/// <summary> /// update current message's sort order /// </summary> /// <param name="id"></param> /// <param name="action"></param> /// <returns></returns> private int managerMsgSortOrder(int id, string action) { eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); DataSet ds; ds = bll.GetList("ID = " + id + " ORDER BY SORTORDER DESC"); if (ds != null & ds.Tables.Count != 0 & ds.Tables[0].Rows.Count > 0) { int ifolderid = int.Parse(ds.Tables[0].Rows[0]["FolderID"].ToString()); int iSortOrder = int.Parse(ds.Tables[0].Rows[0]["sortOrder"].ToString()); //if(iSortOrder==0)return 0; return(UpdateMsgOrderBefore(ifolderid, iSortOrder, action)); } return(0); }
/// <summary> /// set all message offline when user let a folder offline /// </summary> /// <param name="id"></param> /// <param name="onoroff"></param> /// <returns></returns> private bool SetOnOfflineAllMessageInFolder(string id, int onoroff) { eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); DataSet ds; ds = bll.GetList("FolderID = " + id + " ORDER BY SORTORDER DESC"); if (ds != null & ds.Tables.Count != 0 & ds.Tables[0].Rows.Count > 0) { foreach (DataRow dr in ds.Tables[0].Rows) { string msgid = dr["ID"].ToString(); model.ID = int.Parse(msgid); model.isOffLine = onoroff; bll.UpdateByIsoffline(model); } } return(true); }
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); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string varContent = Request.Form["varContent"]; string selectid = Request.Form["selectid"]; string varid = Request.Form["varid"]; string control = Request.Form["control"]; if (varid.Contains(Nodetype.variationedit.ToString())) { varid = varid.Remove(0, Nodetype.variationedit.ToString().Length); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.Question = varContent.Trim(); model.ID = int.Parse(varid); bll.UpdateByQuestion(model); DataSet ds = abll.GetList(" messageID=" + int.Parse(selectid)); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //send answer to ROBORT INTERFACE DataTable dt = new DataTable(); dt.Columns.Add("uri"); dt.Columns.Add("question"); dt.Columns.Add("answer"); string qus = GetQuestionAndVariations(int.Parse(selectid)); dt.Rows.Add(int.Parse(selectid), qus, HttpUtility.HtmlDecode(Utils.StrFormatD(Utils.RemoveHtml(ds.Tables[0].Rows[0]["answer"].ToString().Trim())))); Robot.SAVETOROBOT(dt); } Response.Write("success"); Response.End(); } else if (control == "delete") { varid = varid.Remove(0, Nodetype.variationdelete.ToString().Length); selectid = selectid.Remove(0, Nodetype.message.ToString().Length); eChartProject.Model.eChart.server_contents_message model = new eChartProject.Model.eChart.server_contents_message(); model.ID = int.Parse(varid); bll.Delete(model.ID); DataSet ds = abll.GetList(" messageID=" + int.Parse(selectid)); if (ds != null & ds.Tables != null & ds.Tables[0].Rows.Count > 0) { //send answer to ROBORT INTERFACE DataTable dt = new DataTable(); dt.Columns.Add("uri"); dt.Columns.Add("question"); dt.Columns.Add("answer"); string qus = GetQuestionAndVariations(int.Parse(selectid)); dt.Rows.Add(int.Parse(selectid), qus, HttpUtility.HtmlDecode(Utils.StrFormatD(Utils.RemoveHtml(ds.Tables[0].Rows[0]["answer"].ToString().Trim())))); Robot.SAVETOROBOT(dt); } Response.Write("success"); Response.End(); } } catch { } } }