ParameterFields paramFields = new ParameterFields();
ParameterField paramField = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField.ParameterFieldName = "strTime";
discreteVal.Value = strTime;
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "AdminUserId";
discreteVal2.Value = AdminUid;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
ParameterField paramField = new ParameterField();
ParameterDiscreteValue discreteVal = new ParameterDiscreteValue();
paramField.ParameterFieldName = "strTime";
discreteVal.Value = strTime;
paramField.CurrentValues.Add(discreteVal);
paramFields.Add(paramField);
ParameterField paramField2 = new ParameterField();
ParameterDiscreteValue discreteVal2 = new ParameterDiscreteValue();
paramField2.ParameterFieldName = "AdminUserId";
discreteVal2.Value = AdminUid;
paramField2.CurrentValues.Add(discreteVal2);
paramFields.Add(paramField2);
CrystalReportViewer1.ParameterFieldInfo = paramFields;
doc.Load(Server.MapPath("CrystalReport.rpt"));
-------------------------------------------------------------------------------------------------命令
SELECT * FROM get_money_log where CreateTime >= UNIX_TIMESTAMP('{?strTime}') and CreateTime <= UNIX_TIMESTAMP('{?strTime} 23:59:59') and
AdminUserId={?AdminUserId}