Beispiel #1
0
        private void LoadData()
        {
            try
            {
                if (dataTable != null)
                {
                    dataTable.Columns.Clear();
                    treeList1.Columns.Clear();
                }

                PowerTypes psp_Type = new PowerTypes();
                psp_Type.Flag2 = typeFlag2;
                IList listTypes = new ArrayList();
                try
                {
                    listTypes = Common.Services.BaseService.GetList("SelectPowerTypesByFlag2", psp_Type);
                }
                catch (Exception ex)
                { MsgBox.Show(ex.Message); }
                dataTable = Itop.Common.DataConverter.ToDataTable(listTypes, typeof(PowerTypes));

                treeList1.DataSource = dataTable;

                treeList1.Columns["Title"].Caption = "项目名称";
                treeList1.Columns["Title"].Width   = 180;
                treeList1.Columns["Title"].OptionsColumn.AllowEdit = false;
                treeList1.Columns["Title"].OptionsColumn.AllowSort = false;
                treeList1.Columns["Flag"].VisibleIndex             = -1;
                treeList1.Columns["Flag"].OptionsColumn.ShowInCustomizationForm = false;
                treeList1.Columns["Flag2"].VisibleIndex = -1;
                treeList1.Columns["Flag2"].OptionsColumn.ShowInCustomizationForm = false;

                PowerYears psp_Year = new PowerYears();
                psp_Year.Flag = typeFlag2;
                IList <PowerYears> listYears = Common.Services.BaseService.GetList <PowerYears>("SelectPowerYearsListByFlag", psp_Year);

                foreach (PowerYears item in listYears)
                {
                    AddColumn(item.Year);
                }

                AddColumn1();
                AddColumn2();
                AddColumn3();
                AddColumn4();

                Application.DoEvents();

                LoadValues();

                treeList1.ExpandAll();
            }
            catch (Exception ex)
            {
                MsgBox.Show(ex.Message);
            }
        }
Beispiel #2
0
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            PowerYears psp_Year = new PowerYears();

            psp_Year.Flag = flag2;
            yearValue     = psp_Year.Year = (int)spinEdit1.Value;
            if (_getYearOnly)
            {
                this.DialogResult = DialogResult.OK;
                return;
            }

            if (al.Contains(yearValue + "年") == true)
            {
                MsgBox.Show("已经存在此年份,要想添加,请先删除已存在的" + yearValue + "年!");
                return;
            }
            try
            {
                if (Common.Services.BaseService.GetObject("SelectPowerYearsByYearFlag", psp_Year) == null)
                {
                    try
                    {
                        Common.Services.BaseService.Create <PowerYears>(psp_Year);
                        this.DialogResult = DialogResult.OK;
                    }
                    catch (Exception ex)
                    {
                        MsgBox.Show("出错啦:" + ex.Message);
                    }
                }
                else
                {
                    MsgBox.Show("此年份已经存在,请重新输入!");
                }
            }
            catch (Exception ex)
            {
                MsgBox.Show("出错啦:" + ex.Message);
            }
        }
