Example #1
0
    protected void bthy_Click(object sender, EventArgs e)
    {
        Button   bthf    = ((Button)sender);
        int      index   = ((System.Web.UI.WebControls.GridViewRow)(bthf.Parent.Parent)).RowIndex;
        string   strid   = ((Label)this.JXGrid1.Rows[index].Cells[0].FindControl("lbn_xzdh")).Text;
        KFB_PTZD mo_PTZD = new KFB_PTZD();

        mo_PTZD.N_XZDH  = strid;
        mo_PTZD.N_DEL   = 0;
        mo_PTZD.N_DELYY = "";
        mo_PTZD.N_XGJL  = "R;re_zdcx;" + mUserID + ";" + GetIp() + ";" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
        if (this.objReportDB.IsGZ(strid, "1"))
        {
            if (objReportDB.CheckBet(strid, "4"))
            {
                if (this.rdon_gz.SelectedValue.Equals("1"))
                {
                    objReportDB.delO(mo_PTZD);
                }
                else
                {
                    objReportDB.del(mo_PTZD);
                }
                objReportDB.ModifyRecord(strid, "4");
            }
            else
            {
                this.ShowMsg("已过账注单不能恢复,如需恢复请cs创建注单号");
                return;
            }
        }
        else
        {
            if (this.rdon_gz.SelectedValue.Equals("1"))
            {
                objReportDB.delO(mo_PTZD);
            }
            else
            {
                objReportDB.del(mo_PTZD);
            }
        }
        string strgg = ((Label)this.JXGrid1.Rows[index].Cells[0].FindControl("lbn_gsty")).Text;

        if (strgg.Equals("3") || strgg.Equals("7"))
        {
            string strxzje = this.JXGrid1.Rows[index].Cells[4].Text;
            string strhydh = this.JXGrid1.Rows[index].Cells[2].Text;
            objReportDB.HuiFuHYYE(strhydh, -decimal.Parse(strxzje) / 10000);
            if (this.rdon_gz.SelectedValue.Equals("1"))
            {
                objReportDB.updatejsO(strid, 0);
            }
            else
            {
                objReportDB.updatejs(strid, 0);
            }
        }
        SetGrid();
    }
Example #2
0
    protected void btqbxg_Click(object sender, EventArgs e)
    {
        KFB_PTZD mo_PTZD = new KFB_PTZD();

        string[] strupdate = this.hidupdate.Value.Split(';');
        this.objReportDB.XGZDZWRQ(strupdate[0], strupdate[1], strupdate[2], strupdate[3], "");
        this.ShowMsg("修改成功!");
        SetGrid();
    }
