public string GetUpdateSqlStatement <T>(object obj, MySearchUtil util = null)
{
try
{
var entity = MyContainer.Get(typeof(T));
var sql = MyEntityUtil.BuildUpdateSqlByAnonymous(entity, obj, util == null ? "" : util.GetConditionClaus());
return(sql);
}
catch
{
throw new Exception("指定类型未在MyContainer中注册");
}
}
public string GetInsertSqlStatement <T>(string[] columns, bool isExclude = false)
{
try
{
var entity = MyContainer.Get(typeof(T));
var sql = MyEntityUtil.BuildInsertSqlStatement(entity, columns, isExclude);
return(sql);
}
catch
{
throw new Exception("指定类型未在MyContainer中注册");
}
}
public string GetUpdateSqlStatement <T>(string[] columns, bool isExclude = false, MySearchUtil util = null)
{
try
{
var entity = MyContainer.Get(typeof(T));
var sql = MyEntityUtil.BuildUpdateSqlStatement(entity, columns, isExclude, util == null ? "" : util.GetConditionClaus());
return(sql);
}
catch
{
throw new Exception("指定类型未在MyContainer中注册");
}
}
/// <summary>
/// 更新实体列表，指定不需要更新的列
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="ts">要更新的实体列表</param>
/// <param name="exclude">不需要更新的列</param>
/// <returns></returns>
public int UpdateExclude <T>(List <T> ts, string[] exclude)
{
if (exclude.Length == 0)
{
throw new ArgumentException("必须指定要更新的列");
}
using (var conn = GetConnection())
{
var sql = MyContainer.Get(typeof(T)).GetUpdateSql(null, exclude, "default");
return(conn.Execute(sql, ts));
}
}
public string GetInsertSqlStatement <T>(object obj)
{
try
{
var entity = MyContainer.Get(typeof(T));
var sql = MyEntityUtil.BuildInsertSqlByAnonymous(entity, obj);
return(sql);
}
catch
{
throw new Exception("指定类型未在MyContainer中注册");
}
}
/// <summary>
/// 更新实体
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="t">要更新的实体</param>
/// <returns></returns>
public int Update <T>(T t)
{
if (t == null)
{
throw new ArgumentNullException("要修改的实体为空");
}
using (var conn = GetConnection())
{
string sql = MyContainer.Get(typeof(T)).UpdateSql;
return(conn.Execute(sql, t));
}
}
/// <summary>
/// 指定更新的列和值
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="kvs">要更新的列和值</param>
/// <param name="msu">要更新的数据条件</param>
/// <returns></returns>
public int Set <T>(KeyValuePairs kvs, MySearchUtil msu)
{
DynamicParameters param = new DynamicParameters();
List <string> props = new List <string>();
foreach (var kv in kvs)
{
props.Add(kv.Key);
param.Add(kv.Key, kv.Value);
}
var sql = MyContainer.Get(typeof(T)).GetUpdateSql(props.ToArray(), null, msu.ConditionClaus);
using (var conn = GetConnection())
{
return(conn.Execute(sql, param));
}
}
/// <summary>
/// 更新实体的指定列
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="t">要更新的实体</param>
/// <param name="include">要更新的列</param>
/// <returns></returns>
public int UpdateInclude <T>(T t, string[] include)
{
if (t == null)
{
throw new ArgumentNullException("要修改的实体为空");
}
if (include.Length == 0)
{
throw new ArgumentException("必须指定要更新的列");
}
using (var conn = GetConnection())
{
var sql = MyContainer.Get(typeof(T)).GetUpdateSql(include);
return(conn.Execute(sql, t));
}
}
public string GetTableName(Type type)
{
var entityInfo = MyContainer.Get(type);
return(entityInfo.TableName);
}
public string GetUpdateSql <T>()
{
return(MyContainer.Get(typeof(T))?.UpdateSql);
}
public string GetInsertSql <T>()
{
return(MyContainer.Get(typeof(T))?.InsertSql);
}
