lsquery.aspx.cs

本系统主要内容是围绕图书销售管理系统而展开讨论的

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class TSLS_LSQuery : System.Web.UI.Page
{
    SqlCommand cmd=null;
    SqlConnection conn = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["connection"]);
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            BindGrid();
        }
    }
    public void BindGrid()
    {
        SqlDataReader dataR = null;
        DataTable dt = new DataTable();
        SqlDataAdapter dtcmd;
        string str1 = String.Empty;
        string str2 = String.Empty;        
        if (query_content.Text != "")            
             str1 = " and " + query_tj.SelectedItem.Value + " like '%" + query_content.Text + "%'";
        str2 = "select count(*) as nums,sum(outstorenum) as outstorenums,sum(outstorenum*price) as summy,sum(outstorenum*price*outdiscount) as sumsy from outstoresheeta a,bookinfosheet b,pressinfosheet d where a.bookcode=b.code and presscode=d.code " + str1;
        cmd = new SqlCommand(str2, conn);
        conn.Open();
        dataR = cmd.ExecuteReader();
        if (dataR.Read())
        {
            if (dataR["nums"].ToString() == "0")
                Msg.Text = "";
            else
                Msg.Text = "合计：记录数 " + dataR["nums"].ToString() + "  总出库数 " + dataR["outstorenums"].ToString() + " 总码洋 " + dataR["summy"].ToString() + " 总实洋  " + dataR["sumsy"].ToString();
        }
        dataR.Close();
        str1 = "select a.code,ddate,agent,bookcode,b.name as bookname,d.abbrname,author,price,outstorenum,outdiscount from outstoresheeta a,bookinfosheet b,pressinfosheet d where a.bookcode=b.code and presscode=d.code "+str1+ "  order by a.code desc,bookcode";
        dtcmd = new SqlDataAdapter(str1, conn);
        dtcmd.Fill(dt);
        #region 用来判断当前删除是否为当前页的最后一条记录
        if ((this.DataGrid1.CurrentPageIndex == this.DataGrid1.PageCount - 1) && this.DataGrid1.Items.Count == 1)
        {
            if (this.DataGrid1.CurrentPageIndex - 1 > 1)
            {
                this.DataGrid1.CurrentPageIndex = this.DataGrid1.CurrentPageIndex - 1;
            }
            else
            {
                this.DataGrid1.CurrentPageIndex = 0;
            }
        }
        #endregion
        DataGrid1.DataSource = dt;
        DataGrid1.DataBind();
        conn.Close();
    }
    protected void Grid1_Del(object source, DataGridCommandEventArgs e)
    {
        string codeStr = e.Item.Cells[0].Text;
        string sql;
        SqlDataReader dataR = null;
        string bookCodeStr = e.Item.Cells[3].Text;
        if (e.CommandName.ToString() == "delete")
        {
            conn.Open();
            sql = "delete from outstoresheeta where code='" + codeStr.Trim() + "' and bookcode='" + bookCodeStr.Trim() + "'";
            cmd = new SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
            BindGrid();
        }
        else
        {
            if (e.CommandName.ToString() == "deleteunit")
            {
                conn.Open();
                sql = "delete from outstoresheeta where code='" + codeStr.Trim() + "'";
                cmd = new SqlCommand(sql, conn);
                cmd.ExecuteNonQuery();
                conn.Close();
                BindGrid();
            }
        }
    }
    protected void Grid1_Edit(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = e.Item.ItemIndex;
        BindGrid();
    }
    protected void Grid1_Cancel(object source, DataGridCommandEventArgs e)
    {
        DataGrid1.EditItemIndex = -1;
        BindGrid();
    }
    protected void Grid1_Update(object source, DataGridCommandEventArgs e)
    {
        string bookCodeStr = e.Item.Cells[3].Text;
        string OutNumStr = ((TextBox)e.Item.Cells[8].Controls[0]).Text;
        string DiscountStr = ((TextBox)e.Item.Cells[9].Controls[0]).Text;
        string CodeStr = e.Item.Cells[0].Text;
        float theDiscount;
        if (VCUtilities.IsNumeric(OutNumStr))
        {
            theDiscount = 1;
            if (VCUtilities.IsNumeric(DiscountStr))
                if (Convert.ToSingle(DiscountStr) > 0 && Convert.ToSingle(DiscountStr) < 1)
                    theDiscount = Convert.ToSingle(DiscountStr);
            conn.Open();
            string sql = "update outstoresheeta set outstorenum="+Convert.ToInt32(OutNumStr)+",outdiscount="+theDiscount+" where code='"+CodeStr+ "' and bookcode='"+bookCodeStr+"'";
            cmd = new SqlCommand(sql, conn);
            cmd.ExecuteNonQuery();
            conn.Close();
        }
        DataGrid1.EditItemIndex = -1;
        BindGrid();
    }
    protected void Grid1_PageIndexChanged(object source, DataGridPageChangedEventArgs e)
    {
        DataGrid1.CurrentPageIndex = e.NewPageIndex;
        BindGrid();
    }
    protected void Query_Click(object sender, EventArgs e)
    {
        BindGrid();
    }
    #region 返回脚本字符串
    public string getalertinfo(string str1)
    {
        string str;
        str = "<script language='javascript'>alert('" + str1 + "')</script>";
        return str.Trim();
    }
    #endregion
    protected void DataGrid1_ItemDataBound(object sender, DataGridItemEventArgs e)
    {
        switch (e.Item.ItemType)
        {
            case (ListItemType.Item):
            case (ListItemType.AlternatingItem):
                {
                    LinkButton btn = (LinkButton)e.Item.Cells[11].Controls[0];
                    LinkButton btn_All = (LinkButton)e.Item.Cells[12].Controls[0];
                    btn.Attributes.Add("OnClick", "return window.confirm('确定要删除该单记录？')");
                    btn_All.Attributes.Add("OnClick", "return window.confirm('确定要删除整单记录？')");
                    break;
                }
        }
    }
}