protected void Page_Init(object sender, EventArgs e) { var _mp = new DlMainpagepopulator(); //get salaries CheckBoxList6.DataSource = _mp.GetSalary(); CheckBoxList6.DataTextField = "sTerm"; CheckBoxList6.DataValueField = "Termid"; CheckBoxList6.DataBind(); //get locations CheckBoxList2.DataSource = _mp.GetLocations(); CheckBoxList2.DataTextField = "sTerm"; CheckBoxList2.DataValueField = "Termid"; CheckBoxList2.DataBind(); //get industry CheckBoxList1.DataSource = _mp.GetIndustries(); CheckBoxList1.DataTextField = "sTerm"; CheckBoxList1.DataValueField = "Termid"; CheckBoxList1.DataBind(); if (Request.QueryString["q"] != null & Request.QueryString["q"] != "all") { TextBox2.Text = Request.QueryString["q"]; } }
protected void Button1_Click(object sender, EventArgs e) { CheckBoxList3.Focus(); CheckBoxList2.Items.Clear(); CheckBoxList3.Items.Clear(); // show Question Button for (int i = 0; i < CheckBoxList1.Items.Count; i++) { if (CheckBoxList1.Items[i].Selected == true) { // fetch question with dropdwn condition SqlCommand Ques_cmd = new SqlCommand(); Ques_cmd.CommandText = "SELECT Question_Id, Question_Details FROM question_bank WHERE Subject_Id =" + DropDownList2.SelectedValue + " AND Chapter_Id =" + CheckBoxList1.Items[i].Value + " AND Minimum_Marks=" + DropDownList3.SelectedValue; Ques_cmd.Connection = cn; SqlDataReader dr = Ques_cmd.ExecuteReader(); // here we assign checkbox2 to question and checkbox3 assign id of question while (dr.Read()) { CheckBoxList2.Items.Add(Convert.ToString(dr.GetValue(1))); CheckBoxList3.Items.Add(Convert.ToString(dr.GetValue(0))); } dr.Close(); } } CheckBoxList2.Focus(); }
private void cargarGrid2() { CheckBoxList2.DataSource = CInstEduc.ctrlNivelEducativo.TraerTodos(); CheckBoxList2.DataTextField = "Descripcion"; CheckBoxList2.DataValueField = "Id"; CheckBoxList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if ((Session[MasterPage.User] as Users)?.Rigths != 2) { Response.Redirect("login.aspx"); } if (IsPostBack) { return; } using (var context = new MainEntities()) { CheckBoxList1.DataSourceID = ""; CheckBoxList2.DataSourceID = ""; var source1 = context.Актеры.ToList(); var source2 = context.Персонажи.ToList(); CheckBoxList1.DataSource = source1.Select(o => $"{o.Имя} {o.Фамилия}").ToList(); CheckBoxList2.DataSource = source2.Select(o => $"{o.Имя} {o.Фамилия}").ToList(); CheckBoxList1.DataBind(); CheckBoxList2.DataBind(); } }
// Reset filters protected void Button6_Click(object sender, EventArgs e) { CheckBoxList1.ClearSelection(); CheckBox1.Checked = false; CheckBoxList2.ClearSelection(); ExecuteSearchAndSorting(); }
private void CheckBoxListItems2() { rootCfg = System.Web.Configuration.WebConfigurationManager.OpenWebConfiguration("/petroneeds"); connection = rootCfg.ConnectionStrings.ConnectionStrings["petroneedsConnectionString2"].ConnectionString.ToString(); con = new SqlConnection(connection); con.ConnectionString = connection; con.Open(); dataset = new DataSet(); comm = new SqlCommand("SELECT MenuName, MenuID, ParentID FROM tbl_WebMenu", con); adapter = new SqlDataAdapter(comm); adapter.Fill(dataset); CheckBoxList2.DataSource = dataset; CheckBoxList2.DataTextField = "MenuName"; CheckBoxList2.DataValueField = "MenuID"; //CheckBoxList1.Items[].FindByValue(0) = "ParentID"; ////CheckBoxList1.SelectedIndex.CompareTo("ParentID"); CheckBoxList2.DataBind(); if (CheckBoxList2.DataValueField.Length == 1) { for (int i = 0; i < CheckBoxList2.Items.Count; i++) { CheckBoxList2.Items[i].Selected = true; } } }
protected void Year_TextChanged(object sender, EventArgs e) { using (SqlConnection sq = new SqlConnection(ConfigurationManager.ConnectionStrings["DBC"].ConnectionString)) { sq.Open(); string q = "select username from auth where status='Unverified' and utype='Student' and dept ='" + (Session["user"].ToString()).Substring(0, 2) + "'"; string q1 = "select Std_id,name as [Name],dob as [DOB],fname as [Father Name],mname as [mother's Name] ,aadhar,address,mob as [Mobile],mail,interper as[12th %],passedclg as [Passed School],passedyer as [Year of passing] from " + (Session["user"].ToString()).Substring(0, 2) + Year.SelectedValue + " where status='Unverified'"; DataTable dt = new DataTable(); SqlDataAdapter da = new SqlDataAdapter(q, sq); da.Fill(dt); if (dt.Rows.Count > 0) { CheckBoxList2.DataSource = dt; CheckBoxList2.DataTextField = "username"; CheckBoxList2.DataBind(); dt.Clear(); SqlDataAdapter d1 = new SqlDataAdapter(q1, sq); dt = new DataTable(); d1.Fill(dt); if (dt.Rows.Count > 0) { GridView1.DataSource = dt; GridView1.DataBind(); da.Dispose(); dt.Clear(); } } sq.Close(); } }
protected void Page_Load(object sender, EventArgs e) { var makes = new List <string> { "Ação", "Animação", "Comédia", "Corridas", "Erótico", "Aventura", "Documentário", "Drama" , "Fantasia", "Ficção", "Guerra", "Musical", "Policial", "Religioso", "Romance", "Terror" }; var ator = new List <string> { "Al Pacino ", "Jack Nicholson", "Chiwetel Ejiofor", "Amanda Peet", "Woody Harrelson", "Morgan Freeman", "Brad Pitt", "Angelina Jolie", "Benedict Cumberbatch", "Salvador Dalí", "Al Dalí", "Miranda Cosgrove", "Rik Mayall", "Jimmy Fallon" }; var escritor = new List <string> { "Roland Emmerich", "Harald Kloser", "Chiwetel Ejiofor", "Amanda Peet", "Arthur C. Clarke ", " Peter Hyams", "Benedict Cumberbatch", "Salvador Dalí", }; var song = new List <string> { "The impact ", "Ashes in D.C", "Singin' in the Rain", "Skyfall", "Born to Be Wild" }; var directores = new List <string> { "Ingmar Bergman", "Benedict Cumberbatch", "Chiwetel Ejiofor", "Amanda Peet", "Salvador Dalí", "Federico Fellini", "Francis Ford Coppola", "Charles Chaplin", "Tim Burton", "Roman Polanski", "Roland Emmerich " }; makes.Sort(); ator.Sort(); escritor.Sort(); song.Sort(); directores.Sort(); CheckBoxList2.DataSource = escritor; CheckBoxList2.DataBind(); cblEmployees.DataSource = ator; cblEmployees.DataBind(); cblEmployees.DataSource = directores; DropDownList1.DataBind(); for (int i = 1889; i < 2016; i++) { DropDownList3.Items.Add(i.ToString()); } CheckBoxList3.DataSource = song; CheckBoxList3.DataBind(); DropDownList2.DataSource = makes; DropDownList2.DataBind(); }
private void Reset() { Text_Name.Text = ""; ceil_new.Text = ""; ceil_old.Text = ""; //TextBox2.Text = ""; CheckBoxList1.ClearSelection(); CheckBoxList2.ClearSelection(); DropDownList1.ClearSelection(); resetSelect(); }
protected void Page_Load(object sender, EventArgs e) { if (Session["UserId"] == null) { Response.Redirect("Welcome.aspx"); } Session.Timeout = 120; SectionPanel.Visible = false; DistrictPanel.CssClass = "col-lg-12"; SqlDataReader re = DataConnection.selectQuery("select * from member where memeberid = " + Convert.ToInt32(Session["RCV"]) + " and admin = 'A'"); if (re.HasRows) { SectionPanel.Visible = true; DistrictPanel.CssClass = "col-lg-6"; } int count = CheckBoxList2.Items.Count; SqlDataReader reader = DataConnection.selectQuery("select location,memeberid from member where Department='section'"); if (reader.HasRows) { //List<String> lst = new List<string>(); while (reader.Read()) { ListItem item = new ListItem(); item.Text = reader.GetString(0); item.Value = reader.GetInt32(1).ToString(); item.Selected = false; CheckBoxList2.Items.Add(item); } } reader.Close(); DataConnection.closeConnection(); //count = CheckBoxList3.Items.Count; reader = DataConnection.selectQuery("select location,memeberid from member where Department='dist'"); if (reader.HasRows) { //List<String> lst = new List<string>(); while (reader.Read()) { ListItem item = new ListItem(); item.Text = reader.GetString(0); item.Value = reader.GetInt32(1).ToString(); item.Selected = false; CheckBoxList3.Items.Add(item); } } reader.Close(); DataConnection.closeConnection(); CheckBoxList2.DataBind(); CheckBoxList3.DataBind(); }
private void BindList() { DataSet ds = new DataSet(); string cmdstr = "select skill from skillstaught"; SqlDataAdapter adp = new SqlDataAdapter(cmdstr, con); adp.Fill(ds); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "skill"; CheckBoxList2.DataValueField = "skill"; CheckBoxList2.DataBind(); }
public void filldrop_a() { DataSet ds = new DataSet(); SqlDataAdapter dp = new SqlDataAdapter("select * from tbl_person where (categoryname=@n)", conn); dp.SelectCommand.Parameters.AddWithValue("@n", "Advisor"); dp.Fill(ds); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "Name"; CheckBoxList2.DataValueField = "supervisorId"; CheckBoxList2.DataBind(); }
public void HastaliklariCek() { baglanti.Open(); SqlCommand komut = new SqlCommand("select hastalik from HastalikTanim", baglanti); SqlDataAdapter adaptor = new SqlDataAdapter(komut); DataSet DS = new DataSet(); adaptor.Fill(DS); baglanti.Close(); CheckBoxList2.DataSource = DS.Tables[0]; CheckBoxList2.DataTextField = "hastalik"; CheckBoxList2.DataBind(); }
protected void Page_Load(object sender, EventArgs e) { if (!Context.User.IsInRole("ServiceLine Manager")) { Response.Redirect("Access.aspx"); } string ServiceName = Request.QueryString["ServLineName"]; ServLineName.Text = ServiceName; if (!IsPostBack) { string ServLineName = Request.QueryString["ServLineName"]; //OMCheckList.Text = ServLineName; string ServLineId = Request.QueryString["ID"]; int ServLineId1 = Convert.ToInt32(Request.QueryString["ID"]); ServiceLineRepository SLrepo = new ServiceLineRepository(); SLMServiceLine SlMRepo = new SLMServiceLine(); SlMRepo.getServLineOMDetails(ServLineId); SlMRepo.getAllOMDetails(); SlMRepo.getAllOMDetailsOfServiceLineManagers(ServLineId); SelectAllUsers selectAllUsers = new SelectAllUsers(); OMCheckList.DataSource = SlMRepo.ServLineOMTab; OMCheckList.DataTextField = "UserName"; OMCheckList.DataValueField = "Id"; OMCheckList.DataBind(); for (int i = 0; i < OMCheckList.Items.Count; i++) { OMCheckList.Items[i].Selected = true; string OmId = OMCheckList.Items[i].Value; SLrepo.EditServiceLineOMwhileload(ServLineId1, OmId); } //OMCheckList1.DataSource = SlMRepo.ServLineOMList; //OMCheckList1.DataTextField = "UserName"; //OMCheckList1.DataValueField = "Id"; //OMCheckList1.DataBind(); //CheckBoxList2.DataSource = SlMRepo.getAllOMDetailsOfServiceLineManagers(ServLineId); CheckBoxList2.DataSource = SlMRepo.ServLineOMList; CheckBoxList2.DataTextField = "UserName"; CheckBoxList2.DataValueField = "Id"; CheckBoxList2.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { //set default inputs TextBox2.Focus(); //Page.Form.DefaultButton = ImageButton2.UniqueID; CLMainpagepopulator cmpag = new CLMainpagepopulator(); if (!IsPostBack) { //constructor CLMainpagepopulator mp = new CLMainpagepopulator(); //get count of all jobs Label13.Text = mp.getcountjobs() + " Jobs Advertized from " + mp.getcountrecswadvert() + " Recruiters"; //populate left //get salaries CheckBoxList6.DataSource = mp.getSalary(); CheckBoxList6.DataTextField = "sTerm"; CheckBoxList6.DataValueField = "Termid"; CheckBoxList6.DataBind(); //get locations CheckBoxList2.DataSource = mp.getLocations(); CheckBoxList2.DataTextField = "sTerm"; CheckBoxList2.DataValueField = "Termid"; CheckBoxList2.DataBind(); //get industry CheckBoxList1.DataSource = mp.getIndustries(); CheckBoxList1.DataTextField = "sTerm"; CheckBoxList1.DataValueField = "Termid"; CheckBoxList1.DataBind(); //main job binding CLMainpagepopulator mpgp = new CLMainpagepopulator(); GridView1.DataSource = mpgp.getJobssingle(); GridView1.DataBind(); //featured Recruiters ClFeaturedrecruiters frec = new ClFeaturedrecruiters(); GridView2.DataSource = frec.GetFRecs(); GridView2.DataBind(); } }
private void BindCheckBoxList() { List <TestClass> myList = new List <TestClass>(); myList.Add(new TestClass("1", "数据绑定值 1")); myList.Add(new TestClass("2", "数据绑定值 2")); myList.Add(new TestClass("3", "数据绑定值 3")); myList.Add(new TestClass("4", "数据绑定值 4")); CheckBoxList2.DataTextField = "Name"; CheckBoxList2.DataValueField = "Id"; CheckBoxList2.DataSource = myList; CheckBoxList2.DataBind(); CheckBoxList2.SelectedValueArray = new string[] { "1", "3" }; }
private void LoadPlantName() { try { Datechanged(); String dbConnStr = ConfigurationManager.ConnectionStrings["AMPSConnectionString"].ConnectionString; SqlConnection conn = null; using (conn = new SqlConnection(dbConnStr)) { SqlCommand sqlCmd = new SqlCommand("dbo.[Get_PlantwiseSingleBilldateOverAllDataReport]"); conn.Open(); sqlCmd.Connection = conn; sqlCmd.CommandType = CommandType.StoredProcedure; sqlCmd.Parameters.AddWithValue("@spccode", Company_code); sqlCmd.Parameters.AddWithValue("@spfrmdate", d1.ToString()); sqlCmd.Parameters.AddWithValue("@sptodate", d2.ToString()); SqlDataAdapter da = new SqlDataAdapter(sqlCmd); da.Fill(ds); if (ds != null) { CheckBoxList1.DataSource = ds; CheckBoxList1.DataTextField = "PlantName"; CheckBoxList1.DataValueField = "pcode"; CheckBoxList1.DataBind(); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "Frmtodate2"; CheckBoxList2.DataValueField = "Frmtodate3"; CheckBoxList2.DataBind(); CheckBoxList3.DataSource = ds; CheckBoxList3.DataTextField = "Frmtodate1"; CheckBoxList3.DataValueField = "Frmtodate4"; CheckBoxList3.DataBind(); } else { } } } catch (Exception ex) { Lbl_Errormsg.Visible = true; Lbl_Errormsg.Text = ex.ToString(); } }
protected void DropDownList2_Changed(object sender, EventArgs e) { //绑定还未下载的作业 if (DropDownList2.SelectedIndex != 0 && DropDownList1.SelectedIndex != 0) { classid = Convert.ToInt32(DropDownList1.SelectedValue); times = Convert.ToInt32(DropDownList2.SelectedValue); DataTable dt = BLL.Homework.BLLGetHomeworkToDownload(classid, times); CheckBoxList1.DataSource = dt; CheckBoxList1.DataTextField = dt.Columns[2].ColumnName; CheckBoxList1.DataValueField = dt.Columns[1].ColumnName; CheckBoxList1.DataBind(); } else if (DropDownList2.SelectedIndex == 1 && DropDownList1.SelectedIndex != 0) { classid = Convert.ToInt32(DropDownList1.SelectedValue); times = 0; DataTable dt = BLL.Homework.BLLGetHomeworkToDownload(classid, times); CheckBoxList1.DataSource = dt; CheckBoxList1.DataTextField = dt.Columns[2].ColumnName; CheckBoxList1.DataValueField = dt.Columns[1].ColumnName; CheckBoxList1.DataBind(); } //绑定已下载的作业 if (DropDownList2.SelectedIndex != 0 && DropDownList2.SelectedIndex != 1 && DropDownList1.SelectedIndex != 0) { classid = Convert.ToInt32(DropDownList1.SelectedValue); times = Convert.ToInt32(DropDownList2.SelectedValue); DataTable dt = BLL.Homework.BLLGetDownloadedHomework(classid, times); CheckBoxList2.DataSource = dt; CheckBoxList2.DataTextField = dt.Columns[2].ColumnName; CheckBoxList2.DataValueField = dt.Columns[1].ColumnName; CheckBoxList2.DataBind(); } else if (DropDownList2.SelectedIndex == 1 && DropDownList1.SelectedIndex != 0) { classid = Convert.ToInt32(DropDownList1.SelectedValue); times = 0; DataTable dt = BLL.Homework.BLLGetDownloadedHomework(classid, times); CheckBoxList2.DataSource = dt; CheckBoxList2.DataTextField = dt.Columns[2].ColumnName; CheckBoxList2.DataValueField = dt.Columns[1].ColumnName; CheckBoxList2.DataBind(); } }
public void sizefilter() { MessageBox msg = new MessageBox(); DataTable ds = filter.fillfilterbytype("size"); if (ds.Rows.Count == 0) { } else { CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = ds.Columns["filtervalue"].ToString(); CheckBoxList2.DataValueField = ds.Columns["id"].ToString(); CheckBoxList2.DataBind(); } }
private void InitCheckBoxList2() { List <TestClass> myList = new List <TestClass>(); myList.Add(new TestClass("value1", "可选项 1")); myList.Add(new TestClass("value2", "可选项 2")); myList.Add(new TestClass("value3", "可选项 3")); myList.Add(new TestClass("value4", "可选项 4")); myList.Add(new TestClass("value5", "可选项 5")); myList.Add(new TestClass("value6", "可选项 6")); CheckBoxList2.DataTextField = "Name"; CheckBoxList2.DataValueField = "Id"; CheckBoxList2.DataSource = myList; CheckBoxList2.DataBind(); CheckBoxList2.SelectedValueArray = new string[] { "value1", "value2", "value3" }; }
protected void Page_Load(object sender, EventArgs e) { if (User.Identity.Name.ToString() == "") { Response.Redirect("/Default.aspx"); } List <AspNetUser> listUsers = new List <AspNetUser>(); List <AspNetUser> listManagers = new List <AspNetUser>(); AspNetUser potochnuj = new AspNetUser(); StreamWriter wr = new StreamWriter(@"E:\logWebSite5.txt", true); wr.WriteLine("Page_Load()"); using (var db = new Entities5()) { listUsers = db.AspNetUsers.Where(m => m.ManagerRights != true).ToList(); listManagers = db.AspNetUsers.Where(m => m.ManagerRights == true).ToList(); foreach (AspNetUser m in listManagers) { wr.WriteLine("m.UserName = "******" User.Identity.Name.ToString())" + User.Identity.Name.ToString()); if (m.UserName == User.Identity.Name.ToString()) { potochnuj = m; } } } wr.Close(); listManagers.Remove(potochnuj); CheckBoxList1.DataSource = listUsers; CheckBoxList1.DataTextField = "UserName"; CheckBoxList1.DataValueField = "Id"; CheckBoxList2.DataSource = listManagers; CheckBoxList2.DataTextField = "UserName"; CheckBoxList2.DataValueField = "Id"; if (!IsPostBack) { CheckBoxList1.DataBind(); CheckBoxList2.DataBind(); } }
void advisorList() { con.Open(); DataSet ds = new DataSet(); SqlDataAdapter adp = new SqlDataAdapter("select * from advTable", con); adp.Fill(ds); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "Name"; CheckBoxList2.DataValueField = "CNIC"; CheckBoxList2.DataBind(); con.Close(); }
protected void Button2_Click(object sender, EventArgs e) { TextBox1.Enabled = true; TextBox2.Enabled = true; TextBox3.Enabled = true; TextBox4.Enabled = true; TextBox5.Enabled = true; CheckBoxList2.Enabled = true; CheckBoxList3.Enabled = true; CheckBoxList4.Enabled = true; CheckBoxList1.Enabled = true; Label1.Text = null; TextBox1.Text = null; TextBox2.Text = null; TextBox3.Text = null; TextBox4.Text = null; TextBox5.Text = null; CheckBoxList2.ClearSelection(); CheckBoxList3.ClearSelection(); CheckBoxList4.ClearSelection(); CheckBoxList1.ClearSelection(); }
private void LoadPlantName1() { try { DataSet ds = new DataSet(); String dbConnStr = ConfigurationManager.ConnectionStrings["AMPSConnectionString"].ConnectionString; SqlConnection conn = null; using (conn = new SqlConnection(dbConnStr)) { SqlCommand sqlCmd = new SqlCommand("dbo.[GetPaymentAllot_BalanceAmount]"); conn.Open(); sqlCmd.Connection = conn; sqlCmd.CommandType = CommandType.StoredProcedure; SqlDataAdapter da = new SqlDataAdapter(sqlCmd); da.Fill(ds); if (ds != null) { CheckBoxList1.DataSource = ds; CheckBoxList1.DataTextField = "Plant"; CheckBoxList1.DataValueField = "Plant";//ROUTE_ID CheckBoxList1.DataBind(); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "BalanceAmount"; CheckBoxList2.DataValueField = "BalanceAmount";//ROUTE_ID CheckBoxList2.DataBind(); CheckBoxList3.DataSource = ds; CheckBoxList3.DataTextField = "Billdate"; CheckBoxList3.DataValueField = "Billdate";//ROUTE_ID CheckBoxList3.DataBind(); } } } catch (Exception ex) { } }
protected void Page_Init(object sender, EventArgs e) { var mp = new DlMainpagepopulator(); //get locations CheckBoxList2.DataSource = mp.GetLocations(); CheckBoxList2.DataTextField = "sTerm"; CheckBoxList2.DataValueField = "Termid"; CheckBoxList2.DataBind(); //get industry CheckBoxList1.DataSource = mp.GetIndustries(); CheckBoxList1.DataTextField = "sTerm"; CheckBoxList1.DataValueField = "Termid"; CheckBoxList1.DataBind(); //get salary CheckBoxList6.DataSource = mp.Getsalaries(); CheckBoxList6.DataTextField = "sTerm"; CheckBoxList6.DataValueField = "Termid"; CheckBoxList6.DataBind(); }
private void BindCheckBoxListMaster(int tidd) { try { ds = MBLL.GetSubMenuTitleCheckBoxMaster(tidd); if (tidd == 1) { CheckBoxList1.DataSource = ds; CheckBoxList1.DataTextField = "SubMenuName"; CheckBoxList1.DataValueField = "SubMenuValue"; CheckBoxList1.DataBind(); } else if (tidd == 2) { CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "SubMenuName"; CheckBoxList2.DataValueField = "SubMenuValue"; CheckBoxList2.DataBind(); } else if (tidd == 3) { CheckBoxList3.DataSource = ds; CheckBoxList3.DataTextField = "SubMenuName"; CheckBoxList3.DataValueField = "SubMenuValue"; CheckBoxList3.DataBind(); } else if (tidd == 4) { CheckBoxList4.DataSource = ds; CheckBoxList4.DataTextField = "SubMenuName"; CheckBoxList4.DataValueField = "SubMenuValue"; CheckBoxList4.DataBind(); } } catch (Exception ex) { ex.Message.ToString(); } }
private void loadBranch() { BusinessLogic bl = new BusinessLogic(sDataSource); DataSet ds = new DataSet(); string connection = ConfigurationManager.ConnectionStrings[Request.Cookies["Company"].Value].ToString(); lstBranch.Items.Clear(); brncode = Request.Cookies["Branch"].Value; if (brncode == "All") { ds = bl.ListBranch(); // lstBranch.Items.Add(new ListItem("All", "0")); CheckBoxList1.Visible = true; lblbranch.Text = "Select Branch(es)"; single.Visible = false; single1.Visible = false; // div1.Visible = false; } else { ds = bl.ListDefaultBranch(brncode); CheckBoxList1.Visible = false; // lblbranch.Text = "Select Branch"; multi.Visible = false; select.Visible = false; } lstBranch.DataSource = ds; lstBranch.DataTextField = "BranchName"; lstBranch.DataValueField = "Branchcode"; lstBranch.DataBind(); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "BranchName"; CheckBoxList2.DataValueField = "Branchcode"; CheckBoxList2.DataBind(); }
private void BindprocurementRemarksData() { try { DateTime dt1 = new DateTime(); dt1 = DateTime.ParseExact(txt_RemmarksDate.Text, "dd/MM/yyyy", null); if (rd_sesAm.Checked == true) { ses = "AM"; } else { ses = "PM"; } string d1 = dt1.ToString("MM/dd/yyyy"); ds = Bllproimp.LoadProocurementRemarksDatas(ccode, pcode, d1, ses, IncdecFlag); if (ds != null) { CheckBoxList_Sno.DataSource = ds; CheckBoxList_Sno.DataTextField = "serial_no"; CheckBoxList_Sno.DataValueField = "serial_no"; CheckBoxList_Sno.DataBind(); CheckBoxList1.DataSource = ds; CheckBoxList1.DataTextField = "SampleId"; CheckBoxList1.DataValueField = "SampleId"; CheckBoxList1.DataBind(); CheckBoxList2.DataSource = ds; CheckBoxList2.DataTextField = "agent_Id"; CheckBoxList2.DataValueField = "agent_Id"; CheckBoxList2.DataBind(); CheckBoxList3.DataSource = ds; CheckBoxList3.DataTextField = "milk_Kg"; CheckBoxList3.DataValueField = "milk_Kg"; CheckBoxList3.DataBind(); CheckBoxList4.DataSource = ds; CheckBoxList4.DataTextField = "fat"; CheckBoxList4.DataValueField = "fat"; CheckBoxList4.DataBind(); CheckBoxList5.DataSource = ds; CheckBoxList5.DataTextField = "snf"; CheckBoxList5.DataValueField = "snf"; CheckBoxList5.DataBind(); CheckBoxList6.DataSource = ds; CheckBoxList6.DataTextField = "magent_Id"; CheckBoxList6.DataValueField = "magent_Id"; CheckBoxList6.DataBind(); CheckBoxList7.DataSource = ds; CheckBoxList7.DataTextField = "mmilk_Kg"; CheckBoxList7.DataValueField = "mmilk_Kg"; CheckBoxList7.DataBind(); CheckBoxList8.DataSource = ds; CheckBoxList8.DataTextField = "mfat"; CheckBoxList8.DataValueField = "mfat"; CheckBoxList8.DataBind(); CheckBoxList9.DataSource = ds; CheckBoxList9.DataTextField = "msnf"; CheckBoxList9.DataValueField = "msnf"; CheckBoxList9.DataBind(); } //Adding color to differenciate the remarks modifications Start SetColorRemarksData(); //Adding color to differenciate the remarks modifications End } catch (Exception ex) { } CheckBoxListClear1(); }
/// <summary> /// 加载施工人员 /// </summary> /// <param name="iID"></param> private void LoadSGRY(int iID) { if (iID > 0) { /// 施工员和安装员组用户才加载 string strSQL = "SELECT S_USERINFO.ID,' '+CNAME+' '+ISNULL(SSDZ,'')+' ' NAME,(Select count(id) from W_GCGD_USERS where W_GCGD_USERS.USERS=S_USERINFO.ID and GCDID=" + iID + ") Selected from S_USERINFO,S_YH_QXZ where FLAG=0 and S_USERINFO.id=S_YH_QXZ.USERID and QXZID =3 order by cname"; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { this.Div1.Visible = true; CheckBoxList1.DataTextField = "NAME"; CheckBoxList1.DataValueField = "ID"; CheckBoxList1.DataSource = OP_Mode.Dtv; CheckBoxList1.DataBind(); string arr1 = string.Empty;; for (int i = 0; i < OP_Mode.Dtv.Count; i++) { if (Convert.ToInt32(OP_Mode.Dtv[i]["Selected"]) > 0) { arr1 += OP_Mode.Dtv[i]["ID"] + ","; } } foreach (ListItem lst in this.CheckBoxList1.Items) { string[] arr = arr1.Trim().Split(','); for (int i = 0; i < arr.Length; i++) { if (arr[i].ToString().Equals(lst.Value)) { lst.Selected = true; } } } } else { this.Div1.Visible = false; } } else { MessageBox("", strSQL + " " + OP_Mode.strErrMsg); } /// 施工员和安装员组用户才加载 strSQL = "SELECT S_USERINFO.ID,' '+CNAME+' '+ISNULL(SSDZ,'')+' ' NAME,(Select count(id) from W_GCGD_USERS where W_GCGD_USERS.USERS=S_USERINFO.ID and GCDID=" + iID + ") Selected from S_USERINFO,S_YH_QXZ where FLAG=0 and S_USERINFO.id=S_YH_QXZ.USERID and QXZID =4 order by cname"; if (OP_Mode.SQLRUN(strSQL)) { if (OP_Mode.Dtv.Count > 0) { this.Div1.Visible = true; CheckBoxList2.DataTextField = "NAME"; CheckBoxList2.DataValueField = "ID"; CheckBoxList2.DataSource = OP_Mode.Dtv; CheckBoxList2.DataBind(); string arr1 = string.Empty;; for (int i = 0; i < OP_Mode.Dtv.Count; i++) { if (Convert.ToInt32(OP_Mode.Dtv[i]["Selected"]) > 0) { arr1 += OP_Mode.Dtv[i]["ID"] + ","; } } foreach (ListItem lst in this.CheckBoxList2.Items) { string[] arr = arr1.Trim().Split(','); for (int i = 0; i < arr.Length; i++) { if (arr[i].ToString().Equals(lst.Value)) { lst.Selected = true; } } } } else { this.Div1.Visible = false; } } else { MessageBox("", strSQL + " " + OP_Mode.strErrMsg); } } }
protected void Button1_Click(object sender, EventArgs e) { string message = ""; string memberno = ""; CheckBoxList2.DataBind(); CheckBoxList3.DataBind(); CheckBoxList4.DataBind(); CheckBoxList5.DataBind(); CheckBoxList6.DataBind(); if (Session["sgques"].ToString() == "SendData") { DataConnection.insertQuery("update message set sgsubmit='T' where QNO=N'" + Session["quesno"].ToString() + "' and Assemblys=N'" + Session["sadan"].ToString() + "' and Session=N'" + Session["session"].ToString() + "'"); DataConnection.insertQuery("insert into miscellenous (other_posist_name,posist_no,posist_date,answer_mem_name,ans_no,ans_date,remark,session,assemblys,quesno) values('" + TextBox8.Text + "','" + TextBox9.Text + "','" + Convert.ToDateTime(TextBox10.Text) + "','" + TextBox11.Text + "','" + TextBox12.Text + "','" + Convert.ToDateTime(TextBox13.Text) + "','" + TextBox14.Text + "','" + Session["session"].ToString() + "','" + Session["sadan"] + "'," + Convert.ToInt32(Session["quesno"].ToString()) + ")"); Response.Redirect("Dashboard.aspx"); } else { if (getCheckBoxCount(CheckBoxList2) > 0) { for (int i = 0; i < CheckBoxList2.Items.Count; i++) { if (CheckBoxList2.Items[i].Selected) { SqlDataReader r1 = DataConnection.selectQuery("select memeberid from member where member_name=N'" + CheckBoxList2.Items[i].Text.Trim() + "'"); if (r1.HasRows) { while (r1.Read()) { memberno = r1.GetInt32(0).ToString(); } } r1.Close(); DataConnection.insertQuery("insert into message(QNO,RCV,Sender,Assemblys,Session) values(N'" + Session["quesno"].ToString() + "',N'" + memberno + "',N'" + Session["RCV"].ToString() + "',N'" + Session["assembly"].ToString() + "',N'" + Session["Session"].ToString() + "')"); } } } if (getCheckBoxCount(CheckBoxList3) > 0) { for (int i = 0; i < CheckBoxList3.Items.Count; i++) { if (CheckBoxList3.Items[i].Selected) { SqlDataReader r = DataConnection.selectQuery("select memeberid from member where location=N'" + CheckBoxList3.Items[i].Text.Trim() + "'"); if (r.HasRows) { while (r.Read()) { memberno = r.GetInt32(0).ToString(); } } r.Close(); DataConnection.insertQuery("insert into message(QNO,RCV,Sender,Assemblys,Session) values(N'" + Session["quesno"].ToString() + "',N'" + memberno + "',N'" + Session["RCV"].ToString() + "',N'" + Session["assembly"].ToString() + "',N'" + Session["Session"].ToString() + "')"); } } } if (getCheckBoxCount(CheckBoxList4) > 0) { for (int i = 0; i < CheckBoxList4.Items.Count; i++) { if (CheckBoxList4.Items[i].Selected) { SqlDataReader re = DataConnection.selectQuery("select memeberid from member where location=N'" + CheckBoxList4.Items[i].Text.Trim() + "'"); if (re.HasRows) { while (re.Read()) { memberno = re.GetInt32(0).ToString(); } re.Close(); DataConnection.insertQuery("insert into message(QNO,RCV,Sender,Assemblys,Session) values(N'" + Session["quesno"].ToString() + "',N'" + memberno + "',N'" + Session["RCV"].ToString() + "',N'" + Session["assembly"].ToString() + "',N'" + Session["Session"].ToString() + "')"); } } } } if (getCheckBoxCount(CheckBoxList5) > 0) { for (int i = 0; i < CheckBoxList5.Items.Count; i++) { if (CheckBoxList5.Items[i].Selected) { SqlDataReader re2 = DataConnection.selectQuery("select memeberid from member where location=N'" + CheckBoxList5.Items[i].Text.Trim() + "'"); if (re2.HasRows) { while (re2.Read()) { memberno = re2.GetInt32(0).ToString(); } re2.Close(); DataConnection.insertQuery("insert into message(QNO,RCV,Sender,Assemblys,Session) values(N'" + Session["quesno"].ToString() + "',N'" + memberno + "',N'" + Session["RCV"].ToString() + "',N'" + Session["assembly"].ToString() + "',N'" + Session["Session"].ToString() + "')"); } } } } if (getCheckBoxCount(CheckBoxList6) > 0) { for (int i = 0; i < CheckBoxList6.Items.Count; i++) { if (CheckBoxList6.Items[i].Selected) { SqlDataReader re3 = DataConnection.selectQuery("select memeberid from member where location=N'" + CheckBoxList6.Items[i].Text.Trim() + "'"); if (re3.HasRows) { while (re3.Read()) { memberno = re3.GetInt32(0).ToString(); } re3.Close(); DataConnection.insertQuery("insert into message(QNO,RCV,Sender,Assemblys,Session) values(N'" + Session["quesno"].ToString() + "',N'" + memberno + "',N'" + Session["RCV"].ToString() + "',N'" + Session["assembly"].ToString() + "',N'" + Session["Session"].ToString() + "')"); } } } } if (getCheckBoxCount(CheckBoxList2) < 0) { message = "Select Atleast Section "; ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('" + message + "');", true); return; } } message = "Data has Stored Successfully"; ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "alert('" + message + "');", true); Response.Redirect("Dashboard.aspx"); }