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.BLL.OA;
using CY.BLL.EC;
using CY.BLL.Inquiry;
using CY.Model.Inquiry;
using System.Drawing;
using CY.Model.OA;
using CY.SQLDAL;
using System.Data.SqlClient;
using CY.Infrastructure.Logging;

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

        OA_DriverRecordBLL _oA_DriverRecordBLL = null;
       
        OA_CarManageBll _OA_CarManageBll = null;
        


        //初始化
        public DeliverPlanDakaList()
        {

            _oA_DriverRecordBLL = new OA_DriverRecordBLL();
            
            _OA_CarManageBll = new OA_CarManageBll();
            
        }

        protected void Page_Load(object sender, EventArgs e)
        {
            UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged;
            if (!IsPostBack)
            {
                

            
                switch (Request["Target"])
                {
                    
                    case "AcceptOrderAll":
                       
                        break;
                    case "AcceptOrderAll2":
                       
                        break; 
                    default:
                        InitialSelectData();
                        BindList();
                        return;
                }
                Response.End();
            }
        }


        //加载查询条件
        protected void InitialSelectData()
        {
            

            this.selCarId.DataSource = _OA_CarManageBll.SelectListByFirmId(CurrentUser.MemberId);
            this.selCarId.DataTextField = "CarNumber";
            this.selCarId.DataValueField = "Keyid";
            this.selCarId.DataBind();
            this.selCarId.Items.Insert(0, new ListItem("全部", ""));


            this.txtCreatTimestart.Value = DateTime.Now.ToString("yyyy-MM-dd");
            this.txtCreatTimeend.Value = DateTime.Now.ToString("yyyy-MM-dd");

        }

        //分页事件
        protected void AspNetPager1_PageChanged(object src, EventArgs e)
        {
            BindList();
        }

        //查询事件
        protected void btn_Search_Click(object sender, EventArgs e)
        {
            BindList();
        }
       

        //绑定列表
        private void BindList()
        {
             


            


            Pagination pa = new Pagination();
            pa.PageSize = UCPager1.AspNetPager.PageSize;
            pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex;

            IEnumerable<OA_DriverRecord> oA_DriverRecords = _oA_DriverRecordBLL.SelectModelPage(pa,
                this.txtCreatTimestart.Value,
                 this.txtCreatTimeend.Value,
                 this.selCarId.Value,
                this.txtCreater.Value,
                this.selClockType.Value
              );

            Database DC = new Database();

            try
            {
                List<OA_CorporateClientsContract> fileDataList = null;
                foreach (var oA_DriverRecord in oA_DriverRecords)
                {
                    if (string.IsNullOrEmpty(oA_DriverRecord.MileageImg))
                    {
                        oA_DriverRecord.MileageImgName = "";
                    }
                    else
                    {
                        oA_DriverRecord.MileageImgName = "<img src=\"" + oA_DriverRecord.MileageImg + "\" width=\"20\" height=\"20\" >";
                    }



                   

                    string sqlStr = string.Format(@"     select * from  [dbo].[OA_attachment] where [OA_Id]='{0}' and [AttachmentType]=4 order by [CreateTime]   ", oA_DriverRecord.Id);

                    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;
                    var i = 1;
                    while (a.Read())
                    {   //注意如何将每次读取到的记录添加到listbox1中（因为第一次做时出错了，嘿嘿）
                        Contract = new OA_CorporateClientsContract();
                        // Contract.Keyid = a.GetInt32(0);
                        //Contract.CorporateClientsid = a.GetGuid(1);
                        //Contract.CorporateClientsName = a.GetString(4);
                        Contract.FileName = a[4].ToString();
                        Contract.PageCode = i;
                        Contract.FilePath = a.GetString(2);
                        // Contract.Remark = a.GetString(6);
                        i += 1;

                        fileDataList.Add(Contract);
                    }
                    a.Close();     //关闭sqldatareader

                    if (fileDataList.Count > 0)
                    {
                        oA_DriverRecord.ZhuangcheImg = "<img src=\"" + fileDataList[0].FilePath + "\" width=\"20\" height=\"20\" >";
                    }
                    else
                    {
                        oA_DriverRecord.ZhuangcheImg = "";
                    }




                    sqlStr = string.Format(@"     select * from  [dbo].[OA_attachment] where [OA_Id]='{0}' and [AttachmentType]=5 order by [CreateTime]   ", oA_DriverRecord.Id);

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

                        fileDataList.Add(Contract);
                    }
                    a.Close();     //关闭sqldatareader

                    if (fileDataList.Count > 0)
                    {
                        oA_DriverRecord.CarConditionImg = "<img src=\"" + fileDataList[0].FilePath + "\" width=\"20\" height=\"20\" >";
                    }
                    else
                    {
                        oA_DriverRecord.CarConditionImg = "";
                    }


                }
            }
            catch (Exception ee)
            {
                new Log4NetAdapter().Log("查找送货单图片出错：" + ee.Message);

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


            this.RepClientList.DataSource = oA_DriverRecords;
            this.RepClientList.DataBind();
            UCPager1.AspNetPager.RecordCount = pa.RecordCount;
        }

        


        
    }
}