public string ToSqlText(DataParameterCollection dpc, DbDialect dd, List <string> queryRequiredFields) { var sb = new StringBuilder("SET "); foreach (var kv in this) { if (queryRequiredFields != null) { if (queryRequiredFields.Contains(kv.Key)) { continue; } } string dpStr; switch (kv.Operation) { case KvOpertation.None: if (DataSettings.UsingParameter) { dpStr = dd.QuoteParameter(string.Format("{0}_{1}", DataParameter.LegalKey(kv.Key), dpc.Count)); var dp = new DataParameter(dpStr, kv.Value, kv.ValueType); dpc.Add(dp); } else { dpStr = DataTypeParser.ParseToString(kv.Value, dd); } break; case KvOpertation.Now: dpStr = dd.DbNowString; break; case KvOpertation.Add: dpStr = dd.QuoteForColumnName(kv.Key) + "+(" + kv.Value + ")"; break; case KvOpertation.Sub: dpStr = dd.QuoteForColumnName(kv.Key) + "-(" + kv.Value + ")"; break; default: throw new ApplicationException("Application Error"); } sb.Append(dd.QuoteForColumnName(kv.Key)); sb.Append("="); sb.Append(dpStr); sb.Append(","); } try { return(StringHelper.GetStringLeft(sb.ToString())); } catch (ArgumentOutOfRangeException) { return(""); } }
public string ToSqlText(DataParameterCollection dpc, DbDialect dd, List <string> queryRequiredFields) { var sb1 = new StringBuilder(); var sb2 = new StringBuilder(); foreach (var kv in this) { if (queryRequiredFields != null) { if (queryRequiredFields.Contains(kv.Key)) { continue; } } string dpStr; switch (kv.Operation) { case KvOpertation.None: if (DataSettings.UsingParameter) { dpStr = dd.QuoteParameter(string.Format("{0}_{1}", DataParameter.LegalKey(kv.Key), dpc.Count)); var dp = new DataParameter(dpStr, kv.NullableValue, kv.ValueType); dpc.Add(dp); } else { dpStr = DataTypeParser.ParseToString(kv.Value, dd); } break; case KvOpertation.Now: dpStr = dd.DbNowString; break; case KvOpertation.Add: case KvOpertation.Sub: dpStr = "0"; break; default: throw new ApplicationException(); } sb1.Append(dd.QuoteForColumnName(kv.Key)); sb1.Append(","); sb2.Append(dpStr); sb2.Append(","); } return(string.Format(StatementTemplate, StringHelper.GetStringLeft(sb1.ToString()), StringHelper.GetStringLeft(sb2.ToString()))); }
protected virtual string GetValueString(DataParameterCollection dpc, DbDialect dd, KeyValue kv) { if (kv.Value == null) { return("NULL"); } string dpStr; if (ConfigReader.Config.Database.UseParameter) { dpStr = dd.QuoteParameter(string.Format("{0}_{1}", DataParameter.LegalKey(kv.Key), dpc.Count)); var dp = new DataParameter(dpStr, kv.NullableValue, kv.ValueType); dpc.Add(dp); } else { dpStr = DataTypeParser.ParseToString(kv.Value, dd); } return(dpStr); }