public Component_data ComponentQuickSearchFromTo(string where, int from, int to)
{
Component_data ds = new Component_data();
try
{
//w_product_for_quick_search
string sqlselect = "";
int num_Row_Get = to - from;
sqlselect = "SELECT * FROM ( ";
sqlselect = sqlselect + "SELECT TOP " + num_Row_Get.ToString();
sqlselect = sqlselect + " * FROM( SELECT TOP " + to.ToString() + " Id,Name,Brand,UrlImage,SellingPrice,WarrantyMonth,Note FROM v_web_component_all " + where;
sqlselect = sqlselect + " order by SellingPrice asc) as t1 ";
sqlselect = sqlselect + " order by SellingPrice desc) as t2 ";
sqlselect = sqlselect + " order by SellingPrice asc ";
SqlConnection con = new SqlConnection(dataaccess.configsql.strcon);
SqlDataAdapter da = new SqlDataAdapter(sqlselect, con);
da.Fill(ds, Component_data._table);
con.Close();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(ds);
}
public Component_data ComponantGroupFromTo(int idtype, int idgroup, int from, int to)
{
Component_data ds = new Component_data();
try
{
string sqlselect = "";
int num_Row_Get = to - from;
sqlselect = "SELECT * FROM ( ";
sqlselect = sqlselect + "SELECT TOP " + num_Row_Get.ToString();
sqlselect = sqlselect + " * FROM( SELECT TOP " + to.ToString() + " Id,Name,Brand,UrlImage,SellingPrice,WarrantyMonth,Note FROM v_web_component_all where ProductTypeId=" + idtype + " and ComponentTypeId=" + idgroup + " and CanSales=1";
sqlselect = sqlselect + " order by SellingPrice asc) as t1 ";
sqlselect = sqlselect + " order by SellingPrice desc) as t2 ";
sqlselect = sqlselect + " order by SellingPrice asc ";
SqlConnection con = new SqlConnection(dataaccess.configsql.strcon);
SqlDataAdapter da = new SqlDataAdapter(sqlselect, con);
da.Fill(ds, Component_data._table);
con.Close();
}
catch (Exception ex)
{
Console.Write(ex.ToString());
}
return(ds);
}
public string ShowComGroup()
{
CdymanicViewCom ViewProduct;
int currentpage = 0;
int size = 20;
int idgroup = 0;
string nameGroup = "";
try
{
idgroup = int.Parse(Request.QueryString["id"].ToString());
currentpage = int.Parse(Request.QueryString["page"].ToString());
size = int.Parse(Request.QueryString["size"].ToString());
if (size > 40 || size < 10)
{
size = 20;
}
}
catch
{
}
if (Session["SSComponentGroup"] != null)
{
ViewProduct = (CdymanicViewCom)Session["SSComponentGroup"];
ViewProduct.SetPageSize(size);
if (idgroup != ViewProduct.GetIdGroup())
{
ViewProduct.setIdGroup(idgroup);
ViewProduct.SetNumComGroup();
}
if (currentpage > 0)
{
ViewProduct.SetCurrentPage(currentpage);
}
else
{
ViewProduct.SetCurrentPage();
}
}
else
{
ViewProduct = new CdymanicViewCom();
ViewProduct.SetIdType((int)Application["idtypeproduct"]);
ViewProduct.setIdGroup(idgroup);
ViewProduct.SetNumComGroup();
ViewProduct.SetPageSize(size);
if (currentpage > 0)
{
ViewProduct.SetCurrentPage(currentpage);
}
else
{
ViewProduct.SetCurrentPage();
}
Session["SSComponentGroup"] = ViewProduct;
}
nameGroup = ViewProduct.GetNameGroup();
if (nameGroup.Length > 0)
{
tCurrentAccess += " » " + nameGroup;
}
blpro = string.Format(blpro, "<u>" + ViewProduct.GetNumberRecord() + "</u>");
Component_data product = ViewProduct.ComponentGroupFromTo();
DataTable table = product.Tables[Component_data._table];
int numPro = table.Rows.Count;
Boolean iseven = true;
if (ViewProduct.GetPages() > 1)
{
strpage1 = CreatePage(idgroup, ViewProduct.GetCurrentPage(), ViewProduct.GetPages(), ViewProduct.GetPageSize(), 1);
strpage2 = CreatePage(idgroup, ViewProduct.GetCurrentPage(), ViewProduct.GetPages(), ViewProduct.GetPageSize(), 2);
}
else if (ViewProduct.GetPages() == 1)
{
strpage1 = ButtonCompare(true);
strpage2 = ButtonCompare(false);
}
string strProMain = "";
if (numPro > 0)
{
strProMain = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
strProMain += "<tr height='5'><td colspan='3'></td></tr>";
string id = "";
string name = "";
string url = "";
string price = "";
string warranty = "";
string brand = "";
string note = "";
for (int i = 0; i < numPro; i++)
{
id = table.Rows[i][Component_data._id].ToString();
name = table.Rows[i][Component_data._name].ToString();
url = table.Rows[i][Component_data._urlImage].ToString();
brand = table.Rows[i][Component_data._brand].ToString();
note = table.Rows[i][Component_data._note].ToString();
if (note.Length > 0)
{
note = note.Replace("\"", "''");
note = note.Replace('\r', ' ');
note = note.Replace('\n', ' ');
}
else
{
note = name;
}
if (url.Length > 0)
{
url = "image/img_com/" + url;
}
else
{
url = "image/common/notimgpro.png";
}
price = table.Rows[i][Component_data._sellingPrice].ToString();
warranty = table.Rows[i][Component_data._warrantyMonth].ToString();
if (iseven)
{
strProMain += "<tr><td width='272'>";
strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
strProMain += "<tr><td rowspan='2' width='100'><a href='?menu=dc&id=" + id + "'><img class='border_img' src='" + url + "'/></a></td>";
strProMain += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dc&id=" + id + "' onmouseover=\"ShowSpeccom('" + note + "',event);\" onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
strProMain += "<tr><td>" + tbrand + ": <span class='price'>" + brand + "</span><br />" + tprice + ": <span class='price'>" + price + " " + unitPrice + "</span><br />" + twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span></td>";
strProMain += "<td><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
strProMain += "<tr><td colspan='3' height='29' align='center'><div class='button3' onclick='AddCart(" + id + ",2);'>" + torder + "</div></td></tr>";
strProMain += "</table></td>";
iseven = false;
if (i + 1 == numPro)
{
strProMain += "<td class='bg_line4' width='11'></td>";
strProMain += "<td width='272'> </td>";
strProMain += "</tr>";
}
}
else
{
strProMain += "<td class='bg_line4' width='11'></td>";
strProMain += "<td width='272'>";
strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
strProMain += "<tr><td rowspan='2' width='100'><a href='?menu=dc&id=" + id + "'><img class='border_img' src='" + url + "'/></a></td>";
strProMain += "<td colspan='2' valign='top' class='text_title'><a href='?menu=dc&id=" + id + "' onmouseover=\"ShowSpeccom('" + note + "',event);\" onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
strProMain += "<tr><td>" + tbrand + ": <span class='price'>" + brand + "</span><br />" + tprice + ": <span class='price'>" + price + " " + unitPrice + "</span><br />" + twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span></td>";
strProMain += "<td><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
strProMain += "<tr><td colspan='3' height='29' align='center'><div class='button3' onclick='AddCart(" + id + ",2);'>" + torder + "</div></td></tr>";
strProMain += "</table></td></tr>";
if (i + 1 < numPro)
{
strProMain += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
}
iseven = true;
}
}
strProMain += "<tr height='5'><td colspan='3'></td></tr>";
strProMain += "</table>";
}
else
{
strProMain = "Không có sản phẩm nào.";
}
return(strProMain);
}
public string ShowProductSearch()
{
CdymanicViewCom ViewSearch;
int currentpage = 0;
int size = 20;
try
{
currentpage = int.Parse(Request.QueryString["page"].ToString());
size = int.Parse(Request.QueryString["size"].ToString());
if (size > 40 || size < 10)
{
size = 20;
}
}
catch
{
}
if (Session["SSQSComponent"] == null)
{
ViewSearch = new CdymanicViewCom();
ViewSearch.SetTextSearch(text);
ViewSearch.SetIdType((int)Application["idtypeproduct"]);
ViewSearch.BuildWhere();
ViewSearch.SetNumComQuickSearch();
ViewSearch.SetPageSize(size);
if (currentpage > 0)
{
ViewSearch.SetCurrentPage(currentpage);
}
else
{
ViewSearch.SetCurrentPage();
}
Session["SSQSComponent"] = ViewSearch;
}
else
{
ViewSearch = (CdymanicViewCom)Session["SSQSComponent"];
ViewSearch.SetPageSize(size);
if (!text.Equals(ViewSearch.GetTextSearch()))
{
ViewSearch.SetTextSearch(text);
ViewSearch.BuildWhere();
ViewSearch.SetNumComQuickSearch();
}
if (currentpage > 0)
{
ViewSearch.SetCurrentPage(currentpage);
}
else
{
ViewSearch.SetCurrentPage();
}
}
blpro = string.Format(blpro, "<u>" + ViewSearch.GetNumberRecord() + "</u>");
Component_data product = ViewSearch.ComponentQuickSearchFromTo();
DataTable table = product.Tables[Component_data._table];
int numPro = table.Rows.Count;
Boolean iseven = true;
if (ViewSearch.GetPages() > 1)
{
strpage1 = CreatePage(ViewSearch.GetCurrentPage(), ViewSearch.GetPages(), ViewSearch.GetPageSize(), 1);
strpage2 = CreatePage(ViewSearch.GetCurrentPage(), ViewSearch.GetPages(), ViewSearch.GetPageSize(), 2);
}
else if (ViewSearch.GetPages() == 1)
{
strpage1 = ButtonCompare(true);
strpage2 = ButtonCompare(false);
}
string strProMain = "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
strProMain += "<tr height='5'><td colspan='3'></td></tr>";
string id = "";
string name = "";
string url = "";
string price = "";
float rate = (float)Application["ratepromain"];
float price1 = 1;
string price2 = "";
string warranty = "";
string brand = "";
string note = "";
for (int i = 0; i < numPro; i++)
{
id = table.Rows[i][Component_data._id].ToString();
name = table.Rows[i][Component_data._name].ToString();
url = table.Rows[i][Component_data._urlImage].ToString();
brand = table.Rows[i][Component_data._brand].ToString();
note = table.Rows[i][Component_data._note].ToString();
string namepro = name;
namepro = namepro.Replace("/", "");
namepro = namepro.Replace("#", "");
namepro = namepro.Replace(":", "");
namepro = namepro.Replace("\"", "");
if (note.Length > 0)
{
note = note.Replace("\"", "");
note = note.Replace('\r', ' ');
note = note.Replace('\n', ' ');
}
else
{
note = name;
}
if (url.Length > 0)
{
url = "image/img_com/" + url;
}
else
{
url = "image/common/notimgpro.png";
}
price2 = table.Rows[i][Component_data._sellingPrice].ToString();
price1 = float.Parse(table.Rows[i][Component_data._sellingPrice].ToString());
price1 = price1 * rate;
price = price1.ToString("N").Split('.')[0];
warranty = table.Rows[i][Component_data._warrantyMonth].ToString();
if (iseven)
{
strProMain += "<tr><td width='272'>";
strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
strProMain += "<tr><td rowspan='2' width='100'><a href='" + namepro + "-dc-" + id + ".html'><img class='border_img' src='" + url + "'/></a></td>";
strProMain += "<td colspan='2' valign='top' class='text_title'><a href='" + namepro + "-dc-" + id + ".html' onmouseover=\"ShowSpeccom('" + note + "',event);\" onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
strProMain += "<tr><td height='70'>" + tbrand + ": <span class='price'>" + brand + "</span><br />";
strProMain += tprice + ": <span class='price'>";
if (price.Equals("0"))
{
strProMain += tupdate + "</span><br />";
}
else
{
if (unitPrice.Equals("$"))
{
strProMain += price + " VND</span><br />";
strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + "</span><br />";
}
else if (unitPrice.Equals("$$"))
{
strProMain += price + " VND</span><br />";
strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + " USD</span><br />";
}
else
{
strProMain += price + " " + unitPrice + "</span><br />";
}
strProMain += "<span class='tvat'>" + strMVAT + "</span><br />";
}
strProMain += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span></td>";
strProMain += "<td><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
//strProMain += "<tr><td colspan='3' height='32' align='center'><div class='button3' onclick='AddCart(" + id + ",2);'>" + torder + "</div></td></tr>";
strProMain += "</table></td>";
iseven = false;
if (i + 1 == numPro)
{
strProMain += "<td class='bg_line4' width='11'></td>";
strProMain += "<td width='272'> </td>";
strProMain += "</tr>";
}
}
else
{
strProMain += "<td class='bg_line4' width='11'></td>";
strProMain += "<td width='272'>";
strProMain += "<table cellpadding='0' cellspacing='0' border='0' width='100%'>";
strProMain += "<tr><td rowspan='2' width='100'><a href='" + namepro + "-dc-" + id + ".html'><img class='border_img' src='" + url + "'/></a></td>";
strProMain += "<td colspan='2' valign='top' class='text_title'><a href='" + namepro + "-dc-" + id + ".html' onmouseover=\"ShowSpeccom('" + note + "',event);\" onmouseout='OnMOut(event)'>" + name + "</a></td></tr>";
strProMain += "<tr><td height='70'>" + tbrand + ": <span class='price'>" + brand + "</span><br />";
strProMain += tprice + ": <span class='price'>";
if (price.Equals("0"))
{
strProMain += tupdate + "</span><br />";
}
else
{
if (unitPrice.Equals("$"))
{
strProMain += price + " VND</span><br />";
strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + "</span><br />";
}
else if (unitPrice.Equals("$$"))
{
strProMain += price + " VND</span><br />";
strProMain += "<font color='#FFFFFF'>" + tprice + ": </font><span class='price'>" + price2 + " USD</span><br />";
}
else
{
strProMain += price + " " + unitPrice + "</span><br />";
}
strProMain += "<span class='tvat'>" + strMVAT + "</span><br />";
}
strProMain += twarranty + ": <span class='price'>" + warranty + " " + tmonth + "</span></td>";
strProMain += "<td><input type='checkbox' id='c" + id + "' name='cp'/></td></tr>";
//strProMain += "<tr><td colspan='3' height='32' align='center'><div class='button3' onclick='AddCart(" + id + ",2);'>" + torder + "</div></td></tr>";
strProMain += "</table></td></tr>";
if (i + 1 < numPro)
{
strProMain += "<tr><td class='bg_line3'></td><td></td><td class='bg_line3'></td></tr>";
}
iseven = true;
}
}
if (numPro == 0)
{
strProMain += "<tr><td colspan='3' align='center'>" + tnotpro + "</td></tr>";
}
strProMain += "<tr height='5'><td colspan='3'></td></tr>";
strProMain += "</table>";
return(strProMain);
}
