protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { try { string ruleid = Request.Form["ruleid"]; //Get Rule eChartProject.Model.eChart.server_contents_rule modelans = new eChartProject.Model.eChart.server_contents_rule(); DataSet ds = RuleBll.GetList(" ID=" + int.Parse(ruleid)); if (ds != null && ds.Tables != null && ds.Tables.Count > 0 && ds.Tables[0].Rows.Count > 0) { string strRule = ds.Tables[0].Rows[0]["Rule1"].ToString(); TableEnt te = new TableEnt(); te = XmlSerialization <TableEnt> .DeSerialize(strRule); strRule = te.TableInfo.Name + "&" + te.FieldInfo.Name; Response.Write(strRule); Response.End(); } } catch { } } }
/// <summary> /// 增加一条数据 /// </summary> public void Add(eChartProject.Model.eChart.server_contents_rule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into server_contents_rule("); strSql.Append("MessageID,Rule1,Rule2,Rule3,Rule4,Rule5,Rule6)"); strSql.Append(" values ("); strSql.Append("@MessageID,@Rule1,@Rule2,@Rule3,@Rule4,@Rule5,@Rule6)"); MySqlParameter[] parameters = { new MySqlParameter("@MessageID", MySqlDbType.Int32, 11), new MySqlParameter("@Rule1", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule2", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule3", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule4", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule5", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule6", MySqlDbType.VarChar, 4000) }; parameters[0].Value = model.MessageID; parameters[1].Value = model.Rule1; parameters[2].Value = model.Rule2; parameters[3].Value = model.Rule3; parameters[4].Value = model.Rule4; parameters[5].Value = model.Rule5; parameters[6].Value = model.Rule6; DbHelperMySQL.ExecuteSql(strSql.ToString(), parameters); }
/// <summary> /// 得到一个对象实体 /// </summary> public eChartProject.Model.eChart.server_contents_rule GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID,MessageID,Rule1,Rule2,Rule3,Rule4,Rule5,Rule6 from server_contents_rule "); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@ID", MySqlDbType.Int32) }; parameters[0].Value = ID; eChartProject.Model.eChart.server_contents_rule model = new eChartProject.Model.eChart.server_contents_rule(); 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]["Rule1"] != null && ds.Tables[0].Rows[0]["Rule1"].ToString() != "") { model.Rule1 = ds.Tables[0].Rows[0]["Rule1"].ToString(); } if (ds.Tables[0].Rows[0]["Rule2"] != null && ds.Tables[0].Rows[0]["Rule2"].ToString() != "") { model.Rule2 = ds.Tables[0].Rows[0]["Rule2"].ToString(); } if (ds.Tables[0].Rows[0]["Rule3"] != null && ds.Tables[0].Rows[0]["Rule3"].ToString() != "") { model.Rule3 = ds.Tables[0].Rows[0]["Rule3"].ToString(); } if (ds.Tables[0].Rows[0]["Rule4"] != null && ds.Tables[0].Rows[0]["Rule4"].ToString() != "") { model.Rule4 = ds.Tables[0].Rows[0]["Rule4"].ToString(); } if (ds.Tables[0].Rows[0]["Rule5"] != null && ds.Tables[0].Rows[0]["Rule5"].ToString() != "") { model.Rule5 = ds.Tables[0].Rows[0]["Rule5"].ToString(); } if (ds.Tables[0].Rows[0]["Rule6"] != null && ds.Tables[0].Rows[0]["Rule6"].ToString() != "") { model.Rule6 = ds.Tables[0].Rows[0]["Rule6"].ToString(); } return(model); } else { return(null); } }
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 bool Update(eChartProject.Model.eChart.server_contents_rule model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update server_contents_rule set "); strSql.Append("MessageID=@MessageID,"); strSql.Append("Rule1=@Rule1,"); strSql.Append("Rule2=@Rule2,"); strSql.Append("Rule3=@Rule3,"); strSql.Append("Rule4=@Rule4,"); strSql.Append("Rule5=@Rule5,"); strSql.Append("Rule6=@Rule6"); strSql.Append(" where ID=@ID"); MySqlParameter[] parameters = { new MySqlParameter("@MessageID", MySqlDbType.Int32, 11), new MySqlParameter("@Rule1", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule2", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule3", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule4", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule5", MySqlDbType.VarChar, 4000), new MySqlParameter("@Rule6", MySqlDbType.VarChar, 4000), new MySqlParameter("@ID", MySqlDbType.Int32, 11) }; parameters[0].Value = model.MessageID; parameters[1].Value = model.Rule1; parameters[2].Value = model.Rule2; parameters[3].Value = model.Rule3; parameters[4].Value = model.Rule4; parameters[5].Value = model.Rule5; parameters[6].Value = model.Rule6; parameters[7].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 fieldname = Request.Form["fieldname"]; string selectid = Request.Form["selectid"]; string tablename = Request.Form["tablename"]; if (selectid.Contains(Nodetype.message.ToString())) { selectid = selectid.Remove(0, Nodetype.message.ToString().Length); TableEnt te = new TableEnt(); TableInfo ti = new TableInfo(); FieldInfo fi = new FieldInfo(); ti.Name = tablename; fi.Name = fieldname; te.TableInfo = ti; te.FieldInfo = fi; string result = ""; result = XmlSerialization <TableEnt> .Serialize(te); eChartProject.Model.eChart.server_contents_rule scr = new eChartProject.Model.eChart.server_contents_rule(); scr.MessageID = int.Parse(selectid); scr.Rule1 = result; RuleBll.Add(scr); int i = RuleBll.GetMaxId() - 1; Response.Write("success" + i.ToString()); 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); } }