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