Exemplo n.º 1
0
        private void paintFrm()
        {
            try
            {
                string strSql = String.Format("select CountryName,CountryDes,townName from tbCountry");

                DataTable dtCountry = null;
                CDBConnection.getDataTable(ref dtCountry, strSql, "btCountry");

                this.lsvCountry.Items.Clear();

                for (int i = 0; i < dtCountry.Rows.Count; i++)
                {
                    this.lsvCountry.Items.Add(dtCountry.Rows[i]["countryName"].ToString());
                    this.lsvCountry.Items[i].SubItems.Add(dtCountry.Rows[i]["townName"].ToString());
                    this.lsvCountry.Items[i].SubItems.Add(dtCountry.Rows[i]["countryDes"].ToString());
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Exemplo n.º 2
0
        //»æÖƵ¥Î»Ê÷
        public bool paintTrVDep(System.Windows.Forms.TreeView trvDep)
        {
            try
            {
                string    strSql = "select townName from tbTown";
                DataTable dtTown = null;
                CDBConnection.getDataTable(ref dtTown, strSql, "tbTown");
                for (int i = 0; i < dtTown.Rows.Count; i++)
                {
                    string strTownName = dtTown.Rows[i]["townName"].ToString();
                    trvDep.Nodes.Add(dtTown.Rows[i]["townName"].ToString());
                    DataTable dtCountry = null;
                    strSql = String.Format("select countryName from tbCountry where townName='{0}'", strTownName);
                    CDBConnection.getDataTable(ref dtCountry, strSql, "tbCountry");

                    for (int j = 0; j < dtCountry.Rows.Count; j++)
                    {
                        trvDep.Nodes[i].Nodes.Add(dtCountry.Rows[j]["countryName"].ToString());
                        string strCountryName = dtCountry.Rows[j]["countryName"].ToString();
                        strSql = String.Format("select depShortName from tbDep where countryName='{0}'", strCountryName);
                        DataTable dtDep = null;
                        CDBConnection.getDataTable(ref dtDep, strSql, "dtDep");
                        for (int z = 0; z < dtDep.Rows.Count; z++)
                        {
                            trvDep.Nodes[i].Nodes[j].Nodes.Add(dtDep.Rows[z]["depShortName"].ToString());
                        }
                    }
                }
                return(true);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return(false);
            }
        }
Exemplo n.º 3
0
        private void frmBengZhanEdit_Load(object sender, System.EventArgs e)
        {
            try
            {
                if (this.m_bEdit == false)
                {
                    //生成监测站编号
                    string strSql = "select tbNo from tbDel where tbName='tbWell'";

                    string strWellNo = CDBConnection.ExecuteScalar(strSql);

                    if (strWellNo.Trim() != "")
                    {
                        this.txtWellNo.Text = strWellNo;
                    }
                    else
                    {
                        strSql = "select count(*) from tbWell";
                        int iCount = 0;
                        iCount = Convert.ToInt32(CDBConnection.ExecuteScalar(strSql));
                        iCount = iCount + 1;

                        strWellNo           = cStr(iCount.ToString());
                        this.txtWellNo.Text = strWellNo;
                    }
                    this.txtDepShortName.Text = this.m_strDepName;
                }
                else
                {
                    string    strSql = String.Format("select wellNo,wellName,depName,gprsNo,watAddress,wellDes,ICNo,iniAmount,watchNo,xi,warnAmount,price1,x,y from tbWell where wellNo='{0}'", this.m_strWellNo);
                    DataTable dtWell = null;
                    CDBConnection.getDataTable(ref dtWell, strSql, "tbWell");

                    this.txtWellNo.Text   = dtWell.Rows[0]["wellNo"].ToString();
                    this.txtWellName.Text = dtWell.Rows[0]["wellName"].ToString();
                    string strAddress = dtWell.Rows[0]["watAddress"].ToString();
                    int    iAddress   = Convert.ToInt32(strAddress);
                    strAddress                = iAddress.ToString("x");
                    this.txtAddress.Text      = strAddress;
                    this.txtDes.Text          = dtWell.Rows[0]["wellDes"].ToString();
                    this.txtGprsNo.Text       = dtWell.Rows[0]["gprsNo"].ToString();
                    this.txtDepShortName.Text = dtWell.Rows[0]["depName"].ToString();
                    this.txtICNo.Text         = dtWell.Rows[0]["ICNo"].ToString();

                    this.txtIniAmount.Text = dtWell.Rows[0]["iniAmount"].ToString().Trim();
                    this.txtWatNo.Text     = dtWell.Rows[0]["watchNo"].ToString().Trim();
                    this.txtWarnLevel.Text = dtWell.Rows[0]["warnAmount"].ToString().Trim();
                    this.txtXi.Text        = dtWell.Rows[0]["xi"].ToString().Trim();
                    this.txtX.Text         = dtWell.Rows[0]["x"].ToString().Trim();
                    this.txtY.Text         = dtWell.Rows[0]["y"].ToString().Trim();
                    this.txtPrice.Text     = dtWell.Rows[0]["price1"].ToString().Trim();
                }

                paintJTPrice();
                addCmbPrice();
            }

            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Exemplo n.º 4
0
        //*******************数据库操作区*****************
        #region "数据库查询"
/// <summary>
/// 已审
/// </summary>
/// <param name="strWellNo">监测站编号</param>
/// <param name="strUserName">操作员名称</param>
        private void paintReport(string strWellNo, string strUserName)
        {
            try
            {
                string strFrom  = String.Format("{0}-{1}-{2}", this.dtpFrom.Value.Year.ToString(), this.dtpFrom.Value.Month.ToString(), this.dtpFrom.Value.Day.ToString());
                string strTo    = String.Format("{0}-{1}-{2}", this.dtpTo.Value.Year.ToString(), this.dtpTo.Value.Month.ToString(), this.dtpTo.Value.Day.ToString());
                string strTitle = "";


                //监测站统计sql1******************************sql语句
                string strSql = String.Format("select tbSal.wellNo as Field1,depName as Field2,price as Field3,salMony as Field4,salAmount as Field5,salPer as Field6,time as Field7 from tbSal,tbWell where (cast(floor(cast(time as float)) as datetime) between '{0}' and '{1}') and tbSal.wellNo=tbWell.wellNo and tbSal.wellNo='{2}' order by time", strFrom, strTo, strWellNo);
                strTitle = "单位购水统计表";
                if (strWellNo.Trim() == "")
                {
                    if (strUserName.Trim() == "")
                    {
                        //无查询条件sql2
                        strSql = String.Format("select tbSal.wellNo as Field1,depName as Field2,price as Field3,salMony as Field4,salAmount as Field5,salPer as Field6,time as Field7 from tbSal,tbWell where (cast(floor(cast(time as float)) as datetime) between '{0}' and '{1}') and tbSal.wellNo=tbWell.wellNo order by time", strFrom, strTo);
                    }
                    else
                    {
                        //操作员统计sql3*****
                        strSql   = String.Format("select tbSal.wellNo as Field1,depName as Field2,price as Field3,salMony as Field4,salAmount as Field5,salPer as Field6,time as Field7 from tbSal,tbWell where (cast(floor(cast(time as float)) as datetime) between '{0}' and '{1}') and tbSal.wellNo=tbWell.wellNo and tbSal.salPer='{2}' order by time", strFrom, strTo, strUserName);
                        strTitle = "操作员售水统计表";
                    }
                }
                //**************************************


                //统计合计
                DataTable dt = null;
                CDBConnection.getDataTable(ref dt, strSql, "tbSalWater");
                double iSalAmount = 0, iSalMony = 0;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    iSalAmount = iSalAmount + Convert.ToDouble(dt.Rows[i]["Field5"]);
                    iSalMony   = iSalMony + Convert.ToDouble(dt.Rows[i]["Field4"]);
                }
                DataRow dr = dt.NewRow();
                dr["Field1"] = "合计";
                dr["Field4"] = iSalMony.ToString();
                dr["Field5"] = iSalAmount.ToString();
                dt.Rows.Add(dr);
                //************************

                //报表显示
                string   strTime = String.Format("时间范围:{0}至{1}", strFrom, strTo);
                string[] strText = new string[7];
                strText[0] = "监测站编号";
                strText[1] = "单位名称";
                strText[2] = "售水单价";
                strText[3] = "售水金额";
                strText[4] = "售水量";
                strText[5] = "售水人";
                strText[6] = "售水时间";

                printDoc.crpPrint crpPrintObj = new BengZhan.printDoc.crpPrint();
                CrystalDecisions.CrystalReports.Engine.TextObject toTitle = (CrystalDecisions.CrystalReports.Engine.TextObject)crpPrintObj.ReportDefinition.ReportObjects["txtTime"];
                toTitle.Text = strTime;
                toTitle      = (CrystalDecisions.CrystalReports.Engine.TextObject)crpPrintObj.ReportDefinition.ReportObjects["txtTitle"];
                if (strTitle != "")
                {
                    toTitle.Text = strTitle;
                }
                for (int i = 0; i < 7; i++)
                {
                    int    iNum         = i + 1;
                    string strTextTitle = "Text" + iNum.ToString();
                    CrystalDecisions.CrystalReports.Engine.TextObject to = (CrystalDecisions.CrystalReports.Engine.TextObject)crpPrintObj.ReportDefinition.ReportObjects[strTextTitle];
                    to.Text = strText[i].ToString();
                }

                crpPrintObj.SetDataSource(dt);
                this.crpSalWater.ReportSource = crpPrintObj;
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Exemplo n.º 5
0
        //绘制图表
        public bool PaintFrm(string strWellNo)
        {
            try
            {
                string strFrom    = String.Format("{0}-{1}-{2}", this.dtFrom.Value.Year.ToString(), this.dtFrom.Value.Month.ToString(), this.dtFrom.Value.Day.ToString());
                string strTo      = String.Format("{0}-{1}-{2}", this.dtTo.Value.Year.ToString(), this.dtTo.Value.Month.ToString(), this.dtTo.Value.Day.ToString());
                string strSql     = String.Format("select depName from tbWell where wellNo='{0}'", strWellNo);
                string strDepName = CDBConnection.ExecuteScalar(strSql);
                this.lblInfo.Text = String.Format("水井编号:{0} 单位名称:{3} 日期:{1} 至 {2}", strWellNo, strFrom, strTo, strDepName);


                DataTable dtLine1 = new  DataTable();

                DataTable dtLine2 = new DataTable();

                if (this.m_strDrawLine1Sql != "")
                {
                    //查询第一条线的sql语句
                    strSql = this.m_strDrawLine1Sql;
                    DataTable dt = new DataTable();
                    CDBConnection.getDataTable(ref dt, strSql, "tbData");
                    dtLine1 = dt;
                }

                if (this.m_strDrawLine2Sql != "")
                {
                    //查询第二条线的sql语句
                    strSql = this.m_strDrawLine2Sql;
                    DataTable dt = new DataTable();
                    CDBConnection.getDataTable(ref dt, strSql, "tbData");
                    dtLine2 = dt;
                }

                ZedGraph.Demo.DateAxisSampleDemo demo = new ZedGraph.Demo.DateAxisSampleDemo();

                demo.m_dtLine1  = dtLine1;
                demo.m_strTitle = "";

                demo.m_dtLine2 = dtLine2;
                //第一条线名称
                demo.m_strLine1Name = this.m_strColTitle1;
                //第二条线名称
                demo.m_strLine2Name = this.m_strColTitle2;
                if (strFrom != strTo)
                {
                    //绘图
                    demo.m_strState = "month";
                }
                else
                {
                    //绘图
                    demo.m_strState = "Day";
                }


                demo.initialDateAxis();



                if (demo == null)
                {
                    return(false);
                }

                this.tabChart.TabPages[0].Controls.Clear();
                this.tabChart.TabPages[0].Controls.Add(this.lblInfo);
                this.tabChart.TabPages[0].Controls.Add(demo.ZedGraphControl);

                //demo.ZedGraphControl.Top=this.label1.Top+this.label1.Height;
                demo.ZedGraphControl.Top    = 10;
                demo.ZedGraphControl.Left   = 10;
                demo.ZedGraphControl.Width  = tabChart.Width - 20;
                demo.ZedGraphControl.Height = tabChart.Height - 40;

                demo.ZedGraphControl.Anchor = AnchorStyles.Left | AnchorStyles.Top
                                              | AnchorStyles.Right | AnchorStyles.Bottom;

                //this.Text				= TitlePrefix + demo.Title;

                //descriptionBox.Text	= demo.Description;

                // tell the control to rescale itself
                demo.ZedGraphControl.AxisChange();

                // redraw the entire form
                this.Invalidate();
                return(true);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                return(false);
            }
        }
Exemplo n.º 6
0
        private void frmDepEdit_Load(object sender, System.EventArgs e)
        {
            try
            {
                string    strSql    = String.Format("select countryName from tbCountry");
                DataTable dtCountry = null;
                CDBConnection.getDataTable(ref dtCountry, strSql, "dtCountry");

                this.cmbCountry.Items.Clear();
                for (int i = 0; i < dtCountry.Rows.Count; i++)
                {
                    this.cmbCountry.Items.Add(dtCountry.Rows[i]["countryName"].ToString());
                }

                if (this.cmbCountry.Items.Count > 0)
                {
                    this.cmbCountry.Text = this.cmbCountry.Items[0].ToString();
                }
                else
                {
                    this.cmbCountry.Text = "";
                }

                this.cmbHangYe.Items.Clear();

                strSql = "select hangYeName from tbHangYe";
                DataTable dtHangYe = null;
                CDBConnection.getDataTable(ref dtHangYe, strSql, "HangYe");
                for (int i = 0; i < dtHangYe.Rows.Count; i++)
                {
                    this.cmbHangYe.Items.Add(dtHangYe.Rows[i]["HangYeName"].ToString());
                }

                if (this.cmbHangYe.Items.Count > 0)
                {
                    this.cmbHangYe.Text = this.cmbHangYe.Items[0].ToString();
                }
                else
                {
                    this.cmbHangYe.Text = "";
                }

                if (this.m_bEdit == false)
                {
                    this.cmbCountry.Text = this.m_strCountryName;
                }
                else
                {
                    strSql = String.Format("select depShortName,depName,CountryName,HangYeName,ContactPer,ContactTel,address,des from tbDep where depShortName='{0}'", this.m_strDepShortName.Trim());
                    DataTable dtDep = null;

                    if (CDBConnection.getDataTable(ref dtDep, strSql, "dep") == false)
                    {
                        return;
                    }
                    if (dtDep.Rows.Count > 0)
                    {
                        this.txtDepShortName.Text     = dtDep.Rows[0]["depShortName"].ToString();
                        this.txtDepShortName.ReadOnly = true;
                        this.txtDepName.Text          = dtDep.Rows[0]["depName"].ToString();
                        this.txtAddress.Text          = dtDep.Rows[0]["address"].ToString();
                        this.txtContactPer.Text       = dtDep.Rows[0]["ContactPer"].ToString();
                        this.txtContactTel.Text       = dtDep.Rows[0]["ContactTel"].ToString();
                        this.txtDes.Text     = dtDep.Rows[0]["des"].ToString();
                        this.cmbHangYe.Text  = dtDep.Rows[0]["HangYeName"].ToString();
                        this.cmbCountry.Text = dtDep.Rows[0]["CountryName"].ToString();
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }
Exemplo n.º 7
0
        private void lswUserInfo_Click(object sender, System.EventArgs e)
        {
            try
            {
                if (lswUserInfo.SelectedItems.Count == 0)
                {
                    return;
                }

                if (checkSelectedItem() == false)
                {
                    //判断是否同权限
                    //return;
                }

                for (int z = 0; z < this.tvwMenuInfo.Nodes.Count; z++)
                {
                    this.tvwMenuInfo.Nodes[z].Checked = false;
                    CheckAllChildNodes(this.tvwMenuInfo.Nodes[z], false);
                }

                string    strUserID  = this.lswUserInfo.SelectedItems[0].Text.Trim();
                string    strSql     = String.Format("select ltrim(rtrim(menuName)) as menuName from  userMenu where userID='{0}'", strUserID);
                DataTable dtUserMenu = new DataTable();
                CDBConnection.getDataTable(ref dtUserMenu, strSql, "userMenu");

                for (int i = 0; i < this.tvwMenuInfo.Nodes.Count; i++)

                {
                    for (int x = 0; x < dtUserMenu.Rows.Count; x++)
                    {
                        if (this.tvwMenuInfo.Nodes[i].Text.Trim() == dtUserMenu.Rows[x][0].ToString().Trim())
                        {
                            this.tvwMenuInfo.Nodes[i].Checked = true;
                            break;
                        }
                        else
                        {
                            this.tvwMenuInfo.Nodes[i].Checked = false;
                        }
                    }

                    for (int j = 0; j < this.tvwMenuInfo.Nodes[i].Nodes.Count; j++)
                    {
                        for (int y = 0; y < dtUserMenu.Rows.Count; y++)
                        {
                            if (this.tvwMenuInfo.Nodes[i].Nodes[j].Text.Trim() == dtUserMenu.Rows[y][0].ToString().Trim())
                            {
                                this.tvwMenuInfo.Nodes[i].Nodes[j].Checked = true;
                                break;
                            }
                            else
                            {
                                this.tvwMenuInfo.Nodes[i].Nodes[j].Checked = false;
                            }
                        }
                    }
                }
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
            }
        }