示例#1
0
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (comboBoxEdit3.Text == "")
            {
                MessageBox.Show("竣工年份不能为空"); return;
            }
            if (comboBoxEdit2.Text != "")
            {
                if (int.Parse(comboBoxEdit3.Text) < int.Parse(comboBoxEdit2.Text))
                {
                    MessageBox.Show("结束年必须大于开工年!"); return;
                }
            }
            DialogResult = DialogResult.OK;
            Ps_Table_Edit edit = new Ps_Table_Edit();

            edit.ID        += "|" + GetProject;
            edit.ParentID   = parentid;
            edit.StartYear  = comboBoxEdit2.Text;
            edit.FinishYear = comboBoxEdit3.Text;
            edit.ProjectID  = projectid;
            edit.Status     = "新建";
            edit.Volume     = spinEdit1.Text;
            edit.Col1       = comboBoxEdit1.Text;
            try
            {
                edit.Sort = OperTable.GetChildMaxSort() + 1;
            }
            catch { edit.Sort = 4; }
            if (edit.Sort < 4)
            {
                edit.Sort = 4;
            }
            Common.Services.BaseService.Create("InsertPs_Table_Edit", edit);
        }
示例#2
0
 public void InitCom()
 {
     OperTable oper=new OperTable();
     IList<string> list = oper.GetLineS1("1=1");
     foreach (string str in list)
         comboBoxEdit1.Properties.Items.Add(str);
     if (comboBoxEdit1.Properties.Items.Count > 0)
         comboBoxEdit1.SelectedIndex = 0;
 }
示例#3
0
 public void InitCom()
 {
     OperTable oper = new OperTable();
     //IList<string> list = oper.GetLineS1("1=1");
     //foreach (string str in list)
     //    comboBoxEdit1.Properties.Items.Add(str);
     //if (comboBoxEdit1.Properties.Items.Count > 0)
     //    comboBoxEdit1.SelectedIndex = 0;
 }
示例#4
0
 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
 {
     if (this.gridView2.FocusedRowHandle > -1)
     {
         IList <string> filedList = new List <string>();
         IList <string> capList   = new List <string>();
         for (int i = 0; i < gridView1.Columns.Count; i++)
         {
             capList.Add(gridView1.Columns[i].Caption);
             filedList.Add(gridView1.Columns[i].FieldName);
         }
         OpenFileDialog op = new OpenFileDialog();
         op.Filter = "Excel文件(*.xls)|*.xls";
         if (op.ShowDialog() == DialogResult.OK)
         {
             try
             {
                 DataTable table = OperTable.GetExcel(op.FileName, filedList, capList);
                 for (int i = 0; i < table.Rows.Count; i++)
                 {
                     if (table.Rows[i][0].ToString().IndexOf("合计") > 0 || table.Rows[i][1].ToString().IndexOf("合计") > 0)
                     {
                         continue;
                     }
                     PSP_PowerSubstationInfo area = new PSP_PowerSubstationInfo();
                     area.UID        = Guid.NewGuid().ToString() + "|" + ProjectID;
                     area.AreaID     = ProjectID;
                     area.CreateDate = DateTime.Now;
                     string f = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "Title").ToString();
                     if (f == "现状")
                     {
                         f = "1";
                     }
                     else if (f == "规划")
                     {
                         f = "2";
                     }
                     area.Flag = f;
                     foreach (DataColumn col in table.Columns)
                     {
                         area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null);
                     }
                     Common.Services.BaseService.Create <PSP_PowerSubstationInfo>(area);
                 }
             }
             catch (Exception a) { MessageBox.Show(a.Message); }
             InitGrid1();
         }
     }
     else
     {
         MessageBox.Show("没有选择规划或现状", "导入EXCEL", MessageBoxButtons.OK);
     }
 }