Example #3
0
    protected void btxg_Click(object sender, EventArgs e)
    {
        Button   btxg    = ((Button)sender);
        int      index   = ((System.Web.UI.WebControls.GridViewRow)(btxg.Parent.Parent)).RowIndex;
        string   strid   = ((Label)this.JXGrid1.Rows[index].Cells[0].FindControl("lbn_xzdh")).Text;
        KFB_PTZD mo_PTZD = new KFB_PTZD();

        this.objReportDB.XGZDZWRQ("", "", "", "", strid);
        this.ShowMsg("修改成功!");
        SetGrid();
    }
    /// <summary>
    /// 计算过关注单
    /// </summary>
    /// <param name="model"></param>
    public void CountPassBill(KFB_PTZD model)
    {
        StringBuilder strSql = new StringBuilder();

        strSql.Append("update KFB_PTZD set ");
        strSql.Append("N_SYJG=:N_SYJG,");
        strSql.Append("N_HYJG=:N_HYJG,");
        strSql.Append("N_DLSJG=:N_DLSJG,");
        strSql.Append("N_ZDLJG=:N_ZDLJG,");
        strSql.Append("N_GDJG=:N_GDJG,");
        strSql.Append("N_DGDJG=:N_DGDJG,");
        strSql.Append("N_ZJJG=:N_ZJJG,");
        strSql.Append("N_DZJJG=:N_DZJJG,");
        strSql.Append("N_GSJG=:N_GSJG,");
        strSql.Append("n_js=:n_js,");
        strSql.Append("N_DLSWCZ=:N_DLSWCZ ");
        strSql.Append(" where n_xzdh=:n_xzdh  and  n_gsty=3");
        OracleParameter[] parameters =
        {
            new OracleParameter(":n_xzdh",   OracleType.VarChar, 20),
            new OracleParameter(":N_SYJG",   OracleType.Float,   22),
            new OracleParameter(":N_HYJG",   OracleType.Float,   22),
            new OracleParameter(":N_DLSJG",  OracleType.Float,   22),
            new OracleParameter(":N_ZDLJG",  OracleType.Float,   22),
            new OracleParameter(":N_GDJG",   OracleType.Float,   22),
            new OracleParameter(":N_DGDJG",  OracleType.Float,   22),
            new OracleParameter(":N_ZJJG",   OracleType.Float,   22),
            new OracleParameter(":N_GSJG",   OracleType.Float,   22),
            new OracleParameter(":n_js",     OracleType.Number,   4),
            new OracleParameter(":N_DZJJG",  OracleType.Float,   22),
            new OracleParameter(":N_DLSWCZ", OracleType.Float, 22)
        };
        parameters[0].Value  = model.N_XZDH;
        parameters[1].Value  = model.N_SYJG;
        parameters[2].Value  = model.N_HYJG;
        parameters[3].Value  = model.N_DLSJG;
        parameters[4].Value  = model.N_ZDLJG;
        parameters[5].Value  = model.N_GDJG;
        parameters[6].Value  = model.N_DGDJG;
        parameters[7].Value  = model.N_ZJJG;
        parameters[8].Value  = model.N_GSJG;
        parameters[9].Value  = model.N_JS;
        parameters[10].Value = model.N_DZJJG;
        parameters[11].Value = model.N_DLSWCZ;
        DbHelperOra.ExecuteSql(conn, tran, strSql.ToString(), parameters);
    }
