cw_peijian.cs

此系统开发了一个公交车管理系统。系统根据权限的不同

                                    this.textCarKinds.Clear();
                                    this.textBuyFitName.Clear();
                                    this.textBuyFitAver.Clear();
                                    this.textBuyFitCount.Clear();
                                    this.textBuyFitMoney.Clear();
                                    this.textBuyFitAddress.Clear();

                                }
                                else
                                {

                                    MessageBox.Show("请将信息添加完整 ");

                                }

                            }
                            else
                            {
                                MessageBox.Show("请将信息添加完整 ");
                            }
                        }
                        else
                        {
                            MessageBox.Show("请将信息添加完整");
                        }

                    }
                    else
                    {
                        MessageBox.Show("请将信息添加完整");
                    }

                }
                else
                {
                    MessageBox.Show("请将信息添加完整");
                }
            }
            else
            {
                MessageBox.Show("请将信息添加完整");
            }


        }

        private void button4_Click(object sender, EventArgs e)
        {
            this.textCarKinds.Clear();
            this.textBuyFitName.Clear();
            this.textBuyFitAver.Clear();
            this.textBuyFitCount.Clear();
            this.textBuyFitMoney.Clear();
            this.textBuyFitAddress.Clear();
        }

        private void btnUseFitAdd_Click(object sender, EventArgs e)
        {
            string UseFitCount1 = this.textUseFitCount.Text.ToString().Trim();
            string UseFitCount = " - " + UseFitCount1;
            string UserCarStyle = this.textUserCarStyle.SelectedItem.ToString();
            string UserCarKinds = this.textUserCarKinds.Text.ToString().Trim();
            string UseFitName = this.textUseFitName.Text.ToString().Trim();
            string UseFitAver = this.textUseFitAver.Text.ToString().Trim();
            string UseFitMoney1 = this.textUseFitMoney.Text.ToString().Trim();
            string UseFitMoney = "-" + UseFitMoney1;
            DateTime UseTime = Convert.ToDateTime(this.dateTimeUse.Value.ToShortDateString());

            if (UserCarKinds != "")
            {
                if (UseFitName != "")
                {
                    if (UseFitAver != "")
                    {
                        if (UseFitCount1 != "")
                        {
                            if (UseFitMoney1 != "")
                            {
                                string sql = "insert into db_fit(fit_style,fit_carkinds,fit_name,fit_price,fit_count,fit_totol,fit_time)values('" + UserCarStyle + "','" + UserCarKinds + "','" + UseFitName + "','" + UseFitAver + "','" + UseFitCount + "','" + UseFitMoney + "','" + UseTime + "')";
                                Car.ADU(sql);
                                //调用gridviewcar方法
                                this.gridviewcar2();
                                MessageBox.Show("添加成功");
                                this.textUseFitName.Clear();
                                this.textUseFitAver.Clear();
                                this.textUseFitCount.Clear();
                                this.textUseFitMoney.Clear();
                            }
                        }
                        else
                        {

                            MessageBox.Show("请将信息添加完整 ");

                        }

                    }
                    else
                    {
                        MessageBox.Show("请将信息添加完整 ");
                    }
                }
                else
                {
                    MessageBox.Show("请将信息添加完整");
                }

            }
            else
            {
                MessageBox.Show("请将信息添加完整");
            }

        }

        private void button6_Click(object sender, EventArgs e)
        {
            this.textUseFitName.Clear();
            this.textUseFitAver.Clear();
            this.textUseFitCount.Clear();
            this.textUseFitMoney.Clear();
        }

        private void btnCheck_Click(object sender, EventArgs e)
        {
            string sqlstr = "select fit_id as 序号, fit_style as 配件类型,fit_carkinds as 车型,fit_name as 配件名称,fit_price as 配件单价,fit_count as 配件数量,fit_totol as 总金额,fit_palce as 购买地址,fit_time as 购买时间 from db_fit where 1 = 1";
            string CheckFitName = this.textCheckFitName.Text.ToString().Trim();
            string CheckFitCarKinds = this.textCheckFitCarKinds.Text.ToString().Trim();
            string CheckFitAdress = this.textCheckFitAdress.Text.ToString().Trim();
            string CheckFitKinds = this.textCheckFitKinds.SelectedItem.ToString();
            DateTime TimeCheck = Convert.ToDateTime(this.dateTimeCheck.Value.ToShortDateString());
            //调用config配置文件对象dl连接对象
            string dl = ConfigurationManager.AppSettings["sqlString"];
            //创建connection对象con进行连接
            SqlConnection con = new SqlConnection(dl);
            //打开连接
            con.Open();
            if (dateTimeCheck.Checked)
            {
                sqlstr = sqlstr + "and fit_time = '" + TimeCheck + "'";

            }
            if (CheckFitAdress != "")
            {
                sqlstr = sqlstr + "and fit_palce = '" + CheckFitAdress + "'";

            }
            if (CheckFitName != "")
            {
                sqlstr = sqlstr + "and fit_name = '" + CheckFitName + "'";

            }
            if (CheckFitKinds != "--未选择--")
            {
                sqlstr = sqlstr + "and fit_style = '" + CheckFitKinds + "'";
            }
            if (CheckFitKinds == "剩余")
            {
                sqlstr = "select fit_carkinds as 车型, fit_name as 配件名称,fit_price as 配件单价, sum(fit_count) as 剩余配件,sum(fit_totol) as 剩余金额 from db_fit  group by  fit_carkinds,fit_name,fit_price";

            }
            if (CheckFitCarKinds != "")
            {
                sqlstr = sqlstr + "and fit_carkinds = '" + CheckFitCarKinds + "'";
            }
            SqlCommand cmd = new SqlCommand(sqlstr, con);
            //创建读取器对象sdr
            SqlDataAdapter sdr = new SqlDataAdapter();
            //sdr的查询方法为cmd
            sdr.SelectCommand = cmd;
            //创建一个dataset容器
            DataSet ds = new DataSet();
            //填充数据ds
            sdr.Fill(ds);
            //绑定datagriview数据源为ds
            this.GridViewFitCheck.DataSource = ds.Tables[0].DefaultView;
            //关闭连接
            con.Close();
        }

        private void btnCheckClear_Click(object sender, EventArgs e)
        {
            this.textUseFitName.Clear();
            this.textUseFitAver.Clear();
            this.textUseFitCount.Clear();
            this.textUseFitMoney.Clear();
        }

        private void CW_peijian_Load(object sender, EventArgs e)
        {
            this.textBuyFitStyle.SelectedItem = "购买";
            this.textUserCarStyle.SelectedItem = "使用";
            this.textCheckFitKinds.SelectedItem = "--未选择--";
            //调用gridviewcar方法
            this.gridviewcar();
            this.gridviewcar2();
        }
    }
}