public async Task <_Tablename_DeleteManyQueryDTO> Handle(_Tablename_DeleteManyQuery request, CancellationToken cancellationToken)
{
SqlTranExtensions STE = new SqlTranExtensions();
foreach (var id in request.ids)
{
var item = await _Tablename_.GetModel(id);
await item.Delete(STE);
}
if (await STE.ExecuteSqlTran())
{
return(new _Tablename_DeleteManyQueryDTO()
{
ids = request.ids
});
}
else
{
throw new MyException("删除出错");
}
}
public async Task <_tablename_ResetOrderNumQueryDTO> Handle(_tablename_ResetOrderNumQuery request, CancellationToken cancellationToken)
{
SqlTranExtensions STE = new SqlTranExtensions();
foreach (var id in request.ids)
{
var item = await _tablename_.GetModel(id);
item.ordernum = request.ordernum;
await item.Update(STE);
}
if (await STE.ExecuteSqlTran())
{
return(new _tablename_ResetOrderNumQueryDTO()
{
ids = request.ids
});
}
else
{
throw new MyException("保存出错");
}
}
/// <summary>
/// 添加一条记录,正常返回新增主键, 异常返回-1, 事务返回0
/// </summary>
/// <param name="model">model实例</param>
/// <param name="_SqlTranExtensions">事务机制对象</param>
/// <returns>返回新增int 自动增加的主键的记录号</returns>
public static int Add(object model, SqlTranExtensions _SqlTranExtensions)
{
ClearWebCache();
return((int)InvokeMethod("Add", new object[] { model, _SqlTranExtensions }));
}
/// <summary>
/// 更新记录
/// </summary>
/// <param name="model">实体</param>
/// <param name="_SqlTranExtensions">事务机制对象</param>
public static void Update(EntityObject model, SqlTranExtensions _SqlTranExtensions)
{
ClearWebCache();
InvokeMethod("Update", new object[] { model, _SqlTranExtensions });
}
/// <summary>
/// 根据条件删除记录
/// </summary>
/// <param name="where">删除条件</param>
/// <param name="objects">删除参数</param>
/// <param name="_SqlTranExtensions">事务机制对象</param>
public static void DeleteWhere(string where, object[] objects, SqlTranExtensions _SqlTranExtensions)
{
DeleteWhere(where, SQL.GetSQLParameter <EntityObject>(where, objects, typeof(EntityObject)).Re_SqlParameter(), _SqlTranExtensions);
}
/// <summary>
/// 根据条件删除记录
/// </summary>
/// <param name="where">删除条件</param>
/// <param name="cmdParms">删除参数</param>
/// <param name="_SqlTranExtensions">事务机制对象</param>
public static void DeleteWhere(string where, SqlParameter[] cmdParms, SqlTranExtensions _SqlTranExtensions)
{
ClearWebCache();
InvokeMethod("DeleteWhere", new object[] { SQL.DealSQL <EntityObject>(where), cmdParms, _SqlTranExtensions });
}
/// <summary>
/// 删除记录
/// </summary>
/// <param name="primaryKeyValue">主键值</param>
/// <param name="_SqlTranExtensions">事务机制对象</param>
public static void Delete(int?primaryKeyValue, SqlTranExtensions _SqlTranExtensions)
{
ClearWebCache();
InvokeMethod("Delete", new object[] { primaryKeyValue, _SqlTranExtensions });
}
