private void BindDropDownList12() { DataSet ds = new DataSet(); DatabaseHelper DbQuery = new DatabaseHelper(); DataTable dt = new DataTable(); DataRow ndr = dt.NewRow(); dt.Columns.Add("MR002", typeof(String)); dt.Columns.Add("MR003", typeof(String)); string connectionString = ConfigurationManager.ConnectionStrings["ERPconnectionstring"].ToString(); using (SqlConnection conn = new SqlConnection(connectionString)) { SqlCommand command = new SqlCommand(@"SELECT LTRIM(RTRIM(MR002)) AS MR002,MR003 FROM [TK].dbo.CMSMR WHERE MR001='4' ORDER BY MR002", conn); ds.Clear(); SqlDataAdapter adapter = new SqlDataAdapter(command); conn.Open(); adapter.Fill(ds, command.ToString()); if (ds.Tables[0].Rows.Count > 0) { DropDownList12.DataSource = ds.Tables[0]; DropDownList12.DataTextField = "MR003"; DropDownList12.DataValueField = "MR002"; DropDownList12.DataBind(); } else { } } }
protected void insertcity_Click(object sender, EventArgs e) { if ((TextBox1.Text != "")) { int t = controllerObj.insertcity(TextBox1.Text, Convert.ToInt32(DropDownList6.SelectedValue)); if (t == 0) { Label1.Text = "this city is already exist ."; } else { Label1.Text = "this city inserts corectly ."; } DropDownList7.DataBind(); DropDownList6.DataBind(); DropDownList5.DataBind(); DropDownList4.DataBind(); DropDownList3.DataBind(); DropDownList2.DataBind(); // to make change which happens when delete and insert apeare in other droplists DropDownList11.DataBind(); DropDownList12.DataBind(); DropDownList13.DataBind(); } else { Label1.Text = "You enter missing data !!."; } }
protected void insertcountry_Click(object sender, EventArgs e) { if (TextBox2.Text != "") { int t = controllerObj.insertcountry(TextBox2.Text); if (t == 0) { Label2.Text = "this country is already exist ."; } else { Label2.Text = "this country inserts corectly ."; } DropDownList7.DataBind(); DropDownList6.DataBind(); DropDownList5.DataBind(); DropDownList4.DataBind(); DropDownList3.DataBind(); DropDownList2.DataBind(); DropDownList11.DataBind(); DropDownList12.DataBind(); DropDownList13.DataBind(); } else { Label2.Text = "You enter missing data !!."; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { txtEstimateStartDate.SelectedDate = Convert.ToDateTime(DateTime.Now.AddDays(-7).ToString("yyyy/MM/dd")); txtEstimateEndDate.SelectedDate = Convert.ToDateTime(DateTime.Now.AddDays(+0).ToString("yyyy/MM/dd")); sql_temp = "select distinct(t.type_name) as type_name from lh_onduty_record t"; ds_temp = func.get_dataSet_access(sql_temp, conn); DropDownList1.DataTextField = "type_name"; DropDownList1.DataValueField = "type_name"; DropDownList1.DataSource = ds_temp.Tables[0]; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "請選擇"); ds_temp.Clear(); sql_temp = "select distinct(t.buname) as buname from lh_onduty_record t"; ds_temp = func.get_dataSet_access(sql_temp, conn); DropDownList3.DataTextField = "buname"; DropDownList3.DataValueField = "buname"; DropDownList3.DataSource = ds_temp.Tables[0]; DropDownList3.DataBind(); DropDownList3.Items.Insert(0, "請選擇"); ds_temp.Clear(); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\lh_category.txt"); DropDownList6.DataSource = arlist_temp1; DropDownList6.DataBind(); DropDownList12.DataSource = ""; DropDownList12.DataBind(); DropDownList12.Items.Insert(0, "請選擇"); DropDownList4.DataSource = ""; DropDownList4.Items.Insert(0, "請選擇"); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\flag_type_query.txt"); DropDownList2.DataSource = arlist_temp1; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "請選擇"); bind_data(); } }
protected void delcity_Click(object sender, EventArgs e) { controllerObj.deletecity(Convert.ToInt32(DropDownList12.SelectedValue)); DropDownList7.DataBind(); DropDownList6.DataBind(); DropDownList5.DataBind(); DropDownList4.DataBind(); DropDownList3.DataBind(); DropDownList2.DataBind(); DropDownList11.DataBind(); DropDownList12.DataBind(); DropDownList13.DataBind(); }
protected void DropDownList3_SelectedIndexChanged(object sender, EventArgs e) { sql_temp = "select distinct(t.divname) as divname from lh_onduty_record t where t.buname='" + DropDownList3.SelectedValue + "' "; ds_temp = func.get_dataSet_access(sql_temp, conn); DropDownList12.DataTextField = "divname"; DropDownList12.DataValueField = "divname"; DropDownList12.DataSource = ds_temp.Tables[0]; DropDownList12.DataBind(); DropDownList12.Items.Insert(0, "請選擇"); ds_temp.Clear(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var x = Request.QueryString["id"].ToString(); int y = int.Parse(x); HyperLink1.NavigateUrl = "ProfAddQuestion.aspx?id=" + x; HyperLink2.NavigateUrl = "ProfEditChapters.aspx?id=" + x; HyperLink3.NavigateUrl = "ProfEditQuestion.aspx?id=" + x; HyperLink4.NavigateUrl = "ProfAddChapters.aspx?id=" + x; HyperLink6.NavigateUrl = "ProfShowResult.aspx?id=" + x; HyperLink7.NavigateUrl = "ProfExamStructure.aspx?id=" + x; var stateid = from Tbl_Subject in db.Tbl_Subject where Tbl_Subject.Prof_ID.Equals(y) select new { Tbl_Subject.Subject_ID, Tbl_Subject.Name_Er, Tbl_Subject.Name_Ar }; var statename = stateid.ToList(); if (statename.Count > 0) { DropDownList2.DataValueField = "Subject_ID"; DropDownList2.DataTextField = "Name_Er"; DropDownList2.DataSource = statename; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "--- select sub----"); DropDownList12.DataValueField = "Subject_ID"; DropDownList12.DataTextField = "Name_Ar"; DropDownList12.DataSource = statename; DropDownList12.DataBind(); DropDownList12.Items.Insert(0, "--- احتر المادة ----"); } DropDownList4.Items.Add("" + 0); DropDownList5.Items.Add("" + 0); DropDownList6.Items.Add("" + 0); DropDownList7.Items.Add("" + 0); DropDownList8.Items.Add("" + 0); DropDownList9.Items.Add("" + 0); DropDownList10.Items.Add("" + 0); DropDownList11.Items.Add("" + 0); //DropDownList12.Items.Add("" + 0); DropDownList15.Items.Add("" + 0); DropDownList16.Items.Add("" + 0); DropDownList17.Items.Add("" + 0); DropDownList18.Items.Add("" + 0); DropDownList19.Items.Add("" + 0); DropDownList20.Items.Add("" + 0); DropDownList21.Items.Add("" + 0); DropDownList22.Items.Add("" + 0); } }
protected void DropDownList11_SelectedIndexChanged(object sender, EventArgs e) { DropDownList12.Items.Clear(); int dep = Convert.ToInt32(DropDownList11.SelectedValue); var stateid = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(dep) select new { Tbl_department.Name_En, Tbl_department.Department_ID }; var statename = stateid.ToList(); if (statename.Count > 0) { DropDownList12.DataValueField = "Department_ID"; DropDownList12.DataTextField = "Name_En"; DropDownList12.DataSource = statename; DropDownList12.DataBind(); DropDownList12.Items.Insert(0, "--- select dep----"); } }
protected void Page_Load(object sender, EventArgs e) { int advisor_Id = 100, id = 100; string date = "4/16/2013"; string stID = "822459053"; lblAdvisorID.Text = advisor_Id.ToString(); lblDate.Text = date; lblStudentID.Text = stID; int time = 9; this.Util(100); DropDownList1.DataSource = getAdvisorIDs(); DropDownList1.DataBind(); Label2.Text = getAdvisorImage(advisor_Id); Label3.Text = getName(advisor_Id); Label4.Text = getDepartment(advisor_Id); // Label5.Text = getMonday(advisor_Id); // ////Label6.Text = getTuesday(advisor_Id); // ////Label7.Text = getWednesday(advisor_Id); // ////Label8.Text = getThursday(advisor_Id); // ////Label9.Text = getFriday(advisor_Id); DropDownList10.DataSource = getSlots(advisor_Id, date); DropDownList10.DataBind(); DropDownList11.DataSource = getTaken(advisor_Id, date); DropDownList11.DataBind(); DropDownList12.DataSource = getAvailability(getSlots(advisor_Id, date), getTaken(advisor_Id, date)); DropDownList12.DataBind(); DropDownList13.DataSource = getDaysAvailable(id); DropDownList13.DataBind(); // //Label14.Text = getAvailableID(time); Label15.Text = getCheck(stID).ToString(); DropDownList16.DataSource = getAdvisor2WeekSchedule(); DropDownList16.DataBind(); DropDownList17.DataSource = getAdvisor2WeekSchedule(id); DropDownList17.DataBind(); DropDownList18.DataSource = getStudentIds(); DropDownList18.DataBind(); }
private void BindAreaDP() { List <RSSMWeb.Code.Utils.CustomClass> mylist = Utils.GetUserList(); RSSMWeb.Code.Utils.CustomClass tmp = new RSSMWeb.Code.Utils.CustomClass("0", "无", "0"); List <RSSMWeb.Code.Utils.CustomClassForDropdownlist> mylist_username_dpt = Utils.GetUserListForDropdownlist_dpt(); mylist.Insert(0, tmp); DropDownList7.DataTextField = "Name"; DropDownList7.DataValueField = "ID"; DropDownList7.DataSource = mylist; DropDownList7.DataBind(); //DropDownList6.DataTextField = "Name"; //DropDownList6.DataValueField = "ID"; //DropDownList6.DataSource = mylist; //DropDownList6.DataBind(); DropDownList6.EnableSimulateTree = true; DropDownList6.DataTextField = "Name"; DropDownList6.DataValueField = "ID"; DropDownList6.DataSimulateTreeLevelField = "Group"; DropDownList6.DataEnableSelectField = "Enableselect"; DropDownList6.DataSource = mylist_username_dpt; DropDownList6.DataBind(); DropDownList6.SelectedValue = "0"; //DropDownList9.DataTextField = "Name"; //DropDownList9.DataValueField = "ID"; //DropDownList9.DataSource = mylist; //DropDownList9.DataBind(); DropDownList9.EnableSimulateTree = true; DropDownList9.DataTextField = "Name"; DropDownList9.DataValueField = "ID"; DropDownList9.DataSimulateTreeLevelField = "Group"; DropDownList9.DataEnableSelectField = "Enableselect"; DropDownList9.DataSource = mylist_username_dpt; DropDownList9.DataBind(); DropDownList9.SelectedValue = "0"; DropDownList10.EnableSimulateTree = true; DropDownList10.DataTextField = "Name"; DropDownList10.DataValueField = "ID"; DropDownList10.DataSimulateTreeLevelField = "Group"; DropDownList10.DataEnableSelectField = "Enableselect"; DropDownList10.DataSource = mylist_username_dpt; DropDownList10.DataBind(); DropDownList10.SelectedValue = "0"; DropDownList12.EnableSimulateTree = true; DropDownList12.DataTextField = "Name"; DropDownList12.DataValueField = "ID"; DropDownList12.DataSimulateTreeLevelField = "Group"; DropDownList12.DataEnableSelectField = "Enableselect"; DropDownList12.DataSource = mylist_username_dpt; DropDownList12.DataBind(); DropDownList12.SelectedValue = "0"; mylist.Clear(); mylist = Utils.GetPJList(); tmp.ID = "0"; tmp.Name = "无"; mylist.Insert(0, tmp); DropDownList4.DataTextField = "Name"; DropDownList4.DataValueField = "ID"; DropDownList4.DataSource = mylist; DropDownList4.DataBind(); mylist.Clear(); mylist = Utils.GetPDList(); tmp.ID = "0"; tmp.Name = "无"; mylist.Insert(0, tmp); DropDownList2.DataTextField = "Name"; DropDownList2.DataValueField = "ID"; DropDownList2.DataSource = mylist; DropDownList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { Panel4.Visible = false; Panel2.Visible = false; Panel3.Visible = false; string cs = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString; using (SqlConnection con = new SqlConnection(cs)) { SqlCommand cmd = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con); con.Open(); SqlDataReader sd; sd = cmd.ExecuteReader(); DropDownList4.DataSource = sd; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, new ListItem("Select Subject", "NA")); sd.Close(); SqlCommand cmd1 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con); sd = cmd1.ExecuteReader(); DropDownList5.DataSource = sd; DropDownList5.DataBind(); DropDownList5.Items.Insert(0, new ListItem("Select Teacher", "NA")); sd.Close(); SqlCommand cmd2 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con); sd = cmd2.ExecuteReader(); DropDownList6.DataSource = sd; DropDownList6.DataBind(); DropDownList6.Items.Insert(0, new ListItem("Select Assisstant", "NA")); sd.Close(); SqlCommand cmd3 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con); sd = cmd3.ExecuteReader(); DropDownList9.DataSource = sd; DropDownList9.DataBind(); DropDownList9.Items.Insert(0, new ListItem("Select Teacher", "NA")); sd.Close(); SqlCommand cmd4 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con); sd = cmd4.ExecuteReader(); DropDownList12.DataSource = sd; DropDownList12.DataBind(); DropDownList12.Items.Insert(0, new ListItem("Select Teacher", "NA")); sd.Close(); SqlCommand cmd5 = new SqlCommand("Select teacherid,teachername,email,contact from Teacherdeatils", con); sd = cmd5.ExecuteReader(); DropDownList14.DataSource = sd; DropDownList14.DataBind(); DropDownList14.Items.Insert(0, new ListItem("Select Teacher", "NA")); sd.Close(); SqlCommand cmd6 = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con); sd = cmd6.ExecuteReader(); DropDownList8.DataSource = sd; DropDownList8.DataBind(); DropDownList8.Items.Insert(0, new ListItem("Select Subject", "NA")); sd.Close(); SqlCommand cmd7 = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con); sd = cmd7.ExecuteReader(); DropDownList11.DataSource = sd; DropDownList11.DataBind(); DropDownList11.Items.Insert(0, new ListItem("Select Subject", "NA")); sd.Close(); SqlCommand cmd8 = new SqlCommand("Select subjectcode,subjectname from subjectdetails", con); sd = cmd8.ExecuteReader(); DropDownList13.DataSource = sd; DropDownList13.DataBind(); DropDownList13.Items.Insert(0, new ListItem("Select Subject", "NA")); sd.Close(); SqlCommand cmd9 = new SqlCommand("Select Id,classroom,lab from Room", con); sd = cmd9.ExecuteReader(); DropDownList3.DataSource = sd; DropDownList3.DataBind(); DropDownList3.Items.Insert(0, new ListItem("Select Lab Room", "NA")); sd.Close(); SqlCommand cmd10 = new SqlCommand("Select Id,classroom,lab from Room", con); sd = cmd10.ExecuteReader(); DropDownList7.DataSource = sd; DropDownList7.DataBind(); DropDownList7.Items.Insert(0, new ListItem("Select Class Room", "NA")); sd.Close(); //SqlCommand cmd11 = new SqlCommand("Insert into ROOM 1,"+DropDownList7.SelectedItem.Text+", "+DropDownList3.SelectedItem.Text, con); /* if (DropDownList11.Items.Contains(DropDownList8.SelectedItem)) * { * DropDownList11.Items.IndexOf(DropDownList8.SelectedItem); * DropDownList11.SelectedItem.Enabled = false; * }*/ } } //Panel1.Visible = true; }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ArrayList arlist_temp1 = new ArrayList(); txtEstimateStartDate.SelectedDate = Convert.ToDateTime(DateTime.Now.AddDays(-7).ToString("yyyy/MM/dd")); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\hour.txt"); DropDownList5.DataSource = arlist_temp1; DropDownList5.DataBind(); DropDownList5.Text = DateTime.Now.ToString("HH"); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\min.txt"); DropDownList8.DataSource = arlist_temp1; DropDownList8.DataBind(); DropDownList8.Text = DateTime.Now.ToString("mm"); txtEstimateEndDate.SelectedDate = Convert.ToDateTime(DateTime.Now.AddDays(+0).ToString("yyyy/MM/dd")); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\hour.txt"); DropDownList15.DataSource = arlist_temp1; DropDownList15.DataBind(); DropDownList15.Text = DateTime.Now.ToString("HH"); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\min.txt"); DropDownList18.DataSource = arlist_temp1; DropDownList18.DataBind(); DropDownList18.Text = DateTime.Now.ToString("mm"); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\abnormal_type.txt"); DropDownList1.DataSource = arlist_temp1; DropDownList1.DataBind(); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\abnormal_area.txt"); DropDownList2.DataSource = arlist_temp1; DropDownList2.DataBind(); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\dep.txt"); DropDownList3.DataSource = arlist_temp1; DropDownList3.DataBind(); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\flag_type_query.txt"); DropDownList12.DataSource = arlist_temp1; DropDownList12.DataBind(); bind_data(); } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { var x = Request.QueryString["page"].ToString(); int y = int.Parse(x); if (y == 1) { Panel2.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_department rr = db.Tbl_department.First(u => u.Department_ID == y1); int dep = Convert.ToInt32(rr.Level_ID); var stateid = from Tbl_Level in db.Tbl_Level where Tbl_Level.Level_ID.Equals(dep) select new { Tbl_Level.Name_Ar, Tbl_Level.Name_Er, Tbl_Level.Level_ID }; var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar }; DropDownList1.DataSource = le.ToList(); DropDownList1.DataValueField = "Level_ID"; DropDownList1.DataTextField = "Name_Er"; DropDownList1.DataBind(); DropDownList1.SelectedValue = dep.ToString(); name_ar_dep.Text = rr.Name_Ar; name_en_dep.Text = rr.Name_En; } else if (y == 112) { Panel7.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_department rr = db.Tbl_department.First(u => u.Department_ID == y1); int dep = Convert.ToInt32(rr.Level_ID); var stateid = from Tbl_Level in db.Tbl_Level where Tbl_Level.Level_ID.Equals(dep) select new { Tbl_Level.Name_Ar, Tbl_Level.Name_Er, Tbl_Level.Level_ID }; var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar }; DropDownList9.DataSource = le.ToList(); DropDownList9.DataValueField = "Level_ID"; DropDownList9.DataTextField = "Name_Ar"; DropDownList9.DataBind(); DropDownList9.SelectedValue = dep.ToString(); TextBox14.Text = rr.Name_Ar; TextBox13.Text = rr.Name_En; } else if (y == 21) { Panel8.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Subject rr = db.Tbl_Subject.First(u => u.Subject_ID == y1); int pro = Convert.ToInt32(rr.Prof_ID); var stateid = from Tbl_Prof in db.Tbl_Prof where Tbl_Prof.Approval.Equals("1") select new { Tbl_Prof.Prof_ID, Tbl_Prof.Name }; //var pr = from Tbl_Prof in db.Tbl_Prof select new { Tbl_Prof.Name, Tbl_Prof.Prof_ID }; DropDownList10.DataSource = stateid.ToList(); DropDownList10.DataValueField = "Prof_ID"; DropDownList10.DataTextField = "Name"; DropDownList10.DataBind(); DropDownList10.SelectedValue = pro.ToString(); int dep = Convert.ToInt32(rr.Department_ID); Tbl_department de = db.Tbl_department.First(d => d.Department_ID == dep); int lev = Convert.ToInt32(de.Level_ID); var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar }; DropDownList11.DataSource = le.ToList(); DropDownList11.DataValueField = "Level_ID"; DropDownList11.DataTextField = "Name_Ar"; DropDownList11.DataBind(); DropDownList11.SelectedValue = lev.ToString(); var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En, Tbl_department.Name_Ar }; var statename = stateidDep.ToList(); if (statename.Count > 0) { DropDownList12.DataSource = statename; DropDownList12.DataValueField = "Department_ID"; DropDownList12.DataTextField = "Name_Ar"; DropDownList12.DataBind(); DropDownList12.SelectedValue = dep.ToString(); } TextBox15.Text = rr.Name_Er; TextBox16.Text = rr.Name_Ar; } else if (y == 2) { Panel3.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Subject rr = db.Tbl_Subject.First(u => u.Subject_ID == y1); int pro = Convert.ToInt32(rr.Prof_ID); var stateid = from Tbl_Prof in db.Tbl_Prof where Tbl_Prof.Approval.Equals("1") select new { Tbl_Prof.Prof_ID, Tbl_Prof.Name }; //var pr = from Tbl_Prof in db.Tbl_Prof select new { Tbl_Prof.Name, Tbl_Prof.Prof_ID }; DropDownList4.DataSource = stateid.ToList(); DropDownList4.DataValueField = "Prof_ID"; DropDownList4.DataTextField = "Name"; DropDownList4.DataBind(); DropDownList4.SelectedValue = pro.ToString(); int dep = Convert.ToInt32(rr.Department_ID); Tbl_department de = db.Tbl_department.First(d => d.Department_ID == dep); int lev = Convert.ToInt32(de.Level_ID); var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID }; DropDownList2.DataSource = le.ToList(); DropDownList2.DataValueField = "Level_ID"; DropDownList2.DataTextField = "Name_Er"; DropDownList2.DataBind(); DropDownList2.SelectedValue = lev.ToString(); var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En }; var statename = stateidDep.ToList(); if (statename.Count > 0) { DropDownList3.DataSource = statename; DropDownList3.DataValueField = "Department_ID"; DropDownList3.DataTextField = "Name_En"; DropDownList3.DataBind(); DropDownList3.SelectedValue = dep.ToString(); } TextBox1.Text = rr.Name_Er; TextBox2.Text = rr.Name_Ar; } else if (y == 31) { Panel9.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Prof rr = db.Tbl_Prof.First(u => u.Prof_ID == y1); TextBox17.Text = rr.Name.ToString(); TextBox18.Text = rr.Password.ToString(); TextBox19.Text = rr.Email.ToString(); } else if (y == 3) { Panel1.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Prof rr = db.Tbl_Prof.First(u => u.Prof_ID == y1); TextBox4.Text = rr.Name.ToString(); TextBox5.Text = rr.Password.ToString(); TextBox6.Text = rr.Email.ToString(); } else if (y == 41) { Panel10.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Student rr = db.Tbl_Student.First(u => u.Student_ID == y1); TextBox20.Text = rr.Name.ToString(); TextBox21.Text = rr.Password.ToString(); TextBox22.Text = rr.Email.ToString(); var lev = rr.Level_ID; var dep = rr.Department_ID; var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID, Tbl_Level.Name_Ar }; DropDownList13.DataSource = le.ToList(); DropDownList13.DataValueField = "Level_ID"; DropDownList13.DataTextField = "Name_Ar"; DropDownList13.DataBind(); DropDownList13.SelectedValue = lev.ToString(); var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En, Tbl_department.Name_Ar }; var statename = stateidDep.ToList(); if (statename.Count > 0) { DropDownList14.DataSource = statename; DropDownList14.DataValueField = "Department_ID"; DropDownList14.DataTextField = "Name_Ar"; DropDownList14.DataBind(); DropDownList14.SelectedValue = dep.ToString(); } } else if (y == 4) { Panel4.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Student rr = db.Tbl_Student.First(u => u.Student_ID == y1); TextBox3.Text = rr.Name.ToString(); TextBox7.Text = rr.Password.ToString(); TextBox8.Text = rr.Email.ToString(); var lev = rr.Level_ID; var dep = rr.Department_ID; var le = from Tbl_Level in db.Tbl_Level select new { Tbl_Level.Name_Er, Tbl_Level.Level_ID }; DropDownList5.DataSource = le.ToList(); DropDownList5.DataValueField = "Level_ID"; DropDownList5.DataTextField = "Name_Er"; DropDownList5.DataBind(); DropDownList5.SelectedValue = lev.ToString(); var stateidDep = from Tbl_department in db.Tbl_department where Tbl_department.Level_ID.Equals(lev) select new { Tbl_department.Department_ID, Tbl_department.Level_ID, Tbl_department.Name_En }; var statename = stateidDep.ToList(); if (statename.Count > 0) { DropDownList6.DataSource = statename; DropDownList6.DataValueField = "Department_ID"; DropDownList6.DataTextField = "Name_En"; DropDownList6.DataBind(); DropDownList6.SelectedValue = dep.ToString(); } } else if (y == 61) { Panel11.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_chapter rr = db.Tbl_chapter.First(u => u.Chapter_ID == y1); int dep = Convert.ToInt32(rr.Subject_ID); var x2 = Request.QueryString["pr"].ToString(); int y2 = int.Parse(x2); var stateid = from Tbl_Subject in db.Tbl_Subject where Tbl_Subject.Prof_ID.Equals(y2) select new { Tbl_Subject.Subject_ID, Tbl_Subject.Name_Ar }; var statename = stateid.ToList(); if (statename.Count > 0) { DropDownList15.DataValueField = "Subject_ID"; DropDownList15.DataTextField = "Name_Ar"; DropDownList15.DataSource = statename; DropDownList15.DataBind(); DropDownList15.Items.Insert(0, "--- select sub----"); } DropDownList15.SelectedValue = dep.ToString(); TextBox24.Text = rr.Name_Ar; TextBox23.Text = rr.Name_En; } else if (y == 6) { Panel5.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_chapter rr = db.Tbl_chapter.First(u => u.Chapter_ID == y1); int dep = Convert.ToInt32(rr.Subject_ID); var x2 = Request.QueryString["pr"].ToString(); int y2 = int.Parse(x2); var stateid = from Tbl_Subject in db.Tbl_Subject where Tbl_Subject.Prof_ID.Equals(y2) select new { Tbl_Subject.Subject_ID, Tbl_Subject.Name_Er }; var statename = stateid.ToList(); if (statename.Count > 0) { DropDownList7.DataValueField = "Subject_ID"; DropDownList7.DataTextField = "Name_Er"; DropDownList7.DataSource = statename; DropDownList7.DataBind(); DropDownList7.Items.Insert(0, "--- select sub----"); } DropDownList7.SelectedValue = dep.ToString(); TextBox10.Text = rr.Name_Ar; TextBox9.Text = rr.Name_En; } else if (y == 71) { Panel12.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Question rr = db.Tbl_Question.First(u => u.Question_ID == y1); TextBox26.Text = rr.Question_Ar.ToString(); TextBox25.Text = rr.Question_En.ToString(); DropDownList16.SelectedValue = rr.Question_Level.ToString(); var x2 = Request.QueryString["pr"].ToString(); int y2 = int.Parse(x2); } else if (y == 7) { Panel6.Visible = true; var x1 = Request.QueryString["id"].ToString(); int y1 = int.Parse(x1); Tbl_Question rr = db.Tbl_Question.First(u => u.Question_ID == y1); TextBox12.Text = rr.Question_Ar.ToString(); TextBox11.Text = rr.Question_En.ToString(); DropDownList8.SelectedValue = rr.Question_Level.ToString(); var x2 = Request.QueryString["pr"].ToString(); int y2 = int.Parse(x2); } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { sql_str = " select distinct(t.offday) as offday from onduty t " + " where t.offday not in ('OFF','ON') "; ds_temp = func.get_dataSet_access(sql_str, conn); RadioButtonList1.DataSource = ds_temp.Tables[0]; RadioButtonList1.DataTextField = "offday"; RadioButtonList1.DataValueField = "offday"; RadioButtonList1.DataBind(); // RadioButtonList1.Items.Insert(0, "請選擇"); txtEstimateStartDate.SelectedDate = Convert.ToDateTime(DateTime.Now.AddDays(-1).ToString("yyyy/MM/dd")); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\hour.txt"); DropDownList5.DataSource = arlist_temp1; DropDownList5.DataBind(); DropDownList5.Text = DateTime.Now.ToString("HH"); DropDownList5.Text = "08"; arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\min.txt"); DropDownList8.DataSource = arlist_temp1; DropDownList8.DataBind(); DropDownList8.Text = DateTime.Now.ToString("mm"); DropDownList8.Text = "00"; txtEstimateEndDate.SelectedDate = Convert.ToDateTime(DateTime.Now.AddDays(+0).ToString("yyyy/MM/dd")); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\hour.txt"); DropDownList15.DataSource = arlist_temp1; DropDownList15.DataBind(); DropDownList15.Text = DateTime.Now.ToString("HH"); arlist_temp1 = func.FileToArray(Server.MapPath(".") + "\\config\\min.txt"); DropDownList18.DataSource = arlist_temp1; DropDownList18.DataBind(); DropDownList18.Text = DateTime.Now.ToString("mm"); DropDownList18.Text = "59"; #region MyRegion 值班工程師 sql_str = " select distinct (t.engineer) as engineer " + " from onduty t " + " where t.engineer not in " + " ('何宗彥', '吳泳潔', '廖建賀', '張松騰', '徐展文', '林校平', '林豐裕', " + " '羅盛平', '胡慶祥', '邵朝文', '賴岳汶', '陳品辰', '陳盈仁', '魏武慶', " + " '黃建友', '黃紹煒','蔡丞','楊炎煌','蕭寶棋','蔡育倫','陳鏞企','吳宗哲','吳宜蓁','呂政達') "; // ds_temp.Clear(); ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList4.DataSource = ds_temp.Tables[0]; DropDownList4.DataTextField = "engineer"; DropDownList4.DataValueField = "engineer"; DropDownList4.DataBind(); DropDownList4.Items.Insert(0, "請選擇"); #endregion #region fab sql_str = " select distinct (t.fab) as fab " + " from onduty t "; // ds_temp.Clear(); string [] fab_array = { "T0T1*", "T2*", "T0Array", "T1Array", "T0Cell", "T1Cell", "T1CF", "T2Array", "T2Cell", "T2CF", "T0T1_OTHERS", "T2_OTHERS", "C3", "WIS" }; ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList1.DataSource = ds_temp.Tables[0]; DropDownList1.DataSource = fab_array; //DropDownList1.DataTextField = "fab"; //DropDownList1.DataValueField = "fab"; DropDownList1.DataBind(); DropDownList1.Items.Insert(0, "請選擇"); #endregion #region fab sql_str = " select distinct (t.system) as system " + " from onduty t "; // ds_temp.Clear(); ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList2.DataSource = ds_temp.Tables[0]; DropDownList2.DataTextField = "system"; DropDownList2.DataValueField = "system"; DropDownList2.DataBind(); DropDownList2.Items.Insert(0, "請選擇"); #endregion #region close_flag sql_str = "select distinct(t.close_flag) as close_flag from onduty t" + " where t.close_flag is not null"; // ds_temp.Clear(); ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList3.DataSource = ds_temp.Tables[0]; DropDownList3.DataTextField = "close_flag"; DropDownList3.DataValueField = "close_flag"; DropDownList3.DataBind(); DropDownList3.Items.Insert(0, "請選擇"); #endregion #region ars_flag sql_str = "select distinct(t.ars_flag) as ars_flag from onduty t" + " where t.ars_flag is not null"; // ds_temp.Clear(); ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList12.DataSource = ds_temp.Tables[0]; DropDownList12.DataTextField = "ars_flag"; DropDownList12.DataValueField = "ars_flag"; DropDownList12.DataBind(); DropDownList12.Items.Insert(0, "請選擇"); #endregion #region alarm_flag sql_str = "select distinct(t.alarm_flag) as alarm_flag from onduty t" + " where t.alarm_flag is not null"; // ds_temp.Clear(); ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList10.DataSource = ds_temp.Tables[0]; DropDownList10.DataTextField = "alarm_flag"; DropDownList10.DataValueField = "alarm_flag"; DropDownList10.DataBind(); DropDownList10.Items.Insert(0, "請選擇"); #endregion #region type sql_str = " select distinct(t.type) as type from onduty t " + " where t.type not in ('資料異常','MO+過帳失敗','交辦事項','支援部門','設備(搬運系統)','過帳失敗') "; // ds_temp.Clear(); ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList6.DataSource = ds_temp.Tables[0]; DropDownList6.DataTextField = "type"; DropDownList6.DataValueField = "type"; DropDownList6.DataBind(); DropDownList6.Items.Insert(0, "請選擇"); #endregion #region product_impact sql_str = " select distinct(t.product_impact) as product_impact from onduty t " + " where t.product_impact is not null "; ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList7.DataSource = ds_temp.Tables[0]; DropDownList7.DataTextField = "product_impact"; DropDownList7.DataValueField = "product_impact"; DropDownList7.DataBind(); DropDownList7.Items.Insert(0, "請選擇"); #endregion #region 處理者 sql_str = " select distinct(t.bywhom) as bywhom from onduty t " + " where t.bywhom is not null "; ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList9.DataSource = ds_temp.Tables[0]; DropDownList9.DataTextField = "bywhom"; DropDownList9.DataValueField = "bywhom"; DropDownList9.DataBind(); DropDownList9.Items.Insert(0, "請選擇"); #endregion #region Assign To sql_str = " select distinct(t.assign_owner) as assign_owner from onduty t " + " where t.assign_owner not in ('何宗彥', '吳泳潔', '廖建賀', '張松騰', '徐展文', '林校平', '林豐裕', " + " '羅盛平', '胡慶祥', '邵朝文', '賴岳汶', '陳品辰', '陳盈仁', '魏武慶', " + " '黃建友', '黃紹煒','蔡丞','楊炎煌','蕭寶棋','蔡育倫','陳鏞企','吳宗哲','吳宜蓁','呂政達') "; ds_temp = func.get_dataSet_access(sql_str, conn); DropDownList11.DataSource = ds_temp.Tables[0]; DropDownList11.DataTextField = "assign_owner"; DropDownList11.DataValueField = "assign_owner"; DropDownList11.DataBind(); DropDownList11.Items.Insert(0, "請選擇"); DropDownList11.Items.Insert(1, "*"); #endregion Label1.Text = "0"; Label2.Text = "0"; Label3.Text = "0"; Label4.Text = "0"; Label5.Text = "0"; Label1.ForeColor = Color.Red; Label2.ForeColor = Color.Red; Label3.ForeColor = Color.Red; Label4.ForeColor = Color.Red; Label5.ForeColor = Color.Red; bind_data(); //MappTextProvider omapp = new MappTextProvider(); //omapp.SendMessage("12574", "值班紀錄被查詢發送測試"); } }