protected void TextBox4_TextChanged(object sender, EventArgs e)
{
try
{
{
DropDownList1.DataSource = null;
System.Data.DataTable lsp = new System.Data.DataTable();
{
string sql = "select id_loai_san_pham, ten_loai_san_pham from loai_san_pham where cap_do_loai_san_pham = " + (int.Parse(TextBox4.Text) - 1);
WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi);
ketnoi.Open();
System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh);
data.Fill(lsp);
ketnoi.Close();
for (int i = 0; i < lsp.Rows.Count; i++)
{
lsp.Rows[i][1] = mH.Base64Decode(lsp.Rows[i][1].ToString());
}
if ((int.Parse(TextBox4.Text)) == 0)
{
System.Data.DataRow row;
row = lsp.NewRow();
row[0] = 0;
row[1] = "cao nhất";
lsp.Rows.Add(row);
}
DropDownList1.DataSource = lsp;
DropDownList1.DataTextField = "ten_loai_san_pham";
DropDownList1.DataValueField = "id_loai_san_pham";
DropDownList1.DataBind();
try { DropDownList1.Items.FindByValue(id_cha + "").Selected = true; }
catch (Exception a) { }
}
}
}
catch (Exception x)
{
}
}
protected void Page_Load(object sender, EventArgs e)
{
connect connect = new connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
string loi = "Dữ liệu đầu vào lỗi";
string ngaybaydau = "";
string ngayketthuc = "";
try
{
try
{
if (Request.QueryString["ngaybaydau"] != null && Request.QueryString["ngaybaydau"].Length != 0)
{
ngaybaydau = Request.QueryString["ngaybaydau"];
}
if (Request.QueryString["ngayketthuc"] != null && Request.QueryString["ngayketthuc"].Length != 0)
{
ngayketthuc = Request.QueryString["ngayketthuc"];
}
}
catch (Exception a) { }
if (ngaybaydau.Length == 0 || ngayketthuc.Length == 0)
{
int.Parse("a");
}
loi = "Lỗi không xác định!";
maHoa m = new maHoa();
ngaybaydau = m.Base64Decode(ngaybaydau);
ngayketthuc = m.Base64Decode(ngayketthuc);
if (!IsPostBack)
{
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
string sql = "select dh.id_don_hang, cast(FORMAT(dh.ngay_tao_don_hang, 'dd-MM-yyyy') as varchar) as ngay_tao_don_hang, " +
" sp.ten_san_pham, ctdh.so_luong, " +
" cast (sp.gia_nhap_san_pham as int) donGiaNhap, " +
" cast(ctdh.so_luong * sp.gia_nhap_san_pham as int)thanhTienNhap, " +
" cast(ctdh.gia_da_giam as int)donGiaBan, " +
" cast(ctdh.so_luong * ctdh.gia_da_giam as int)thanhTienBan, " +
" cast((ctdh.so_luong * ctdh.gia_da_giam - ctdh.so_luong * sp.gia_nhap_san_pham) as int) tienLoi " +
" from don_hang dh join chi_tiet_don_hang ctdh on dh.id_don_hang = ctdh.id_don_hang " +
" join san_pham sp on sp.id_san_pham=ctdh.id_san_pham " +
" where " +
" DATEDIFF(DAY,'" + ngaybaydau + "', dh.ngay_tao_don_hang) >= 0 " +
" and DATEDIFF(DAY,dh.ngay_tao_don_hang, '" + ngayketthuc + "') >= 0 " +
" and dh.id_ttdh=3 " +
" order by dh.id_don_hang asc";
DataTable tmp = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp);
//khungHoaDon KHD = new khungHoaDon();
//DataTable BangChiTietDoanhThu = KHD.Tables["ChiTietSanPhamDonHang"];
DataTable BangChiTietDoanhThu = new DataTable();
BangChiTietDoanhThu.Columns.Add("id_don_hang");
BangChiTietDoanhThu.Columns.Add("ngay_tao_don_hang");
BangChiTietDoanhThu.Columns.Add("ten_san_pham");
BangChiTietDoanhThu.Columns.Add("so_luong");
BangChiTietDoanhThu.Columns.Add("donGiaNhap");
BangChiTietDoanhThu.Columns.Add("thanhTienNhap");
BangChiTietDoanhThu.Columns.Add("donGiaBan");
BangChiTietDoanhThu.Columns.Add("thanhTienBan");
BangChiTietDoanhThu.Columns.Add("tienLoi");
long tongdoanhthu = 0, tongtienloi = 0;
for (int i = 0; i < tmp.Rows.Count; i++)
{
tongdoanhthu += int.Parse(tmp.Rows[i][7].ToString());
tongtienloi += int.Parse(tmp.Rows[i][8].ToString());
DataRow x = BangChiTietDoanhThu.NewRow();
x[0] = tmp.Rows[i][0].ToString();
x[1] = tmp.Rows[i][1].ToString();
x[2] = mH.Base64Decode(tmp.Rows[i][2].ToString());
x[3] = tmp.Rows[i][3].ToString();
x[4] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][4].ToString())).Replace(",", ".") + " vnđ";
x[5] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][5].ToString())).Replace(",", ".") + " vnđ";
x[6] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][6].ToString())).Replace(",", ".") + " vnđ";
x[7] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][7].ToString())).Replace(",", ".") + " vnđ";
x[8] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][8].ToString())).Replace(",", ".") + " vnđ";
BangChiTietDoanhThu.Rows.Add(x);
}
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Report1.rdlc");
//
ReportParameter[] param = new ReportParameter[4];
param[0] = new ReportParameter("thoiGianDauCuoi", "TỪ NGÀY " + ngaybaydau + " ĐẾN NGÀY " + ngayketthuc);
param[1] = new ReportParameter("ngaytaobaocao", DateTime.Now.ToString("dd/MM/yyyy"));
param[2] = new ReportParameter("tongdoanhthu", String.Format("{0:n0}", tongdoanhthu).Replace(",", ".") + " vnđ");
param[3] = new ReportParameter("tongtienloi", String.Format("{0:n0}", tongtienloi).Replace(",", ".") + " vnđ");
ReportViewer1.LocalReport.SetParameters(param);
//
ReportDataSource datasource = new ReportDataSource("PhaiChinhXac", BangChiTietDoanhThu);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
}
}
catch (Exception a)
{
Response.Write("<script language='javascript'> alert('" + loi + "'); history.go(-1); </script>");
}
//
}
protected void Page_Load(object sender, EventArgs e)
{
int id_don_hang = 0;
try
{
if (Request.QueryString["id_don_hang"] != null && Request.QueryString["id_don_hang"] != "")
{
id_don_hang = int.Parse(Request.QueryString["id_don_hang"]);
}
}
catch (Exception a) { }
if (id_don_hang == 0)
{
Response.Redirect("./danhSachTTDH.aspx");
}
string sql =
"select " +
"dh.id_don_hang, " +
"n.ten_nguoi, " +
"ttn.ten_tinh_trang, " +
"ttdh.ten_ttdh, " +
"ptvc.ten_ptvc, " +
"kv.ht+ ', ' +dh.dia_chi_nhan_hang_chi_tiet, " +
"dh.ma_van_chuyen, " +
"cast(dh.phi_van_chuyen as int), " +
"cast(dh.phi_thu_ho as int), " +
"cast(dh.tong_tien as int), " +
"cast(FORMAT(dh.ngay_tao_don_hang, 'dd-MM-yyyy') as varchar) as ngay_tao_don_hang , " +
"cast(FORMAT(dh.ngay_xac_nhan_don_hang_thanh_cong, 'dd-MM-yyyy') as varchar) as ngay_xac_nhan_don_hang_thanh_cong , " +
"dh.so_ngay_giao_gan_nhat, " +
"dh.so_ngay_giao_xa_nhat, " +
"n.sdt_nguoi, " +
"dh.id_ttdh, " +
"n.id_nguoi " +
"from don_hang dh " +
"join nguoi n on dh.id_nguoi=n.id_nguoi " +
"join tinh_trang_nguoi ttn on ttn.id_tinh_trang_nguoi=n.id_tinh_trang_nguoi " +
"join tinh_trang_don_hang ttdh on ttdh.id_ttdh=dh.id_ttdh " +
"join ( " +
" select h.id_khu_vuc, t.ten_khu_vuc+ ', ' +h.ten_khu_vuc as 'ht' "+
" from khu_vuc h join khu_vuc t on h.id_khu_vuc_cha = t.id_khu_vuc "+
") as kv on kv.id_khu_vuc=dh.id_khu_vuc " +
"join phuong_thuc_van_chuyen ptvc on dh.id_ptvc=ptvc.id_ptvc " +
"WHERE dh.id_don_hang=" + id_don_hang;
connect connect = new connect();
DataTable ds = new DataTable();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
ds = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds);
if (ds.Rows.Count == 0)
{
Response.Redirect("./danhSachTTDH.aspx");
}
if (!IsPostBack)
{
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
sql = "select sp.id_san_pham, th.ten_thuong_hieu, sp.ten_san_pham, sp.anh_san_pham, ctdh.ma_giam_gia, ctdh.so_luong, cast(ctdh.gia_san_pham as int), cast(ctdh.gia_da_giam as int) " +
"from chi_tiet_don_hang ctdh join san_pham sp on ctdh.id_san_pham=sp.id_san_pham " +
"join thuong_hieu th on th.id_thuong_hieu=sp.id_thuong_hieu " +
"where id_don_hang=" + id_don_hang;
DataTable tmp = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp);
//khungHoaDon KHD = new khungHoaDon();
//DataTable BangChiTietSanPham = KHD.Tables["ChiTietSanPhamDonHang"];
DataTable BangChiTietSanPham = new DataTable();
BangChiTietSanPham.Columns.Add("Ten");
BangChiTietSanPham.Columns.Add("SL");
BangChiTietSanPham.Columns.Add("DG");
BangChiTietSanPham.Columns.Add("tamTinh");
BangChiTietSanPham.Columns.Add("Giam");
BangChiTietSanPham.Columns.Add("ThanhTien");
for (int i = 0; i < tmp.Rows.Count; i++)
{
DataRow x = BangChiTietSanPham.NewRow();
x["Ten"] = mH.Base64Decode(tmp.Rows[i][2].ToString());
x["SL"] = tmp.Rows[i][5].ToString();
x["DG"] = String.Format("{0:n0}", int.Parse(tmp.Rows[i][6].ToString())).Replace(",", ".") + " vnđ";
long tam1 = int.Parse(tmp.Rows[i][6].ToString()) * int.Parse(tmp.Rows[i][5].ToString());
long tam2 = int.Parse(tmp.Rows[i][7].ToString()) * int.Parse(tmp.Rows[i][5].ToString());
long tam3 = tam1 - tam2;
x["tamTinh"] = String.Format("{0:n0}", tam1).Replace(",", ".") + " vnđ";
x["Giam"] = String.Format("{0:n0}", tam3).Replace(",", ".") + " vnđ";
x["ThanhTien"] = String.Format("{0:n0}", tam2).Replace(",", ".") + " vnđ";
BangChiTietSanPham.Rows.Add(x);
}
ReportViewer1.ProcessingMode = ProcessingMode.Local;
ReportViewer1.LocalReport.ReportPath = Server.MapPath("Report1.rdlc");
//
ReportParameter[] param = new ReportParameter[11];
param[0] = new ReportParameter("maDonHang", "#" + ds.Rows[0][0].ToString());
param[1] = new ReportParameter("hoTen", ds.Rows[0][1].ToString());
param[2] = new ReportParameter("SDT", ds.Rows[0][14].ToString());
param[3] = new ReportParameter("PTVC", ds.Rows[0][4].ToString());
param[4] = new ReportParameter("DCGH", ds.Rows[0][5].ToString());
param[5] = new ReportParameter("ngayDat", ds.Rows[0][10].ToString());
long tam = (long.Parse(ds.Rows[0][9].ToString()) - long.Parse(ds.Rows[0][8].ToString()) - long.Parse(ds.Rows[0][7].ToString()));
param[6] = new ReportParameter("tongCong", String.Format(" {0:0,0}", tam).Replace(",", ".") + " vnđ");
param[7] = new ReportParameter("phiVanChuyen", String.Format(" {0:0,0}", long.Parse(ds.Rows[0][7].ToString())).Replace(",", ".") + " vnđ");
param[8] = new ReportParameter("phiThuHo", String.Format(" {0:0,0}", long.Parse(ds.Rows[0][8].ToString())).Replace(",", ".") + " vnđ");
param[9] = new ReportParameter("tongTienThanhToan", String.Format(" {0:0,0}", long.Parse(ds.Rows[0][9].ToString())).Replace(",", ".") + " vnđ");
param[10] = new ReportParameter("ngayBaoCao", DateTime.Now.ToString("dd/MM/yyyy"));
ReportViewer1.LocalReport.SetParameters(param);
//
ReportDataSource datasource = new ReportDataSource("PhaiChinhXac", BangChiTietSanPham);
ReportViewer1.LocalReport.DataSources.Clear();
ReportViewer1.LocalReport.DataSources.Add(datasource);
}
}
protected void Page_Load(object sender, EventArgs e)
{
id_loai_san_pham = 0;
connect = new connect();
mH = new WebApplication2.QuanTri.maHoa();
try
{
if (Request.QueryString["id_loai_san_pham"] != null && Request.QueryString["id_loai_san_pham"] != "")
{
id_loai_san_pham = int.Parse(Request.QueryString["id_loai_san_pham"]);
}
}
catch (Exception a) { }
if (id_loai_san_pham == 0)
{
Response.Redirect("danhsachloaisanpham.aspx");
}
System.Data.DataTable ds = new System.Data.DataTable();
{
string sql = "select id_loai_san_pham, ten_loai_san_pham, anh_loai_san_pham, bieu_tuong_loai_san_pham, cap_do_loai_san_pham, id_cha_loai_san_pham from loai_san_pham where id_loai_san_pham=" + id_loai_san_pham;
WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi);
ketnoi.Open();
System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh);
data.Fill(ds);
ketnoi.Close();
id_cha = ds.Rows[0][5].ToString();
if (!IsPostBack)
{
TextBox1.Text = mH.Base64Decode(ds.Rows[0][1].ToString());
TextBox4.Text = ds.Rows[0][4].ToString();
}
//TextBox4.Text = ds.Rows[0][4].ToString();
}
System.Data.DataTable lsp = new System.Data.DataTable();
{
string sql = "select id_loai_san_pham, ten_loai_san_pham from loai_san_pham where cap_do_loai_san_pham = " + (int.Parse(TextBox4.Text) - 1);
WebApplication2.YNNSHOP56131778.CONGFIG.connect cnt = new WebApplication2.YNNSHOP56131778.CONGFIG.connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand lenh = new System.Data.SqlClient.SqlCommand(sql, ketnoi);
ketnoi.Open();
System.Data.SqlClient.SqlDataAdapter data = new System.Data.SqlClient.SqlDataAdapter(lenh);
data.Fill(lsp);
ketnoi.Close();
for (int i = 0; i < lsp.Rows.Count; i++)
{
lsp.Rows[i][1] = mH.Base64Decode(lsp.Rows[i][1].ToString());
}
if ((int.Parse(TextBox4.Text)) == 0)
{
System.Data.DataRow row;
row = lsp.NewRow();
row[0] = 0;
row[1] = "cao nhất";
lsp.Rows.Add(row);
}
DropDownList1.DataSource = lsp;
DropDownList1.DataTextField = "ten_loai_san_pham";
DropDownList1.DataValueField = "id_loai_san_pham";
DropDownList1.DataBind();
try { DropDownList1.Items.FindByValue(id_cha + "").Selected = true; }catch (Exception a) { }
}
}
