propertypanel.cs

社区管理系统

        }

        private String generateUpdateCommand()
        {
            String cmd = "";
 //           String s = (Int64)dgvCW.Rows[selectedIndex].Cells["财产编号"].Value + "";
            cmd = String.Format("update 财产信息 set 财产名称='{1}',数量='{2}',财产金额='{3}',增加日期='{5}',使用次数='{4}' where 财产编号='{0}'", tnCWnum.Text, tnCWname.Text, tnCWcount.Text, tnCWmon.Text, tnCWtime.Text,dtCWdate.Text);
            return cmd;
        }

        private String generateInsertCommand()
        {
            String cmd = "insert into 财产信息 values(";
            //Int64 id = DateTime.Now.ToBinary();
            //insertDealID = id;
            cmd = cmd + String.Format("'{0}','{1}','{2}','{5}','{3}','{4}')", tnCWnum.Text, tnCWname.Text, tnCWcount.Text, tnCWmon.Text,tnCWtime.Text,dtCWdate.Text);

            return cmd;
        }

        private String generateDeleteCommand()
        {
            String cmd = String.Format("Delete from 财产信息 where 财产编号='{0}'", dgvCW.Rows[selectedIndex].Cells["财产编号"].Value);
            return cmd;
        }
        
        private void textBox3_TextChanged(object sender, EventArgs e)
        {

        }

        private void dateTimePicker1_ValueChanged(object sender, EventArgs e)
        {

        }

            private void btCWdel_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 == dgvCW.Rows.Count - 2)
                {
                    dgvCW.Rows.Remove(dgvCW.Rows[selectedIndex]);
                    selectedIndex--;
                    if (selectedIndex == -1)
                    {//若dgvZK没有数据则重置界面
                        reset();
                        return;
                    }
                }
                else dgvCW.Rows.Remove(dgvCW.Rows[selectedIndex]);
                showDetailInfo(selectedIndex);
            }

            private void btCWadd_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);//显示插入前的一行
                    MessageBox.Show("添加成功！");
                    dgvCW.DataSource = DBManager.ExecuteSelectCommand("select * from 财产信息");
                    showDetailInfo(selectedIndex);//显示插入前的一行
                }
            }

            private void btCWalter_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
                {//成功修改,更新dgvZK
           /*         DataGridViewRow row = dgvCW.Rows[selectedIndex];
                    row.Cells["财产编号"].Value = tnCWnum.Text;
                    row.Cells["财产名称"].Value = tnCWname.Text;
                    row.Cells["数量"].Value = tnCWcount.Text;
                    row.Cells["财产金额"].Value = tnCWmon.Text;
                    row.Cells["使用次数"].Value = tnCWtime.Text;*/
                   // row.Cells["日期"].Value = tnCWdate.Text;
                    MessageBox.Show("修改成功！");
                    dgvCW.DataSource = DBManager.ExecuteSelectCommand("select * from 财产信息");
         //           showDetailInfo(selectedIndex);//显示修改前的一行
                }
            }

            private void showDetailInfo(int idx)
            {
                if (idx < 0) return;
                selectedIndex = idx;
                dealID = (Int64)dgvCW.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;
                }
        
                tnCWnum.Text = (Int64)dt.Rows[0]["财产编号"] + "";
                tnCWname.Text = (String)dt.Rows[0]["财产名称"];
                tnCWcount.Text = (Int64)dt.Rows[0]["数量"] + "";  //用这种方式将数字转换成字符串
                tnCWmon.Text = (Double)dt.Rows[0]["财产金额"] + "";
                tnCWtime.Text = (Int64)dt.Rows[0]["使用次数"] + "";

                dtCWdate.Text = (DateTime)dt.Rows[0]["增加日期"]+"";


                btCWalter.Enabled = true;//此时可以操作修改、删除数据
                btCWdel.Enabled = true;
            }
            public void visilize()
            {
                reset();    //将各个控件置为初始状态
                this.Visible = true;
            }

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

            private void reset()
            {
                dealID = 0;
                selectedIndex = -1;
                btCWalter.Enabled = false;
                btCWdel.Enabled = false;
                btCWpri.Enabled = false;
                tnCWnum.Text = "";     //清空TextBox及ComboBox
                tnCWname.Text = "";
                tnCWcount.Text = "";
                tnCWmon.Text = "";
                tnCWtime.Text = "";
                 dtCWdate.Text = "";

             }


    }
}