public static void RuntimeAddSpecialCategory(EasyUITreeNode RootNode, String ORGID) { //Ryan 20170328 This function may be a bit ugly, can be improved someday. String RootName = RootNode.text; // Add Category "Std Assembly,Functional Testing, SW inst (General)" EasyUITreeNode NodeStdAssembly = new EasyUITreeNode("CATEGORY_STDASSEMBLY", "CATEGORY_STDASSEMBLY", "Std Assembly,Functional Testing, SW inst (General)", RootNode.hieid, "", "", 1, 99, 1, 1, 1, 0, 0); EasyUITreeNode NodeSYSA = new EasyUITreeNode("ComponentAGS-CTOS-SYS-B", "ComponentAGS-CTOS-SYS-B", "AGS-CTOS-SYS-B", "", "", "Standard Assembly + Functional Testing + Software", 2, 1, 1, 0, 0, 1, 0); NodeStdAssembly.children.Add(NodeSYSA); RootNode.children.Add(NodeStdAssembly); // Add Extended Warranty EasyUITreeNode NodeExtendedWarranty = new EasyUITreeNode("CATEGORY_EW", "CATEGORY_EW", " Extended Warranty for " + RootName, RootNode.hieid, "", "", 1, 100, 0, 0, 0, 0, 0); String str_getEW = String.Format(@"SELECT A.PART_NO, A.PRODUCT_DESC From SAP_PRODUCT A INNER JOIN SAP_PRODUCT_ORG B ON A.PART_NO=B.PART_NO WHERE B.ORG_ID='{0}' and A.PART_NO in {1} order by A.PART_NO", ORGID, System.Configuration.ConfigurationManager.AppSettings["StdAGSEWPN"]); DataTable dtEW = SqlProvider.dbGetDataTable("MY", str_getEW); if (dtEW != null && dtEW.Rows.Count > 0) { for (int i = 0; i < dtEW.Rows.Count; i++) { EasyUITreeNode NodeEW = new EasyUITreeNode(dtEW.Rows[i]["PART_NO"].ToString(), dtEW.Rows[i]["PART_NO"].ToString(), dtEW.Rows[i]["PART_NO"].ToString(), "", "", dtEW.Rows[i]["PRODUCT_DESC"].ToString(), 2, i, 1, 0, 0, 0, 0); NodeExtendedWarranty.children.Add(NodeEW); } RootNode.children.Add(NodeExtendedWarranty); } }
private static void LoadTreeNode(List <SYS_DEPTANDMEMBER> listMenus, List <EasyUITreeNode> listTreeNodes, string pid, bool isCheckAll) { foreach (SYS_DEPTANDMEMBER menu in listMenus) { if (menu.PARENT_CODE == pid) { EasyUITreeNode node = menu.TransformTreeNode(isCheckAll); listTreeNodes.Add(node); LoadTreeNode(listMenus, node.children, node.id, isCheckAll); } } }
private static void LoadTreeNode(List <SYS_MENU> listMenus, List <EasyUITreeNode> listTreeNodes, string pid) { foreach (SYS_MENU menu in listMenus) { if (menu.PARENT_ID.ToString() == pid) { EasyUITreeNode node = menu.TransformTreeNode(); //if (!string.IsNullOrEmpty(node.gisorder)) { // node.text = "GIS监控"; //} listTreeNodes.Add(node); LoadTreeNode(listMenus, node.children, node.id); } } }
public static List <EasyUITreeNode> GetConfigRecord(String rootid, String sales_org, String cbom_org, int nodetype) { List <EasyUITreeNode> TreeNodes = new List <EasyUITreeNode>(); try { CategoryTypes type = (CategoryTypes)Enum.ToObject(typeof(CategoryTypes), nodetype); if (type == CategoryTypes.SharedComponent) { rootid = SqlProvider.dbExecuteScalar("CBOMV2", string.Format("select top 1 ISNULL(SHARED_CATEGORY_ID,'') AS [SID] from CBOM_CATALOG_CATEGORY_V2 where ID= '{0}' ", rootid.Trim())).ToString(); if (string.IsNullOrEmpty(rootid)) { return(TreeNodes); } } List <CBOM_CATEGORY_RECORD> CBOMCategoryRecords = GetCBOMCategoryRecordByRootId(rootid, cbom_org.Substring(0, 2)); List <CBOM_CATEGORY_RECORD> RootRecord = (from q in CBOMCategoryRecords where q.ID == rootid select q).ToList(); if (RootRecord.Count == 1) { CheckSharedCategory(new List <String>(), ref CBOMCategoryRecords); EasyUITreeNode RootTreeNode = new EasyUITreeNode(RootRecord.First().ID, RootRecord.First().ID, RootRecord.First().CATEGORY_ID, "", RootRecord.First().HIE_ID, "", 0, 0, 1, 0, 0, 0, 0); RootTreeNode.csstype = NodeCssType.Tree_Node_Root; //Ryan 20171120 Check components orderable or not for ACN. CBOMCategoryRecords.RemoveAll(item => (item.CATEGORY_TYPE == CategoryTypes.Component || item.CATEGORY_TYPE == CategoryTypes.SharedComponent) && !CheckItemOrdereable(item.CATEGORY_ID, sales_org)); //if (cbomorg.ToUpper().StartsWith("CN")) // CBOMCategoryRecords.RemoveAll(item => (item.CATEGORY_TYPE == CategoryTypes.Component || item.CATEGORY_TYPE == CategoryTypes.SharedComponent) && !CheckItemOrdereable(item.CATEGORY_ID, org)); //else if (cbomorg.ToUpper().StartsWith("DL")) // CBOMCategoryRecords.RemoveAll(item => (item.CATEGORY_TYPE == CategoryTypes.Component || item.CATEGORY_TYPE == CategoryTypes.SharedComponent) && !CheckItemOrdereable(item.CATEGORY_ID, "US01")); CBOMCategoryRecordsToEasyUITreeNode(CBOMCategoryRecords, RootTreeNode); // Only have to add Special category such as EW and STD assembly if node is BTOS-Parent //if (RootTreeNode.type == (int)CategoryTypes.Root && RootTreeNode.text.Contains("-BTO")) // RuntimeAddSpecialCategory(RootTreeNode, orgid); TreeNodes.Add(RootTreeNode); } } catch { //save error } return(TreeNodes); }
public static void CBOMCategoryRecordsToEasyUITreeNode(List <CBOM_CATEGORY_RECORD> CBOMCategoryRecords, EasyUITreeNode CurrentNode) { String CurrentNodeHieId = CurrentNode.hieid; List <CBOM_CATEGORY_RECORD> SubRecord = (from q in CBOMCategoryRecords where q.PAR_HIE_ID == CurrentNodeHieId orderby q.SEQ_NO, q.CATEGORY_ID select q).ToList(); if (SubRecord.Count == 0) { return; } foreach (CBOM_CATEGORY_RECORD SubRecord_loopVariable in SubRecord) { EasyUITreeNode SubTreeNode = new EasyUITreeNode(SubRecord_loopVariable.ID, SubRecord_loopVariable.VIRTUAL_ID, SubRecord_loopVariable.CATEGORY_ID, CurrentNode.id, SubRecord_loopVariable.HIE_ID, SubRecord_loopVariable.CATEGORY_NOTE, (int)SubRecord_loopVariable.CATEGORY_TYPE, SubRecord_loopVariable.SEQ_NO, SubRecord_loopVariable.QTY , SubRecord_loopVariable.isExpand, SubRecord_loopVariable.isRequired, SubRecord_loopVariable.isDefault, SubRecord_loopVariable.CONFIGURATION_RULE); switch (SubRecord_loopVariable.CATEGORY_TYPE) { case CategoryTypes.Category: SubTreeNode.csstype = NodeCssType.Tree_Node_Category; break; case CategoryTypes.Component: SubTreeNode.csstype = NodeCssType.Tree_Node_Component; break; case CategoryTypes.SharedCategory: SubTreeNode.csstype = NodeCssType.Tree_Node_Shared_Category; break; case CategoryTypes.SharedComponent: SubTreeNode.csstype = NodeCssType.Tree_Node_Shared_Component; break; case CategoryTypes.Root: SubTreeNode.csstype = NodeCssType.Tree_Node_Root; break; default: break; } CurrentNode.children.Add(SubTreeNode); CBOMCategoryRecordsToEasyUITreeNode(CBOMCategoryRecords, SubTreeNode); } }
public static SRPBTO GetSRPConfigRecord(string rootid, string orgid) { SRPBTO srp = new SRPBTO(orgid); object count = SqlProvider.dbExecuteScalar("CBOMV2", string.Format(@"DECLARE @Child hierarchyid SELECT @Child = HIE_ID FROM CBOM_CATALOG_CATEGORY_V2 WHERE ID = '{0}' SELECT COUNT(*) FROM CBOM_CATALOG_CATEGORY_V2 WHERE HIE_ID.GetAncestor(1) = @Child AND ID = '{1}' ", srp.Org.ToString(), rootid)); if (count != null && Convert.ToInt32(count) == 1) { List <CBOM_CATEGORY_RECORD> CBOMCategoryRecords = CBOMV2_EditorDAL.GetCBOMCategoryTreeByRootId(rootid, orgid); CBOM_CATEGORY_RECORD RootRecord = (from q in CBOMCategoryRecords where q.ID == rootid select q).FirstOrDefault(); if (RootRecord != null) { srp.BTOSName = RootRecord.CATEGORY_NOTE; srp.RealPartNo = RootRecord.CATEGORY_ID; List <CBOM_CATEGORY_RECORD> SubRecord = (from q in CBOMCategoryRecords where q.PAR_HIE_ID == RootRecord.HIE_ID && q.CATEGORY_TYPE == CategoryTypes.Root orderby q.SEQ_NO select q).ToList(); foreach (var defaultoption in SubRecord) { EasyUITreeNode RootTreeNode = new EasyUITreeNode(defaultoption.ID, defaultoption.VIRTUAL_ID, defaultoption.CATEGORY_ID, "", defaultoption.HIE_ID, "", 0, 0, 1, 0, 0, 0, 0); RootTreeNode.csstype = NodeCssType.Tree_Node_Root; CBOMCategoryRecordsToEasyUITreeNode(CBOMCategoryRecords, RootTreeNode); if (defaultoption.CATEGORY_ID.ToUpper().IndexOf("DEFAULT") > -1) { srp.DefaultPackage = RootTreeNode; } else if (defaultoption.CATEGORY_ID.ToUpper().IndexOf("OPTION") > -1) { srp.OptionPackage = RootTreeNode; } } } } return(srp); }
public EasyUITreeNode TransformTreeNode() { //int menuCloseState =Convert.ToInt32(ConfigurationSettings.AppSettings["MenuCloseState"]); EasyUITreeNode easyUITreeNode = new EasyUITreeNode() { id = this.MENU_ID, text = this.MENU_NAME, state = this.MENU_LEVEL == 3 ? "closed" : "open", //只有存在下级才可设为closed,否则会循环查询 iconCls = this.C_ICO, Checked = true, //是否选中, area = this.AREA, haspermission = string.Empty, //用于平台子系统权限判断 isdefu = string.Empty, //用于平台获取默认子系统 isdefuopen = string.Empty, //用于打开默认二,三级菜单 gisorder = this.GIS_ORDER == null?string.Empty:this.GIS_ORDER, //用于加载二三级菜单 attributes = new { url = GetUrl(), menulevel = this.MENU_LEVEL }, children = new List <EasyUITreeNode>() }; return(easyUITreeNode); }
private EasyUITreeNode TransformTreeNode(bool isCheckAll) { string mytext = this.ORGRY_NAME; if (!string.IsNullOrEmpty(RYMOBILE)) { mytext += "-" + RYMOBILE; } //string orgOpenState=ConfigurationSettings.AppSettings["OrgOpenState"]; EasyUITreeNode easyUITreeNode = new EasyUITreeNode() { id = this.ORGRY_CODE, text = mytext, state = this.STATE.Equals("1") ? "open" : "closed",//只有存在下级才可设为closed,否则会循环查询 iconCls = this.ICO, Checked = isCheckAll?true:(this.STATE.Equals("C")?true:false), attributes = new { mobile = RYMOBILE, ico = ICO, phone = PHONE }, children = new List <EasyUITreeNode>() }; return(easyUITreeNode); }