using CY.Infrastructure.Common;
using CY.Infrastructure.Logging;
using CY.Model.OA;
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;

namespace CY.WebForm.Pages.business
{
    public partial class CorporateClientsContractShow : System.Web.UI.Page
    {
        /// <summary>
        /// 合同附件集合
        /// </summary>
        List<OA_CorporateClientsContract> fileDataList { set; get; } = new List<OA_CorporateClientsContract>();
        protected void Page_Load(object sender, EventArgs e)
        {
            ReadList();
        }


        private void ReadList()
        {

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

            if (Keyid == null)
            {
                JavaScript.MessageBox("未找到该客户", this, false, false);
                return;
            }
            Database DC = new Database();
            string sqlStr = string.Format(@"USE [ECTEST]    select * from  [dbo].[OA_CorporateClientContract] where CorporateClientsid='{0}' order by PageCode  ", Keyid);
            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<OA_CorporateClientsContract>();
                OA_CorporateClientsContract Contract;
                while (a.Read())
                {   //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
                    Contract = new OA_CorporateClientsContract();
                    Contract.Keyid = a.GetGuid(0);
                    Contract.CorporateClientsid = a.GetGuid(1);
                    Contract.CorporateClientsName = a.GetString(2);
                    Contract.FileName = a.GetString(3);
                    Contract.PageCode = a.GetInt32(4);
                    Contract.FilePath = a.GetString(5);
                    Contract.Remark = a.GetString(6);


                    fileDataList.Add(Contract);
                }
                a.Close();     //关闭sqldatareader
                sqlStr = string.Format("select  count(*) from [dbo].[OA_CorporateClientContract] where CorporateClientsid='{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();
            }




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

            this.RepClientList.DataBind();

           
        }
    }
}