show_sell.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 Show_Sell : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        HeardConfig();
        if (!IsPostBack)
        {
            PersonInfo.Return_SessionPerson();//检测是否登陆
            if (QueryString.Get_Id != null)
            {
                if (QueryString.Get_Flag.ToString() == "see" && QueryString.Get_Flag != null)
                {
                    oksee.Visible = true;
                }
                else
                {
                    oksee.Visible = false;
                }
                IsPage_Bind();
            }
        }
    }
    #region 页面初始化必需的内容
    public void HeardConfig()
    {
        Header.Title = "销售订单管理系统-销售记录查看";
        HeaderTextInfo.GetHeader(this, null);
    }
    #endregion
    public void IsPage_Bind()
    {
        //根据传入的ID 读取各项数据
        string id = QueryString.Get_Id;
        string CmdTxt = "Select * From sell Where Id=" + id + "";
        SqlDataReader sdr = new SqlDataBase().GetDataReader(CmdTxt);
        if (sdr.Read())
        {
            this.CommodityName.Text = sdr["CommodityName"].ToString();
            this.CompanyName.Text = sdr["CompanyName"].ToString();
            this.kehu.Text = sdr["kehu"].ToString();
            this.Type.Text = sdr["Type"].ToString();
            this.Number.Text = sdr["Number"].ToString();
            this.Pirce.Text = sdr["Pirce"].ToString();
            this.StockDate.Text = Convert.ToDateTime(sdr["StockDate"]).ToShortDateString();
            this.ManageMan.Text = sdr["ManageMan"].ToString();
            this.SettlementType.Text = sdr["SettlementType"].ToString();
            this.Username.Text = sdr["Username"].ToString();
            this.AddTime.Text = sdr["AddTime"].ToString();
            this.tol.Text = Convert.ToString(Convert.ToInt32(sdr["Pirce"]) * Convert.ToInt32(sdr["Number"]));
            this.HyperLink1.NavigateUrl = "See.aspx?cid=" + id + "";

            string year = Convert.ToDateTime(sdr["StockDate"]).Year.ToString();
            string month = Convert.ToDateTime(sdr["StockDate"]).Month.ToString();
            if (month.Length < 2)
            {
                month = "0" + month;
            }
            string day = Convert.ToDateTime(sdr["StockDate"]).Day.ToString();
            if (day.Length < 2)
            {
                day = "0" + day;
            }
            string zero = "";
            for (int i = 1; i < (10 - id.Length); i++)
            {
                zero = zero + "0";
            }
            id = zero + id;
            this.uid.Text = year + month + day + id;
        }
    }
}