public static LOAISP_DTO LayLoaiSanPhamTheoMaLoaiSP(int malsp)
{
helper.connect();
string sqlCommand = "sp_LayLoaiSanPhamTheoMaLoaiSP";
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@MALSP", malsp));
try
{
LOAISP_DTO lsp = new LOAISP_DTO();
DataTable table = helper.executeQueryDataTableProcedure(sqlCommand, list);
if (table != null && table.Rows.Count > 0)
{
DataRow row = table.Rows[0];
lsp.MaLoaiSanPham = int.Parse(row["MALSP"].ToString());
lsp.MaNhomSanPham = int.Parse(row["MANHOM"].ToString());
lsp.TenLoaiSanPham = row["TENLSP"].ToString();
}
return(lsp);
}
catch (Exception ex)
{
throw ex;
}
finally
{
helper.disconnect();
}
}
public static List <LOAISP_DTO> SelectingAllProductTypeByGroup(int maNhomLoaiSanPham)
{
helper.connect();
List <LOAISP_DTO> ds = new List <LOAISP_DTO>();
List <SqlParameter> list = new List <SqlParameter>();
list.Add(new SqlParameter("@maNhomLSP", maNhomLoaiSanPham));
string sqlCommand = "sp_LayDanhSachLoaiSanPhamTheoNhom";
try
{
DataTable dt = helper.executeQueryDataTableProcedure(sqlCommand, list);
foreach (DataRow dr in dt.Rows)
{
LOAISP_DTO proTypeDTO = new LOAISP_DTO();
proTypeDTO.MaLoaiSanPham = int.Parse(dr["MALSP"].ToString());
//proTypeDTO.MaNhomSanPham = int.Parse(dr["MANHOM"].ToString());
proTypeDTO.TenLoaiSanPham = dr["TENLSP"].ToString();
ds.Add(proTypeDTO);
}
}
catch (Exception ex)
{
throw new Exception(ex.Message);
}
finally
{
helper.disconnect();
}
return(ds);
}
protected void Page_Load(object sender, EventArgs e)
{
int isLogIn;
int.TryParse(Session["IsLogin"].ToString(), out isLogIn);
if (isLogIn == 1)
{
string typeUser = Session["LoaiUser"].ToString();
if (typeUser == "Manager")
{
#region hiển thị thông tin sản phẩm
if (!IsPostBack)
{
//lấy mã sản phẩm
string masp = Request.QueryString["masp"];
if (masp != "")
{
SAN_PHAM_DTO sp = ProductBUS.LayThongTinSanPhamTheoMaSP(masp);
lbMaSP.Text = sp.MaSanPham;
//xử lý mã loại sp
//lbMaLSP.Text=sp.MaLoaiSanPham.ToString();
LOAISP_DTO lsp = ProductTypeBUS.LayLoaiSanPhamTheoMaLoaiSP(sp.MaLoaiSanPham);
lbMaLSP.Text = lsp.TenLoaiSanPham;
lbTenSP.Text = sp.TenSanPham;
txtareMota.Value = sp.MoTaSanPham;
//xử lý hình ảnh
ImageSP.ImageUrl = sp.HinhAnh;
txtChatLuong.Text = sp.ChatLuong;
txtGiaBan.Text = sp.Gia.ToString();
txtSoLuong.Text = sp.SoLuong.ToString();
txtDonVi.Text = sp.DonViTinh;
lbSoLuongConLai.Text = sp.SoLuongConLai.ToString();
lbNgayDangSP.Text = sp.NgayDangSanPham.ToString("dd/MM/yyyy");
lbNgaySuaDoi.Text = sp.NgaySuaDoi.ToString("dd/MM/yyyy");
//xử lý tình trạng
radiobtnTinhTrang.SelectedValue = sp.TinhTrangSanPham;
if (radiobtnTinhTrang.SelectedValue == "0")
{
radiobtnTinhTrang.Items[0].Enabled = true;
}
else
{
radiobtnTinhTrang.Items[1].Enabled = true;
}
//không hiển thị ngày xóa
txtSoNguoiMua.Text = sp.SoNguoiMua.ToString();
}
}
#endregion
}
else
{
Response.Redirect("../Shared/Default.aspx");
}
}
else
{
Response.Redirect("../Shared/Default.aspx");
}
}
