?using System;
using System.Data;
using System.Configuration;
using System.Linq;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.HtmlControls;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Xml.Linq;

/// <summary>
///BLLContractSub 的摘要說明
/// </summary>
/// 
namespace corInfMan.BLL
{
    public class BLLContractSub
    {
        public BLLContractSub()
        {
            //
            //TODO: 在此處添加構造函數邏輯
            //
        }
        public void submitApply(string ctname, string ctdatetime, int ctcash, string ctclientname, string ctburdenman, string ctstyle, string ctresume,string username, int iscertified,string times)
        {
            new corInfMan.DAL.DALContracteSub().submitApply(ctname,DateTime.Parse( ctdatetime), ctcash, ctclientname, ctburdenman, ctstyle, ctresume,username, iscertified,int.Parse(times));

        }

        /// <summary>
        /// 信息提示 是否通過審核
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public string isCertified(string username)
        {
            string note;
            int check = new corInfMan.DAL.DALContracteSub().isCertified(username);
            switch (check)
            {
                case 0:
                    note = "您新申請的出差現在還沒通過審核";
                    break;
                case 1:
                    note = "您新申請的出差已通過審核";
                    break;
                case 2:
                    note = "您沒有新的出差等待審核";
                    break;
                case 3:
                    note = "您沒有申請過出差";
                    break;
                default:
                    note = "您沒有申請過出差";
                    break;
            }
            return note;
        }
        /// <summary>
        /// 還未通過審核的合同申請
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public DataTable contracteTable(string username)
        {
            return new corInfMan.DAL.DALContracteSub().contracteTable(username).Tables[0];
        }
        /// <summary>
        /// 已經通過的合同申請
        /// </summary>
        /// <param name="username"></param>
        /// <returns></returns>
        public DataTable contracteOverTable(string username)
        {
            return new corInfMan.DAL.DALContracteSub().contracteOverTable(username).Tables[0];
        }


        /// <summary>
        /// 部門經理審核的合同表    
        /// </summary>
        /// <returns></returns>
        //public DataTable contracteTableList()
        //{

        //    DataTable dt;
        //    dt = new corInfMan.DAL.DALContracteSub.contracteTableList().Tables[0];
        //    dt.Columns.Add("Certified", typeof(bool));
        //    for (int i = 0; i < dt.Rows.Count; i++)
        //    {
        //        if (int.Parse(dt.Rows[i][7].ToString()) == 1)
        //        {
        //            dt.Rows[i]["Certified"] = true;
        //        }
        //        else
        //        {
        //            dt.Rows[i]["Certified"] = false;
        //        }
        //    }
        //    return dt;
        //}
        /// <summary>
        /// 財務部審核的合同表
        /// </summary>
        /// <returns></returns>
        public DataTable travelTableAccountList()
        {
            DataTable dt;
            dt = new corInfMan.DAL.DALTravel().traveTableList().Tables[0];
            return dt;
        }



        /// <summary>
        /// 部門經理審核通過
        /// </summary>
        /// <param name="name"></param>
        /// <param name="check"></param>
        public void isCertified(string name, bool check)
        {
            int icheck;
            if (check)
            {
                icheck = 1;
            }
            else
            {
                icheck = 0;
            }
            new corInfMan.DAL.DALContracteSub().isCertified(name,icheck);
        }

        public DataTable inContracteTable(string username)
        {
            return new corInfMan.DAL.DALContracteSub().inContracteTable(username).Tables[0];
            
        }
    }
}