mainform.cs

一个比较简单的

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using AssetsSystem.Dao;
using AssetsSystem.Inc;
using AssetsSystem.Service;

namespace AssetsSystem.Dialog
{

    public partial class MainForm : Form
    {
        private static AssetService service = new AssetService();
        private Page page=new Page();
        private AssetsSortOrder sort = new AssetsSortOrder();
        private Admin admin;

        public void setAdmin(Admin admin)
        {
            this.admin=admin;
        }
        public Admin getAdmin()
        {
            return this.admin;
        }

        public MainForm()
        {
            InitializeComponent();

        }

        private void MainForm_Load(object sender, EventArgs e)
        {
           this.timeStatusLabel.Text = DateTime.Now.ToString();

          LoadData(page);
        }

        private void ExitMenuItem_Click(object sender, EventArgs e)
        {
            //点击退出
            Application.Exit();
        }


        private void timer1_Tick(object sender, EventArgs e)
        {
            this.timeStatusLabel.Text = DateTime.Now.ToString();
        }


        private void LoadData(Page page)
        {

            DataTable dt= service.List(page, new Asset(), sort);

            this.pageTextBox.Text = page.getPage();
            this.totalLabel.Text = page.getTotalPage() + " 页";
            this.assetsCountStatusLabel.Text = "记录总数:"+page.getTotal() + "条";

            this.toolStripButton3.Enabled = true;
            this.toolStripButton2.Enabled = true;

            if (page.getPageInInt() >= Convert.ToUInt32(page.getTotalPage()))
            {
                this.toolStripButton3.Enabled = false;
            }

            if (page.getPageInInt() <= 1)
            {
                this.toolStripButton2.Enabled = false;
            }

            this.assetsDataGridView.DataSource = dt;
           
        }
        private void LoadData(Page page, AssetsSortOrder s)
        {
            LoadData(page);
            if (sort.orderColIndex!=-1) this.assetsDataGridView.Columns[sort.orderColIndex].HeaderCell.SortGlyphDirection = s.sortOrder;
         }

        private void toolStripButton3_Click(object sender, EventArgs e)
        {
           
            //下一页
            if ((page.getPageInInt())>= Convert.ToInt32(page.getTotalPage())) return;
            page.setPage(Convert.ToString(page.getPageInInt()+1));
            LoadData(page,sort);

        }

        private void toolStripButton2_Click(object sender, EventArgs e)
        {
            //上一页
            if ((page.getPageInInt() - 1) <= 0) return;
            page.setPage(Convert.ToString(page.getPageInInt() - 1));
            LoadData(page,sort);

        }

        private void toolStripButton1_Click(object sender, EventArgs e)
        {
            //第一页
            page.setPage("1");
            LoadData(page,sort);
        }

        private void toolStripButton4_Click(object sender, EventArgs e)
        {
            //最后一页
            page.setPage(page.getTotalPage());
            LoadData(page,sort);
        }

        private void 第一页ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            toolStripButton1_Click(sender,e);
        }