示例#5
0
        protected bool SaveRecord()
        {
            try
            {
                _obj.GDPper = Math.Round((_obj.Population == 0.0 ? 0.0 : 10000 * _obj.GDP / _obj.Population), 2);
                if (IsCreate)
                {
                    //Ps_Table_GDP pg = new Ps_Table_GDP();
                    //pg.ID = _obj.ID;
                    //pg.GDP = _obj.GDP;
                    //pg.Population = _obj.Population;
                    //pg.Yearf = _obj.Yearf;
                    //pg.GDPrate = _obj.GDPrate;
                    _obj.ID       += "|" + projectid;
                    _obj.ParentID  = parentid;
                    _obj.ProjectID = projectid;
                    _obj.SortID    = OperTable.GetGDPMaxSort() + 1;
                    IList <Ps_Table_GDP> list = Common.Services.BaseService.GetList <Ps_Table_GDP>("SelectPs_Table_GDPByConn", " ProjectID='" + _obj.ProjectID + "' and ParentID='" + _obj.ParentID + "' and Yearf='" + _obj.Yearf + "'");
                    if (list.Count > 0)
                    {
                        MessageBox.Show("创建的年份不能够重复!");
                        _obj = new Ps_Table_GDP();
                        IList <Ps_Table_GDP> list1 = new List <Ps_Table_GDP>();
                        list1.Add(_obj);
                        this.vGridControl.DataSource = list1;
                        return(false);
                    }
                    Services.BaseService.Create <Ps_Table_GDP>(_obj);
                }
                else
                {
                    IList <Ps_Table_GDP> list = Common.Services.BaseService.GetList <Ps_Table_GDP>("SelectPs_Table_GDPByConn", " ProjectID='" + _obj.ProjectID + "' and ParentID='" + _obj.ParentID + "' and Yearf='" + _obj.Yearf + "'");
                    foreach (Ps_Table_GDP pg in list)
                    {
                        if (pg.ID != _obj.ID)
                        {
                            MessageBox.Show("已经存在此年数据,请重新修改!");
                            return(false);
                        }
                    }

                    Services.BaseService.Update <Ps_Table_GDP>(_obj);
                }
            }
            catch (Exception exc)
            {
                Debug.Fail(exc.Message);
                HandleException.TryCatch(exc);
                return(false);
            }

            //操作已成功
            return(true);
        }
示例#6
0
 private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
 {
     if (this.gridView2.FocusedRowHandle > -1)
     {
         IList <string> filedList = new List <string>();
         IList <string> capList   = new List <string>();
         for (int i = 0; i < gridView1.Columns.Count; i++)
         {
             capList.Add(gridView1.Columns[i].Caption);
             filedList.Add(gridView1.Columns[i].FieldName);
         }
         OpenFileDialog op = new OpenFileDialog();
         op.Filter = "Excel文件(*.xls)|*.xls";
         if (op.ShowDialog() == DialogResult.OK)
         {
             try
             {
                 DataTable table = OperTable.GetExcel(op.FileName, filedList, capList);
                 for (int i = 0; i < table.Rows.Count; i++)
                 {
                     if (table.Rows[i][0].ToString().IndexOf("合计") > 0 || table.Rows[i][1].ToString().IndexOf("合计") > 0)
                     {
                         continue;
                     }
                     Ps_Table_GDP area = new Ps_Table_GDP();
                     area.ID       += "|" + ProjectID;
                     area.SortID    = OperTable.GetGDPMaxSort() + 1;
                     area.ParentID  = this.gridView2.GetRowCellValue(this.gridView2.FocusedRowHandle, "ID").ToString();
                     area.ProjectID = ProjectID;
                     foreach (DataColumn col in table.Columns)
                     {
                         if (col.ColumnName == "Yearf")
                         {
                             area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(table.Rows[i][col].ToString()), null);
                         }
                         else
                         {
                             area.GetType().GetProperty(col.ColumnName).SetValue(area, double.Parse(table.Rows[i][col].ToString()), null);
                         }
                     }
                     Common.Services.BaseService.Create <Ps_Table_GDP>(area);
                 }
             }
             catch { }
             InitGrid1();
         }
     }
     else
     {
         MessageBox.Show("没有选择地区(如果没有请添加一个)", "导入EXCEL", MessageBoxButtons.OK);
     }
 }
