internal int DeleteTargetPlanDetailList(List <A_TargetPlanDetail> List)
{
StringBuilder sb = new StringBuilder();
int i = 0;
if (List.Count > 0)
{
List.ForEach(p =>
{
sb.Append(ORMapping.GetDeleteSql <A_TargetPlanDetail>(p, TSqlBuilder.Instance) + sqlSeperator);
});
if (sb.Length > 0)
{
using (TransactionScope scope = TransactionScopeFactory.Create())
{
i = ExecuteSql(sb.ToString());
scope.Complete();
}
}
return(i);
}
else
{
return(i);
}
}
/// <summary>
/// 批量删除
/// </summary>
/// <param name="dataList"></param>
/// <returns></returns>
public int DeleteList(List <T> dataList)
{
StringBuilder sqlBuilder = new StringBuilder();
int i = 0;
if (dataList.Count > 0)
{
foreach (T data in dataList)
{
sqlBuilder.Append(ORMapping.GetDeleteSql <T>(data, TSqlBuilder.Instance) + sqlSeperator);
if (sqlBuilder.Length > 7000)
{
i += ExecuteSql(sqlBuilder.ToString());
sqlBuilder.Clear();
}
}
if (sqlBuilder.Length > 0)
{
i += ExecuteSql(sqlBuilder.ToString());
}
}
return(i);
}
internal int DeleteModel(A_MonthlyReportDetail Model)
{
int i = 0;
string SQL = ORMapping.GetDeleteSql <A_MonthlyReportDetail>(Model, TSqlBuilder.Instance);
if (SQL.Length > 0)
{
i = ExecuteSql(SQL.ToString());
}
return(i);
}
internal int DeleteModel(A_SystemBatch Model)
{
int i = 0;
string SQL = ORMapping.GetDeleteSql <A_SystemBatch>(Model, TSqlBuilder.Instance);
if (SQL.Length > 0)
{
i = ExecuteSql(SQL.ToString());
}
return(i);
}
