using System;
using System.Data;
using System.Web;
using System.Drawing;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Text.RegularExpressions ;
using AjaxControlToolkit;

namespace projmanager
{
    /// <summary>
    /// CommHandler類包含本解決方案通用的方法 
    /// </summary>
    public class CommHandler
    {

        #region 字符串轉(zhuǎn)換方法

        /// <summary>
        /// 從前臺獲取的帶空格字符串的處理
        /// </summary>
        /// <param name="s">待處理字符串</param>
        /// <returns>處理后的字符串</returns>
        public static string FormatNullString(string s)
        {
            s = s.Replace("&nbsp;", " ");
            return s.Trim();
        }

        /// <summary>
        /// 將字符串轉(zhuǎn)換為整數(shù)
        /// </summary>
        /// <param name="str">待轉(zhuǎn)換的字符串</param>
        /// <returns>轉(zhuǎn)換后的整數(shù)</returns>
        public static int StringToInt(string str)
        {
            int ret = 0;
            try
            {
                ret = int.Parse(str);
            }
            catch
            {
            }

            return ret;
        }

        /// <summary>
        /// 將字符串轉(zhuǎn)換為浮點數(shù)
        /// </summary>
        /// <param name="str">待轉(zhuǎn)換的字符串</param>
        /// <returns>轉(zhuǎn)換后的浮點數(shù)</returns>
        public static double StringToDouble(string str)
        {
            double ret = 0.0;

            try
            {
                ret = double.Parse(str);
            }
            catch
            { }

            return ret;
        }

        /// <summary>
        /// 將字符串轉(zhuǎn)換為日期格式
        /// </summary>
        /// <param name="val">待轉(zhuǎn)換的字符串</param>
        /// <returns>轉(zhuǎn)換后的日期</returns>
        public static DateTime StringToDateTime(string val)
        {
            //若字符串為空，返回最小日期
            if (val == string.Empty || val == null)
                return System.DateTime.MinValue;

            try
            {
                System.DateTime dt = System.DateTime.Parse(val);
                return dt;
            }
            catch
            {
                return System.DateTime.MinValue;
            }
        }

        public static string Today()
        {
            return DateTimeToString(System.DateTime.Today);
        }

        public static string DateTimeToString(DateTime d)
        {
            string ret = "";

            try
            {
                ret = d.ToString("yyyy-MM-dd");
            }
            catch
            { }

            if (ret == "0001-01-01")
            {
                ret = "";
            }

            return ret;
        }


        #endregion





        /// <summary>
        /// 用VALUEID初始化下拉框
        /// </summary>
        /// <param name="ddl">下拉框ID</param>
        /// <param name="valuetype">VALUETYPE</param>
        /// <param name="emptyLine">是否包含空行</param>
        public static void DDL_Init(DropDownList ddl, string valuetype, bool emptyLine)
        {
            //從HR_Value表中讀取對應(yīng)VALUETYPE的記錄的存儲過程
            string spName = "HR_Value_InitDDL";
            //存儲過程參數(shù)
            object[] para = new object[] { valuetype };

            //調(diào)用SQL文初始化下拉框方法
            DDL_Init(ddl, spName, para, emptyLine);
        }

        /// <summary>
        /// 從存儲過程加載下拉框
        /// </summary>
        /// <param name="ddl"></param>
        /// <param name="spName"></param>
        /// <param name="para"></param>
        /// <param name="emptyLine"></param>
        public static void DDL_Init(DropDownList ddl, string spName, object[] para, bool emptyLine)
        {
            //通過存儲過程查詢數(shù)據(jù)
            DataTable dt = DataAccess.ExecuteDataTable(spName, emptyLine, para);

            //查詢結(jié)果為空
            if (dt == null)
            {
                return;
            }

            //在首行添加空行
            if (emptyLine)
            {
                DataRow dr = dt.NewRow();
                dr["VALUETEXT"] = "";
                dr["VALUEID"] = "";
                dt.Rows.InsertAt(dr, 0);
            }

            //為下拉框綁定數(shù)據(jù)源
            ddl.DataSource = dt;
            ddl.DataTextField = "VALUETEXT";
            ddl.DataValueField = "VALUEID";
            ddl.DataBind();
        }

        /// <summary>
        /// 顯示下拉框指定的行
        /// </summary>
        /// <param name="ddl">下拉框ID</param>
        /// <param name="val">要顯示的值</param>
        public static void DDL_ShowItem(DropDownList ddl, string val)
        {
            //若下拉框當(dāng)前有選中行，清除
            if (ddl.SelectedItem != null)
            {
                ddl.SelectedItem.Selected = false;
            }

            for (int i = 0; i < ddl.Items.Count; i++)
            {
                ListItem li = ddl.Items[i];
                //找到下拉選項中，value等于給定值的
                if (li.Value == val)
                {
                    //將該選項置為選中狀態(tài)
                    li.Selected = true;
                    break;
                }
            }
        }

        /// <summary>
        /// 通過下拉框?qū)㈧o態(tài)數(shù)據(jù)的Value翻譯成Text
        /// </summary>
        /// <param name="ddl">下拉框</param>
        /// <param name="val">待翻譯的Value</param>
        /// <returns>返回Text</returns>
        public static string DDL_ValueToText(DropDownList ddl, string val)
        {
            string ret = "";

            for (int i = 0; i < ddl.Items.Count; i++)
            {
                ListItem li = ddl.Items[i];
                //從下拉框所有選項中找到Value等于給定值的
                if (li.Value == val)
                {
                    //獲取符合條件的選項的Text
                    ret = li.Text;
                    break;
                }
            }

            return ret;
        }



        #region 執(zhí)行前臺腳本相關(guān)

        /// <summary>
        /// 整個頁面重定向到指定的URL
        /// </summary>
        /// <param name="pg">頁面</param>
        /// <param name="url">URL</param>
        public static void ReDirURL(System.Web.UI.Page pg, string url)
        {
            string cmd = "<script for=document event=onreadystatechange language=javascript>\n"
                + "top.main.window.location='"
                + url
                + "'</script> ";
            pg.Response.Write(cmd);
        }

        /// <summary>