private void setEnableCreated(searchCreated _opts)
{
if (_opts == searchCreated.None)
{
SearchEnableOn = false;
SearchEnableBefore = false;
SearchEnableAfter = false;
SearchEnableBetween = false;
}
if (_opts == searchCreated.CreatedOn)
{
SearchEnableOn = true;
SearchEnableBefore = false;
SearchEnableAfter = false;
SearchEnableBetween = false;
}
if (_opts == searchCreated.Before)
{
SearchEnableOn = false;
SearchEnableBefore = true;
SearchEnableAfter = false;
SearchEnableBetween = false;
}
if (_opts == searchCreated.After)
{
SearchEnableOn = false;
SearchEnableBefore = false;
SearchEnableAfter = true;
SearchEnableBetween = false;
}
if (_opts == searchCreated.Between)
{
SearchEnableOn = false;
SearchEnableBefore = false;
SearchEnableAfter = false;
SearchEnableBetween = true;
}
}
private void onAdvanceSearchEvent(object _param)
{
string _txtKey = _param as string;
this._txtKeySearch = string.Empty;
searchGenaral _optsGenaral = SearchGenaral;
searchCreated _optsCreated = SearchCreated;
searchDeliver _optsDeliver = SearchDeliver;
if (string.IsNullOrEmpty(_txtKey) && _optsGenaral == searchGenaral.None && _optsCreated == searchCreated.None && _optsDeliver == searchDeliver.None)
{
this._txtKeySearch = string.Empty;
paging.CurrentPage = 1;
ShowCurPage = paging.CurrentPage;
onFormLoadedEvent(null);
return;
}
else
{
string _strCondition = string.Empty;
DateTime _enddate, _startdate;
if (!string.IsNullOrEmpty(_txtKey))
{
_strCondition += "Barcode like $'%" + _txtKey.Trim() + "%' and ";
}
if (_optsGenaral != searchGenaral.None)
{
switch (_optsGenaral)
{
case searchGenaral.Expired:
DateTime _expreTime;
DateTime oDate = DateTime.Now;
_expreTime = Convert.ToDateTime(oDate.ToString(System.Globalization.CultureInfo.CurrentUICulture.DateTimeFormat.ShortDatePattern) + " 23:59:59");
_strCondition += "ExpirationDate <= " + ConvertToUnixTime(_expreTime) + " and ";
break;
case searchGenaral.InUse:
_strCondition += "Balance > 0 and ";
break;
case searchGenaral.IsUsed:
_strCondition += "Balance <= 0 and ";
break;
default:
break;
}
}
if (_optsCreated != searchCreated.None)
{
switch (_optsCreated)
{
case searchCreated.Before:
_enddate = Convert.ToDateTime(this.SearchCreatedBefore + " 00:00:00");
_strCondition += "CreateDate < " + ConvertToUnixTime(_enddate) + " and ";
break;
case searchCreated.After:
_enddate = Convert.ToDateTime(this.SearchCreatedAfter + " 23:59:59");
_strCondition += "CreateDate > " + ConvertToUnixTime(_enddate) + " and ";
break;
case searchCreated.Between:
_enddate = Convert.ToDateTime(this.SearchCreatedEnd + " 23:59:59");
_startdate = Convert.ToDateTime(this.SearchCreatedStart + " 00:00:00");
_strCondition += "CreateDate between " + ConvertToUnixTime(_startdate) + " and " + ConvertToUnixTime(_enddate) + " and ";
break;
case searchCreated.CreatedOn:
_enddate = Convert.ToDateTime(this.SearchCreatedOn + " 23:59:59");
_startdate = Convert.ToDateTime(this.SearchCreatedOn + " 00:00:00");
_strCondition += "CreateDate between " + ConvertToUnixTime(_startdate) + " and " + ConvertToUnixTime(_enddate) + " and ";
break;
default:
break;
}
}
if (_optsDeliver != searchDeliver.None)
{
if (_optsDeliver == searchDeliver.Delivered)
{
_strCondition += "DeliveredDate > 0 and ";
}
else
{
_strCondition += "DeliveredDate = 0 and ";
}
}
_strCondition = _strCondition.Remove(_strCondition.Length - 5, 5);
this._txtKeySearch = _strCondition;
paging.CurrentPage = 1;
ShowCurPage = paging.CurrentPage;
onFormLoadedEvent(null);
}
}
