/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
string tempSQL = null;
string strErr = null;
string strDept = null;
string strDeptNM = null;
strDept = cmbDept.SelectedItem.ID;
strDeptNM = cmbDept.SelectedItem.Name;
tempSQL = string.Format(strSQL, strDept);
try
{
interManager.ExecQuery(tempSQL, ref ds);
}
catch (Exception ex)
{
strErr = "查询数据失败！" + ex.Message;
MessageBox.Show(strErr);
return(-1);
}
//向fp内添加数据
if (ds.Tables.Count > 0)
{
neuSpread1_Sheet1.DataSource = ds.Tables[0].DefaultView;
Filter();
}
lbTitle1.Text = "查询科室：" + strDeptNM +
" 共：" + ds.Tables[0].Rows.Count.ToString() + "条记录";
return(1);
}
/// <summary>
/// 查询
/// </summary>
/// <returns></returns>
protected int Query()
{
string tempSQL = null;
string strErr = null;
string strDept = null;
string strDeptNM = null;
DateTime dtBegin = new DateTime();
DateTime dtEnd = new DateTime();
dtBegin = new DateTime(this.dtpBeginDate.Value.Year, this.dtpBeginDate.Value.Month, this.dtpBeginDate.Value.Day, 0, 0, 0);
dtEnd = new DateTime(this.dtpEndDate.Value.Year, this.dtpEndDate.Value.Month, this.dtpEndDate.Value.Day, 23, 59, 59);
strDept = cmbDept.SelectedItem.ID;
strDeptNM = cmbDept.SelectedItem.Name;
tempSQL = string.Format(strSQL, dtBegin, dtEnd, strDept);
try
{
interManager.ExecQuery(tempSQL, ref ds);
}
catch (Exception ex)
{
strErr = "查询数据失败！" + ex.Message;
MessageBox.Show(strErr);
return(-1);
}
//向fp内添加数据
if (ds.Tables.Count > 0)
{
neuSpread1_Sheet1.DataSource = ds.Tables[0].DefaultView;
Filter();
}
lbTitle1.Text = "查询时间：" + dtpBeginDate.Value.ToShortDateString() +
"至" + dtpEndDate.Value.ToShortDateString() +
" 查询科室：" + strDeptNM +
" 共：" + ds.Tables[0].Rows.Count.ToString() + "条记录";
return(1);
}
