public void DeleteSelectedTableJoin(string strParms)
{
CollectionInvokeResult <TableJoin> tableJoinResult = new CollectionInvokeResult <TableJoin> {
Success = true
};
List <IBatisNetBatchStatement> tableJoinStatements = new List <IBatisNetBatchStatement>();
try
{
//InvokeResult invokeResultResult = new InvokeResult { Success = true };
//查询表关系Id进行删除操作
var dictionary = new StringObjectDictionary().MixInJson(strParms);
tableJoinResult.rows = BuilderFactory.DefaultBulder().List <TableJoin>(dictionary);
//得到id
for (int i = 0; i < tableJoinResult.rows.Count; i++)
{
string statementName = new TableJoin().GetDeleteMethodName();
TableJoinPK pk2 = new TableJoinPK {
Id = tableJoinResult.rows[i].Id
};
tableJoinStatements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = pk2, Type = SqlExecuteType.DELETE
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(tableJoinStatements);
}
catch (Exception ex)
{
tableJoinResult.Success = false;
tableJoinResult.ErrorMessage = ex.Message;
throw new Exception("删除表关系出错");
}
}
public InvokeResult NullifySelected(string strtableJoinIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrTableJoinIds = strtableJoinIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrTableJoinIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new TableJoin().GetUpdateMethodName();
foreach (string strtableJoinId in arrTableJoinIds)
{
TableJoin tableJoinInfo = new TableJoin {
Id = int.Parse(strtableJoinId), Status = 0
};
/***********************begin 自定义代码*******************/
TableJoinPK pk = new TableJoinPK {
Id = int.Parse(strtableJoinId)
};
DeleteCascade(statements, pk, "update");
tableJoinInfo.OperatedBy = NormalSession.UserId.ToGuid();
tableJoinInfo.OperatedOn = DateTime.Now;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = tableJoinInfo.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public ModelInvokeResult <TableJoinPK> Delete(string strtableJoinId)
{
ModelInvokeResult <TableJoinPK> result = new ModelInvokeResult <TableJoinPK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
int?_strtableJoinId = int.Parse(strtableJoinId);
if (_strtableJoinId == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
TableJoinPK pk = new TableJoinPK {
Id = _strtableJoinId
};
//DeleteCascade(statements, pk);
statements.Add(new IBatisNetBatchStatement {
StatementName = new TableJoin().GetDeleteMethodName(), ParameterObject = pk, Type = SqlExecuteType.DELETE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = new TableJoinPK {
};
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public InvokeResult DeleteSelected(string strtableJoinIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrTableJoinIds = strtableJoinIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrTableJoinIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new TableJoin().GetDeleteMethodName();
foreach (string strtableJoinId in arrTableJoinIds)
{
TableJoinPK pk = new TableJoinPK {
Id = int.Parse(strtableJoinId)
};
//DeleteCascade(statements, pk);
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = pk, Type = SqlExecuteType.DELETE
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
private void DeleteCascade(List <IBatisNetBatchStatement> statements, TableJoinPK pk, string type)
{
//此处增加级联删除代码
}
