/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(eChartProject.Model.eChart.server_contents_folders model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update server_contents_folders set ");
strSql.Append("Foldername=@Foldername,");
strSql.Append("ParentID=@ParentID,");
strSql.Append("isDeleted=@isDeleted,");
strSql.Append("isOffline=@isOffline");
strSql.Append(" where FolderID=@FolderID");
MySqlParameter[] parameters =
{
new MySqlParameter("@Foldername", MySqlDbType.VarChar, 50),
new MySqlParameter("@ParentID", MySqlDbType.Int32, 11),
new MySqlParameter("@isDeleted", MySqlDbType.Bit, 1),
new MySqlParameter("@isOffline", MySqlDbType.Bit, 1),
new MySqlParameter("@FolderID", MySqlDbType.Int32, 11)
};
parameters[0].Value = model.Foldername;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.isDeleted;
parameters[3].Value = model.isOffline;
parameters[4].Value = model.FolderID;
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 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
{
}
}
}
public void PasteFromCut()
{
if (toID.Contains(Nodetype.folder.ToString()))
{
int iFolderID = int.Parse(toID.Remove(0, Nodetype.folder.ToString().Length));
int iToRootID = int.Parse(ID.Remove(0, Nodetype.root.ToString().Length));
eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders();
model = Fbll.GetModel(iFolderID);
model.ParentID = iToRootID;
Fbll.Add(model);
Fbll.Delete(iFolderID);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public eChartProject.Model.eChart.server_contents_folders GetModel(int FolderID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select FolderID,Foldername,ParentID,isDeleted,isOffline from server_contents_folders ");
strSql.Append(" where FolderID=@FolderID");
MySqlParameter[] parameters =
{
new MySqlParameter("@FolderID", MySqlDbType.Int32)
};
parameters[0].Value = FolderID;
eChartProject.Model.eChart.server_contents_folders model = new eChartProject.Model.eChart.server_contents_folders();
DataSet ds = DbHelperMySQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
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]["Foldername"] != null && ds.Tables[0].Rows[0]["Foldername"].ToString() != "")
{
model.Foldername = ds.Tables[0].Rows[0]["Foldername"].ToString();
}
if (ds.Tables[0].Rows[0]["ParentID"] != null && ds.Tables[0].Rows[0]["ParentID"].ToString() != "")
{
model.ParentID = int.Parse(ds.Tables[0].Rows[0]["ParentID"].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;
}
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;
}
return(model);
}
else
{
return(null);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public void Add(eChartProject.Model.eChart.server_contents_folders model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into server_contents_folders(");
strSql.Append("Foldername,ParentID,isDeleted,isOffline)");
strSql.Append(" values (");
strSql.Append("@Foldername,@ParentID,@isDeleted,@isOffline)");
MySqlParameter[] parameters =
{
new MySqlParameter("@Foldername", MySqlDbType.VarChar, 50),
new MySqlParameter("@ParentID", MySqlDbType.Int32, 11),
new MySqlParameter("@isDeleted", MySqlDbType.Bit, 1),
new MySqlParameter("@isOffline", MySqlDbType.Bit, 1)
};
parameters[0].Value = model.Foldername;
parameters[1].Value = model.ParentID;
parameters[2].Value = model.isDeleted;
parameters[3].Value = model.isOffline;
DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters);
}
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
{
}
}
}