Example #5
0
    protected void Page_Load(object sender, EventArgs e)
    {
        if (this.Request["nid"] != null)
        {
            string   strnid  = this.Request["nid"].ToString();
            KFB_PTZD mo_PTZD = objReportDB.GetModel(strnid);
            string   strmes  = "";
            if (mo_PTZD.N_QR.ToString().Equals("1"))
            {
                strmes = "PS:確認時間已過,會員下注已經成功!";
            }
            else
            {
                if (this.Request["status"].Equals("0"))
                {
                    //o_PTZD.COZDQR(strnid,"1", "0");
                    if (mo_PTZD != null)                           //如果注单存在  做删单操作
                    {
                        string  strdel = mo_PTZD.N_DEL.ToString(); //注单时候删除标识位  0或者“”为未删除   1表示已经删除
                        decimal n_xzje = (decimal)mo_PTZD.N_XZJE;
                        objReportDB.Delete(strnid);
                        //KingOfBall.BLL.KFB_COUNT_BLL count = new KingOfBall.BLL.KFB_COUNT_BLL();
                        //int no = count.GetNo();
                        //count.InsertBillLog(no, mo_PTZD.N_HYDH, mo_PTZD.N_XZDH, mo_PTZD.N_QSBH.Value.ToString(), n_xzje, 0, 0, DateTime.Now, "6");
                        if (!n_xzje.Equals(0) && strdel != "1")//下注金额不等于0并且该注单未被删除,此时需要恢复会员的额度
                        {
                            objReportDB.HuiFuHYYE(mo_PTZD.N_HYDH, n_xzje / 10000);
                        }
                    }
                }
                else
                {
                    objReportDB.ZDQR(strnid, "1");
                }
                // strmes = "操作成功!";
                strmes = "";
            }
            //if (mo_PTZD == null)// && mo_PTZD.N_QR.ToString().Equals("1"))
            //{
            //    strmes = "PS:確認時間已過,該筆注單已被刪除!";
            //}
            //else
            //{
            //    o_PTZD.ZDQR(strnid, "1");
            //}
            this.Response.Write(strmes);
            this.Response.Flush();
            this.Response.End();;
        }
        if (this.Request["time"] != null && this.Request["type"] != null)
        {
            string strreturn = "";
            string strtime   = this.Request["time"].ToString();
            string strtype   = this.Request["type"].ToString();
            if (strtime.Equals(""))
            {
                strtime = this.objReportDB.GetSystemTime().ToString("yyyy/MM/dd HH:mm:ss");
            }
            strtype = strtype.Replace("ch", "b_");
            string  strbslx = "'l_zdrf','l_zddx','l_zddy','l_zdhj','l_zdds','l_zdye'";
            DataSet ds      = objReportDB.GetZDQuick(strtime.Replace('-', '/'), strtype, strbslx);
            // DataSet ds = o_PTZD.GetQuick("2008/01/01 12:00:00", strtype);
            XmlDocument CreateXml = new XmlDocument();
            XmlNode     xmlNode   = CreateXml.CreateNode(XmlNodeType.XmlDeclaration, "", "");
            CreateXml.AppendChild(xmlNode);

            XmlElement xmlRoot = CreateXml.CreateElement("", "ZDTB", "");
            CreateXml.AppendChild(xmlRoot);

            XmlElement xmlTime = CreateXml.CreateElement("", "Time", "");
            //XmlText xmlTimeText = CreateXml.CreateTextNode(DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss").Replace('-', '/'));
            XmlText xmlTimeText = CreateXml.CreateTextNode(strtime.Replace('-', '/'));
            xmlTime.AppendChild(xmlTimeText);
            CreateXml.ChildNodes[1].AppendChild(xmlTime);

            if (ds.Tables[0].Rows.Count > 0)
            {
                string strn_xzdh = "";
                string strn_xzrq = "";
                string strn_hydh = "";
                string strnr     = "";
                string strn_xzwf = "";
                string strn_xzje = "";
                string strlx     = "";
                string strnid    = "";
                string strwxdj   = "";
                string strdbzd   = "";
                string strXZNR   = "";
                string strQR     = "";
                string strdx     = "";
                string strdxbl   = "";
                string strdxxt   = "";

                for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
                {
                    strn_xzdh = ds.Tables[0].Rows[i]["N_XZDH"].ToString();
                    strn_xzrq = DateTime.Parse(ds.Tables[0].Rows[i]["N_XZRQ"].ToString()).ToString("yyyy-MM-dd HH:mm:ss");
                    strn_hydh = ds.Tables[0].Rows[i]["N_HYDH"].ToString();
                    strn_xzje = ds.Tables[0].Rows[i]["N_XZJE"].ToString();
                    strn_xzwf = ds.Tables[0].Rows[i]["N_XZWF"].ToString();
                    strlx     = ds.Tables[0].Rows[i]["N_BSLX"].ToString();
                    strnid    = ds.Tables[0].Rows[i]["N_ID"].ToString();
                    strwxdj   = ds.Tables[0].Rows[i]["N_WXDJ"].ToString();
                    strdbzd   = ds.Tables[0].Rows[i]["N_DBZD"].ToString();
                    strXZNR   = ds.Tables[0].Rows[i]["XZNR"].ToString();
                    strQR     = ds.Tables[0].Rows[i]["N_QR"].ToString();
                    strdx     = ds.Tables[0].Rows[i]["N_DX"].ToString();
                    strdxbl   = ds.Tables[0].Rows[i]["N_DXBL"].ToString();
                    strdxxt   = ds.Tables[0].Rows[i]["N_DXXT"].ToString();

                    XmlElement xmlRow = CreateXml.CreateElement("", "Rows", "");
                    CreateXml.ChildNodes[1].AppendChild(xmlRow);
                    //下注單號
                    XmlElement elemtEQUIP_NAME = CreateXml.CreateElement("", "N_XZDH", "");
                    XmlText    EQUIP_NAMEtext  = CreateXml.CreateTextNode(strn_xzdh);
                    elemtEQUIP_NAME.AppendChild(EQUIP_NAMEtext);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(elemtEQUIP_NAME);
                    //下注日期
                    XmlElement elemtMapPath = CreateXml.CreateElement("", "N_XZRQ", "");
                    XmlText    MapPathtext  = CreateXml.CreateTextNode(strn_xzrq);
                    elemtMapPath.AppendChild(MapPathtext);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(elemtMapPath);
                    //會員代號
                    XmlElement elemtPURPOSE = CreateXml.CreateElement("", "N_HYDH", "");
                    XmlText    PURPOSEtext  = CreateXml.CreateTextNode(strn_hydh);
                    elemtPURPOSE.AppendChild(PURPOSEtext);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(elemtPURPOSE);
                    //下注金額
                    XmlElement eleN_XZJE  = CreateXml.CreateElement("", "N_XZJE", "");
                    XmlText    N_XZJEText = CreateXml.CreateTextNode(strn_xzje);
                    eleN_XZJE.AppendChild(N_XZJEText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_XZJE);
                    //下注金額
                    XmlElement eleN_XZWF = CreateXml.CreateElement("", "N_XZWF", "");
                    //XmlText N_XZWFText = CreateXml.CreateTextNode(Comm.ChType(strn_xzwf));
                    XmlText N_XZWFText = CreateXml.CreateTextNode(Comm.GetPlayName(strn_xzwf, "2"));
                    eleN_XZWF.AppendChild(N_XZWFText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_XZWF);



                    if (!strn_xzwf.Equals("l_gg"))
                    {
                        // strnr = dsnr.Tables[0].Rows[0]["n_xznr"].ToString();
                        strnr = strXZNR.Replace("#", "");
                    }
                    else
                    {
                        strnr = " <table  class='eng_12_bk'> ";
                        string[] strsplit = strXZNR.Split('#');
                        for (int j = 0; j < strsplit.Length - 1; j++)
                        {
                            strnr = strnr + " <tr> <td width='10' bgcolor='#FFFFFF' > " + Convert.ToString(j + 1) + "</td> <td bgcolor='#FFFFFF' >" + strsplit[j].ToString() + " </td> </tr> ";
                        }
                        strnr = strnr + " </table > ";
                    }

                    //下注内容
                    XmlElement eleN_XZNR  = CreateXml.CreateElement("", "N_XZNR", "");
                    XmlText    N_XZNRText = CreateXml.CreateTextNode(string.Format(strnr, "", ""));
                    eleN_XZNR.AppendChild(N_XZNRText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_XZNR);

                    //N_ID
                    XmlElement eleN_ID    = CreateXml.CreateElement("", "N_ID", "");
                    XmlText    N_N_IDText = CreateXml.CreateTextNode(Comm.ChType(strnid));
                    eleN_ID.AppendChild(N_N_IDText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_ID);

                    //危險等級
                    XmlElement eleN_WXDJ  = CreateXml.CreateElement("", "N_WXDJ", "");
                    XmlText    N_WXDJText = CreateXml.CreateTextNode(Comm.ChType(strwxdj));
                    eleN_WXDJ.AppendChild(N_WXDJText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_WXDJ);

                    //大筆注單
                    XmlElement eleN_DBZD  = CreateXml.CreateElement("", "N_DBZD", "");
                    XmlText    N_DBZDText = CreateXml.CreateTextNode(Comm.ChType(strdbzd));
                    eleN_DBZD.AppendChild(N_DBZDText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_DBZD);

                    //是否确认
                    XmlElement eleN_QR  = CreateXml.CreateElement("", "N_QR", "");
                    XmlText    N_QRText = CreateXml.CreateTextNode(Comm.ChType(strdbzd));
                    eleN_QR.AppendChild(N_QRText);
                    CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_QR);

                    //DA xiao qiu tou
                    if ((strn_xzwf.Equals("l_zddx") || strn_xzwf.Equals("l_dx")) && strdx.Equals("0") && strdxbl.Equals("0") && strdxxt.Equals("0"))
                    {
                        XmlElement eleN_DXQT  = CreateXml.CreateElement("", "N_DXQT", "");
                        XmlText    N_DXQTText = CreateXml.CreateTextNode("1");
                        eleN_DXQT.AppendChild(N_DXQTText);
                        CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_DXQT);
                    }
                    else
                    {
                        XmlElement eleN_DXQT  = CreateXml.CreateElement("", "N_DXQT", "");
                        XmlText    N_DXQTText = CreateXml.CreateTextNode("0");
                        eleN_DXQT.AppendChild(N_DXQTText);
                        CreateXml.ChildNodes[1].ChildNodes[i + 1].AppendChild(eleN_DXQT);
                    }
                }
            }
            strreturn = CreateXml.InnerXml.ToString();
            this.Response.Write(strreturn);
            this.Response.Flush();
            this.Response.End();;
        }
    }
