lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/Dresses/FrmDressView.cs

using LYFZ.ComponentLibrary;
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.Dresses
{
    public partial class FrmDressView : LYFZ.Software.UI.Dresses.FrmDressView
    {
        private delegate void UpdateControl();
        public FrmDressView()
        {

            this.ucPagerEx1.EventPaging += ucPagerEx1_EventPaging;
        }

        #region 加载
        protected override void FrmDressView_Shown(object sender, EventArgs e)
        {
            try
            {
                BindDsfm_DressType();
                Bind();

                #region 权限设置
                #region  查看
                if (LYFZ.BLL.BLL_ErpUser.GetRights(LYFZ.BLL.BLL_ErpUser.CurrentUserRights.DressView, CustomAttributes.OperatingAuthority.SeeView))
                {
                    btnRecord.Enabled = true;
                }
                else
                {
                    btnRecord.Enabled = false;
                }
                #endregion
                #endregion

            }
            catch (Exception ex)
            {
                MessageBoxCustom.Show(ex.Message);
            }
        }

        #region 获取礼服
        /// <summary>
        /// 获取礼服
        /// </summary>
        public void Bind()
        {
            this.ucPagerEx1.PageCurrent = 1;
            this.ucPagerEx1.PageSize = 100;// LYFZ.Software.MainBusiness.CommonLogical.SuccessfulLogin.GetPageSize();//3;分页条数
            this.ucPagerEx1.Bind();

        }
        #endregion
        #endregion

        #region 查询
        protected override void btnSlect_Click(object sender, EventArgs e)
        {
            try
            {
                Bind();
            }
            catch (Exception ex)
            {
                MessageBoxCustom.Show(ex.Message);
            }
        }
        #endregion

        #region 租售洗记录
        protected override void btnRecord_Click(object sender, EventArgs e)
        {
            try
            {

                if (dgv.SelectedRows.Count == 0)
                {
                    MessageBoxCustom.Show("请选择你要查看的礼服！");
                    return;
                }
                LYFZ.Software.MainBusiness.Dresses.DressView.FrmRecord set = new DressView.FrmRecord();
                set.Number = dgv.CurrentRow.Cells["Dsfm_DressNumber"].Value.ToString();
                set.ShowDialog();
            }
            catch (Exception ex)
            {

                MessageBoxCustom.Show(ex.Message);
            }
        }
        #endregion

        #region 绑定礼服类别
        /// <summary>
        /// 绑定礼服类别
        /// </summary>
        public void BindDsfm_DressType()
        {
            CtvDsfm_DressType.TreeView.Nodes.Clear();
            #region 绑定二级礼服类别
            LYFZ.BLL.BLL_ErpSystemCategory BLLSystemCategory = new BLL.BLL_ErpSystemCategory();
            DataTable tbl = BLLSystemCategory.GetList("Sc_ClassParentID='59'").Tables[0];
            if (tbl.Rows.Count > 0)
            {
                TreeNode root = null;

                for (int i = 0; i < tbl.Rows.Count; i++)
                {
                    if (i == 0)
                    {
                        root = new TreeNode("全部");
                        this.CtvDsfm_DressType.TreeView.Nodes.Add(root);
                    }
                    root = new TreeNode();
                    root.Text = tbl.Rows[i]["Sc_ClassName"].ToString();
                    root.Tag = tbl.Rows[i]["Sc_ClassCode"].ToString();
                    this.CreateTreeViewShop(root.Nodes, tbl.Rows[i]["ID"].ToString());
                    this.CtvDsfm_DressType.TreeView.Nodes.Add(root);
                }
            }
            #endregion

        }

        private void CreateTreeViewShop(TreeNodeCollection nodes, string ClassCode)
        {
            if (ClassCode != "")
            {
                LYFZ.BLL.BLL_ErpSystemCategory BLLSystemCategory = new BLL.BLL_ErpSystemCategory();
                DataTable tbl = BLLSystemCategory.GetList("Sc_ClassParentID=" + ClassCode + "").Tables[0];
                if (tbl.Rows.Count > 0)
                {
                    TreeNode node;
                    for (int i = 0; i < tbl.Rows.Count; i++)
                    {
                        node = new TreeNode();
                        node.Text = tbl.Rows[i]["Sc_ClassName"].ToString();
                        node.Tag = tbl.Rows[i]["Sc_ClassCode"].ToString();
                        nodes.Add(node);
                    }
                }
            }
        }
        #endregion


        LYFZ.BLL.BLL_ErpDressSaleRentalDetail DressSaleRentalDetailBll = new BLL.BLL_ErpDressSaleRentalDetail();
        DataTable dt_DressSaleRentalDetai = null;

        LYFZ.BLL.BLL_ErpDressSendWashDetail DressSendWashDetailBll = new BLL.BLL_ErpDressSendWashDetail();
        DataTable dt_DressSendWashDetail = null;

        #region 画分页
        /// <summary>
        /// 画分页
        /// </summary>
        /// <param name="e"></param>
        /// <returns></returns>
        private int ucPagerEx1_EventPaging(UCPager.EventPagingArg e)
        {
            LYFZ.UCPager.PageData pageData = new LYFZ.UCPager.PageData();
            dgv.Rows.Clear();
            DataTable dt = new DataTable();
            string StrWhere = "";
            if (!string.IsNullOrEmpty(txtkeyword.Text))
            {
                StrWhere = "";
                StrWhere += " 1=1 and (Dsfm_DressNumber like '%" + txtkeyword.Text + "%' or Dsfm_DressName like '%" + txtkeyword.Text + "%' and Dsfm_IsEnabled='1')";
            }
            if (!string.IsNullOrEmpty(CtvDsfm_DressType.Text) && CtvDsfm_DressType.Text != "全部")
            {
                StrWhere = "";
                StrWhere += " 1=1 and Dsfm_DressType='" + CtvDsfm_DressType.Tag.ToString() + "' and Dsfm_IsEnabled='1'";
            }
            if (!string.IsNullOrEmpty(CtvDsfm_DressType.Text) && CtvDsfm_DressType.Text != "全部" && !string.IsNullOrEmpty(txtkeyword.Text))
            {
                StrWhere = "";
                StrWhere += " 1=1 and Dsfm_DressType='" + CtvDsfm_DressType.Tag.ToString() + "' and Dsfm_IsEnabled='1' and (Dsfm_DressNumber like '%" + txtkeyword.Text + "%' or Dsfm_DressName like '%" + txtkeyword.Text + "%')";
            }
            if (CtvDsfm_DressType.Text == "全部" && !string.IsNullOrEmpty(txtkeyword.Text))
            {
                StrWhere = "";
                StrWhere += " 1=1 and  Dsfm_DressNumber like '%" + txtkeyword.Text + "%' or Dsfm_DressName like '%" + txtkeyword.Text + "%' and Dsfm_IsEnabled='1'";
            }
            if (string.IsNullOrEmpty(txtkeyword.Text) && (string.IsNullOrEmpty(CtvDsfm_DressType.Text) || CtvDsfm_DressType.Text == "全部"))
            {
                StrWhere = " 1=1 and Dsfm_IsEnabled='1'";
            }

            LYFZ.ComponentLibrary.FrmLoadHandling.LoadDoWorkMethod(delegate(object obj, BackgroundWorker backgroundWorker)
            {
                pageData.TableName = "View_tb_ErpDressFrom";
                pageData.PageIndex = this.ucPagerEx1.PageCurrent;
                pageData.PageSize = this.ucPagerEx1.PageSize;
                pageData.QueryCondition = StrWhere.ToString();
                pageData.QueryFieldName = "ID,Dsfm_DressNumber,Dsfm_DressType,Dsfm_DressName,Dsfm_DressBrand,Dsfm_DressSize,Dsfm_DressQuantity,Dsfm_CostPrice,Dsfm_RentPrice,Dsfm_SalePrice,Dsfm_IsEnabled,Dsfm_PlacedRegion,Dsfm_PicturePath,Dsfm_DressIntroduce,Dsfm_DressDetail,Dsfm_DressRemark,Dsfm_CreateDateTime,Dsfm_CreateName,Dsfm_UpdateDateTime,Dsfm_UpdateName,Dsfm_DressTypeName,Dsfm_PlacedRegionName ";
                pageData.OrderStr = " ID desc ";

                DataSet da = pageData.QueryDataTable();
                dt = da.Tables[0];
                if (dt.Rows.Count > 0)
                {
                    #region
                    dt_DressSaleRentalDetai = DressSaleRentalDetailBll.View_DressSaleRentalDetail("").Tables[0];
                    dt_DressSendWashDetail = DressSendWashDetailBll.View_DressSendWashDetail("").Tables[0];
                    #endregion
                    this.Invoke(new UpdateControl(delegate()
                    {
                        for (int t = 0; t < dt.Rows.Count; t++)
                        {
                            #region
                            DataGridViewRow dgvr = new DataGridViewRow();
                            DataGridViewCell cell = null;

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

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

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

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

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

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

                            #region 已租
                            DataRow[] dt_DressSaleRentalDetaiCount = dt_DressSaleRentalDetai.Select(" Dsrd_DressNumber='" + dt.Rows[t]["Dsfm_DressNumber"].ToString().Trim() + "' and Dsro_Type='0'");
                            cell = new DataGridViewTextBoxCell();
                            cell.Value = dt_DressSaleRentalDetaiCount.Length;
                            dgvr.Cells.Add(cell);
                            #endregion

                            #region 已售
                            cell = new DataGridViewTextBoxCell();
                            dt_DressSaleRentalDetaiCount = dt_DressSaleRentalDetai.Select(" Dsrd_DressNumber='" + dt.Rows[t]["Dsfm_DressNumber"].ToString().Trim() + "' and Dsro_Type='1'");
                            cell.Value = dt_DressSaleRentalDetaiCount.Length;
                            dgvr.Cells.Add(cell);
                            #endregion

                            #region 送洗
                            cell = new DataGridViewTextBoxCell();
                            dt_DressSaleRentalDetaiCount = dt_DressSendWashDetail.Select(" Dswd_DressNumber='" + dt.Rows[t]["Dsfm_DressNumber"].ToString().Trim() + "'");
                            cell.Value = dt_DressSaleRentalDetaiCount.Length;
                            dgvr.Cells.Add(cell);
                            #endregion

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

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

                            cell = new DataGridViewTextBoxCell();
                            cell.Value = Convert.ToDateTime(dt.Rows[t]["Dsfm_CreateDateTime"].ToString().Trim()).ToString("yyyy-MM-dd");
                            dgvr.Cells.Add(cell);

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

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

        }
        #endregion
    }
}