WebUI/Consumption/SYXF/AjaxAdd.aspx.cs

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

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

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

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

        protected void Page_Load(object sender, EventArgs e)
        {
            DataTable dt;
            string str;
            if (base.Request.QueryString["type"] == "addshop")
            {
                dt = PublicMethod.QueryDataset("select * from consumes where cNum='" + base.Request.QueryString["cNum"] + "' and csNum ='" + this.Session["shopnum"].ToString() + "' ").Tables[0];
                if (dt.Rows.Count > 0)
                {
                    string IsZeng = (dt.Rows[0]["IsZeng"].ToString() == "0") ? "是" : "否";
                    str = dt.Rows[0]["cId"].ToString() + "@" + dt.Rows[0]["cName"].ToString() + "@" + dt.Rows[0]["cPrice"].ToString() + "@" + dt.Rows[0]["cNum"].ToString() + "@" + IsZeng + "@" + dt.Rows[0]["cCount"].ToString();
                    base.Response.Write(str);
                }
                else
                {
                    base.Response.Write("false");
                }
            }
            else
            {
                string name5;
                if (base.Request.QueryString["type"] == "postDate")
                {
                    try
                    {
                        dt = PublicMethod.QueryDataset("select Id,C_Id from TemporaryCard where C_Id='" + base.Request.QueryString["cNum"] + "'").Tables[0];
                        if (dt.Rows.Count > 0)
                        {
                            base.Response.Write("临时卡@" + dt.Rows[0]["C_Id"].ToString());
                        }
                        else
                        {
                            string strsp;
                            DataTable dtLevel;
                            DataTable dtMbr = PublicMethod.QueryDataset("select mNum,mBalanceGive,mLevel,mName,mBalance,convert(varchar(100), mPastdate,23) as 'mPastdate',mType,mPwd,mIntegral,mStates from membersinfo where mNum='" + base.Request.QueryString["cNum"] + "'").Tables[0];
                            if (dtMbr.Rows.Count > 0)
                            {
                                if (dtMbr.Rows[0]["mStates"].ToString() == "0")
                                {
                                    if ((dtMbr.Rows[0]["mPastdate"].ToString() == "永久有效") || (DateTime.Parse(dtMbr.Rows[0]["mPastdate"].ToString()) > DateTime.Now))
                                    {
                                        strsp = dtMbr.Rows[0]["mType"].ToString() + "@" + dtMbr.Rows[0]["mLevel"].ToString() + "@" + dtMbr.Rows[0]["mName"].ToString() + "@" + dtMbr.Rows[0]["mBalance"].ToString() + "@" + dtMbr.Rows[0]["mPastdate"].ToString() + "@" + dtMbr.Rows[0]["mNum"].ToString() + "@" + DESEncrypt.Decrypt(dtMbr.Rows[0]["mPwd"].ToString()) + "@" + dtMbr.Rows[0]["mIntegral"].ToString();
                                        dtLevel = PublicMethod.QueryDataset("select lName,lDiscount,ljifen from memberlevel where lNum='" + dtMbr.Rows[0]["mLevel"].ToString() + "'").Tables[0];
                                        if (dtLevel.Rows.Count > 0)
                                        {
                                            name5 = strsp;