salelist.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data;
using System.Data.SqlClient;
using DbPrvd;
using Common;

public partial class salelist : Pagging
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["User"] == null || Session["Role"] == null)
            Response.Write("<script type='text/javascript'>parent.document.location='timeout.htm';</script>");
        if (Session["Role"].ToString() != "管理员" && Session["Role"].ToString() != "收银员")
        {
            Response.Write("<script type='text/javascript'>alert('您无权操作');history.go(-1);</script>");
        }

        PAGESIZE = 20;
        InitMember();
        Delete();
        BindCount();
        SetMember();
        BindReader();
        SetPageDiv_2(pageDiv);
    }
    private void BindCount()
    {
        string strSql = "select count(1) from [" + SqlHelper.Tbpre + "sale]  ";

        object rv = SqlHelper.ExecuteScalar(SqlHelper.ConStr, CommandType.Text, strSql);
        _recordCount = int.Parse(rv.ToString());
    }

    private void BindReader()
    {
        string strSql = "select TT.* from " +
                "(select top " + _currentSize + " T.* from " +
                "(select top " + _pageIndex * PAGESIZE + " A.*,B.name from [" + SqlHelper.Tbpre + "sale] as A " +
                "inner join [" + SqlHelper.Tbpre + "product] as B on A.pid=B.sid  ";

        strSql += " order by id desc)t " +
                "order by t.id  )tt " +
                "order by tt.id desc";
        _infoReader = SqlHelper.ExecuteReader(SqlHelper.ConStr, CommandType.Text, strSql);
    }

    private void Delete()
    {
        if (!string.IsNullOrEmpty(Request.Form["hdID"]) && RegexHelper.isNumberR(Request.Form["hdID"]))
        {
            int id = int.Parse(Request.Form["hdID"]);


            // 查看是否是已审核记录
            string Query = "select isconfirm from [" + SqlHelper.Tbpre + "sale] where id=" + id;