protected void btnHuy_Click(object sender, EventArgs e) { string IDThuMuaDatHang = IDThuMuaDatHang_Temp.Value.ToString(); data = new dtThemDonHangKho(); data.XoaChiTietDonHang_Nhap(IDThuMuaDatHang); Response.Redirect("DanhSachPhieuDatHang.aspx"); }
private void Import_Temp(DataTable datatable) { int intRow = datatable.Rows.Count; if (datatable.Columns.Contains("MaNguyenLieu") && datatable.Columns.Contains("TenNguyenLieu") && datatable.Columns.Contains("SoLuong") && datatable.Columns.Contains("DonGia")) { if (intRow != 0) { for (int i = 0; i <= intRow - 1; i++) { DataRow dr = datatable.Rows[i]; int SoLuong = Int32.Parse(dr["SoLuong"].ToString()); string MaNguyenLieu = dr["MaNguyenLieu"].ToString().Trim(); if (SoLuong > 0 && SoLuong.ToString() != "" && MaNguyenLieu != "") { string TenNguyenLieu = dr["TenNguyenLieu"].ToString(); string IDNguyenLieu = dtSetting.LayIDNguyenLieu(MaNguyenLieu.Trim()); string IDDonHang = IDThuMuaDatHang_Temp.Value.ToString(); string IDDonViTinh = dtThemHangHoa.LayIDDonViTinh(IDNguyenLieu); float DonGia = 0; if (dr["DonGia"].ToString() == "") { DonGia = dtSetting.GiaMua(IDNguyenLieu); } else { DonGia = float.Parse(dr["DonGia"].ToString()); } DataTable db = dtThemDonHangKho.KTChiTietDonHang_Temp(IDNguyenLieu, IDDonHang);// kiểm tra hàng hóa if (db.Rows.Count == 0) { data = new dtThemDonHangKho(); data.ThemChiTietDonHang_Temp(IDDonHang, IDNguyenLieu, MaNguyenLieu, IDDonViTinh, SoLuong, DonGia); TinhTongTien(); CLear(); } else { data = new dtThemDonHangKho(); data.CapNhatChiTietDonHang_temp(IDDonHang, IDNguyenLieu, SoLuong, DonGia); TinhTongTien(); CLear(); } LoadGrid(IDDonHang); } else { Response.Write("<script language='JavaScript'> alert('Số lượng phải > 0.'); </script>"); } } } } else { Response.Write("<script language='JavaScript'> alert('Dữ liệu không chính xác? Vui lòng kiểm tra lại.'); </script>"); } }
protected void BtnXoaHang_Click(object sender, EventArgs e) { txtBarcode.Focus(); string ID = (((ASPxButton)sender).CommandArgument).ToString(); string IDThuMuaDatHang = IDThuMuaDatHang_Temp.Value.ToString(); data = new dtThemDonHangKho(); data.XoaChiTietDonHang_Temp_ID(ID); LoadGrid(IDThuMuaDatHang); }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { data = new dtThemDonHangKho(); object IDPhieuDatHang = data.ThemPhieuDatHang(); IDThuMuaDatHang_Temp.Value = IDPhieuDatHang.ToString(); cmbKhoLap.Value = Session["IDChiNhanh"].ToString(); txtNguoiLap.Text = Session["TenDangNhap"].ToString(); txtSoDonHang.Text = (Int32.Parse(Session["IDChiNhanh"].ToString())).ToString().Replace(".", "") + "-" + (DateTime.Now.ToString("ddMMyyyy-hhmmss")); } LoadGrid(IDThuMuaDatHang_Temp.Value.ToString()); }
protected void btnThem_Temp_Click(object sender, EventArgs e) { if (cmbHangHoa.Text != "" && UploadFileExcel.FileName.ToString() != "") { Response.Write("<script language='JavaScript'> alert('Vui lòng chỉ chọn 1 hình thức thêm hàng hóa.'); </script>"); CLear(); return; } else if (UploadFileExcel.FileName.ToString() != "") { Import(); } else if (cmbHangHoa.Text != "") { float SoLuong = float.Parse(txtSoLuong.Text.ToString()); if (SoLuong > 0) { string IDNguyenLieu = cmbHangHoa.Value.ToString(); string MaNguyenLieu = dtThemHangHoa.LayMaNguyenLieu(IDNguyenLieu); string IDDonViTinh = dtThemHangHoa.LayIDDonViTinh(IDNguyenLieu); float DonGia = float.Parse(txtDonGia.Text); string IDDonHang = IDThuMuaDatHang_Temp.Value.ToString(); DataTable db = dtThemDonHangKho.KTChiTietDonHang_Temp(IDNguyenLieu, IDDonHang);// kiểm tra hàng hóa if (db.Rows.Count == 0) { data = new dtThemDonHangKho(); data.ThemChiTietDonHang_Temp(IDDonHang, IDNguyenLieu, MaNguyenLieu, IDDonViTinh, SoLuong, DonGia); TinhTongTien(); CLear(); } else { data = new dtThemDonHangKho(); data.CapNhatChiTietDonHang_temp(IDDonHang, IDNguyenLieu, SoLuong, DonGia); TinhTongTien(); CLear(); } LoadGrid(IDDonHang); } else { Response.Write("<script language='JavaScript'> alert('Số Lượng phải > 0.'); </script>"); return; } } else { Response.Write("<script language='JavaScript'> alert('Vui lòng chọn hàng hóa.'); </script>"); return; } }
protected void btnThem_Click(object sender, EventArgs e) { string IDThuMuaDatHang = IDThuMuaDatHang_Temp.Value.ToString(); data = new dtThemDonHangKho(); DataTable dt = data.DanhSachDonDatHang_Temp(IDThuMuaDatHang); if (dt.Rows.Count != 0) { string SoDonHang = txtSoDonHang.Text.Trim(); string IDNguoiLap = Session["IDNhanVien"].ToString(); DateTime NgayLap = DateTime.Parse(txtNgayLap.Text); string TongTien = txtTongTien.Text; string IDChiNhanh = Session["IDChiNhanh"].ToString(); string GhiChu = txtGhiChu.Text == null ? "" : txtGhiChu.Text.ToString(); string IDNhaCungCap = cmbNhaCungCap.Text == "" ? "" : cmbNhaCungCap.Value.ToString(); int TrangThai = 0; if (ckThanhToan.Checked == true) { TrangThai = 1; } if (cmbNhaCungCap.Text != "" && ckThanhToan.Checked == false) { data = new dtThemDonHangKho(); data.CongCongNoNCC(IDNhaCungCap, TongTien); } data = new dtThemDonHangKho(); data.CapNhatDonDatHang(IDThuMuaDatHang, SoDonHang, IDNguoiLap, NgayLap, TongTien, GhiChu, IDChiNhanh, IDNhaCungCap, TrangThai); foreach (DataRow dr in dt.Rows) { string IDNguyenLieu = dr["IDNguyenLieu"].ToString(); string MaNguyenLieu = dr["MaNguyenLieu"].ToString(); string IDDonViTinh = dr["IDDonViTinh"].ToString(); string SoLuong = dr["SoLuong"].ToString(); string DonGia = dr["DonGia"].ToString(); data = new dtThemDonHangKho(); dtSetting.CongTonKho(IDNguyenLieu, SoLuong, IDChiNhanh); // cộng kho không qua bước duyệt // ghi lịch sử data.ThemChiTietDonHang(IDThuMuaDatHang, IDNguyenLieu, MaNguyenLieu, IDDonViTinh, SoLuong, DonGia); } data = new dtThemDonHangKho(); data.XoaChiTietDonHang_Nhap(IDThuMuaDatHang); Response.Redirect("DanhSachPhieuNhapHang.aspx"); } else { cmbHangHoa.Focus(); Response.Write("<script language='JavaScript'> alert('Danh sách nguyên liệu rỗng.'); </script>"); } }
public double TinhTongTien() { string IDThuMuaDatHang = IDThuMuaDatHang_Temp.Value.ToString(); data = new dtThemDonHangKho(); DataTable dt = data.DanhSachDonDatHang_Temp(IDThuMuaDatHang); if (dt.Rows.Count > 0) { double TongTien = 0; foreach (DataRow dr in dt.Rows) { double ThanhTien = double.Parse(dr["ThanhTien"].ToString()); TongTien = TongTien + ThanhTien; } return(TongTien); } else { return(0); } }
public void TinhTongTien() { string IDThuMuaDatHang = IDThuMuaDatHang_Temp.Value.ToString(); data = new dtThemDonHangKho(); DataTable db = data.DanhSachDonDatHang_Temp(IDThuMuaDatHang); if (db.Rows.Count != 0) { double TongTien = 0; foreach (DataRow dr in db.Rows) { double ThanhTien = double.Parse(dr["ThanhTien"].ToString()); TongTien = TongTien + ThanhTien; } txtTongTien.Text = (TongTien).ToString(); } else { txtTongTien.Text = "0"; } }
protected void btnThem_Click(object sender, EventArgs e) { if (cmbNhaCungCap.Text != "" && txtTraTruoc.Text != "") { double TraTruoc = double.Parse(txtTraTruoc.Text.ToString()); double TongTien = TinhTongTien(); if (TraTruoc > TongTien) { Response.Write("<script language='JavaScript'> alert('Trả trước không lớn hơn tổng tiền.'); </script>"); } else { string IDThuMuaDatHang = IDThuMuaDatHang_Temp.Value.ToString(); data = new dtThemDonHangKho(); DataTable dt = data.DanhSachDonDatHang_Temp(IDThuMuaDatHang); if (dt.Rows.Count != 0) { string SoDonHang = txtSoDonHang.Text.Trim(); string IDNguoiLap = Session["IDNhanVien"].ToString(); DateTime NgayLap = DateTime.Parse(txtNgayLap.Text); string IDChiNhanh = Session["IDKho"].ToString(); string GhiChu = txtGhiChu.Text == null ? "" : txtGhiChu.Text.ToString(); string IDNhaCungCap = cmbNhaCungCap.Value.ToString(); double ConLai = TongTien - TraTruoc; int TrangThai = 0; if (ConLai == 0) { TrangThai = 1; } if (IDNhaCungCap != "1") { data = new dtThemDonHangKho(); data.CongCongNoNCC(IDNhaCungCap, ConLai.ToString()); } data = new dtThemDonHangKho(); object ID = data.ThemPhieuDatHang(); if (ID != null) { data.CapNhatDonDatHang(ID, SoDonHang, IDNguoiLap, NgayLap, TongTien.ToString(), GhiChu, IDNhaCungCap, TrangThai, TraTruoc, ConLai); foreach (DataRow dr in dt.Rows) { string IDHangHoa = dr["IDHangHoa"].ToString(); string MaHangHoa = dr["MaHangHoa"].ToString(); string IDDonViTinh = dr["IDDonViTinh"].ToString(); string SoLuong = dr["SoLuong"].ToString(); string DonGia = dr["DonGia"].ToString(); string ThanhTien = dr["ThanhTien"].ToString(); data = new dtThemDonHangKho(); dtCapNhatTonKho.CongTonKho(IDHangHoa, SoLuong, IDChiNhanh); // cộng kho không qua bước duyệt // ghi lịch sử data.ThemChiTietDonHang(ID, IDHangHoa, MaHangHoa, IDDonViTinh, SoLuong, DonGia, ThanhTien); } data = new dtThemDonHangKho(); data.XoaChiTietDonHang_Nhap(IDThuMuaDatHang); Response.Redirect("DanhSachPhieuDatHang.aspx"); } } else { txtBarcode.Focus(); Response.Write("<script language='JavaScript'> alert('Danh sách nguyên liệu rỗng.'); </script>"); } } } else { cmbNhaCungCap.Focus(); Response.Write("<script language='JavaScript'> alert('Vui lòng chọn nhà cung cấp & nhập trả trước.'); </script>"); } }
private void LoadGrid(string p) { data = new dtThemDonHangKho(); gridDanhSachHangHoa.DataSource = data.DanhSachDonDatHang_Temp(p); gridDanhSachHangHoa.DataBind(); }
private void LoadGrid(string p) { data = new dtThemDonHangKho(); gridChiTiet.DataSource = data.DanhSachChiTiet(p); gridChiTiet.DataBind(); }