public void SearchData()
{
Cursor.Current = Cursors.WaitCursor;
string strSearchItem;
string strSearhItemType;
string strSearchUseYN;
ResetDetial();
try
{
strSearchItem = lueSearchItem.EditValue.ToString();
if (string.IsNullOrEmpty(strSearchItem))
{
strSearchItem = "%";
}
strSearhItemType = lueSearchItemType.Properties.GetKeyValueByDisplayText(lueSearchItemType.Text).ToString();
if (string.IsNullOrEmpty(strSearhItemType))
{
strSearhItemType = "%";
}
strSearchUseYN = lueSearchUseYN.Properties.GetKeyValueByDisplayText(lueSearchUseYN.Text).ToString();
if (string.IsNullOrEmpty(strSearchUseYN))
{
strSearchUseYN = "%";
}
//if (strSearchUseYN == "%")
//{
// strSearchUseYN = "";
//}
var qry = db.stp_ItemMaster_Select(strSearchItem, strSearhItemType, strSearchUseYN).ToList();
//var qry = from obj in db.ItemMasters
// where (obj.ItemCode.Contains(strSearchItem) || obj.ItemDescription.Contains(strSearchItem))
// && obj.ItemType.Contains(strSearhItemType)
// && (obj.UseYN == true ? "Y" : "N").Contains(strSearchUseYN)
// select new
// {
// ItemID = obj.ItemID
// ,
// ItemCode = obj.ItemCode
// ,
// ItemDescription = obj.ItemDescription
// ,
// ItemType = obj.ItemType
// ,
// UseYN = obj.UseYN
// };
if (qry.Count() > 0)
{
gcList.DataSource = qry;
//gcList.View.FocusedRowHandle = 0;
string[] arr = { "ItemID", "ItemType" };
Functions.SetInvisible(ref gvList, arr);
gvList.BestFitColumns();
gvList.FocusedRowHandle = gvList.GetVisibleRowHandle(0);
}
else
{
gcList.DataSource = null;
MessageBox.Show("No Results", "Success!", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show("Couldn't Search Item List!" + Environment.NewLine + ex.Message.ToString(), "Error!", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
finally
{
Cursor.Current = Cursors.Default;
}
}
