usercontrol1.cs

社区管理系统

            if (tb_WHM.Text != "")
            {
                if (cmdChanged) cmd = cmd + " and 维护费用='" + tb_WHM.Text + "'";
                else cmd = cmd + "维护费用='" + tb_WHM.Text + "'";
                cmdChanged = true;
            }
            if (tb_WHmaneger.Text != "")
            {
                if (cmdChanged) cmd = cmd + " and 管理人员='" + tb_WHmaneger.Text + "'";
                else cmd = cmd + "管理人员='" + tb_WHmaneger.Text + "'";
                cmdChanged = true;
            }
            if (tb_WHshuom.Text != "")
            {
                if (cmdChanged) cmd = cmd + " and 维护说明='" + tb_WHshuom.Text + "'";
                else cmd = cmd + " 维护说明='" + tb_WHshuom.Text + "'";
                cmdChanged = true;
            }
            
               

            return cmd;
        }

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

            if (tb_SSname.Text != "")
                cmd = cmd + " and 设施名称='" + tb_SSname.Text + "'";

            if (tb_WHperson.Text != "")
                cmd = cmd + " and 维护人员='" + tb_WHperson.Text + "'";

            if (tb_WHtel.Text != "")
                cmd = cmd + " and 电话='" + tb_WHtel.Text + "'";

            if (tb_WHtime.Text != "")
                cmd = cmd + " and 维护时间='" + tb_WHtime.Text + "'";

            if (tb_map.Text != "")
                cmd = cmd + " and 设施平面图='" + tb_map + "'";

            if (tb_WHM.Text != "")
                cmd = cmd + " and 维护费用='" + tb_WHM.Text + "'";

            if (tb_WHmaneger.Text != "")
                cmd = cmd + " and 管理人员='" + tb_WHmaneger.Text + "'";

            if (tb_WHshuom.Text != "")
                if (cmdChanged) cmd = cmd + " and 维护说明='" + tb_WHshuom.Text + "'";
            return cmd;
        }
        
        private String generateUpdateCommand()
        {
            String cmd = "";
            cmd = String.Format("update 设施维护 set 设施名称='{0}',维护人员='{1}',电话='{2}',维护时间='{3}',设施平面图='{4}',", tb_SSname.Text, tb_WHperson.Text, tb_WHtel.Text, tb_WHtime.Text, tb_map);
            cmd = cmd + String.Format("维护费用='{0}',管理人员='{1}',维护说明='{2}'", tb_WHM.Text, tb_WHmaneger.Text, tb_WHshuom.Text);
            cmd = cmd + String.Format(" where 设施编号='{0}'", dealID);
            return cmd;
        }

        private String generateInsertCommand()
        {
            String cmd = "insert into 设施维护 values(";
            Int64 id = DateTime.Now.ToBinary();
            insertDealID = id;
            cmd = cmd + String.Format("'{0}','{1}','{2}','{3}','{4}',", id, tb_SSname.Text, tb_WHperson.Text,tb_WHtel.Text, tb_WHtime.Text);
            cmd = cmd + String.Format("'{0}','{1}','{2}','{3}'", tb_map, tb_WHM.Text, tb_WHmaneger.Text, tb_WHshuom.Text);
            return cmd;
        }

        private String generateDeleteCommand()
        {
            String cmd = String.Format("Delete from 设施维护 where 设施编号='{0}'", dataGridView1.Rows[selectedIndex].Cells["设施编号"].Value);
            return cmd;
        }


        private void UserControl1_Load(object sender, EventArgs e)
        {

        }

        private void dataGridView11_CellContentClick(object sender, DataGridViewCellEventArgs e)
        {

        }

        private void bt_WHdel_Click(object sender, EventArgs e)
        {
            String cmd = generateDeleteCommand();
            int affectRows = DBManager.Execute(cmd);
            if (affectRows == -1)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (affectRows == 0)
            {
                MessageBox.Show("此数据已被其他登陆用户删除");
            }
            if (selectedIndex == dataGridView1.Rows.Count - 2)
            {
                dataGridView1.Rows.Remove(dataGridView1.Rows[selectedIndex]);
                selectedIndex--;
                if (selectedIndex == -1)
                {//若dataGridView1没有数据则重置界面
                    reset();
                    return;
                }
            }
            else dataGridView1.Rows.Remove(dataGridView1.Rows[selectedIndex]);
            showDetailInfo(selectedIndex);
        }

        private void bt_WHadd_Click(object sender, EventArgs e)
        {
            String cmd;
            if (checkInput("Insert") == false) return;//用户输入错误

            cmd = generateSelectCommand();    //首先查找数据库中有没有相同内容的行

            DataTable dataTable = DBManager.ExecuteSelectCommand(cmd);
            if (dataTable == null)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (dataTable.Rows.Count > 0)
            {
                MessageBox.Show("数据库中已存在相同信息");
                return;
            }

            //将信息添加到数据库
            cmd = generateInsertCommand();    //根据输入情况生成相应的命令

            int affectedRows = DBManager.Execute(cmd);

            if (affectedRows == -1)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (affectedRows == 0)
            {//
                MessageBox.Show("插入失败");
                return;
            }
            else
            {//插入成功，
                showDetailInfo(selectedIndex);//显示插入前的一行

                /*DataRow row = new DataRow();
                row.set
                row.ItemArray={insertDealID,tb_SSname.Text};
                dataGridView1Cell[] cell = new dataGridView1Cell[6];
                for (int i = 0; i < 6; i++) cell[i] = new dataGridView1Cell();
                row.Cells = cell;
                row.Cells[0].Value=insertDealID;
                row.Cells[1].Value=tb_SSname.Text;
                row.Cells[2].Value=cbSex.Text;
                row.Cells[3].Value=int.Parse(tbAge.Text);
                row.Cells[4].Value=tb_WHperson.Text;
                row.Cells[5].Value=cbPreferedCategory.Text;
                row.Cells[6].Value=tbPreferedArea.Text;

                dataGridView1.Rows.Add(row);
                int idx = dataGridView1.Rows.IndexOf(row);
                selectedIndex = idx;
                showDetailInfo(idx);
              */
            }


        }

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

            int affectRows = DBManager.Execute(cmd);
            if (affectRows == -1)
            {  //数据库出错
                MessageBox.Show(DBManager.errorMessage);
                return;
            }
            else if (affectRows == 0)
            {//没有搜索到对应信息
                MessageBox.Show("信息可能已被其他用户删除");
                return;
            }
            else
            {//成功修改,更新dataGridView1

                 cmd = String.Format("update 设施维护 set 设施名称='{0}',维护人员='{1}',电话='{2}',维护时间='{3}',设施平面图='{4}',", tb_SSname.Text, tb_WHperson.Text, tb_WHtel.Text, tb_WHtime.Text, tb_map);
            cmd = cmd + String.Format("维护费用='{0}',管理人员='{1}',维护说明='{2}'", tb_WHM.Text, tb_WHmaneger.Text, tb_WHshuom.Text);
                DataGridViewRow row = dataGridView1.Rows[selectedIndex];
                row.Cells["设施名称"].Value = tb_SSname.Text;
                row.Cells["维护人员"].Value = tb_WHperson.Text;
                row.Cells["电话"].Value = tb_WHtel.Text;
                row.Cells["维护时间"].Value = tb_WHtime.Text;
                row.Cells["设施平面图"].Value = tb_map;
                row.Cells["维护费用"].Value = tb_WHM.Text;
                row.Cells["管理人员"].Value = tb_WHmaneger.Text;
                row.Cells["维护说明"].Value = tb_WHshuom.Text;
            }
        }

        private void bt_WHfind_Click(object sender, EventArgs e)
        {

        }



        
    }
}