Пример #1
0
    /// <summary>
    /// 刷新数据明细数据
    /// </summary>
    public void RefreshCheckData()
    {
        #region 查询明细数据

        //initJavascript();
        tLoadHISRequest tloadhisRequest = new tLoadHISRequest(gethisReq);
        IAsyncResult    result_his      = tloadhisRequest.BeginInvoke(txt_startDate.Text.Trim(), txt_endDate.Text.Trim(), null, null);
        tLoadWYRequest  tLoadwyRequest  = new tLoadWYRequest(getReq);
        IAsyncResult    result2         = tLoadwyRequest.BeginInvoke(txt_startDate.Text.Trim(), txt_endDate.Text.Trim(), null, null);



        string _requesthis = tloadhisRequest.EndInvoke(result_his);
        string _request    = tLoadwyRequest.EndInvoke(result2);

        tLoadHISData tloadhis  = new tLoadHISData(gethisXml);
        IAsyncResult result    = tloadhis.BeginInvoke(_requesthis, null, null);
        tLoadWYData  tloadwy   = new tLoadWYData(getXml);
        IAsyncResult result_WY = tloadwy.BeginInvoke(_request, null, null);
        string       strhisxml = tloadhis.EndInvoke(result);
        string       strxml    = tloadwy.EndInvoke(result_WY);

        dt_his = GetDBdata.XmlToDataTable(strhisxml);
        dt_wy  = GetDBdata.XmlToDataTable(strxml);
        if (dt_wy != null && dt_his != null)
        {
            try
            {
                //this.GridView.DataSource = dt_wy.DefaultView;
                //this.GridView.DataBind();
                //for (int i = dt_his.Rows.Count-1;i>=0; i--)
                //{
                //    for (int k =0; k < dt_wy.Rows.Count; k++)
                //    {
                //        if (dt_his.Rows[i][3].ToString() == dt_wy.Rows[k][11].ToString() && dt_his.Rows[i][13].ToString() == dt_wy.Rows[k][1].ToString() && dt_his.Rows[i][1].ToString() == dt_wy.Rows[k][2].ToString())
                //        {
                //            GridView.Rows[k].BackColor = System.Drawing.Color.Green;
                //        }

                //    }

                //}

                #region 统计所有数据
                dt_his_Result = GetDBdata.GetResult(dt_his);
                dt_wy_Result  = GetDBdata.GetResult(dt_wy);
                DtAll         = GetDBdata.UniteDataTable(dt_his_Result, dt_wy_Result, "合并Dt");
                DtAll.Columns.AddRange(new DataColumn[] { new DataColumn("different", typeof(double)) });
                DataRow drw             = DtAll.NewRow();
                double  different_money = 0.00;
                for (int i = 0; i < DtAll.Rows.Count; i++)
                {
                    foreach (DataRow dr in DtAll.Rows)
                    {
                        different_money            = different_money + (Convert.ToDouble(DtAll.Rows[i]["Amounthis"]) - Convert.ToDouble(DtAll.Rows[i]["wxAmount"]));
                        DtAll.Rows[i]["different"] = different_money.ToString("f2");

                        different_money = 0;
                    }
                }

                this.GridView.Visible          = false;
                this.GridView_Count.DataSource = DtAll.DefaultView;
                this.GridView_Count.DataBind();

                #endregion
                #region 账不平的变红色

                for (int k = 0; k < DtAll.Rows.Count; k++)
                {
                    if (DtAll.Rows[k][6].ToString() != "0")
                    {
                        GridView_Count.Rows[k].BackColor = System.Drawing.Color.Red;
                        //Logging.WriteHISlog("记录日志:","HIS的CARD_NO="+dt_his.Rows[i][3].ToString()+ "\r\n"+"微医的HOSP_PATIENT_ID="+ dt_wy.Rows[k][11].ToString() + "\r\n" + "HIS的TRANS_NO="+dt_his.Rows[i][13].ToString()+"微医的HOSP_ORDER_ID = "+ dt_wy.Rows[k][1].ToString() + "\r\n" + "HIS的TRANS_TYPE=" + dt_his.Rows[i][1].ToString() + "\r\n" + "微医的ORDER_TYPE=" + dt_wy.Rows[k][2].ToString() + "");
                    }
                }

                #endregion
            }

            catch (Exception Exc)
            {
                Logging.WriteBuglog(Exc);
            }
            finally
            {
                Logging.WriteWYlog(txt_startDate.Text + "至" + txt_endDate.Text + "的日志", strxml);
                Logging.WriteHISlog(txt_startDate.Text + "至" + txt_endDate.Text + "的日志", strhisxml);
            }
        }
        else
        {
            this.GridView.DataSource = "";
            this.GridView.DataBind();
        }
        #endregion
    }