示例#7
0
        private void barButtonItem8_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            IList <string> filedList = new List <string>();
            IList <string> capList   = new List <string>();

            for (int i = 0; i < gridView2.Columns.Count; i++)
            {
                if (gridView2.Columns[i].Visible == true)
                {
                    capList.Add(gridView2.Columns[i].Caption);
                    filedList.Add(gridView2.Columns[i].FieldName);
                }
            }
            OpenFileDialog op = new OpenFileDialog();

            op.Filter = "Excel文件(*.xls)|*.xls";
            if (op.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    DataTable table = OperTable.GetExcel(op.FileName, filedList, capList);
                    for (int i = 0; i < table.Rows.Count; i++)
                    {
                        if (table.Rows[i][0].ToString().IndexOf("建表时间") >= 0)
                        {
                            continue;
                        }
                        PS_Table_Area_TYPE area = new PS_Table_Area_TYPE();
                        area.ID       += "|" + ProjectID;
                        area.ProjectID = ProjectID;
                        foreach (DataColumn col in table.Columns)
                        {
                            if (col.ColumnName == "Yearf")
                            {
                                area.GetType().GetProperty(col.ColumnName).SetValue(area, int.Parse(table.Rows[i][col].ToString()), null);
                            }
                            else
                            {
                                area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null);
                            }
                        }
                        Common.Services.BaseService.Create <PS_Table_Area_TYPE>(area);
                    }
                }
                catch { }
                InitGrid2();
            }
        }
示例#8
0
        protected bool SaveRecord()
        {
            try
            {
                if (IsCreate)
                {
                    string id = _obj.ID;
                    _obj.ID       += "|" + projectid;
                    _obj.ParentID  = parentid;
                    _obj.ProjectID = projectid;
                    _obj.SortID    = OperTable.GetAreaMaxSort() + 1;
                    IList <Ps_Table_AreaData> list = Common.Services.BaseService.GetList <Ps_Table_AreaData>("SelectPs_Table_AreaDataByConn", " ParentID='" + parentid + "' and ProjectID='" + projectid + "'and Yearf='" + _obj.Yearf + "'");
                    if (list.Count > 0)
                    {
                        MessageBox.Show("存在重复年份,请重新添加年份!");
                        _obj.ID = id;
                        return(false);
                    }
                    Services.BaseService.Create <Ps_Table_AreaData>(_obj);
                }
                else
                {
                    IList <Ps_Table_AreaData> list = Common.Services.BaseService.GetList <Ps_Table_AreaData>("SelectPs_Table_AreaDataByConn", " ParentID='" + parentid + "' and ProjectID='" + projectid + "'and Yearf='" + _obj.Yearf + "'");

                    foreach (Ps_Table_AreaData pa in list)
                    {
                        if (pa.ID != _obj.ID)
                        {
                            MessageBox.Show("存在重复年份,请重新添加年份!");
                            return(false);
                        }
                    }
                    Services.BaseService.Update <Ps_Table_AreaData>(_obj);
                }
            }
            catch (Exception exc)
            {
                Debug.Fail(exc.Message);
                HandleException.TryCatch(exc);
                return(false);
            }

            //操作已成功
            return(true);
        }
示例#9
0
        //添加地区
        private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            FrmAddPN frm = new FrmAddPN();

            frm.SetFrmName   = "添加地区";
            frm.SetLabelName = "地区名称";
            if (frm.ShowDialog() == DialogResult.OK)
            {
                Ps_Table_GDP data = new Ps_Table_GDP();
                data.ID       += "|" + ProjectID;
                data.ParentID  = "0";
                data.ProjectID = ProjectID;
                data.SortID    = OperTable.GetGDPMaxSort() + 1;
                data.Area      = frm.ParentName;
                Common.Services.BaseService.Create <Ps_Table_GDP>(data);
            }
            InitGrid2();
        }
