public frmSmallSearch(HTextBox textboxSearch)
{
InitializeComponent();
ht = textboxSearch;
if (ht._SearchTable != null)
{
sql = "Select ";
string[] column = ht._SearchFields.Split('&');
foreach (string a in column)
{
field.Add(a.Split(':')[0], a.Split(':')[1]);
sql += " " + a.Split(':')[0] + ",";
}
sql = sql.Remove(sql.Length - 1);
sql += " from " + ht._SearchTable + " where 1=1 ";
//-----------------
#region SearchFilter ABUBAKR 10 Sept 2013
if (txtSearchfor.Text.Trim() != "" && ht._SearchFilter != null && ht._SearchFilter != "")
sql += " and " + ht._SearchFilter;
#endregion
string NotActivesql = @" SELECT COLUMN_NAME
FROM INFORMATION_SCHEMA.COLUMNS
WHERE (TABLE_NAME = '" + ht._SearchTable + @"') and COLUMN_NAME = 'NotActive' ";
DataTable dt = DataLayer.executeDataTable(NotActivesql);
if (dt.Rows.Count != 0)
sql += " and isnull( NotActive ,0) =0";
dt = DataLayer.executeDataTable(sql);
grid.DataSource = dt;
foreach (DataGridViewColumn col in grid.Columns)
{
col.HeaderText = field[col.Name];
}
}
}
public string Previous(string tableName, HTextBox co, string value, string criteria = "")
{
string code = "";
try
{
if (value != "")
{
string sql = @"Select top(1) isnull(" + co._FieldName + ",0) As PrevCode from " + tableName + " Where " + co._FieldName + " < " + value;
if (criteria != "") sql += " AND " + criteria;
sql += " Order BY " + co._FieldName + " desc";
code = DataLayer.Executescalar(sql);
if (code == null || code == "")
{
string sql2 = @"Select isnull(MIN(" + co._FieldName + "),0) As PrevCode from " + tableName + " ";
if (criteria != "") sql2 += " Where " + criteria;
code = DataLayer.Executescalar(sql2);
}
}
else
{
string sql = @"Select isnull(MIN(" + co._FieldName + "),0) As PrevCode from " + tableName + " ";
if (criteria != "") sql += " Where " + criteria;
code = DataLayer.Executescalar(sql);
}
}
catch (Exception)
{
MessageBox.Show("Exception : Previous()");
}
return code;
}