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 WMS.Frm.Base;
using WMS.Model.Base;
using WMS.Common;
using System.Text.RegularExpressions;
using System.Collections;
using WMS.Ctrl;
using WMS.Business;
using WMS.Business.Base;

namespace WMS.FrmBaseData
{
    public partial class FrmCustomerType : FormBase
    {
        #region 变量声明
        /// <summary>
        /// 版定的数据源
        /// </summary>
        public List<CustomerTypeModel> list = new List<CustomerTypeModel>();

        /// <summary>
        /// 实体
        /// </summary>
        public CustomerTypeModel model;

        /// <summary>
        /// 操作标志
        /// </summary>
        public int flag = 0;

        /// <summary>
        /// 所选择节点
        /// </summary>
        public DevExpress.XtraTreeList.Nodes.TreeListNode tr = null;
        #endregion

        public FrmCustomerType()
        {
            InitializeComponent();
        }

        private void FrmCustomerType_Load(object sender, EventArgs e)
        {
            FrmSelectModle = new CustomerTypeModel();
            lue_parentid.LoadData();
            if (frmButtonItem.ContainsKey("Save"))
            {
                frmButtonItem["Save"].Enabled = false;
            }
            BindData();
            LockControl(true);
        }

        #region 通用查询
        /// <summary>
        /// 通用查询
        /// </summary>
        /// <param name="table"></param>
        public override void LoadListData(DataTable table)
        {
            list = ConvertHelper<CustomerTypeModel>.ConvertToList(table);
            bsCustoerType.DataSource = list;
            this.tr_CustomerType.DataSource = list;
            tr_CustomerType.ExpandAll();
            tr_CustomerType.RefreshDataSource();
        }
        #endregion

        #region 绑定
        /// <summary>
        /// 绑定TreeList
        /// </summary>
        public void BindData()
        {
            try
            {
                DataSet dtCustomerType = IBussFactory<BussCustomerType>.Instance().GetCustomerType("");
                list = ConvertHelper<CustomerTypeModel>.ConvertToList(dtCustomerType.Tables[0]);

            }
            catch (Exception ex)
            {
                SystemCommon.ShowInfoMessageBox("加载客户类型出错了GetCustomerType:" + ex.Message);
                return;
            }
            foreach (CustomerTypeModel model in list)
            {
                if (model.Status == "0")
                {
                    model.Status = "正常";
                }
                else if (model.Status == "1")
                {
                    model.Status = "停用";
                }
                else
                { continue; }
            }
            this.tr_CustomerType.DataSource = list;
            tr_CustomerType.ExpandAll();
        }
        #endregion

        #region 事件处理

        #region 去重选择
        /// <summary>
        /// 去重选择
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chkCus_Type_sta_In_CheckedChanged(object sender, EventArgs e)
        {
            if (chkCus_Type_sta_In.Checked)
            {
                chkCus_Type_sta_Off.Checked = !chkCus_Type_sta_In.Checked;
            }
        }

        /// <summary>
        /// 去重选择
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void chkCus_Type_sta_Off_CheckedChanged(object sender, EventArgs e)
        {
            if (chkCus_Type_sta_Off.Checked)
            {
                chkCus_Type_sta_In.Checked = !chkCus_Type_sta_Off.Checked;
            }
        }
        #endregion

        #region 传递实体
        /// <summary>
        /// 传递实体
        /// </summary>
        public void DisplayModel()
        {
            txt_cusType_shortName.Text = model.Cus_short_name;
            txt_cusType_id.Text = model.Cus_type_id;
            txt_cusType_name.Text = model.Cus_type_name;
            txt_cusType_pyName.Text = model.Py_name;
            memoEdit1.Text = model.Remark;
            txt_cusType_sort.Text = model.Sort;
            lue_parentid.EditValue = model.Parent_id;
            //  txt_cusType_version.Text = model.Version;
            if (model.Status == "0")
            {
                chkCus_Type_sta_In.Checked = true;
            }
            else if (model.Status == "1")
            {
                chkCus_Type_sta_Off.Checked = true;
            }
        }
        #endregion

