public JsonResult GetTreeMemoryInfo() { string type = System.Web.HttpContext.Current.Request.Params["type"]; string busstype = System.Web.HttpContext.Current.Request.Params["busstype"]; TreeMemoryEntity treeMemoryEntity = proxy.GetTreeMemory(type, string.IsNullOrEmpty(busstype) ? "all" : busstype); return(this.Json(treeMemoryEntity, JsonRequestBehavior.AllowGet)); }
public void UpdataTreeMemory() { string type = System.Web.HttpContext.Current.Request.Params["type"]; string busstype = System.Web.HttpContext.Current.Request.Params["busstype"]; string FoucedNodeValue = System.Web.HttpContext.Current.Request.Params["foucednodevalue"]; string IsMemo = System.Web.HttpContext.Current.Request.Params["ismemo"]; TreeMemoryEntity treeMemoryEntity = new TreeMemoryEntity(NG3.AppInfoBase.LoginID, NG3.AppInfoBase.OCode, type, string.IsNullOrEmpty(busstype) ? "all" : busstype); treeMemoryEntity.FoucedNodeValue = FoucedNodeValue; treeMemoryEntity.IsMemo = IsMemo == "true"; proxy.UpdataTreeMemory(treeMemoryEntity); }
/// <summary> /// 获取树节点的记忆状态 /// </summary> /// <param name="TreeType"></param> /// <param name="BussType"></param> /// <returns></returns> public TreeMemoryEntity GetTreeMemory(TreeMemoryType TreeType, string BussType) { string sql = string.Format("SELECT * from fg_comhelp_treememo where logid='{0}' and ocode='{1}' and comhelptype='{2}' and busstype='{3}' and ismemo='1'", NG3.AppInfoBase.LoginID, NG3.AppInfoBase.OCode, TreeType.ToString(), BussType); DataTable tmpDT = DbHelper.GetDataTable(sql); TreeMemoryEntity treeMemoryEntity = new TreeMemoryEntity(NG3.AppInfoBase.LoginID, NG3.AppInfoBase.OCode, TreeType, BussType); if (null == tmpDT || tmpDT.Rows.Count == 0) { treeMemoryEntity.IsMemo = false; } else { treeMemoryEntity.FoucedNodeValue = tmpDT.Rows[0]["FoucedNodeValue"].ToString(); } return(treeMemoryEntity); }
/// <summary> /// 更新树节点的记忆状态 /// </summary> /// <param name="treeMemoryEntity"></param> /// <returns></returns> public int UpdataTreeMemory(TreeMemoryEntity treeMemoryEntity) { string sql = string.Format("SELECT * from fg_comhelp_treememo where logid='{0}' and ocode='{1}' and comhelptype='{2}' and busstype='{3}'", treeMemoryEntity.LogId, treeMemoryEntity.OCode, treeMemoryEntity.TreeType.ToString(), treeMemoryEntity.BussType); DataTable tmpDT = DbHelper.GetDataTable(sql); DataRow dr; if (tmpDT.Rows.Count == 0) { dr = tmpDT.NewRow(); tmpDT.Rows.Add(dr); } else { dr = tmpDT.Rows[0]; } dr["logid"] = treeMemoryEntity.LogId; dr["ocode"] = treeMemoryEntity.OCode; dr["comhelptype"] = treeMemoryEntity.TreeType.ToString(); dr["foucednodevalue"] = treeMemoryEntity.FoucedNodeValue; dr["ismemo"] = treeMemoryEntity.IsMemo ? 1 : 0; dr["busstype"] = treeMemoryEntity.BussType; return(DbHelper.Update(tmpDT, sql)); }