| public Remove ( int startIndex, int length ) : StringBuilder | ||
| startIndex | int | |
| length | int | |
| return | StringBuilder | |
static void Main()
{
string inputStr = Console.ReadLine();
string multipleString = "";
while (inputStr != "END")
{
multipleString += inputStr;
inputStr = Console.ReadLine();
}
string pattern = @"(?<=<a).*?\s*href\s*=\s*((""[^""]*""(?=>))|('[^']*'(?=>))|([\w\/\:\.]+\.\w{3})|(\/[^'""]*?(?=>)))";
//string pattern = @"(?s)(?:<a)(?:[\s\n_0-9a-zA-Z=""()]*?.*?)(?:href([\s\n]*)?=(?:['""\s\n]*)?)([a-zA-Z:#\/._\-0-9!?=^+]*(\([""'a-zA-Z\s.()0-9]*\))?)(?:[\s\na-zA-Z=""()0-9]*.*?)?(?:\>)";
MatchCollection collection = Regex.Matches(multipleString, pattern);
List<string> resultStrings = new List<string>();
foreach (Match match in collection)
{
StringBuilder tempStr = new StringBuilder(match.Groups[2].Value);
if (tempStr[0] == '"' || tempStr[0] == '\'')
{
tempStr.Remove(0,1);
}
if (tempStr[tempStr.Length-1] == '"' || tempStr[tempStr.Length-1] == '\'')
{
tempStr.Remove(tempStr.Length-1,1);
}
resultStrings.Add(tempStr.ToString());
Console.WriteLine(tempStr);
}
//Console.WriteLine(string.Join("\r\n",resultStrings));
}
public static string ReturnJson(bool bResult, int strErrorCode, string strErrorMsg, Dictionary <string, object> Dictionary)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("{");
sb.Append(string.Format("\"result\":\"{0}\",\"errMsg\":\"{1}\", \"errCode\":\"{2}\",", Convert.ToString(bResult).ToLower(), strErrorMsg, strErrorCode));
sb.Append("\"data\":[{");
try
{
if (Dictionary != null && Dictionary.Keys.Count > 0)
{
foreach (KeyValuePair <string, object> Temp in Dictionary)
{
sb.Append(string.Format("\"{0}\":\"{1}\",", Temp.Key, Convert.ToString(Temp.Value)));
}
sb.Remove(sb.Length - 1, 1);
}
sb.Append("}]}");
}
catch
{
sb.Remove(0, sb.Length);
sb.Append("{");
sb.Append(string.Format("\"result\":\"{0}\",\"errMsg\":\"{1}\", \"errCode\":\"{2}\",", Convert.ToString(bResult).ToLower(), strErrorMsg, strErrorCode));
sb.Append("\"data\":[]");
sb.Append("}");
}
return(sb.ToString().Replace("\r", "").Replace("\n", ""));
}
private void _run()
{
_log.Info("sina level1 行情接收器开始运行");
bool isSent = false;
if (aliases.Count != 0)
{
StringBuilder sb = new StringBuilder();
for (int i = 0; i < aliases.Count; i++)
{
isSent = false;
sb.Append(aliases[i]);
sb.Append(",");
if (i % n == (n - 1))
{
sb.Remove(sb.Length - 1, 1);
t_ReqSymbols.Add(sb.ToString());
sb.Clear();
isSent = true;
}
}
if (!isSent)
{
sb.Remove(sb.Length - 1, 1);
t_ReqSymbols.Add(sb.ToString());
}
}
foreach (string item in t_ReqSymbols)
{
_sendRequest(item);
}
}
/// 某个用户带权限功菜单列表
/// </summary>
/// <param name="guid">用户guid</param>
/// <returns></returns>
public string getJsonTree(string guid)
{
DataTable dt_main = dal.GetRole_menu_right("fatherid=0 and ui_role_id='" + guid + "' order by menuorder").Tables[0];
System.Text.StringBuilder sb = new System.Text.StringBuilder();
sb.Append("[{\"text\":\"导航菜单\",\"children\":[");
if (dt_main.Rows.Count > 0)
{
for (int i = 0; i < dt_main.Rows.Count; i++)
{
sb.Append("{\"id\":\"" + dt_main.Rows[i]["ui_menu_id"].ToString() + "\",\"text\":\"" + dt_main.Rows[i]["menuname"].ToString() + "\",\"iconCls\":\"" + dt_main.Rows[i]["icon"].ToString() + "\",\"children\":[");
//
string sqlwhere = string.Format("fatherid={0} and ui_role_id='{1}' order by menuorder", dt_main.Rows[i]["ui_menu_id"].ToString(), guid);
DataTable dt_list = dal.GetRole_menu_right(sqlwhere).Tables[0];
for (int j = 0; j < dt_list.Rows.Count; j++)
{
sb.Append("{\"id\":\"" + dt_list.Rows[j]["ui_menu_id"].ToString() + "\",\"text\":\"" + dt_list.Rows[j]["menuname"].ToString() + "\",\"iconCls\":\"" + dt_list.Rows[j]["icon"].ToString() + "\",\"checked\":" + dt_list.Rows[j]["roleright"].ToString() + "},");
}
if (dt_list.Rows.Count > 0)
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]},");
}
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]}]");
return(sb.ToString());
}
public static string DataTableToJson(DataTable table, params string[] columnsToParse)
{
if (table == null || table.Rows.Count == 0)
return "{\"total\":0,\"rows\":[]}";
StringBuilder sb = new StringBuilder();
sb.Append("{\"total\":").Append(table.Rows.Count).Append(",");
sb.Append("\"rows\":[");
foreach (DataRow row in table.Rows)
{
sb.Append("{");
if (columnsToParse.Count() == 0)
{
columnsToParse = ParserHelper.GetColumnName(table);
}
foreach (string column in columnsToParse)
{
string m_ColumnValue = GetConfigInfo.FormatDecimalPlaces(row[column], table.Columns[column].DataType); //增加保留小数点功能
sb.Append("\"").Append(column).Append("\":").Append("\"").Append(m_ColumnValue.Trim()).Append("\",");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("},");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]}");
return sb.ToString();
}
public static string FromUpcA(string value)
{
if (!Regex.IsMatch(value, @"^[01]\d{2}([012]0{4}\d{3}|[3-9]0{4}\d{2}|\d{4}0{4}\d|\d{5}0{4}[5-9])"))
throw new ArgumentException("UPC A code cannot be compressed.");
StringBuilder result = new StringBuilder(value);
if (result[5] != '0')
result.Remove(6, 4);
else if (result[4] != '0')
{
result.Remove(5, 5);
result.Insert(6, "4");
}
else if (result[3] != '2' && result[3] != '1' && result[3] != '0')
{
result.Remove(4, 5);
result.Insert(6, "3");
}
else
{
result.Insert(11, result[3]);
result.Remove(3, 5);
}
return result.ToString();
}
/// <summary>
/// datatable 转化为 json
/// </summary>
/// <param name="table"></param>
/// <param name="columnsToParse"></param>
/// <returns></returns>
public static string DataTableToJson(DataTable table, params string[] columnsToParse)
{
if (table == null || table.Rows.Count == 0)
return "{\"total\":0,\"rows\":[]}";
StringBuilder sb = new StringBuilder();
sb.Append("{\"total\":").Append(table.Rows.Count).Append(",");
sb.Append("\"rows\":[");
foreach (DataRow row in table.Rows)
{
sb.Append("{");
foreach (string column in columnsToParse)
{
sb.Append("\"").Append(column).Append("\":").Append("\"").Append(row[column].ToString().Trim()).Append("\",");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("},");
}
sb.Remove(sb.Length - 1, 1);
sb.Append("]}");
return sb.ToString();
}
public static string InsertCharacterInStringAtSpecifiedInterval(string InputString,
int Interval,
char InsertCharacter)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
for (int i = 0; i < InputString.Length; i = i + Interval)
{
int getMe = Interval;
if (i + Interval > InputString.Length)
{
getMe = (InputString.Length - i);
}
sb.Append(InputString.Substring(i, getMe));
sb.Append(InsertCharacter);
}
if (sb[0] == InsertCharacter)
{
sb = sb.Remove(0, 1);
}
if (sb[sb.Length - 1] == InsertCharacter)
{
sb = sb.Remove(sb.Length - 1, 1);
}
return(sb.ToString());
}
protected string NormalizePhoneNumber(string phoneNumber)
{
StringBuilder normalizedNumber = new StringBuilder();
foreach (char symbol in phoneNumber)
{
if (char.IsDigit(symbol) || (symbol == '+'))
{
normalizedNumber.Append(symbol);
}
}
if (normalizedNumber.Length >= 2 && normalizedNumber[0] == '0' && normalizedNumber[1] == '0')
{
normalizedNumber.Remove(0, 1);
normalizedNumber[0] = '+';
}
while (normalizedNumber.Length > 0 && normalizedNumber[0] == '0')
{
normalizedNumber.Remove(0, 1);
}
if (normalizedNumber.Length > 0 && normalizedNumber[0] != '+')
{
normalizedNumber.Insert(0, DefaultCountryCode);
}
return normalizedNumber.ToString();
}
private static string BuildName(List<ObjectCommandPropertyValue> propValues)
{
StringBuilder builder = new StringBuilder();
foreach (ObjectCommandPropertyValue value2 in propValues)
{
if ((value2 != null) && (value2.PropertyValue != null))
{
ICollection propertyValue = value2.PropertyValue as ICollection;
if (propertyValue != null)
{
builder.Append("{");
int length = builder.Length;
foreach (object obj2 in propertyValue)
{
builder.Append(string.Format(CultureInfo.InvariantCulture, "{0}, ", new object[] { obj2.ToString() }));
}
builder = (builder.Length > length) ? builder.Remove(builder.Length - 2, 2) : builder;
builder.Append("}, ");
}
else
{
builder.Append(string.Format(CultureInfo.InvariantCulture, "{0}, ", new object[] { value2.PropertyValue.ToString() }));
}
}
}
if (builder.Length < 2)
{
return string.Empty;
}
return builder.Remove(builder.Length - 2, 2).ToString();
}
/// <summary>
/// 根据操作员权限所对应的json格式字符串
/// </summary>
/// <returns></returns>
public string getJsonMenu(Guid userid)
{
DataTable dt_main = dal.getUserMenu(userid);
System.Text.StringBuilder sb = new System.Text.StringBuilder();
DataRow[] rows = dt_main.Select("fatherid=0");
if (rows.Length > 0)
{
sb.Append("{ \"menus\": [");
for (int i = 0; i < rows.Length; i++)
{
DataRow[] r_list = dt_main.Select(string.Format(" fatherid={0}", rows[i]["ui_menu_id"]));
if (r_list.Length > 0)
{
sb.Append("{ \"menuid\": \"" + rows[i]["ui_menu_id"].ToString() + "\", \"icon\": \"" + rows[i]["icon"].ToString() + "\", \"menuname\": \"" + rows[i]["menuname"].ToString() + "\",\"menus\": [");
for (int j = 0; j < r_list.Length; j++)
{
sb.Append("{ \"menuid\": \"" + r_list[j]["ui_menu_id"].ToString() + "\", \"menuname\": \"" + r_list[j]["menuname"].ToString() + "\", \"icon\": \"" + r_list[j]["icon"].ToString() + "\", \"url\": \"" + r_list[j]["url"].ToString() + "\" },");
}
//去，
sb.Remove(sb.Length - 1, 1);
sb.Append("]},");
}
}
//去，
sb.Remove(sb.Length - 1, 1);
sb.Append("]}");
}
return(sb.ToString());
}
public static void ExportToCsv(System.Web.HttpResponse response, DataTable exportData, string exportName)
{
response.Clear();
byte[] BOM = { 0xEF, 0xBB, 0xBF }; // UTF-8 BOM karakterleri
response.BinaryWrite(BOM);
StringBuilder sb = new StringBuilder();
foreach (DataColumn dc in exportData.Columns)
{
sb.Append((char)(34) + dc.ColumnName + (char)(34));
sb.Append(";");
}
sb = sb.Remove(sb.Length - 1, 1);
sb.AppendLine();
foreach (DataRow dr in exportData.Rows)
{
for (int i = 0; i < exportData.Columns.Count; i++)
{
sb.Append(dr[i].ToString().Replace(';', ',').Replace('\n', ' ').Replace('\t', ' ').Replace('\r', ' '));
sb.Append(";");
}
sb = sb.Remove(sb.Length - 1, 1);
sb.AppendLine();
}
response.ContentType = "text/csv";
response.AppendHeader("Content-Disposition", "attachment; filename=" + exportName + ".csv");
response.Write(sb.ToString());
response.End();
}
private static string ConvertToCanonical(string number)
{
StringBuilder sb = new StringBuilder();
foreach (char ch in number)
{
if (char.IsDigit(ch) || (ch == '+'))
{
sb.Append(ch);
}
}
if (sb.Length >= 2 && sb[0] == '0' && sb[1] == '0')
{
sb.Remove(0, 1);
sb[0] = '+';
}
while (sb.Length > 0 && sb[0] == '0')
{
sb.Remove(0, 1);
}
if (sb.Length > 0 && sb[0] != '+')
{
sb.Insert(0, code);
}
return sb.ToString();
}
public static string ReadLine(this Stream ns)
{
var builder = new StringBuilder();
byte cur = 0;
byte prev = 0;
while (true)
{
if (cur == 10)
{
if (prev == 13)
{
// Remove /r/n
builder.Remove(builder.Length - 2, 2);
}
else
{
// Remove /n
builder.Remove(builder.Length - 1, 1);
}
break;
}
prev = cur;
cur = (byte)ns.ReadByte();
builder.Append((char)cur);
}
return builder.ToString();
}
/// <summary>
/// dataTable中的全部记录转换成Json格式
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
// public static string DataTable2Json(DataTable dt,)
//{
// return DataTable2JsonAfterRow(dt, 0,row);
// }
/// <summary>
///
///
/// </summary>
/// <param name="dt"></param>
/// <param name="after">起行＋１</param>
/// <returns></returns>
public static string DataTable2JsonAfterRow(DataTable dt, int after ,int row,int total)
{
StringBuilder jsonBuilder = new StringBuilder();
if (dt.Rows.Count == 0)
{
jsonBuilder.Append("{\"total\":" + total.ToString());
jsonBuilder.Append(",\"rows\":[]}");
return jsonBuilder.ToString();
}
jsonBuilder.Append("{\"total\":"+total.ToString());
jsonBuilder.Append(dt.TableName);
jsonBuilder.Append(",\"rows\":[");
for (int i = after; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
/// <summary>
/// Converts input phone string to its canonical variant.
/// </summary>
/// <param name="phoneNumberString">Phone number string.</param>
/// <returns>Converted phone string.</returns>
private static string ConvertToCanonical(string phoneNumberString)
{
var resultNumber = new StringBuilder();
resultNumber.Clear();
foreach (char character in phoneNumberString)
{
if (char.IsDigit(character) || (character == '+'))
{
resultNumber.Append(character);
}
}
if (resultNumber.Length >= 2 && resultNumber[0] == '0' && resultNumber[1] == '0')
{
resultNumber.Remove(0, 1);
resultNumber[0] = '+';
}
while (resultNumber.Length > 0 && resultNumber[0] == '0')
{
resultNumber.Remove(0, 1);
}
if (resultNumber.Length > 0 && resultNumber[0] != '+')
{
resultNumber.Insert(0, DefaultCountryCode);
}
return resultNumber.ToString();
}
static void Main(string[] args)
{
string text = Console.ReadLine();
int start = text.IndexOf("<upcase>");
int end = text.IndexOf("</upcase>") + 9;
while(start != -1 && end != -1)
{
StringBuilder sb = new StringBuilder(text);
for(int i= start; i<end; i++)
{
if(sb[i] >= 'a' && sb[i]<='z')
{
sb[i] -= (char)32;
}
}
sb = sb.Remove(end - 9, 9);
sb = sb.Remove(start, 8);
text = sb.ToString();
start = text.IndexOf("<upcase>");
end = text.IndexOf("</upcase>") + 9;
}
Console.WriteLine(text);
}
/// <summary>Creates a regular expression that represents a comma-delimited list of the given regular expression pattern.</summary>
/// <param name="expression">The regular expression.</param>
/// <returns>A new regular expression.</returns>
private static string CreateListRegularExpression(string expression)
{
var emailRegularExpressionBuilder = new StringBuilder(expression);
var prefixBuilder = new StringBuilder();
if (emailRegularExpressionBuilder[0] == '^')
{
prefixBuilder.Append('^');
emailRegularExpressionBuilder.Remove(0, 1);
}
if (emailRegularExpressionBuilder.ToString(0, 2).Equals(@"\b", StringComparison.Ordinal))
{
prefixBuilder.Append(@"\b");
emailRegularExpressionBuilder.Remove(0, 2);
}
var suffixBuilder = new StringBuilder();
if (emailRegularExpressionBuilder[emailRegularExpressionBuilder.Length - 1] == '$')
{
suffixBuilder.Append('$');
emailRegularExpressionBuilder.Remove(emailRegularExpressionBuilder.Length - 1, 1);
}
if (emailRegularExpressionBuilder.ToString(emailRegularExpressionBuilder.Length - 2, 2)
.Equals(@"\b", StringComparison.Ordinal))
{
suffixBuilder.Append(@"\b");
emailRegularExpressionBuilder.Remove(emailRegularExpressionBuilder.Length - 2, 2);
}
return string.Format(CultureInfo.InvariantCulture, @"{0}{1}(?:,\s*{1})*{2}", prefixBuilder, emailRegularExpressionBuilder, suffixBuilder);
}
public byte[] ToBytes()
{
int totalLen = 0;
byte[] bytes = new byte[TOTAL_WIDTH];
StringBuilder sb = new StringBuilder();
sb = sb.Append(CommonDataHelper.FillSpecifyWidthFigure(QUERY_TYPE, 1));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(ACCOUNT_DATE, 8));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(NOTICE_NO, 20));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthFigure(NOTICE_TYPE, 1));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthFigure(BUSINESS_TYPE, 1));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(RESERVE, 256));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
return bytes;
}
private static StringBuilder MoveToBack(StringBuilder test, Tuple<int, int> location){
var charToMoveToBack = test[location.Item1];
test = test.Remove(location.Item1, 1);
test = test.Remove(location.Item2 - 1, 1);
test = test.Append(charToMoveToBack.ToString());
return test;
}
public byte[] ToBytes()
{
int totalLen = 0;
byte[] bytes = new byte[TOTAL_WIDTH];
StringBuilder sb = new StringBuilder();
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(RecordID, 8));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthFigure(RecordLength, 8));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthFigure(RecordNumber, 8));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
if (RecordCollection != null)
{
foreach (var record in RecordCollection)
{
Array.Copy(record.ToBytes(), 0, bytes, totalLen, record.TOTAL_WIDTH);
totalLen += record.TOTAL_WIDTH;
}
}
return bytes;
}
/*
* 插入新供应商
*/
public void insertSupplier(Dictionary<String,String> supplierInformationDict)
{
StringBuilder sqlText = new StringBuilder("insert into supplier(");
foreach (var item in supplierInformationDict)
{
sqlText.Append(item.Key);
sqlText.Append(",");
}
sqlText.Remove(sqlText.Length-1,1); //移除,(多余的逗号)
sqlText.Append(") values(");
SqlParameter[] sqlParameter = new SqlParameter[supplierInformationDict.Count];
int index = 0;
foreach (var item in supplierInformationDict)
{
sqlText.Append("@");
sqlText.Append(item.Key);
sqlText.Append(",");
if (index != supplierInformationDict.Count - 1)
{
sqlParameter[index] = new SqlParameter("@" + item.Key, SqlDbType.VarChar);
}
else
{
sqlParameter[index] = new SqlParameter("@" + item.Key, SqlDbType.DateTime);
}
sqlParameter[index].Value = item.Value;
index++;
}
sqlText.Remove(sqlText.Length - 1, 1); //移除,(多余的逗号)
sqlText.Append(")");
DBHelper.ExecuteNonQuery(sqlText.ToString(),sqlParameter);
}
public static string DataTable2Json(System.Data.DataTable dt, int total = 0)
{
System.Text.StringBuilder jsonBuilder = new System.Text.StringBuilder();
jsonBuilder.Append("{");
if (total == 0)
{
jsonBuilder.AppendFormat("\"total\":{0}, ", dt.Rows.Count);
}
else
{
jsonBuilder.AppendFormat("\"total\":{0}, ", total);
}
jsonBuilder.Append("\"rows\":[ ");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
/// <summary>
/// DataSet To Json by chuchur 2013年12月24日 09:52:32
/// </summary>
/// <param name="ds"></param>
/// <returns></returns>
public static string dsToJson(this System.Data.DataSet ds)
{
System.Text.StringBuilder str = new System.Text.StringBuilder("[");
for (int o = 0; o < ds.Tables.Count; o++)
{
str.Append("{");
str.Append(string.Format("\"{0}\":[", ds.Tables[o].TableName));
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
str.Append("{");
for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
{
str.Append(string.Format("\"{0}\":\"{1}\",", ds.Tables[0].Columns[j].ColumnName, ds.Tables[0].Rows[i][j].ToString()));
}
str.Remove(str.Length - 1, 1);
str.Append("},");
}
str.Remove(str.Length - 1, 1);
str.Append("]},");
}
str.Remove(str.Length - 1, 1);
str.Append("]");
return(str.ToString());
}
/// <summary>
/// dataTable转换成Json格式
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTable2Json(List<Area> ds)
{
StringBuilder jsonBuilder = new StringBuilder();
if (ds != null && ds.Count > 0)
{
jsonBuilder.Append("[");
for (int i = 0; i < ds.Count; i++)
{
jsonBuilder.Append("{");
jsonBuilder.Append("\"");
jsonBuilder.Append("AreaID");
jsonBuilder.Append("\":\"");
jsonBuilder.Append(ds[i].AreaID);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append("AreaName");
jsonBuilder.Append("\":\"");
jsonBuilder.Append(ds[i].AreaName);
jsonBuilder.Append("\",");
jsonBuilder.Append("\"");
jsonBuilder.Append("FaAreaID");
jsonBuilder.Append("\":\"");
jsonBuilder.Append(ds[i].FaAreaID);
jsonBuilder.Append("\",");
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
}
return jsonBuilder.ToString();
}
public string ConvertPhoneNumber(string num)
{
StringBuilder sb = new StringBuilder();
sb.Clear();
foreach (char ch in num)
{
if (char.IsDigit(ch) || (ch == '+'))
{
sb.Append(ch);
}
}
if (sb.Length >= 2 && sb[0] == '0' && sb[1] == '0')
{
sb.Remove(0, 1);
sb[0] = '+';
}
while (sb.Length > 0 && sb[0] == '0')
{
sb.Remove(0, 1);
}
if (sb.Length > 0 && sb[0] != '+')
{
sb.Insert(0, Code);
}
return sb.ToString();
}
public string ConvertToCanonical(string number)
{
var canonicalNumber = new StringBuilder();
foreach (var ch in number.Where(ch => char.IsDigit(ch) || (ch == '+')))
{
canonicalNumber.Append(ch);
}
if (canonicalNumber.Length >= 2 && canonicalNumber[0] == '0' && canonicalNumber[1] == '0')
{
canonicalNumber.Remove(0, 1);
canonicalNumber[0] = '+';
}
while (canonicalNumber.Length > 0 && canonicalNumber[0] == '0')
{
canonicalNumber.Remove(0, 1);
}
if (canonicalNumber.Length > 0 && canonicalNumber[0] != '+')
{
canonicalNumber.Insert(0, this.countryCode);
}
return canonicalNumber.ToString();
}
public static string ToCharacterSeparatedValues(this DataTable table, string delimiter, bool includeHeader)
{
var result = new StringBuilder();
if (includeHeader)
{
foreach (DataColumn column in table.Columns)
{
result.Append(column.ColumnName);
result.Append(delimiter);
}
result.Remove(result.Length, 0);
result.AppendLine();
}
foreach (DataRow row in table.Rows)
{
for (var x = 0; x < table.Columns.Count; x++)
{
if (x != 0)
result.Append(delimiter);
result.Append(row[table.Columns[x]]);
}
result.AppendLine();
}
result.Remove(result.Length, 0);
result.AppendLine();
return result.ToString();
}
/// <summary>
/// dataTable转换成Json格式
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
public static string DataTable2Json(DataTable dt)
{
StringBuilder jsonBuilder = new StringBuilder();
jsonBuilder.Append("{\"");
jsonBuilder.Append(dt.TableName);
jsonBuilder.Append("\":[");
//jsonBuilder.Append("[");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return jsonBuilder.ToString();
}
public static string DataTableToJson(DataTable dt)
{
System.Text.StringBuilder jsonBuilder = new System.Text.StringBuilder();
jsonBuilder.Append("{\"Name\":\"" + dt.TableName + "\",\"Rows");
jsonBuilder.Append("\":[");
if (dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString().Replace("\"", "\\\""));
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
}
else
{
jsonBuilder.Append("[");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
private static string Data2Json(DataTable dt, string tableName)
{
var jsonBuilder = new System.Text.StringBuilder();
jsonBuilder.Append("{");
jsonBuilder.Append("\"" + tableName + "\":[ ");
for (var i = 0; i < dt.Rows.Count; i++)
{
if (string.IsNullOrEmpty(dt.Rows[i]["DoctorName"].ToString().Trim()))
{
continue;
}
jsonBuilder.Append("{");
for (var j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
/// <summary>
/// 得到json树
/// </summary>
/// <param name="tabel"></param>
/// <param name="idCol"></param>
/// <param name="txtCol"></param>
/// <param name="rela"></param>
/// <param name="pId"></param>
/// <param name="szCheckItems">选中的ID号集合</param>
/// <returns></returns>
public static string GetTreeGridJsonByTable(DataTable dt, string idCol, string txtCol, string rela, object pId, string szCheckItems)
{
System.Text.StringBuilder jsonBuilder = new System.Text.StringBuilder();
jsonBuilder.Append("{");
jsonBuilder.AppendFormat("\"total\":{0}, ", dt.Rows.Count);
jsonBuilder.Append("\"rows\":[ ");
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append("\":\"");
jsonBuilder.Append(dt.Rows[i][j].ToString());
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
jsonBuilder.Append("}");
return(jsonBuilder.ToString());
}
public byte[] ToBytes()
{
int totalLen = 0;
byte[] bytes = new byte[TOTAL_WIDTH];
StringBuilder sb = new StringBuilder();
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(SignType, 1));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(ORG_NO, 6));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(STF_NO, 7));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
if (PIN_BLK == null)
{
PIN_BLK = new byte[24];
}
Array.Copy(PIN_BLK, 0, bytes, totalLen, PIN_BLK.Length);
totalLen += 24;
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(CARD_NO, 20));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
sb = sb.Append(CommonDataHelper.FillSpecifyWidthString(SystemDate, 8));
CommonDataHelper.ResetByteBuffer(sb, ref bytes, ref totalLen, true);
sb.Remove(0, sb.Length);
return bytes;
}
/// <summary>
/// DataTable转换为json字符串
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected string DataTable2Json(DataTable dt)
{
System.Text.StringBuilder jsonBuilder = new System.Text.StringBuilder();
jsonBuilder.Append("[");
if (dt.Rows.Count == 0)
{
jsonBuilder.Append("]");
return(jsonBuilder.ToString());
}
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
//jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append(":\"");
try
{
jsonBuilder.Append(GetSafeJSONString(dt.Rows[i][j].ToString())); //.Replace("\"","\\\""));
}
catch
{
jsonBuilder.Append("");
}
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
return(jsonBuilder.ToString());
}
/// <summary>
/// Detects untokenized fields and sets as NotAnalyzed in analyzer
/// </summary>
private static string PreProcessUntokenizedTerms(PerFieldAnalyzerWrapper analyzer, string query, Analyzer keywordAnlyzer)
{
var untokenizedMatches = untokenizedQuery.Matches(query);
if (untokenizedMatches.Count < 1)
{
return query;
}
var sb = new StringBuilder(query);
// KeywordAnalyzer will not tokenize the values
// process in reverse order to leverage match string indexes
for (int i=untokenizedMatches.Count; i>0; i--)
{
Match match = untokenizedMatches[i-1];
// specify that term for this field should not be tokenized
analyzer.AddAnalyzer(match.Groups[1].Value, keywordAnlyzer);
Group term = match.Groups[2];
// remove enclosing "[[" "]]" from term value (again in reverse order)
sb.Remove(term.Index+term.Length-2, 2);
sb.Remove(term.Index, 2);
}
return sb.ToString();
}
public static string RandomPassword(int length)
{
var sb = new StringBuilder();
sb.Append("1");
sb.Append("A");
sb.Append("a");
sb.Append("!");
for (var i = 0; i < length; i++)
{
sb.Append(
Convert.ToChar(Convert.ToInt32(Math.Floor((26 * DataHelper.Random.NextDouble()) + 65))));
}
if (sb.Length > 10)
{
sb.Append(DateTime.Now.ToString("hhMMssffff"));
sb.Remove(0, 10);
}
else if (sb.Length > 6)
{
sb.Append(DateTime.Now.ToString("hhMMss"));
sb.Remove(0, 6);
}
return sb.ToString();
}
private static string CreateInsertSqlString(Table table, IDictionary<string, object> parameters)
{
var sb = new StringBuilder();
sb.AppendLine("IF NOT EXISTS (SELECT * FROM {0} WHERE {1})".Put(table.Name, table.Columns.Where(c => c.IsPrimaryKey).Select(c => "{0} = @{0}".Put(c.Name)).Join(" AND ")));
sb.AppendLine("BEGIN");
sb.Append("INSERT INTO ");
sb.Append(table.Name);
sb.Append(" (");
foreach (var par in parameters)
{
sb.Append("[");
sb.Append(par.Key);
sb.Append("],");
}
sb.Remove(sb.Length - 1, 1);
sb.Append(") VALUES (");
foreach (var par in parameters)
{
sb.Append("@");
sb.Append(par.Key);
sb.Append(",");
}
sb.Remove(sb.Length - 1, 1);
sb.AppendLine(")");
sb.Append("END");
return sb.ToString();
}
public void Insert(string Table, List<string> ColumnNames, List<Object> Values)
{
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO ");
sb.Append(Table);
sb.Append(" (");
foreach (string column in ColumnNames)
{
sb.Append(column);
sb.Append(",");
}
sb.Remove(sb.Length - 1, 1);
sb.Append(") VALUES (");
foreach (object value in Values)
{
if (value.GetType() == typeof(double) || value.GetType() == typeof(int))
{
sb.Append(value.ToString().Replace(',', '.') + ",");
}
else
{
sb.Append("'" + value + "',");
}
}
sb.Remove(sb.Length - 1, 1);
sb.Append(")");
Execute(sb.ToString());
}
/// <summary>
/// Arma los filtros que se aplicarán para regenerar
/// el reporte. Depende de cada implementación del
/// IPanelFiltros.
/// </summary>
private string armaFiltro()
{
var sb = new StringBuilder();
// Filtros de fecha
// Si no selecciona ningún filtro, genera una excepción.
if (chkListaEntidades.CheckedItems.Count != 0 &&
chkEstadosGestion.CheckedItems.Count != 0)
{
// Filtros de entidades
sb.Append("(");
foreach (object item in chkListaEntidades.CheckedItems)
sb.Append(string.Format("Entidad = '{0}' or ", item));
sb.Remove(sb.Length - 4, 4);
sb.Append(")");
// Filtros de estados de cuenta
sb.Append(" and (");
foreach (object item in chkEstadosGestion.CheckedItems)
sb.Append(string.Format("Estado = '{0}' or ", item));
sb.Remove(sb.Length - 4, 4);
sb.Append(")");
return sb.ToString();
}
throw new Exception(Mensaje.TextoMensaje("REPORTE-NOFILTRO"));
}
static void Main()
{
StringBuilder cages = new StringBuilder();
while (true)
{
string input = Console.ReadLine();
if (input == "END")
{
break;
}
cages.Append(input);
}
int cagesToTake = int.Parse((cages[0] - '0').ToString());
int cagesToRemove = 1;
while (cagesToTake < cages.Length)
{
cages.Remove(0, cagesToRemove);
BigInteger sum = 0;
BigInteger product = 1;
for (int i = 0; i < cagesToTake; i++)
{
sum += BigInteger.Parse((cages[i] - '0').ToString());
product *= BigInteger.Parse((cages[i] - '0').ToString());
cages.Insert(0, "*", 1);
cages.Remove(0, 1);
}
string digitsToAppend = AppendTheSumAndProduct(cages, sum, product);
cages.Remove(0, cagesToTake);
cages.Insert(0, digitsToAppend);
if (cagesToRemove >= cages.Length)
{
break;
}
cagesToRemove++;
int cagesToSum = cagesToRemove;
cagesToTake = SumOfDigitsToAppend(digitsToAppend, cagesToRemove);
}
for (int i = 0; i < cages.Length; i++)
{
if (i != cages.Length - 1)
{
Console.Write("{0} ", cages[i]);
}
else
{
Console.WriteLine(cages[i]);
}
}
}
private string GetTableCreationSqlStmt(TableInfo tableInfo)
{
// *** Coyove Patched ***
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder(100);
stringBuilder.AppendFormat("CREATE TABLE \"{0}\" (", tableInfo.Name);
foreach (ColumnInfo current in tableInfo.Values)
{
stringBuilder.AppendFormat("\"{0}\" {1},", current.Name, this.m_DataTypeMap[current.DataType]);
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
// MySQL does not support setting a text column as the primary key
// Switched to Postgresql
if (!DatabaseManager.isExcelExport && tableInfo.PrimaryKeys.Count > 0)
{
stringBuilder.AppendFormat(", CONSTRAINT \"PK_{0}\" PRIMARY KEY (", tableInfo.Name);
for (int i = 0; i < tableInfo.PrimaryKeys.Count; i++)
{
stringBuilder.AppendFormat("\"{0}\",", tableInfo[tableInfo.PrimaryKeys[i]].Name);
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append(")");
}
stringBuilder.Append(")");
return(stringBuilder.ToString());
}
protected override string GetUrl()
{
string[] ids = MyHelper.EnumToArray(this.IDs);
if (ids.Length > 0)
{
System.Text.StringBuilder whereClause = new System.Text.StringBuilder();
if (ids.Length == 1)
{
whereClause.AppendFormat("symbol=\"{0}\"", ids[0]);
}
else
{
whereClause.Append("symbol in (");
foreach (string id in ids)
{
if (id.Trim() != string.Empty)
{
whereClause.AppendFormat("\"{0}\",", MyHelper.CleanYqlParam(id));
}
}
whereClause.Remove(whereClause.Length - 1, 1);
whereClause.Append(')');
}
if (this.ExpirationDates != null)
{
System.DateTime[] expirations = MyHelper.EnumToArray(this.ExpirationDates);
if (ids.Length > 1 & expirations.Length > 1)
{
throw new NotSupportedException("Multiple IDs and multiple Expiration Dates are not supported");
}
if (expirations.Length > 0)
{
if (expirations.Length == 1)
{
whereClause.AppendFormat(" AND expiration=\"{0}-{1:00}\"", expirations[0].Year, expirations[0].Month);
}
else
{
whereClause.Append(" AND expiration in (");
foreach (System.DateTime exp in expirations)
{
whereClause.AppendFormat("\"{0}-{1:00}\",", exp.Year, exp.Month);
}
whereClause.Remove(whereClause.Length - 1, 1);
whereClause.Append(')');
}
}
}
return(MyHelper.YqlUrl("*", "yahoo.finance.options", whereClause.ToString(), null, false));
}
else
{
throw new NotSupportedException("An empty id list will not be supported.");
}
}
/// <summary>
/// DataTable转换为json字符串
/// </summary>
/// <param name="dt"></param>
/// <returns></returns>
protected string DataTable2Json(DataTable dt)
{
System.Text.StringBuilder jsonBuilder = new System.Text.StringBuilder();
jsonBuilder.Append("[");
if (dt.Rows.Count == 0)
{
jsonBuilder.Append("]");
return(jsonBuilder.ToString());
}
for (int i = 0; i < dt.Rows.Count; i++)
{
jsonBuilder.Append("{");
for (int j = 0; j < dt.Columns.Count; j++)
{
//jsonBuilder.Append("\"");
jsonBuilder.Append(dt.Columns[j].ColumnName);
jsonBuilder.Append(":\"");
try
{
/*根据datatable列的数据格式 来格式化字符*/
string tmp = string.Empty;
if (dt.Columns[j].DataType.ToString() == "System.Int16" || dt.Columns[j].DataType.ToString() == "System.Int32" || dt.Columns[j].DataType.ToString() == "System.Int64")
{
tmp = dt.Rows[i][j].ToString();
}
else if (dt.Columns[j].DataType.ToString() == "System.Decimal")
{
tmp = dt.Rows[i][j].ToString();
}
else if (dt.Columns[j].DataType.ToString() == "System.DateTime")
{
if (dt.Rows[i][j] != null && dt.Rows[i][j].ToString() != "")
{
tmp = (Convert.ToDateTime(dt.Rows[i][j].ToString())).ToString("yyyy-MM-dd");
}
}
else
{
tmp = dt.Rows[i][j].ToString();
}
jsonBuilder.Append(GetSafeJSONString(tmp));//.Replace("\"","\\\""));
}
catch
{
jsonBuilder.Append("");
}
jsonBuilder.Append("\",");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("},");
}
jsonBuilder.Remove(jsonBuilder.Length - 1, 1);
jsonBuilder.Append("]");
return(jsonBuilder.ToString());
}
private void GetAllCategories(System.Web.HttpContext context)
{
System.Collections.Generic.IList <CategoryInfo> mainCategories = CategoryBrowser.GetMainCategories();
if (mainCategories == null || mainCategories.Count == 0)
{
context.Response.Write(this.GetErrorJosn(103, "没获取到相应的分类"));
return;
}
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
stringBuilder.Append("{\"result\":[");
foreach (CategoryInfo current in mainCategories)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"cid\":{0},", current.CategoryId);
stringBuilder.AppendFormat("\"name\":\"{0}\",", current.Name);
stringBuilder.AppendFormat("\"icon\":\"{0}\",", current.Icon);
stringBuilder.AppendFormat("\"hasChildren\":\"{0}\",", current.HasChildren.ToString().ToLower());
stringBuilder.AppendFormat("\"description\":\"{0}\",", this.GetSubCategoryNames(current.CategoryId));
stringBuilder.Append("\"subs\":[");
System.Collections.Generic.IList <CategoryInfo> subCategories = CategoryBrowser.GetSubCategories(current.CategoryId);
if (subCategories != null && subCategories.Count > 0)
{
foreach (CategoryInfo current2 in subCategories)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"cid\":{0},", current2.CategoryId);
stringBuilder.AppendFormat("\"name\":\"{0}\",", current2.Name);
stringBuilder.AppendFormat("\"icon\":\"{0}\",", current2.Icon);
stringBuilder.AppendFormat("\"hasChildren\":\"{0}\",", current2.HasChildren.ToString().ToLower());
stringBuilder.Append("\"subs\":[");
System.Collections.Generic.IList <CategoryInfo> subCategories2 = CategoryBrowser.GetSubCategories(current2.CategoryId);
if (subCategories2 != null && subCategories2.Count > 0)
{
foreach (CategoryInfo current3 in subCategories2)
{
stringBuilder.Append("{");
stringBuilder.AppendFormat("\"cid\":{0},", current3.CategoryId);
stringBuilder.AppendFormat("\"name\":\"{0}\",", current3.Name);
stringBuilder.AppendFormat("\"icon\":\"{0}\"", current3.Icon);
stringBuilder.Append("},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
}
stringBuilder.Append("]},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
}
stringBuilder.Append("]},");
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append("]}");
context.Response.Write(stringBuilder.ToString());
}
/// <summary>
/// 将内存中的日志持久化到磁盘
/// </summary>
/// <param name="path">文件的存放目录</param>
private void Persist(System.IO.DirectoryInfo path)
{
//读取时加锁
lock (contentsLockObj)
{
using (System.IO.StreamWriter writer = new System.IO.StreamWriter(PreparePath(path), true, Encoding.UTF8))
{
writer.WriteLine(contents.ToString());
writer.Flush();
writer.Close();
contents.Remove(0, contents.Length);
GC.Collect();
}
}
}
/// <summary>
/// 用户流失人数（个人）
/// </summary>
/// <param name="starttime"></param>
/// <param name="endtime"></param>
/// <param name="errmsg"></param>
/// <returns></returns>
public static int GetUserLoss(string starttime, string endtime, out string errmsg)
{
List <DataParameter> pars = new List <DataParameter>();
System.Text.StringBuilder sqlstr = new System.Text.StringBuilder();
System.Text.StringBuilder sqluserids = new System.Text.StringBuilder();
sqlstr.Append("SELECT b.userid from (SELECT * from (SELECT userid,MAX(createdtime) as t from chosen_orderinfo GROUP BY userid asc) as c WHERE 1=1 ");
if (!string.IsNullOrEmpty(starttime))
{
sqlstr.Append(" and c.t >='@starttime'");
pars.Add(new DataParameter("starttime", starttime));
}
if (!string.IsNullOrEmpty(endtime))
{
sqlstr.Append(" and c.t<='@endtime' ");
pars.Add(new DataParameter("endtime", endtime));
}
if (string.IsNullOrEmpty(endtime) || string.IsNullOrEmpty(starttime))
{
sqlstr.Append(" and c.t>DATE_SUB(CURDATE(), INTERVAL 3 MONTH)");
}
sqlstr.Append(") as b");
List <base_users> list = MySqlHelper.GetDataList <base_users>(sqlstr.ToString(), out errmsg, pars.ToArray());
sqluserids.Append("SELECT COUNT(*) from base_users where userid not in(");
foreach (var item in list)
{
sqluserids.Append(item.userid + ",");
}
sqluserids.Remove(sqluserids.ToString().LastIndexOf(','), 1);
sqluserids.Append(")");
return((int)MySqlHelper.GetRecCount(sqluserids.ToString(), out errmsg, pars.ToArray()));
}
public DataSet Select(BOL.Hunaid1BOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `id`, `fisrtName`, `lastName`, `cellNum`, `email` FROM `hunaid` ");
if (c.Id > 0)
{
qry.Append("`id` = " + c.Id + " AND");
}
if (!string.IsNullOrEmpty(c.FirstName))
{
qry.Append("`firstName` = '" + c.FirstName + "' AND");
}
if (!string.IsNullOrEmpty(c.LastName))
{
qry.Append("`lastName` = '" + c.LastName + "' AND");
}
if (Convert.ToInt32(c.CellNum) > 0)
{
qry.Append("`cellNum` = '" + c.CellNum + "' AND");
}
else
{
qry.Append(" 1 AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
private string GetPrjCode()
{
string cmdText = "SELECT prjCode + ',' FROM dbo.Sm_Treasury WHERE tcode != @tcode FOR XML PATH('')";
SqlParameter[] commandParameters = new SqlParameter[]
{
new SqlParameter("@tcode", this.tcode)
};
string @string = DBHelper.GetString(SqlHelper.ExecuteScalar(CommandType.Text, cmdText, commandParameters));
System.Collections.Generic.List <string> list = (
from s in @string.Split(new char[]
{
','
})
where s.Length > 0
select s).ToList <string>();
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
foreach (string current in list)
{
stringBuilder.Append(",'").Append(current).Append("'");
}
if (stringBuilder.Length > 0)
{
return(stringBuilder.Remove(0, 1).ToString());
}
return(string.Empty);
}
private string GetChargeInfo(clsTestApplyItme_VO[] unitItems, string[] strUnits)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
foreach (clsTestApplyItme_VO objTestVO in unitItems)
{
foreach (string strUnit in strUnits)
{
if (strUnit == objTestVO.m_strItemID)
{
sb.Append(objTestVO.m_strItemName == null ? "" : objTestVO.m_strItemName.Trim());
sb.Append(">");
sb.Append(objTestVO.m_strSpec == null ? "" : objTestVO.m_strSpec.Trim());
sb.Append(">");
sb.Append(objTestVO.m_decQty.ToString() + "" + objTestVO.m_strUnit);
sb.Append(">");
sb.Append(objTestVO.m_decTolPrice.ToString());
sb.Append(">");
sb.Append(objTestVO.m_decDiscount.ToString() + "%");
sb.Append("|");
}
}
}
if (sb.Length > 0)
{
sb.Remove(sb.Length - 1, 1);
}
return(sb.ToString());
}
private string PrintDom(HtmlElementCollection elemColl, System.Text.StringBuilder returnStr, Int32 depth)
{
System.Text.StringBuilder str = new System.Text.StringBuilder();
foreach (HtmlElement elem in elemColl)
{
string elemName;
elemName = elem.GetAttribute("ID");
if (elemName == null || elemName.Length == 0)
{
elemName = elem.GetAttribute("name");
if (elemName == null || elemName.Length == 0)
{
elemName = "<no name>";
}
}
str.Append(' ', depth * 4);
str.Append(elemName + ": " + elem.TagName + "(Level " + depth + ")");
returnStr.AppendLine(str.ToString());
if (elem.CanHaveChildren)
{
PrintDom(elem.Children, returnStr, depth + 1);
}
str.Remove(0, str.Length);
}
return(returnStr.ToString());
}
private string PrintDom(HtmlAgilityPack.HtmlNodeCollection elemColl, System.Text.StringBuilder returnStr, Int32 depth)
{
System.Text.StringBuilder str = new System.Text.StringBuilder();
// IHTMLElement htmlElementCollection = null;
foreach (HtmlNode elem in elemColl)
{
string elemName;
elemName = elem.GetAttributeValue("ID", "null");
if (elemName == null || elemName.Length == 0)
{
elemName = elem.GetAttributeValue("name", "null");
if (elemName == null || elemName.Length == 0)
{
elemName = "<no name>";
}
}
str.Append(' ', depth * 4);
str.Append(elemName + ": " + elem.Name + "(Level " + depth + ")");
returnStr.AppendLine(str.ToString());
if (elem.HasChildNodes)
{
PrintDom(elem.ChildNodes, returnStr, depth + 1);
}
str.Remove(0, str.Length);
}
return(returnStr.ToString());
}
public IDataReader GetDataFromReader(string tableName, List <Column> tableColumns, List <PrimaryKey> tablePrimaryKeys, string whereClause = null)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder(200);
sb.Append("SELECT ");
foreach (Column col in tableColumns)
{
if (col.ServerDataType == "hierarchyid")
{
sb.Append(string.Format(System.Globalization.CultureInfo.InvariantCulture, "CAST([{0}] AS varbinary(892)) AS [{0}], ", col.ColumnName));
}
else
{
sb.Append(string.Format(System.Globalization.CultureInfo.InvariantCulture, "[{0}], ", col.ColumnName));
}
}
sb.Remove(sb.Length - 2, 2);
sb.AppendFormat(System.Globalization.CultureInfo.InvariantCulture, " From [{0}]", GetSchemaAndTableName(tableName));
if (!string.IsNullOrEmpty(whereClause))
{
sb.AppendFormat(System.Globalization.CultureInfo.InvariantCulture, " WHERE {0}", whereClause);
}
sb.Append(SortSelect(tablePrimaryKeys));
return(ExecuteDataReader(sb.ToString()));
}
static void Main(string[] args)
{
var builder = new System.Text.StringBuilder("Hello World");
builder.Append('-', 10);
builder.AppendLine();
builder.Append("Header");
builder.AppendLine();
builder.Append('-', 10);
// Or because Append returns type StringBuilder method can be chained together
//builder.Append('-', 10)
// .AppendLine()
// .Append("Header")
// .AppendLine()
// .Append('-', 10);
// The following methods can also be chained together as well.
builder.Replace('-', '+');
builder.Remove(0, 10);
builder.Insert(0, new string('-', 10));
Console.WriteLine(builder);
// Can access StringBuilder just like array or string
Console.WriteLine("First Char: " + builder[0]);
}
public DataSet Select(BOL.customers c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `customerid`, `firstname`, `lastname`, `status`, `email`,
`mobile`, `createdby`, `createdon`, `isdeleted`, `modifyby`, `modifyon` FROM `customers` WHERE ");
if (c.Customerid > 0)
{
qry.Append("`customerid` = " + c.Customerid + " AND");
}
if (!string.IsNullOrEmpty(c.Firstname))
{
qry.Append("`firstname` = '" + c.Firstname + "' AND");
}
if (!string.IsNullOrEmpty(c.Lastname))
{
qry.Append("`Lastname` = '" + c.Lastname + "' AND");
}
if (!string.IsNullOrEmpty(c.Mobile))
{
qry.Append("`Mobile` = '" + c.Mobile + "' AND");
}
else
{
qry.Append(" 1 AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public string GetUserScoroInfo()
{
System.Text.StringBuilder stringBuilder = new System.Text.StringBuilder();
System.Data.DataSet scoreRanking = FacadeManage.aideTreasureFacade.GetScoreRanking(10);
if (scoreRanking.Tables[0].Rows.Count > 0)
{
stringBuilder.Append("[");
foreach (System.Data.DataRow dataRow in scoreRanking.Tables[0].Rows)
{
stringBuilder.Append(string.Concat(new object[]
{
"{userName:'******',s:'",
dataRow["Score"],
"'},"
}));
}
stringBuilder.Remove(stringBuilder.Length - 1, 1);
stringBuilder.Append("]");
}
else
{
stringBuilder.Append("{}");
}
return(stringBuilder.ToString());
}
/// <summary>
/// 强键值对的数据转换为连接URL参数拼接参数格式
/// </summary>
/// <param name="func"></param>
/// <returns></returns>
public virtual string ToUrl(CheckUrlKeyCall func)
{
System.Text.StringBuilder strb = new System.Text.StringBuilder();
foreach (var d in this)
{
if (string.IsNullOrEmpty(d.Key))
{
continue;
}
if (string.IsNullOrEmpty(d.Value))
{
continue;
}
if (!func(d.Key))
{
continue;
}
strb.Append(string.Format("&{0}={1}", d.Key.Trim(), WebHelper.UrlEncode(d.Value.Trim())));
}
if (strb.Length > 0)
{
strb = strb.Remove(0, 1);
}
return(strb.ToString());
}
public DataSet Select(BOL.OwaisBOL c, MySqlConnection conn, MySqlTransaction trans)
{
if (c != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `idNumber`, `firstName`, `lastName`, `status`, `email` FROM `owais` WHERE ");
if (c.IdNumber > 0)
{
qry.Append("`idNumber` = " + c.IdNumber + " AND");
}
if (!string.IsNullOrEmpty(c.FirstName))
{
qry.Append("`firstName` = '" + c.FirstName + "' AND");
}
if (!string.IsNullOrEmpty(c.LastName))
{
qry.Append("`lastName` = '" + c.LastName + "' AND");
}
if (!string.IsNullOrEmpty(c.Email))
{
qry.Append("`email` = '" + c.Email + "' AND");
}
else
{
qry.Append(" 1 AND");
}
qry = qry.Remove(qry.Length - 3, 3);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
public DataSet Select(BOL.tickethistory obj, MySqlConnection conn, MySqlTransaction trans)
{
if (obj != null)
{
StringBuilder qry = new System.Text.StringBuilder();
qry.Append(@"SELECT `tickethistoryid`, `ticketid`, `userid`, `ticketstatusid`,`createdon` FROM `tickethistory` WHERE ");
if (obj.Tickethistoryid > 0)
{
qry.Append("`tickethistoryid` = " + obj.Tickethistoryid + " AND");
}
if (obj.Ticketid > 0)
{
qry.Append("`ticketid` = " + obj.Ticketid + " AND");
}
if (obj.Userid > 0)
{
qry.Append("`userid` = " + obj.Userid + " AND");
}
if (obj.Ticketstatusid > 0)
{
qry.Append("`ticketstatusid` = " + obj.Ticketstatusid + " AND");
}
qry = qry.Remove(qry.Length - 3, qry.Length);
return(dbconnect.GetDataset(conn, trans, qry.ToString()));
}
return(null);
}
/// <summary>
/// 递归将DataTable转化为适合jquery easy ui 控件tree ,combotree 的 json
/// 该方法最后还要 将结果稍微处理下,将最前面的,"children" 字符去掉.
/// </summary>
/// <param name="dt">要转化的表</param>
/// <param name="pField">表中的父节点字段</param>
/// <param name="pValue">表中顶层节点的值,没有 可以输入为0</param>
/// <param name="kField">关键字字段名称</param>
/// <param name="TextField">要显示的文本 对应的字段</param>
/// <returns></returns>
public static string TableToEasyUITreeJson(System.Data.DataTable dt, string pField, string pValue, string kField, string TextField)
{
System.Text.StringBuilder sb = new System.Text.StringBuilder();
string filter = String.Format(" {0}='{1}' ", pField, pValue);//获取顶级目录.
System.Data.DataRow[] drs = dt.Select(filter);
if (drs.Length < 1)
{
return("");
}
sb.Append(",\"children\":[");
foreach (System.Data.DataRow dr in drs)
{
string pcv = dr[kField].ToString();
sb.Append("{");
sb.AppendFormat("\"id\":\"{0}\",", dr[kField].ToString());
sb.AppendFormat("\"text\":\"{0}\"", dr[TextField].ToString());
sb.Append(TableToEasyUITreeJson(dt, pField, pcv, kField, TextField).TrimEnd(','));
sb.Append("},");
}
if (sb.ToString().EndsWith(","))
{
sb.Remove(sb.Length - 1, 1);
}
sb.Append("]");
return(sb.ToString());
}
public string RemoveVowels(string s)
{
var sb = new System.Text.StringBuilder(s);
var i = 0;
while (i < sb.Length)
{
if
(
sb[i] == 'a' ||
sb[i] == 'e' ||
sb[i] == 'i' ||
sb[i] == 'o' ||
sb[i] == 'u'
)
{
sb.Remove(i, 1);
}
else
{
i++;
}
}
return(sb.ToString());
}