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();
    }
Exemple #2
0
    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();
        }
    }