private void FBanhang_Load(object sender, EventArgs e) { bt_xoa.Hide(); bt_tinh.Hide(); conn = con._CreateConnect(); lb_ngay.Text = DateTime.Now.ToString("MM/dd/yyyy"); }
public int GetScalar(string sqlquery) { ConnectData con = new ConnectData(); SqlConnection conn = new SqlConnection(); conn = con._CreateConnect(); conn.Open(); SqlCommand cmd = new SqlCommand(sqlquery, conn); int scalar = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); return(scalar); }
public DataTable Getdatatable(string sqlquery) { ConnectData con = new ConnectData(); SqlConnection conn = new SqlConnection(); conn = con._CreateConnect(); conn.Open(); SqlCommand cmd = new SqlCommand(sqlquery, conn); SqlDataAdapter da = new SqlDataAdapter(cmd); dt = new DataTable(); da.Fill(dt); conn.Close(); return(dt); }
private void bt_them_Click(object sender, EventArgs e) { ConnectData con = new ConnectData(); SqlConnection conn = new SqlConnection(); conn = con._CreateConnect(); if (cbb_chon.Text == "") { MessageBox.Show("Chưa chọn loại chức năng thêm !!!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } else if (cbb_chon.Text == "Thêm máy tính") { StringBuilder builder = new StringBuilder(); builder.Append(RandomNumber(0, 9999)); string sql = "insert into TBLMAYTINH(MAMAY, TENMAY, DONGIA, GHICHU, TINHTRANG) VALUES('MT" + builder.ToString() + "',N'" + txt_ten.Text + "'," + txt_dongia.Text + ",N'" + txt_ghichu.Text + "',1)"; string sql2 = "insert into TBLCAUHINH(MAMAY, HANG,CPU ,GPU ,RAM ,HARDDISK) values('MT" + builder.ToString() + "',N'" + cbb_hang.Text + "',N'" + txt_CPU.Text + "',N'" + txt_GPU.Text + "',N'" + cbb_ram.Text + "',N'" + txt_hardisk.Text + "')"; SqlCommand cmd = new SqlCommand(sql, conn); SqlCommand cmd2 = new SqlCommand(sql2, conn); conn.Open(); cmd.ExecuteNonQuery(); cmd2.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Thêm máy tính thành công !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else if (cbb_chon.Text == "Thêm linh kiện") { StringBuilder builder = new StringBuilder(); builder.Append(RandomNumber(0, 9999)); string sql = "insert into TBLLINHKIEN(MALK, TENLK, DONGIA, GHICHU, TINHTRANG) VALUES('LK" + builder.ToString() + "',N'" + txt_ten.Text + "'," + txt_dongia.Text + ",N'" + txt_ghichu.Text + "',1)"; SqlCommand cmd = new SqlCommand(sql, conn); conn.Open(); cmd.ExecuteNonQuery(); conn.Close(); MessageBox.Show("Thêm linh kiện thành công !!!", "Thông báo", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { MessageBox.Show("Chọn sai chức năng !!!", "Lỗi", MessageBoxButtons.OK, MessageBoxIcon.Error); } }