        #region 选中节点传值
        /// <summary>
        /// 选中节点传值
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private void tr_CustomerType_FocusedNodeChanged(object sender, DevExpress.XtraTreeList.FocusedNodeChangedEventArgs e)
        {
            if (frmButtonItem["Save"].Enabled)
            {
                if (SystemCommon.ShowMessageBoxResult("是否保存当前编辑内容？") == DialogResult.OK)
                {
                    Save();
                }
                else
                {
                    Refresh();
                }

            }
            if (e.Node != null)
            {
                string cus_type_id = " and Cus_type_id = '" + e.Node.GetValue("Cus_type_id").ToString() + "'";
                ;
                try
                {
                    DataSet dtCustomerType = IBussFactory<BussCustomerType>.Instance().GetCustomerType(cus_type_id);
                    list = ConvertHelper<CustomerTypeModel>.ConvertToList(dtCustomerType.Tables[0]);

                }
                catch (Exception ex)
                {
                    SystemCommon.ShowInfoMessageBox("出错了：" + ex.Message);
                    return;
                }
                model = new CustomerTypeModel();
                model = list[0];
                DisplayModel();
                LockControl(true);
            }
        }
        #endregion

        #region 锁定控件不可用
        /// <summary>
        /// 锁定或解锁groupbox的textbox控件
        /// </summary>
        /// <param name="bol">true 锁定 false 解除锁定</param>
        public void LockControl(bool bol)
        {
            foreach (Control ctrl in splitContainerControl1.Panel1.Controls)
            {
                if (!ctrl.GetType().ToString().ToLower().Contains("lab"))
                {
                    ctrl.Enabled = !bol;
                }
            }

        }

        #endregion

        #region 通过工作标志判断新增或修改
        /// <summary>
        /// 操作实体,通过工作标志判断新增或修改
        /// </summary>
        public void OperateModel()
        {
            model = new CustomerTypeModel();
            model.Cus_type_id = txt_cusType_id.Text;
            model.Cus_short_name = txt_cusType_shortName.Text;
            model.Cus_type_name = txt_cusType_name.Text;
            model.Py_name = txt_cusType_pyName.Text;
            model.Remark = memoEdit1.Text;
            model.Sort = txt_cusType_sort.Text;
            model.Parent_id = lue_parentid.EditValue.ToString();
            model.OperatorID = userData.USER_ID;
            model.OperateDate = System.DateTime.Now;
            if (chkCus_Type_sta_Off.Checked)
            {
                model.Status = "1";
            }
            else
                model.Status = "0";

            int count = 0;
            try
            {
                count = IBussFactory<BussCustomerType>.Instance().execCustomerTypeAddUpdate(model, flag);
            }
            catch (Exception ex)
            {
                SystemCommon.ShowInfoMessageBox("网络连接错误！");
                return;
            }
            if (count > 0)
            {
                SystemCommon.ShowInfoMessageBox("操作成功！");

                LockControl(true);
                if (frmButtonItem.ContainsKey("Save"))
                {
                    frmButtonItem["Save"].Enabled = false;
                }
                if (frmButtonItem.ContainsKey("Cancel"))
                {
                    frmButtonItem["Cancel"].Enabled = false;
                }
                if (tr != null)
                {
                    tr_CustomerType.FocusedNode = tr;
                }
                txt_cusType_id.Properties.ReadOnly = false;
                BindData();
            }
            else
                SystemCommon.ShowInfoMessageBox("操作失败！");
        }
        #endregion

        #endregion

        #region 按钮事件

        #region 增加事件
        /// <summary>
        /// 增加事件
        /// </summary>
        public override void Add()
        {
            if (frmButtonItem.ContainsKey("Save"))
            {
                frmButtonItem["Save"].Enabled = true;
            }

            if (frmButtonItem.ContainsKey("Cancel"))
            {
                frmButtonItem["Cancel"].Enabled = true;
            }
            flag = 0;//工作标志
            LockControl(false);
            foreach (Control ctrl in splitContainerControl1.Panel1.Controls)
            {
                if (ctrl.GetType().ToString().Contains("WMS.Ctrl.WMSCtrlTextBox"))
                {
                    WMS.Ctrl.WMSCtrlTextBox text = ctrl as WMS.Ctrl.WMSCtrlTextBox;
                    text.Text = "";
                }
            }
            chkCus_Type_sta_In.Checked = true;//默认是正常
            //把当前所选节点的Cus_type_id作为新增节点的父节点
            txt_cusType_id.Focus();
            lue_parentid.EditValue = model.Parent_id;
        }
        #endregion

