protected void Page_Load(object sender, EventArgs e) { REQUESTCODE uResponse = REQUESTCODE.EXECUTE_FAIL; RTUSEDETAILREQ vrParameter = new RTUSEDETAILREQ(); RTUSEDETAIL[] vrResult; string szDevID = ""; GetPageCtrlValue(out vrParameter.szReqExtInfo); if (!IsPostBack) { dwStartDate.Value = DateTime.Now.AddDays(-30).ToString("yyyy-MM-dd"); dwEndDate.Value = DateTime.Now.ToString("yyyy-MM-dd"); } UNIDEVICE[] dev; if (GetAllDev(out dev) == true) { szDevID = dev[0].dwDevID.ToString(); for (int i = 0; i < dev.Length; i++) { m_szDev += "<option value='" + dev[i].dwDevID.ToString() + "'>" + dev[i].szDevName + "</option>"; } } if (Request["dwDevID"] != null && Request["dwDevID"] != "" && Request["dwDevID"] != "0") { vrParameter.dwDevID = ToUint(Request["dwDevID"]); } else { vrParameter.dwDevID = ToUint(szDevID); } vrParameter.dwStartDate = DateToUint(dwStartDate.Value); vrParameter.dwEndDate = DateToUint(dwEndDate.Value); uResponse = m_Request.Report.GetRTUseDetail(vrParameter, out vrResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS && vrResult != null && vrResult.Length > 0) { for (int i = 0; i < vrResult.Length; i++) { m_szOut += "<tr>"; m_szOut += "<td>" + Get1970Date(vrResult[i].dwBeginTime, "yyyy-MM-dd") + "</td>"; m_szOut += "<td>" + vrResult[i].szOwnerName + "</td>"; m_szOut += "<td>" + vrResult[i].szHolderName.ToString() + "</td>"; m_szOut += "<td>" + vrResult[i].dwSampleNum.ToString() + "</td>"; m_szOut += "<td>" + GetFee(vrResult[i].dwRealCost) + "</td>"; m_szOut += "<td>" + GetFee(vrResult[i].dwDevUseFee) + "</td>"; // m_szOut += "<td>" + GetFee(vrResult[i].dwSampleFee) + "</td>"; // m_szOut += "<td>" + GetFee(vrResult[i].dwEntrustFee) + "</td>"; // m_szOut += "</tr>"; } UpdatePageCtrl(m_Request.Report); } PutBackValue(); }
protected void Page_Load(object sender, EventArgs e) { REQUESTCODE uResponse = REQUESTCODE.EXECUTE_FAIL; RTUSEDETAILREQ vrParameter = new RTUSEDETAILREQ(); RTUSEDETAIL[] vrResult; vrParameter.dwDevID = DateToUint(Request["dwDevID"]); vrParameter.dwStartDate = DateToUint(Request["dwStartDate"]); vrParameter.dwEndDate = DateToUint(Request["dwEndDate"]); uResponse = m_Request.Report.GetRTUseDetail(vrParameter, out vrResult); if (uResponse == REQUESTCODE.EXECUTE_SUCCESS && vrResult != null && vrResult.Length > 0) { System.IO.StringWriter swCSV = new System.IO.StringWriter(); swCSV.WriteLine(" 时间,使用人," + ConfigConst.GCTutorName + ",总金额,分析测试费,开放基金,劳务费"); for (int i = 0; i < vrResult.Length; i++) { System.Text.StringBuilder sbText = new System.Text.StringBuilder(); sbText = AppendCSVFields(sbText, Get1970Date(vrResult[i].dwBeginTime, "yyyy-MM-dd")); sbText = AppendCSVFields(sbText, vrResult[i].szOwnerName); sbText = AppendCSVFields(sbText, vrResult[i].szHolderName.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwRealCost.ToString()); sbText = AppendCSVFields(sbText, vrResult[i].dwDevUseFee.ToString()); //协助 sbText = AppendCSVFields(sbText, vrResult[i].dwSampleFee.ToString()); ////使用 sbText = AppendCSVFields(sbText, vrResult[i].dwEntrustFee.ToString()); //样品费 //sbText = AppendCSVFields(sbText, vrResult[i]..ToString()); //代建费 sbText.Remove(sbText.Length - 1, 1); //写datatable的一行 swCSV.WriteLine(sbText.ToString()); } DownloadFile(Response, swCSV.GetStringBuilder(), "devUseFeeDetail.csv"); swCSV.Close(); Response.End(); } }