public override TList <PaymentItem> Find(TransactionManager transactionManager, string whereClause, int start, int pageLength, out int count)
{
count = -1;
if (whereClause.IndexOf(";") > -1)
{
return(new TList <PaymentItem>());
}
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand command = StoredProcedureProvider.GetCommandWrapper(database, "dbo.PaymentItem_Find", this._useStoredProcedure);
bool flag = false;
if (whereClause.IndexOf(" OR ") > 0)
{
flag = true;
}
database.AddInParameter(command, "@SearchUsingOR", DbType.Boolean, flag);
database.AddInParameter(command, "@PaymentItemCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PaymentCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@CostCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PaymentType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ItemMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@Summary", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Remark", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@AllocateCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@OldItemMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@AlloType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@CostBudgetSetCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PBSType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PBSCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Description", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ContractCostCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ItemCash", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@MoneyType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ExchangeRate", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash0", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash1", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash2", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash3", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash4", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash5", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash6", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash7", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash8", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ItemCash9", DbType.Decimal, DBNull.Value);
whereClause = whereClause.Replace(" AND ", "|").Replace(" OR ", "|");
string[] textArray = whereClause.ToLower().Split(new char[] { '|' });
char[] trimChars = new char[] { '=' };
char[] chArray2 = new char[] { '\'' };
foreach (string text in textArray)
{
if (text.Trim().StartsWith("paymentitemcode ") || text.Trim().StartsWith("paymentitemcode="))
{
database.SetParameterValue(command, "@PaymentItemCode", text.Replace("paymentitemcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("paymentcode ") || text.Trim().StartsWith("paymentcode="))
{
database.SetParameterValue(command, "@PaymentCode", text.Replace("paymentcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("costcode ") || text.Trim().StartsWith("costcode="))
{
database.SetParameterValue(command, "@CostCode", text.Replace("costcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("paymenttype ") || text.Trim().StartsWith("paymenttype="))
{
database.SetParameterValue(command, "@PaymentType", text.Replace("paymenttype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemmoney ") || text.Trim().StartsWith("itemmoney="))
{
database.SetParameterValue(command, "@ItemMoney", text.Replace("itemmoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("summary ") || text.Trim().StartsWith("summary="))
{
database.SetParameterValue(command, "@Summary", text.Replace("summary", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("remark ") || text.Trim().StartsWith("remark="))
{
database.SetParameterValue(command, "@Remark", text.Replace("remark", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("allocatecode ") || text.Trim().StartsWith("allocatecode="))
{
database.SetParameterValue(command, "@AllocateCode", text.Replace("allocatecode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("olditemmoney ") || text.Trim().StartsWith("olditemmoney="))
{
database.SetParameterValue(command, "@OldItemMoney", text.Replace("olditemmoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("allotype ") || text.Trim().StartsWith("allotype="))
{
database.SetParameterValue(command, "@AlloType", text.Replace("allotype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("costbudgetsetcode ") || text.Trim().StartsWith("costbudgetsetcode="))
{
database.SetParameterValue(command, "@CostBudgetSetCode", text.Replace("costbudgetsetcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("pbstype ") || text.Trim().StartsWith("pbstype="))
{
database.SetParameterValue(command, "@PBSType", text.Replace("pbstype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("pbscode ") || text.Trim().StartsWith("pbscode="))
{
database.SetParameterValue(command, "@PBSCode", text.Replace("pbscode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("description ") || text.Trim().StartsWith("description="))
{
database.SetParameterValue(command, "@Description", text.Replace("description", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("contractcostcode ") || text.Trim().StartsWith("contractcostcode="))
{
database.SetParameterValue(command, "@ContractCostCode", text.Replace("contractcostcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash ") || text.Trim().StartsWith("itemcash="))
{
database.SetParameterValue(command, "@ItemCash", text.Replace("itemcash", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("moneytype ") || text.Trim().StartsWith("moneytype="))
{
database.SetParameterValue(command, "@MoneyType", text.Replace("moneytype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("exchangerate ") || text.Trim().StartsWith("exchangerate="))
{
database.SetParameterValue(command, "@ExchangeRate", text.Replace("exchangerate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash0 ") || text.Trim().StartsWith("itemcash0="))
{
database.SetParameterValue(command, "@ItemCash0", text.Replace("itemcash0", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash1 ") || text.Trim().StartsWith("itemcash1="))
{
database.SetParameterValue(command, "@ItemCash1", text.Replace("itemcash1", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash2 ") || text.Trim().StartsWith("itemcash2="))
{
database.SetParameterValue(command, "@ItemCash2", text.Replace("itemcash2", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash3 ") || text.Trim().StartsWith("itemcash3="))
{
database.SetParameterValue(command, "@ItemCash3", text.Replace("itemcash3", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash4 ") || text.Trim().StartsWith("itemcash4="))
{
database.SetParameterValue(command, "@ItemCash4", text.Replace("itemcash4", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash5 ") || text.Trim().StartsWith("itemcash5="))
{
database.SetParameterValue(command, "@ItemCash5", text.Replace("itemcash5", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash6 ") || text.Trim().StartsWith("itemcash6="))
{
database.SetParameterValue(command, "@ItemCash6", text.Replace("itemcash6", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash7 ") || text.Trim().StartsWith("itemcash7="))
{
database.SetParameterValue(command, "@ItemCash7", text.Replace("itemcash7", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("itemcash8 ") || text.Trim().StartsWith("itemcash8="))
{
database.SetParameterValue(command, "@ItemCash8", text.Replace("itemcash8", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else
{
if (!text.Trim().StartsWith("itemcash9 ") && !text.Trim().StartsWith("itemcash9="))
{
throw new ArgumentException("Unable to use this part of the where clause in this version of Find: " + text);
}
database.SetParameterValue(command, "@ItemCash9", text.Replace("itemcash9", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
}
IDataReader reader = null;
TList <PaymentItem> rows = new TList <PaymentItem>();
try
{
if (transactionManager != null)
{
reader = Utility.ExecuteReader(transactionManager, command);
}
else
{
reader = Utility.ExecuteReader(database, command);
}
PaymentItemProviderBaseCore.Fill(reader, rows, start, pageLength);
if (reader.NextResult() && reader.Read())
{
count = reader.GetInt32(0);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rows);
}
public override TList <ContractMaterial> Find(TransactionManager transactionManager, string whereClause, int start, int pageLength, out int count)
{
count = -1;
if (whereClause.IndexOf(";") > -1)
{
return(new TList <ContractMaterial>());
}
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand command = StoredProcedureProvider.GetCommandWrapper(database, "dbo.ContractMaterial_Find", this._useStoredProcedure);
bool flag = false;
if (whereClause.IndexOf(" OR ") > 0)
{
flag = true;
}
database.AddInParameter(command, "@SearchUsingOR", DbType.Boolean, flag);
database.AddInParameter(command, "@ContractMaterialCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ContractCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@MaterialCode", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@Qty", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@Price", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@Money", DbType.Decimal, DBNull.Value);
whereClause = whereClause.Replace(" AND ", "|").Replace(" OR ", "|");
string[] textArray = whereClause.ToLower().Split(new char[] { '|' });
char[] trimChars = new char[] { '=' };
char[] chArray2 = new char[] { '\'' };
foreach (string text in textArray)
{
if (text.Trim().StartsWith("contractmaterialcode ") || text.Trim().StartsWith("contractmaterialcode="))
{
database.SetParameterValue(command, "@ContractMaterialCode", text.Replace("contractmaterialcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("contractcode ") || text.Trim().StartsWith("contractcode="))
{
database.SetParameterValue(command, "@ContractCode", text.Replace("contractcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("materialcode ") || text.Trim().StartsWith("materialcode="))
{
database.SetParameterValue(command, "@MaterialCode", text.Replace("materialcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("qty ") || text.Trim().StartsWith("qty="))
{
database.SetParameterValue(command, "@Qty", text.Replace("qty", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("price ") || text.Trim().StartsWith("price="))
{
database.SetParameterValue(command, "@Price", text.Replace("price", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else
{
if (!text.Trim().StartsWith("money ") && !text.Trim().StartsWith("money="))
{
throw new ArgumentException("Unable to use this part of the where clause in this version of Find: " + text);
}
database.SetParameterValue(command, "@Money", text.Replace("money", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
}
IDataReader reader = null;
TList <ContractMaterial> rows = new TList <ContractMaterial>();
try
{
if (transactionManager != null)
{
reader = Utility.ExecuteReader(transactionManager, command);
}
else
{
reader = Utility.ExecuteReader(database, command);
}
ContractMaterialProviderBaseCore.Fill(reader, rows, start, pageLength);
if (reader.NextResult() && reader.Read())
{
count = reader.GetInt32(0);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rows);
}
public override TList <ContractChange> Find(TransactionManager transactionManager, string whereClause, int start, int pageLength, out int count)
{
count = -1;
if (whereClause.IndexOf(";") > -1)
{
return(new TList <ContractChange>());
}
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand command = StoredProcedureProvider.GetCommandWrapper(database, "dbo.ContractChange_Find", this._useStoredProcedure);
bool flag = false;
if (whereClause.IndexOf(" OR ") > 0)
{
flag = true;
}
database.AddInParameter(command, "@SearchUsingOR", DbType.Boolean, flag);
database.AddInParameter(command, "@ContractChangeCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ContractChangeId", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ContractCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Voucher", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Money", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ChangeMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@NewMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@OriginalMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@TotalChangeMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@SupplierChangeMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ConsultantAuditMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ProjectAuditMoney", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@ChangeReason", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Status", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@ChangePerson", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ChangeDate", DbType.DateTime, DBNull.Value);
database.AddInParameter(command, "@ChangeType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@CheckPerson", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@CheckDate", DbType.DateTime, DBNull.Value);
whereClause = whereClause.Replace(" AND ", "|").Replace(" OR ", "|");
string[] textArray = whereClause.ToLower().Split(new char[] { '|' });
char[] trimChars = new char[] { '=' };
char[] chArray2 = new char[] { '\'' };
foreach (string text in textArray)
{
if (text.Trim().StartsWith("contractchangecode ") || text.Trim().StartsWith("contractchangecode="))
{
database.SetParameterValue(command, "@ContractChangeCode", text.Replace("contractchangecode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("contractchangeid ") || text.Trim().StartsWith("contractchangeid="))
{
database.SetParameterValue(command, "@ContractChangeId", text.Replace("contractchangeid", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("contractcode ") || text.Trim().StartsWith("contractcode="))
{
database.SetParameterValue(command, "@ContractCode", text.Replace("contractcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("voucher ") || text.Trim().StartsWith("voucher="))
{
database.SetParameterValue(command, "@Voucher", text.Replace("voucher", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("money ") || text.Trim().StartsWith("money="))
{
database.SetParameterValue(command, "@Money", text.Replace("money", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("changemoney ") || text.Trim().StartsWith("changemoney="))
{
database.SetParameterValue(command, "@ChangeMoney", text.Replace("changemoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("newmoney ") || text.Trim().StartsWith("newmoney="))
{
database.SetParameterValue(command, "@NewMoney", text.Replace("newmoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("originalmoney ") || text.Trim().StartsWith("originalmoney="))
{
database.SetParameterValue(command, "@OriginalMoney", text.Replace("originalmoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("totalchangemoney ") || text.Trim().StartsWith("totalchangemoney="))
{
database.SetParameterValue(command, "@TotalChangeMoney", text.Replace("totalchangemoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("supplierchangemoney ") || text.Trim().StartsWith("supplierchangemoney="))
{
database.SetParameterValue(command, "@SupplierChangeMoney", text.Replace("supplierchangemoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("consultantauditmoney ") || text.Trim().StartsWith("consultantauditmoney="))
{
database.SetParameterValue(command, "@ConsultantAuditMoney", text.Replace("consultantauditmoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("projectauditmoney ") || text.Trim().StartsWith("projectauditmoney="))
{
database.SetParameterValue(command, "@ProjectAuditMoney", text.Replace("projectauditmoney", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("changereason ") || text.Trim().StartsWith("changereason="))
{
database.SetParameterValue(command, "@ChangeReason", text.Replace("changereason", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("status ") || text.Trim().StartsWith("status="))
{
database.SetParameterValue(command, "@Status", text.Replace("status", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("changeperson ") || text.Trim().StartsWith("changeperson="))
{
database.SetParameterValue(command, "@ChangePerson", text.Replace("changeperson", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("changedate ") || text.Trim().StartsWith("changedate="))
{
database.SetParameterValue(command, "@ChangeDate", text.Replace("changedate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("changetype ") || text.Trim().StartsWith("changetype="))
{
database.SetParameterValue(command, "@ChangeType", text.Replace("changetype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("checkperson ") || text.Trim().StartsWith("checkperson="))
{
database.SetParameterValue(command, "@CheckPerson", text.Replace("checkperson", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else
{
if (!text.Trim().StartsWith("checkdate ") && !text.Trim().StartsWith("checkdate="))
{
throw new ArgumentException("Unable to use this part of the where clause in this version of Find: " + text);
}
database.SetParameterValue(command, "@CheckDate", text.Replace("checkdate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
}
IDataReader reader = null;
TList <ContractChange> rows = new TList <ContractChange>();
try
{
if (transactionManager != null)
{
reader = Utility.ExecuteReader(transactionManager, command);
}
else
{
reader = Utility.ExecuteReader(database, command);
}
ContractChangeProviderBaseCore.Fill(reader, rows, start, pageLength);
if (reader.NextResult() && reader.Read())
{
count = reader.GetInt32(0);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rows);
}
public override TList <Trouble> Find(TransactionManager transactionManager, string whereClause, int start, int pageLength, out int count)
{
count = -1;
if (whereClause.IndexOf(";") > -1)
{
return(new TList <Trouble>());
}
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand command = StoredProcedureProvider.GetCommandWrapper(database, "dbo.Trouble_Find", this._useStoredProcedure);
bool flag = false;
if (whereClause.IndexOf(" OR ") > 0)
{
flag = true;
}
database.AddInParameter(command, "@SearchUsingOR", DbType.Boolean, flag);
database.AddInParameter(command, "@TroubleID", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@InspectSituationID", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@Requirement", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Suggestion", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ExecutionTime", DbType.DateTime, DBNull.Value);
database.AddInParameter(command, "@Place", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@TroubleCompendium", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Remark", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Status", DbType.Int32, DBNull.Value);
whereClause = whereClause.Replace(" AND ", "|").Replace(" OR ", "|");
string[] textArray = whereClause.ToLower().Split(new char[] { '|' });
char[] trimChars = new char[] { '=' };
char[] chArray2 = new char[] { '\'' };
foreach (string text in textArray)
{
if (text.Trim().StartsWith("troubleid ") || text.Trim().StartsWith("troubleid="))
{
database.SetParameterValue(command, "@TroubleID", text.Replace("troubleid", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("inspectsituationid ") || text.Trim().StartsWith("inspectsituationid="))
{
database.SetParameterValue(command, "@InspectSituationID", text.Replace("inspectsituationid", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("requirement ") || text.Trim().StartsWith("requirement="))
{
database.SetParameterValue(command, "@Requirement", text.Replace("requirement", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("suggestion ") || text.Trim().StartsWith("suggestion="))
{
database.SetParameterValue(command, "@Suggestion", text.Replace("suggestion", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("executiontime ") || text.Trim().StartsWith("executiontime="))
{
database.SetParameterValue(command, "@ExecutionTime", text.Replace("executiontime", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("place ") || text.Trim().StartsWith("place="))
{
database.SetParameterValue(command, "@place", text.Replace("place", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("troublecompendium ") || text.Trim().StartsWith("troublecompendium="))
{
database.SetParameterValue(command, "@TroubleCompendium", text.Replace("troublecompendium", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("remark ") || text.Trim().StartsWith("remark="))
{
database.SetParameterValue(command, "@Remark", text.Replace("remark", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else
{
if (!text.Trim().StartsWith("status ") && !text.Trim().StartsWith("status="))
{
throw new ArgumentException("Unable to use this part of the where clause in this version of Find: " + text);
}
database.SetParameterValue(command, "@Status", text.Replace("status", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
}
IDataReader reader = null;
TList <Trouble> rows = new TList <Trouble>();
try
{
if (transactionManager != null)
{
reader = Utility.ExecuteReader(transactionManager, command);
}
else
{
reader = Utility.ExecuteReader(database, command);
}
TroubleProviderBaseCore.Fill(reader, rows, start, pageLength);
if (reader.NextResult() && reader.Read())
{
count = reader.GetInt32(0);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rows);
}
public override TList <Payout> Find(TransactionManager transactionManager, string whereClause, int start, int pageLength, out int count)
{
count = -1;
if (whereClause.IndexOf(";") > -1)
{
return(new TList <Payout>());
}
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand command = StoredProcedureProvider.GetCommandWrapper(database, "dbo.Payout_Find", this._useStoredProcedure);
bool flag = false;
if (whereClause.IndexOf(" OR ") > 0)
{
flag = true;
}
database.AddInParameter(command, "@SearchUsingOR", DbType.Boolean, flag);
database.AddInParameter(command, "@PayoutCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PayoutID", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ProjectCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PaymentCodes", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PayoutDate", DbType.DateTime, DBNull.Value);
database.AddInParameter(command, "@PaymentType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Payer", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@SupplyCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@BillNo", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@InvoNo", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@BankName", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@BankAccount", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@SubjectCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Money", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@Status", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@InputPerson", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@InputDate", DbType.DateTime, DBNull.Value);
database.AddInParameter(command, "@CheckPerson", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@CheckDate", DbType.DateTime, DBNull.Value);
database.AddInParameter(command, "@CheckOpinion", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@SupplyName", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Remark", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ReceiptCount", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@GroupCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@IsApportioned", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@Cash", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@MoneyType", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ExchangeRate", DbType.Decimal, DBNull.Value);
database.AddInParameter(command, "@VoucherNo", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@SubjectSetCode", DbType.AnsiString, DBNull.Value);
whereClause = whereClause.Replace(" AND ", "|").Replace(" OR ", "|");
string[] textArray = whereClause.ToLower().Split(new char[] { '|' });
char[] trimChars = new char[] { '=' };
char[] chArray2 = new char[] { '\'' };
foreach (string text in textArray)
{
if (text.Trim().StartsWith("payoutcode ") || text.Trim().StartsWith("payoutcode="))
{
database.SetParameterValue(command, "@PayoutCode", text.Replace("payoutcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("payoutid ") || text.Trim().StartsWith("payoutid="))
{
database.SetParameterValue(command, "@PayoutID", text.Replace("payoutid", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("projectcode ") || text.Trim().StartsWith("projectcode="))
{
database.SetParameterValue(command, "@ProjectCode", text.Replace("projectcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("paymentcodes ") || text.Trim().StartsWith("paymentcodes="))
{
database.SetParameterValue(command, "@PaymentCodes", text.Replace("paymentcodes", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("payoutdate ") || text.Trim().StartsWith("payoutdate="))
{
database.SetParameterValue(command, "@PayoutDate", text.Replace("payoutdate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("paymenttype ") || text.Trim().StartsWith("paymenttype="))
{
database.SetParameterValue(command, "@PaymentType", text.Replace("paymenttype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("payer ") || text.Trim().StartsWith("payer="))
{
database.SetParameterValue(command, "@Payer", text.Replace("payer", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("supplycode ") || text.Trim().StartsWith("supplycode="))
{
database.SetParameterValue(command, "@SupplyCode", text.Replace("supplycode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("billno ") || text.Trim().StartsWith("billno="))
{
database.SetParameterValue(command, "@BillNo", text.Replace("billno", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("invono ") || text.Trim().StartsWith("invono="))
{
database.SetParameterValue(command, "@InvoNo", text.Replace("invono", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("bankname ") || text.Trim().StartsWith("bankname="))
{
database.SetParameterValue(command, "@BankName", text.Replace("bankname", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("bankaccount ") || text.Trim().StartsWith("bankaccount="))
{
database.SetParameterValue(command, "@BankAccount", text.Replace("bankaccount", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("subjectcode ") || text.Trim().StartsWith("subjectcode="))
{
database.SetParameterValue(command, "@SubjectCode", text.Replace("subjectcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("money ") || text.Trim().StartsWith("money="))
{
database.SetParameterValue(command, "@Money", text.Replace("money", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("status ") || text.Trim().StartsWith("status="))
{
database.SetParameterValue(command, "@Status", text.Replace("status", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("inputperson ") || text.Trim().StartsWith("inputperson="))
{
database.SetParameterValue(command, "@InputPerson", text.Replace("inputperson", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("inputdate ") || text.Trim().StartsWith("inputdate="))
{
database.SetParameterValue(command, "@InputDate", text.Replace("inputdate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("checkperson ") || text.Trim().StartsWith("checkperson="))
{
database.SetParameterValue(command, "@CheckPerson", text.Replace("checkperson", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("checkdate ") || text.Trim().StartsWith("checkdate="))
{
database.SetParameterValue(command, "@CheckDate", text.Replace("checkdate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("checkopinion ") || text.Trim().StartsWith("checkopinion="))
{
database.SetParameterValue(command, "@CheckOpinion", text.Replace("checkopinion", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("supplyname ") || text.Trim().StartsWith("supplyname="))
{
database.SetParameterValue(command, "@SupplyName", text.Replace("supplyname", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("remark ") || text.Trim().StartsWith("remark="))
{
database.SetParameterValue(command, "@Remark", text.Replace("remark", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("receiptcount ") || text.Trim().StartsWith("receiptcount="))
{
database.SetParameterValue(command, "@ReceiptCount", text.Replace("receiptcount", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("groupcode ") || text.Trim().StartsWith("groupcode="))
{
database.SetParameterValue(command, "@GroupCode", text.Replace("groupcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("isapportioned ") || text.Trim().StartsWith("isapportioned="))
{
database.SetParameterValue(command, "@IsApportioned", text.Replace("isapportioned", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("cash ") || text.Trim().StartsWith("cash="))
{
database.SetParameterValue(command, "@Cash", text.Replace("cash", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("moneytype ") || text.Trim().StartsWith("moneytype="))
{
database.SetParameterValue(command, "@MoneyType", text.Replace("moneytype", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("exchangerate ") || text.Trim().StartsWith("exchangerate="))
{
database.SetParameterValue(command, "@ExchangeRate", text.Replace("exchangerate", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("voucherno ") || text.Trim().StartsWith("voucherno="))
{
database.SetParameterValue(command, "@VoucherNo", text.Replace("voucherno", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else
{
if (!text.Trim().StartsWith("subjectsetcode ") && !text.Trim().StartsWith("subjectsetcode="))
{
throw new ArgumentException("Unable to use this part of the where clause in this version of Find: " + text);
}
database.SetParameterValue(command, "@SubjectSetCode", text.Replace("subjectsetcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
}
IDataReader reader = null;
TList <Payout> rows = new TList <Payout>();
try
{
if (transactionManager != null)
{
reader = Utility.ExecuteReader(transactionManager, command);
}
else
{
reader = Utility.ExecuteReader(database, command);
}
PayoutProviderBaseCore.Fill(reader, rows, start, pageLength);
if (reader.NextResult() && reader.Read())
{
count = reader.GetInt32(0);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rows);
}
public override TList <SystemUser> Find(TransactionManager transactionManager, string whereClause, int start, int pageLength, out int count)
{
count = -1;
if (whereClause.IndexOf(";") > -1)
{
return(new TList <SystemUser>());
}
SqlDatabase database = new SqlDatabase(this._connectionString);
DbCommand command = StoredProcedureProvider.GetCommandWrapper(database, "dbo.SystemUser_Find", this._useStoredProcedure);
bool flag = false;
if (whereClause.IndexOf(" OR ") > 0)
{
flag = true;
}
database.AddInParameter(command, "@SearchUsingOR", DbType.Boolean, flag);
database.AddInParameter(command, "@UserCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@UserID", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@UserName", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@OwnName", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@PassWord", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Sex", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Phone", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@MailBox", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Note", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@BirthDay", DbType.DateTime, DBNull.Value);
database.AddInParameter(command, "@PhoneHome", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Address", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Mobile", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Fax", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@Status", DbType.Int32, DBNull.Value);
database.AddInParameter(command, "@LastProjectCode", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@SortID", DbType.AnsiString, DBNull.Value);
database.AddInParameter(command, "@ShortUserName", DbType.AnsiString, DBNull.Value);
whereClause = whereClause.Replace(" AND ", "|").Replace(" OR ", "|");
string[] textArray = whereClause.ToLower().Split(new char[] { '|' });
char[] trimChars = new char[] { '=' };
char[] chArray2 = new char[] { '\'' };
foreach (string text in textArray)
{
if (text.Trim().StartsWith("usercode ") || text.Trim().StartsWith("usercode="))
{
database.SetParameterValue(command, "@UserCode", text.Replace("usercode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("userid ") || text.Trim().StartsWith("userid="))
{
database.SetParameterValue(command, "@UserID", text.Replace("userid", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("username ") || text.Trim().StartsWith("username="******"@UserName", text.Replace("username", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("ownname ") || text.Trim().StartsWith("ownname="))
{
database.SetParameterValue(command, "@OwnName", text.Replace("ownname", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("password ") || text.Trim().StartsWith("password="******"@PassWord", text.Replace("password", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("sex ") || text.Trim().StartsWith("sex="))
{
database.SetParameterValue(command, "@Sex", text.Replace("sex", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("phone ") || text.Trim().StartsWith("phone="))
{
database.SetParameterValue(command, "@Phone", text.Replace("phone", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("mailbox ") || text.Trim().StartsWith("mailbox="))
{
database.SetParameterValue(command, "@MailBox", text.Replace("mailbox", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("note ") || text.Trim().StartsWith("note="))
{
database.SetParameterValue(command, "@Note", text.Replace("note", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("birthday ") || text.Trim().StartsWith("birthday="))
{
database.SetParameterValue(command, "@BirthDay", text.Replace("birthday", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("phonehome ") || text.Trim().StartsWith("phonehome="))
{
database.SetParameterValue(command, "@PhoneHome", text.Replace("phonehome", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("address ") || text.Trim().StartsWith("address="))
{
database.SetParameterValue(command, "@Address", text.Replace("address", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("mobile ") || text.Trim().StartsWith("mobile="))
{
database.SetParameterValue(command, "@Mobile", text.Replace("mobile", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("fax ") || text.Trim().StartsWith("fax="))
{
database.SetParameterValue(command, "@Fax", text.Replace("fax", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("status ") || text.Trim().StartsWith("status="))
{
database.SetParameterValue(command, "@Status", text.Replace("status", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("lastprojectcode ") || text.Trim().StartsWith("lastprojectcode="))
{
database.SetParameterValue(command, "@LastProjectCode", text.Replace("lastprojectcode", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else if (text.Trim().StartsWith("sortid ") || text.Trim().StartsWith("sortid="))
{
database.SetParameterValue(command, "@SortID", text.Replace("sortid", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
else
{
if (!text.Trim().StartsWith("shortusername ") && !text.Trim().StartsWith("shortusername="******"Unable to use this part of the where clause in this version of Find: " + text);
}
database.SetParameterValue(command, "@ShortUserName", text.Replace("shortusername", "").Trim().TrimStart(trimChars).Trim().Trim(chArray2));
}
}
IDataReader reader = null;
TList <SystemUser> rows = new TList <SystemUser>();
try
{
if (transactionManager != null)
{
reader = Utility.ExecuteReader(transactionManager, command);
}
else
{
reader = Utility.ExecuteReader(database, command);
}
SystemUserProviderBaseCore.Fill(reader, rows, start, pageLength);
if (reader.NextResult() && reader.Read())
{
count = reader.GetInt32(0);
}
}
finally
{
if (reader != null)
{
reader.Close();
}
}
return(rows);
}