示例#10
0
        //增加
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (comboBoxEdit3.Text == "")
            {
                MessageBox.Show("竣工年份不能为空"); return;
            }
            if (comboBoxEdit1.Text != "已有" && comboBoxEdit2.Text != "")
            {
                if (int.Parse(comboBoxEdit3.Text) < int.Parse(comboBoxEdit2.Text))
                {
                    MessageBox.Show("竣工年必须大于开工年!"); return;
                }
            }
            // DialogResult = DialogResult.OK;
            Ps_Table_Edit edit = new Ps_Table_Edit();

            edit.ID        += "|" + GetProject;
            edit.ParentID   = parentid;
            edit.StartYear  = comboBoxEdit1.Text == "已有" ? "" : comboBoxEdit2.Text;
            edit.FinishYear = comboBoxEdit1.Text == "已有" ? "" : comboBoxEdit3.Text;
            edit.Status     = comboBoxEdit1.Text;
            edit.Volume     = this.spinEdit1.Text;
            edit.ProjectID  = GetProject;
            edit.Col4       = mark;
            try
            {
                edit.Sort = OperTable.GetChildMaxSort() + 1;
            }
            catch { edit.Sort = 4; }
            if (edit.Sort < 4)
            {
                edit.Sort = 4;
            }
            Common.Services.BaseService.Create("InsertPs_Table_Edit", edit);
            strResult.Add(textEdit1.Text);
            strResult.Add(comboBoxEdit3.Text);
            strResult.Add(spinEdit1.Value.ToString());
            string conn = "ParentID='" + parentid + "'";

            list = Common.Services.BaseService.GetList <Ps_Table_Edit>("SelectPs_Table_EditListByConn", conn);
            LoadGridData();
            label7.Text = GetCurVolumn();
        }
示例#11
0
        private void barButtonItem1_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            FrmAddTzgsWH2pw frm = new FrmAddTzgsWH2pw();

            frm.Text = "增加";
            // frm.Stat = focusedNode.GetValue("Col2").ToString();
            // frm.SetLabelName = "子分类名称";
            if (frm.ShowDialog() == DialogResult.OK)
            {
                Ps_Table_TZGS table1 = new Ps_Table_TZGS();
                table1.ID   += "|" + GetProjectID;
                frm.tzgspwid = table1.ID;

                table1.Title     = frm.ParentName;
                table1.ParentID  = "0";// focusedNode.GetValue("ID").ToString();
                table1.ProjectID = GetProjectID;
                table1.BuildYear = frm.StartYear;
                table1.BuildEd   = frm.FinishYear;
                table1.FromID    = "0";
                //table1.AllVolumn = frm.AllVol;
                //table1.AftVolumn = frm.AllVol;
                table1.LineInfo = frm.LineInfo;
                table1.BianInfo = frm.BianInfo;
                table1.AreaName = frm.AreaName;
                table1.Length   = frm.LineLen;
                table1.Length2  = frm.LineLen2;
                table1.Sort     = OperTable.GetTZGSMaxSort() + 1;
                table1.Col3     = frm.Col3;
                table1.Col1     = frm.BieZhu;
                table1.DQ       = frm.DQ;
                table1.JGNum    = frm.JGNum;
                table1.WGNum    = frm.WGNum;
                table1.ProgType = frm.ProgType;
                table1.Amount   = frm.Amount;
                table1.Num6     = frm.Num6;
                table1.Col4     = "pw";
                frm.StrType     = "pw";
                table1.Amount   = frm.Amount;
                try
                {
                    string pid = table1.ID;
                    string tit = table1.Title;

                    Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1);
                    frm.StrType  = "pw-pb";
                    table1.Title = tit + "-配变";
                    table1.Col4  = "pw-pb";
                    //table1.Volumn = frm.Vol;
                    table1.ParentID = pid;
                    table1.ID       = Guid.NewGuid().ToString();
                    table1.Num1     = frm.Num1;
                    table1.Num2     = frm.Num2;
                    table1.Num3     = frm.Num3;
                    table1.Num4     = frm.Num4;
                    table1.Num5     = frm.Num5;
                    table1.Num6     = frm.Num6;
                    table1.Amount   = frm.Amount;
                    Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1);
                    frm.StrType     = "pw-kg";
                    table1.Title    = tit + "-开关";
                    table1.Col4     = "pw-kg";
                    table1.ParentID = pid;
                    table1.ID       = Guid.NewGuid().ToString();
                    table1.Num1     = frm.Num1;
                    table1.Num2     = frm.Num2;
                    table1.Num3     = frm.Num3;
                    table1.Num4     = frm.Num4;
                    table1.Amount   = frm.Amount;
                    Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1);
                    frm.StrType     = "pw-line";
                    table1.Title    = tit + "-线路";
                    table1.Col4     = "pw-line";
                    table1.Length   = frm.LineLen;
                    table1.ParentID = pid;
                    table1.ID       = Guid.NewGuid().ToString();
                    table1.LineInfo = frm.LineInfo;
                    table1.Num1     = frm.Num1;
                    table1.Num2     = frm.Num2;
                    table1.Num3     = frm.Num3;
                    table1.Num4     = frm.Num4;
                    table1.Num5     = frm.Num5;
                    table1.Num6     = frm.Num6;
                    table1.Length   = frm.LineLen;
                    table1.Length2  = frm.LineLen2;
                    table1.Amount   = frm.Amount;
                    Common.Services.BaseService.Create("InsertPs_Table_TZGS", table1);

                    LoadData();
                }
                catch (Exception ex)
                {
                    MsgBox.Show("增加工程出错:" + ex.Message);
                }
            }
        }
