public List<CCardPopSale> get_CardPopSales(string state_str)
{
List<CCardPopSale> cardPopSales = new List<CCardPopSale>();
SqlConnection sqlCn = null;
string cmd_str = "";
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
cmd_str = "Select * from [CardPopSale]";
if (state_str != null && state_str != "")
cmd_str += "where (" + state_str + ")";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
var cardPopSale = new CCardPopSale();
cardPopSale.id = (int)dr["id"];
cardPopSale.mimMoney = ToInt(dr["mimMoney"]);
cardPopSale.saleMoney = ToInt(dr["saleMoney"]);
cardPopSales.Add(cardPopSale);
}
}
}
catch (System.Exception e)
{
IOUtil.insert_file(DateTime.Now.ToString() + "=" + cmd_str);
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return cardPopSales;
}
public CCardPopSale get_CardPopSale(string cmd_str)
{
CCardPopSale cardPopSale = null;
SqlConnection sqlCn = null;
try
{
sqlCn = new SqlConnection(_con_str);
sqlCn.Open();
//string cmd_str = "Select * from [Orders] where " + key + "='" + key_val.ToString() + "'";
SqlCommand cmdSelect = new SqlCommand(cmd_str, sqlCn);
using (SqlDataReader dr = cmdSelect.ExecuteReader())
{
while (dr.Read())
{
cardPopSale = new CCardPopSale();
cardPopSale.id = (int)dr["id"];
cardPopSale.mimMoney = ToInt(dr["mimMoney"]);
cardPopSale.saleMoney = ToInt(dr["saleMoney"]);
}
}
}
catch (System.Exception e)
{
BathClass.printErrorMsg(e.Message);
}
finally
{
close_connection(sqlCn);
}
return cardPopSale;
}