public void RebarSummaryTable() { SetButtonNormal(); table = transform.GetComponentInChildren <Table>(); table.ResetTable(); table.AddTextColumn("序号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("料牌编号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋规格").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋形状").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("断料长度(mm)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("总数(根)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("总重(kg)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("备注").horAlignment = Column.HorAlignment.CENTER; table.Initialize(); var datas = _myRebars.OrderBy(a => int.Parse(a.Name.Split(' ')[0])).GroupBy(myRebar => new { myRebar.Name }); int i = 0; int j = 0; foreach (var data in datas) { i++; var items = data.GroupBy(myRebar => new { myRebar.Shape, myRebar.Length }); Datum mergeName = Datum.Body(i.ToString()); #region 显示合并后的单元格的文字 mergeName.elements.Add(data.First().Name); //合并后的名字 mergeName.elements.Add(""); //料牌编号 mergeName.elements.Add(""); //钢筋规格 mergeName.elements.Add(""); // 钢筋形状 mergeName.elements.Add(""); // 断料长度(mm) mergeName.elements.Add(""); // 总数(根) mergeName.elements.Add(""); // 总重(kg) mergeName.elements.Add(""); // 备注 mergeName.elements[0].color = Color.red; table.data.Add(mergeName); Sprite s = Resources.Load <Sprite>("") as Sprite; #endregion foreach (var item in items) { i++; j++; Datum rows = Datum.Body(i.ToString()); rows.elements.Add(j.ToString()); //序号 rows.elements.Add(item.First().CardNum); //料牌编号 rows.elements.Add(item.First().Name); //钢筋规格 rows.elements.Add(item.First().Shape); //钢筋形状 rows.elements.Add(item.First().Length.ToString()); //断料长度(mm) rows.elements.Add(item.Sum(a => a.Quantity).ToString()); //总数(根) rows.elements.Add("1"); //总重(kg) rows.elements.Add(""); //备注 table.data.Add(rows); } } table.StartRenderEngine(); RebarSummaryBtn.GetComponent <Image>().enabled = true; }
public void Load(List <CountNum> list) { table = transform.GetComponentInChildren <Table>(); table.ResetTable(); table.AddTextColumn("序号"); table.AddTextColumn("项目编码"); table.AddTextColumn("项目名称"); table.AddTextColumn("项目特征"); table.AddTextColumn("计量单位"); table.AddTextColumn("工程量"); table.Initialize(); int i = 0; foreach (var item in list) { i++; Datum d = Datum.Body(i.ToString()); d.elements.Add(i.ToString()); //序号 d.elements.Add(item.ProjectNum); //项目编码 d.elements.Add(item.ProjectName); //项目名称 d.elements.Add(item.ProjectFeature); //项目特征 d.elements.Add(item.ProjectUnit); //计量单位 d.elements.Add(item.ProjectQuantities); //工程量 table.data.Add(d); } table.StartRenderEngine(); }
public override void Active() { _tableList = data as List <CountNum>; base.Active(); TableCount.ResetTable(); TableCount.AddTextColumn("序号"); TableCount.AddTextColumn("项目编码"); TableCount.AddTextColumn("项目名称"); TableCount.AddTextColumn("项目特征"); TableCount.AddTextColumn("计量单位"); TableCount.AddTextColumn("工程量"); TableCount.Initialize(); int i = 0; foreach (var item in _tableList) { i++; Datum d = Datum.Body(i.ToString()); d.elements.Add(i.ToString()); //序号 d.elements.Add(item.ProjectNum); //项目编码 d.elements.Add(item.ProjectName); //项目名称 d.elements.Add(item.ProjectFeature); //项目特征 d.elements.Add(item.ProjectUnit); //计量单位 d.elements.Add(item.ProjectQuantities); //工程量 TableCount.data.Add(d); } TableCount.StartRenderEngine(); }
public void ShowSelect(string str) { this.table.data.Clear(); for (int i = 0; i < poplist.Count; i++) { mxy_MaintenancePlanTableData.MaintenancePlanDataParameter p = poplist[i]; if (p.name == str) { Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type); d.elements.Add(p.tutorial); d.elements.Add(p.operation); this.table.data.Add(d); } else if (p.type == str) { Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type); d.elements.Add(p.tutorial); d.elements.Add(p.operation); this.table.data.Add(d); } else if (p.tutorial == str) { Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type); d.elements.Add(p.tutorial); d.elements.Add(p.operation); this.table.data.Add(d); } } if (str == "全部") { for (int i = 0; i < poplist.Count; i++) { mxy_MaintenancePlanTableData.MaintenancePlanDataParameter p = poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type); d.elements.Add(p.tutorial); d.elements.Add(p.operation); this.table.data.Add(d); } } this.table.StartRenderEngine(); }
// Use this for initialization void Start() { togglePval = GameObject.Find("PlayerData").GetComponent <PlayerData>().togglePval; this.table = this.GetComponent <Table>(); this.table.ResetTable(); this.table.AddTextColumn(); this.table.AddTextColumn(); this.table.AddTextColumn(); this.table.AddTextColumn(); this.table.AddTextColumn(); this.table.AddTextColumn(); this.table.AddTextColumn(); if (togglePval) { this.table.AddTextColumn(); } this.table.Initialize(this.OnTableSelected); int uid = -1; Datum d = Datum.Body(uid.ToString()); //Debug.Log("Got inside for loop"); //DataModel.GetPValue(5, 7, 20, 14, csv); //go.transform.Find("").GetComponent<Text>().text = datam.day[index].ToString(); d.elements.Add("Day"); d.elements.Add("Budget"); d.elements.Add("AvailToTreat"); d.elements.Add("TreatA"); d.elements.Add("CureA"); d.elements.Add("TreatB"); d.elements.Add("CureB"); if (togglePval) { d.elements.Add("PValue *"); } this.table.data.Add(d); datam = world.data; //this.dayCount = datam.day.Count; if (datam == null) { Debug.Log("datam is null"); return; } this.table.StartRenderEngine(); }
void updateTable() { // reset the table before updating it table.ResetTable(); // add the column headers table.AddTextColumn("Station (ft)"); table.AddTextColumn("Existing Gr (ft)"); table.AddTextColumn("Proposed Gr (ft)"); table.AddTextColumn("Roadway Width (ft)"); table.AddTextColumn("Cut Area (ft)"); table.AddTextColumn("Fill Area (sf)"); table.AddTextColumn("Cut Volumes (bcy)"); table.AddTextColumn("Fill Volumes (ccy)"); table.AddTextColumn("Adj. Fill Volumes (bcy)"); table.AddTextColumn("Algebraic Sum (cy)"); table.AddTextColumn("Mass Ordinate (cy)"); // Initialize Your Table table.Initialize(onTableSelected); // update values updateStation(); updateExistGrade(); updatePropGrade(); updateRoadWidth(); updateCutArea(); updateFillArea(); updateCutVolume(); updateFillVolume(); updateAdjFillVolume(); updateAlgebraicSum(); updateMassOrdinate(); // Populate Your Rows for (int i = 0; i < MAXPOINTS; i++) { Datum d = Datum.Body(i.ToString()); d.elements.Add(station[i].ToString()); d.elements.Add(existGrade[i].ToString()); d.elements.Add(propGrade[i].ToString()); d.elements.Add(roadWidth[i].ToString()); d.elements.Add(cutArea[i].ToString()); d.elements.Add(fillArea[i].ToString()); d.elements.Add(cutVolume[i].ToString()); d.elements.Add(fillVolume[i].ToString()); d.elements.Add(adjFillVolume[i].ToString()); d.elements.Add(algebraicSum[i].ToString()); d.elements.Add(massOrdinate[i].ToString()); table.data.Add(d); } // Draw Your Table table.StartRenderEngine(); }
private Datum MakeDatum(string pfx, Resource file) { Datum d = Datum.Body(pfx); d.elements.Add(pfx); d.elements.Add(file.FileName); d.elements.Add(file.FileSize.ToString()); d.elements.Add(file.FileDate.ToString()); d.elements.Add("download!"); d.rawObject = file; return(d); }
private void RebarCardTable() { SetButtonNormal(); table.ResetTable(); table.AddTextColumn("序号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("料牌编号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋规格").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋形状").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("计算公式", null, 150, 160).horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("单长(mm)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("总数量(根)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋所在位置").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("备注").horAlignment = Column.HorAlignment.CENTER; table.Initialize(); int i = 0; var datas = _myRebars.OrderBy(a => int.Parse(a.Name.Split(' ')[0])).GroupBy(myRebar => new { myRebar.Name, myRebar.Shape, myRebar.Length }); foreach (var data in datas) { i++; Datum rows = Datum.Body(i.ToString()); rows.elements.Add(i.ToString()); //序号 rows.elements.Add(data.First().CardNum); //料牌编号 rows.elements.Add(data.First().Name); //钢筋规格 rows.elements.Add(data.First().Shape); //钢筋形状 rows.elements.Add(data.First().CalculatingFormula); //计算公式 rows.elements.Add(data.First().Length.ToString()); //单长(mm) rows.elements.Add(data.Sum(a => a.Quantity).ToString()); //总数量(根) string location = ""; List <string> hostcodeList = new List <string>(); foreach (var item in data) { if (!hostcodeList.Contains(item.Host.HostCode)) { hostcodeList.Add(item.Host.HostCode); } } foreach (var item in hostcodeList) { location += "所在构件:" + item + "\n"; } rows.elements.Add(location); //钢筋所在位置 rows.elements.Add(""); //备注 table.data.Add(rows); } table.StartRenderEngine(); RebarCardBtn.GetComponent <Image>().enabled = true; }
private void PopulateUnitTable() { this.UnitTable.ResetTable(); //Set up the columns this.UnitTable.AddTextColumn("Name"); this.UnitTable.AddTextColumn("HP"); this.UnitTable.AddTextColumn("Armour"); this.UnitTable.AddTextColumn("Size"); this.UnitTable.AddTextColumn("MVMT"); this.UnitTable.AddTextColumn("STR"); this.UnitTable.AddTextColumn("DEX"); this.UnitTable.AddTextColumn("INT"); this.UnitTable.AddTextColumn("DET"); this.UnitTable.AddTextColumn("Amount"); this.UnitTable.Initialize(this.OnTableSelected); //Populate the table with information for (int i = 0; i < squad.units.Count; i++) { //The unit we're working with Unit unit = squad.units[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(unit.getName()); d.elements.Add(unit.GetHP()); d.elements.Add(unit.GetArmour()); d.elements.Add(unit.GetSize()); d.elements.Add(unit.GetMovement()); d.elements.Add(unit.GetStrength()); d.elements.Add(unit.GetDexterity()); d.elements.Add(unit.GetIntelligence()); d.elements.Add(unit.GetDetermination()); d.elements.Add(unit.amount); this.UnitTable.data.Add(d); } //Draw the table this.UnitTable.StartRenderEngine(); }
void Start() { // Initialize Your Table resourceTable.ResetTable(); // Add the columns Column c; c = resourceTable.AddImageColumn(" "); // Icon c.horAlignment = Column.HorAlignment.CENTER; resourceTable.AddTextColumn("Resource"); // Add in the quantity columns, one per quality for (int i = 0; i < (int)QualityEnum.any; i++) { //print("Adding Quality Column"); resourceTable.AddTextColumn(((QualityEnum)i).ToString() + " quality", null); } // Initialize Your Table resourceTable.Initialize(onTableSelected, resourceNameSpriteDict); // Populate Rows int ind = 0; foreach (KeyValuePair <string, int> entry in ManagerBase.resourceIndexOf) { Datum d = Datum.Body(ind.ToString()); ind++; //print("Printing Name"); d.elements.Add(entry.Key); // The name is the key into the sprite dictionary d.elements.Add(entry.Key); int[] quantity = domain.stock.quantity[entry.Value]; foreach (int q in quantity) { //print("Printing Quantity"); d.elements.Add(q.ToString()); } resourceTable.data.Add(d); } // Draw Your Table resourceTable.StartRenderEngine(); }
private Datum MakeInternetDatum(string pfx, Resource file) { //check file status ResourceStatus Status; string s = ""; if (localFiles != null) { if (localFiles.Any(f => f.FileName == file.FileName)) { Resource localfile = localFiles.First(f => f.FileName == file.FileName); if (localfile.FileSize == file.FileSize) { Status = ResourceStatus.DOWNLOADED; } else { Status = ResourceStatus.MODIFIED; } } else { Status = ResourceStatus.NEW; } } else { Status = ResourceStatus.NEW; } Debug.Log(Status.ToString()); //int i = (int)(Status); Debug.Log(((int)(Status)).ToString()); Datum d = Datum.Body(pfx); d.elements.Add(pfx); d.elements.Add(file.FileName); d.elements.Add(file.FileSize.ToString()); d.elements.Add(file.FileDate.ToString()); d.elements.Add(((int)(Status)).ToString()); d.rawObject = file; return(d); }
void Start() { buildingTable.ResetTable(); // Add the columns buildingTable.AddImageColumn(""); // Icon buildingTable.AddTextColumn("Name"); buildingTable.AddTextColumn("Tier"); buildingTable.AddTextColumn("Quality"); buildingTable.AddTextColumn("Maintenance"); //buildingTable.AddImageColumn(""); // HP Bar buildingTable.AddTextColumn("Workers"); buildingTable.AddTextColumn("Active Jobs"); // Initialize Your Table buildingTable.Initialize(onTableSelected, buildingNameSpriteDict); // Populate Rows int ind = 0; foreach (BuildingObj building in ManagerBase.domain.buildings) { Datum d = Datum.Body(ind.ToString()); ind++; d.elements.Add(building.name); d.elements.Add(building.name); d.elements.Add(ManagerBase.buildingDefinitions[ManagerBase.buildingIndexOf[building.name]].tier); d.elements.Add(building.quality.ToString()); d.elements.Add(ManagerBase.buildingDefinitions[ManagerBase.buildingIndexOf[building.name]].maintenanceCost); //d.elements.Add(""); // HP Bar d.elements.Add(building.NumberOfWorkers().ToString()); d.elements.Add(building.NumberOfActiveJobs().ToString()); buildingTable.data.Add(d); } // Draw Table buildingTable.StartRenderEngine(); }
void InitIssueTable() { // Task task = new Task(GetComponentInfo(originData)); #region Test Data List <Issue> IssueList = new List <Issue>() { new Issue() { IssueName = "Chrysanthemum.jpg", IssueDescription = "null", IssuePoster = "zhao" }, new Issue() { IssueName = "Hydrangeas.jpg", IssueDescription = "Hello", IssuePoster = "lee" } }; #endregion issueTable.ResetTable(); issueTable.AddTextColumn("问题材料", null, 100); issueTable.AddTextColumn("问题描述", null, 100); issueTable.AddTextColumn("问题记录者", null, 100); issueTable.Initialize(OnCellSelected); int count = 0; foreach (var item in IssueList) { count++; Datum d = Datum.Body(count.ToString()); d.elements.Add(item.IssueName); d.elements.Add(item.IssueDescription); d.elements.Add(item.IssuePoster); issueTable.data.Add(d); } issueTable.StartRenderEngine(); }
public void UpdateTable(int lastDay) { for (int index = lastDay; index < datam.day.Count; index++) { Datum d = Datum.Body(index.ToString()); d.elements.Add(datam.day[index]); d.elements.Add(datam.budget[index]); d.elements.Add(datam.availToTreat[index]); d.elements.Add(datam.aTreat[index]); d.elements.Add(datam.aCure[index]); d.elements.Add(datam.bTreat[index]); d.elements.Add(datam.bCure[index]); if (togglePval) { if (datam.pVal[index] == 0.0) { d.elements.Add("NA"); } else if (datam.pVal[index] == -999.0) { d.elements.Add("> 0.50"); } else if (datam.pVal[index] == -1.0) { d.elements.Add("< 0.001"); } else { d.elements.Add(datam.pVal[index].ToString()); } } this.table.data.Add(d); } }
public void ShowSelect(string str) { this.table.data.Clear(); Debug.Log(table.data.Count); for (int i = 0; i < poplist.Count; i++) { mxy_RecordDataTableData.RecordDataParameter p = poplist[i]; if (p.number == str) { Datum d1 = Datum.Body(i.ToString()); d1.elements.Add(p.number); d1.elements.Add(p.name); d1.elements.Add(p.type.ToString()); d1.elements.Add(p.person); d1.elements.Add(p.accessory); d1.elements.Add(p.operation); this.table.data.Add(d1); } else if (p.name == str) { Datum d2 = Datum.Body(i.ToString()); d2.elements.Add(p.number); d2.elements.Add(p.name); d2.elements.Add(p.type.ToString()); d2.elements.Add(p.person); d2.elements.Add(p.accessory); d2.elements.Add(p.operation); this.table.data.Add(d2); } else if (p.person == str) { Datum d3 = Datum.Body(i.ToString()); d3.elements.Add(p.number); d3.elements.Add(p.name); d3.elements.Add(p.type.ToString()); d3.elements.Add(p.person); d3.elements.Add(p.accessory); d3.elements.Add(p.operation); this.table.data.Add(d3); } } if ("全部" == str) { Debug.Log(table.data.Count); for (int i = 0; i < poplist.Count; i++) { mxy_RecordDataTableData.RecordDataParameter p = poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type.ToString()); d.elements.Add(p.person); d.elements.Add(p.accessory); d.elements.Add(p.operation); this.table.data.Add(d); } } //OnHeaderClick(this.table.columns[0], null); this.table.StartRenderEngine(); }
private IEnumerator GetComponentInfo(string id) { issueTable.ResetTable(); issueTable.AddTextColumn("问题材料", null, 100, 200); issueTable.AddTextColumn("问题描述", null, 150, 300); issueTable.AddTextColumn("问题记录者", null, 100, 200); issueTable.Initialize(OnCellSelected); int count = 0; string url = Tools.WebUrl + getAction; WWWForm form = new WWWForm(); form.AddField("id", id); //form.AddField("id", "258879"); WWW getdata = new WWW(url, form); yield return(data); if (getdata.error != null) { MessageBox.Show(getdata.error); } else { if (getdata.isDone) { if (getdata.text != "\"没有构件的数据\"") { Debug.Log("json数据:" + getdata.text); JObject obj = JObject.Parse(getdata.text); Debug.Log("json数据:" + getdata.text); string t = obj["dataSource"].ToString(); if (t == "listdata") { JArray jar = JArray.Parse(obj["listdata"].ToString()); //Debug.Log(jar.ToString()); SqliteConnection conn = Tools.Instance.SqlConnection(); foreach (var item in jar) { //得到问题反馈列表,并写进ComponentInfos表里面去 //-Id-ComponentId-FileInfo-FileServerInfo-FileLocalInfo-Remarks //如果表没有这个 count++; string ComponentId = item["ComponentId"].ToString(); //string ComponentName = item["componentName"].ToString(); string FileInfo = item["FlieInfo"].ToString(); string FilePath = item["filePath"].ToString(); string Remarks = item["FeedbackInfo"].ToString(); Debug.Log(Remarks); string CreateTime = item["createTime"].ToString(); Datum d = Datum.Body(count.ToString()); d.rawObject = Tools.WebUrl + FilePath; d.elements.Add(FileInfo); d.elements.Add(Remarks); d.elements.Add(CreateTime); issueTable.data.Add(d); Debug.Log(FilePath); // FilePath = count.ToString(); SqliteCommand cmd = conn.CreateCommand(); cmd.CommandText = "select * from ComponentInfos where FileInfo ='" + FileInfo + "'"; Debug.Log("cmd:" + cmd.CommandText); SqliteDataReader dr = cmd.ExecuteReader(); if (dr.HasRows) { Debug.Log("The componentInfos doesn't have !"); } else { //Insert Debug.Log("start to insert to componentInfos"); SqliteCommand cmd2 = conn.CreateCommand(); // cmd2.CommandText = "Insert Into ComponentInfos(ComponentId,FileInfo,FileServerInfo,FileLocalInfo)values("+ ComponentId +","+ FlieInfo + ","+ FilePath + "," + "a" + ")"; cmd2.CommandText = "Insert Into [ComponentInfos]([ComponentId],[FileInfo],[FileServerInfo],[FileLocalInfo],[Remarks])values(@ComponentId,@FileInfo,@FileServerInfo,@FileLocalInfo,@Remarks)"; cmd2.Parameters.AddWithValue("ComponentId", ComponentId); cmd2.Parameters.AddWithValue("FileInfo", FileInfo); cmd2.Parameters.AddWithValue("FileServerInfo", FilePath); cmd2.Parameters.AddWithValue("FileLocalInfo", ""); cmd2.Parameters.AddWithValue("Remarks", Remarks); Debug.Log("cm2:" + cmd2.CommandText); cmd2.ExecuteNonQuery(); } } conn.Close(); conn.Dispose(); } } else { Debug.Log("json数据:" + getdata.text); } } } issueTable.StartRenderEngine(); }
public void Select(string str1, string str2, string str3) { this.table.data.Clear(); if (str1 == str2 && str2 == str3) { for (int i = 0; i < poplist.Count; i++) { mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p = poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } poplist_Temp = poplist; } else { List <mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter> _poplist = poplist; if (str1 != "全部") { IEnumerable <mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter> rs = from data in _poplist where data.property == str1 select data; _poplist = rs.ToList(); Debug.Log(poplist_Temp.Count); } if (str2 != "全部") { IEnumerable <mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter> rs = from data in _poplist where data.state == str2 select data; _poplist = rs.ToList(); Debug.Log(poplist_Temp.Count); } if (str3 != "全部") { IEnumerable <mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter> rs = from data in _poplist where data.person == str3 select data; _poplist = rs.ToList(); Debug.Log(poplist_Temp.Count); } Debug.Log(poplist_Temp.Count); for (int i = 0; i < _poplist.Count; i++) { mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p = _poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } poplist_Temp = _poplist; } this.table.StartRenderEngine(); }
public void ShowSelect(string str) { this.table.data.Clear(); for (int i = 0; i < poplist.Count; i++) { mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p = poplist[i]; if (p.property == str) { Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } else if (p.state == str) { Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } else if (p.person == str) { Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } } if (str == "全部") { for (int i = 0; i < poplist.Count; i++) { mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p = poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } } this.table.StartRenderEngine(); }
public void LoadDatas() { Stopwatch sw = new Stopwatch(); sw.Start(); #region UnityEngine.Debug.Log(path); UnityEngine.Debug.Log(level); UnityEngine.Debug.Log(table.name); table.ResetTable(); table.AddTextColumn("序号"); table.AddTextColumn("项目编码"); table.AddTextColumn("项目名称"); table.AddTextColumn("项目特征"); table.AddTextColumn("计量单位"); table.AddTextColumn("工程量"); table.Initialize(); XmlDocument xml = new XmlDocument(); //xml.Load(path); string s1 = Resources.Load(path).ToString(); xml.LoadXml(s1); XmlNode mainNode = xml.SelectSingleNode("算量信息"); int i = 0; #region int start = System.Environment.TickCount; UnityEngine.Debug.Log("开始:" + start); for (int j = 0; j < resultsList.Keys.Count; j++) { i++; string codeNum = resultsList.Keys.ElementAt(j); string elementId = resultsList[codeNum][0]; XmlNode elemId = mainNode.SelectSingleNode(elementId); XmlNode unitNode = elemId.SelectSingleNode("单位"); XmlNode textNode = elemId.SelectSingleNode("项目特征"); XmlNode nameNode = elemId.SelectSingleNode("项目名称"); string unit = unitNode.InnerText; string text = textNode.InnerText; string name = nameNode.InnerText.Split(' ')[1]; double result = 0; for (int k = 0; k < resultsList[codeNum].Count; k++) { string id = resultsList[codeNum][k]; //如果所选的楼层包含该ID的level就计入工程量 if (!ReadModelXML.idAndLevels.ContainsKey(id)) { UnityEngine.Debug.Log("id:" + id + "______" + "codingnum :" + codeNum + "_____"); } else { if (level.Contains(ReadModelXML.idAndLevels[id])) { XmlNode countNode = mainNode.SelectSingleNode(id).SelectSingleNode("工程量"); result += double.Parse(countNode.InnerText); } } //foreach (GameObject go in ReadModelXML.goList) //{ // string[] goName = go.name.Split('_'); // if (id == goName[1]) // { // switch (goName[0]) // { // case "墙": // Walls wall = go.GetComponent<Walls>(); // if (level.Contains(wall.FLOORSNUM)) // { // XmlNode countNode = mainNode.SelectSingleNode(id).SelectSingleNode("工程量"); // //result = 1; // result += double.Parse(countNode.InnerText); // } // break; // case "结构框架": // Frameworks frameworks = go.GetComponent<Frameworks>(); // if (level.Contains(frameworks.FLOORSNUM)) // { // XmlNode countNode = mainNode.SelectSingleNode(id).SelectSingleNode("工程量"); // //result = 1; // result += double.Parse(countNode.InnerText); // } // break; // case "楼板": // Floors floors = go.GetComponent<Floors>(); // if (level.Contains(floors.FLOORSNUM)) // { // XmlNode countNode = mainNode.SelectSingleNode(id).SelectSingleNode("工程量"); // //result = 1; // result += double.Parse(countNode.InnerText); // } // break; // default: // break; // } // } //} /**************************************************************************************/ //XmlNode countNode = mainNode.SelectSingleNode(id).SelectSingleNode("工程量"); //result += double.Parse(countNode.InnerText); /**************************************************************************************/ } if (result == 0) { continue; } Datum d = Datum.Body(i.ToString()); d.elements.Add(i.ToString()); //序号 d.elements.Add(codeNum); //项目编码 d.elements.Add(name); //项目名称 d.elements.Add(text); //项目特征 d.elements.Add(unit); //计量单位 d.elements.Add(result.ToString("0.00")); //工程量 table.data.Add(d); #endregion #endregion #region 无筛选条件 显示表格 //table.ResetTable(); //table.AddTextColumn(); //table.AddTextColumn(); //table.AddTextColumn(); //table.AddTextColumn(); //table.AddTextColumn(); //table.AddTextColumn(); //// Initialize Your Table //table.Initialize(); //List<CountNum> cn = new List<CountNum>(); //XmlDocument xml = new XmlDocument(); //xml.Load(path); //XmlNodeList xnl = xml.SelectSingleNode("算量信息").ChildNodes; //foreach (XmlNode item in xnl) //{ // CountNum c = new CountNum(); // foreach (XmlNode i in item) // { // if (i.Name == "项目名称") // { // c.ProjectName = i.InnerText; // } // if (i.Name == "项目编码") // { // c.ProjectNum = i.InnerText; // } // if (i.Name == "项目特征") // { // c.ProjectFeature = i.InnerText; // } // if (i.Name == "工程量") // { // c.ProjectQuantities = i.InnerText; // } // if (i.Name == "单位") // { // c.ProjectUnit = i.InnerText; // } // } // cn.Add(c); //} //var cList = cn.OrderBy(a => a.ProjectNum).GroupBy(b => new { b.ProjectNum }).ToList(); //Datum d = Datum.Body(0.ToString()); //d.elements.Add("序号"); //d.elements.Add("项目编码"); //d.elements.Add("项目名称"); //d.elements.Add("项目特征"); //d.elements.Add("计量单位"); //d.elements.Add("工程量"); //table.data.Add(d); //Datum d1 = Datum.Body(1.ToString()); //d1.elements.Add("混凝土及钢筋混凝土工程"); //d1.elements.Add(""); //d1.elements.Add(""); //d1.elements.Add(""); //d1.elements.Add(""); //d1.elements.Add(""); //table.data.Add(d1); //int i1 = 2;//在第2行遍历数据 //int m = 0;//序号 //foreach (var item in cList) //{ // m++; // Datum dm = Datum.Body(i1.ToString()); // dm.elements.Add(m.ToString()); // dm.elements.Add(item.First().ProjectNum.ToString()); // dm.elements.Add(item.First().ProjectName.ToString()); // dm.elements.Add(item.First().ProjectFeature.ToString()); // dm.elements.Add(item.First().ProjectUnit.ToString()); // dm.elements.Add(item.Sum(a => double.Parse(a.ProjectQuantities)).ToString("0.00")); // table.data.Add(dm); // i1++; //} //table.StartRenderEngine(); #endregion } sw.Stop(); UnityEngine.Debug.Log(sw.Elapsed.TotalSeconds); int end = System.Environment.TickCount; UnityEngine.Debug.Log("结束:" + start); UnityEngine.Debug.Log("消耗的时间:" + (end - start) + "毫秒"); table.StartRenderEngine(); }
private void OnHeaderClick(Column column, PointerEventData e) { bool isAscending = false; // Reset current sort UI for (int i = 0; i < this.table.columns.Count; i++) { if (column == this.table.columns[i]) { if (column.headerIcon == "UP") { isAscending = true; column.headerIcon = "DOWN"; } else { isAscending = false; column.headerIcon = "UP"; } } else { this.table.columns[i].headerIcon = null; } } // do the sort poplist_Temp.Sort( delegate(mxy_MaintenancePlanTableData.MaintenancePlanDataParameter p1, mxy_MaintenancePlanTableData.MaintenancePlanDataParameter p2) { // 编号 if (column.idx == 0) { if (isAscending) { return(p1.number.CompareTo(p2.number)); } else { return(p2.number.CompareTo(p1.number)); } } // 设备名称 if (column.idx == 1) { if (isAscending) { return(p1.name.CompareTo(p2.name)); } else { return(p2.name.CompareTo(p1.name)); } } // 设备类别 if (column.idx == 2) { if (isAscending) { return(p1.type.CompareTo(p2.type)); } else { return(p2.type.CompareTo(p1.type)); } } // 维保教程 if (column.idx == 3) { if (isAscending) { return(p1.tutorial.CompareTo(p2.tutorial)); } else { return(p2.tutorial.CompareTo(p1.tutorial)); } } return(p1.number.CompareTo(p2.number)); } ); this.table.data.Clear(); for (int i = 0; i < poplist_Temp.Count; i++) { mxy_MaintenancePlanTableData.MaintenancePlanDataParameter p = poplist_Temp[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type); d.elements.Add(p.tutorial); d.elements.Add(p.operation); this.table.data.Add(d); } }
public void RebarOptimizeTabletemp() { SetButtonNormal(); if (FirstClick) { UnityEngine.Debug.Log("FirstClick is " + FirstClick); MyCutLib mycurebar = new MyCutLib(ReadTextAndGroupBy()); tables = mycurebar.GetAllKindOfCutRebarList(); } //UnityEngine.Debug.Log("count:"+ tables.Count); table.ResetTable(); table.AddTextColumn("断料序号", null, 50, 60).horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋规格").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("原长定尺(mm)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("需要的原材数").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("断料组合").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("料牌编号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("余料长度").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("损耗率").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("备注").horAlignment = Column.HorAlignment.CENTER; table.Initialize(); int i = 0; int j = 0; foreach (var tableitem in tables) { i++; Datum mergeName = Datum.Body(i.ToString()); #region 显示合并后的单元格的文字 mergeName.elements.Add(tableitem.First().Name); //断料序号 mergeName.elements.Add(""); //钢筋规格 mergeName.elements.Add(""); //原长定尺(mm) mergeName.elements.Add(""); // 需要的原材数 mergeName.elements.Add(""); // 断料组合 mergeName.elements.Add(""); // 料牌编号 mergeName.elements.Add(""); // 余料长度 mergeName.elements.Add(""); // 损耗率 mergeName.elements.Add(""); // 备注 mergeName.elements[0].color = Color.red; table.data.Add(mergeName); double totalUsed = 0; int totalNum = 0; double wasteLength = 0; double fixedLength = 0; foreach (var item in tableitem) { i++; j++; Datum rows = Datum.Body(i.ToString()); rows.elements.Add(j.ToString()); //断料序号 rows.elements.Add(item.name); //钢筋规格 rows.elements.Add(item.FixedLength.ToString()); //原长定尺(mm) rows.elements.Add(item.NeedNumber.ToString()); //需要的原材数 rows.elements.Add(item.GetTotal()); //断料组合 rows.elements.Add(item.GetCardNum(mySameLenght)); //料牌编号 rows.elements.Add(Math.Round(item.GetUseValue()[0], 4).ToString()); // 余料长度 rows.elements.Add((Math.Round(item.GetUseValue()[2], 4) * 100).ToString() + "%"); // 损耗率 if (Math.Round(item.GetUseValue()[0], 4) > 0 && Math.Round(item.GetUseValue()[2], 4) == 0.0) { string str = "此为余料,可用于下批次加工"; rows.elements.Add(str); //备注 } else { wasteLength += Math.Round(item.GetUseValue()[0], 4) * item.NeedNumber; rows.elements.Add(""); } fixedLength = item.FixedLength; totalUsed += fixedLength * item.NeedNumber; table.data.Add(rows); } i++; double wasteRate = (wasteLength / totalUsed) * 100; UnityEngine.Debug.Log("wasteRate :" + wasteRate); wasteRate = Math.Round(wasteRate, 2); string UtilizationRate = (100 - wasteRate).ToString() + "%"; Datum mergeSum = Datum.Body(i.ToString()); mergeSum.elements.Add("小计"); //断料序号 mergeSum.elements.Add(""); //钢筋规格 mergeSum.elements.Add(""); //原长定尺(mm) mergeSum.elements.Add(tableitem.Sum(a => a.NeedNumber).ToString()); // 需要的原材数 mergeSum.elements.Add(""); // 断料组合 mergeSum.elements.Add(""); // 料牌编号 mergeSum.elements.Add("总的利用率" + UtilizationRate); // 余料长度 mergeSum.elements.Add("总的损耗率" + wasteRate.ToString() + "%"); // 损耗率 mergeSum.elements.Add(""); // 备注 mergeSum.elements[0].color = Color.red; table.data.Add(mergeSum); } table.StartRenderEngine(); FirstClick = false; RebarOptimizeBtn.GetComponent <Image>().enabled = true; }
private void OnHeaderClick(Column column, PointerEventData e) { bool isAscending = false; // Reset current sort UI for (int i = 0; i < this.table.columns.Count; i++) { if (column == this.table.columns[i]) { if (column.headerIcon == "UP") { isAscending = true; column.headerIcon = "DOWN"; } else { isAscending = false; column.headerIcon = "UP"; } } else { this.table.columns[i].headerIcon = null; } } // do the sort poplist_Temp.Sort( delegate(mxy_RecordDataTableData.RecordDataParameter p1, mxy_RecordDataTableData.RecordDataParameter p2) { // 资料编号 if (column.idx == 0) { if (isAscending) { return(p1.number.CompareTo(p2.number)); } else { return(p2.number.CompareTo(p1.number)); } } // 资料名称 if (column.idx == 1) { if (isAscending) { return(p1.name.CompareTo(p2.name)); } else { return(p2.name.CompareTo(p1.name)); } } // 资料类型 if (column.idx == 2) { if (isAscending) { return(p1.type.CompareTo(p2.type)); } else { return(p2.type.CompareTo(p1.type)); } } // 上传人员 if (column.idx == 3) { if (isAscending) { return(p1.person.CompareTo(p2.person)); } else { return(p2.person.CompareTo(p1.person)); } } // 附件 if (column.idx == 4) { if (isAscending) { return(p1.accessory.CompareTo(p2.accessory)); } else { return(p2.accessory.CompareTo(p1.accessory)); } } return(p1.number.CompareTo(p2.number)); } ); this.table.data.Clear(); for (int i = 0; i < poplist.Count; i++) { mxy_RecordDataTableData.RecordDataParameter p = poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type.ToString()); d.elements.Add(p.person); d.elements.Add(p.accessory); d.elements.Add(p.operation); this.table.data.Add(d); } }
public void RebarSummaryTable(List <MyRebar> rebars) { _myRebars = rebars; table = transform.GetComponentInChildren <Table>(); table.ResetTable(); table.AddTextColumn("dfadf", null, 100.0f, 200.0f); table.AddTextColumn("序号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("料牌编号").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋规格").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("钢筋形状").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("断料长度(mm)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("总数(根)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("总重(kg)").horAlignment = Column.HorAlignment.CENTER; table.AddTextColumn("备注").horAlignment = Column.HorAlignment.CENTER; table.Initialize(); long totalCountQuantity = 0; double totalCountWeight = 0.0; var datas = _myRebars.OrderBy(a => int.Parse(a.Name.Split(' ')[0])).GroupBy(myRebar => new { myRebar.Name }); int i = 0; int j = 0; foreach (var data in datas) { double sumWeight = 0.0; i++; var items = data.GroupBy(myRebar => new { myRebar.Shape, myRebar.Length }); Datum mergeName = Datum.Body(i.ToString()); #region 显示合并后的单元格的文字 mergeName.elements.Add(data.First().Name); //合并后的名字 mergeName.elements.Add(""); //料牌编号 mergeName.elements.Add(""); //钢筋规格 mergeName.elements.Add(""); // 钢筋形状 mergeName.elements.Add(""); // 断料长度(mm) mergeName.elements.Add(""); // 总数(根) mergeName.elements.Add(""); // 总重(kg) mergeName.elements.Add(""); // 备注 mergeName.elements[0].color = Color.red; table.data.Add(mergeName); #endregion foreach (var item in items) { i++; j++; Datum rows = Datum.Body(i.ToString()); rows.elements.Add(j.ToString()); //序号 rows.elements.Add(item.First().CardNum); //料牌编号 rows.elements.Add(item.First().Name); //钢筋规格 rows.elements.Add(item.First().Shape); //钢筋形状 rows.elements.Add(item.First().Length.ToString()); //断料长度(mm) rows.elements.Add(item.Sum(a => a.Quantity).ToString()); //总数(根) #region 设置钢筋重量 string diameter = item.First().Name.Split(' ')[0]; double weight = GetRebarWeight(diameter, item.First().Length / 1000, item.Sum(a => a.Quantity)); rows.elements.Add(weight.ToString("0.0"));//总重(kg) sumWeight += weight; #endregion rows.elements.Add("");//备注 table.data.Add(rows); } i++; Datum mergeSum = Datum.Body(i.ToString()); mergeSum.elements.Add("小计"); //序号 mergeSum.elements.Add(""); //料牌编号 mergeSum.elements.Add(""); //钢筋规格 mergeSum.elements.Add(""); // 钢筋形状 mergeSum.elements.Add(""); // 断料长度(mm) mergeSum.elements.Add(data.Sum(a => a.Quantity).ToString()); // 总数(根) mergeSum.elements.Add(sumWeight.ToString("0.0")); // 总重(kg) mergeSum.elements.Add(""); //备注 mergeSum.elements[0].color = Color.red; totalCountQuantity += data.Sum(a => a.Quantity); totalCountWeight += sumWeight; table.data.Add(mergeSum); } i++; Datum mergeSums = Datum.Body(i.ToString()); mergeSums.elements.Add("合计"); //序号 mergeSums.elements.Add(""); //料牌编号 mergeSums.elements.Add(""); //钢筋规格 mergeSums.elements.Add(""); // 钢筋形状 mergeSums.elements.Add(""); // 断料长度(mm) mergeSums.elements.Add(totalCountQuantity.ToString()); // 总数(根) mergeSums.elements.Add(totalCountWeight.ToString("0.000")); // 总重(kg) mergeSums.elements.Add(); //备注 table.data.Add(mergeSums); table.StartRenderEngine(); //RebarSummaryBtn.GetComponent<Image>().enabled = true; }
private void OnHeaderClick(Column column, PointerEventData e) { bool isAscending = false; // Reset current sort UI for (int i = 0; i < this.table.columns.Count; i++) { if (column == this.table.columns[i]) { if (column.headerIcon == "UP") { isAscending = true; column.headerIcon = "DOWN"; } else { isAscending = false; column.headerIcon = "UP"; } } else { this.table.columns[i].headerIcon = null; } } // do the sort poplist_Temp.Sort( delegate(mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p1, mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p2) { // 编号 if (column.idx == 0) { if (isAscending) { return(p1.number.CompareTo(p2.number)); } else { return(p2.number.CompareTo(p1.number)); } } // 流程标题 if (column.idx == 1) { if (isAscending) { return(p1.title.CompareTo(p2.title)); } else { return(p2.title.CompareTo(p1.title)); } } // 流程属性 if (column.idx == 2) { if (isAscending) { return(p1.property.CompareTo(p2.property)); } else { return(p2.property.CompareTo(p1.property)); } } // 审批状态 if (column.idx == 3) { if (isAscending) { return(p1.state.CompareTo(p2.state)); } else { return(p2.state.CompareTo(p1.state)); } } // 发起人 if (column.idx == 4) { if (isAscending) { return(p1.person.CompareTo(p2.person)); } else { return(p2.person.CompareTo(p1.person)); } } // 发起时间 if (column.idx == 5) { if (isAscending) { return(p1.time.CompareTo(p2.time)); } else { return(p2.time.CompareTo(p1.time)); } } // 流程进度 if (column.idx == 6) { if (isAscending) { return(ChangetoFloat(p1.progress).CompareTo(ChangetoFloat(p2.progress))); } else { return(ChangetoFloat(p2.progress).CompareTo(ChangetoFloat(p1.progress))); } } return(p1.number.CompareTo(p2.number)); } ); this.table.data.Clear(); for (int i = 0; i < poplist_Temp.Count; i++) { mxy_MaintenanceManagementTableData.MaintenanceManagementDataParameter p = poplist_Temp[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.title); d.elements.Add(p.property); d.elements.Add(p.state); d.elements.Add(p.person); d.elements.Add(p.time); d.elements.Add(p.progress); d.elements.Add(p.operation); this.table.data.Add(d); } }
public void Select(string str1, string str2, string str3) { this.table.data.Clear(); if (str1 == str2 && str2 == str3) { for (int i = 0; i < poplist.Count; i++) { mxy_RecordDataTableData.RecordDataParameter p = poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type.ToString()); d.elements.Add(p.person); d.elements.Add(p.accessory); d.elements.Add(p.operation); this.table.data.Add(d); } poplist_Temp = poplist; } else { List <mxy_RecordDataTableData.RecordDataParameter> _poplist = poplist; if (str1 != "全部") { IEnumerable <mxy_RecordDataTableData.RecordDataParameter> rs = from data in _poplist where data.number == str1 select data; _poplist = rs.ToList(); } if (str2 != "全部") { IEnumerable <mxy_RecordDataTableData.RecordDataParameter> rs = from data in _poplist where data.name == str2 select data; _poplist = rs.ToList(); } if (str3 != "全部") { IEnumerable <mxy_RecordDataTableData.RecordDataParameter> rs = from data in _poplist where data.person == str3 select data; _poplist = rs.ToList(); } for (int i = 0; i < _poplist.Count; i++) { mxy_RecordDataTableData.RecordDataParameter p = _poplist[i]; Datum d = Datum.Body(i.ToString()); d.elements.Add(p.number); d.elements.Add(p.name); d.elements.Add(p.type.ToString()); d.elements.Add(p.person); d.elements.Add(p.accessory); d.elements.Add(p.operation); this.table.data.Add(d); } poplist_Temp = _poplist; } this.table.StartRenderEngine(); }