lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/FinancialManagement/TwoSalesOrder/FrmCustomerSelete.cs

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

namespace LYFZ.Software.MainBusiness.FinancialManagement.TwoSalesOrder
{
    public partial class FrmCustomerSelete : LYFZ.Software.UI.FinancialManagement.TwoSalesOrder.FrmCustomerSelete
    {
        public FrmCustomerSelete()
        {
            this.Shown += FrmCustomerSelete_Shown;
            this.txtkeyword.KeyDown += txtkeyword_KeyDown;
            this.btnQuery.Click += btnQuery_Click;
            this.dgvData.MouseDoubleClick += dgvData_MouseDoubleClick;
            this.btnOk.Click += btnOk_Click;
            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
        }

        /// <summary>
        /// 选择的客户编号
        /// </summary>
        public string StrClientNumber;
        /// <summary>
        /// 窗体加载事件
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void FrmCustomerSelete_Shown(object sender, EventArgs e)
        {
            this.dgvData.DataColumns("客户编号,客户姓名,客户性别,客户电话,客户地址", strHideField: "客户编号");
            this.PublicFunctionRows();
        }
        /// <summary>
        /// 关键字回车查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void txtkeyword_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            { this.PublicFunctionRows(); }
        }
        /// <summary>
        /// 查询
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnQuery_Click(object sender, EventArgs e)
        { this.PublicFunctionRows(); }
        /// <summary>
        /// 双击选择
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void dgvData_MouseDoubleClick(object sender, EventArgs e)
        {
            if (this.dgvData.Rows.Count > 0)
            { this.btnOk_Click(this, null); }
        }
        /// <summary>
        /// 确定选择
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        void btnOk_Click(object sender, EventArgs e)
        {
            if (this.dgvData.SelectedRows.Count == 0)
            { MessageBoxCustom.Show("请选择你要客户！"); return; }
            this.StrClientNumber = this.dgvData.CurrentRow.Cells["客户编号"].Value.ToString();
            this.Close();
        }
        /// <summary>
        /// 绑定数据
        /// </summary>
        void PublicFunctionRows()
        {
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.PageSize = 100;
            this.ucPagerEx1.Bind();
        }
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            this.dgvData.Rows.Clear();
            string Strkeyword = txtkeyword.Text.Trim();

            DataTable dt = new DataTable();
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            pageData.PageIndex = this.ucPagerEx1.PageCurrent;
            pageData.PageSize = this.ucPagerEx1.PageSize;
            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                string StrWhere = "Cus_Type != '儿童'";
                if (!string.IsNullOrEmpty(txtkeyword.Text))
                { StrWhere += " And (Cus_Name like '%" + Strkeyword + "%' or Cus_Telephone like '%" + Strkeyword + "%' or Cus_NamePinyin like '%" + Strkeyword + "%' )"; }
                pageData.QueryCondition = StrWhere;
                pageData.TableName = "tb_ErpCustomer";
                pageData.QueryFieldName = " Cus_CustomerNumber,Cus_Name,Cus_Sex,Cus_Telephone,Cus_Address";
                pageData.OrderStr = " Cus_Name Asc";
                pageData.OrderType = 1;
                dt = pageData.QueryDataTable().Tables[0];
                this.Invoke(new LYFZ.Software.MainBusiness.DoorCityProcess.PublicCodeClasses.UpdateControl(delegate()
                {
                    for (int t = 0; t < dt.Rows.Count; t++)
                    {
                        DataGridViewRow dgvr = new DataGridViewRow();
                        DataGridViewCell cell = null;

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Cus_CustomerNumber"].ToString().Trim(); ;
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Cus_Name"].ToString().Trim(); ;
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = Convert.ToBoolean(dt.Rows[t]["Cus_Sex"]) ? "女" : "男";
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Cus_Telephone"].ToString().Trim();
                        dgvr.Cells.Add(cell);

                        cell = new DataGridViewTextBoxCell();
                        cell.Value = dt.Rows[t]["Cus_Address"].ToString().Trim();
                        dgvr.Cells.Add(cell);

                        this.dgvData.Rows.Add(dgvr);
                    }
                }));
            });
            try
            { this.ucPagerEx1.TbDataSource = dt; }
            catch
            { }
            this.dgvData.ClearSelection();
            this.dgvData.FillLastColumn();
            return pageData.TotalCount;
        }
    }
}