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(); }
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(); }
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); }
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();; } }
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(); } }