public List<Customer> searchCusAll()
{
List<Customer> cusList = new List<Customer>();
string sqlStr = dbUtil.getSqlStatement("SQL_Cus_SearchAll");
DataSet searchResult = null;
try
{
searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, null);
foreach (DataTable dt in searchResult.Tables)
{
foreach (DataRow dr in dt.Rows)
{
Customer cus = new Customer();
cus.CustomId = dr["CusID"].ToString();
cus.Name = dr["CusName"].ToString();
cus.CompanyName = dr["CusCompName"].ToString();
cus.CusTypeId = dr["CusTypeID"].ToString();
cus.TelNum1 = dr["Tel1"].ToString();
cus.TelNum2 = dr["Tel2"].ToString();
cus.ZipCode = dr["ZipCode"].ToString();
cus.Address = dr["CusAddress"].ToString();
cus.RebateTypeId = dr["RebateTypeID"].ToString();
cusList.Add(cus);
}
}
}
catch (Exception ex)
{
throw;
}
return cusList;
}
public void Save(Customer cus)
{
}
public Customer getCustomer(string cusId)
{
Customer cus = new Customer();
try
{
cus = cusDAO.searchCusByCusId(cusId);
}
catch (Exception ex)
{
}
return cus;
}
public List<Customer> searchCusByMultiFilter(Hashtable hashTable)
{
List<Customer> cusList = new List<Customer>();
string sqlStr = dbUtil.getSqlStatement("SQL_Cus_SearchByMultiFilter");
ArrayList listParms = new ArrayList();
UtilService utilService = new UtilService();
if (hashTable.Contains("@CusID"))
{
sqlStr = utilService.validSearchFilter(sqlStr, "@CusID");
listParms.Add(new SqlParameter("@CusID", SqlDbType.VarChar, 20));
}
if (hashTable.Contains("@CusName"))
{
sqlStr = utilService.validSearchFilter(sqlStr, "@CusName");
listParms.Add(new SqlParameter("@CusName", SqlDbType.NVarChar, 100));
}
if (hashTable.Contains("@CusCompName"))
{
sqlStr = utilService.validSearchFilter(sqlStr, "@CusCompName");
listParms.Add(new SqlParameter("@CusCompName", SqlDbType.NVarChar, 100));
}
if (hashTable.Contains("@TelNum"))
{
sqlStr = utilService.validSearchFilter(sqlStr, "@TelNum");
listParms.Add(new SqlParameter("@TelNum", SqlDbType.VarChar, 20));
}
if (hashTable.Contains("@CusTypeID"))
{
sqlStr = utilService.validSearchFilter(sqlStr, "@CusTypeID");
listParms.Add(new SqlParameter("@CusTypeID", SqlDbType.VarChar, 20));
}
SqlParameter[] sqlParms = (SqlParameter[])listParms.ToArray(typeof(SqlParameter));
foreach (SqlParameter parm in sqlParms)
{
parm.Value = hashTable[parm.ParameterName];
}
DataSet searchResult = null;
try
{
searchResult = DAO.DBAccess.ExecuteAdapter(DAO.DBAccess.SQLConnectionString, CommandType.Text, sqlStr, sqlParms);
foreach (DataTable dt in searchResult.Tables)
{
foreach (DataRow dr in dt.Rows)
{
Customer cus = new Customer();
cus.CustomId = dr["CusID"].ToString();
cus.Name = dr["CusName"].ToString();
cus.CompanyName = dr["CusCompName"].ToString();
cus.CusTypeId = dr["CusTypeID"].ToString();
cus.TelNum1 = dr["Tel1"].ToString();
cus.TelNum2 = dr["Tel2"].ToString();
cus.ZipCode = dr["ZipCode"].ToString();
cus.Address = dr["CusAddress"].ToString();
cus.RebateTypeId = dr["RebateTypeID"].ToString();
cusList.Add(cus);
}
}
}
catch (Exception ex)
{
throw;
}
return cusList;
}
