public IList <PNK_UploadImage> GetList(string id, string productid, string publish, int pageIndex, int pageSize, out int total)
{
IList <PNK_UploadImage> lst = new List <PNK_UploadImage>();
DGCParameter[] param = new DGCParameter[5];
total = 0;
if (!string.IsNullOrEmpty(id))
{
param[0] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, id);
}
else
{
param[0] = new DGCParameter(string.Format("{0}id", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[1] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[1] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[3] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[3] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(productid))
{
param[4] = new DGCParameter(string.Format("{0}productid", prefixParam), DbType.String, productid);
}
else
{
param[4] = new DGCParameter(string.Format("{0}productid", prefixParam), DbType.String, DBNull.Value);
}
lst = dal.GetList("UploadImage_Get", param, out total);
return(lst);
}
public IList <PNK_BookingPrice> GetList(int productId, out int total)
{
IList <PNK_BookingPrice> lst = new List <PNK_BookingPrice>();
DGCParameter[] param = new DGCParameter[1];
if (productId != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.Int32, productId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.Int32, DBNull.Value);
}
lst = dal.GetList("BookingPrice_Get", param, out total);
return(lst);
}
public IList <PNK_User> GetList(string username, string isnewsletter, int pageIndex, int pageSize, out int total)
{
IList <PNK_User> lst = new List <PNK_User>();
DGCParameter[] param = new DGCParameter[4];
if (!string.IsNullOrEmpty(username))
{
param[0] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, username);
}
else
{
param[0] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(isnewsletter))
{
param[1] = new DGCParameter(string.Format("{0}isnewsletter", prefixParam), DbType.String, isnewsletter);
}
else
{
param[1] = new DGCParameter(string.Format("{0}isnewsletter", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter("pageIndex", DbType.Int16, pageIndex);
}
else
{
param[2] = new DGCParameter("pageIndex", DbType.Int16, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter("pageSize", DbType.Int16, pageSize);
}
else
{
param[3] = new DGCParameter("pageSize", DbType.Int16, DBNull.Value);
}
lst = dal_2C.GetList("User_Get", param, out total);
return(lst);
}
public IList <PNK_Banner> GetList(int position, string name, string publish, string pageName, int pageIndex, int pageSize, out int total)
{
IList <PNK_Banner> lst = new List <PNK_Banner>();
DGCParameter[] param = new DGCParameter[6];
total = 0;
if (position != int.MinValue)
{
param[0] = new DGCParameter(string.Format("{0}position", prefixParam), DbType.Int32, position);
}
else
{
param[0] = new DGCParameter(string.Format("{0}position", prefixParam), DbType.Int32, DBNull.Value);
}
if (!string.IsNullOrEmpty(name))
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, name);
}
else
{
param[1] = new DGCParameter(string.Format("{0}name", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int16, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int16, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int16, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int16, DBNull.Value);
}
if (!string.IsNullOrEmpty(publish))
{
param[4] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, publish);
}
else
{
param[4] = new DGCParameter(string.Format("{0}published", prefixParam), DbType.AnsiString, DBNull.Value);
}
if (!string.IsNullOrEmpty(pageName))
{
param[5] = new DGCParameter(string.Format("{0}pageName", prefixParam), DbType.AnsiString, pageName);
}
else
{
param[5] = new DGCParameter(string.Format("{0}pageName", prefixParam), DbType.AnsiString, DBNull.Value);
}
//ConfigSection cfs = new ConfigSection();
//string key = WebUtils.GetCacheKey(new string[] { position + name + publish + pageIndex + pageSize, "PNK_Configuration" });
//if (cfs.EnableCaching && WebUtils.Cache[key] != null)
//{
// lst = (List<PNK_Banner>)WebUtils.Cache[key];
//}
//else
//{
lst = dal.GetList("Banner_Get", param, out total);
//WebUtils.CacheData(key, lst);
//}
return(lst);
}
public IList <PNK_SalesPrice> GetList(string productId, string storeGroup, DateTime fromDate, DateTime toDate, int pageIndex, int pageSize, out int total)
{
IList <PNK_SalesPrice> lst = new List <PNK_SalesPrice>();
DGCParameter[] param = new DGCParameter[6];
if (!string.IsNullOrEmpty(productId))
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.String, productId);
}
else
{
param[0] = new DGCParameter(string.Format("{0}productId", prefixParam), DbType.String, DBNull.Value);
}
if (!string.IsNullOrEmpty(storeGroup))
{
param[1] = new DGCParameter(string.Format("{0}storeGroup", prefixParam), DbType.String, storeGroup);
}
else
{
param[1] = new DGCParameter(string.Format("{0}storeGroup", prefixParam), DbType.String, DBNull.Value);
}
if (pageIndex != int.MinValue)
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, pageIndex);
}
else
{
param[2] = new DGCParameter(string.Format("{0}pageIndex", prefixParam), DbType.Int32, DBNull.Value);
}
if (pageSize != int.MinValue)
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, pageSize);
}
else
{
param[3] = new DGCParameter(string.Format("{0}pageSize", prefixParam), DbType.Int32, DBNull.Value);
}
if (fromDate != DateTime.MinValue)
{
param[4] = new DGCParameter(string.Format("{0}fromDate", prefixParam), DbType.DateTime, fromDate);
}
else
{
param[4] = new DGCParameter(string.Format("{0}fromDate", prefixParam), DbType.DateTime, DBNull.Value);
}
if (toDate != DateTime.MinValue)
{
param[5] = new DGCParameter(string.Format("{0}toDate", prefixParam), DbType.DateTime, toDate);
}
else
{
param[5] = new DGCParameter(string.Format("{0}toDate", prefixParam), DbType.DateTime, DBNull.Value);
}
lst = dal.GetList("SalePrice_Get", param, out total);
return(lst);
}
