public void PrintSendDetail() { try { CpNpStat stat = new CpNpStat(); Sql2KDataAccess access = new Sql2KDataAccess(); DataSet ds = new DataSet(); access.Run_SqlText(ref ds, "select Description ,TotalNum from V_NpType t inner join (select Code,Count(NpId) as TotalNum from V_Np Where InPutTime between '" + this.m_FromDate.ToShortDateString() + "' and '" + this.ToDate.AddDays(1.0).ToShortDateString() + "'" + this.m_State + " Group By Code) t1 on t.Code=t1.Code", "V_NpStat"); ParameterFields fields = new ParameterFields(); ParameterField field = new ParameterField(); ParameterDiscreteValue value2 = new ParameterDiscreteValue(); field.ParameterFieldName="FromDate"; value2.Value=this.m_FromDate.ToShortDateString(); field.CurrentValues.Add(value2); fields.Add(field); field = new ParameterField(); field.ParameterFieldName="ToDate"; value2 = new ParameterDiscreteValue(); value2.Value=this.m_ToDate.ToShortDateString(); field.CurrentValues.Add(value2); fields.Add(field); field = new ParameterField(); field.ParameterFieldName="State"; value2 = new ParameterDiscreteValue(); value2.Value=this.StateDesc; field.CurrentValues.Add(value2); fields.Add(field); this.crv_Send.ParameterFieldInfo=fields; ds.Tables[0].TableName = "V_NpState"; stat.SetDataSource(ds); this.crv_Send.ReportSource=stat; this.crv_Send.PrintReport(); } catch (Exception exception) { MessageBox.Show("打印时发生错误" + '\n' + exception.Message, "打印生产量统计", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }
private void Frm_NpStat_Load(object sender, EventArgs e) { CpNpStat stat = new CpNpStat(); Sql2KDataAccess access = new Sql2KDataAccess(); DataSet ds = new DataSet(); access.Run_SqlText(ref ds, "select Description ,TotalNum from V_NpType t inner join (select Code,Count(NpId) as TotalNum from V_Np Where InPutTime between '" + this.m_FromDate.ToShortDateString() + "' and '" + this.ToDate.AddDays(1.0).ToShortDateString() + "'" + this.m_State + " Group By Code) t1 on t.Code=t1.Code", "V_NpStat"); ParameterFields fields = new ParameterFields(); ParameterField field = new ParameterField(); ParameterDiscreteValue value2 = new ParameterDiscreteValue(); field.ParameterFieldName="FromDate"; value2.Value=this.m_FromDate.ToShortDateString(); field.CurrentValues.Add(value2); fields.Add(field); field = new ParameterField(); field.ParameterFieldName="ToDate"; value2 = new ParameterDiscreteValue(); value2.Value=this.m_ToDate.ToShortDateString(); field.CurrentValues.Add(value2); fields.Add(field); field = new ParameterField(); field.ParameterFieldName="State"; value2 = new ParameterDiscreteValue(); value2.Value=this.StateDesc; field.CurrentValues.Add(value2); fields.Add(field); this.crv_Send.ParameterFieldInfo=fields; stat.SetDataSource(ds); this.crv_Send.ReportSource=stat; }