/// <summary>
/// 获取所有字典数据 转换为json 进行传递
/// </summary>
/// <param name="context"></param>
private void getDicts(HttpContext context)
{
BLL.bllts_Dicts dictbll = new BLL.bllts_Dicts();
int intCount = 0;
int pagenums = 0;
DataTable dt = dictbll.GetPagingListInfo("", "0", 10000, 1, "", "", out intCount, out pagenums);
List <ts_DictDto> list = new List <ts_DictDto>();
if (dt.Rows.Count > 0)
{
DataRow[] rows = dt.Select("pdicid =0 "); //
for (int i = 0; i < rows.Length; i++)
{
ts_DictDto dto = new ts_DictDto();
dto.id = rows[i]["dicid"].ToString();
dto.isParent = true;
dto.open = false;
dto.name = rows[i]["dicname"].ToString();
dto.pId = rows[i]["pdicid"].ToString();
dto.iconClose = "../img/dict_close.png";
dto.iconOpen = "../img/dict_open.png";
DataRow[] itemsrows = dt.Select("pdicid =" + dto.id); //
if (itemsrows.Length > 0)
{
List <ts_DictDto> itemlist = new List <ts_DictDto>();
for (int k = 0; k < itemsrows.Length; k++)
{
ts_DictDto itemdto = new ts_DictDto();
itemdto.id = itemsrows[k]["dicid"].ToString();
itemdto.isParent = false;
itemdto.open = false;
itemdto.name = itemsrows[k]["dicname"].ToString();
itemdto.pId = itemsrows[k]["pdicid"].ToString();
itemdto.icon = "../img/dict_chilren.png";
itemlist.Add(itemdto);
dto.children = itemlist;
}
}
list.Add(dto);
}
}
JavaScriptSerializer s_serializer = new JavaScriptSerializer(); // 通过JavaScriptSerializer对象的Serialize序列化为["value1","value2",...]的字符串
context.Response.Write(s_serializer.Serialize(list)); // 返回客户端json格式数据
}
private void GetTree(Dictionary <string, object> dicPar)
{
//要检测的参数信息
List <string> pra = new List <string>()
{
"GUID", "USER_ID", "pageSize", "currentPage", "filter", "order"
};
//检测方法需要的参数
//获取参数信息
string GUID = "0";
string USER_ID = "0";
int pageSize = StringHelper.StringToInt(dicPar["pageSize"].ToString());
int currentPage = StringHelper.StringToInt(dicPar["currentPage"].ToString());
string filter = dicPar["filter"].ToString();
//filter = CombinationFilter(new List<string>() { "buscode","stocode","pdistypecode","distypecode","dispath","distypename","metcode","fincode","maxdiscount","busSort","status","cuser","uuser" }, dicPar, typeof(string), filter);
string order = "sort asc";
int recordCount = 0;
int totalPage = 0;
//调用逻辑
dt = bll.GetPagingListInfo(GUID, USER_ID, pageSize, currentPage, filter, order, out recordCount, out totalPage);
List <ts_DictDto> list = new List <ts_DictDto>();
if (dt.Rows.Count > 0)
{
DataRow[] rows = dt.Select("pkkcode='0'"); //
for (int i = 0; i < rows.Length; i++)
{
ts_DictDto dto = new ts_DictDto();
dto.id = rows[i]["pkcode"].ToString();
dto.isParent = true;
dto.open = false;
dto.name = rows[i]["typename"].ToString();
dto.pId = rows[i]["pkkcode"].ToString();
dto.iconClose = "../img/dict_close.png";
dto.iconOpen = "../img/dict_open.png";
dto.sort = rows[i]["sort"].ToString();
DataRow[] itemsrows = dt.Select("pkkcode ='" + dto.id + "'"); //
if (itemsrows.Length > 0)
{
List <ts_DictDto> itemlist = new List <ts_DictDto>();
for (int k = 0; k < itemsrows.Length; k++)
{
ts_DictDto itemdto = new ts_DictDto();
itemdto.id = itemsrows[k]["pkcode"].ToString();
itemdto.isParent = false;
itemdto.open = false;
itemdto.name = itemsrows[k]["typename"].ToString();
itemdto.pId = itemsrows[k]["pkkcode"].ToString();
itemdto.icon = "../img/dict_chilren.png";
dto.sort = itemsrows[k]["sort"].ToString();
itemlist.Add(itemdto);
dto.children = itemlist;
}
}
list.Add(dto);
}
}
JavaScriptSerializer s_serializer = new JavaScriptSerializer(); // 通过JavaScriptSerializer对象的Serialize序列化为["value1","value2",...]的字符串
ReturnJsonStr(s_serializer.Serialize(list));
}
