//绑定险种树
private void StvProTypeBindData(TreeNodeCollection nds, string parentId)
{
ProductTypeManager proType = new ProductTypeManager();
TreeNode tn = null;
DataTable dt = proType.GetAllList();
DataRow[] rows = dt.Select(string.Format("ParentId='{0}'", parentId));
int comid = Convert.ToInt32(Request.QueryString["id"].ToString());
IList <CompanyProd> cplist = CompanyProdManager.GetListByPro(comid);
foreach (DataRow row in rows)
{
tn = new TreeNode(row["ProdTypeName"].ToString(), row["ProdTypeNo"].ToString());
foreach (CompanyProd item in cplist)
{
if (tn.Value == item.ProdTypeId)
{
tn.Checked = true;
}
}
nds.Add(tn);
StvProTypeBindData(tn.ChildNodes, row["ProdTypeNo"].ToString());
}
}
private void addsource()
{
int id = Convert.ToInt32(Request.QueryString["id"].ToString());
CompanyProdManager.deleteCompanyProdByComId(id);
foreach (TreeNode select in this.stvProType.CheckedNodes)
{
CompanyProd cp = new CompanyProd();
cp.CompanyId = id;
cp.ProdTypeId = select.Value.ToString();
CompanyProdManager.addCompanyProd(cp);
}
}
public void ProcessRequest(HttpContext context)
{
context.Response.ContentType = "text/plain";
List <string> treenodes = new List <string>(); //存储列表数据
object id = context.Request.QueryString["id"]; //根据id值查找该公司下的险种数据
if (id == null || id.ToString() == string.Empty)
{
context.Response.Write("{'id':'1','pid':'0','name':'暂无数据'}");
context.Response.End();
}
ProductTypeManager proType = new ProductTypeManager();
DataTable dt = proType.GetAllList();
IList <CompanyProd> comList = CompanyProdManager.GetListByPro(Convert.ToInt32(id));
if (comList.Count == 0)
{
context.Response.Write("[{'id':'1','pid':'0','name':'暂无数据','nocheck':'true'}]");
context.Response.End();
}
StringBuilder ids = new StringBuilder();
foreach (CompanyProd com in comList)
{
ids.Append("'");
ids.Append(com.ProdTypeId);
ids.Append("',");
}
DataRow[] rows = dt.Select(string.Format("ProdTypeNo in ({0}) ", ids.ToString().TrimEnd(',')));
List <string> parentList = new List <string>();
DataRow[] parents = dt.Select(string.Format("ParentId='0'"));
foreach (DataRow parent in parents)
{
parentList.Add(parent["ProdTypeNo"].ToString().Trim());
string node = string.Format("{{ 'id':'{0}', 'pId':'{1}', 'name':'{2}', 'open':'true','nocheck':'true'}}",
parent["ProdTypeNo"].ToString().Trim(), parent["ParentId"].ToString().Trim(), parent["ProdTypeName"]);
treenodes.Add(node);
}
foreach (DataRow row in rows)
{
if (HasChildren(row["ProdTypeNo"]))
{
continue;
}
string parent = "";
foreach (string item in parentList)
{
if (row["ParentId"].ToString().StartsWith(item))
{
parent = item;
break;
}
}
string node = string.Format("{{ 'id':'{0}', 'pId':'{1}', 'name':'{2}'}}",
row["ProdTypeNo"].ToString().Trim(), parent, row["ProdTypeName"]);
treenodes.Add(node);
}
string NodesData = string.Join(",", treenodes.ToArray());
context.Response.Write("[" + NodesData + "]");
context.Response.End();
}
private void stvBind()
{
CompanyProd cprod = CompanyProdManager.getCompanyProdByComId(Convert.ToInt32(Request.QueryString["id"]));
}
