public InvokeResult NullifySelected(string strSetIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrResidentIds = strSetIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrResidentIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new Table().GetUpdateMethodName();
foreach (string strTableId in arrResidentIds)
{
Table TableInfo = new Table {
TableName = strTableId, Status = 0
};
/***********************begin 自定义代码*******************/
TablePK pk = new TablePK {
TableName = strTableId
};
//DeleteCascade(statements, pk, "update");//级联操作，暂未实现
TableInfo.OperatedBy = NormalSession.UserId.ToGuid();
TableInfo.OperatedOn = DateTime.Now;
//TableInfo.DataSource = GlobalManager.DIKey_00012_ManualEdit;
/***********************end 自定义代码*********************/
statements.Add(new IBatisNetBatchStatement {
StatementName = statementName, ParameterObject = TableInfo.ToStringObjectDictionary(false), Type = SqlExecuteType.UPDATE
});
}
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
public string DeleteSelectedTable(string strParms, int count)
{
CollectionInvokeResult <Column> strColumnResult = new CollectionInvokeResult <Column> {
Success = true
};
ModelInvokeResult <TablePK> result = new ModelInvokeResult <TablePK> {
Success = true
};
string str = null;
try
{
//查询表内数据是否等于1，是则删除操作
strColumnResult = Query(strParms);
if (strColumnResult.rows.Count == count)
{
string strTableId = strColumnResult.rows[0].TableName;
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string _TableName = strTableId;
TablePK pk = new TablePK {
TableName = _TableName
};
statements.Add(new IBatisNetBatchStatement {
StatementName = new Table().GetDeleteMethodName(), ParameterObject = pk, Type = SqlExecuteType.DELETE
});
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
str = _TableName;
}
return(str);
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
throw new Exception("删除公共表出错");
}
}
public InvokeResult DeleteSelected(string strSetIds)
{
InvokeResult result = new InvokeResult {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string[] arrResidentIds = strSetIds.Split("|".ToCharArray(), StringSplitOptions.RemoveEmptyEntries);
if (arrResidentIds.Length == 0)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
string statementName = new Table().GetDeleteMethodName();
foreach (string strTableId in arrResidentIds)
{
TablePK pk = new TablePK {
TableName = strTableId
};
//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);
}
public ModelInvokeResult <TablePK> Delete(string strTableId)
{
ModelInvokeResult <TablePK> result = new ModelInvokeResult <TablePK> {
Success = true
};
try
{
List <IBatisNetBatchStatement> statements = new List <IBatisNetBatchStatement>();
string _Id = strTableId;
if (_Id == null)
{
result.Success = false;
result.ErrorCode = 59996;
return(result);
}
TablePK pk = new TablePK {
TableName = _Id
};
//DeleteCascade(statements, pk);
statements.Add(new IBatisNetBatchStatement {
StatementName = new Table().GetDeleteMethodName(), ParameterObject = pk, Type = SqlExecuteType.DELETE
});
/***********************begin 自定义代码*******************/
/***********************此处添加自定义代码*****************/
/***********************end 自定义代码*********************/
BuilderFactory.DefaultBulder().ExecuteNativeSqlNoneQuery(statements);
result.instance = pk;
}
catch (Exception ex)
{
result.Success = false;
result.ErrorMessage = ex.Message;
}
return(result);
}
private void DeleteCascade(List <IBatisNetBatchStatement> statements, TablePK pk, string type)
{
//此处增加级联删除代码
}