示例#12
0
        //导入数据
        private void barButtonItem12_ItemClick(object sender, DevExpress.XtraBars.ItemClickEventArgs e)
        {
            IList <string> filedList = new List <string>();
            IList <string> capList   = new List <string>();

            for (int i = 0; i < gridView1.Columns.Count; i++)
            {
                if (gridView1.Columns[i].Visible == true)
                {
                    capList.Add(gridView1.Columns[i].Caption);
                    filedList.Add(gridView1.Columns[i].FieldName);
                }
            }
            OpenFileDialog op = new OpenFileDialog();

            op.Filter = "Excel文件(*.xls)|*.xls";
            string Message = "";

            if (op.ShowDialog() == DialogResult.OK)
            {
                try
                {
                    DataTable table = OperTable.GetExcel(op.FileName, filedList, capList);
                    for (int i = 0; i < table.Rows.Count; i++)
                    {
                        if (table.Rows[i][0].ToString().IndexOf("建表时间") >= 0)
                        {
                            continue;
                        }
                        Ps_Table_Report area = new Ps_Table_Report();
                        area.ProjectID = MIS.ProgUID;
                        foreach (DataColumn col in table.Columns)
                        {
                            if (col.ColumnName == "Num1" || col.ColumnName == "image1" || col.ColumnName == "image2")
                            {
                                //area.GetType().GetProperty(col.ColumnName).SetValue(area, Convert.ToInt32(table.Rows[i][col]), null);
                            }
                            else if (col.ColumnName == "TableID")
                            {
                                string con = " TableID='" + table.Rows[i][col].ToString() + "' and ProjectID='" + MIS.ProgUID + "'";
                                IList <Ps_Table_Report> templist = Common.Services.BaseService.GetList <Ps_Table_Report>("SelectPs_Table_ReportListByConn", con);
                                if (templist.Count > 0)
                                {
                                    Message = "[" + table.Rows[i][col].ToString() + "]";
                                }
                                else
                                {
                                    area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col].ToString(), null);
                                }
                            }
                            else
                            {
                                area.GetType().GetProperty(col.ColumnName).SetValue(area, table.Rows[i][col], null);
                            }
                        }
                        area.Num1   = Convert.ToInt32(Common.Services.BaseService.GetObject("SelectPs_Table_ReportMaxNum1", " ProjectID='" + MIS.ProgUID + "'")) + 1;
                        area.image1 = new byte[0];
                        area.image2 = new byte[0];
                        Common.Services.BaseService.Create <Ps_Table_Report>(area);
                    }
                    InitData();
                    MessageBox.Show("导入完成!");
                    if (Message.Length != 0)
                    {
                        MessageBox.Show("表标识" + Message + " 已经存在,未重复添加!");
                    }
                }
                catch { MessageBox.Show("格式有误,导入失败!"); }
            }
        }
