tenementpanel.cs

社区管理系统

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

        private bool checkInput(String str)
        {
            tbOwnerName.Text = tbOwnerName.Text.Trim();   //将多余的空格去掉
            tbOwnerSex.Text = tbOwnerSex.Text.Trim();
            tbOwnerTel.Text = tbOwnerTel.Text.Trim();
            tbOwnerWork.Text = tbOwnerWork.Text.Trim();
            tbXiaoQuBianHao.Text = tbXiaoQuBianHao.Text.Trim();
            tbBuildNum.Text = tbBuildNum.Text.Trim();
            tbUnitNum.Text = tbUnitNum.Text.Trim();
            tbRoomNum.Text = tbRoomNum.Text.Trim();

            if (str == "Insert" || str == "Modify")
            {//以下是在更新或插入时检查输入是否为空
                if (tbOwnerName.Text == "") return ErrorMessage("户主姓名为空");
                if (tbOwnerSex.Text == "") return ErrorMessage("户主性别为空");
                if (tbOwnerTel.Text == "") return ErrorMessage("户主电话为空");
                if (tbOwnerWork.Text == "") return ErrorMessage("户主工作单位为空");
                if (tbXiaoQuBianHao.Text == "") return ErrorMessage("电话为空");
                if (tbBuildNum.Text == "") return ErrorMessage("移动电话为空");
                if (tbUnitNum.Text == "") return ErrorMessage("需求户型为空");
                if (tbRoomNum.Text == "") return ErrorMessage("需求大小为空");
            }

            //下面为检查输入数字的TextBox和ComboBox的输入格式是否正确
            if (tbOwnerSex.Text != "" && tbOwnerSex.Text != "男" && tbOwnerSex.Text != "女") return ErrorMessage("性别输入错误");
            //当此函数由查询按钮调用时，某些控件可能为空字符串，因此在转化前加了一个判断
            try{
                if (tbOwnerTel.Text != "") Int64.Parse(tbOwnerTel.Text);    //
            }catch{
                return ErrorMessage("户主电话输入错误");
            }

            try{
                if (tbXiaoQuBianHao.Text != "") Int64.Parse(tbXiaoQuBianHao.Text);
            }catch{
                return ErrorMessage("小区编号输入错误");
            }
            try{
                if (tbBuildNum.Text != "") Int64.Parse(tbBuildNum.Text);
            }catch{
                return ErrorMessage("楼宇编号输入错误");
            } 
            try{
                if (tbUnitNum.Text != "") Int64.Parse(tbUnitNum.Text);
            }catch{
                return ErrorMessage("单元编号输入错误");
            } 
            try{
                if (tbRoomNum.Text != "") Int64.Parse(tbRoomNum.Text);
            }catch{
                return ErrorMessage("房间编号输入错误");
            }
            
            return true;
        }

        private String generateSelectCommand()
        {
            String cmd = "Select 住户编号,小区编号,楼芋编号,单元编号,房间编号,户主姓名,性别 from 住户信息 ";
            bool cmdChanged = false;

            if (tbOwnerName.Text != ""){
                if (cmdChanged)
                    cmd = cmd + " and 户主姓名='" + tbOwnerName.Text + "'";
                else{
                    cmd = cmd + " where 户主姓名='" + tbOwnerName.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbXiaoQuBianHao.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 小区编号='" + tbXiaoQuBianHao.Text + "'";
                else
                {
                    cmd = cmd + " where 小区编号='" + tbXiaoQuBianHao.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbBuildNum.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 楼芋编号='" + tbBuildNum.Text + "'";
                else
                {
                    cmd = cmd + " where 楼芋编号='" + tbBuildNum.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbUnitNum.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 单元编号='" + tbUnitNum.Text + "'";
                else
                {
                    cmd = cmd + " where 单元编号='" + tbUnitNum.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbRoomNum.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 房间编号='" + tbRoomNum.Text + "'";
                else
                {
                    cmd = cmd + " where 房间编号='" + tbRoomNum.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbOwnerName.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 户主姓名='" + tbOwnerName.Text + "'";
                else
                {
                    cmd = cmd + " where 户主姓名='" + tbOwnerName.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbOwnerSex.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 性别='" + tbOwnerSex.Text + "'";
                else
                {
                    cmd = cmd + " where 性别='" + tbOwnerSex.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbOwnerTel.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 宅电1='" + tbOwnerTel.Text + "'";
                else
                {
                    cmd = cmd + " where 宅电1='" + tbOwnerTel.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbOwnerWork.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 工作单位='" + tbOwnerWork.Text + "'";
                else
                {
                    cmd = cmd + " where 工作单位='" + tbOwnerWork.Text + "'";
                    cmdChanged = true;
                }
            }
            return cmd;
        }

        private String generateUpdateCommand()
        {
            String cmd = "";

            cmd = String.Format("update 住户信息 set 户主姓名='{0}',性别='{1}',宅电1='{2}',工作单位='{3}'", tbOwnerName.Text,tbOwnerSex.Text,tbOwnerTel.Text,tbOwnerWork.Text);
            cmd = cmd + String.Format(" where 住户编号='{0}'", ID);
            return cmd;
        }

        private String generateInsertCommand()
        {
            String cmd = "insert into 住户信息 values(";
            Int64 id = DateTime.Now.ToBinary();
            Int64 xiaoquNum, BuildNum, UnitNum, RoomNum;

            xiaoquNum = Int64.Parse(tbXiaoQuBianHao.Text);
            BuildNum = Int64.Parse(tbBuildNum.Text);
            UnitNum = Int64.Parse(tbUnitNum.Text);
            RoomNum = Int64.Parse(tbRoomNum.Text);
            id = xiaoquNum * 1000000 + BuildNum * 10000 + UnitNum * 100 + RoomNum;
            insertID = id;
            cmd = cmd + String.Format("'{0}','{1}','{2}','{3}','{4}','{5}',",tbXiaoQuBianHao.Text,tbBuildNum.Text,tbUnitNum.Text,tbRoomNum.Text,id,tbOwnerName.Text);
            cmd = cmd + String.Format("'{0}','{1}','','','','{2}','','','')", tbOwnerSex.Text, tbOwnerTel.Text, tbOwnerWork.Text);
            return cmd;
        }

        private String generateDeleteCommand()
        {
            String cmd = String.Format("Delete from 住户信息 where 住户编号='{0}'", dataGridView.Rows[selectedIndex].Cells["住户编号"].Value);
            return cmd;
        }

//////////////////////////////////////////////////////////////////////////////////////////////////
//////////////////////////////////////////////////////////////////////////////////////////////////
        private void searchMemberInfo(Int64 i)
        {
            String cmd=String.Format("Select 住户编号,家庭成员姓名,性别,家庭关系,移动电话 from 家庭成员信息 where 住户编号='{0}'",i);
            
            DataTable dataTable = DBManager.ExecuteSelectCommand(cmd);
            if (dataTable == null)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (dataTable.Rows.Count == 0)
            {//没有搜索到对应信息,显示一个空的DataGridView
                dataGridView2.DataSource = dataTable;
                return;
            }
            else
            {//至少找到一条信息，将信息显示到DataGridView，并将第一条信息详细列出
                dataGridView2.DataSource = dataTable;
                showDetailInfo2(0);
            }
        }
        private void bSearch2_Click(object sender, EventArgs e)
        {
            String cmd;
            if (checkInput2("Select") == false) return;  //用户输入不合法
            cmd = generateSelectCommand2();    //根据输入情况生成相应的命令

            DataTable dataTable = DBManager.ExecuteSelectCommand(cmd);
            if (dataTable == null)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (dataTable.Rows.Count == 0)
            {//没有搜索到对应信息,显示一个空的DataGridView
                dataGridView2.DataSource = dataTable;
                return;
            }
            else
            {//至少找到一条信息，将信息显示到DataGridView，并将第一条信息详细列出
                dataGridView2.DataSource = dataTable;
                showDetailInfo2(0);
            }
        }
        private void bModify2_Click(object sender, EventArgs e)
        {
            String cmd;
            if (checkInput2("Modify") == false) return;  //用户输入不合法
            cmd = generateUpdateCommand2();    //根据输入情况生成相应的命令

            int affectRows = DBManager.Execute(cmd);
            if (affectRows == -1)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (affectRows == 0)
            {//没有搜索到对应信息
                MessageBox.Show("信息可能已被其他用户删除");
                return;
            }
            else
            {//成功修改,更新DataGridView
                DataGridViewRow row = dataGridView2.Rows[selectedIndex2];
                row.Cells["家庭关系"].Value = tbRelation.Text;
                row.Cells["家庭成员姓名"].Value = tbMemberName.Text;
                row.Cells["性别"].Value = tbMemberSex.Text;
                row.Cells["移动电话"].Value = tbMemberTel.Text;
            }