protected void Button1_Click(object sender, EventArgs e)
{
string loi = "Sản phẩm này không tồn tại!";
try
{
string sql =
"kiem_tra_san_pham " + TextBox1.Text;
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)
{
int.Parse("a"); //hủy thao tác
}
loi = "Sản phẩm đã thêm vào trước đó!";
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
System.Data.SqlClient.SqlConnection connDB = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("danh_sach_loai_san_pham_cua_san_pham_them", connDB);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@id_san_pham", System.Data.SqlDbType.NVarChar).Value = TextBox1.Text;
cmd.Parameters.Add("@id_loai_san_pham", System.Data.SqlDbType.NVarChar).Value = int.Parse(Request.QueryString["id_loai_san_pham"]);
connDB.Open();
cmd.ExecuteNonQuery();
connDB.Close();
Response.Write("<script language='javascript'> alert('Thêm thành công'); window.open('" + Page.Request.Url.ToString() + "','_self', 1); </script>");
}
catch (Exception x)
{
Response.Write("<script language='javascript'> alert('" + loi + "');history.go(-1); </script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
string sql = "select id_nguoi, email_nguoi, mat_khau_nguoi, ten_nguoi, cast(FORMAT(ngay_sinh, 'yyyy-MM-dd') as varchar) as ngay_sinh, dia_chi_nguoi, sdt_nguoi, gioi_tinh_nguoi from nguoi where id_nguoi=";
int id_nguoi = 0;
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
connect connect;
try
{
if (Request.QueryString["id_nguoi"] != null && Request.QueryString["id_nguoi"] != "")
{
id_nguoi = int.Parse(Request.QueryString["id_nguoi"]);
}
}
catch (Exception qqe) { }
if (id_nguoi == 0)
{
Response.Redirect("./DanhSach.aspx");
}
connect = new connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
DataTable ds = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql + +id_nguoi, ketnoi)).Fill(ds);
if (ds == null || ds.Rows.Count == 0)
{
Response.Redirect("./DanhSach.aspx");
}
maHoa m = new maHoa();
if (!IsPostBack)
{
TextBox6.Text = ds.Rows[0][0].ToString();
TextBox0.Text = ds.Rows[0][1].ToString();
TextBox1.Text = m.Base64Decode(ds.Rows[0][2].ToString());
TextBox1.Attributes["type"] = "password";
TextBox2.Text = ds.Rows[0][3].ToString();
TextBox3.Text = ds.Rows[0][4].ToString();
TextBox4.Text = ds.Rows[0][5].ToString();
TextBox5.Text = ds.Rows[0][6].ToString();
if (bool.Parse(ds.Rows[0][7].ToString()) == true)
{
RadioButton1.Checked = true;
RadioButton2.Checked = false;
}
else
{
RadioButton1.Checked = false;
RadioButton2.Checked = true;
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
id_thuong_hieu = -1;
connect = new connect();
mH = new WebApplication2.QuanTri.maHoa();
try
{
if (Request.QueryString["id_thuong_hieu"] != null && Request.QueryString["id_thuong_hieu"] != "")
{
id_thuong_hieu = int.Parse(Request.QueryString["id_thuong_hieu"]);
}
}
catch (Exception a) { }
if (id_thuong_hieu == -1)
{
Response.Redirect("./danhSach.aspx");
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int id_san_pham = 0;
try
{
if (Request.QueryString["id_san_pham"] != null && Request.QueryString["id_san_pham"] != "")
{
id_san_pham = int.Parse(Request.QueryString["id_san_pham"]);
}
}
catch (Exception a) { }
if (id_san_pham == 0)
{
Response.Redirect("./danhSach.aspx");
}
{
string loi = "Thêm bị lỗi";
try
{
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
WebApplication2.YNNSHOP56131778.CONGFIG.connect connect = new WebApplication2.YNNSHOP56131778.CONGFIG.connect();
System.Data.SqlClient.SqlConnection connDB = new System.Data.SqlClient.SqlConnection(connect.getconnect());
System.Data.SqlClient.SqlCommand cmd = new System.Data.SqlClient.SqlCommand("danh_sach_anh_cua_san_pha_them", connDB);
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.Parameters.Add("@id_san_pham", System.Data.SqlDbType.NVarChar).Value = id_san_pham;
cmd.Parameters.Add("@duong_link_anh", System.Data.SqlDbType.NVarChar).Value = mH.Base64Encode(TextBox1.Text);
connDB.Open();
cmd.ExecuteNonQuery();
connDB.Close();
Response.Write("<script language='javascript'> alert('Thêm thành công'); window.open('" + Session["danhSachAnh"].ToString() + "','_self', 1); </script>");
}
catch (Exception x)
{
Response.Write("<script language='javascript'> alert('" + loi + "');history.go(-1); </script>");
}
}
}
protected void Page_Load(object sender, EventArgs e)
{
connect connect;
try
{
if (Request.QueryString["id_phieu_nhap"] != null && Request.QueryString["id_phieu_nhap"] != "")
{
id_phieu_nhap = int.Parse(Request.QueryString["id_phieu_nhap"]);
}
}
catch (Exception a) { }
if (id_phieu_nhap == 0)
{
Response.Redirect("./danhSach.aspx");
}
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
string sql = "select id_kho_hang, ten_kho_hang from kho_hang";
connect = new connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
DataTable ds = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds);
if (!IsPostBack)
{
DropDownList1.DataSource = ds;
DropDownList1.DataTextField = "ten_kho_hang";
DropDownList1.DataValueField = "id_kho_hang";
DropDownList1.DataBind();
}
sql = "select pnhh.id_phieu_nhap, pnhh.id_nguoi, n.ten_nguoi, pnhh.id_kho_hang, cast(FORMAT(pnhh.ngay_tao_phieu, 'yyyy-MM-dd') as varchar) as ngay_tao_phieu, pnhh.mo_ta_nguon_nhap, CASE WHEN DATEDIFF(HOUR, GETDATE(), pnhh.ngay_tao_phieu)>=-24 THEN 1 ELSE 0 END " +
"from phieu_nhap_hang_hoa pnhh " +
"join nguoi n on pnhh.id_nguoi=n.id_nguoi " +
"where pnhh.id_phieu_nhap=" + id_phieu_nhap;
connect = new connect();
ds = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds);
if (ds == null || ds.Rows.Count == 0)
{
Response.Redirect("./danhSach.aspx");
}
if (int.Parse(ds.Rows[0][6].ToString()) == 0)
{
hieu_luc = false;
}
else
{
hieu_luc = true;
}
if (hieu_luc == false)
{
Response.Redirect("./danhSach.aspx");
}
if (!IsPostBack)
{
TextBox6.Text = ds.Rows[0][0].ToString();
TextBox7.Text = ds.Rows[0][2].ToString();
TextBox8.Text = ds.Rows[0][4].ToString();
TextBox3.Text = ds.Rows[0][5].ToString();
DropDownList1.SelectedValue = ds.Rows[0][3].ToString();
}
}
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)
{
mH = new WebApplication2.QuanTri.maHoa();
connect = new connect();
}
protected void Page_Load(object sender, EventArgs e)
{
connect connect;
try
{
if (Request.QueryString["id_kho_hang"] != null && Request.QueryString["id_kho_hang"] != "")
{
id_kho_hang = int.Parse(Request.QueryString["id_kho_hang"]);
}
}
catch (Exception qqe) { }
if (id_kho_hang == 0)
{
Response.Redirect("./danhSach.aspx");
}
WebApplication2.QuanTri.maHoa mH = new WebApplication2.QuanTri.maHoa();
connect = new connect();
System.Data.SqlClient.SqlConnection ketnoi = new System.Data.SqlClient.SqlConnection(connect.getconnect());
string sql = "select id_kho_hang, id_khu_vuc, ten_kho_hang, dia_chi_kho_hang_chi_tiet, dien_tich_kho, cast(FORMAT(ngay_tao_kho, 'yyyy-MM-dd') as varchar) as ngay_tao_kho, ghi_chu_kho " +
"from kho_hang " +
"where id_kho_hang=" + id_kho_hang;
DataTable ds = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(ds);
if (ds == null || ds.Rows.Count == 0)
{
Response.Redirect("./danhSach.aspx");
}
//1. danh sách tỉnh
sql = "select id_khu_vuc, ten_khu_vuc from khu_vuc where id_khu_vuc_cha=0";
connect = new connect();
DataTable tmp = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp);
if (!IsPostBack)
{
DropDownList2.DataSource = tmp;
DropDownList2.DataTextField = "ten_khu_vuc";
DropDownList2.DataValueField = "id_khu_vuc";
DropDownList2.DataBind();
}
//2. set mã tỉnh
sql = "select id_khu_vuc_cha from khu_vuc where id_khu_vuc=" + ds.Rows[0][1].ToString();
tmp = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp);
string id_tinh = tmp.Rows[0][0].ToString();
//3. huyện
sql = "select id_khu_vuc, ten_khu_vuc from khu_vuc where id_khu_vuc_cha=" + tmp.Rows[0][0].ToString();
tmp = new DataTable();
new System.Data.SqlClient.SqlDataAdapter(new System.Data.SqlClient.SqlCommand(sql, ketnoi)).Fill(tmp);
if (!IsPostBack)
{
DropDownList1.DataSource = tmp;
DropDownList1.DataTextField = "ten_khu_vuc";
DropDownList1.DataValueField = "id_khu_vuc";
DropDownList1.DataBind();
}
if (!IsPostBack)
{
TextBox6.Text = ds.Rows[0][0].ToString();
TextBox7.Text = ds.Rows[0][2].ToString();
TextBox3.Text = ds.Rows[0][3].ToString();
TextBox8.Text = ds.Rows[0][4].ToString();
TextBox9.Text = ds.Rows[0][5].ToString();
TextBox10.Text = ds.Rows[0][6].ToString();
DropDownList2.SelectedValue = id_tinh;
DropDownList1.SelectedValue = ds.Rows[0][1].ToString();
}
}
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) { }
}
}
