protected virtual string FormatCommentOn(string sql) { StringBuilder result = new StringBuilder(60).Append(Indent1); IEnumerator<string> tokens = (new StringTokenizer(sql, " '[]\"", true)).GetEnumerator(); bool quoted = false; while (tokens.MoveNext()) { string token = tokens.Current; result.Append(token); if (IsQuote(token)) { quoted = !quoted; } else if (!quoted) { if ("is".Equals(token)) { result.Append(Indent2); } } } return result.ToString(); }
public string Replace (string str) { if (string.IsNullOrEmpty (str)) { return str; } System.Text.StringBuilder formatted = new System.Text.StringBuilder (); int lastMatch = 0; string variable; string replacement; foreach (System.Text.RegularExpressions.Match m in re.Matches(str)) { formatted.Append (str.Substring (lastMatch, m.Index - lastMatch)); variable = m.Groups [1].Value; if (vars.TryGetValue (variable, out replacement)) formatted.Append (this.Replace (replacement)); else throw new ObfuscarException("Unable to replace variable: " + variable); lastMatch = m.Index + m.Length; } formatted.Append (str.Substring (lastMatch)); return formatted.ToString (); }
/// <exception cref="MyException"></exception> public void Inserir(ICliente cliente, ILog log) { var sql = new StringBuilder(); var tblLog = new TblClientesLog(); sql.AppendFormat(" INSERT INTO {0} ({1},{2},{3}", tblLog.NomeTabela, tblLog.Clientes_Id, tblLog.Clientes_Nome, tblLog.Clientes_Status_Id); sql.AppendFormat(",{0},{1},{2})", tblLog.Usuarios_Id, tblLog.Operacao_Id, tblLog.DataHora); sql.Append(" VALUES (@id,@nome,@status_id"); sql.Append(",@usuarios_id,@operacao_id,@datahora);"); using (var dal = new DalHelperSqlServer()) { try { dal.CriarParametroDeEntrada("id", SqlDbType.Int, cliente.Id); dal.CriarParametroDeEntrada("nome", SqlDbType.Char, cliente.Nome); dal.CriarParametroDeEntrada("status_id", SqlDbType.SmallInt, cliente.Status.GetHashCode()); dal.CriarParametroDeEntrada("usuarios_id", SqlDbType.Int, log.Usuario.Id); dal.CriarParametroDeEntrada("operacao_id", SqlDbType.SmallInt, log.Operacao.GetHashCode()); dal.CriarParametroDeEntrada("datahora", SqlDbType.DateTime, log.DataHora); dal.ExecuteNonQuery(sql.ToString()); } catch (SqlException) { throw new MyException("Operação não realizada, por favor, tente novamente!"); } } }
protected void Page_Load(object sender, EventArgs e) { ReciboBE reciboBE; //if (Session["ReciboBE"] != null) //{ reciboBE = Session["ReciboBE"] as ReciboBE; //} CarregaProfissional(Convert.ToInt32(reciboBE.RefProfissionalBE.id)); lblReciboNumero.Text = Convert.ToString(reciboBE.id); lblValorTotalCabecalho.Text = String.Format("{0:C2}", reciboBE.ValorTotal); lblValorTotal.Text = String.Format("{0:C2}", reciboBE.ValorTotal); lblSessoesQtd.Text = Convert.ToString(reciboBE.RefReciboAgendamentoSessoesBE.Count.ToString("00")); lblPacienteNome.Text = Convert.ToString(reciboBE.PacienteNome); //Pego a possicao zero da lista de sessooes lblValorSessao.Text = String.Format("{0:C2}", reciboBE.RefReciboAgendamentoSessoesBE[0].Valor); StringBuilder sb = new System.Text.StringBuilder(); for (int i = 0; i < reciboBE.RefReciboAgendamentoSessoesBE.Count; i++) { if (i > 0) sb.Append(", "); sb.Append(reciboBE.RefReciboAgendamentoSessoesBE[i].Data.ToString("dd/MM/yyyy")); } lblDatas.Text = Convert.ToString(sb); DataExtenso(); }
public override void AsText(StringBuilder b, int pad) { b.Append(' ', pad); b.AppendLine("JewelerDataInitialMessage:"); b.Append(' ', pad++); b.Append(CrafterData.ToString()); }
internal override StringBuilder AsEsql(StringBuilder builder, bool isTopLevel, int indentLevel) { // The SELECT/DISTINCT part. StringUtil.IndentNewLine(builder, indentLevel); builder.Append("SELECT "); if (m_selectDistinct == CellQuery.SelectDistinct.Yes) { builder.Append("DISTINCT "); } GenerateProjectionEsql(builder, m_nodeTableAlias, true, indentLevel, isTopLevel); // Get the FROM part. builder.Append("FROM "); CqlWriter.AppendEscapedQualifiedName(builder, m_extent.EntityContainer.Name, m_extent.Name); builder.Append(" AS ").Append(m_nodeTableAlias); // Get the WHERE part only when the expression is not simply TRUE. if (!BoolExpression.EqualityComparer.Equals(WhereClause, BoolExpression.True)) { StringUtil.IndentNewLine(builder, indentLevel); builder.Append("WHERE "); WhereClause.AsEsql(builder, m_nodeTableAlias); } return builder; }
public static object MediaHelper(string image) { var sb = new StringBuilder(); sb.Append(ConfigurationManager.AppSettings["MediaPath"]); sb.Append(image); return new MvcHtmlString(sb.ToString()); }
protected virtual string FormatAlterTable(string sql) { StringBuilder result = new StringBuilder(60).Append(Indent1); IEnumerator<string> tokens = (new StringTokenizer(sql, " (,)'[]\"", true)).GetEnumerator(); bool quoted = false; while (tokens.MoveNext()) { string token = tokens.Current; if (IsQuote(token)) { quoted = !quoted; } else if (!quoted) { if (IsBreak(token)) { result.Append(Indent3); } } result.Append(token); } return result.ToString(); }
internal override StringBuilder AsNegatedUserString(StringBuilder builder, string blockAlias, bool skipIsNotNull) { builder.Append("NOT("); builder = AsUserString(builder, blockAlias, skipIsNotNull); builder.Append(")"); return builder; }
/// <summary> /// Gets the method body without definition and curly braces. /// </summary> public string GetMethodBody() { StringBuilder buffer = new StringBuilder(512); var signature = MethodSignature.GetIndexSignature(_index); buffer.AppendLine("using (var connection = GetReadOnlyConnection())"); buffer.AppendLine("{"); buffer.AppendLine("connection.Open();"); buffer.AppendFormat("return connection.Query<{0}>(\"SELECT * FROM {1} WHERE ", _index.Table.EntityName, _index.Table.FullName); buffer.Append(string.Join(" AND ", signature.Parameters.Select(p => p.Key + " = @" + p.Key))); buffer.Append("\", new { "); buffer.Append(string.Join(", ", signature.Parameters.Select(p => p.Key))); if (!_index.Unique) buffer.AppendLine(" });"); else buffer.AppendLine(" }).FirstOrDefault();"); buffer.AppendLine("}"); return buffer.ToString(); }
public static string ToCsv(this DataTable dataTable) { var sbData = new StringBuilder(); // Only return Null if there is no structure. if (dataTable.Columns.Count == 0) return null; foreach (var col in dataTable.Columns) { if (col == null) sbData.Append(","); else sbData.Append("\"" + col.ToString().Replace("\"", "\"\"") + "\","); } sbData.Replace(",", System.Environment.NewLine, sbData.Length - 1, 1); foreach (DataRow dr in dataTable.Rows) { foreach (var column in dr.ItemArray) { if (column == null) sbData.Append(","); else sbData.Append("\"" + column.ToString().Replace("\"", "\"\"") + "\","); } sbData.Replace(",", System.Environment.NewLine, sbData.Length - 1, 1); } return sbData.ToString(); }
public override string ToString() { if (invariant) { if (invariant_result) return "PivotsExpression.TrueExpression"; else return "PivotsExpression.FalseExpression"; } StringBuilder res = new StringBuilder(); bool first_combination = true; foreach (var combination in matching_combinations) { if (!first_combination) res.Append("|"); res.Append("("); bool first_value = true; foreach (var item in combination) { if (!first_value) res.Append(","); res.Append(item); first_value = false; } res.Append(")"); first_combination = false; } return res.ToString(); }
public override void Write(StringBuilder builder, int index) { if (index > 0) builder.Append('.'); builder.Append(property); }
public static string EvaluateRelativePath(string mainDirPath, string absoluteFilePath) { string first = mainDirPath.ToUpper().Substring(0, 2); if (first == "\\\\" || first != absoluteFilePath.ToUpper().Substring(0, 2)) return absoluteFilePath; if (mainDirPath[mainDirPath.Length - 1] != '\\') mainDirPath += "\\"; StringBuilder sb = new StringBuilder(); while (mainDirPath.Length > 0) { if (!absoluteFilePath.ToUpper().StartsWith(mainDirPath.ToUpper())) { sb.Append("..\\"); int i = mainDirPath.LastIndexOf("\\"); if (i == mainDirPath.Length - 1) { mainDirPath = mainDirPath.Remove(i, 1); i = mainDirPath.LastIndexOf("\\"); } mainDirPath = mainDirPath.Remove(i + 1, mainDirPath.Length - i - 1); } else { absoluteFilePath = absoluteFilePath.Remove(0, mainDirPath.Length); mainDirPath = ""; } } sb.Append(absoluteFilePath); return sb.ToString(); }
public string FormatHtml(object data) { const string keywordFormat = "<span style=\"color: #0000FF\">{0}</span>"; const string typeFormat = "<span style=\"color: #2B91AF\">{0}</span>"; var methodInfo = (MethodInfo)data; var sb = new StringBuilder(); var declaringType = methodInfo.DeclaringType; sb.AppendFormat("{0} {1}.{2} {{ ", string.Format(keywordFormat, "class"), declaringType.Namespace, string.Format(typeFormat, declaringType.Name)); AppendAccess(methodInfo, sb, keywordFormat); if (methodInfo.IsVirtual) { sb.AppendFormat(keywordFormat, "virtual"); sb.Append(" "); } AppendMethodName(methodInfo, sb); sb.Append(" (...)"); sb.Append("}}"); return sb.ToString(); }
private static string Get2000() { StringBuilder sql = new StringBuilder(); sql.Append("SELECT groupname as name, convert(int,groupid) AS [ID],is_default=convert(bit,status & 16),is_read_only=convert(bit,status & 8),'FG' as type "); sql.Append("FROM sysfilegroups ORDER BY groupname"); return sql.ToString(); }
/// <summary> /// Generates the VPS Signature from the parameters of the POST. /// </summary> public virtual string GenerateSignature(string securityKey, string vendorName) { var builder = new StringBuilder(); builder.Append(VPSTxId); builder.Append(VendorTxCode); builder.Append(Status.ToString().ToUpper()); builder.Append(TxAuthNo); builder.Append(vendorName.ToLower()); builder.Append(AVSCV2); builder.Append(securityKey); builder.Append(AddressResult); builder.Append(PostCodeResult); builder.Append(CV2Result); builder.Append(GiftAid); builder.Append(ThreeDSecureStatus); builder.Append(CAVV); builder.Append(AddressStatus); builder.Append(PayerStatus); builder.Append(CardType); builder.Append(Last4Digits); builder.Append(DeclineCode); builder.Append(ExpiryDate); builder.Append(FraudResponse); builder.Append(BankAuthCode); var hash = FormsAuthentication.HashPasswordForStoringInConfigFile(builder.ToString(), "MD5"); return hash; }
public void AddTableEle(TableEle tableEle, params string[] cols) { if (cols != null && cols.Length > 0) { StringBuilder th = new StringBuilder(""); ITableItemStrategy item = TableFactoryMethod.GetTableItem(tableEle); for (int i = 0; i < cols.Length; i++) { //### commented in order to render the cell regardless of null or empty string //if(!"".Equals(cols[i])){ th.Append("\n" + item.Middle.Replace("{value}", cols[i])); //} } if (!"".Equals(th.ToString())) { th.Insert(0, item.Top); th.Append(item.Bottom); } string finalResult = SetUpRepeatTableHeaderOnEveryPage(th); _txt.Append(finalResult); //final result appended } }
//public static void WriteErrFile(Exception es,string type) //{ // try // { // System.Text.StringBuilder sb = new System.Text.StringBuilder(""); // sb.Append("������Ϣ��"); // sb.Append(es.Message); // sb.Append("\n\r"); // sb.Append("����ԭ��"); // sb.Append(es.Source); // sb.Append("\n\r"); // sb.Append("����λ�ã�"); // sb.Append(es.StackTrace); // sb.Append("\n\r"); // sb.Append("���������"); // sb.Append(es.TargetSite); // sb.Append("\n\r"); // sb.Append("����ʱ�䣺"); // sb.Append(DateTime.Now); // sb.Append("\n\r"); // //string content = ""; // //FileStream aFile = new FileStream(Util.GetMapPath("~") + @"\errinfo.txt", FileMode.OpenOrCreate); // //StreamReader dd = new StreamReader(aFile); // //content = dd.ReadToEnd(); // StreamWriter sw = new StreamWriter(Utils.GetMapPath("~") + @"\errinfo.txt", true); // sw.Write(sb.ToString()); // sw.Flush(); // sw.Close(); // XYECOM. // string url = ""; // if (type == "user") // { // url = wci.WebURL +"user/errinfo."+wci.Suffix+"?"; // } // else if (type == "xyecom") // { // url = wci.WebURL + "xymanage/err.aspx?"; // } // else if (type == "index") // { // url = wci.WebURL + "page404." + wci.Suffix + "?"; // } // else if (type == "person") // { // url = wci.WebURL + "person/errinfo." + wci.Suffix + "?"; // } // //�Դ�����Դ�����ж� // if (es.Source.ToString().IndexOf(".Net SqlClient Data Provider") >= 0) // url += "key=002"; // else // url += "key=003"; // System.Web.HttpContext.Current.Response.Redirect(url,true ); // } // catch (Exception ex) // { // throw ex; // } //} public static void WriteErrFile(Exception es) { try { System.Text.StringBuilder sb = new System.Text.StringBuilder(""); sb.Append("������Ϣ��"); sb.Append(es.Message); sb.Append("\n\r"); sb.Append("����ԭ��"); sb.Append(es.Source); sb.Append("\n\r"); sb.Append("����λ�ã�"); sb.Append(es.StackTrace); sb.Append("\n\r"); sb.Append("���������"); sb.Append(es.TargetSite); sb.Append("\n\r"); sb.Append("����ʱ�䣺"); sb.Append(DateTime.Now); sb.Append("\n\r"); //string content = ""; //FileStream aFile = new FileStream(Util.GetMapPath("~") + @"\errinfo.txt", FileMode.OpenOrCreate); //StreamReader dd = new StreamReader(aFile); //content = dd.ReadToEnd(); StreamWriter sw = new StreamWriter(Utils.GetMapPath("~") + @"\errinfo.txt", true); sw.Write(sb.ToString()); sw.Flush(); sw.Close(); } catch (Exception ex) { throw ex; } }
private static string PascalCaseToElement(string input) { if (string.IsNullOrEmpty(input)) { return null; } var result = new StringBuilder(); result.Append(char.ToLowerInvariant(input[0])); for (var i = 1; i < input.Length; i++) { if (char.IsLower(input[i])) { result.Append(input[i]); } else { result.Append("_"); result.Append(char.ToLowerInvariant(input[i])); } } return result.ToString(); }
private static string Get2008() { StringBuilder sql = new StringBuilder(); sql.Append("SELECT name, data_space_id AS [ID], is_default, is_read_only, type "); sql.Append("FROM sys.filegroups ORDER BY name"); return sql.ToString(); }
public void CanReadCompleContent() { // Arrange var content = "This is"; var sb = new StringBuilder(); var sr = new StreamReader(content.ToStream()); var lab = new CharBuffer(() => { int read = sr.Read(); return read != -1 ? new char?((char)read) : new char?(); }, 3); // Act while (lab.HasNext()) { sb.Append(lab.PeekAt(0)); lab.Consume(); } sb.Append(lab.PeekAt(0)); // Assert sb.ToString().Should().Be(content); }
public static object MediaHelper(string image, int width, int height, bool forceFit) { var sb = new StringBuilder(); sb.Append(MediaHelper(image)); sb.Append(string.Format("?width={0}&height={1}&force={2}", width, height,forceFit)); return sb.ToString(); }
private static string GetFilesInFileGroup2000(FileGroup filegroup) { StringBuilder sql = new StringBuilder(); sql.Append("select convert(int,fileid) as file_id,type=convert(tinyint,(status&64)/64),name,filename as physical_name,size,maxsize as max_size,growth,convert(bit,0) as is_sparse,is_percent_growth =convert(bit,status & 1048576) "); sql.Append("FROM sysfiles where groupid="+filegroup.Id.ToString()); return sql.ToString(); }
private string Postfix(string prefix) { var result = new StringBuilder(prefix); result.Append(TileDirectionUtil.GetChar(Direction)); result.Append(TurnDirectionUtil.GetChar(Turn)); return result.ToString(); }
public static string BuildSql([NotNull] this IEnumerable<SearchCondition> conditions, bool surroundWithParathesis) { var sb = new StringBuilder(); conditions.ForEachFirst( (item, isFirst) => { sb.Append(" "); if (!isFirst) { sb.Append(item.ConditionType.GetStringValue()); sb.Append(" "); } if (surroundWithParathesis) { sb.AppendFormat("({0})", (object)item.Condition); } else { sb.Append((string)item.Condition); } }); return sb.ToString(); }
private static string GetFilesInFileGroup2008(FileGroup filegroup) { StringBuilder sql = new StringBuilder(); sql.Append("select file_id,type,name,physical_name,size,max_size,growth,is_sparse,is_percent_growth "); sql.Append("from sys.database_files WHERE data_space_id = " + filegroup.Id.ToString()); return sql.ToString(); }
/// <summary> /// Processes the specified arguments. /// </summary> /// <param name="args">The arguments.</param> public virtual void Process(PipelineArgs args) { Assert.ArgumentNotNull(args, "args"); ShoppingCart shoppingCart = Context.Entity.GetInstance<ShoppingCart>(); PaymentProvider paymentProvider = Context.Entity.Resolve<PaymentProvider>(shoppingCart.PaymentSystem.Code); PaymentUrlResolver paymentUrlResolver = new PaymentUrlResolver(); PaymentArgs paymentArgs = new PaymentArgs { ShoppingCart = shoppingCart, PaymentUrls = paymentUrlResolver.Resolve(), }; StringBuilder description = new StringBuilder(); foreach (ShoppingCartLine shoppingCartLine in shoppingCart.ShoppingCartLines) { description.Append(shoppingCartLine.Product.Title); description.Append(", "); } paymentArgs.Description = description.ToString().Trim().TrimEnd(','); paymentProvider.Invoke(shoppingCart.PaymentSystem, paymentArgs); args.AbortPipeline(); }
public string ReadNext(bool peek = false) { var isInQuote = false; var curToken = new StringBuilder(); int i; for (i = 0; i < _cmd.Length; i++) { if (isInQuote && _cmd[i] == '"' && i < _cmd.Length - 1 && _cmd[i + 1] == '"') { curToken.Append('"'); i++; continue; } if (isInQuote == false && _cmd[i] == '"') isInQuote = true; else if (isInQuote && _cmd[i] == '"') { i++; break; } else if (_cmd[i] == ' ' && isInQuote == false) break; else curToken.Append(_cmd[i]); } if (peek == false) { _cmd = _cmd.Substring(i); _cmd = _cmd.TrimStart(); } return curToken.ToString(); }
private static StringBuilder ParseRoute(IEnumerator<char> tokenizer, StringBuilder routePattern, IDictionary<string, string> routeParametersVsNamedGroup, IList<string> queryParameters) { char nextCharacterInRoute = tokenizer.Current; if (nextCharacterInRoute == '{') { tokenizer.MoveNext(); return ParseRouteParameter(tokenizer, routePattern, routeParametersVsNamedGroup, queryParameters); } else if (nextCharacterInRoute == '?') { routePattern.Append(Regex.Escape(nextCharacterInRoute.ToString(CultureInfo.InvariantCulture))); tokenizer.MoveNext(); return ParseQueryStringParameters(tokenizer, routePattern, queryParameters); } else { routePattern.Append(Regex.Escape(nextCharacterInRoute.ToString(CultureInfo.InvariantCulture))); if (tokenizer.MoveNext()) return ParseRoute(tokenizer, routePattern, routeParametersVsNamedGroup, queryParameters); else return routePattern; } }