- using System.Globalization;
- public class MainClass {
- public static void Main(string[] args) {
- DateTime dt = DateTime.Now;
- String[] format = {
- "d", "D",
- "f", "F",
- "g", "G",
- "m",
- "r",
- "s",
- "t", "T",
- "u", "U",
- "y",
- "dddd, MMMM dd yyyy",
- "ddd, MMM d /"'/"yy",
- "dddd, MMMM dd",
- "M/yy",
- "dd-MM-yy",
- };
- String date;
- for (int i = 0; i < format.Length; i++) {
- date = dt.ToString(format[i], DateTimeFormatInfo.InvariantInfo);
- Console.WriteLine(String.Concat(format[i], " :" , date));
- }
- /** Output.
- *
- * d :08/17/2000
- * D :Thursday, August 17, 2000
- * f :Thursday, August 17, 2000 16:32
- * F :Thursday, August 17, 2000 16:32:32
- * g :08/17/2000 16:32
- * G :08/17/2000 16:32:32
- * m :August 17
- * r :Thu, 17 Aug 2000 23:32:32 GMT
- * s :2000-08-17T16:32:32
- * t :16:32
- * T :16:32:32
- * u :2000-08-17 23:32:32Z
- * U :Thursday, August 17, 2000 23:32:32
- * y :August, 2000
- * dddd, MMMM dd yyyy :Thursday, August 17 2000
- * ddd, MMM d "'"yy :Thu, Aug 17 '00
- * dddd, MMMM dd :Thursday, August 17
- * M/yy :8/00
- * dd-MM-yy :17-08-00
- */
- }
- }
- using System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Web;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Data.SqlClient;
- using System.Configuration;
- using System.Drawing;
- using System.Web.UI.HtmlControls;
- using System.Data;
- public partial class Default3 : System.Web.UI.Page
- {
- protected void Page_Load(object sender, EventArgs e)
- {
- string connectionString = ConfigurationManager.ConnectionStrings["DataImportConnectionString"].ConnectionString;
- SqlConnection connection = new SqlConnection(connectionString);
- connection.Open();
- SqlCommand commandAboutHuojia = new SqlCommand(
- string.Format("SELECT * FROM [info] "));
- commandAboutHuojia.Connection = connection;
- SqlDataReader resultOfInfo = commandAboutHuojia.ExecuteReader();
- //创建html表格
- HtmlTable locationLayoutTable = new HtmlTable();
- this.form1.Controls.Add(locationLayoutTable);
- locationLayoutTable.CellSpacing = 5;
- locationLayoutTable.Style.Add("Table-Layout", "Fixed");
- locationLayoutTable.Align = "center";
- while (resultOfInfo.Read())
- {
- //每一格子插入一行数据
- HtmlTableRow tr = new HtmlTableRow();
- HtmlTableCell td = new HtmlTableCell();
- locationLayoutTable.Controls.Add(tr);
- tr.Controls.Add(td);
- Label la = new Label();
- td.Controls.Add(la);
- object[] values=new object[resultOfInfo.FieldCount];
- resultOfInfo.GetValues(values);
- if (values[0].Equals("薛勇"))
- for (int i = 0; i < values.Length; i++)
- {
- if (!values[i].Equals(DBNull.Value))
- {
- la.Text += values[i].ToString();
- la.ForeColor = Color.Blue;
- la.Text += "/n";
- }
- }
- else
- {
- for (int i = 0; i < values.Length; i++)
- {
- if (!values[i].Equals(DBNull.Value))
- {
- la.Text += values[i].ToString();
- la.ForeColor = Color.Black;
- }
- }
- }
- }
- resultOfInfo.Dispose();
- resultOfInfo.Close();
- SqlDataAdapter sa = new SqlDataAdapter("SELECT * FROM [info] ", connection);
- DataSet ds = new DataSet();
- int num=sa.Fill(ds);
- DataTableReader tablereader = ds.CreateDataReader();
- while (tablereader.Read())
- {
- object[] values = new object[tablereader.FieldCount];
- tablereader.GetValues(values);
- for (int i = 0; i < values.Length; i++)
- {
- if (!values[i].Equals(DBNull.Value))
- {
- Label la = new Label();
- this.form1.Controls.Add(la);
- la.Text += values[i].ToString();
- la.ForeColor = Color.Blue;
- la.Text += "/n";
- }
- }
- }
- tablereader.Dispose();
- tablereader.Close();
- connection.Close();
- }
- }
- sing System;
- using System.Collections.Generic;
- using System.Linq;
- using System.Text;
- using System.Text.RegularExpressions;
- namespace S.Workflow.Core
- {
- public static class ValueFormater
- {
- /// <summary>
- /// 格式化字符串
- /// </summary>
- /// <param name="value">格式化长整型、浮点型和字符串类型的值,其他类型返回value的字符串形式</param>
- /// <returns>返回格式化后的字符串</returns>
- public static string FormatValueToString(object value)
- {
- if (value.GetType().Equals(typeof(long)))
- {
- return Uri.EscapeDataString(value.ToString() + "L");
- }
- if (value.GetType().Equals(typeof(double)))
- {
- return Uri.EscapeDataString(value.ToString() + "D");
- }
- if (value.GetType().Equals(typeof(string)))
- {
- return Uri.EscapeDataString("/"" + value + "/"");
- }
- return Uri.EscapeDataString(value.ToString());
- }
- /// <summary>
- /// 解析格式化过的字符串
- /// </summary>
- /// <param name="valueString">格式化过的字符串</param>
- /// <returns>返回格式化前类型的值</returns>
- public static object ParseValueString(string valueString)
- {
- valueString = Uri.UnescapeDataString(valueString);
- int intValue;
- if (GetIntValue(valueString, out intValue))
- {
- return intValue;
- }
- long longValue;
- if (GetLongValue(valueString, out longValue))
- {
- return longValue;
- }
- double doubleValue;
- if (GetDoubleValue(valueString, out doubleValue))
- {
- return doubleValue;
- }
- DateTime dateTimeValue;
- if (GetDateTimeValue(valueString, out dateTimeValue))
- {
- if (dateTimeValue.ToString() != DateTime.MaxValue.ToString())
- { return dateTimeValue; }
- else
- {
- return DateTime.MaxValue;
- }
- }
- string stringValue;
- if (GetStringValue(valueString, out stringValue))
- {
- return stringValue;
- }
- bool boolValue;
- if (GetBoolValue(valueString, out boolValue))
- {
- return boolValue;
- }
- return string.Empty;
- }
- /// <summary>
- /// 判断是否整型
- /// </summary>
- /// <param name="formatString"></param>
- /// <param name="intValue"></param>
- /// <returns>如果是整型,则返回intValue</returns>
- public static bool GetIntValue(string formatString, out int intValue)
- {
- intValue = 0;
- string regexString = @"(^[+-]?[0]*[1-9]/d*$)|(^[+-]?[0]+$)";
- Regex regex = new Regex(regexString);
- bool isMatch = regex.IsMatch(formatString);
- if (isMatch)
- {
- isMatch = int.TryParse(formatString,out intValue);
- }
- return isMatch;
- }
- /// <summary>
- /// 判读是否是长整型
- /// </summary>
- /// <param name="formatString"></param>
- /// <param name="longValue"></param>
- /// <returns>如果是返回转换后的longValue</returns>
- public static bool GetLongValue(string formatString, out long longValue)
- {
- longValue = 0;
- string regexString = @"(^[+-]?[0]*[1-9]/d*[Ll]$)|(^[+-]?[0]+[Ll]$)";
- Regex regex = new Regex(regexString);
- bool isMatch = regex.IsMatch(formatString);
- if (isMatch)
- {
- longValue = long.Parse(formatString.TrimEnd('l', 'L'));
- }
- return isMatch;
- }
- /// <summary>
- /// 判断是否浮点型
- /// </summary>
- /// <param name="formatString"></param>
- /// <param name="doubleValue"></param>
- /// <returns>如果是返回转化后的doubleValue</returns>
- public static bool GetDoubleValue(string formatString, out double doubleValue)
- {
- doubleValue = 0;
- string regexString = @"(^[+-]?[0]*[1-9]/d*([.]/d+)?[Dd]$)|(^[+-]?[0]+([.][0]+)?[Dd]$)";
- Regex regex = new Regex(regexString);
- bool isMatch = regex.IsMatch(formatString);
- if (isMatch)
- {
- doubleValue = double.Parse(formatString.TrimEnd('d', 'D'));
- }
- return isMatch;
- }
- /// <summary>
- /// 判断是否日期类型
- /// </summary>
- /// <param name="formatString"></param>
- /// <param name="dateTimeValue"></param>
- /// <returns>如果是返回转化后的dateTimeValue</returns>
- public static bool GetDateTimeValue(string formatString, out DateTime dateTimeValue)
- {
- dateTimeValue = DateTime.MaxValue;
- string regexString = @"^(/d{1,4})[-./]([0]?[1-9]|([1][012]))[-./](([0]?[1-9])|" +
- @"([12]/d)|([3][01]))([ ]+)?((([0])|([01]/d)|[2][0-3])[:][0-5]/d[:][0-5]/d([.]/d{3})?)?$";
- Regex regex = new Regex(regexString);
- bool isMatch = regex.IsMatch(formatString);
- if (isMatch)
- {
- //这里并没有对日期是否存在进行完全的验证,比如平年和闰年的2月,每个月具体有几天。
- try
- {
- dateTimeValue = DateTime.Parse(formatString);
- }
- catch
- { isMatch = false; }
- }
- return isMatch;
- }
- /// <summary>
- /// 判读是否是Bool类型的
- /// </summary>
- /// <param name="formatString"></param>
- /// <param name="boolValue"></param>
- /// <returns>如果是返回转化后的boolValue</returns>
- public static bool GetBoolValue(string formatString, out bool boolValue)
- {
- boolValue = true;
- string regexString = @"^([Tt][Rr][Uu][Ee]$)|([Ff][Aa][Ll][Ss][Ee]$)";
- Regex regex = new Regex(regexString);
- bool isMatch = regex.IsMatch(formatString);
- if (isMatch)
- {
- boolValue = bool.Parse(formatString);
- }
- return isMatch;
- }
- /// <summary>
- /// 判读是否string类型的
- /// </summary>
- /// <param name="formatString"></param>
- /// <param name="stringValue"></param>
- /// <returns>如果是返回转化后的stringValue</returns>
- public static bool GetStringValue(string formatString, out string stringValue)
- {
- stringValue = string.Empty;
- string regexString = @"^""[/w/W]+""$";
- Regex regex = new Regex(regexString);
- bool isMatch = regex.IsMatch(formatString);
- if (isMatch)
- {
- stringValue = formatString.Substring(1, formatString.Length - 2);
- }
- return isMatch;
- }
- public static Dictionary<string, string> ConvertToString (Dictionary<string, object> data)
- {
- Dictionary<string,string> dic = new Dictionary<string,string>();
- foreach (KeyValuePair<string, object> valuePair in data)
- {
- dic.Add(valuePair.Key, FormatValueToString(valuePair.Value));
- }
- return dic;
- }
- }
- }