facilitymaintpanel.cs

社区管理系统

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Drawing;
using System.Data;
using System.Text;
using System.Windows.Forms;
using DataBaseManagerLibrary;

namespace SSWHssbh
{
    public partial class UserControl1 : UserControl
    {
        private DataBaseManager DBManager;
        private Int64 dealID, insertDealID;
        private int selectedIndex;
       
        
        public UserControl1()
        {
            InitializeComponent();
            reset();
            //setDataBaseManager(null);
        }
        public void visilize()
        {
            reset();    //将各个控件置为初始状态
            this.Visible = true;
        }

        public void disVisilize()
        {
            this.Visible = false;
        }

        private void reset() //
        {
            dealID = 0;
            dataGridView1.DataSource = null;
            selectedIndex = -1;
 //           bt_WHdel.Enabled = false;
 //           bt_WHxiug.Enabled = false;
            tb_map.Text = "";
            tb_SSname.Text = "";
            tb_WHM.Text = "";
            tb_WHssbh.Text = "";
            tb_WHperson.Text = "";
            tb_WHshuom.Text = "";
            tb_WHtel.Text = "";
            dtWHtime.Text = "";
            

        }

        public void setDataBaseManager(DataBaseManager DBManager)
        {
            this.DBManager = DBManager;
            //String SqlConnectInfo = "server=hwadee-1e12;database=master;uid=sa;pwd=''";
            //DBManager = new DataBaseManager(SqlConnectInfo);
            DataTable dt = DBManager.ExecuteSelectCommand("select * from 设施维护");
            if (dt == null) MessageBox.Show(DBManager.errorMessage);
            dataGridView1.DataSource = dt;
        }

        private void bSearch_Click(object sender, EventArgs e)
        {
            String cmd;
            if (checkInput("Select") == false) return;  //用户输入不合法
            cmd = generateSelectCommand();    //根据输入情况生成相应的命令

            DataTable dataTable = DBManager.ExecuteSelectCommand(cmd);
            if (dataTable == null)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (dataTable.Rows.Count == 0)
            {//没有搜索到对应信息,显示一个空的dataGridView1
                dataGridView1.DataSource = dataTable;
                return;
            }
            else
            {//至少找到一条信息，将信息显示到dataGridView1，并将第一条信息详细列出
                dataGridView1.DataSource = dataTable;
                showDetailInfo(0);
            }
        }

        private bool ErrorMessage(String msg)
        {
            MessageBox.Show(msg);
            return false;
        }

        private void dataGridView1_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex == -1 || e.RowIndex >= dataGridView1.Rows.Count - 1) return; //选择多行或选择列标签
            showDetailInfo(e.RowIndex);
            selectedIndex = e.RowIndex;
   //         MessageBox.Show(selectedIndex+"");
            
            tb_WHssbh.Text = (dataGridView1.Rows[selectedIndex].Cells["设施编号"].Value).ToString();
            tb_SSname.Text = (dataGridView1.Rows[selectedIndex].Cells["设施名称"].Value).ToString();
            tb_WHtel.Text = (dataGridView1.Rows[selectedIndex].Cells["电话"].Value).ToString();
            dtWHtime.Text = (dataGridView1.Rows[selectedIndex].Cells["维护时间"].Value).ToString();
            tb_map.Text = (dataGridView1.Rows[selectedIndex].Cells["设施平面图"].Value).ToString();
            tb_WHM.Text = (dataGridView1.Rows[selectedIndex].Cells["维护费用"].Value).ToString();
            tb_WHshuom.Text = (dataGridView1.Rows[selectedIndex].Cells["维护说明"].Value).ToString();
            tb_WHperson.Text = (dataGridView1.Rows[selectedIndex].Cells["维护人员"].Value).ToString();

    
        }

        private void showDetailInfo(int idx)
        {
            if (idx < 0) return;
            selectedIndex = idx;
            dealID = (Int64)dataGridView1.Rows[idx].Cells["设施编号"].Value;//得到用户选择的行的主键
            DataTable dt = DBManager.ExecuteSelectCommand(String.Format("select * from 设施维护 where 设施编号='{0}'", dealID));
            if (dt == null)
            {//数据库错误
                MessageBox.Show(DBManager.errorMessage);
                dealID = 0;
                return;
            }
            else if (dt.Rows.Count == 0)
            {  //未找到此记录
                MessageBox.Show("此记录可能已被其他用户删除");
                dealID = 0;
                return;
            }



          //  bt_WHxiug.Enabled = true;//此时可以操作修改、删除数据
           // bt_WHdel.Enabled = true;
        }

        private bool checkInput(String str)
        {
            //将多余的空格去掉
            tb_SSname.Text = tb_SSname.Text.Trim();
            tb_WHperson.Text = tb_WHperson.Text.Trim();
            tb_WHtel.Text = tb_WHtel.Text.Trim();
            dtWHtime.Text = dtWHtime.Text.Trim();
            tb_map.Text = tb_map.Text.Trim();
            tb_WHM.Text = tb_WHM.Text.Trim();
            tb_WHssbh.Text = tb_WHssbh.Text.Trim();
            tb_WHshuom.Text = tb_WHshuom.Text.Trim();

            if (tb_SSname.Text == "") return ErrorMessage("设施名称为空");
            if (tb_WHperson.Text == "") return ErrorMessage("维护人员为空");
            if (tb_WHtel.Text == "") return ErrorMessage("电话为空");
            if (dtWHtime.Text == "") return ErrorMessage("维护时间为空");
            if (tb_map.Text == "") return ErrorMessage("设施平面图为空");
            if (tb_WHM.Text == "") return ErrorMessage("维护费用为空");
            if (tb_WHssbh.Text == "") return ErrorMessage("设施编号为空");
            if (tb_WHshuom.Text == "") return ErrorMessage("维护说明为空");

            if (tb_WHtel.Text != "")
            {
                try
                {
                    Int64.Parse(tb_WHtel.Text);
                }
                catch {
                    MessageBox.Show("电话输入错误");
                    return false;
                }
            }

            if (tb_WHM.Text != "")
            {
                try
                {
                    double.Parse(tb_WHM.Text);
                }
                catch {
                    MessageBox.Show("金额输入错误");
                    return false;
                }
            }
            return true;
        }


        private String generateSelectCommand()
        {
            String cmd = "Select 设施编号,设施名称,维护人员,电话,维护时间,设施平面图,维护费用,维护说明 from 设施维护  ";
            bool cmdChanged = false;

            if (tb_WHssbh.Text != "")
                cmd = cmd + " where 设施编号='" + tb_WHssbh.Text + "'";
         
 /*           if (tb_WHssbh.Text != "")
                cmd = cmd + " and 设施编号='" + tb_WHssbh.Text + "'";

            if (tb_WHperson.Text != "")