using CY.Infrastructure.Common;
using CY.Infrastructure.Logging;
using CY.SQLDAL;
using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using static CY.WebForm.MainPage;
using CY.Model.OA;
using CY.WebForm.Helper;
using CY.Infrastructure.Query;
using System.IO;

namespace CY.WebForm.Pages.business
{
    public partial class OrderUpLoadLiuyang : BasePage
    {

        
        /// <summary>
        /// 选择文件
        /// </summary>
        List<HttpFileCollection> SelFile { set; get; }
        /// <summary>
        /// 留样附件集合
        /// </summary>
        List<EC_OrderLiuyang> fileDataList { set; get; } = new List<EC_OrderLiuyang>();
        /// <summary>
        /// 附件个数
        /// </summary>
        public int  FileCount { get; set; }
        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageSize=5;
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;

            
            
                if (Request["deleteKeyIds"] != null&& Request["deleteKeyIds"]!="")
            {
                if (Request["deleteKeyIds"] == "all")
                {
                    //删除说有页面
                    string keyid = Request["deleteKeyIds"].ToString();
                    string pageID = Request["Keyid"];
                    Database DC = new Database();
                    string sqlStr = string.Format(@" select  [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang] where [orderid]={0} ORDER BY [CreateTime] ", pageID);


                    try
                    {
                        SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                        //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
                        var a = myCmd.ExecuteReader();
                        //myDa.Dispose();
                        fileDataList = new List<EC_OrderLiuyang>();
                        EC_OrderLiuyang Contract;
                        while (a.Read())
                        {   //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
                            Contract = new EC_OrderLiuyang();
                            Contract.Keyid = a.GetGuid(0);
                            Contract.orderid = a.GetInt32(1);
                            Contract.FileName = a.GetString(2);
                            Contract.FilePath = a.GetString(3);
                            Contract.Remark = a.GetString(4);


                            fileDataList.Add(Contract);
                        }
                        a.Close();     //关闭sqldatareader
                        if (fileDataList.Count > 0)
                        {
                            foreach (var item in fileDataList)
                            {
                                FileInfo file = new FileInfo(Server.MapPath(item.FilePath));//指定文件路径
                                if (file.Exists)//判断文件是否存在
                                {
                                    file.Attributes = FileAttributes.Normal;//将文件属性设置为普通,比方说只读文件设置为普通
                                    file.Delete();//删除文件
                                }
                                sqlStr = string.Format(@" DELETE FROM [dbo].[EC_OrderLiuyang] where Keyid='{0}'", item.Keyid);
                                myCmd = new SqlCommand(sqlStr, DC.Connection);
                                myCmd.ExecuteNonQuery();
                                myCmd.Dispose();
                            }
                          
                        }
                    
                        JavaScript.MessageBox("删除成功", this);
                        //  Response.Redirect("/Pages/business/OrderUpLoadLiuyang.aspx");
                    }
                    catch (Exception ee)
                    {
                        new Log4NetAdapter().Log("查找留样出错：" + ee.Message);
                        JavaScript.MessageBox("删除失败", this);

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



                }
                else
                {
                    //删除页面
                    string keyid = Request["deleteKeyIds"].ToString();

                    string orderid = Request["Keyid"].ToString(); 

                    Database DC = new Database();
                    string sqlStr = string.Format(@" select [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang] where Keyid='{0}'ORDER BY [CreateTime] ", keyid);


                    try
                    {
                        SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                        //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
                        var a = myCmd.ExecuteReader();
                        //myDa.Dispose();
                        fileDataList = new List<EC_OrderLiuyang>();
                        EC_OrderLiuyang Contract;
                        while (a.Read())
                        {   //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
                            Contract = new EC_OrderLiuyang();
                            Contract.Keyid = a.GetGuid(0);
                            Contract.orderid = a.GetInt32(1);
                            Contract.FileName = a.GetString(2);
                            Contract.FilePath = a.GetString(3);
                            Contract.Remark = a.GetString(4);


                            fileDataList.Add(Contract);
                        }
                        a.Close();     //关闭sqldatareader
                        if (fileDataList.Count > 0)
                        {
                            FileInfo file = new FileInfo(Server.MapPath(fileDataList[0].FilePath));//指定文件路径
                            if (file.Exists)//判断文件是否存在
                            {
                                file.Attributes = FileAttributes.Normal;//将文件属性设置为普通,比方说只读文件设置为普通
                                file.Delete();//删除文件
                            }
                        }
                        sqlStr = string.Format(@" DELETE FROM [dbo].[EC_OrderLiuyang] where Keyid='{0}'", keyid);
                        myCmd = new SqlCommand(sqlStr, DC.Connection);
                        myCmd.ExecuteNonQuery();
                        //if (fileDataList.Count<=1)
                        //{
                        //    sqlStr = string.Format(@"  update [EC_OrderBasic]        set [LiuyangStatus] =     0  where [Keyid]=  {0}   ", orderid);
                        //    myCmd = new SqlCommand(sqlStr, DC.Connection);
                        //    myCmd.ExecuteNonQuery();
                        //}
                        JavaScript.MessageBox("删除成功", this);
                        //  Response.Redirect("/Pages/business/OrderUpLoadLiuyang.aspx");
                    }
                    catch (Exception ee)
                    {
                        new Log4NetAdapter().Log("查找留样出错：" + ee.Message);
                        JavaScript.MessageBox("删除失败", this);

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

                Response.AppendHeader("deleteKeyIds", "");

            }
              
            if (!IsPostBack)
                BindList();
           
        }
        public Guid GetKeyid()
        {
            return Request["Keyid"].ToGuid2();
        }
        //绑定列表
        private void BindList()
        {

             
            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;
            int Keyid = Request["Keyid"].ToInt32().Value ;
        
               if(Keyid==0)
            {
                JavaScript.MessageBox("未找到该客户", this, false, false);
                return;
            }
            Database DC = new Database();
            string sqlStr =string.Format(@"    select * from (select ROW_NUMBER() OVER(Order by CreateTime ) AS RowNumber,* from [dbo].[EC_OrderLiuyang] where orderid='{0}' ) as b where b.RowNumber BETWEEN ({1}-1)*({2})+1 and {1}*{2} order by CreateTime  ", Keyid,pa.PageIndex,pa.PageSize);
            int count = 0;
            try
            {
                SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
                var  a = myCmd.ExecuteReader();
                //myDa.Dispose();
                fileDataList = new List <EC_OrderLiuyang>();
                EC_OrderLiuyang Contract ;
                while (a.Read())
                {   //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
                    Contract = new EC_OrderLiuyang();
                    Contract.Keyid = a.GetGuid(1);
                    Contract.orderid = a.GetInt32(2);
                    Contract.FileName = a.GetString(3);
                    Contract.FilePath = a.GetString(4);
                    Contract.Remark = a.GetString(5);


                    fileDataList.Add(Contract);
                }
                a.Close();     //关闭sqldatareader
                sqlStr = string.Format("select  count(*) from [dbo].[EC_OrderLiuyang] where orderid='{0}'", Keyid);
                myCmd = new SqlCommand(sqlStr, DC.Connection);
                count = (int)myCmd.ExecuteScalar();


            }
            catch (Exception ee)
            {
                new Log4NetAdapter().Log("查找留样出错：" + ee.Message);

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



            FileCount = fileDataList.Count;

            this.RepClientList.DataSource = fileDataList;// fileDataList.AsEnumerable<EC_OrderLiuyang>();

            this.RepClientList.DataBind();

            UCPager1.AspNetPager.RecordCount = count;
        }
        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

        protected void btn_Submit_Click_multi(object sender, EventArgs e)
        {

            var files = Request.Files;
            //if (files.Count <= 0)
            //    return;
            HttpPostedFile postedFile;
            List<HttpPostedFile> fileList = new List<HttpPostedFile>();


            for (int i=0;i< files.Count;i++)
            {
              
                if (files.Keys[i]=="file2")
                {
                    postedFile = files[i];
                    if (postedFile.ContentLength == 0)
                        continue;
                    fileList.Add(postedFile);
                }
                
            }

            upLoadLiuyangFile uploadContract = new upLoadLiuyangFile();
            EC_OrderLiuyang contract = null;
            //Guid? g = null;
            foreach (var item in fileList)
            {

                //int page = 0;
                //try
                //{
                //    page = pagecount(item);
                //}
                //catch (Exception)
                //{

                //    continue;
                //}
                //try
                //{
                //    g = GetContractFileID(page);
                //}
                //catch (Exception)
                //{

                //    continue;
                //}
               
                //uploadContract = new upLoadLiuyangFile();
                //if (g != null)
                //{

                //    try
                //    {
                //        uploadContract.SavAndUpDataContractFile(item, CountractFileKeiId: g);

                //        JavaScript.MessageBoxandhideLoadingIndicator( "上传文件成功", this);
                //        //JavaScript.RefreshSelf(this);
                //        //JavaScript.RefreshOpener(this);
                       
                //    }
                //    catch (Exception)
                //    {
                //        JavaScript.MessageBoxandhideLoadingIndicator("上传文件失败", this);
                //        // JavaScript.RefreshSelf(this);
                //        //JavaScript.RefreshOpener(this);
                      

                //    }

                //    continue;
                //}

                //新建走下面页面
                 contract = new EC_OrderLiuyang
                 {
                     orderid = Request["Keyid"].ToInt32().Value,
                    FileName = System.IO.Path.GetFileName(item.FileName),
                    Creater = CurrentUser.TrueMemberId,

                };



                try
                {
                    uploadContract.SavAndUpDataContractFile(item, contract);

                    JavaScript.MessageBox("上传文件成功", this);
                   
                   
                }
                catch (Exception)
                {
                    JavaScript.MessageBox( "上传文件失败", this);
                  

                }


            }
            BindList();
               


           

        }
        protected void btn_Submit_Click_DELLALL(object sender, EventArgs e)
        {

          
            string pageID = Request["Keyid"];
            Database DC = new Database();
            string sqlStr = string.Format(@"  SELECT   [Keyid],[orderid],[FileName],[FilePath],[Remark],[Creater],[CreateTime],[Updater],[LastUpdateTime] FROM [ECTEST].[dbo].[EC_OrderLiuyang]   where orderid={0} ORDER BY CreateTime ", pageID);


            try
            {
                SqlCommand myCmd = new SqlCommand(sqlStr, DC.Connection);
                //SqlDataAdapter myDa = new SqlDataAdapter(myCmd);
                var a = myCmd.ExecuteReader();
                //myDa.Dispose();
                fileDataList = new List<EC_OrderLiuyang>();
                EC_OrderLiuyang Contract;
                while (a.Read())
                {   //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
                    Contract = new EC_OrderLiuyang();
                    Contract.Keyid = a.GetGuid(0);
                    Contract.orderid = a.GetInt32(1);
                    Contract.FileName = a.GetString(2);
                    Contract.FilePath = a.GetString(3);
                    Contract.Remark = a.GetString(4);


                    fileDataList.Add(Contract);
                }
                a.Close();     //关闭sqldatareader
                if (fileDataList.Count > 0)
                {
                    foreach (var item in fileDataList)
                    {
                        FileInfo file = new FileInfo(Server.MapPath(item.FilePath));//指定文件路径
                        if (file.Exists)//判断文件是否存在
                        {
                            file.Attributes = FileAttributes.Normal;//将文件属性设置为普通,比方说只读文件设置为普通
                            file.Delete();//删除文件
                        }
                        sqlStr = string.Format(@"  DELETE FROM [dbo].[EC_OrderLiuyang] where Keyid='{0}'", item.Keyid);
                        myCmd = new SqlCommand(sqlStr, DC.Connection);
                        myCmd.ExecuteNonQuery();
                      
                    }
                    sqlStr = string.Format(@"  update [EC_OrderBasic]        set [LiuyangStatus] =     0  where [Keyid]=  {0}   ", pageID);
                    myCmd = new SqlCommand(sqlStr, DC.Connection);

                    myCmd.ExecuteNonQuery();
                    myCmd.Dispose();

                }

                JavaScript.MessageBox("删除成功", this);
                //  Response.Redirect("/Pages/business/OrderUpLoadLiuyang.aspx");
            }
            catch (Exception ee)
            {
                new Log4NetAdapter().Log("查找留样出错：" + ee.Message);
                JavaScript.MessageBox("删除失败", this);

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

            BindList();
        }
     

        public void  test()
        {
            return;
        }
        
     
      



    }
}