private void BindingItem(DataListItemEventArgs e) { DataRowView dr = (DataRowView)e.Item.DataItem; string q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]); string q_sbj_name = DataTypeUtility.GetValue(dr["Q_SBJ_NAME"]); string q_sbj_define = DataTypeUtility.GetValue(dr["Q_SBJ_DEFINE"]); double weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]); quizWeight.Columns.Add(q_sbj_id, typeof(double)); if (quizWeight.Rows.Count == 0) { quizWeight.Rows.Add(weight / 100); } else { quizWeight.Rows[0][q_sbj_id] = weight / 100; } Literal ltrSbjName = e.Item.FindControl("ltrLevelSbjName") as Literal; Literal ltrSbjDefine = e.Item.FindControl("ltrLevelSbjDefine") as Literal; RadioButtonList rBtnList = e.Item.FindControl("rBtnList") as RadioButtonList; TextBox txtValue = e.Item.FindControl("txtLevelValue") as TextBox; HiddenField hdfSubItmYN = e.Item.FindControl("tmpSubItmYN") as HiddenField; Literal ltrPointData = e.Item.FindControl("ltrLevelPointData") as Literal; DataList dtList = e.Item.FindControl("DataList3") as DataList; HtmlTableCell tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell; HtmlTableCell tdContent = null; if (dtList == null) { tdContent = e.Item.FindControl("tdContent") as HtmlTableCell; } else { tdContent = dtList.FindControl("tdContent") as HtmlTableCell; } TextBoxCommon.SetOnlyPercent(txtValue); ltrSbjName.Text = q_sbj_name; ltrSbjDefine.Text = q_sbj_define; Biz_QuestionItems questionItems = new Biz_QuestionItems(); DataSet ds = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID); SUBJECT_ITEM_YN = ds.Tables[0].Rows[0]["SUBJECT_ITEM_YN"].ToString(); hdfSubItmYN.Value = SUBJECT_ITEM_YN; if (ds.Tables[0].Rows.Count == 0) { rBtnList.Visible = false; txtValue.Visible = false; txtValue.Width = Unit.Percentage(100); } else if (SUBJECT_ITEM_YN == "1") { rBtnList.Visible = false; txtValue.Visible = true; txtValue.Width = Unit.Percentage(100); Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , EST_DEPT_ID , EST_EMP_ID , PRJ_REF_ID , q_sbj_id); txtValueText = questionDatas.Text_Value; txtValue.Text = txtValueText; } else { rBtnList.Visible = true; txtValue.Visible = false; // 만약 질의항목에 설명을 표시할 경우 if (_q_item_desc_use_yn.Equals("Y")) { rBtnList.RepeatLayout = RepeatLayout.Table; rBtnList.DataTextField = "Q_ITEM_DESC"; tdHeader.Style.Add("width", "260px"); if (tdContent != null) { tdContent.Style.Add("width", "262px"); } } rBtnList.DataSource = ds; rBtnList.DataBind(); if (READ_ONLY_YN.Equals("N")) { //Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID // , EST_ID // , ESTTERM_REF_ID // , ESTTERM_SUB_ID // , ESTTERM_STEP_ID // , EST_DEPT_ID // , EST_EMP_ID // , PRJ_REF_ID // , q_sbj_id); //// 데이타 바인딩 //WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID); Biz_Prj_QuestionData questionDatas = new Biz_Prj_QuestionData(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , ESTTERM_STEP_ID , EST_DEPT_ID , EST_EMP_ID , TGT_EMP_ID , PRJ_REF_ID , q_sbj_id); // 데이타 바인딩 WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID); groupNumber += questionDatas.Point; if (questionDatas.Point.Equals(0)) { noneSelectCount = noneSelectCount + 1; } if (questionDatas.Point > 0) { ltrPointData.Text = "<font color=#BF0000>" + DataTypeUtility.GetToInt32_String(questionDatas.Point, "##.#0") + "</font>점"; //TOTALPOINT += questionDatas.Point * weight; } //----------------- 라디오버튼 유효성 검사 시작 ------------------- string clientIDs = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (i != 0) { clientIDs += ";"; } clientIDs += rBtnList.ClientID + "_" + i.ToString(); } VALID_SCRIPT += string.Format("if(ValidQuestion('{0}', '{1}') == false) return false;", dr["Q_SBJ_NAME"], clientIDs); //----------------- 라디오버튼 유효성 검사 끝 ------------------- } } }
protected void DataList1_ItemDataBound(object sender, DataListItemEventArgs e) { HiddenField c = (HiddenField)e.Item.FindControl("hfRoleName"); HtmlGenericControl div = (HtmlGenericControl)e.Item.FindControl("cddSection"); //string txt = Value; //string query = $"Select Candidate_Name, RoleName from Candidate where RoleName= '{c.Value}' AND (RoleStatus = 'Active') "; string query = $"SELECT DISTINCT c.Candidate_Name, c.RoleID, c.RoleImages, c.ManifestoName, p.PollID, p.PollRole, p.PollQuestion, p.PollName FROM tblPoll AS p INNER JOIN Candidate AS c ON p.RoleID = c.RoleID "; using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["smartElectorConnectionString"].ConnectionString)) { SqlCommand com = new SqlCommand(query, con); try { con.Open(); DataTable dtblCandidates = new DataTable(); SqlDataAdapter sqlDA = new SqlDataAdapter(query, con); sqlDA.Fill(dtblCandidates); DataList dt = DataList1; //Repeater rp = dt.FindControl("ProductsByCategoryList") as Repeater FormView FV = dt.FindControl("FVCandidateList") as FormView; if (dtblCandidates.Rows.Count > 0) { dt.DataSource = dtblCandidates; dt.DataBind(); } //var reader = com.ExecuteReader(); //if (reader.HasRows) //{ // List<User> listusers = new List<User>(); // string html = "<div>"; // while (reader.Read()) // { // RadioButton u = new RadioButton(); // Dictionary<string, string> listCandidatename = new Dictionary<string, string>(); // for (int i = 0; reader.Read(); i++) // { // listCandidatename[reader.GetString(1)] = reader.GetValue(1).ToString(); // } // html += "<Label> " + reader.GetString(0) + @" </Label>"; // //html += @"<asp:RadioButtonList ID='rbInsertVote' runat='server' DataSourceID='SqlDataSource1' DataTextField='Candidate_Name' DataValueField='Candidate_Name'> // // <asp:ListItem></asp:ListItem> // //</asp:RadioButtonList>"; // u.Text = reader["Candidate_Name"].ToString(); // Controls.Add(u); // } // html += "<div>"; // div.InnerHtml = html; //} con.Close(); } catch (Exception ex) { } } }
private void BindingItem_P(DataListItemEventArgs e) { DataRowView dr = (DataRowView)e.Item.DataItem; string q_sbj_id = DataTypeUtility.GetValue(dr["Q_SBJ_ID"]); string q_sbj_name = DataTypeUtility.GetValue(dr["Q_SBJ_NAME"]); string q_sbj_define = DataTypeUtility.GetValue(dr["Q_SBJ_DEFINE"]); double weight = DataTypeUtility.GetToDouble(dr["WEIGHT"]); Literal ltrSbjName = e.Item.FindControl("ltrLevelSbjName") as Literal; Literal ltrSbjDefine = e.Item.FindControl("ltrLevelSbjDefine") as Literal; RadioButtonList rBtnList = e.Item.FindControl("rBtnList") as RadioButtonList; TextBox txtValue = e.Item.FindControl("txtLevelValue") as TextBox; Literal ltrPointData = e.Item.FindControl("ltrLevelPointData") as Literal; DataList dtList = e.Item.FindControl("DataList3") as DataList; HtmlTableRow trTextValue = e.Item.FindControl("trTextValue") as HtmlTableRow; HtmlTableCell tdHeader = null; HtmlTableCell tdContent = null; if (dtList == null) { //tdHeader = Page.FindControl("tdHeader") as HtmlTableCell; tdContent = e.Item.FindControl("tdContent") as HtmlTableCell; } else { //tdHeader = e.Item.FindControl("tdHeader") as HtmlTableCell; tdContent = dtList.FindControl("tdContent") as HtmlTableCell; } //TextBoxCommon.SetOnlyInteger(txtValue); ltrSbjName.Text = q_sbj_name; ltrSbjDefine.Text = q_sbj_define; Biz_QuestionItems questionItems = new Biz_QuestionItems(); DataSet ds = questionItems.GetQuestionItem("", q_sbj_id, Q_OBJ_ID); if (ds.Tables[0].Rows.Count == 0) { rBtnList.Visible = false; txtValue.Visible = false; txtValue.Width = Unit.Percentage(100); } else if (ds.Tables[0].Rows[0]["SUBJECT_ITEM_YN"].ToString() == "1") { rBtnList.Visible = false; txtValue.Visible = true; txtValue.Width = Unit.Percentage(100); } else { rBtnList.Visible = true; // 만약 질의항목에 설명을 표시할 경우 if (_q_item_desc_use_yn.Equals("Y")) { rBtnList.RepeatLayout = RepeatLayout.Table; rBtnList.DataTextField = "Q_ITEM_DESC"; //tdHeader.Style.Add("width", "260px"); if (tdContent != null) { tdContent.Style.Add("width", "262px"); } } // 만약 피드백을 적용할 경우 if (_feedback_yn.Equals("Y")) { if (EST_TGT_TYPE.Equals("TGT")) { txtValue.ReadOnly = true; rBtnList.Enabled = false; } trTextValue.Visible = true; } rBtnList.DataSource = ds; rBtnList.DataBind(); Biz_QuestionDatas questionDatas = new Biz_QuestionDatas(COMP_ID , EST_ID , ESTTERM_REF_ID , ESTTERM_SUB_ID , this.IESTTERM_STEP_PREVIOUS_SELECT , 0 , 0 , TGT_DEPT_ID , TGT_EMP_ID , q_sbj_id); // 데이타 바인딩 WebUtility.FindByValueRadioButtonList(rBtnList, questionDatas.Q_Itm_ID); if (questionDatas.Point > 0) { ltrPointData.Text = "<font color=#BF0000>" + DataTypeUtility.GetToInt32_String(questionDatas.Point, "##.#0") + "</font>점"; } //----------------- 라디오버튼 유효성 검사 시작 ------------------- string clientIDs = ""; for (int i = 0; i < ds.Tables[0].Rows.Count; i++) { if (i != 0) { clientIDs += ";"; } clientIDs += rBtnList.ClientID + "_" + i.ToString(); } VALID_SCRIPT += string.Format("if(ValidQuestion('{0}', '{1}') == false) return false;", dr["Q_SBJ_NAME"], clientIDs); //----------------- 라디오버튼 유효성 검사 끝 ------------------- } }
protected void DataList1_ItemCommand(object source, DataListCommandEventArgs e) { MembershipUser currentUser = Membership.GetUser(); Guid currentUserId = (Guid)currentUser.ProviderUserKey; DataList lv = (DataList)source; String req_from = lv.DataKeys[e.Item.ItemIndex].ToString(); Label lblNotify = lv.FindControl("LabelNotify") as Label; if (e.CommandName == "CommandAccept") { string connectionString = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string updateSql = "UPDATE FriendRequests SET Request_status = @Request_status WHERE Request_to = @Request_to"; try { using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(updateSql, myConnection); myCommand.Parameters.AddWithValue("@Request_to", currentUserId); myCommand.Parameters.AddWithValue("@Request_status", 1); myCommand.ExecuteNonQuery(); myConnection.Close(); } } catch { } System.Data.SqlClient.SqlDataReader rdr = null; System.Data.SqlClient.SqlConnection conn = null; System.Data.SqlClient.SqlCommand sqlcmd = null; try { string connectionString3 = System.Configuration.ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; conn = new System.Data.SqlClient.SqlConnection(connectionString3); sqlcmd = new System.Data.SqlClient.SqlCommand("select * from [FriendsList] where my_id='" + currentUserId + "'", conn); conn.Open(); rdr = sqlcmd.ExecuteReader(); if (rdr.HasRows) { while (rdr.Read()) { String frd_id = rdr["friend_id"].ToString(); String my_id = rdr["my_id"].ToString(); if (frd_id == req_from && my_id == currentUserId.ToString()) { lblNotify.Visible = true; break; } else { string connectionString4 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql = "INSERT INTO FriendsList(friend_id, my_id) VALUES(@friend_id, @my_id)"; using (SqlConnection myConnection = new SqlConnection(connectionString4)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@friend_id", req_from); myCommand.Parameters.AddWithValue("@my_id", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } using (SqlConnection myConnection = new SqlConnection(connectionString4)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@friend_id", currentUserId); myCommand.Parameters.AddWithValue("@my_id", req_from); myCommand.ExecuteNonQuery(); myConnection.Close(); } } } } else { string connectionString5 = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string insertSql = "INSERT INTO FriendsList(friend_id, my_id) VALUES(@friend_id, @my_id)"; using (SqlConnection myConnection = new SqlConnection(connectionString5)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@friend_id", req_from); myCommand.Parameters.AddWithValue("@my_id", currentUserId); myCommand.ExecuteNonQuery(); myConnection.Close(); } using (SqlConnection myConnection = new SqlConnection(connectionString5)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(insertSql, myConnection); myCommand.Parameters.AddWithValue("@friend_id", currentUserId); myCommand.Parameters.AddWithValue("@my_id", req_from); myCommand.ExecuteNonQuery(); myConnection.Close(); } } if (rdr != null) { rdr.Close(); } } catch (Exception ex) { } finally { if (conn != null) { conn.Close(); } } } if (e.CommandName == "CommandReject") { string connectionString = ConfigurationManager.ConnectionStrings["SecurityConnectionString"].ConnectionString; string updateSql = "UPDATE FriendRequests SET Request_status = @Request_status WHERE Request_to = @Request_to"; try { using (SqlConnection myConnection = new SqlConnection(connectionString)) { myConnection.Open(); SqlCommand myCommand = new SqlCommand(updateSql, myConnection); myCommand.Parameters.AddWithValue("@Request_to", currentUserId); myCommand.Parameters.AddWithValue("@Request_status", 2); myCommand.ExecuteNonQuery(); myConnection.Close(); } } catch { } } this.DataBind(); }