public static void BindDDL_Cid(ListOptions options, DropDownList ddl, int cid, int pid, string separator)
{
int numResults = 0;
List<CategoryInfo> list = (new CCategory(LANG)).Getlist(cid, pid, options, out numResults);
if (list == null) return;
foreach (CategoryInfo info in list)
{
string sep = pid == 0 ? "" : separator + "---";
ListItem item = new ListItem(sep + info.Name, info.Id.ToString());
ddl.Items.Add(item);
BindDDL_Cid(options, ddl, cid, info.Id, sep);
}
}
public static void BindDDL_Cid_DDL(ListOptions options, DropDownList ddl, int cid, int pid, string separator)
{
options.SortExp = Queryparam.Sqlcolumn.Orderd;
options.GetAll = true;
List<CategoryInfo> list = (new CCategory(CCommon.LANG)).Wcmm_Getlist(cid, pid, options);
if (list == null) return;
foreach (CategoryInfo info in list)
{
string sep = pid == 0 ? "" : separator + "---";
ListItem item = new ListItem(sep + info.Name, info.Id.ToString());
ddl.Items.Add(item);
BindDDL_Cid_DDL(options, ddl, cid, info.Id, sep);
}
}
public ListOptions Get_ListOptions()
{
ListOptions options = new ListOptions();
options.PageIndex = PageIndex;
options.PageSize = PageSize;
options.SortExp = SortExp;
options.SortDir = SortDir.ToString();
UserInfo user = CCommon.Get_CurrentUser();
if (user != null)
{
options.Username = user.Username;
options.GetAll = CCommon.Right_sys();
}
return options;
}
public List<MemberInfo> Wcmm_Search(int grouptype, string keywords, ListOptions options, out int numResults)
{
try
{
List<MemberInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += grouptype == -1 ? "" : " AND A.grouptype=" + grouptype;
SQL += CFunctions.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
MemberInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<MemberInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Searchcount(iConn, grouptype, keywords, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private int Wcmm_Getlistcount(iSqlConnection iConn, int memberid, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += memberid == 0 ? "" : " AND A.memberid=" + memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
public List<MeCreditcardHistoryInfo> Wcmm_Search(int memberid, string keywords, ListOptions options, out int numResults)
{
try
{
List<MeCreditcardHistoryInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += memberid == 0 ? "" : " AND A.memberid=" + memberid;
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
CMember DALMem = new CMember(LANG);
while (dar.Read())
{
MeCreditcardHistoryInfo info = this.getDataReader(dar);
info.iMember = DALMem.Getinfo(info.Memberid);
if (arr == null)
arr = new List<MeCreditcardHistoryInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Searchcount(iConn, memberid, keywords, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private int Wcmm_Searchcount(iSqlConnection iConn, string Setof_Catalogue, string keywords, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += CFunctions.IsNullOrEmpty(Setof_Catalogue) ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
private int Searchcount(iSqlConnection iConn, string Setof_Catalogue, string keywords, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += CFunctions.IsNullOrEmpty(Setof_Catalogue) ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
private int Wcmm_Getlistcount(iSqlConnection iConn, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
public List<FileattachInfo> Getlist(int belongto, int iid, ListOptions options, out int numResults)
{
try
{
List<FileattachInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += " AND A.belongto=" + belongto;
SQL += " AND A.iid=" + iid;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
FileattachInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<FileattachInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Getlistcount(iConn, belongto, iid, options.Markas);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<FeedbackInfo> Wcmm_Getlist(int pid, ListOptions options, out int numResults)
{
try
{
List<FeedbackInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.pid=" + pid;
SQL += " AND A.pis=0";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
FeedbackInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<FeedbackInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Getlistcount(iConn, pid);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private int Getlistcount(iSqlConnection iConn, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
public List<CategoryInfo> Getlist(int cid, int pid, ListOptions options, out int numResults)
{
try
{
List<CategoryInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += cid == 0 ? "" : " AND A.cid=" + cid;
SQL += pid == -1 ? "" : " AND A.pid=" + pid;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
CategoryInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<CategoryInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Getlistcount(iConn, cid, pid);
if(arr != null)
{
foreach (var cate in arr)
{
if (cate.Pid == 61)
{
CNews news = new CNews("vn");
cate.dictCount = news.GetDictCount(iConn, cate.Id.ToString());
}
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private int Wcmm_Searchcount(iSqlConnection iConn, string categoryid, string Searchquery, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += CFunctions.IsNullOrEmpty(categoryid) ? "" : " AND A.id IN(SELECT iid FROM " + LANG + CConstants.TBDBPREFIX + "itemcategory WHERE categoryid IN(" + categoryid + ") AND belongto=" + Webcmm.Id.Video + ")";
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
private int Searchcount(iSqlConnection iConn, string categoryid, string Searchquery, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += CFunctions.IsNullOrEmpty(categoryid) ? "" : " AND A.id IN(SELECT iid FROM " + LANG + CConstants.TBDBPREFIX + "itemcategory WHERE categoryid IN(" + categoryid + ") AND belongto=" + Webcmm.Id.Video + ")";
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
public List<LibrariesInfo> Search(int cid, string keywords, ListOptions options, out int numResults)
{
try
{
List<LibrariesInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string Setof_Catalogue = cid == 0 ? "" : (new CCategory(LANG)).Get_setof(cid, "");
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += options.Markas == (int)CConstants.State.MarkAs.None ? "" : " AND A.markas=" + options.Markas;
SQL += cid == 0 ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
LibrariesInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<LibrariesInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Searchcount(iConn, Setof_Catalogue, keywords, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<LibrariesInfo> Wcmm_Getlist(int cid, ListOptions options, out int numResults)
{
try
{
List<LibrariesInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string Setof_Catalogue = cid == 0 ? "" : (new CCategory(LANG)).Get_setof(cid, "");
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += cid == 0 ? "" : " AND A.cid IN(" + Setof_Catalogue + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
LibrariesInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<LibrariesInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Getlistcount(iConn, Setof_Catalogue, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<GeneralInfo> Getlist_extend(int belongto, int aid, ListOptions options)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = "SELECT A.name, A.introduce, A.description, A.filepreview, A.cid, A.iconex, A.status, A.timeupdate, A.username, A.id, ROW_NUMBER() OVER(ORDER BY A." + options.SortExp + (options.SortDir == "Ascending" ? " ASC" : " DESC") + ") AS rownumber FROM " + TABLENAME + " AS A"
+ " INNER JOIN " + LANG + CConstants.TBDBPREFIX + "extenditem AS J ON J.iid=A.id";
SQL += belongto == 0 ? "" : " AND J.belongto=" + belongto;
SQL += aid == 0 ? "" : " AND J.aid=" + aid;
SQL += " WHERE A.id<>0 AND A.status<>" + (int)CConstants.State.Status.Deleted;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader_ext(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
dar.Close();
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<LibrariesInfo> Wcmm_Report(SearchInfo isearch, ListOptions options, out int numResults)
{
try
{
List<LibrariesInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
isearch.Setof_Category = isearch.Cid == 0 ? "" : (new CCategory(LANG)).Get_setof(isearch.Cid, "");
SQL += isearch.Cid == 0 ? "" : " AND A.cid IN(" + isearch.Setof_Category + ")";
isearch.Searchquery = CGeneral.Get_Searchquery(isearch.Keywords);
SQL += CFunctions.IsNullOrEmpty(isearch.Searchquery) ? "" : " AND (" + isearch.Searchquery + ")";
SQL += " AND (A.timeupdate BETWEEN '" + isearch.Datefr + "' AND '" + isearch.Dateto + "')";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
LibrariesInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<LibrariesInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Reportcount(iConn, isearch, options);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<GeneralInfo> Search(int belongto, string belongtoname, string categoryid, string keywords, ListOptions options, out int numResults)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING_SEARCH.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += CFunctions.IsNullOrEmpty(categoryid) || categoryid=="0" ? "" : " AND A.id IN(SELECT iid FROM " + LANG + CConstants.TBDBPREFIX + "itemcategory WHERE categoryid IN(" + categoryid + ") AND belongto=" + belongto + ")";
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += CFunctions.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader_search(dar);
info.Belongto = belongto;
info.Belongtoname = belongtoname;
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
}
numResults = this.Searchcount(iConn, belongto, categoryid, Searchquery);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private int Wcmm_Reportcount(iSqlConnection iConn, SearchInfo isearch, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += CFunctions.IsNullOrEmpty(isearch.Setof_Category) ? "" : " AND A.cid IN(" + isearch.Setof_Category + ")";
SQL += string.IsNullOrEmpty(isearch.Searchquery) ? "" : " AND (" + isearch.Searchquery + ")";
SQL += " AND (A.timeupdate BETWEEN '" + isearch.Datefr + "' AND '" + isearch.Dateto + "')";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
public List<GeneralInfo> Wcmm_Getlist(int cid, int pid, ListOptions options)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += " AND A.pid=" + pid;
if (pid == 0)
SQL += cid == 0 ? "" : " AND A.cid IN(" + (new CCategory(LANG)).Get_setof(cid, "") + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<MeCreditcardHistoryInfo> Getlist(int memberid, ListOptions options, out int numResults)
{
try
{
List<MeCreditcardHistoryInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.memberid=@MEMBERID";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
while (dar.Read())
{
MeCreditcardHistoryInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<MeCreditcardHistoryInfo>();
arr.Add(info);
}
dar.Close();
}
numResults = this.Getlistcount(iConn, memberid);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<GeneralInfo> Wcmm_Getlist_buildmenu(int cid, ListOptions options)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += cid == 0 ? "" : " AND A.cid=" + cid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<CartInfo> GetinfofullCheckout(int memberid, ListOptions options)
{
if (memberid == 0) return null;
try
{
List<CartInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.memberid=@MEMBERID";
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += " AND A.checkout=1";
iSqlParameter[] parms = new iSqlParameter[]{
new iSqlParameter(PARM_MEMBERID, iSqlType.Field_tInterger),
};
int i = -1;
parms[++i].Value = memberid;
using (iSqlDataReader dar = HELPER.executeReader(iConn, iCommandType.Text, SQL, parms))
{
while (dar.Read())
{
CartInfo info = this.getDataReader(dar);
info.lCartitem = (new CCartitem(LANG)).Getlistfull(info.Id);
if (arr == null)
arr = new List<CartInfo>();
arr.Add(info);
}
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
public List<GeneralInfo> Wcmm_Getlist_com(int status, ListOptions options, out int numResults)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING_COM.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
SQL += status == (int)CConstants.State.Status.None ? "" : " AND A.status=" + status;
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader_com(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
}
numResults = this.Wcmm_Getlistcount_com(iConn, status);
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private int Wcmm_Searchcount(iSqlConnection iConn, int memberid, string keywords, ListOptions options)
{
try
{
int numResults = 0;
string SQL = SQL_COUNT.Replace(Queryparam.Varstring.VAR_TABLENAME, TABLENAME);
SQL += memberid == 0 ? "" : " AND A.memberid=" + memberid;
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += string.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
if (dar.Read())
{
numResults = dar.IsDBNull(0) ? 0 : dar.GetInt32(0);
}
}
return numResults;
}
catch
{
return 0;
}
}
public List<GeneralInfo> Wcmm_Search_extend(string keywords, int belongto, int aid, ListOptions options)
{
try
{
List<GeneralInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = "SELECT A.name, A.status, A.timeupdate, A.username, A.id, ROW_NUMBER() OVER(ORDER BY A." + options.SortExp + (options.SortDir == "Ascending" ? " ASC" : " DESC") + ") AS rownumber FROM " + TABLENAME + " AS A"
+ " INNER JOIN " + LANG + CConstants.TBDBPREFIX + "extenditem AS J ON J.iid=A.id";
SQL += belongto == 0 ? "" : " AND J.belongto=" + belongto;
SQL += aid == 0 ? "" : " AND J.aid=" + aid;
SQL += " WHERE A.id<>0 AND A.status<>" + (int)CConstants.State.Status.Deleted;
SQL += CFunctions.Expression_GetPermit(options.GetAll, options.Username);
string Searchquery = CGeneral.Get_Searchquery(keywords);
SQL += CFunctions.IsNullOrEmpty(Searchquery) ? "" : " AND (" + Searchquery + ")";
SQL = "SELECT * FROM(" + SQL + ") AS T WHERE id<>0 " + CFunctions.Expression_GetLimit(options.PageIndex, options.PageSize);
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
GeneralInfo info = this.getDataReader_com(dar);
if (arr == null)
arr = new List<GeneralInfo>();
arr.Add(info);
}
dar.Close();
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
private ListOptions Get_ListOptionsMenu()
{
ListOptions options = new ListOptions();
options.SortExp = Queryparam.Sqlcolumn.Orderd;
options.SortDir = SortDirection.Descending.ToString();
options.GetAll = true;
return options;
}
public List<LibrariesInfo> Getlistrelated(string relateditem, ListOptions options)
{
if (CFunctions.IsNullOrEmpty(relateditem)) return null;
try
{
List<LibrariesInfo> arr = null;
using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM))
{
string SQL = SQL_GETIFOPAGING.Replace(Queryparam.Varstring.VAR_SORTEXPRESSION, CFunctions.Expression_GetSort(options.SortExp, options.SortDir));
SQL += " AND A.status<>" + (int)CConstants.State.Status.Waitactive;
SQL += " AND A.status<>" + (int)CConstants.State.Status.Disabled;
SQL += " AND A.id IN(" + relateditem + ")";
using (iSqlDataReader dar = HELPER.executeReader(iConn, SQL))
{
while (dar.Read())
{
LibrariesInfo info = this.getDataReader(dar);
if (arr == null)
arr = new List<LibrariesInfo>();
arr.Add(info);
}
dar.Close();
}
iConn.Close();
}
return arr;
}
catch (Exception ex)
{
throw ex;
}
}