        #region 编辑按钮
        /// <summary>
        /// 编辑按钮
        /// </summary>
        public override void Edit()
        {
            tr = tr_CustomerType.FocusedNode;
            if (frmButtonItem.ContainsKey("Save"))
            {
                frmButtonItem["Save"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Cancel"))
            {
                frmButtonItem["Cancel"].Enabled = true;
            }
            DisplayModel();

            flag = 1;//工作标志
            LockControl(false);
            txt_cusType_id.Properties.ReadOnly = true;
            txt_cusType_id.Enabled = false;
            txt_cusType_name.SelectAll();
            txt_cusType_name.Focus();
        }
        #endregion

        #region 确认按钮
        /// <summary>
        /// 确认按钮
        /// </summary>
        public override void Save()
        {
            //if (txt_cusType_sort.Properties.ReadOnly)
            //{
            //    SystemCommon.ShowInfoMessageBox("请先选择增加或编辑操作！");

            //    return;
            //}

            if (txt_cusType_id.Text.Trim() == "")
            {
                SystemCommon.ShowInfoMessageBox("编号不能为空！");
                txt_cusType_id.Focus();
                return;
            }
            if (txt_cusType_name.Text.Trim() == "")
            {
                SystemCommon.ShowInfoMessageBox("分类名称不能为空！");
                txt_cusType_name.Focus();
                return;
            }

            Regex reg = new Regex(@"^([a-z]|[A-Z]|[0-9])+$");
            if (!reg.IsMatch(this.txt_cusType_id.Text.Trim()))
            {
                SystemCommon.ShowInfoMessageBox("分类编号只能为字母和数字！");
                this.txt_cusType_id.Focus();
                this.txt_cusType_id.SelectAll();
                return;
            }

            Regex _reg = new Regex(@"^([0-9])+$");
            if (!_reg.IsMatch(this.txt_cusType_sort.Text.Trim()) && txt_cusType_sort.Text.Trim() != "")
            {
                SystemCommon.ShowInfoMessageBox("排序只能为数字！");
                this.txt_cusType_sort.Focus();
                this.txt_cusType_sort.SelectAll();
                return;
            }

            if (flag == 0)
            {
                List<CustomerTypeModel> lstCustomerTypes = new List<CustomerTypeModel>();
                try
                {
                    DataSet dtCustomerType = IBussFactory<BussCustomerType>.Instance().GetCustomerType(" and CUS_TYPE_ID ='" + txt_cusType_id.Text + "'");

                    lstCustomerTypes = ConvertHelper<CustomerTypeModel>.ConvertToList(dtCustomerType.Tables[0]);
                }
                catch (Exception ex)
                {
                    SystemCommon.ShowInfoMessageBox("GetCustomerType出错了:" + ex.Message);
                    return;
                }
                if (lstCustomerTypes.Count > 0)
                {
                    SystemCommon.ShowInfoMessageBox("该分类编号已经存在！");
                    txt_cusType_id.SelectAll();
                    txt_cusType_id.Focus();
                    return;
                }
            }
            OperateModel();
        }
        #endregion

        #region 取消按钮
        /// <summary>
        /// 取消按钮
        /// </summary>
        public void Cancel()
        {
            BindData();
            LockControl(true);

            if (frmButtonItem.ContainsKey("Cancel"))
            {
                frmButtonItem["Cancel"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Save"))
            {
                frmButtonItem["Save"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Import"))
            {
                frmButtonItem["Import"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Export"))
            {
                frmButtonItem["Export"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("SaveImport"))
            {
                frmButtonItem["SaveImport"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Add"))
            {
                frmButtonItem["Add"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Edit"))
            {
                frmButtonItem["Edit"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Del"))
            {
                frmButtonItem["Del"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Refresh"))
            {
                frmButtonItem["Refresh"].Enabled = true;
            }
        }
        #endregion

        #region 刷新
        /// <summary>
        /// 刷新按钮
        /// </summary>
        public override void Refresh()
        {
            Cancel();
        }
        #endregion

        #region 删除按钮
        /// <summary>
        /// 删除按钮
        /// </summary>
        public override void Del()
        {
            if (model == null)
            {
                return;
            }

            //删除之前首先查询有没有子类，有子类则提示不能删除
            string _temp1 = " and parent_id = '" + model.Cus_type_id + "'";
            try
            {
                DataSet dtCustomerType = IBussFactory<BussCustomerType>.Instance().GetCustomerType(_temp1);
                list = ConvertHelper<CustomerTypeModel>.ConvertToList(dtCustomerType.Tables[0]);
            }
            catch (Exception ex)
            {
                SystemCommon.ShowInfoMessageBox("出错了Del--GetCustomerType:" + ex.Message);
                return;
            }
            if (list.Count > 0)
            {
                SystemCommon.ShowInfoMessageBox("请先删除该分类下的子分类后再删除该分类！");
                return;
            }
            int count = IBussFactory<BussCustomerType>.Instance().execCustomerTypeDel(model.Cus_type_id);
            if (count > 0)
            {
                SystemCommon.ShowInfoMessageBox("操作成功！");
                BindData();
            }
            else
            {
                SystemCommon.ShowInfoMessageBox("操作失败！");
            }

        }
        #endregion

        #region 导入
        /// <summary>
        /// 导入
        /// </summary>
        public void Import()
        {
            if (frmButtonItem.ContainsKey("SaveImport"))
            {
                frmButtonItem["SaveImport"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Cancel"))
            {
                frmButtonItem["Cancel"].Enabled = true;
            }
            if (frmButtonItem.ContainsKey("Export"))
            {
                frmButtonItem["Export"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Import"))
            {
                frmButtonItem["Import"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Save"))
            {
                frmButtonItem["Save"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Edit"))
            {
                frmButtonItem["Edit"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Add"))
            {
                frmButtonItem["Add"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Del"))
            {
                frmButtonItem["Del"].Enabled = false;
            }
            if (frmButtonItem.ContainsKey("Refresh"))
            {
                frmButtonItem["Refresh"].Enabled = false;
            }
            LockControl(true);
            OpenFileDialog fileDialog = new OpenFileDialog();
            fileDialog.Title = "导入客户分类资料";
            fileDialog.Filter = "Excel文件(*.xls;*.xlsx)|*.xls;*.xlsx";
            DialogResult dialogResult = fileDialog.ShowDialog(this);
            if (dialogResult == DialogResult.OK)
            {

                Hashtable ht = new Hashtable();
                ht.Add("CUS_TYPE_ID", "客户分类编号");
                ht.Add("CUS_TYPE_NAME", "客户分类名称");
                ht.Add("CUS_SHORT_NAME", "客户分类简称");
                ht.Add("PY_NAME", "拼音简称");
                ht.Add("PARENT_ID", "父编号");
                ht.Add("REMARK", "备注");

                list = NPOIHelper<CustomerTypeModel>.Import(fileDialog, ht);

                if (list == null)
                {
                    SystemCommon.ShowInfoMessageBox("分类信息为空！请重新选择");
                    return;
                }
            }
        }
        #endregion

        #region 保存导入数据
        /// <summary>
        /// 保存导入数据
        /// </summary>
        public void SaveImport()
        {
            foreach (CustomerTypeModel model in list)
            {
                model.OperateDate = System.DateTime.Now;
                model.OperatorID = userData.USER_ID;
            }
            List<string> listID = IBussFactory<BussCustomerType>.Instance().Import(list);
            if (listID.Count > 0)
            {
                string fileName = @"D:\客户分类导入错误日志" + System.DateTime.Now.ToString("yyyyMMddHHmmss") + ".txt";
                //fileName = Application.StartupPath.ToString();
                string strContent = "";

                foreach (string str in listID)
                {
                    strContent += str;
                    strContent += "\r\n";
                }
                try
                {

                    SystemCommon.WriteFile(fileName, strContent);
                }
                catch (Exception ex)
                {
                    SystemCommon.ShowInfoMessageBox("写入日志出错！");
                    return;
                }

                string msg = "导入成功 " + (list.Count - listID.Count).ToString() + " 条数据, ";
                msg += "失败 " + listID.Count + " 条.\r\n";
                msg += "成功数据已写入数据库，错误日志已写入" + fileName;
                SystemCommon.ShowInfoMessageBox(msg);
            }
            else
            {
                SystemCommon.ShowInfoMessageBox("导入成功 " + list.Count + " 条数据！");
            }

            Cancel();
        }
        #endregion

        #region 导出
        /// <summary>
        /// 导出
        /// </summary>
        public void Export()
        {

        }
        #endregion

        #endregion
    }
}