WebUI/present/Ajaxchange.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

namespace hyst.present
{
    using DBUtility;
    using Model;
    using System;
    using System.Data;
    using System.Text;
    using System.Web.UI;

    public class Ajaxchange : Page
    {
        private BaseClass bc = new BaseClass();

        protected void Page_Load(object sender, EventArgs e)
        {
            try
            {
                string cnum = "YH" + DateTime.Now.ToString("yyyyMMddHHmmssffff");
                string mnum = base.Request.QueryString["mnum"].ToString();
                string jifen = base.Request.QueryString["jifen"].ToString();
                string gid = base.Request.QueryString["gid"].ToString();
                string sqlft = "select * from membersinfo where  mNum ='" + base.Request.QueryString["mnum"].ToString() + "'";
                DataTable dt = this.bc.ReadTable(sqlft);
                if (dt.Rows.Count > 0)
                {
                    double jifens = double.Parse(dt.Rows[0]["mIntegral"].ToString()) - double.Parse(base.Request.QueryString["jifen"]);
                    string name3 = "update  membersinfo set  mIntegral=convert(decimal(18, 0),mIntegral)-" + jifen + " where mNum ='" + base.Request.QueryString["mnum"].ToString() + "' ";
                    string sqlf = (name3 + "insert into prsentchange(cNum,cMnum,cGnum,cShopname,cDate,cMaker,jifen) values('" + cnum + "','" + mnum + "','" + gid + "','" + PublicMethod.GetSessionValue("shopname") + "','" + DateTime.Now.ToString("yyyy-MM-dd") + "','" + PublicMethod.GetSessionValue("names") + "','" + jifen + "')") + " update present set gCount=gCount-1 where gNum='" + gid + "' ";
                    this.bc.execsql(sqlf);
                    string str = "会员卡号：" + base.Request.QueryString["mnum"].ToString() + ",会员姓名：" + dt.Rows[0]["mName"].ToString() + ",积分：" + jifen + ",兑换店铺：" + PublicMethod.GetSessionValue("shopname");
                    string strl = " insert into WorkNote(Wn_Person,Wn_Time,Wn_type,wn_dianpu,wn_ip,wn_Remark) values ('" + PublicMethod.GetSessionValue("names") + "','" + DateTime.Now.ToString() + "','积分兑换','" + PublicMethod.GetSessionValue("shopnum") + "','" + Userinfo.getIPAddress() + "''," + str + "')";
                    this.bc.execsql(strl);
                    string sqlsms = "select xuhao,Pwd,type,states,contents from messageset where type = 'sms'";
                    DataTable dtsms = this.bc.ReadTable(sqlsms);
                    if (dtsms.Rows[0]["states"].ToString() == "1")
                    {
                        StringBuilder balance = new StringBuilder("0000000000");
                        int result = EUCPComm.GetBalance(dtsms.Rows[0]["xuhao"].ToString(), balance);
                        string _Response = "";
                        string mybalance = balance.ToString(0, balance.Length - 2);
                        if (result == 1)
                        {
                            _Response = mybalance;
                        }
                        if (int.Parse(_Response) > 1)
                        {
                            string sms = "";
                            DataTable d = this.bc.ReadTable(" select * from systemSms where sName='积分兑换' ");
                            if ((d.Rows.Count > 0) && (d.Rows[0]["sIsEnable"].ToString() == "1"))
                            {
                                double name6 = double.Parse(dt.Rows[0]["mBalance"].ToString()) + double.Parse(dt.Rows[0]["mBalanceGive"].ToString());
                                sms = Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(Userinfo.GetReplace(d.Rows[0]["sRemark"].ToString(), "{姓名}", dt.Rows[0]["mName"].ToString()), "{性别}", dt.Rows[0]["mSex"].ToString()), "{当前日期}", DateTime.Now.ToString("yyyy-MM-dd HH:mm")), "{店铺}", PublicMethod.GetSessionValue("shopname")), "{扣除积分}", base.Request.QueryString["jifen"]), "{剩余积分}", jifens.ToString()), "{储值余额}", dt.Rows[0]["mBalance"].ToString()), "{赠送余额}", dt.Rows[0]["mBalanceGive"].ToString()), "{总余额}", name6.ToString()), "{到期时间}", dt.Rows[0]["mPastdate"].ToString()) + dtsms.Rows[0]["contents"].ToString();
                                EUCPComm.SendSMS(dtsms.Rows[0]["xuhao"].ToString(), dt.Rows[0]["mMobile"].ToString(), sms, "");
                            }
                        }
                    }
                    base.Response.Write("true");
                }
                else
                {