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); }