private void FillRepeater()
{
StringBuilder sqlString = new StringBuilder();
sqlString.Append("SELECT BASE_COMPANIES.*, ");
sqlString.Append("(ACCOUNT.SURNAME+' '+ACCOUNT.NAME) AS OWNER ");
sqlString.Append("FROM BASE_COMPANIES ");
sqlString.Append("LEFT OUTER JOIN ACCOUNT ON BASE_COMPANIES.OWNERID = ACCOUNT.UID");
sqlString.Append(" WHERE LIMBO=1");
sqlString.Append(" ORDER BY BASE_COMPANIES.COMPANYNAME");
Repeaterpaging1.PageSize = UC.PagingSize;
Repeaterpaging1.RepeaterObj = Repeater1;
Repeaterpaging1.sqlRepeater = sqlString.ToString();
Repeaterpaging1.CurrentPage = 0;
Repeaterpaging1.BuildGrid();
if (Repeater1.Items.Count > 0)
{
Repeater1.Visible = true;
RepeaterInfo.Visible = false;
}
else
{
RepeaterInfo.Text = "<center>" + Root.rm.GetString("Bcotxt41") + "</center>";
Repeater1.Visible = false;
RepeaterInfo.Visible = true;
}
}
private void FindProductQuery()
{
string search = DatabaseConnection.FilterInjection(Search.Text);
StringBuilder q = new StringBuilder();
if (FindCatID.Text.Length > 0)
{
string c = String.Empty;
FillQueryCategories(int.Parse(FindCatID.Text), ref c);
c = c.Substring(0, c.Length - 3);
q.AppendFormat("SELECT * FROM CATALOGPRODUCTS WHERE ({0}) AND (", c);
q.AppendFormat("SHORTDESCRIPTION LIKE '{0}%' OR ", search);
q.AppendFormat("LONGDESCRIPTION LIKE '{0}%' OR ", search);
q.AppendFormat("CODE LIKE '{0}%') ", search);
q.Append("ORDER BY CATEGORY");
}
else
{
q.AppendFormat("SELECT * FROM CATALOGPRODUCTS WHERE (");
q.AppendFormat("SHORTDESCRIPTION LIKE '{0}%' OR ", search);
q.AppendFormat("LONGDESCRIPTION LIKE '{0}%' OR ", search);
q.AppendFormat("CODE LIKE '{0}%') ", search);
q.Append("ORDER BY CATEGORY");
}
Repeaterpaging1.PageSize = UC.PagingSize;
Repeaterpaging1.RepeaterObj = ProductRepeater;
Repeaterpaging1.sqlRepeater = q.ToString();
Repeaterpaging1.CurrentPage = 0;
Repeaterpaging1.BuildGrid();
if (ProductRepeater.Items.Count > 0)
{
ProductRepeater.Visible = true;
}
else
{
ProductRepeater.Visible = false;
}
Tabber.Visible = false;
}
