Beispiel #1
0
        //protected void DropDownList29_SelectedIndexChanged(object sender, EventArgs e)
        //{
        //    //if ((DropDownList29.SelectedValue == "workitem"))
        //    //{ Button1.Enabled = true; }
        //    //else
        //    //{ Button1.Enabled = false; }
        //}
        protected void DDLLayer_SelectedIndexChanged(object sender, EventArgs e)
        {
            DDLDtUpper.Items.Clear();
            DDLNext.Items.Clear();
            string database = Session["DatabaseName"].ToString();

            DDLDtUpper.DataSourceID = "SqlDataSource1";
            //for (int i=0; i<= int.Parse(ViewState["i"].ToString()); i++)
            //{
            //DDLLayer.SelectedValue = i.ToString();
            if (Session["bid"] != null && Session["bid"].ToString() != "")
            {
                int layer = int.Parse(DDLLayer.SelectedValue);

                //layer = layer >= 0 ? layer - 1 : 0;
                //}
                if (layer == 1)
                {
                    string MaxLayer = "Select  count(SortNum) as SortNum from [NTUST].[dbo].[Bid_WBS] where BID=" + Session["BID"] + "and  LayerNum=1 ";
                    string NextNum  = WebModel.SItemName(database, MaxLayer, "SortNum");
                    SqlDataSource1.SelectCommand = "";
                    DDLDtUpper.Enabled           = false;
                    for (int i = 1; i <= int.Parse(NextNum) + 1; i++)
                    {
                        DDLNext.Items.Add(new ListItem(i.ToString(), i.ToString()));
                    }
                    //ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('無上層工項');", true);
                }

                else
                {
                    DDLDtUpper.Enabled           = true;
                    SqlDataSource1.SelectCommand = "Select * from Bid_WBS where LayerNum =" + (layer - 1) + " and  ItemName is not null and Bid=" + Session["Bid"].ToString() + "";
                    DDLDtUpper.DataTextField     = "ItemName";
                    DDLDtUpper.DataValueField    = "UID";
                    DDLDtUpper.AutoPostBack      = true;
                    DDLDtUpper.DataBind();
                    //ListItem LI1 = new ListItem();
                    //LI1.Text = "--";
                    //LI1.Value = "0";
                    //DDLTop.Items.Insert(0, LI1);
                }
                ListItem LI2 = new ListItem();
                LI2.Text  = "-請選擇-";
                LI2.Value = "0";
                DDLNext.Items.Insert(0, LI2);
                DDLDtUpper.Items.Insert(0, LI2);
            }
            else
            {
                ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('請重新選擇標案');", true);
            }
        }
Beispiel #2
0
        protected void DDLLayer_SelectedIndexChanged(object sender, EventArgs e)
        {
            DDLDtUpper.Items.Clear();
            DDLNext.Items.Clear();
            DDLDtUpper.DataSourceID = "SqlDataSource1";
            //for (int i=0; i<= int.Parse(ViewState["i"].ToString()); i++)
            //{
            //DDLLayer.SelectedValue = i.ToString();
            if (Session["bid"] != null && Session["bid"].ToString() != "")
            {
                int layer = int.Parse(DDLLayer.SelectedValue) - 1;

                //}
                if (layer == 0)
                {
                    SqlDataSource1.SelectCommand = "";
                    //ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('無上層工項');", true);
                }

                else
                {
                    SqlDataSource1.SelectCommand = "Select * from Bid_WBS where LayerNum =" + layer + " and  ItemName is not null and Bid=" + Session["Bid"].ToString() + "";
                    DDLDtUpper.DataTextField     = "ItemName";
                    DDLDtUpper.DataValueField    = "UID";
                    DDLDtUpper.AutoPostBack      = true;
                    DDLDtUpper.DataBind();
                }
                ListItem LI2 = new ListItem();
                LI2.Text  = "--";
                LI2.Value = "0";

                DDLDtUpper.Items.Insert(0, LI2);
            }
            else
            {
                ScriptManager.RegisterStartupScript((System.Web.UI.Page)HttpContext.Current.Handler, this.GetType(), "ShowMessage", "alert('請重新選擇標案');", true);
            }
        }
