using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using CY.BLL;
using CY.Model;
using CY.Infrastructure.Query;
using CY.Infrastructure.Common;
using CY.BLL.Sys;
using CY.Model.Inquiry;
using CY.SQLDAL;
using System.Data.SqlClient;
using CY.Infrastructure.Logging;

namespace CY.WebForm.Pages.business
{
    public partial class CorporateClientsVisit : BasePage
    {
        OA_CorporateClientsBLL bll_OA_CorporateClientsBLL = null;
        Sys_DictionaryBLL bll_Sys_DictionaryBLL = null;//字典业务逻辑操作类对象
        SysInquiry_PrintingTypeBLL bll_SysInquiry_PrintingTypeBLL = null;//印刷业务类型业务逻辑操作类对象
        /// <summary>
        /// 是否需要节假日维护
        /// </summary>
        public bool IsNeedJiejiaRi { get; set; }
        /// <summary>
        /// 是否需要维护
        /// </summary>
        public bool NeedWeihu { get; set; }

        /// <summary>
        /// 合作客户例子
        /// </summary>
        public OA_CorporateClients client { get; set; }
        //初始化
        public CorporateClientsVisit()
        {
            bll_OA_CorporateClientsBLL = new OA_CorporateClientsBLL();
            bll_Sys_DictionaryBLL = new Sys_DictionaryBLL();
            bll_SysInquiry_PrintingTypeBLL = new SysInquiry_PrintingTypeBLL();
        }
        /// <summary>
        /// 是否时维护提醒传过来的
        /// </summary>
        public bool IsWeihuTixingUrl { get; set; } = false;
        //页面加载
        protected void Page_Load(object sender, EventArgs e)
        {

            if (Request["Keyid"] != null || Request["MemberId"] != null)
            {
                OA_CorporateClients m_OA_CorporateClients = bll_OA_CorporateClientsBLL.GetModelDetail(Request["Keyid"].ToGuid2());
                this.spanCompanyName.InnerText = m_OA_CorporateClients.CompanyName;
                this.spanBusinessManagerId.InnerText = m_OA_CorporateClients.BusinessmanagerName;
                this.spanprintdate.InnerText = DateTime.Now.ToString("yyyy-MM-dd");
                client = bll_OA_CorporateClientsBLL.GetModel(Request["Keyid"].ToGuid2());
                IsNeedJiejiaRi = client.JieJiaRiWiHu==true;
                NeedWeihu = client.NeedWiHu == true;
                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.SelectVisitListByCorId(Request["Keyid"].ToGuid2());

                this.RepClientList.DataBind();
                if (IsNeedJiejiaRi)
                    this.btn_Submit.Enabled = true;
                else
                    this.btn_Submit.Enabled = false;


                //判决是否是节假日维护弹窗 这个弹窗添加维护记录后会关闭窗口
                var x = Request["JIeriCount"];
                if (x != "undefined"&&x!=null)
                {
                    this.Button1.Enabled = false;
                    this.txtvisitRemark.Value = x;
                }

                this.txtVisitTime.Value = DateTime.Now.ToString("yyyy-MM-dd");
                //判决是否是提醒弹窗  这个弹窗添加维护记录后会关闭窗口
                var y = Request["tixingweihu"];
                if ( y != null&& y=="1")
                {
                    IsWeihuTixingUrl = true;
                }


            }


        }
        //完结事件
        protected void btn_Submit_Visit(object sender, EventArgs e)
        {
            OA_CorporateClientsVisit m_OA_CorporateClientsVisit = new OA_CorporateClientsVisit();

          
            try
            {
                Guid Keyid = Request["Keyid"].ToGuid2();




                if (Request["Keyid"] != null)
                {


                }
                else
                {
                    JavaScript.MessageBox("请先保存客户", this);
                }

                if (this.txtVisitTime.Value == "")
                {
                    JavaScript.MessageBox("请选择日期", this);

                }
                if (this.txtVisitTime.Value == "")
                {
                    JavaScript.MessageBox("请填写维护记录", this);

                }

                m_OA_CorporateClientsVisit.Keyid = Guid.NewGuid();


                m_OA_CorporateClientsVisit.CorporateClientsid = Keyid;

                m_OA_CorporateClientsVisit.VisitTime = this.txtVisitTime.Value.ToDateTime2();

                m_OA_CorporateClientsVisit.Remark = this.txtvisitRemark.Value.ToString2();
                m_OA_CorporateClientsVisit.Creater = CurrentUser.TrueMemberId;
                m_OA_CorporateClientsVisit.CreateTime = DateTime.Now;
                m_OA_CorporateClientsVisit.Updater = CurrentUser.TrueMemberId;
                m_OA_CorporateClientsVisit.LastUpdateTime = DateTime.Now;


                #region 添加或编辑


                bool result = bll_OA_CorporateClientsBLL.InsertModelVisit(m_OA_CorporateClientsVisit);//更新信息

                if (result)
                {
                    //this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.SelectVisitListByCorId(Keyid);
                    //this.RepClientList.DataBind();
                    this.txtVisitTime.Value = "";
                    this.txtvisitRemark.Value = "";
                    JavaScript.MessageBox("维护保存成功", this, false, false);
                    if (NeedWeihu)
                    {

                        Database DC = new Database();
                        string sqlStr = string.Format("USE [ECTEST]  UPDATE[dbo].[OA_CorporateClients] SET [NeedWiHu] = 'false' where Keyid='{0}'", Request["Keyid"]);

                        try
                        {
                            SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                            //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
                            int a = myCmd.ExecuteNonQuery();
                            //myDa.Dispose();                  


                        }
                        catch (Exception ee)
                        {
                            new Log4NetAdapter().Log("中秋节提醒错误 错误：" + ee.Message);
                            this.txtVisitTime.Value = "";
                            this.txtvisitRemark.Value = "";
                            JavaScript.MessageBox("清除维护标志失败", this, false, false);

                        }
                        finally
                        {
                            if (DC.Connection.State != System.Data.ConnectionState.Closed)
                                DC.Connection.Close();
                        }


                       
                    }



                }

                else
                    JavaScript.MessageBox("维护保存失败", this);
                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.SelectVisitListByCorId(Request["Keyid"].ToGuid2());
                this.RepClientList.DataBind();
                //Province = CurrentUser.Province;
                //City = CurrentUser.City;
                //County = CurrentUser.County;
                //BindData();
                if (IsWeihuTixingUrl)
                    JavaScript.RefreshDIVOpener(this);
                #endregion


            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("操作失败", this);
                if (IsWeihuTixingUrl)
                    JavaScript.RefreshDIVOpener(this);
            }
        }