Example #6
0
    protected void btdel_Click(object sender, EventArgs e)
    {
        Button   btgb    = ((Button)sender);
        int      index   = ((System.Web.UI.WebControls.GridViewRow)(btgb.Parent.Parent)).RowIndex;
        string   strid   = ((Label)this.JXGrid1.Rows[index].Cells[0].FindControl("lbn_xzdh")).Text;
        KFB_PTZD mo_PTZD = new KFB_PTZD();

        mo_PTZD.N_XZDH  = strid;
        mo_PTZD.N_DEL   = 1;
        mo_PTZD.N_DELYY = this.delyy.Value;
        mo_PTZD.N_XGJL  = "D;re_zdcx;" + mUserID + ";" + GetIp() + ";" + DateTime.Now.ToString("yyyy/MM/dd HH:mm:ss");
        mo_PTZD.N_HYJG  = 0;
        if (objReportDB.IsGZ(strid, "1"))
        {
            //if (o_PTZD.CheckBet(strid, "0") || o_PTZD.CheckBet(strid, "3"))
            if (objReportDB.CheckBet(strid, "0"))
            {
                if (this.rdon_gz.SelectedValue.Equals("1"))
                {
                    objReportDB.delO(mo_PTZD);
                }
                else
                {
                    objReportDB.del(mo_PTZD);
                }

                objReportDB.ModifyRecord(strid, "0");
                //o_PTZD.ModifyRecord(strid, "3");
            }
            else
            {
                this.ShowMsg("已过账注单不能删除,如需删除请cs创建注单号");
                return;
            }
        }
        else
        {
            if (this.rdon_gz.SelectedValue.Equals("1"))
            {
                objReportDB.delO(mo_PTZD);
            }
            else
            {
                objReportDB.del(mo_PTZD);
            }
        }


        //if (o_PTZD.IsGZ(strid, "1") && (o_PTZD.CheckBet(strid, "0") || o_PTZD.CheckBet(strid, "2")))
        //{
        //    if (this.rdon_gz.SelectedValue.Equals("1"))
        //        o_PTZD.delO(mo_PTZD);
        //    else
        //        o_PTZD.del(mo_PTZD);

        //    o_PTZD.ModifyRecord(strid);
        //}
        //else
        //{


        //    ShowPageMesg("00000", "已过账注单不能删除,如需删除请cs创建注单号");
        //    return;
        //}
        string strgg = ((Label)this.JXGrid1.Rows[index].Cells[0].FindControl("lbn_gsty")).Text;

        if (strgg.Equals("3") || strgg.Equals("7"))
        {
            string strxzje = this.JXGrid1.Rows[index].Cells[4].Text;
            string strhydh = this.JXGrid1.Rows[index].Cells[2].Text;
            string strhyjg = this.JXGrid1.Rows[index].Cells[5].Text;
            if (strhyjg.Equals(""))
            {
                strhyjg = "0";
            }
            if (!this.objReportDB.getGGCOL(strid, "n_js").Equals("1"))//未計算
            {
                objReportDB.HuiFuHYYE(strhydh, decimal.Parse(strxzje) / 10000);
            }
            else
            {
                objReportDB.HuiFuHYYE(strhydh, -decimal.Parse(strhyjg) / 10000);
            }
        }
        SetGrid();
    }
    /// <summary>
    ///
    /// </summary>
    /// <param name="strrq"></param>
    /// <param name="strball"></param>
    public void BallPassCount(string strrq, string strball)
    {
        //KingOfBall.BLL.KFB_COUNT_BLL count = new KingOfBall.BLL.KFB_COUNT_BLL();
        try
        {
            Decimal gsjg    = 0;
            decimal strgszc = 100M;
            //BY KEWEN
            // KingOfBall.BLL.KFB_MRZJ_BLL O_MRZJ = new KingOfBall.BLL.KFB_MRZJ_BLL();
            // KFB_MRZJ M_MRZJ = new KFB_MRZJ();

            //KingOfBall.BLL.KFB_PTZD_BLL o_PTZD = new KingOfBall.BLL.KFB_PTZD_BLL();
            DataSet  ds      = GetPassBillList(Convert.ToDateTime(strrq), strball);
            KFB_PTZD mo_PTZD = new KFB_PTZD();
            foreach (DataRow dr in ds.Tables[0].Rows)
            {
                //DataRow dr = ds.Tables[0].Rows[i];
                Decimal dhyty     = Convert.ToDecimal(dr["n_ty"].ToString());
                int     bsjscount = PassCountNum(dr["n_xzdh"].ToString());
                if (bsjscount > 0)
                {
                    continue;
                }
                //bool CheckGG = new KingOfBall.BLL.KFB_BET_BLL().CheckGG(dr["n_xzdh"].ToString());
                //if (CheckGG)
                //    continue;
                decimal tempHYJG = 0;
                string  tempJS   = dr["n_js"].ToString();
                string  tempHYDH = dr["n_hydh"].ToString();
                string  tempDEL  = GetColValue(dr["n_xzdh"].ToString(), "n_del");
                if (tempJS.Equals("1"))
                {
                    tempHYJG = decimal.Parse(GetColValue(dr["n_xzdh"].ToString(), "n_hyjg"));
                }

                //type
                string strbslx = dr["N_BSLX"].ToString();

                decimal strdlty  = Convert.ToDecimal(dr["n_dlty"]);
                decimal strzdlty = Convert.ToDecimal(dr["n_zdlty"]);
                decimal strgdty  = Convert.ToDecimal(dr["n_gdty"]);
                decimal strzgdty = Convert.ToDecimal(dr["n_dgdty"]);
                decimal strzjty  = Convert.ToDecimal(dr["n_zjty"]);
                decimal strdzjty = Convert.ToDecimal(dr["n_dzjty"]);

                decimal strdlcz  = Convert.ToDecimal(dr["n_dlcz"]);
                decimal strzdlcz = Convert.ToDecimal(dr["n_zdlcz"]);
                decimal strgdcz  = Convert.ToDecimal(dr["n_gdcz"]);
                decimal strzgdcz = Convert.ToDecimal(dr["n_zgdcz"]);
                decimal strzjcz  = Convert.ToDecimal(dr["n_zjcz"]);
                decimal strdzjcz = Convert.ToDecimal(dr["n_dzjcz"]);
                string  strjs    = dr["n_js"].ToString();

                string  strkyje = dr["n_kyje"].ToString();
                Decimal dljg    = 0;
                Decimal zdljg   = 0;
                Decimal gdjg    = 0;
                Decimal dgdjg   = 0;
                Decimal zjjg    = 0;
                Decimal dzjjg   = 0;
                string  strid   = dr["n_xzdh"].ToString();
                Decimal dxzje   = Convert.ToDecimal(dr["n_xzje"].ToString());
                DataSet dsgg    = GetPassResult(strid);
                Decimal kyje    = 1;
                //Decimal dcs = 1;
                Decimal dlscz   = 0;
                bool    che     = true;
                string  matchId = "";
                foreach (DataRow drr in dsgg.Tables[0].Rows)
                {
                    Decimal ggjg = Convert.ToDecimal(drr["N_GGJG"].ToString());
                    matchId += drr["N_QSBH"].ToString() + ",";
                    if (ggjg != -1)
                    {
                        if (ggjg < 0)
                        {
                            if (Math.Abs(ggjg) == dxzje)
                            {
                                che = false;
                            }
                        }


                        kyje = kyje * (dxzje + ggjg) / dxzje;
                    }
                    // dcs = dcs * dxzje;
                }
                if (!che)
                {
                    kyje = -1 * dxzje * (1 - (dhyty / 10000));
                }
                else
                {
                    kyje = (dxzje * kyje) - dxzje;
                }
                //if (kyje > 1000000)
                //{
                //    kyje = 1000000;
                //}
                //原来是高于100万 改为高于20万
                if (kyje > 200000)
                {
                    kyje = 200000;
                }

                mo_PTZD.N_SYJG = (kyje);
                mo_PTZD.N_HYJG = (kyje);
                mo_PTZD.N_XZDH = strid;


                if ((kyje) == 0)
                {
                    dljg  = 0;
                    zdljg = 0;
                    gdjg  = 0;
                    dgdjg = 0;
                    zjjg  = 0;
                    dzjjg = 0;
                    dlscz = 0;
                    gsjg  = 0;
                }
                else if ((kyje) > 0)
                {
                    dljg  = (kyje) * (1 - (strdlcz) / 100);
                    zdljg = (kyje) * (1 - (strzdlcz) / 100);
                    gdjg  = (kyje) * (1 - (strgdcz) / 100);
                    dgdjg = (kyje) * (1 - (strzgdcz) / 100);
                    zjjg  = (kyje) * (1 - (strzjcz) / 100);
                    dzjjg = (kyje) * (1 - (strdzjcz) / 100);
                    dlscz = (kyje);

                    //strgszc = Comm.GetZC(strbslx, M_MRZJ);
                    gsjg = (kyje) * (1 - (strgszc) / 100);
                }
                else if (che)
                {
                    mo_PTZD.N_SYJG = (kyje) + ((-1) * (kyje) * (dhyty) / 10000);
                    mo_PTZD.N_HYJG = (kyje) + ((-1) * (kyje) * (dhyty) / 10000);
                    dljg           = ((kyje) + ((-1) * (kyje) * (strdlty) / 10000)) * (1 - (strdlcz) / 100);
                    zdljg          = ((kyje) + ((-1) * (kyje) * (strzdlty) / 10000)) * (1 - (strzdlcz) / 100);
                    gdjg           = ((kyje) + ((-1) * (kyje) * (strgdty) / 10000)) * (1 - (strgdcz) / 100);
                    dgdjg          = ((kyje) + ((-1) * (kyje) * (strzgdty) / 10000)) * (1 - (strzgdcz) / 100);
                    zjjg           = ((kyje) + ((-1) * (kyje) * (strzjty) / 10000)) * (1 - (strzjcz) / 100);
                    dzjjg          = ((kyje) + ((-1) * (kyje) * (strdzjty) / 10000)) * (1 - (strdzjcz) / 100);
                    dlscz          = ((kyje) + ((-1) * (kyje) * (strdlty) / 10000));

                    //strgszc = Comm.GetZC(strbslx, M_MRZJ);
                    gsjg = ((kyje) + ((-1) * (kyje) * (strdzjty) / 10000)) * (1 - (strgszc) / 100);
                }
                else
                {
                    //dljg = (kyje) * (1 - (strdlcz) / 100) + (dxzje) * (((strdlty) - dhyty) / 10000);
                    //zdljg = (kyje) * (1 - (strzdlcz) / 100) + (dxzje) * (((strzdlty) - (strdlty)) / 10000);
                    //gdjg = (kyje) * (1 - (strgdcz) / 100) + (dxzje) * (((strgdty) - (strzdlty)) / 10000);
                    //dgdjg = (kyje) * (1 - (strzgdcz) / 100) + (dxzje) * (((strzgdty) - (strgdty)) / 10000);
                    //zjjg = (kyje) * (1 - (strzjcz) / 100) + (dxzje) * (((strzjty) - (strzgdty)) / 10000);
                    //dzjjg = (kyje) * (1 - (strdzjcz) / 100) + (dxzje) * (((strdzjty) - (strzjty)) / 10000);
                    dljg  = ((-1) * (dxzje) + ((dxzje) * (strdlty) / 10000)) * (1 - (strdlcz) / 100);
                    zdljg = ((-1) * (dxzje) + ((dxzje) * (strzdlty) / 10000)) * (1 - (strzdlcz) / 100);
                    gdjg  = ((-1) * (dxzje) + ((dxzje) * (strgdty) / 10000)) * (1 - (strgdcz) / 100);
                    dgdjg = ((-1) * (dxzje) + ((dxzje) * (strzgdty) / 10000)) * (1 - (strzgdcz) / 100);
                    zjjg  = ((-1) * (dxzje) + ((dxzje) * (strzjty) / 10000)) * (1 - (strzjcz) / 100);
                    dzjjg = ((-1) * (dxzje) + ((dxzje) * (strdzjty) / 10000)) * (1 - (strdzjcz) / 100);
                    dlscz = ((-1) * (dxzje) + ((dxzje) * (strdlty) / 10000));

                    //strgszc = Comm.GetZC(strbslx, M_MRZJ);
                    gsjg = ((-1) * (dxzje) + ((dxzje) * (strdzjty) / 10000)) * (1 - (strgszc) / 100);
                }



                mo_PTZD.N_DLSJG  = dljg;
                mo_PTZD.N_ZDLJG  = zdljg;
                mo_PTZD.N_GDJG   = gdjg;
                mo_PTZD.N_DGDJG  = dgdjg;
                mo_PTZD.N_ZJJG   = zjjg;
                mo_PTZD.N_GSJG   = gsjg;
                mo_PTZD.N_DZJJG  = dzjjg;
                mo_PTZD.N_JS     = 1;
                mo_PTZD.N_DLSWCZ = dlscz;

                //KingOfBall.BLL.KFB_HYGL_BLL o_HYGL = new KingOfBall.BLL.KFB_HYGL_BLL();
                mo_PTZD.N_HYDH = dr["n_hydh"].ToString();
                mo_PTZD.N_XZJE = Convert.ToDecimal(dr["n_xzje"]);
                decimal creditBeore = GetCredit(mo_PTZD.N_HYDH);
                int     no          = GetNo();
                string  type        = "";
                Tran();
                if (!tempDEL.Equals("1"))
                {
                    if (tempJS.Equals("1"))    //已進行過計算
                    {
                        ReSetCredit(tempHYDH, (mo_PTZD.N_HYJG.Value - tempHYJG) / 10000);
                        type = "3";
                    }
                    else
                    {
                        ReSetCredit(tempHYDH, (dxzje + mo_PTZD.N_HYJG.Value) / 10000);
                        type = "2";
                    }
                }
                else
                {
                    if (tempJS.Equals("1"))    //已進行過計算
                    {
                        type = "3";
                    }
                    else
                    {
                        type = "2";
                    }
                }
                //注單存在
                bool bcz = Exists(dr["n_xzdh"].ToString());
                if (bcz)
                {
                    CountPassBill(mo_PTZD);
                }
                else
                {
                    ReCountPassBill(mo_PTZD);
                }
                DateTime sysDateNow  = GetSysDate();
                decimal  creditAfter = GetCredit(mo_PTZD.N_HYDH);
                InsertCreditLog(no, sysDateNow, type, mo_PTZD.N_HYDH, creditBeore * 10000M, creditAfter * 10000M);
                InsertBillLog(no, mo_PTZD.N_HYDH, mo_PTZD.N_XZDH, matchId.Substring(0, matchId.Length - 1), mo_PTZD.N_XZJE.Value, tempHYJG, mo_PTZD.N_HYJG.Value, sysDateNow, type);

                Commit();
            }
        }
        catch (Exception ex)
        {
            Rollback();
            //LogDB.Error("Count Error!!", ex);
        }
        finally
        {
            Close();
        }
    }