        private void 上一页ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            toolStripButton2_Click(sender, e);
        }

        private void 下一页ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            toolStripButton3_Click(sender, e);
        }

        private void 最后一页ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            toolStripButton4_Click(sender, e);
        }
        /// <summary>
        /// 手动输入行数
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void pageTextBox_KeyDown(object sender, KeyEventArgs e)
        {
            //输入行数
            if (e.KeyCode == Keys.Enter)            
            {
                page.setPage(this.pageTextBox.Text);
                LoadData(page,sort);
            }

        }

        /// <summary>
        /// 检查输入数字
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void pageTextBox_KeyPress(object sender, KeyPressEventArgs e)
        {
            if (!Util.isnumstr(e.KeyChar.ToString()))
            {
                //MessageBox.Show("不是数字！");
                e.Handled = true; 
            }
            
        }
        /// <summary>
        /// 
        ///点击增加数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton5_Click(object sender, EventArgs e)
        {
            AddAsset add = new AddAsset();
            add.ShowDialog();
            if (add.DialogResult == DialogResult.OK)
            {
                LoadData(page);
            }
        }

        private void 增加记录ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            toolStripButton5_Click(sender, e);
        }

        /// <summary>
        /// 删除记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void toolStripButton6_Click(object sender, EventArgs e)
        {
            this.assetsDataGridView.EndEdit();
            int n = 0;//更新记录数目
            try
            {

                //获取所有删除的记录
                StringBuilder delsql = new StringBuilder();
                for (int i = 0; i < this.assetsDataGridView.Rows.Count; i++)
                {
                    if ((bool)this.assetsDataGridView.Rows[i].Cells[0].EditedFormattedValue)
                    {
                        delsql.AppendFormat(this.assetsDataGridView.Rows[i].Cells[1].Value.ToString());
                        delsql.AppendFormat(",");
                    }
                }
                //没有选中记录
                if (!Util.haveText(delsql.ToString()))
                {
                    MessageBox.Show("对不起,请选择你要删除的记录!", "警告", MessageBoxButtons.OK, MessageBoxIcon.Warning);
                    return;
                }
                string s = delsql.ToString();
                s=s.Substring(0, s.Length - 1);

                n=service.Del(s);
               

            }
            finally
            {
                if (n > 0) LoadData(page,sort);
            }

        }
        /// <summary>
        /// 点击排序
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void assetsDataGridView_ColumnHeaderMouseClick(object sender, DataGridViewCellMouseEventArgs e)
        {
            DataGridViewColumn tbc = this.assetsDataGridView.Columns[e.ColumnIndex];
            if (tbc.SortMode == DataGridViewColumnSortMode.NotSortable) return;
            sort.orderColIndex = e.ColumnIndex;

            //Console.WriteLine(tbc.HeaderCell.SortGlyphDirection.ToString());
            //是否为升序
            bool isAsc = tbc.HeaderCell.SortGlyphDirection.ToString().Equals("Ascending")?true:false;
            if (isAsc)
            {
                sort.orderType = "desc";
                sort.sortOrder = SortOrder.Descending;
            }
            else
            {
                sort.orderType = "asc";
                sort.sortOrder = SortOrder.Ascending;
            }
            sort.orderCol = tbc.DataPropertyName;

            page.setPage("1");//跳转到第一页
            LoadData(page,sort);
            
        }
        /// <summary>
        /// 编辑记录
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void assetsDataGridView_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
        {


            if (e.RowIndex < 0) return;
            DataGridViewRow tbr = this.assetsDataGridView.Rows[e.RowIndex];

            //MessageBox.Show(tbr.Cells[1].EditedFormattedValue.ToString());

            EditAsset ef = new EditAsset();
            Asset asset = new Asset();

            int i = 1;
            asset.setId(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setZcbm(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setZcmc(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setLb(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setXh(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setDw(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setZzs(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setCd(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setRzrq(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setSyrq(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setSyqk(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setSybm(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setCfdd(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setSl(tbr.Cells[i++].EditedFormattedValue.ToString());
            asset.setYz(tbr.Cells[i++].EditedFormattedValue.ToString());
            
            ef.setValue(asset);
            ef.ShowDialog();
            if (ef.DialogResult == DialogResult.OK)
            {
                LoadData(page);
            }
        }
        /// <summary>
        /// 全选删除框
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void assetsDataGridView_ColumnHeaderMouseClick2(object sender, DataGridViewCellMouseEventArgs e)
        {

            this.assetsDataGridView.EndEdit();
            //双击全选按钮
            if (e.RowIndex < 0&&e.ColumnIndex==0)
            {
                for (int i = 0; i < this.assetsDataGridView.Rows.Count; i++)
                {
                    this.assetsDataGridView.Rows[i].Cells[0].Value = !(bool)this.assetsDataGridView.Rows[i].Cells[0].FormattedValue;
                }

            }


        }

        private void 删除记录ToolStripMenuItem_Click(object sender, EventArgs e)
        {
            this.toolStripButton6_Click(sender, e);
        }
        /// <summary>
        /// 修改密码
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void CPasswordMenuItem_Click(object sender, EventArgs e)
        {
            ChangePassword cpf = new ChangePassword();
            cpf.setAdmin(this.admin);
            cpf.ShowDialog();

        }

    

    }
}