/// <summary>
/// 根据ID删除记录
/// </summary>
/// <param name="id">要删除的记录ID</param>
/// <returns></returns>
public int DeleteById(object id)
{
int ret = -1;
DeleteCondition con = new DeleteCondition(EntityInfo.DBInfo);
con.Tables.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatTableName(EntityInfo.TableName));
ParamList list = new ParamList();
ScopeList lstScope = new ScopeList();
PrimaryKeyInfo pkInfo = id as PrimaryKeyInfo;
if (pkInfo == null)
{
lstScope.AddEqual(EntityInfo.PrimaryProperty[0].PropertyName, id);
}
else
{
pkInfo.FillScope(EntityInfo.PrimaryProperty, lstScope, true);
}
con.Condition.Append("1=1");
con.Condition.Append(DataAccessCommon.FillCondition(EntityInfo, list, lstScope));
Dictionary <string, bool> cacheTables = null;
cacheTables = _oper.DBInfo.QueryCache.CreateMap(EntityInfo.TableName);
ret = ExecuteCommand(con.GetSql(true), list, CommandType.Text, cacheTables);
return(ret);
}
public void Delete(DeleteCondition deleteCondition)
{
List <Assignment> assignments = GetList();
for (int i = 0; i < assignments.Count; i++)
{
if (deleteCondition(assignments[i]))
{
assignments.RemoveAt(i);
}
}
SaveAll(assignments);
}
public HttpResponseMessage Delete(DeleteCondition dc)
{
DELETEDal.DeleteCondition dddc = new DELETEDal.DeleteCondition();
dddc.index = dc.index;
dddc.type = dc.type;
dddc.id = dc.id;
bool results = false;
if (dc.sign.Equals("confirm"))
{
results = _dal.DELETE(dddc);
}
string str = results.ToString();
HttpResponseMessage result = new HttpResponseMessage { Content = new StringContent(str, Encoding.GetEncoding("UTF-8"), "application/json") };
return result;
}
/// <summary>
/// 删除指定数据
/// </summary>
/// <param name="obj">要删除的实体</param>
/// <param name="scopeList">要删除的条件</param>
/// <param name="isConcurrency">是否版本并发删除</param>
/// <returns></returns>
public int Delete(EntityBase obj, ScopeList scopeList, bool isConcurrency)
{
DeleteCondition con = new DeleteCondition(EntityInfo.DBInfo);
con.Tables.Append(EntityInfo.DBInfo.CurrentDbAdapter.FormatTableName(EntityInfo.TableName));
ParamList list = new ParamList();
Type type = EntityInfo.EntityType;
con.Condition.Append("1=1");
if (obj != null)
{
if (scopeList == null)//通过ID删除
{
scopeList = new ScopeList();
foreach (EntityPropertyInfo info in EntityInfo.PrimaryProperty)
{
scopeList.AddEqual(info.PropertyName, info.GetValue(obj));
}
}
}
con.Condition.Append(DataAccessCommon.FillCondition(EntityInfo, list, scopeList));
if (isConcurrency)
{
int index = 0;
foreach (EntityPropertyInfo pInfo in EntityInfo.PropertyInfo)
{
if (pInfo.IsVersion)
{
FillWhereConcurrency(con.Condition, pInfo, list, pInfo.GetValue(obj), ref index);
}
}
}
Dictionary <string, bool> cacheTables = null;
cacheTables = _oper.DBInfo.QueryCache.CreateMap(EntityInfo.TableName);
int ret = -1;
ret = ExecuteCommand(con.GetSql(true), list, CommandType.Text, cacheTables);
return(ret);
}
public bool DELETE(DeleteCondition dc)
{
return ESHelper.Delete(dc.index,dc.type,dc.id);
}
