financialpanel.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 CaiWuControlLibrary1
{
    public partial class FinancialPanel : UserControl
    {
        private DataBaseManager DBManager;
        private Int64 dealID, insertDealID;
        private int selectedIndex;

        public FinancialPanel()
        {
            InitializeComponent();
            //String SqlConnectInfo = "server=localhost;database=test;uid=sa;pwd=''";
           // DBManager = new DataBaseManager(SqlConnectInfo);
            reset();
            //setDataBaseManager(null);
        }

        public void setDataBaseManager(DataBaseManager DBManager){
            this.DBManager=DBManager;
            //String SqlConnectInfo = "server=(local);database=CommunityManagementSystem;uid=sa;pwd='586925'";
            //DBManager = new DataBaseManager(SqlConnectInfo);
            /*DataTable dt = DBManager.ExecuteSelectCommand("select * from 账款信息");
            if (dt == null) MessageBox.Show(DBManager.errorMessage);
            dgvZK.DataSource = dt;*/
        }

        private bool ErrorMessage(String msg)
        {
            MessageBox.Show(msg);
            return false;
        }
        private void dgvZK_CellClick(object sender, DataGridViewCellEventArgs e)
        {
            if (e.RowIndex == -1 || e.RowIndex >= dgvZK.Rows.Count - 1) return; //选择多行或选择列标签
            showDetailInfo(e.RowIndex);
            selectedIndex = e.RowIndex;
            tbZKkind.Text = (dgvZK.Rows[selectedIndex].Cells["账款类别"].Value).ToString();
            tbZKname.Text = (dgvZK.Rows[selectedIndex].Cells["账款名称"].Value).ToString();
            tbZKnum.Text = (dgvZK.Rows[selectedIndex].Cells["账款号码"].Value).ToString();
            tbZKhcount.Text = (dgvZK.Rows[selectedIndex].Cells["借方数目"].Value).ToString();
            tbZKlcount.Text = (dgvZK.Rows[selectedIndex].Cells["贷方数目"].Value).ToString();
            tbZKsum.Text = (dgvZK.Rows[selectedIndex].Cells["总计"].Value).ToString();
            cbZKstat.Text = (dgvZK.Rows[selectedIndex].Cells["账款状态"].Value).ToString();
        }
        private void btZKsel_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)
            {//没有搜索到对应信息,显示一个空的dgvZK
                MessageBox.Show("no");
                dgvZK.DataSource = dataTable;
                return;
            }
            else
            {//至少找到一条信息，将信息显示到dgvZK，并将第一条信息详细列出
                dgvZK.DataSource = dataTable;
                showDetailInfo(0);
            }
        }
        private bool checkInput(String str)
        {
            tbZKkind.Text = tbZKkind.Text.Trim();//将多余的空格去掉 　
            tbZKname.Text = tbZKname.Text.Trim();
            tbZKnum.Text = tbZKnum.Text.Trim();
            if (tbZKnum.Text != ""){
                try{
                    Int64.Parse(tbZKnum.Text);
                }catch{
                    MessageBox.Show("账款号码输入错误！");
                    return false;
                }
            }
            tbZKhcount.Text = tbZKhcount.Text.Trim();
            if (tbZKhcount.Text != "") 
            {
                try
                {
                    float.Parse(tbZKhcount.Text);
                }
                catch
                {
                    MessageBox.Show("借方数目输入错误！");
                    return false;
                }
            }
            tbZKlcount.Text = tbZKlcount.Text.Trim();
            if (tbZKlcount.Text != "")
            {
                try
                {
                    float.Parse(tbZKlcount.Text);
                }
                catch
                {
                    MessageBox.Show("贷方数目输入错误！");
                    return false;
                }
            }

            tbZKsum.Text = tbZKsum.Text.Trim();
            if (tbZKsum.Text != "")
            {
                try
                {
                    float.Parse(tbZKsum.Text);
                }
                catch
                {
                    MessageBox.Show("总计输入错误！");
                    return false;
                }
            }
            if (str == "Insert" || str == "Modify")
            {//以下是在更新或插入时检查输入是否为空
                if (tbZKkind.Text == "") return ErrorMessage("账款类别为空");
                if (tbZKname.Text == "") return ErrorMessage("账款名称为空");
                if (tbZKnum.Text == "") return ErrorMessage("账款号码为空");
                if (tbZKhcount.Text == "") return ErrorMessage("借方数目为空");
                if (tbZKlcount.Text == "") return ErrorMessage("贷方数目为空");
                if (tbZKsum.Text == "") return ErrorMessage("总计为空");
                if (cbZKstat.Text == "") return ErrorMessage("账款状态为空");
                if (tbTime.Text == "") return ErrorMessage("日期为空");
            } 

            return true;
        }
        private String generateSelectCommand()
        {
            String cmd = "select 账款号码,账款类别,账款名称,借方数目,贷方数目,账款状态,总计,日期 from 账款信息 ";
            bool cmdChanged = false;

            if (tbZKkind.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 账款类别='" + tbZKkind.Text + "'";
                else
                {
                    cmd = cmd + "where 账款类别='" + tbZKkind.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbZKname.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 账款名称='" + tbZKname.Text + "'";
                else
                {
                    cmd = cmd + "where 账款名称='" + tbZKname.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbZKnum.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 账款号码='" + tbZKnum.Text + "'";
                else
                {
                    cmd = cmd + "where 账款号码='" + tbZKnum.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbZKhcount.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 借方数目='" + tbZKhcount.Text + "'";
                else
                {
                    cmd = cmd + "where 借方数目='" + tbZKhcount.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbZKlcount.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 贷方数目='" + tbZKlcount.Text + "'";
                else
                {
                    cmd = cmd + "where 贷方数目='" + tbZKlcount.Text + "'";
                    cmdChanged = true;
                }
            }
            if (tbZKsum.Text != "")
            {
                if (cmdChanged)
                    cmd = cmd + " and 总计='" + tbZKsum.Text + "'";
                else
                {
                    cmd = cmd + "where 总计='" + tbZKsum.Text + "'";
                    cmdChanged = true;
                }