public string TenTDGet([PexAssumeUnderTest] ThucDonDTO target) { string result = target.TenTD; return(result); // TODO: add assertions to method ThucDonDTOTest.TenTDGet(ThucDonDTO) }
public static bool CapNhatThucDon(ThucDonDTO td) { string sql = string.Format("update ThucDon set MaLoai = {0}, TenThucDon = N'{1}', DonViTinh = N'{2}' where MaThucDon = {3}", td.MaLoai, td.TenTD, td.DonViTinh, td.MaTD); bool kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
public ThucDonDTO Constructor02(ThucDonDTO thucDon) { ThucDonDTO target = new ThucDonDTO(thucDon); return(target); // TODO: add assertions to method ThucDonDTOTest.Constructor02(ThucDonDTO) }
public int MaTDGet([PexAssumeUnderTest] ThucDonDTO target) { int result = target.MaTD; return(result); // TODO: add assertions to method ThucDonDTOTest.MaTDGet(ThucDonDTO) }
public ActionResult Delete(int?id) { if (KiemTraDangNhap() == false) { return(View("../Login/Index")); } // if (id == null) // return RedirectToAction ("Index"); // ThucDon td = context.ThucDons.Find (id); // if (td == null) // return RedirectToAction ("Index"); // return View (td); if (id == null) { return(RedirectToAction("Index")); } ThucDonDTO tdDTO = _services.GetMonAn(id.Value); if (tdDTO == null) { return(RedirectToAction("Index")); } SaveThucDonDTO saveThucDonDTO = _mapper.Map <ThucDonDTO, SaveThucDonDTO>(tdDTO); return(View(saveThucDonDTO)); }
public ThucDonDTO[] DSThucDonTheoTag(int matag) { Connect(); ThucDonDTO[] Kq; SqlCommand cmd = new SqlCommand("spDanhSachThucDonTheoTag", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ma_tag", SqlDbType.Int); cmd.Parameters["@ma_tag"].Value = matag; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable tab = new DataTable(); da.Fill(tab); int n = tab.Rows.Count; Kq = new ThucDonDTO[n]; for (int i = 0; i < n; ++i) { object thuc_don = GetDataFromDataRow(tab, i); Kq[i] = (ThucDonDTO)thuc_don; } Disconnect(); return(Kq); }
public ThucDonDTO[] DSMThucDonThuocLoaiThucDon(int maloaithucdon) { Connect(); ThucDonDTO[] Kq; SqlCommand cmd = new SqlCommand("spLayDSThucDonCuaMotLoaiThucDonLa", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@maloaithucdon", SqlDbType.Int); cmd.Parameters["@maloaithucdon"].Value = maloaithucdon; SqlDataAdapter da = new SqlDataAdapter(cmd); DataTable tab = new DataTable(); da.Fill(tab); int n = tab.Rows.Count; Kq = new ThucDonDTO[n]; for (int i = 0; i < n; ++i) { object mon_an = GetDataFromDataRow(tab, i); Kq[i] = (ThucDonDTO)mon_an; } Disconnect(); return(Kq); }
public bool CapNhatTD(ThucDonDTO thucdon) { string update = "UPDATE THUCDON " + "SET TENTHUCDON = @TENTHUCDON," + " LOAITD = @LOAITD" + ",GIA = @GIA" + " , TINHTRANG = @TINHTRANG" + " WHERE MATD = @MATD"; //SqlParameter[] arrParams = new SqlParameter[7]; string gia = null; foreach (char a in thucdon.GIA.ToString()) { if (a.ToString() != "V" || a.ToString() != "N" || a.ToString() != "Đ") { gia += a; } } List <SqlParameter> lsparams = new List <SqlParameter>(); lsparams.Add(new SqlParameter("@MATD", thucdon.MATD)); lsparams.Add(new SqlParameter("@TENTHUCDON", thucdon.TENTHUCDON)); lsparams.Add(new SqlParameter("@GIA", thucdon.GIA)); lsparams.Add(new SqlParameter("@LOAITD", thucdon.LOAITD)); lsparams.Add(new SqlParameter("@TINHTRANG", thucdon.TINHTRANG)); SqlConnection con = DataProvider.TaoKetNoi(); bool thucthi = DataProvider.ThucThi(update, lsparams.ToArray(), con); return(thucthi); }
//-> tránh nhập nhằng với hàm trên -> lấy thông tin thực đơn ko bao gồm chi tiết món :| public ThucDonDTO LayThongTinTongQuatCuaThucDon(int ma) { ThucDonDTO Kq = new ThucDonDTO(); Connect(); SqlCommand cmd = new SqlCommand("spLayThongTinThucDon", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@mathucdon", SqlDbType.Int); cmd.Parameters["@mathucdon"].Value = ma; SqlDataReader dr = cmd.ExecuteReader(); if (dr.Read()) { Kq.Ma_thuc_don = int.Parse(dr["MaThucDon"].ToString()); Kq.Ten_thuc_don = dr["TenThucDon"].ToString(); Kq.Ma_loai_thuc_don = int.Parse(dr["MaLoaiThucDon"].ToString()); Kq.Mo_ta = dr["MoTa"].ToString(); Kq.Hinh_anh_minh_hoa = dr["HinhAnhMinhHoa"].ToString(); Kq.Gia = decimal.Parse(dr["Gia"].ToString()); Kq.Diem_binh_chon = int.Parse(dr["DiemBinhChon"].ToString()); Kq.Trang_thai_hien_thi = bool.Parse(dr["TrangThaiHienThi"].ToString()); Kq.Tinh_trang = bool.Parse(dr["TinhTrang"].ToString()); } Disconnect(); return(Kq); }
public ThucDonDTO[] TimKiemThucDonTheoTen(string ten_thuc_don) { Connect(); ThucDonDTO[] Kq; SqlCommand cmd = new SqlCommand("spTimKiemTheoTen", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ten", SqlDbType.NVarChar, 50); cmd.Parameters["@ten"].Value = ten_thuc_don; SqlDataAdapter da = new SqlDataAdapter(cmd); //DataTable tab = new DataTable(); DataSet dsThucDon = new DataSet(); da.Fill(dsThucDon, "THUC_DON"); int n = dsThucDon.Tables[1].Rows.Count; Kq = new ThucDonDTO[n]; for (int i = 0; i < n; ++i) { object thuc_don = GetDataFromDataRow(dsThucDon.Tables[1], i); Kq[i] = (ThucDonDTO)thuc_don; } Disconnect(); return(Kq); }
public static bool ThemThucDon(ThucDonDTO td) { string sql = string.Format("insert into ThucDon values ({0}, {1}, '{2}', '{3}')", td.MaTD, td.MaLoai, td.TenTD, td.DonViTinh); bool kq = SqlDataAccessHelper.ExecuteNonQuery(sql); return(kq); }
protected void LayDSThucDon() { ThucDonBUS ThucDonBUS = new ThucDonBUS(); ThucDonDTO[] DsThucDon = ThucDonBUS.DSThucDonThuocLoaiThucDon(int.Parse(Request["MaLoaiThucDon"].ToString())); XL_THE Kq = new XL_THE("DANH_SACH"); for (int i = 0; i < DsThucDon.Length; i++) { XL_THE Kq1 = new XL_THE("ThucDon"); ThucDonDTO ThucDon = DsThucDon[i]; XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString()); Kq.Danh_sach_the.Add(Kq1); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }
private void btn_lamMoi_Click(object sender, EventArgs e) { TDhienhanh = null; trThai = 1; TrangThai(); Bind(); LoadData(); }
public void MaTDSet841() { ThucDonDTO s0 = new ThucDonDTO(0, 0, (string)null, (string)null); this.MaTDSet(s0, 0); Assert.IsNotNull((object)s0); Assert.AreEqual <int>(0, s0.MaTD); Assert.AreEqual <int>(0, s0.MaLoai); Assert.AreEqual <string>((string)null, s0.TenTD); Assert.AreEqual <string>((string)null, s0.DonViTinh); }
public void Constructor02201() { ThucDonDTO thucDonDTO; ThucDonDTO s0 = new ThucDonDTO(0, 0, (string)null, (string)null); thucDonDTO = this.Constructor02(s0); Assert.IsNotNull((object)thucDonDTO); Assert.AreEqual <int>(0, thucDonDTO.MaTD); Assert.AreEqual <int>(0, thucDonDTO.MaLoai); Assert.AreEqual <string>((string)null, thucDonDTO.TenTD); Assert.AreEqual <string>((string)null, thucDonDTO.DonViTinh); }
private void Ghi_nhan_dat_hang() { ArrayList arr = new ArrayList(); int ma = int.Parse(Request["Ma"].ToString()); MonAnBUS monanBUS = new MonAnBUS(); if (Request["Loai"] == "0") { MonAnDTO MonAn = monanBUS.ChiTietMonAn(ma); Item_online mon_an = new Item_online(); mon_an.Ma_item = MonAn.Ma_mon; mon_an.Ten_item = MonAn.Ten_mon; mon_an.Hinh_anh_minh_hoa = MonAn.Hinh_anh_minh_hoa; mon_an.Gia = MonAn.Gia; mon_an.Loai_item = 0; mon_an.So_luong = int.Parse(Request["So_luong"].ToString()); Session["Item_online"] = mon_an; } else if (Request["Loai"] == "1") { ThucDonBUS thucdonBUS = new ThucDonBUS(); //ThucDonDTO ThucDon = thucdonBUS.ThongTinThucDon(ma); ThucDonDTO thuc_don = thucdonBUS.ChiTietThucDon(ma); Item_online mon_an = new Item_online(); mon_an.Ma_item = thuc_don.Ma_thuc_don; mon_an.Ten_item = thuc_don.Ten_thuc_don; mon_an.Hinh_anh_minh_hoa = thuc_don.Hinh_anh_minh_hoa; mon_an.Gia = thuc_don.Gia; mon_an.Loai_item = 1; mon_an.So_luong = int.Parse(Request["So_luong"].ToString()); Session["Item_online"] = mon_an; } else { ThucDonCaNhanBUS thucdonBUS = new ThucDonCaNhanBUS(); //ThucDonDTO ThucDon = thucdonBUS.ThongTinThucDon(ma); ThucDonCaNhanDTO thuc_don = thucdonBUS.ChiTietThucDonCaNhan(ma); Item_online mon_an = new Item_online(); mon_an.Ma_item = thuc_don.Ma_thuc_don_ca_nhan; mon_an.Ten_item = thuc_don.Ten_thuc_don; mon_an.Hinh_anh_minh_hoa = thuc_don.Hinh_anh; mon_an.Gia = thuc_don.Gia; mon_an.Loai_item = 1; mon_an.So_luong = int.Parse(Request["So_luong"].ToString()); Session["Item_online"] = mon_an; } }
public ThucDonDTO Constructor01( int maNV, int maLoai, string tenTD, string donViTinh ) { ThucDonDTO target = new ThucDonDTO(maNV, maLoai, tenTD, donViTinh); return(target); // TODO: add assertions to method ThucDonDTOTest.Constructor01(Int32, Int32, String, String) }
public void DonViTinhGet977() { string s; ThucDonDTO s0 = new ThucDonDTO(0, 0, (string)null, (string)null); s = this.DonViTinhGet(s0); Assert.AreEqual <string>((string)null, s); Assert.IsNotNull((object)s0); Assert.AreEqual <int>(0, s0.MaTD); Assert.AreEqual <int>(0, s0.MaLoai); Assert.AreEqual <string>((string)null, s0.TenTD); Assert.AreEqual <string>((string)null, s0.DonViTinh); }
public static List <ThucDonDTO> LayDSMaTDVaTenTDTheoMaLoai(int maLoai) { List <ThucDonDTO> ds = new List <ThucDonDTO>(); string sql = "select * from ThucDon where MaLoai = " + maLoai; DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { ThucDonDTO td = new ThucDonDTO(); td.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString()); td.TenTD = dt.Rows[i]["TenThucDon"].ToString(); ds.Add(td); } return(ds); }
private void dgv_ThucDon_SelectionChanged(object sender, EventArgs e) { if (dgv_ThucDon.SelectedRows.Count > 0) { trThai = 1; TrangThai(); btn_capNhat.Enabled = true; TDhienhanh = (ThucDonDTO)dgv_ThucDon.SelectedRows[0].DataBoundItem; // dgv_ThucDon.CurrentRow } else { btn_capNhat.Enabled = false; TDhienhanh = null; } Bind(); }
//Rút trích dữ liêu: select public static List <ThucDonDTO> LayDSThucDon() { List <ThucDonDTO> _ds = new List <ThucDonDTO>(); string sql = "select * from ThucDon"; DataTable dt = SqlDataAccessHelper.ExecuteQuery(sql); for (int i = 0; i < dt.Rows.Count; i++) { ThucDonDTO td = new ThucDonDTO(); td.MaTD = int.Parse(dt.Rows[i]["MaThucDon"].ToString()); td.MaLoai = int.Parse(dt.Rows[i]["MaLoai"].ToString()); td.TenTD = dt.Rows[i]["TenThucDon"].ToString(); td.DonViTinh = dt.Rows[i]["DonViTinh"].ToString(); _ds.Add(td); } return(_ds); }
public ThucDonDTO[] TimKiemThucDonNangCao(string ten_thuc_don, int ma_loai_thuc_don, string tag, double gia_min, double gia_max) { Connect(); ThucDonDTO[] Kq; SqlCommand cmd = new SqlCommand("spTimKiemNangCao", cnn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@ten", SqlDbType.NVarChar, 50); cmd.Parameters["@ten"].Value = ten_thuc_don; cmd.Parameters.Add("@ma_loai", SqlDbType.Int); cmd.Parameters["@ma_loai"].Value = ma_loai_thuc_don; cmd.Parameters.Add("@tag", SqlDbType.NVarChar, 50); cmd.Parameters["@tag"].Value = tag; cmd.Parameters.Add("@gia_min", SqlDbType.Money); cmd.Parameters["@gia_min"].Value = gia_min; cmd.Parameters.Add("@gia_max", SqlDbType.Money); cmd.Parameters["@gia_max"].Value = gia_max; SqlDataAdapter da = new SqlDataAdapter(cmd); //DataTable tab = new DataTable(); DataSet dsThucDon = new DataSet(); da.Fill(dsThucDon, "THUC_DON"); int n = dsThucDon.Tables[1].Rows.Count; Kq = new ThucDonDTO[n]; for (int i = 0; i < n; ++i) { object thuc_don = GetDataFromDataRow(dsThucDon.Tables[1], i); Kq[i] = (ThucDonDTO)thuc_don; } Disconnect(); return(Kq); }
public List <ThucDonDTO> dsThucDon() { List <ThucDonDTO> ds = new List <ThucDonDTO>(); SqlConnection conn = DataProvider.TaoKetNoi(); SqlCommand com = new SqlCommand("select * from THUCDON ,LOAITD where THUCDON.LOAITD = LOAITD.MALOAITD and lOAITD.TINHTRANG = '1'", conn); SqlDataReader sdr = com.ExecuteReader(); while (sdr.Read()) { ThucDonDTO a = new ThucDonDTO() { MATD = sdr.GetString(0), LOAITD = sdr.GetInt32(1), TENTHUCDON = sdr.GetString(2), GIA = sdr.GetDecimal(3).ToString("0,00 VNĐ"), TINHTRANG = sdr.GetInt32(4) }; ds.Add(a); } return(ds); }
private void LayDSThucDon() { ThucDonYeuDauBUS tdydBus = new ThucDonYeuDauBUS(); ThucDonUaThich[] arr = tdydBus.LayDSThucDonYeuThich(int.Parse(Session["MaNguoiDung"].ToString())); if (arr == null) { return; } XL_THE Kq = new XL_THE("DANH_SACH"); for (int i = 0; i < arr.Length; i++) { XL_THE Kq1 = new XL_THE("ThucDon"); ThucDonUaThich ThucDonUT = (ThucDonUaThich)arr[i]; ThucDonDTO thucdon = thucdonbus.ChiTietThucDon(ThucDonUT.Ma_thuc_don); //ThucDonDTO thucdon = thucdonbus.ChiTietThucDon((int)arr[i]); XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", thucdon.Ma_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", thucdon.Ten_thuc_don); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", thucdon.Hinh_anh_minh_hoa); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Gia", thucdon.Gia.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", thucdon.Tinh_trang.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Diem_binh_chon", thucdon.Diem_binh_chon.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Kq.Danh_sach_the.Add(Kq1); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }
private void DS_thuc_don_theo_tag() { TagThucDonBUS tagthucdonBUS = new TagThucDonBUS(); ThucDonDTO[] dsThucDon = tagthucdonBUS.DSThucDonTheoTag(int.Parse(Session["Tag"].ToString())); XL_THE Kq = new XL_THE("DANH_SACH"); for (int i = 0; i < dsThucDon.Length; i++) { XL_THE Kq1 = new XL_THE("ThucDon"); ThucDonDTO ThucDon = dsThucDon[i]; if (ThucDon.Trang_thai_hien_thi == false) { continue; } XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Kq.Danh_sach_the.Add(Kq1); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }
private void Lay_danh_sach() { ThucDonBUS thucdonBUS = new ThucDonBUS(); ThucDonDTO[] DsThucDon = thucdonBUS.DanhSachThucDon(); XL_THE Kq = new XL_THE("DANH_SACH"); for (int i = 0; i < DsThucDon.Length; i++) { XL_THE Kq1 = new XL_THE("ThucDon"); ThucDonDTO ThucDon = DsThucDon[i]; if (ThucDon.Trang_thai_hien_thi == false) { continue; } XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("Ma_thuc_don", ThucDon.Ma_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ten_thuc_don", ThucDon.Ten_thuc_don); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Hinh_anh_minh_hoa", ThucDon.Hinh_anh_minh_hoa); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Gia", ThucDon.Gia.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Ma_loai_thuc_don", ThucDon.Ma_loai_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Tinh_trang", ThucDon.Tinh_trang.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("Trang_thai_hien_thi", ThucDon.Trang_thai_hien_thi.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Kq.Danh_sach_the.Add(Kq1); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }
protected void ThemThucDon() { ThucDonDTO dto = new ThucDonDTO(); dto.Ten_thuc_don = XL_CHUOI.Nhap(Request, "ten"); dto.Ma_loai_thuc_don = int.Parse(XL_CHUOI.Nhap(Request, "maloai")); dto.Mo_ta = XL_CHUOI.Nhap(Request, "mota"); dto.Hinh_anh_minh_hoa = XL_CHUOI.Nhap(Request, "hinhanh"); dto.Gia = decimal.Parse(XL_CHUOI.Nhap(Request, "gia")); dto.Tinh_trang = bool.Parse(XL_CHUOI.Nhap(Request, "tinhtrang")); dto.Trang_thai_hien_thi = bool.Parse(XL_CHUOI.Nhap(Request, "hienthi")); String strTag = XL_CHUOI.Nhap(Request, "tag"); String strDsMaMonAn = XL_CHUOI.Nhap(Request, "dsmamonan"); String[] M = strDsMaMonAn.Split(new String[] { "-" }, StringSplitOptions.RemoveEmptyEntries); ThucDonBUS bus = new ThucDonBUS(); int Kq = bus.ThemThucDon(dto, M, strTag); XL_THE the = new XL_THE("goc"); XL_THUOC_TINH thuoc_tinh; if (Kq != 0) { thuoc_tinh = new XL_THUOC_TINH("kq", "true"); } else { thuoc_tinh = new XL_THUOC_TINH("kq", "false"); } the.Danh_sach_thuoc_tinh.Add(thuoc_tinh); string chuoi = the.Chuoi(); XL_CHUOI.XuatChuoi(Response, chuoi); }
public void LayDSTenThucDon() { ThucDonBUS bus = new ThucDonBUS(); ThucDonDTO[] DsThucDon = bus.DanhSachThucDon(); XL_THE Kq = new XL_THE("DANH_SACH"); for (int i = 0; i < DsThucDon.Length; i++) { XL_THE Kq1 = new XL_THE("ThucDon"); ThucDonDTO dto = DsThucDon[i]; XL_THUOC_TINH Thuoc_tinh = new XL_THUOC_TINH("MaThucDon", dto.Ma_thuc_don.ToString()); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Thuoc_tinh = new XL_THUOC_TINH("TenThucDon", dto.Ten_thuc_don); Kq1.Danh_sach_thuoc_tinh.Add(Thuoc_tinh); Kq.Danh_sach_the.Add(Kq1); } XL_CHUOI.XuatXML(Response, Kq.Chuoi()); }
public List <ThucDonDTO> TraCuu(int x, int y) { string search = "SELECT * FROM THUCDON" + " WHERE MATD LIKE '%" + x + "%' and TINHTRANG LIKE '%" + y + "%' "; SqlConnection con = DataProvider.TaoKetNoi(); List <ThucDonDTO> ds = new List <ThucDonDTO>(); SqlDataReader sdr = DataProvider.TruyVanDuLieu(search, con); while (sdr.Read()) { ThucDonDTO a = new ThucDonDTO(); a.MATD = sdr.GetString(0); a.TENTHUCDON = sdr.GetString(1); a.LOAITD = sdr.GetInt32(2); a.GIA = sdr.GetDecimal(3).ToString("0,00 VNĐ"); a.TINHTRANG = sdr.GetInt32(4); ds.Add(a); } sdr.Close(); con.Close(); return(ds); }
public bool ThemTD(ThucDonDTO thucdon) { string insert = "INSERT INTO THUCDON" + " (MATD" + ", TENTHUCDON" + " , LOAITD" + " , GIA" + " , TINHTRANG)" + " VALUES" + "(@MATD," + "@TENTHUCDON," + "@LOAITD," + "@GIA," + "@TINHTRANG)"; string gia = null; foreach (char a in thucdon.GIA.ToString()) { if (a.ToString() != "V" || a.ToString() != "N" || a.ToString() != "Đ") { gia += a; } } List <SqlParameter> lsparams = new List <SqlParameter>(); lsparams.Add(new SqlParameter("@MATD", thucdon.MATD)); lsparams.Add(new SqlParameter("@TENTHUCDON", thucdon.TENTHUCDON)); lsparams.Add(new SqlParameter("@GIA", thucdon.GIA)); lsparams.Add(new SqlParameter("@LOAITD", thucdon.LOAITD)); lsparams.Add(new SqlParameter("@TINHTRANG", thucdon.TINHTRANG)); SqlConnection con = DataProvider.TaoKetNoi(); bool thucthi = DataProvider.ThucThi(insert, lsparams.ToArray(), con); return(thucthi); }