Beispiel #3
0
        protected void Page_Load(object sender, EventArgs e)
        {
            if ((Session["UserName"] == null) || (Session["CompanyName"] == null))
            {
                Response.Redirect("Login.aspx");
            }
            if (Session["bid"] == null || Session["bid"] == "")
            {
                Response.Write("<script>alert('尚未選擇專案');location.href='Main.aspx';</script>");
            }
            SqlDataSource1.ConnectionString = Utility.DBconnection.connect_string(Session["DatabaseName"].ToString());
            if (!IsPostBack)
            {
                DDL_Unit.DataSource = Utility.Unitlist.UnitList();
                DDL_Unit.DataBind();


                LoadContent();
                Session["DDLLayer"]            = null;
                Session["DDLDtUpper"]          = null;
                Session["DDLNext"]             = null;
                Session["DDLKind"]             = null;
                Session["TxItemName"]          = null;
                Session["DDL_Unit"]            = null;
                Session["PriceID"]             = null;
                Session["ResourceLinkPriceID"] = null;
                ListItem LI2 = new ListItem();
                LI2.Text  = "-請選擇-";
                LI2.Value = "0";
                DDL_Unit.Items.Insert(0, LI2);
                if (UID != "")
                {
                    string    database   = Session["DatabaseName"].ToString();
                    string    SQLString1 = "Select * from Bid_WBS where UId=" + UID;
                    DataTable DataTable  = WebModel.LoadSetContentData(database, SQLString1);
                    foreach (DataRow row in DataTable.Rows)
                    {
                        //DDLLayer.DataBind();
                        //DDLLayer.AutoPostBack = true;
                        DDLLayer.SelectedValue = row["LayerNum"].ToString().Trim();
                        DDLLayer_SelectedIndexChanged(this, null);
                        DDLDtUpper.AutoPostBack = true;
                        DDLDtUpper.DataSourceID = "SqlDataSource1";
                        DDLDtUpper.DataBind();
                        DDLDtUpper.SelectedValue = row["UpperUID"].ToString();
                        DDLTop_SelectedIndexChanged(this, null);
                        DDLNext.DataBind();
                        DDLNext.SelectedValue = row["SortNum"].ToString();
                        DDLKind.SelectedValue = row["ItemKind"].ToString();
                        TxItemName.Text       = row["ItemName"].ToString();
                        DDL_Unit.DataBind();
                        DDL_Unit.SelectedValue = row["Unit"].ToString();
                        string PriceID = row["PriceID"].ToString();
                        if (PriceID != "")
                        {
                            string SQLSelectString = "Select * from Bid_Library where PriceID=" + PriceID;
                            ItemName.Text = WebModel.SItemName(database, SQLSelectString, "ItemName");
                        }
                        if (row["ItemKind"].ToString() == "workitem")
                        {
                            Button17.Enabled = true;
                        }
                        else
                        {
                            Button17.Enabled = false;
                        }
                    }
                }
            }


            //if (Session["PriceID"] != null && Session["PriceID"] != "")
            //{

            //    string PriceIDArray = Session["PriceID"].ToString();

            //    PriceID = PriceIDArray.Split('ξ')[0];
            //    Session["thisID"] = PriceID;
            //    ItemName.Text = PriceIDArray.Split('ξ')[1];
            //    DDLLayer.SelectedValue = Session["DDLLayer"].ToString();
            //    DDLDtUpper.SelectedValue = Session["DDLDtUpper"].ToString();
            //    DDLNext.SelectedValue = Session["DDLNext"].ToString();
            //    DDLKind.SelectedValue = Session["DDLKind"].ToString();
            //    TxItemName.Text = Session["TxItemName"].ToString();
            //    DDL_Unit.SelectedValue = Session["DDL_Unit"].ToString();
            //    LbPriceID.Text = PriceID;
            //    LoadContent();
            //    Session["DDLLayer"] = null;
            //    Session["DDLDtUpper"] = null;
            //    Session["DDLNext"] = null;
            //    Session["DDLKind"] = null;
            //    Session["TxItemName"] = null;
            //    Session["DDL_Unit"] = null;
            //    Session["PriceID"] = null;
            //}
            if (Session["ResourceLinkPriceID"] != null && Session["ResourceLinkPriceID"] != "")
            {
                string PriceIDArray = Session["ResourceLinkPriceID"].ToString();
                string database     = Session["DatabaseName"].ToString();
                PriceID                  = PriceIDArray.Split('ξ')[0];
                Session["thisID"]        = PriceID;
                ItemName.Text            = PriceIDArray.Split('ξ')[1];
                DDLLayer.SelectedValue   = Session["DDLLayer"].ToString();
                DDLDtUpper.SelectedValue = Session["DDLDtUpper"].ToString();
                DDLNext.SelectedValue    = Session["DDLNext"].ToString();
                DDLKind.SelectedValue    = Session["DDLKind"].ToString();
                TxItemName.Text          = Session["TxItemName"].ToString();
                DDL_Unit.SelectedValue   = Session["DDL_Unit"].ToString();
                LbPriceID.Text           = PriceID;
                LoadContent();

                string    SQLString1    = "Select  *  from  Bid_Library  where PriceID=" + PriceID + "";
                DataTable DataTableBox1 = WebModel.LoadSetContentData(database, SQLString1);
                if (DataTableBox1 != null && DataTableBox1.Rows.Count > 0)
                {
                    foreach (DataRow row in DataTableBox1.Rows)
                    {
                        ItemName.Text = row["ItemName"].ToString();
                    }
                }
                Session["DDLLayer"]   = null;
                Session["DDLDtUpper"] = null;
                Session["DDLNext"]    = null;
                Session["DDLKind"]    = null;
                Session["TxItemName"] = null;
                Session["DDL_Unit"]   = null;
                Session["PriceID"]    = null;


                Session["ResourceLinkPriceID"] = null;
            }
        }