bool m_blnIsChange = false; //判断工作组的资料是否有改动
#region 构造函数
public clsController_StatBaseInfo()
{
//
// TODO: 在此处添加构造函数逻辑
//
m_objManage = new clsDomainController_StatManage();
}
public void m_mthQueryScienceStatInfo()
{
m_objViewer.m_lsvItemDetail.Items.Clear();
#region checkValidate
if (m_objViewer.m_txtAgeFrom.Text.ToString().Trim() != "")
{
if (!Microsoft.VisualBasic.Information.IsNumeric(m_objViewer.m_txtAgeFrom.Text.ToString().Trim()))
{
MessageBox.Show("请输入正确年龄格式！", "学术统计");
m_objViewer.m_txtAgeFrom.Focus();
return;
}
}
if (m_objViewer.m_txtAgeTo.Text.ToString().Trim() != "")
{
if (!Microsoft.VisualBasic.Information.IsNumeric(m_objViewer.m_txtAgeTo.Text.ToString().Trim()))
{
MessageBox.Show("请输入正确年龄格式！", "学术统计");
m_objViewer.m_txtAgeTo.Focus();
return;
}
}
if (m_objViewer.m_lsvItemList.Items.Count <= 0)
{
MessageBox.Show("请输入查询条件", "学术统计");
return;
}
#endregion
this.m_objViewer.m_btnQuery.Enabled = false;
this.m_objViewer.Cursor = System.Windows.Forms.Cursors.WaitCursor;
#region InitalParameter
string strCheckItemID = m_objViewer.m_cboCheckItem.SelectedValue.ToString().Trim();
string strCheckDatFrom = m_objViewer.m_dtpDatFrom.Value.ToShortDateString() + " 00:00:00";
string strCheckDatTo = m_objViewer.m_dtpDatTo.Value.ToShortDateString() + " 23:59:59";
string strResultFrom = m_objViewer.m_txtResultFrom.Text.ToString().Trim();
string strResultTo = m_objViewer.m_txtResultTo.Text.ToString().Trim();
string strLowCompare = m_objViewer.m_cboLowCompare.Text.ToString().Trim();
if (strLowCompare == "在")
{
strLowCompare = "IN";
}
else if (strLowCompare == "不在")
{
strLowCompare = "NOT IN";
}
string strUpCompare = m_objViewer.m_cboUpCompare.Text.ToString().Trim();
string strCondition = m_objViewer.m_cboCondition.Text.ToString().Trim();
string strAgeFrom = "";
string strAgeTo = "";
string strSex = m_objViewer.m_cboSex.Text.ToString().Trim();
if (m_objViewer.m_txtAgeFrom.Text.ToString().Trim() != null && m_objViewer.m_txtAgeFrom.Text.ToString().Trim() != "")
{
strAgeFrom = m_objViewer.m_txtAgeFrom.Text.ToString().Trim() + " " + m_objViewer.m_cboFromAgeUnit.Text.ToString().Trim();
}
if (m_objViewer.m_txtAgeTo.Text.ToString().Trim() != null && m_objViewer.m_txtAgeTo.Text.ToString().Trim() != "")
{
strAgeTo = m_objViewer.m_txtAgeTo.Text.ToString().Trim() + " " + m_objViewer.m_cboToAgeUnit.Text.ToString().Trim();
}
#endregion
clsLisScienceStatItemQueryCondition[] objVOArr = new clsLisScienceStatItemQueryCondition[m_objViewer.m_lsvItemList.Items.Count];
for (int i = 0; i < m_objViewer.m_lsvItemList.Items.Count; i++)
{
objVOArr[i] = (clsLisScienceStatItemQueryCondition)m_objViewer.m_lsvItemList.Items[i].Tag;
}
clsDomainController_StatManage objManage = new clsDomainController_StatManage();
DataTable dtbHead = null;
DataTable dtbDetail = null;
DataSet ds = new DataSet();
long lngRes = 0;
lngRes = objManage.m_lngGetScienceStatByCondition(strCheckDatFrom, strCheckDatTo, strAgeFrom,
strAgeTo, strSex, objVOArr, out dtbHead, out dtbDetail);
if (dtbHead != null && dtbDetail != null)
{
dtbHead.TableName = "dtbHead";
dtbDetail.TableName = "dtbDetail";
ds.Tables.Add(dtbHead);
ds.Tables.Add(dtbDetail);
}
// DataSet ds = m_mthCreateDataSet();
// com.digitalwave.iCare.gui.LIS.Report.cryScienceStat obj = new com.digitalwave.iCare.gui.LIS.Report.cryScienceStat();
CrystalDecisions.CrystalReports.Engine.ReportDocument objReportDoc = new ReportDocument();
try
{
if (lngRes > 0 && ds != null)
{
try
{
objReportDoc.Load(Application.StartupPath + "\\lis_reports\\cryScienceStat.rpt");
objReportDoc.SetDataSource(ds);
}
catch
{
MessageBox.Show("加载报表失败！");
}
}
else
{
MessageBox.Show("没有符合条件的记录", "学术统计");
ds = null;
ds.Tables.Add(new DataTable("dtbHead"));
ds.Tables.Add(new DataTable("dtbDetail"));
}
#region 送参数
try
{
////传送参数
//ParameterValues paramValues=new ParameterValues();
////定义参数
//ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();//
//discreteVal.Value=m_objViewer.m_dtpDatFrom.Value.ToShortDateString().Trim();
//paramValues.Add(discreteVal);
//ParameterDiscreteValue discreteVal1 = new ParameterDiscreteValue();//
//discreteVal1.Value=m_objViewer.m_dtpDatTo.Value.ToShortDateString().Trim();
//paramValues.Add(discreteVal1);
////将参数加入集合
//discreteVal.Kind =DiscreteOrRangeKind.DiscreteValue;
//ParameterValues paramValue=new ParameterValues();
////传送参数
//for(int i=0;i<=paramValues.Count-1;i++)
//{
// paramValue.Clear();
// paramValue.Add(paramValues[i]);
// objReportDoc.DataDefinition.ParameterFields[i].ApplyCurrentValues(paramValue);
//}
objReportDoc.SetParameterValue(0, strCheckDatFrom.Substring(0, 16));
objReportDoc.SetParameterValue(1, strCheckDatTo.Substring(0, 16));
}
catch
{
}
#endregion
m_objViewer.m_ReportViewer.ReportSource = objReportDoc;
// m_objViewer.m_ReportViewer.RefreshReport();
}
catch
{
}
finally
{
this.m_objViewer.Cursor = System.Windows.Forms.Cursors.Default;
this.m_objViewer.m_btnQuery.Enabled = true;
}
}
