/// <summary>
/// 模糊搜索事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void CheckSimpleButton_Click(object sender, EventArgs e)
{
if (BGW1.IsBusy == false)
{
gridControl1.RefreshDataSource();
BGW1.RunWorkerAsync("SearchData");
}
}
/// <summary>
/// 分页事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gridViewPaging1_PagingChanged(object sender, MyPagingEventArgs e)
{
if (BGW1.IsBusy == false)
{
gridControl1.RefreshDataSource();
BGW1.RunWorkerAsync("SearchData");
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
//excel side of things
dgRes.Rows.Clear();
searchInProgress = true;
PopulateExcelData();
if (cbSQL.Checked)
{
//sql side of things - first build the query string
queryString = "SELECT * FROM [" + tableName + "]";
if (txtName.Text != "" || txtEmpNum.Text != "" || cmbGender.Text != "" || txtHighSal.Text != "" || txtLowSal.Text != "")
{
queryString = queryString + " WHERE "; //if any of the fields have been included, we must develop this query string further
if (!string.IsNullOrEmpty(txtName.Text))
{
queryString = queryString + " [NAME] = '" + txtName.Text + "' AND "; //add name elements to the query string
}
if (!string.IsNullOrEmpty(cmbGender.Text))
{
queryString = queryString + " [GENDER] = '" + cmbGender.Text + "' AND "; //add gender elements...
}
if (!string.IsNullOrEmpty(txtEmpNum.Text))
{
if (rdoExactEmpNum.Checked)
{
queryString = queryString + " [EMPLOYEE NUMBER] = '" + txtEmpNum.Text + "' AND "; //add employee number...
}
else
{
queryString = queryString + " [EMPLOYEE NUMBER] LIKE '%" + txtEmpNum.Text + "%' AND ";
}
}
if (!string.IsNullOrEmpty(txtLowSal.Text) && !string.IsNullOrEmpty(txtHighSal.Text))
{
queryString = queryString + " [SALARY] BETWEEN '" + txtLowSal.Text + "' AND '" + txtHighSal.Text + "' AND "; //add salary elements...
}
//take the last AND off the query string and close it
char[] trimLastAnd = { ' ', 'A', 'N', 'D', ' ' };
queryString = (queryString.TrimEnd(trimLastAnd));
//queryString = queryString + ")";
}
btnSearch.Enabled = false;
BGW1.RunWorkerAsync(); //run search operations in a backgroundworker so as not to disrupt other stuff or risk non-responsiveness on larger tables
}
}
/// <summary>
/// 异步事务工作事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void BGW1_DoWork(object sender, DoWorkEventArgs e)
{
BGW1.ReportProgress(0);
try
{
switch (e.Argument.ToString())
{
case "SearchData":
int CurrPage = (int)page.CurrentPage;
int PageSize = (int)page.PageSize;
Tuple <string, object[]> tWhere = null;
if (CheckTextEdit.Text.IsNullOrEmpty() == false)
{
string strWhere = "1=1 and (DevCode.Contains(@0) or DeviCode.Contains(@0) or DeviName.Contains(@0) or DevpCode.Contains(@0) ) ";
tWhere = Tuple.Create <string, object[]>(strWhere, new object[] { CheckTextEdit.Text });
}
using (SRDevice.DeviceServiceClient client = new SRDevice.DeviceServiceClient())
{
var ret = client.GetDevInterfacePagedList(context.SessionID, tWhere, PageSize, CurrPage);
if (ret.IsSuccess)
{
page.CurrentPage = CurrPage;
page.RowCount = ret.TotalNum;
e.Result = ret.Data;
}
else
{
BGW1.ReportProgress(101, ret.Message);
}
}
break;
default:
break;
}
}
catch (Exception ex)
{
BGW1.ReportProgress(101, ex.Message);
}
BGW1.ReportProgress(100);
}
/// <summary>
/// 窗体初始化加载
/// </summary>
private void frmInterfaceChoose_Load(object sender, EventArgs e)
{
client = new SRDevice.DeviceServiceClient();
BGW1.RunWorkerAsync("SearchData");
}