Пример #2
0
    protected void GridView_Count_RowCommand(object sender, GridViewCommandEventArgs e)
    {
        GridView.Visible = false;
        if (e.CommandName == "Check")
        {
            initJavascript();
            int         id        = Convert.ToInt32(e.CommandArgument);
            GridViewRow row       = GridView_Count.Rows[id];
            string      CheckDate = row.Cells[0].Text.ToString();//Convert.ToString(this.GridView_Count.Rows[id].Cells[0].ToString());

            if (dt_wy != null && dt_his != null)
            {
                try
                {
                    tLoadHISRequest tloadhisRequest = new tLoadHISRequest(gethisReq);
                    IAsyncResult    result          = tloadhisRequest.BeginInvoke(CheckDate, CheckDate, null, null);
                    tLoadWYRequest  tLoadwyRequest  = new tLoadWYRequest(getReq);
                    IAsyncResult    result2         = tLoadwyRequest.BeginInvoke(CheckDate, CheckDate, null, null);

                    string _requesthis = tloadhisRequest.EndInvoke(result);
                    string _request    = tLoadwyRequest.EndInvoke(result2);

                    tLoadHISData tloadhis  = new tLoadHISData(gethisXml);
                    IAsyncResult resulthis = tloadhis.BeginInvoke(_requesthis, null, null);
                    tLoadWYData  tloadwy   = new tLoadWYData(getXml);
                    IAsyncResult result_WY = tloadwy.BeginInvoke(_request, null, null);
                    string       strhisxml = tloadhis.EndInvoke(resulthis);
                    string       strxml    = tloadwy.EndInvoke(result_WY);

                    dt_his = GetDBdata.XmlToDataTable(strhisxml);
                    dt_wy  = GetDBdata.XmlToDataTable(strxml);
                    this.GridView.DataSource = dt_wy.DefaultView;
                    this.GridView.DataBind();
                    for (int i = dt_his.Rows.Count - 1; i >= 0; i--)
                    {
                        for (int k = 0; k < dt_wy.Rows.Count; k++)
                        {
                            if (dt_his.Rows[i][3].ToString() == dt_wy.Rows[k][11].ToString() && dt_his.Rows[i][13].ToString() == dt_wy.Rows[k][1].ToString() && dt_his.Rows[i][1].ToString() == dt_wy.Rows[k][2].ToString())
                            {
                                GridView.Rows[k].BackColor = System.Drawing.Color.Green;
                            }
                        }
                    }
                    DetailsListTitle.Visible = true;
                    DetailsListTitle.Text    = CheckDate + "的明细单。 备注:绿色是匹配成功的订单,白色是HIS没有的订单";
                }
                catch (Exception ex)
                {
                    Logging.WriteBuglog(ex);
                }
                finally
                {
                    this.GridView.Visible = true;
                }
            }
            else
            {
                //this.GridView.Visible = true;
            }
        }
    }
    /// <summary>
    /// 刷新数据明细数据
    /// </summary>
    public void RefreshCheckData(List <string> request, string request_his)
    {
        #region 计算耗时方法,可删
        //Stopwatch sw = new Stopwatch();
        //sw.Start();
        #endregion
        initJavascript();
        #region datatable创建

        dt_wy.Columns.Add("交易时间", typeof(string));
        dt_wy.Columns.Add("业务平台流水", typeof(string));

        dt_wy.Columns.Add("平台交易流水", typeof(string));
        dt_wy.Columns.Add("业务退款流水", typeof(string));
        dt_wy.Columns.Add("平台退款流水", typeof(string));
        dt_wy.Columns.Add("交易金额", typeof(decimal));
        dt_wy.Columns.Add("退款金额", typeof(decimal));
        dt_wy.Columns.Add("补贴金额", typeof(decimal));
        dt_wy.Columns.Add("实付金额", typeof(decimal));
        dt_wy.Columns.Add("实退金额", typeof(decimal));
        dt_wy.Columns.Add("第三方支付交易流水号", typeof(string));
        dt_wy.Columns.Add("第三方支付退款流水号", typeof(string));
        dt_wy.Columns.Add("支付类型", typeof(string));
        dt_wy.Columns.Add("交易状态", typeof(string));
        dt_wy.Columns.Add("退款状态", typeof(string));
        dt_wy.Columns.Add("商户名称", typeof(string));
        dt_wy.Columns.Add("商品名称", typeof(string));
        dt_wy.Columns.Add("商户号", typeof(string));
        dt_wy.Columns.Add("接入应用ID", typeof(string));
        dt_wy.Columns.Add("第三方商户号", typeof(string));
        #endregion
        dt_wy.TableName = "ACCOUNT_LIST";
        System.Data.DataTable dt_his      = new System.Data.DataTable();
        DataTable             dtResulthis = new DataTable();
        tLoadHISData          tloadhis    = new tLoadHISData(gethisXml);
        IAsyncResult          result      = tloadhis.BeginInvoke(request_his, null, null);
        tLoadWYData           tloadwy     = new tLoadWYData(getDataList);
        IAsyncResult          result_WY   = tloadwy.BeginInvoke(request, null, null);
        string          strxmlhis         = tloadhis.EndInvoke(result);
        List <string[]> response2         = tloadwy.EndInvoke(result_WY);// gethisXml(request_his);
        //string strxmlhis = gethisXml(request_his);
        //tLoadWYData tloadwy = new tLoadWYData(getDataList);
        //IAsyncResult result_WY = tloadwy.BeginInvoke(request, null, null);
        dt_his      = GetDBdata.XmlToDataTable(strxmlhis);
        dtResulthis = GetDBdata.GetResult(dt_his);
        // HIS_RowsCount = dt_his.Rows.Count;

        foreach (DataRow dr in dtResulthis.Rows)
        {
            Counthis  += double.Parse(dr["Counthis"].ToString());
            Amounthis += double.Parse(dr["Amounthis"].ToString());
        }


        HIS_TotalFeeCount.Text = Convert.ToDecimal(Amounthis).ToString("f2") + "元";
        // HIS_TotalDealCount.Text = Convert.ToString(Counthis) + "笔";
        HIS_TotalFeeCount.Visible = false; HIS_TotalDealCount.Visible = false;

        try
        {
            //List<string[]> response = tloadwy.EndInvoke(result_WY);// getDataList(request); ;// getDataList(request);
            // List<string[]> response = response2;//getDataList(request);
            // List<string> result = new List<string>();
            //int _count = response.Count;
            sum_totalCount = response2.Count; //_count;

            for (int k = 0; k < sum_totalCount; k++)
            {
                dt_wy.Rows.Add(response2[k]);
            }

            this.GridView.DataSource = dt_wy.DefaultView;
            this.GridView.DataBind();
            for (int i = dt_his.Rows.Count - 1; i >= 0; i--)
            {
                for (int k = 0; k < dt_wy.Rows.Count; k++)
                {
                    if (dt_his.Rows[i][1].ToString() == dt_wy.Rows[k][1].ToString())
                    {
                        GridView.Rows[k].BackColor = System.Drawing.Color.Green;
                        //Logging.WriteHISlog("记录日志:","HIS的ORDER_ID="+dt_his.Rows[i][3].ToString()+ "\r\n"+"微医的平台订单号="+ dt_wy.Rows[k][11].ToString() + "\r\n" + "HIS的TRANS_NO="+dt_his.Rows[i][13].ToString()+"微医的HOSP_ORDER_ID = "+ dt_wy.Rows[k][1].ToString() + "\r\n" + "HIS的TRANS_TYPE=" + dt_his.Rows[i][1].ToString() + "\r\n" + "微医的ORDER_TYPE=" + dt_wy.Rows[k][2].ToString() + "");
                    }
                }
            }


            #region 统计所有数据
            dtResulthis   = GetDBdata.GetResult(dt_his);
            dtWYResulthis = GetDBdata.GetResult(dt_wy);
            DtAll         = GetDBdata.UniteDataTable(dtResulthis, dtWYResulthis, "合并Dt");
            DtAll.Columns.AddRange(new DataColumn[] { new DataColumn("different", typeof(double)) });
            DataRow drw             = DtAll.NewRow();
            double  different_money = 0.00;
            for (int i = 0; i < DtAll.Rows.Count; i++)
            {
                foreach (DataRow dr in DtAll.Rows)
                {
                    different_money            = different_money + (Convert.ToDouble(DtAll.Rows[i]["Amounthis"]) - Convert.ToDouble(DtAll.Rows[i]["wxAmount"]));
                    DtAll.Rows[i]["different"] = different_money.ToString("f2");
                    different_money            = 0;
                }
            }
            this.GridView_Count.DataSource = DtAll.DefaultView;
            this.GridView_Count.DataBind();
            #endregion
            #region 账不平的变红色

            for (int k = 0; k < DtAll.Rows.Count; k++)
            {
                if (DtAll.Rows[k][6].ToString() != "0")
                {
                    GridView_Count.Rows[k].BackColor = System.Drawing.Color.Red;
                }
            }
            #endregion
        }

        catch (Exception Exc)
        {
            Logging.WriteBuglog(Exc);
            return;
        }
        finally
        {
            string LogXml = GetDBdata.DataTable2Xml(dt_wy);
            Logging.WriteWYlog(txt_startDate.Text.Trim() + "至" + txt_endDate.Text.Trim() + "的明细日志", LogXml);
            Logging.WriteHISlog(txt_startDate.Text + "至" + txt_endDate.Text + "的日志", strxmlhis);
            //sw.Stop();
            //TimeSpan ts2 = sw.Elapsed;
            //Console.WriteLine("Stopwatch总共花费{0}ms.", ts2.TotalMilliseconds);   //结束耗时显示多久
            //Logging.WriteKeylog("Stopwatch总共花费",Convert.ToString(ts2.TotalMilliseconds));
        }
    }