        protected void btn_Submit_Visit_jiari(object sender, EventArgs e)
        {

           
            OA_CorporateClientsVisit m_OA_CorporateClientsVisit = new OA_CorporateClientsVisit();


            try
            {
                Guid Keyid = Request["Keyid"].ToGuid2();




                if (Request["Keyid"] != null)
                {


                }
                else
                {
                    JavaScript.MessageBox("请先保存客户", this);
                }

                if (this.txtVisitTime.Value == "")
                {
                    JavaScript.MessageBox("请选择日期", this);

                }
                if (this.txtVisitTime.Value == "")
                {
                    JavaScript.MessageBox("请填写维护记录", this);

                }

                m_OA_CorporateClientsVisit.Keyid = Guid.NewGuid();


                m_OA_CorporateClientsVisit.CorporateClientsid = Keyid;

                m_OA_CorporateClientsVisit.VisitTime = this.txtVisitTime.Value.ToDateTime2();

                m_OA_CorporateClientsVisit.Remark = this.txtvisitRemark.Value.ToString2();
                m_OA_CorporateClientsVisit.Creater = CurrentUser.TrueMemberId;
                m_OA_CorporateClientsVisit.CreateTime = DateTime.Now;
                m_OA_CorporateClientsVisit.Updater = CurrentUser.TrueMemberId;
                m_OA_CorporateClientsVisit.LastUpdateTime = DateTime.Now;


                #region 添加或编辑


                bool result = bll_OA_CorporateClientsBLL.InsertModelVisit(m_OA_CorporateClientsVisit);//更新信息

                if (result)
                {
                    //this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.SelectVisitListByCorId(Keyid);
                    //this.RepClientList.DataBind();
                    this.txtVisitTime.Value = "";
                    this.txtvisitRemark.Value = "";
                    JavaScript.MessageBox("维护保存成功", this, false, false);
                    if (IsNeedJiejiaRi)
                    {

                        Database DC = new Database();
                      
                        string sqlStr = string.Format("USE [ECTEST]  UPDATE[dbo].[OA_CorporateClients] SET [JieJiaRiWiHu] = 'false' where Keyid='{0}'", Request["Keyid"]);

                        try
                        {
                            SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                            //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
                            int a = myCmd.ExecuteNonQuery();
                            //myDa.Dispose();                  


                        }
                        catch (Exception ee)
                        {
                            new Log4NetAdapter().Log("节假日清除标志 错误：" + ee.Message);
                            this.txtVisitTime.Value = "";
                            this.txtvisitRemark.Value = "";
                            JavaScript.MessageBox("清除维护标志失败", this, false, false);

                        }
                        finally
                        {
                            if (DC.Connection.State != System.Data.ConnectionState.Closed)
                                DC.Connection.Close();
                        }



                    }



                }

                else
                    JavaScript.MessageBox("维护保存失败", this);
                this.RepClientList.DataSource = bll_OA_CorporateClientsBLL.SelectVisitListByCorId(Request["Keyid"].ToGuid2());
                this.RepClientList.DataBind();
                JavaScript.MessageBox("维护完成", this);
                //Province = CurrentUser.Province;
                //City = CurrentUser.City;
                //County = CurrentUser.County;
                //BindData();
                
              if(IsWeihuTixingUrl)
                JavaScript.RefreshDIVOpener(this);
                #endregion


            }
            catch (Exception ex)
            {
                PAGEHandleException(ex);
                JavaScript.MessageBox("操作失败", this);
                if (IsWeihuTixingUrl)
                    JavaScript.RefreshDIVOpener(this);
            }
        }
    }
}