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();
}
