/// <summary> /// 显示对应单据报表 /// </summary> /// <param name="rowHeaderName">行头名</param> /// <param name="columnName">列头名</param> public void SqlToReport(string rowHeaderName, string columnName) { string TypeName = ""; string sql = "SELECT ReceiptId 单据号,InvoiceNo 发票编号, ReceiptTypeID 单据类别," + "CustomerReceiptNo 自定义编号,CurWorkMonth 工作年月,OccurTime 单据日期," + "CustName 客户名称,MatId 商品编号 ,MatName 商品名称,SourceStoreH 仓库," + "MatType 类型,num 数量,price 含税单价,Amount 含税金额,TTaxPurchPrice 成本金额," + "ML 毛利, lotCode 批号,VerifyPerson 验收员,BillUser 操作员,Memo 备注 " + "FROM T_JXDetail where SourceStoreH='" + columnName + "' and "; string strsql = ""; switch (rowHeaderName) { case "01": TypeName = "JHDetail"; strsql = sql + " ReceiptTypeID='01'"; break; case "03": TypeName = "JHDetail"; strsql = sql + " ReceiptTypeID='03'"; break; case "20": TypeName = "JHDetail"; strsql = sql + " ReceiptTypeID='20'"; break; case "51": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='51'"; break; case "52": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='52'"; break; case "53": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='53'"; break; case "54": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='54'"; break; case "55": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='55'"; break; case "56": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='56'"; break; case "75": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='75'"; break; case "88": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='88'"; break; case "90": TypeName = "XSDetail"; strsql = sql + " ReceiptTypeID='90'"; break; default: break; } SqlDBConnect db = new SqlDBConnect(); DataTable dt = new DataTable(); strsql += " and (OccurTime between '" + dateTimeFrom + "' and '" + dateTimeTo + "')"; dt = db.Get_Dt(strsql); string count = dt.Rows.Count.ToString(); //通过sql条件显示报表窗体 PublicDetailForm form = new PublicDetailForm(); form.MdiParent = this.MdiParent as MainForm; form.Show(); form.strSql = strsql; form.count = count; form.ReiceName = TypeName; form.Username = (this.MdiParent as MainForm).userName; form.ShowReport(); }
/// <summary> ///报表通用连接查询语句 /// </summary> public void Connect(string strSql, string receiname) { SqlDBConnect db = new SqlDBConnect(); DataTable dt = new DataTable(); dt = db.Get_Dt(strSql); string count = dt.Rows.Count.ToString(); //通过sql条件显示报表窗体 PublicDetailForm form = new PublicDetailForm(); form.MdiParent = this; form.Show(); form.ReiceName = receiname; form.Username = userName; form.strSql = strSql; form.count = count; form.ShowReport(); }