lyfz_repos/铂金版源码/LYFZ.Software.MainBusiness/InitialSet/PackagesGoods/FrmTheScenery.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;
using System.Collections;
using LYFZ.Software.MainBusiness.DoorCityProcess;

namespace LYFZ.Software.MainBusiness.InitialSet.PackagesGoods
{
    public partial class FrmTheScenery : LYFZ.Software.UI.InitialSet.PackagesGoods.FrmTheScenery
    {
        LYFZ.BLL.BLL_ErpOrder orbll = new BLL.BLL_ErpOrder();
        LYFZ.BLL.BLL_ErpTheScenery tsbll = new BLL.BLL_ErpTheScenery();
        public FrmTheScenery()
        {
        }
        /// <summary>
        /// 套系大类类型（0：订单景点，1：礼包景点）
        /// </summary>
        public int StrPackagesType;
        /// <summary>
        /// 景点类型（0：景点，1：次数）
        /// </summary>
        public string StrSightsType;
        /// <summary>
        /// 是否保存
        /// </summary>
        public bool IsSaveed = false;
        /// <summary>
        /// 确定后的选择景点数据
        /// </summary>
        public DataTable tbl_Select = new DataTable();
        /// <summary>
        /// 确定后的选择景点数据
        /// </summary>
        public ArrayList ListArray = new ArrayList();

        /// <summary>
        /// 加载数据
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void FrmTheScenery_Load(object sender, EventArgs e)
        {
            //string StrWhereN = " And Tsc_PackagesMainClass = '" + this.StrPackagesType + "'";
            string StrTableName = "tb_ErpTheScenery Left Join tb_ErpSystemCategory on Sc_ClassCode = Tsc_Rating";
            string StrWhere = "Tsc_IsDisable='0' and Tsc_Type='" + this.StrSightsType + "'";
            string StrColumns = "tb_ErpTheScenery.ID,Tsc_Name,Tsc_Type,Tcs_Category,Tsc_PackagesMainClass,Tsc_Rating,Sc_ClassName AS Tsc_RatingName,Tsc_Introduction,Tsc_DetailsOf,Tsc_Address,Tsc_CostPrice,Tsc_SalesPrice,"+
                "Tsc_Remark,Tsc_Thumbnail,Tsc_PhotoAlbum,Tsc_IsDisable,Tsc_CreateDatetime,Tsc_CreateName,Tsc_UpdateDatetime,Tsc_UpdateName,CASE Tcs_Category WHEN 0 THEN '内景' ELSE '外景' END AS Tcs_CategoryName";
            DataTable dt = orbll.GetView_Custom(StrTableName, StrWhere: StrWhere, ShowColumnName: StrColumns).Tables[0];
            //DataTable dt = tsbll.View_ErpTheScenery("Tsc_IsDisable='0' and Tsc_Type='" + this.StrSightsType + "' And Tsc_PackagesMainClass = '" + this.StrPackagesType + "'").Tables[0];
            this.dgv.AutoGenerateColumns = false;
            this.dgv.DataSource = dt;
            this.dgv.ClearSelection();
            if (this.StrSightsType.ToString() == "1")
            {
                this.dgv.Columns["Tsc_SalesPrice"].Visible = false;
                this.dgv.Columns["Tsc_CostPrice"].Visible = false;
            }
            this.dgv.Columns["ID"].Visible = false;
        }
        /// <summary>
        /// 双击事件增加商品
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void dgv_DoubleClick(object sender, EventArgs e)
        {
            try
            {
                if (this.dgv.Rows.Count > 0)
                {
                    if (this.dgv.CurrentCell.ColumnIndex >= 0 && this.dgv.CurrentRow.Index >= 0)
                    {
                        object ID = this.dgv.CurrentRow.Cells["ID"].Value;
                        string Tsc_Name = this.dgv.CurrentRow.Cells["Tsc_Name"].Value.ToString();
                        bool IsFind = false;
                        for (int i = 0; i < this.lst.Items.Count; i++)
                        {
                            ListItem listitem = (ListItem)this.lst.Items[i];
                            if (listitem.StrValue.Equals(ID))
                            { IsFind = true; break; }
                        }
                        if (!IsFind)
                        { this.lst.Items.Add(new ListItem(Tsc_Name, ID)); }
                    }
                }
            }
            catch (Exception ex)
            { MessageBoxCustom.Show(ex.Message); }
        }
        /// <summary>
        /// 按钮增加商品
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnRight_Click(object sender, EventArgs e)
        {
            if (this.dgv.SelectedRows.Count == 0)
            { MessageBoxCustom.Show("请选择景点名称"); return; }
            object ID = this.dgv.CurrentRow.Cells["ID"].Value;
            string Tsc_Name = this.dgv.CurrentRow.Cells["Tsc_Name"].Value.ToString();
            bool IsFind = false;
            for (int i = 0; i < this.lst.Items.Count; i++)
            {
                ListItem listitem = (ListItem)this.lst.Items[i];
                if (listitem.StrValue.Equals(ID))
                { IsFind = true; break; }
            }
            if (!IsFind)
            { this.lst.Items.Add(new ListItem(Tsc_Name, ID)); }
        }
        /// <summary>
        /// 移除商品
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnLeft_Click(object sender, EventArgs e)
        {
            if (this.lst.Items.Count > 0)
            { this.lst.Items.Remove(this.lst.SelectedItem); }
        }
        /// <summary>
        /// 确定
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        protected override void btnSave_Click(object sender, EventArgs e)
        {
            if (lst.Items.Count > 0)
            {
                string StrWhere = "";
                for (int i = 0; i < lst.Items.Count; i++)
                {
                    ListItem listitem = (ListItem)this.lst.Items[i];
                    ListArray.Add(listitem);
                    StrWhere += "'" + listitem.StrValue + "',";
                }
                StrWhere = "ID in (" + StrWhere.TrimEnd(',') + ")";
                tbl_Select = orbll.GetView_Custom("tb_ErpTheScenery", StrWhere: StrWhere, ShowColumnName: "*").Tables[0];
                if (tbl_Select.Rows.Count > 0)
                { this.IsSaveed = true; }
            }
            this.Close();
        }
    }
}