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); }