/// <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); }