示例#13
0
        //增加
        private void simpleButton1_Click(object sender, EventArgs e)
        {
            if (comboBoxEdit3.Text == "")
            {
                MessageBox.Show("竣工年份不能为空"); return;
            }
            if (comboBoxEdit1.Text != "已有" && comboBoxEdit2.Text != "")
            {
                if (int.Parse(comboBoxEdit3.Text) < int.Parse(comboBoxEdit2.Text))
                {
                    MessageBox.Show("竣工年必须大于开工年!"); return;
                }
            }
            // DialogResult = DialogResult.OK;
            Ps_Table_Edit edit = new Ps_Table_Edit();

            edit.ID        += "|" + GetProject;
            edit.ParentID   = parentid;
            edit.StartYear  = comboBoxEdit1.Text == "已有" ? "" : comboBoxEdit2.Text;
            edit.FinishYear = comboBoxEdit1.Text == "已有" ? "" : comboBoxEdit3.Text;
            edit.Status     = comboBoxEdit1.Text;
            edit.Volume     = this.spinEdit1.Text;
            edit.ProjectID  = GetProject;
            edit.Col4       = mark;
            try
            {
                edit.Sort = OperTable.GetChildMaxSort() + 1;
            }
            catch { edit.Sort = 4; }
            if (edit.Sort < 4)
            {
                edit.Sort = 4;
            }
            Common.Services.BaseService.Create("InsertPs_Table_Edit", edit);
            strResult.Add(textEdit1.Text);
            strResult.Add(comboBoxEdit3.Text);
            strResult.Add(spinEdit1.Value.ToString());
            string conn = "ParentID='" + parentid + "'";

            list = Common.Services.BaseService.GetList <Ps_Table_Edit>("SelectPs_Table_EditListByConn", conn);
            if (typeTable == "500")
            {
                Ps_Table_500PH table = new Ps_Table_500PH();
                table = Common.Services.BaseService.GetOneByKey <Ps_Table_500PH>(parentid);
                if (comboBoxEdit1.Text == "扩建/改造")
                {
                    for (int i = int.Parse(comboBoxEdit3.Text); i <= yearRange.FinishYear; i++)
                    {
                        string a = table.GetType().GetProperty("y" + i.ToString()).GetValue(table, null).ToString();

                        table.GetType().GetProperty("y" + i.ToString()).SetValue(table, Convert.ToDouble(a) + Convert.ToDouble(spinEdit1.Text), null);
                    }
                    Common.Services.BaseService.Update("UpdatePs_Table_500PH", table);
                }
            }
            else if (typeTable == "200")
            {
                Ps_Table_200PH table = new Ps_Table_200PH();
                table = Common.Services.BaseService.GetOneByKey <Ps_Table_200PH>(parentid);
                if (comboBoxEdit1.Text == "扩建/改造")
                {
                    for (int i = int.Parse(comboBoxEdit3.Text); i <= yearRange.FinishYear; i++)
                    {
                        string a = table.GetType().GetProperty("y" + i.ToString()).GetValue(table, null).ToString();
                        table.GetType().GetProperty("y" + i.ToString()).SetValue(table, Convert.ToDouble(a) + Convert.ToDouble(spinEdit1.Text), null);
                    }
                    Common.Services.BaseService.Update("UpdatePs_Table_200PH", table);
                }
            }
            else if (typeTable == "100")
            {
                Ps_Table_100PH table = new Ps_Table_100PH();
                table = Common.Services.BaseService.GetOneByKey <Ps_Table_100PH>(parentid);
                if (comboBoxEdit1.Text == "扩建/改造")
                {
                    for (int i = int.Parse(comboBoxEdit3.Text); i <= yearRange.FinishYear; i++)
                    {
                        string a = table.GetType().GetProperty("y" + i.ToString()).GetValue(table, null).ToString();
                        table.GetType().GetProperty("y" + i.ToString()).SetValue(table, Convert.ToDouble(a) + Convert.ToDouble(spinEdit1.Text), null);
                    }
                    Common.Services.BaseService.Update("UpdatePs_Table_100PH", table);
                }
            }



            LoadGridData();
            label7.Text = GetCurVolumn();
        }
示例#14
0
        //500千伏分区分年容载比计算表
        private void build_500rzbtj()
        {
            Dictionary<string, Columqk> viscol = new Dictionary<string, Columqk>();
            string title = "500千伏分区分年容载比计算表";
            OperTable oper = new OperTable();
            yAnge = oper.GetYearRange("Col5='" + GetProjectID + "' and Col4='" + OperTable.ph500 + "'");
            System.Data.DataTable datatable = get500phtable(yAnge);
            System.Data.DataTable dt = ResultDataTable1(ConvertTreeListToDataTable(datatable, false, yAnge), ref viscol, yAnge);
            if (!shjjbyyear)
            {
                creatsheetbydt(title, dt, viscol);
            }

            else
            {
                recreatsheetbydt(title, dt, viscol, 1);
            }
        }