Beispiel #3
0
        private void FrmEditProject_Load(object sender, EventArgs e)
        {
            string q0  = "";
            string q1  = "";
            string q2  = "";
            string q3  = "";
            double?q4  = null;
            string q5  = "";
            string q6  = "";
            string q7  = "";
            string q8  = "";
            string q9  = "";
            string q10 = "";
            string q11 = "";
            string q12 = "";
            string q13 = "";
            string q14 = "";
            string q15 = "";
            string q16 = "";
            string q17 = "";
            string q18 = "";
            string q19 = "";
            string q20 = "";
            string q21 = "";
            string q22 = "";
            string q23 = "";
            string q24 = "";


            int t1 = 0;

            PSP_PowerTypes_Liao ppt = new PSP_PowerTypes_Liao();

            try
            {
                ppt.ID = int.Parse(poweruid);
            }
            catch { }
            ppt.Flag2 = flag;

            PSP_PowerTypes_Liao ps = (PSP_PowerTypes_Liao)Common.Services.BaseService.GetOneByKey <PSP_PowerTypes_Liao>(ppt);

            // if (ps != null)
            try
            {
                groupBox1.Text = ps.Title;
                q0             = ps.Title;
                t1             = ps.Flag;
                q1             = ps.JianSheXingZhi;
                q2             = ps.RongLiang;
                q3             = ps.ChangDu;
                dt             = ps.CreatTime;
                if (ps.TouZiZongEr.ToString() != "")
                {
                    q4 = double.Parse(ps.TouZiZongEr);
                }
                if (ps.S1 == "" || ps.S1 == null)
                {
                    q5 = "";
                }
                else
                {
                    q5 = ps.S1;
                }

                if (ps.S2 != "" && ps.S2 != null)
                {
                    q6 = ps.S2;
                }

                if (ps.S3 != "" && ps.S3 != null)
                {
                    q7 = ps.S3;
                }

                if (ps.S4 != "" && ps.S4 != null)
                {
                    q8 = ps.S4;
                }


                if (ps.S5 != "" && ps.S5 != null)
                {
                    q9 = ps.S5;
                }

                if (ps.S6 != "" && ps.S6 != null)
                {
                    q10 = ps.S6;
                }

                if (ps.S7 != "" && ps.S7 != null)
                {
                    q11 = ps.S7;
                }


                if (ps.S8 != "" && ps.S8 != null)
                {
                    q12 = ps.S8;
                }

                if (ps.S9 != "" && ps.S9 != null)
                {
                    q13 = ps.S9;
                }

                if (ps.S10 != "" && ps.S10 != null)
                {
                    q14 = ps.S10;
                }

                if (ps.S11 != "" && ps.S11 != null)
                {
                    q15 = ps.S11;
                }

                if (ps.S12 != "" && ps.S12 != null)
                {
                    q16 = ps.S12;
                }


                if (ps.S13 != "" && ps.S13 != null)
                {
                    q17 = ps.S13;
                }

                if (ps.S14 != "" && ps.S14 != null)
                {
                    q18 = ps.S14;
                }

                if (ps.S15 != "" && ps.S15 != null)
                {
                    q19 = ps.S15;
                }

                if (ps.S16 != "" && ps.S16 != null)
                {
                    q20 = ps.S16;
                }

                if (ps.S17 != "" && ps.S17 != null)
                {
                    q21 = ps.S17;
                }


                if (ps.S18 != "" && ps.S18 != null)
                {
                    q22 = ps.S18;
                }


                if (ps.S19 != "" && ps.S19 != null)
                {
                    q23 = ps.S19;
                }


                if (ps.S20 != "" && ps.S20 != null)
                {
                    q24 = ps.S20;
                }
            }
            catch { }
            ac1.Add(q5);
            ac1.Add(q6);
            ac1.Add(q7);
            ac1.Add(q8);
            ac1.Add(q9);
            ac1.Add(q10);
            ac1.Add(q11);
            ac1.Add(q12);
            ac1.Add(q13);
            ac1.Add(q14);
            ac1.Add(q15);
            ac1.Add(q16);
            ac1.Add(q17);
            ac1.Add(q18);
            ac1.Add(q19);
            ac1.Add(q20);
            ac1.Add(q21);
            ac1.Add(q22);
            ac1.Add(q23);
            ac1.Add(q24);


            PowerValues ppv = new PowerValues();

            if (ps == null)
            {
                ppv.TypeID = -1;
            }
            else
            {
                ppv.TypeID = ps.ID;
            }
            //ppv.TypeID1 = flag;
            IList <PowerValues> listValues = Common.Services.BaseService.GetList <PowerValues>("SelectPowerValuesList", ppv);

            PowerYears pps = new PowerYears();

            pps.Flag = flag;
            IList <PowerYears> li = Common.Services.BaseService.GetList <PowerYears>("SelectPowerYearsListByFlagSortYear", pps);

            lb = new Label[li.Count];
            te = new TextEdit[li.Count];

            int i = 0;

            lt3.Text     = "项目名称:";
            lt3.Location = new Point(52, 27 + 33 * i);
            groupBox1.Controls.Add(lt3);

            tt3          = new TextEdit();
            tt3.Location = new Point(157, 26 + 33 * i);
            tt3.Size     = new Size(231, 21);
            groupBox1.Controls.Add(tt3);

            i++;

            lt2.Text     = "建设性质:";
            lt2.Location = new Point(52, 27 + 33 * i);
            groupBox1.Controls.Add(lt2);

            tt2          = new TextEdit();
            tt2.Location = new Point(157, 26 + 33 * i);
            tt2.Size     = new Size(231, 21);
            groupBox1.Controls.Add(tt2);

            i++;

            lt4.Text     = "变电容量:";
            lt4.Location = new Point(52, 27 + 33 * i);
            groupBox1.Controls.Add(lt4);

            tt4          = new TextEdit();
            tt4.Location = new Point(157, 26 + 33 * i);
            tt4.Size     = new Size(231, 21);

            tt4.Properties.DisplayFormat.FormatString = "n4";
            tt4.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
            tt4.Properties.EditFormat.FormatString    = "n4";
            tt4.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Numeric;
            tt4.Properties.Mask.EditMask = "###########0.####";
            tt4.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;


            groupBox1.Controls.Add(tt4);

            i++;
            lt1.Text     = "线路长度:";
            lt1.Location = new Point(52, 27 + 33 * i);
            groupBox1.Controls.Add(lt1);

            tt1          = new TextEdit();
            tt1.Location = new Point(157, 26 + 33 * i);
            tt1.Size     = new Size(231, 21);

            tt1.Properties.DisplayFormat.FormatString = "n4";
            tt1.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
            tt1.Properties.EditFormat.FormatString    = "n4";
            tt1.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Numeric;
            tt1.Properties.Mask.EditMask = "########0.####";
            tt1.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;

            groupBox1.Controls.Add(tt1);

            i++;

            lt6.Text     = "总投资(万元):";
            lt6.Location = new Point(52, 27 + 33 * i);
            groupBox1.Controls.Add(lt6);

            tt6          = new TextEdit();
            tt6.Location = new Point(157, 26 + 33 * i);
            tt6.Size     = new Size(231, 21);

            tt6.Properties.DisplayFormat.FormatString = "n4";
            tt6.Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
            tt6.Properties.EditFormat.FormatString    = "n4";
            tt6.Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Numeric;
            tt6.Properties.Mask.EditMask = "############0.####";
            tt6.Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;

            groupBox1.Controls.Add(tt6);

            i++;


            int j = 0;

            foreach (PowerYears ppy in li)
            {
                lb[j]          = new Label();
                lb[j].Name     = "Label" + ppy.Year;
                lb[j].Text     = ppy.Year + "年:";
                lb[j].Location = new Point(52, 27 + 33 * i);
                groupBox1.Controls.Add(lb[j]);

                te[j]          = new TextEdit();
                te[j].Name     = "Text" + ppy.Year;
                te[j].Location = new Point(157, 26 + 33 * i);
                te[j].Size     = new Size(231, 21);
                te[j].Properties.DisplayFormat.FormatString = "n4";
                te[j].Properties.DisplayFormat.FormatType   = DevExpress.Utils.FormatType.Numeric;
                te[j].Properties.EditFormat.FormatString    = "n4";
                te[j].Properties.EditFormat.FormatType      = DevExpress.Utils.FormatType.Numeric;
                te[j].Properties.Mask.EditMask = "##########0.####";
                te[j].Properties.Mask.MaskType = DevExpress.XtraEditors.Mask.MaskType.Numeric;
                groupBox1.Controls.Add(te[j]);
                if (listValues.Count > 0)
                {
                    foreach (PowerValues ppy1 in listValues)
                    {
                        if (ppy.Year == ppy1.Year)
                        {
                            te[j].Text = ppy1.Value.ToString();
                        }
                    }
                }
                j++;
                i++;
            }


            PowerSubstationLine psl = new PowerSubstationLine();

            psl.Flag  = "1";
            psl.Type  = flag;
            psl.Type2 = type;

            IList <PowerSubstationLine> lli = Itop.Client.Common.Services.BaseService.GetList <PowerSubstationLine>("SelectPowerSubstationLineByFlagType", psl);

            sb = new Label[lli.Count];
            se = new TextEdit[lli.Count];
            j  = 0;
            foreach (PowerSubstationLine pss in lli)
            {
                sb[j]          = new Label();
                sb[j].Name     = "Label" + pss.Title;
                sb[j].Text     = pss.Title + ":";
                sb[j].Location = new Point(52, 27 + 33 * i);
                groupBox1.Controls.Add(sb[j]);

                se[j]          = new TextEdit();
                se[j].Name     = "Text" + pss.Title;
                se[j].Tag      = "Text" + pss.ClassType;
                se[j].Location = new Point(157, 26 + 33 * i);
                se[j].Size     = new Size(231, 21);
                groupBox1.Controls.Add(se[j]);
                try
                {
                    int num = 0;
                    if (se[j].Tag.ToString().Length <= 6)
                    {
                        num = int.Parse(se[j].Tag.ToString().Substring(se[j].Tag.ToString().Length - 1, 1)) - 1;
                    }
                    else
                    {
                        num = int.Parse(se[j].Tag.ToString().Substring(se[j].Tag.ToString().Length - 2, 2)) - 1;
                    }

                    if (ac1[num].ToString() != DBNull.Value.ToString() && ac1[num].ToString() != "")
                    {
                        se[j].Text = ac1[num].ToString();
                    }
                    else
                    {
                        se[j].Text = "";
                    }
                }
                catch (Exception ex)
                {
                    MsgBox.Show(ex.Message);
                }
                j++;
                i++;
            }



            try
            {
                tt1.Text = q3.ToString();
                tt2.Text = q1.ToString();
                tt3.Text = q0.ToString();
                tt4.Text = q2.ToString();
                tt6.Text = q4.ToString();
            }
            catch { }


            groupBox1.Size         = new Size(434, 30 + 33 * i);
            simpleButton1.Location = new Point(296, 50 + 33 * i);
            simpleButton2.Location = new Point(389, 50 + 33 * i);
            this.Size = new Size(490, 130 + 33 * i);
        }
