public static List <SimpleParameter> GetSim(T t)
{
PropertyInfo[] props = null;
try
{
Type type = typeof(T);
object obj = Activator.CreateInstance(type);
props = type.GetProperties(BindingFlags.Public | BindingFlags.Instance);
List <SimpleParameter> list = new List <SimpleParameter>();
foreach (PropertyInfo item in props)
{
if (!item.IsSpecialName)
{
if (item.GetValue(t, null) != null)
{
SimpleParameter s = new SimpleParameter();
s.Name = item.Name;
s.Value = item.GetValue(t, null);
list.Add(s);
}
}
}
return(list);
}
catch
{
return(null);
}
}
public static T SelectSingle(string tableName, string fields, SimpleParameter queryParams)
{
List <SimpleParameter> list = new List <SimpleParameter>();
list.Add(queryParams);
List <T> result = Select(tableName, fields, list, 1);
if (result != null && result.Count > 0)
{
return(result[0]);
}
return(default(T));
}
public static List <T> Select(string tableName, string fields, SimpleParameter queryParams, int topNum = -1)
{
List <T> result;
string whereStr = " where 1=1 ";
if (queryParams != null)
{
if (!string.IsNullOrEmpty(queryParams.Sql))
{
whereStr += queryParams.Sql;
}
else
{
whereStr += string.Format(" and {0}=@{1}", queryParams.Name, queryParams.Name);
}
}
string topStr = " top {0}";
if (topNum <= 0)
{
topStr = "";
}
else
{
topStr = string.Format(topStr, topNum);
}
string sql = string.Format("select {2} {0} from {1} {3}", fields, tableName, topStr, whereStr);
IDbCommand command = Context().Sql(sql);
if (queryParams != null)
{
if (string.IsNullOrEmpty(queryParams.Sql))
{
command.Parameter(queryParams.Name, queryParams.Value);
}
}
result = command.Query <T>();
return(result);
}
/// <summary>
/// count(*)语句
/// </summary>
/// <param name="tableName"></param>
/// <param name="queryParams"></param>
/// <param name="fileds">count(*)或者指定int列</param>
/// <returns></returns>
public static int SelectExecute(string tableName, string fileds, SimpleParameter queryParams)
{
string whereStr = "";
if (queryParams != null)
{
if (!string.IsNullOrEmpty(queryParams.Sql))
{
whereStr = string.Format(" where {0}=@{0} ", queryParams.Name);
}
else
{
whereStr = queryParams.Sql;
}
}
string sql = string.Format("select {2} from {1} {0}", whereStr, tableName, fileds);
IDbCommand command = Context().Sql(sql);
if (queryParams != null && !string.IsNullOrEmpty(queryParams.Sql))
{
command.Parameters(queryParams.Name, queryParams.Value);
}
return(command.QueryValue <int>());
}
public static int SelectExecute(string tableName, SimpleParameter queryParams)
{
return(SelectExecute(tableName, "count(*)", queryParams));
}
/// <summary>
/// 更新单项
/// </summary>
/// <param name="tableName"></param>
/// <param name="queryParme">queryParme.Name更新的列，queryParme.Value值，queryParme.Sql条件</param>
/// <returns></returns>
public static int Update(string tableName, SimpleParameter queryParme)
{
string sql = string.Format("update {0} set {1}={2} where {3}", tableName, queryParme.Name, queryParme.Value, queryParme.Sql);
return(Context().Sql(sql).Execute());
}