コード例 #1
0
    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;
    }
コード例 #2
0
ファイル: TableControl.cs プロジェクト: YummyChiu/ModelView
    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();
    }
コード例 #3
0
ファイル: UICountTable.cs プロジェクト: YummyChiu/ModelView
    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();
    }
コード例 #4
0
    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();
    }
コード例 #5
0
    // 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();
    }
コード例 #7
0
    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);
    }
コード例 #8
0
    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;
    }
コード例 #9
0
    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();
    }
コード例 #10
0
    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();
    }
コード例 #11
0
    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);
    }
コード例 #12
0
    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();
    }
コード例 #13
0
    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();
    }
コード例 #14
0
    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);
        }
    }
コード例 #15
0
    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();
    }
コード例 #16
0
    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();
    }
コード例 #17
0
    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();
    }
コード例 #18
0
    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();
    }
コード例 #19
0
ファイル: TableControl.cs プロジェクト: YummyChiu/ModelView
    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();
    }
コード例 #20
0
    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);
        }
    }
コード例 #21
0
    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;
    }
コード例 #22
0
    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);
        }
    }
コード例 #23
0
    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;
    }
コード例 #24
0
    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);
        }
    }
コード例 #25
0
    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();
    }