public static classDocGia TimDocGia(string id) { classDocGia res = null; res = connect.FindDocgia(id); return(res); }
public static bool SuaDocGia(classDocGia new_dg, string ID) { bool res = connect.editDocgia(new_dg, ID); //truy van csdl theo id roi sua,sua khong thanh cong return 0 return(res); }
public void sua_docgia(object sender, EventArgs e) { // MessageBox.Show("sua doc gia"); classDocGia new_dg = new classDocGia(qldg_boxTen.Text, qldg_dtBD.Value, qldg_dtKT.Value, qldg_boxDV.Text); classSua.SuaDocGia(new_dg, qldg_boxID.Text); }
public static classDocGia FindDocgia(string Ma) { classDocGia s = new classDocGia(); DataTable table = null; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "select * from docgia where Madocgia= '" + Ma + "'"; com.CommandType = CommandType.Text; com.Connection = con; SqlDataAdapter adap = new SqlDataAdapter(com); table = new DataTable(); adap.Fill(table); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { s.ten = dr[1].ToString().Trim(); s.tgbd = Convert.ToDateTime(dr[2]); s.tgkt = Convert.ToDateTime(dr[3]); s.donvi = dr[4].ToString(); } } return(s); }
public void them_docgia(object sender, EventArgs e) { // MessageBox.Show("them doc gia"); classDocGia new_dg = new classDocGia(qldg_boxTen.Text, qldg_dtBD.Value, qldg_dtKT.Value, qldg_boxDV.Text); classThem.ThemDocGia(new_dg); }
public static bool ThemDocGia(classDocGia doc_gia) { bool res ; res = connect.insertDocGia(doc_gia); //truy van csdl them doc gia, thanh cong return 1, khong thanh cong return 0 return res ; }
public static bool ThemDocGia(classDocGia doc_gia) { bool res; res = connect.insertDocGia(doc_gia); //truy van csdl them doc gia, thanh cong return 1, khong thanh cong return 0 return(res); }
public void tim_docgia(object sender, EventArgs e) { classDocGia dg = classTim.TimDocGia(qldg_boxID.Text); qldg_boxID.Text = dg.id; qldg_boxTen.Text = dg.ten; qldg_dtBD.Value = Convert.ToDateTime(dg.tgbd); qldg_dtKT.Value = Convert.ToDateTime(dg.tgkt); qldg_boxDV.Text = dg.donvi; // MessageBox.Show("tim doc gia"); }
private void qlmt_linkDG_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { classDocGia docgia = classTim.TimDocGia(qlmt_boxDG.Text); if (docgia == null) { MessageBox.Show("không có độc giả này"); return; } qlmt_labTen.Text = docgia.ten; qlmt_labDV.Text = docgia.donvi; }
private void qldg_linkTim_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e) { classDocGia dg = classTim.TimDocGia(qldg_boxID.Text); if (dg != null) { qldg_boxID.Text = dg.id; qldg_boxTen.Text = dg.ten; qldg_dtBD.Value = Convert.ToDateTime(dg.tgbd); qldg_dtKT.Value = Convert.ToDateTime(dg.tgkt); qldg_boxDV.Text = dg.donvi; } else { MessageBox.Show("Không tìm thấy"); } }
public static bool insertDocGia(classDocGia s) { bool isInsert = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "Add_DocGia"; com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@ten", s.ten); com.Parameters.AddWithValue("@tgbd", s.tgbd); com.Parameters.AddWithValue("@tgkt", s.tgkt); com.Parameters.AddWithValue("@dv", s.donvi); com.Connection = con; int i = com.ExecuteNonQuery(); isInsert = i > 0 ? true : false; } return(isInsert); }
public static bool editDocgia(classDocGia s, string id) { bool isEdit = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "update DocGia set Ten=@ten,ngaybatdau=@nbd,ngayketthuc=@nkt,donvi=@dv where Madocgia=@id"; com.CommandType = CommandType.Text; com.Parameters.AddWithValue("@ten", s.ten); com.Parameters.AddWithValue("@nbd", s.tgbd); com.Parameters.AddWithValue("@nkt", s.tgkt); com.Parameters.AddWithValue("@dv", s.donvi); com.Parameters.AddWithValue("@id", id); com.Connection = con; int i = com.ExecuteNonQuery(); isEdit = i > 0 ? true : false; } return isEdit; }
public static bool editDocgia(classDocGia s, string id) { bool isEdit = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "update DocGia set Ten=@ten,ngaybatdau=@nbd,ngayketthuc=@nkt,donvi=@dv where Madocgia=@id"; com.CommandType = CommandType.Text; com.Parameters.AddWithValue("@ten", s.ten); com.Parameters.AddWithValue("@nbd", s.tgbd); com.Parameters.AddWithValue("@nkt", s.tgkt); com.Parameters.AddWithValue("@dv", s.donvi); com.Parameters.AddWithValue("@id", id); com.Connection = con; int i = com.ExecuteNonQuery(); isEdit = i > 0 ? true : false; } return(isEdit); }
public static bool insertDocGia(classDocGia s) { bool isInsert = false; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "Add_DocGia"; com.CommandType = CommandType.StoredProcedure; com.Parameters.AddWithValue("@ten", s.ten); com.Parameters.AddWithValue("@tgbd", s.tgbd); com.Parameters.AddWithValue("@tgkt", s.tgkt); com.Parameters.AddWithValue("@dv", s.donvi); com.Connection = con; int i = com.ExecuteNonQuery(); isInsert = i > 0 ? true : false; } return isInsert; }
public static int ThemDocGia(classDocGia doc_gia) { int res = 0; //truy van csdl them doc gia, thanh cong return 1, khong thanh cong return 0 return res ; }
public static int SuaDocGia(classDocGia new_dg, string ID) { //truy van csdl theo id roi sua,sua khong thanh cong return 0 return 1; }
public void sua_docgia(object sender, EventArgs e) { // MessageBox.Show("sua doc gia"); classDocGia new_dg = new classDocGia(qldg_boxTen.Text,qldg_dtBD.Value,qldg_dtKT.Value,qldg_boxDV.Text); classSua.SuaDocGia(new_dg, qldg_boxID.Text); }
public static classDocGia FindDocgia(string Ma) { classDocGia s = new classDocGia(); DataTable table = null; if (isConnect()) { SqlCommand com = new SqlCommand(); com.CommandText = "select * from docgia where Madocgia= '" + Ma + "'"; com.CommandType = CommandType.Text; com.Connection = con; SqlDataAdapter adap = new SqlDataAdapter(com); table = new DataTable(); adap.Fill(table); SqlDataReader dr = com.ExecuteReader(); if (dr.Read()) { s.ten = dr[1].ToString().Trim(); s.tgbd = Convert.ToDateTime(dr[2]); s.tgkt = Convert.ToDateTime(dr[3]); s.donvi = dr[4].ToString(); } } return s; }
public static bool SuaDocGia(classDocGia new_dg, string ID) { bool res = connect.editDocgia(new_dg, ID); //truy van csdl theo id roi sua,sua khong thanh cong return 0 return res; }