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
{
}
}
}
