public string InsertMember_Block(Member_Block member_Block)
{
string result = "";
MyDB myDB = new MyDB();
MySqlConnection con = myDB.GetCon();
string Sql = "INSERT INTO toourshared.member_block (mem_blo_date,mem_ble_length,mem_id) VALUES(@mem_blo_date,@mem_blo_length,@mem_id); select last_insert_id()";
MySqlCommand cmd = new MySqlCommand(Sql, con);
cmd.Parameters.AddWithValue("@mem_blo_date", member_Block.Mem_blo_date);
cmd.Parameters.AddWithValue("@mem_blo_length", member_Block.Mem_blo_length);
cmd.Parameters.AddWithValue("@mem_id", member_Block.Mem_id);
con.Open();
cmd.ExecuteNonQuery();
result = cmd.LastInsertedId.ToString();
con.Close();
return(result);
}
public Member_Block selectMember_BlockBymem_blo_no(Member_Block member_Block)
{
MyDB mydb = new MyDB();
Member_Block result = new Member_Block();
MySqlConnection con = null;
MySqlDataReader rd = null;
try
{
con = mydb.GetCon();
string Sql = "SELECT * FROM toourshared.member_block where mem_blo_no=@mem_blo_no";
MySqlCommand cmd = new MySqlCommand(Sql, con);
cmd.Parameters.AddWithValue("@mem_blo_no", member_Block.Mem_blo_no);
con.Open();
rd = cmd.ExecuteReader();
if (rd.HasRows)
{
rd.Read();
result.Mem_blo_no = rd["mem_blo_no"].ToString();
result.Mem_blo_date = rd["mem_blo_date"].ToString();
result.Mem_blo_length = rd["mem_blo_length"].ToString();
result.Mem_id = rd["mem_content"].ToString();
//lstMember.Add(tmpMemberPointer);
return(result);
}
rd.Close();
con.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace.ToString());
rd.Close();
con.Close();
}
finally
{
rd.Close();
con.Close();
}
return(result);
}
//계정정지 목록 조회 기능(함수)
public void Member_BlockList()
{
Member_Block memberBlock = new Member_Block();
Member_BlockDao memberBlockDao = new Member_BlockDao();
DataSet ds = memberBlockDao.SelectMember_Block();
dataGridView2.DataSource = ds.Tables[0];
//mem_blo_no, mem_id, mem_blo_date, mem_blo_length
dataGridView2.Columns[0].HeaderCell.Value = "계정정지 번호";
dataGridView2.Columns[1].HeaderCell.Value = "아이디";
dataGridView2.Columns[2].HeaderCell.Value = "계정정지 시작일";
dataGridView2.Columns[3].HeaderCell.Value = "계정정지 기간";
}
public string InsertMember_Block(Member_Block member_Block)
{
string result = "";
MyDB myDB = new MyDB();
MySqlConnection con = myDB.GetCon();
try
{
string Sql = "INSERT INTO toourshared.member_block (mem_blo_date,mem_ble_length,mem_id) VALUES(@mem_blo_date,@mem_blo_length,@mem_id); select last_insert_id()";
MySqlCommand cmd = new MySqlCommand(Sql, con);
cmd.Parameters.AddWithValue("@mem_blo_date", member_Block.Mem_blo_date);
cmd.Parameters.AddWithValue("@mem_blo_length", member_Block.Mem_blo_length);
cmd.Parameters.AddWithValue("@mem_id", member_Block.Mem_id);
con.Open();
cmd.ExecuteNonQuery();
result = cmd.LastInsertedId.ToString();
con.Close();
}
catch (Exception ex)
{
System.Diagnostics.Debug.WriteLine(ex.StackTrace.ToString());
con.Close();
}
finally
{
con.Close();
}
return(result);
}
//신고글 제재 버튼
private void button2_Click(object sender, EventArgs e)
{
Travel travel = new Travel();
Member member = new Member();
Member_Block member_Block = new Member_Block();
TravelDao travelDao = new TravelDao();
MemberDao memberDao = new MemberDao();
Report delete = new Report();
Member_BlockDao member_BlockDao = new Member_BlockDao();
// trvNo를 받아와서 그 Travel의 mem_id를 가지고 그 mem_id의 state를 바꾼다.
//선택한 셀들의 행을 구해오고 그행의 두번째열 trv_no의 값을 가져온다.
if (dataGridView1.SelectedRows.Count > 0 || dataGridView1.SelectedCells.Count > 0)
{
//선택한 행의 두번째 셀 선택시
if (dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[1].Value != null)
{
travel.Trv_no = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[1].Value.ToString();
travel = travelDao.selectTravelBytrv_no(travel); // 바꿔치기
member.Mem_id = travel.Mem_id;
memberDao.UpdateMemberStateByMemId(member, 1); // 멤버 상태 바꾸고
travel.Trv_secret = "3"; // travel 객체 secret 속성 데이터 바꾸고
travelDao.UpdatetTravel(travel); // travelDao로 DB 업데이트
//제재 눌렀을때 선택한 행의 trv_no를 가져온다.
travel.Trv_no = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[1].Value.ToString();
try
{
string sql = "select travel.mem_id as mem_id from toourshared.travel"
+ " where travel.trv_no = @trv_no";
string mem_id = "";
MySqlConnection con = myDB.GetCon();
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@trv_no", travel.Trv_no);
con.Open();
MySqlDataReader rd = cmd.ExecuteReader();
while (rd.Read())
{
mem_id = rd["mem_id"].ToString();
}
rd.Close();
con.Close();
string sql2 = "insert into toourshared.member_block(mem_blo_date, mem_blo_length, mem_id)"
+ " values(now(), 3, @mem_id)";
MySqlCommand cmd2 = new MySqlCommand(sql2, con);
cmd2.Parameters.AddWithValue("@mem_id", mem_id);
con.Open();
cmd2.ExecuteNonQuery();
con.Close();
}
catch
{
}
}
//선택한 행의 첫번째 셀 선택시
if (dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[0].Value != null)
{
//선택 행의 첫번째 rep_no 가져오기
delete.Rep_no = dataGridView1.Rows[dataGridView1.SelectedCells[0].RowIndex].Cells[0].Value.ToString();
try
{
string sql = "Delete from toourshared.report where rep_no = @rep_no";
MySqlConnection con = myDB.GetCon();
MySqlCommand cmd = new MySqlCommand(sql, con);
cmd.Parameters.AddWithValue("@rep_no", delete.Rep_no);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception ex)
{
}
}
//선택한 셀이 없을 경우
else
{
MessageBox.Show("조회된 데이터가 없습니다.");
}
}
//선택한 행이 없을 경우
else
{
MessageBox.Show("선택된 행이 없습니다.");
}
After_Report();
}
