?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 Stock_Stock_open : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if(!IsPostBack)
        {
            string id = Request["id"];
            SqlConnection strcon = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["strcon"]);
            strcon.Open();
            SqlDataAdapter sda = new SqlDataAdapter("select * from stock where id="+Request["id"],strcon);
            DataSet ds = new DataSet();
            sda.Fill(ds, "stock");
            DataRowView rowview = ds.Tables["stock"].DefaultView[0];
            this.CommodityName.Text = rowview["CommodityName"].ToString();
            this.CompanyName.Text = rowview["CompanyName"].ToString();
            this.Type.Text = rowview["Type"].ToString();
            this.Number.Text = rowview["Number"].ToString();
            this.Pirce.Text = rowview["Pirce"].ToString();
            this.StockDate.Text =Convert.ToDateTime(rowview["StockDate"]).ToShortDateString();
            this.ManageMan.Text = rowview["ManageMan"].ToString();
            this.SettlementType.Text = rowview["SettlementType"].ToString();
            this.Username.Text = rowview["Username"].ToString();
            this.AddTime.Text = rowview["AddTime"].ToString();
            this.tol.Text = Convert.ToString(Convert.ToInt32(rowview["Pirce"]) * Convert.ToInt32(rowview["Number"]));

            string year= Convert.ToDateTime(rowview["StockDate"]).Year.ToString();
            string month = Convert.ToDateTime(rowview["StockDate"]).Month.ToString();
            if (month.Length < 2)
            {
                month = "0" + month;
            }
            string day = Convert.ToDateTime(rowview["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;
        }
    }
}