/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <param name="sb"></param>
protected override void BuildParameterName(object value, ref StringBuilder sb)
{
if (this.NeedParams && this.Provider != null)
{
ParamInfo p = this.Provider.BuildParamInfo(false, this._ParamList, value, this._CurrentMemberInfo, ref this._paramIndex);
if (p.DbType == System.Data.DbType.AnsiString && this._CurrentMemberType != typeof(string))
{
p.DbType = null;
}
this._ParamList.Add(p);
this._paramIndex++;
sb.Append(this.Provider.BuildSpecialName(p.Name));
}
else
{
if (value.GetType().IsStringType())
{
string text = TryParse.ToString(value);
sb.Append("'");
sb.Append(text);
sb.Append("'");
}
else
{
string text = TryParse.ToString(value);
sb.Append(text);
}
}
}
/// <summary>
/// yyyy-MM-dd -yyyyMMdd
/// </summary>
/// <param name="value">要转换的值</param>
/// <param name="DateTimeFormat">转换格式</param>
/// <returns></returns>
public static DateTime StrToDateByChar(object value, string DateTimeFormat)
{
if (string.IsNullOrEmpty(TryParse.ToString(value)))
{
return(DateTime.Today);
}
try
{
return(DateTime.ParseExact(TryParse.ToString(value), DateTimeFormat, System.Globalization.CultureInfo.CurrentCulture));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 将固定格式(yyyy-MM-dd) 得到日期格式 yyyyMMdd
/// </summary>
/// <param name="value"></param>
/// <returns></returns>
public static string StrToDateByChar(object value)
{
if (string.IsNullOrEmpty(TryParse.ToString(value)))
{
return("");
}
try
{
return(DateTime.ParseExact(TryParse.ToString(value), "yyyy-MM-dd", System.Globalization.CultureInfo.CurrentCulture).ToString("yyyyMMdd"));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <param name="sb"></param>
protected virtual void AdjustConstant(object value, ref StringBuilder sb)
{
Type type = value.GetType();
if (type.IsStringType())
{
if (type.IsBooleanType())
{
value = ((bool)value) ? 1 : 0;
this.BuildParameterName(value, ref sb);
}
else
{
if (type.GetUnderlyingType() == typeof(DateTime))
{
this.BuildParameterName(value, ref sb);
}
else
{
string text = TryParse.ToString(value);
value = this.FilterText(text);
if (this.LikeLeftFmt)
{
value = string.Format(this.Provider.LikeLeftFmt, value);
}
if (this.LikeRightFmt)
{
value = string.Format(this.Provider.LikeRightFmt, value);
}
this.BuildParameterName(value, ref sb);
}
}
}
else
{
this.BuildParameterName(value, ref sb);
}
}
/// <summary>
///
/// </summary>
/// <param name="value"></param>
/// <param name="sb"></param>
protected virtual void BuildParameterName(object value, ref StringBuilder sb)
{
string text = TryParse.ToString(value);
sb.Append(text);
}
