public override ActionResult GetTreeGridJson(string keyword, string searchFiled, string list, string orderBy = " ORDER BY F_SortCode ")
{
string[] classnameList = typeof(Mst_PositionInfo).ToString().Split('.');
string condition = "";
if (string.IsNullOrEmpty(list))
{
condition = GetKeywordCondition(keyword, searchFiled);
}
else
{
condition = GetAdvCondition(JsonConvert.DeserializeObject <List <AdvSearchEntity> >(list));
}
TreeInfoEntity entity = new TreeInfoEntity();
entity.F_Condition = string.IsNullOrEmpty(condition) ? string.Empty : " AND " + condition;
entity.F_CType = 1;
entity.F_KeyFiled = "F_Id";
entity.F_ParentFiled = "F_ParentId";
entity.F_SortCode = orderBy;
entity.F_TableName = classnameList[classnameList.Length - 1].Replace("Info", string.Empty);
var dt = BLLFactory <AppCommon> .Instance.GetTreeInfo(entity); //baseBLL.Find(condition, orderBy);
string dataStr = JsonAppHelper.ToJson(dt);
var data = JsonAppHelper.ToList <Mst_PositionInfo>(dataStr);
foreach (var item in data)
{
string name = BLLFactory <Mst_Warehouse> .Instance.FindByID(item.F_WarehouseId).F_FullName;
item.F_WarehouseName = string.IsNullOrEmpty(name) ? "" : name;
}
return(Content(GetTreeGridJsonStr(data)));
}
/// <summary>
/// 获取属性结构
/// </summary>
/// <param name="entity">参数对象</param>
/// <returns></returns>
public DataSet GetTreeInfo(TreeInfoEntity entity)
{
List <SmartDbParameter> paramList = new List <SmartDbParameter>();
paramList.Add(CreateInSmartDbParameter("TABLENAME", DbType.String, entity.F_TableName));
paramList.Add(CreateInSmartDbParameter("KEYFILED", DbType.String, entity.F_KeyFiled));
paramList.Add(CreateInSmartDbParameter("PARENTFILED", DbType.String, entity.F_ParentFiled));
paramList.Add(CreateInSmartDbParameter("CONDITION", DbType.String, entity.F_Condition));
paramList.Add(CreateInSmartDbParameter("SORTCODE", DbType.String, entity.F_SortCode));
paramList.Add(CreateInSmartDbParameter("CTYPE", DbType.String, entity.F_CType));
return(base.ExecuteDataSetByProc("[SYS_GETTREEINFO]", paramList));
}
/// <summary>
/// 获取属性结构
/// </summary>
/// <param name="entity">参数对象</param>
/// <returns></returns>
public DataTable GetTreeInfo(TreeInfoEntity entity)
{
IAppCommon dal = base.baseDal as IAppCommon;
return(dal.GetTreeInfo(entity).Tables[0]);
}
