/// <summary> /// 指定条件时给指定泛型及可变串追加指定字段及指定Int值 /// </summary> /// <param name="para">sql参数泛型</param> /// <param name="sqls">sql可变字段</param> /// <param name="field">字段名称</param> /// <param name="fieldvalue">字段值</param> public static void AddWhereIntSqlParameter(List <SqlParameter> para, StringBuilder sqls, string field, int fieldvalue) { if (ConvertHelper.CastInt(fieldvalue) > 0) { sqls.Append(string.Format("[{0}]=@{0} and ", field)); para.Add(new SqlParameter(string.Format("@{0}", field), fieldvalue)); } }
public void userList(HttpContext context) { try { int page = ConvertHelper.CastInt(context.Request["page"]); int rows = ConvertHelper.CastInt(context.Request["rows"]); string sortName = context.Request["sort"]; string sortOrder = context.Request["order"]; string strSort = ""; if (!string.IsNullOrEmpty(sortName) && !string.IsNullOrEmpty(sortOrder)) { strSort = sortName + " " + sortOrder; } string retnJson = JsonHelper1.GetJsonForEasyuiDatagrid(page, rows, "id", "", strSort, "Bus_User"); context.Response.Write(retnJson); } catch (Exception ex) { throw ex; } }
/// <summary> /// 增加赋值sql参数并返回 /// </summary> /// <param name="sqls">sql赋值可变对象</param> /// <param name="arguments">参数列表(格式:@name,@sex,@email......)</param> /// <param name="param">参数对应值</param> /// <returns></returns> public static List <SqlParameter> AddSqlParameters(ref StringBuilder sqls, string arguments, params object[] param) { string[] args = arguments.Split(','); if (args.Length == 0) { throw new ArgumentNullException("arguments", "参数个数为空!"); } if (args.Length != param.Length) { throw new ArgumentNullException("arguments", "参数个数与赋值参数个数不相等!"); } List <SqlParameter> para = new List <SqlParameter>(); for (int i = 0; i < args.Length; i++) { if (param[i] == null) { continue; } if (param[i] is int && ConvertHelper.CastInt(param[i]) == 0) { continue; } if (param[i] is string && string.IsNullOrEmpty(param[i].ToString())) { continue; } if (param[i] is DateTime && ConvertHelper.SafeCastDateTime(param[i]).Date == DateTime.MinValue.Date) { continue; } sqls.Append(string.Format("[{0}]={1},", args[i].TrimStart('@'), args[i])); para.Add(new SqlParameter(args[i], param[i])); } return(para); }