private static ArrayList GetIncomeAndPayout(string sql)
{
ArrayList list = new ArrayList();
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(sql))
{
if (reader.Read())
{
list.Add(reader[0]);
}
if (reader.NextResult() && reader.Read())
{
list.Add(reader[0]);
}
}
return(list);
}
public IList <StockItemInfo> GetListByStockId(int stockId)
{
IList <StockItemInfo> list = new List <StockItemInfo>();
string strSql = "SELECT P.ProductNum, P.ProductName, P.Unit, S.* FROM PE_StockItem s INNER JOIN PE_CommonProduct p ON s.productId = p.productId AND s.TableName = P.TableName WHERE StockId = @StockId ; SELECT P.PresentNum AS ProductNum, P.PresentName AS ProductName, P.Unit, S.* FROM PE_StockItem s INNER JOIN PE_Present P ON s.productId = P.PresentID AND ISNULL(s.TableName,'')= '' WHERE s.StockId = @StockId";
using (NullableDataReader reader = DBHelper.ExecuteReaderSql(strSql, new Parameters("@StockId", DbType.Int32, stockId)))
{
while (reader.Read())
{
list.Add(StockItemFromrdr(reader));
}
if (!reader.NextResult())
{
return(list);
}
while (reader.Read())
{
list.Add(StockItemFromrdr(reader));
}
}
return(list);
}
public IList <ComplainItemInfo> GetList(int startRowIndexId, int maxNumberRows, int searchType, int field, string keyword)
{
IList <ComplainItemInfo> list = new List <ComplainItemInfo>();
Database database = DatabaseFactory.CreateDatabase();
DbCommand storedProcCommand = database.GetStoredProcCommand("PR_Common_GetList");
database.AddInParameter(storedProcCommand, "@StartRows", DbType.Int32, startRowIndexId);
database.AddInParameter(storedProcCommand, "@PageSize", DbType.Int32, maxNumberRows);
database.AddInParameter(storedProcCommand, "@SortColumn", DbType.String, "S.ItemID");
database.AddInParameter(storedProcCommand, "@StrColumn", DbType.String, "S.*, C.ClientName AS ShortedForm");
database.AddInParameter(storedProcCommand, "@Sorts", DbType.String, "DESC");
database.AddInParameter(storedProcCommand, "@TableName", DbType.String, "PE_ComplainItem S INNER JOIN PE_Client C ON S.ClientID = C.ClientID");
database.AddOutParameter(storedProcCommand, "@Total", DbType.Int32, 10);
StringBuilder builder = new StringBuilder(0x100);
builder.Append("1 = 1");
if (string.IsNullOrEmpty(keyword))
{
switch (searchType)
{
case 0:
goto Label_01D7;
case 1:
builder.Append(" AND DATEDIFF(d, S.DateAndTime, GETDATE()) < 10");
goto Label_01D7;
case 2:
builder.Append(" AND DATEDIFF(d, S.DateAndTime, GETDATE()) < 30");
goto Label_01D7;
case 3:
builder.Append(" AND FirstReceiver LIKE '%" + DBHelper.FilterBadChar(PEContext.Current.Admin.AdminName) + "%'");
goto Label_01D7;
}
}
else
{
switch (field)
{
case 0:
builder.Append(" AND S.ClientID = " + DBHelper.ToNumber(keyword));
goto Label_01D7;
case 1:
builder.Append(" AND C.ClientName LIKE '%" + DBHelper.FilterBadChar(keyword) + "%'");
goto Label_01D7;
case 2:
builder.Append(" AND DATEDIFF(d, S.DateAndTime, '" + DBHelper.FilterBadChar(keyword) + "') = 0");
goto Label_01D7;
case 3:
builder.Append(" AND S.Defendant = '" + DBHelper.FilterBadChar(keyword) + "'");
goto Label_01D7;
case 0x63:
builder.Append(ComplexSearch(keyword));
goto Label_01D7;
}
}
Label_01D7:
database.AddInParameter(storedProcCommand, "@Filter", DbType.String, builder.ToString());
using (NullableDataReader reader = new NullableDataReader(database.ExecuteReader(storedProcCommand)))
{
while (reader.Read())
{
list.Add(ComplainFromDataReader(reader));
}
reader.NextResult();
}
this.m_Total = (int)database.GetParameterValue(storedProcCommand, "@Total");
return(list);
}
