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