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