Beispiel #4
0
        private void InsertLineData1()
        {
            PowerTypes m2 = new PowerTypes();

            PowerValues m1 = new PowerValues();

            PowerYears z1 = new PowerYears();

            PowerTypes psp_Type = new PowerTypes();
            object     obj      = Services.BaseService.GetObject("SelectPowerTypesList", "");
            int        z_typeID = (int)Common.Services.BaseService.Create("InsertPowerTypes", psp_Type) - 2;


            try
            {
                DataTable      dts = new DataTable();
                OpenFileDialog op  = new OpenFileDialog();
                op.Filter = "Excel文件(*.xls)|*.xls";
                if (op.ShowDialog() == DialogResult.OK)
                {
                    dts = GetExcel(op.FileName);

                    for (int i = 1; i < dts.Rows.Count; i++)
                    {
                        foreach (DataColumn dc in dts.Columns)
                        {
                            if (dc.Caption.IndexOf("年") > 0)
                            {
                                try
                                {
                                    if (dts.Rows[i][dc.ColumnName].ToString() == "")
                                    {
                                        m1.Value = 0;
                                    }
                                    else
                                    {
                                        m1.Value = double.Parse(dts.Rows[i][dc.ColumnName].ToString());
                                    }
                                    m1.TypeID = z_typeID + 3;



                                    int    eq = dc.ColumnName.IndexOf("年");
                                    string h  = dc.ColumnName.Substring(0, eq);
                                    m1.Year = int.Parse(h);
                                    Services.BaseService.Create <PowerValues>(m1);
                                }
                                catch { }
                            }
                            if (dc.Caption.IndexOf("项目名称") >= 0)
                            {
                                try
                                {
                                    m2.Title = dts.Rows[i][dc.ColumnName].ToString();
                                }
                                catch { }
                            }

                            if (dc.Caption.IndexOf("静态总投资") >= 0)
                            {
                                try
                                {
                                    if (dts.Rows[i][dc.ColumnName].ToString() == "")
                                    {
                                        m2.Jingtai = 0;
                                    }
                                    else
                                    {
                                        m2.Jingtai = double.Parse(dts.Rows[i][dc.ColumnName].ToString());
                                    }
                                }
                                catch { }
                            }
                            if (dc.Caption.IndexOf("建设期间代款利息") >= 0)
                            {
                                try
                                {
                                    if (dts.Rows[i][dc.ColumnName].ToString() == "")
                                    {
                                        m2.Lixi = 0;
                                    }
                                    else
                                    {
                                        m2.Lixi = double.Parse(dts.Rows[i][dc.ColumnName].ToString());
                                    }
                                }
                                catch { }
                            }
                            if (dc.Caption.IndexOf("价格预备费") >= 0)
                            {
                                try
                                {
                                    if (dts.Rows[i][dc.ColumnName].ToString() == "")
                                    {
                                        m2.Yubei = 0;
                                    }
                                    else
                                    {
                                        m2.Yubei = double.Parse(dts.Rows[i][dc.ColumnName].ToString());
                                    }
                                }
                                catch { }
                            }
                            if (dc.Caption.IndexOf("动态投资") >= 0)
                            {
                                try
                                {
                                    if (dts.Rows[i][dc.ColumnName].ToString() == "")
                                    {
                                        m2.Dongtai = 0;
                                    }
                                    else
                                    {
                                        m2.Dongtai = double.Parse(dts.Rows[i][dc.ColumnName].ToString());
                                    }
                                }
                                catch { }
                            }
                        }
                        m2.Flag2 = this.ctrlPowerEachList1.FocusedObject.UID;
                        z_typeID = z_typeID + 1;
                        Services.BaseService.Create <PowerValues>(m1);
                        Services.BaseService.Create <PowerTypes>(m2);
                    }

                    ReLaodData();
                }
            }

            catch { MsgBox.Show("导入格式不正确!"); }
        }