asp.net+SQL

/// <summary>
    /// //验证模板
    /// </summary>
    /// <param name="dt"></param>
    /// <param name="strTemplateFile"></param>
    /// <returns></returns>
    private static bool ValidateTemplate(DataTable dt,string strTemplateFile)
    {        
        XmlDocument xd = new XmlDocument();
        strTemplateFile = System.Web.HttpContext.Current.Server.MapPath("") + @"..\..\XMLFile\PartsImportTemplate\" + strTemplateFile;
        xd.Load(strTemplateFile);
        XmlNodeList xnl = xd.SelectNodes("//field");
        string strColumnString = "";
        if (dt.Columns.Count != xnl.Count + 1) return false;
        foreach(DataColumn dl in dt.Columns)
        {
            strColumnString += dl.ColumnName;
            strColumnString += " ";
        }
        
        foreach (XmlNode xn in xnl)
        {
            if (strColumnString.IndexOf(xn.InnerText) == -1) 
            {
                return false;
            }
        }
        return true;
    }

/// <summary>
    /// //根据配置文件验证
    /// </summary>
    /// <param name="dr"></param>
    /// <returns></returns>
    private static string ValidateInfo(DataRow dr,string strFile)
    {
        string strError = "";
        XmlDocument xd = new XmlDocument();
        strFile = System.Web.HttpContext.Current.Server.MapPath("") + @"..\..\XMLFile\PartsImportTemplate\" + strFile;
        xd.Load(strFile);
        //验证必填项
        XmlNodeList xnl = xd.SelectNodes("//field[@isnull='0']");
        foreach(XmlNode xn in xnl)
        {
            if ("" == dr[xn.InnerText].ToString().Trim()) 
            {
                strError = xn.InnerText + "不能为空！";
                return strError;
            }
        }
        //验证整数
        xnl = xd.SelectNodes("//field[@fieldType='int']");
        foreach (XmlNode xn in xnl)
        {
            Regex rx = new Regex(@"^([1-9][0-9]*)$");
            if (dr[xn.InnerText].ToString().Trim().Length > 0 && !rx.IsMatch(dr[xn.InnerText].ToString().Trim()))
            {
                strError = xn.InnerText + "格式应为数字！";
                return strError;
            }
        }
        //验证浮点数
        xnl = xd.SelectNodes("//field[@fieldType='float']");
        foreach (XmlNode xn in xnl)
        {
            if (dr[xn.InnerText].ToString().Trim().Length > 0)
            {
                try
                {
                    float fl = Convert.ToSingle(dr[xn.InnerText].ToString().Trim());
                    //return strError;
                }
                catch
                {
                    strError = xn.InnerText + "格式应为数字或小数！";
                    return strError;
                }
            }           
        }
        //验证日期
        xnl = xd.SelectNodes("//field[@fieldType='date']");
        foreach (XmlNode xn in xnl)
        {
            if (dr[xn.InnerText].ToString().Trim().Length > 0)
            {
                try
                {
                    DateTime fl = Convert.ToDateTime(dr[xn.InnerText].ToString().Trim());
                    //return strError;
                }
                catch
                {
                    strError = xn.InnerText + "格式应为日期！";
                    return strError;
                }
            }
        }
        return strError;

    }