///<summary></summary>
public static void DetachAllFromStatements(List <long> listStatementNums)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), listStatementNums);
return;
}
if (listStatementNums == null || listStatementNums.Count == 0)
{
return;
}
string command = DbHelper.WhereIn("DELETE FROM stmtlink WHERE StatementNum IN ({0})", false, listStatementNums.Select(x => POut.Long(x)).ToList());
Db.NonQ(command);
}
public static void DeleteAll(List <long> listStatementNums)
{
if (RemotingClient.RemotingRole == RemotingRole.ClientWeb)
{
Meth.GetVoid(MethodBase.GetCurrentMethod(), listStatementNums);
return;
}
if (listStatementNums == null || listStatementNums.Count == 0)
{
return;
}
//Removed all linked dependencies from these statements.
StmtLinks.DetachAllFromStatements(listStatementNums);
string command = DbHelper.WhereIn("UPDATE procedurelog SET StatementNum=0 WHERE StatementNum IN ({0})", false, listStatementNums.Select(x => POut.Long(x)).ToList());
Db.NonQ(command);
command = DbHelper.WhereIn("UPDATE adjustment SET StatementNum=0 WHERE StatementNum IN({0})", false, listStatementNums.Select(x => POut.Long(x)).ToList());
Db.NonQ(command);
command = DbHelper.WhereIn("UPDATE payplancharge SET StatementNum=0 WHERE StatementNum IN({0})", false, listStatementNums.Select(x => POut.Long(x)).ToList());
Db.NonQ(command);
command = DbHelper.WhereIn("DELETE FROM statement WHERE StatementNum IN ({0})", false, listStatementNums.Select(x => POut.Long(x)).ToList());
Db.NonQ(command);
}
