private void SellNewITem(string strSanPhamID, string strSize = null)
 {
     if (SanPhamController.IsExitsItem(strSanPhamID))
     {
         SanPham   itemSP  = SanPhamController.GetItem(strSanPhamID);
         DataRow[] findRow = null;
         if (strSize == null)
         {
             findRow = tblDonHangChiTiet.Select(string.Format("[SanPhamID]='{0}' and [Size] is null", strSanPhamID));
         }
         else
         {
             findRow = tblDonHangChiTiet.Select(string.Format("[SanPhamID]='{0}' and [Size] = '{1}'", strSanPhamID, strSize));
         }
         if (findRow.Count() < 1)//chưa có
         {
             tblDonHangChiTiet.Rows.Add(itemSP.SanPhamID, itemSP.TenSanPham, itemSP.DVT, strSize, 1, itemSP.GiaBan);
         }
         else
         {
             findRow[0]["SoLuong"] = Convert.ToInt32(findRow[0]["SoLuong"]) + 1;
         }
         gridView1.RefreshData();
         gridView1.BestFitColumns();
     }
     else
     {
         MessageBox.Show("Sản phầm này chưa có trong danh mục,\n\n Vui lòng kiểm tra lại hoặc nhập vào danh mục sản phẩm", "Cảnh Báo", MessageBoxButtons.OK, MessageBoxIcon.Error);
         return;
     }
 }
Beispiel #2
0
        public void loadDTList_Tablet()
        {
            SanPhamController sp = new SanPhamController();
            DataTable         dt = new DataTable();

            dt = sp.SanPham_GetByTabLet();
            for (int i = 0; i < dt.Rows.Count; i++)
            {
                double g = double.Parse(dt.Rows[i]["Gia"].ToString());
                string a = g.ToString("###,###").Replace(',', '.');
                ltrTablet.Text += @"
            <div class='col_1_of_3 span_1_of_3'>
                        <a href = 'ThongTinSanPham.aspx?idsp=" + dt.Rows[i]["IDSanPham"] + @"' >
                             <div class='inner_content clearfix'>
                                <div class='product_image'>
                                    <img src = 'images/" + dt.Rows[i]["HinhAnh1"] + @"' alt=''/>
                                </div>
                                <div class='price'>
                                    <div class='cart-left'>
                                        <p class='title'>" + dt.Rows[i]["TenSP"] + @"</p>
                                        <div class='price1'>
                                            <span class='actual'>" + a + @"VND</span>
                                        </div>
                                    </div>
                                    <div class='cart-right'></div>
                                    <div class='clear'></div>
                                </div>
                            </div>
                        </a>
                    </div>
";
            }
        }
        public void loadIngSP()
        {
            if (Request.QueryString["idsp"] == null)
            {
                Response.Redirect("Index.aspx");
            }
            else
            {
                string            id = Request.QueryString["idsp"].ToString();
                SanPhamController sp = new SanPhamController();
                DataTable         dt = new DataTable();
                dt = sp.SanPham_GetByID(id);
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    ltrhinhanh.Text += @"
                           <li>
								<img class='etalage_thumb_image' src='images/"                                 + dt.Rows[i]["HinhAnh1"] + @"'  />
                                    <img class='etalage_source_image' src='images/" + dt.Rows[i]["HinhAnh1"] + @"' />
							</li>
                            <li>
								<img class='etalage_thumb_image' src='images/"                                 + dt.Rows[i]["HinhAnh2"] + @"'  />
                                    <img class='etalage_source_image' src='images/" + dt.Rows[i]["HinhAnh2"] + @"' title='' />
							</li>"                            ;
                }
            }
        }
Beispiel #4
0
 private void frmBarcode_Load(object sender, EventArgs e)
 {
     KhoiTaoLuoi();
     KhoiTaoDuLieuSearch();
     txtSearch.Properties.DataSource = SanPhamController.GetAllList();
     //gridControl1.DataSource = SanPhamController.GetAllList();
 }
Beispiel #5
0
 private void frmTonKho_Load(object sender, EventArgs e)
 {
     KhoiTaoLuoi();
     gridControl1.DataSource = SanPhamController.TonKhoHeThong();
     gridView1.BestFitColumns();
     txtSearchSanPham.Properties.NullValuePrompt = "Tìm theo mã hoặc tên sản phẩm";
 }
Beispiel #6
0
 public ucQlsanpham()
 {
     InitializeComponent();
     sanPham              = new SanPhamController();
     btnCapnhat.Enabled   = false;
     btnThemMoiSP.Enabled = false;
 }
Beispiel #7
0
        private void btnAdd_Click(object sender, EventArgs e)
        {
            frmAddSanPham f = new frmAddSanPham();

            f.ShowDialog();
            gridControl1.DataSource = SanPhamController.GetAllList();
        }
Beispiel #8
0
 public ucLapHoaDon()
 {
     InitializeComponent();
     sanPham   = new SanPhamController();
     khachhang = new KhachhangController();
     hoaDon    = new HoaDonController();
     thamSo    = new ThamSoController();
 }
Beispiel #9
0
        private void gr_btn_del_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
        {
            int intRowSelect = gridView1.FocusedRowHandle;

            if (intRowSelect >= 0)
            {
                string strSanPhamID = gridView1.GetRowCellValue(intRowSelect, "SanPhamID").ToString();
                switch (e.Button.Caption.ToUpper())
                {
                case "PAUSE":    // ngừng kinh doanh
                    if (MessageBox.Show("Bạn có muốn ngừng kinh doanh sản phẩm này?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
                    {
                        SanPhamController.SetTrangThaiKinhDoanh(strSanPhamID, true);   //ngung kinh doanh
                        gridControl1.DataSource = SanPhamController.GetAllList();
                    }
                    break;

                case "START":                                                     //  kinh doanh laij
                    SanPhamController.SetTrangThaiKinhDoanh(strSanPhamID, false); //kinh doanh lai
                    gridControl1.DataSource = SanPhamController.GetAllList();
                    break;

                case "DELETE":
                    if (MessageBox.Show("Bạn có muốn xóa sản phẩm này không?", "Xác nhận", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes)
                    {
                        SanPhamController.Del(strSanPhamID);
                        gridControl1.DataSource = SanPhamController.GetAllList();
                    }
                    break;

                case "COPY":     //sao chep san pham
                    SanPham itemCopy = SanPhamController.GetItem(strSanPhamID);
                    if (itemCopy != null)
                    {
                        frmAddSanPham f = new frmAddSanPham();
                        f.itemCopy = itemCopy;
                        f.formMode = "Copy";
                        f.ShowDialog(this);
                        gridControl1.DataSource = SanPhamController.GetAllList();
                    }
                    break;

                default:
                    break;
                }
            }
        }
Beispiel #10
0
        private void txtSearch_EditValueChanged(object sender, EventArgs e)
        {
            string strSanPhamID = txtSearch.EditValue.ToString();

            if (SanPhamController.IsExitsItem(strSanPhamID))
            {
                SanPham itemSP = SanPhamController.GetItem(strSanPhamID);
                if (tblDonHangChiTiet == null)
                {
                    KhoiTaoTableDonHangChiTiet();
                }

                if (tblDonHangChiTiet.Select(string.Format("[SanPhamID]='{0}'", strSanPhamID)).Count() < 1)
                {
                    tblDonHangChiTiet.Rows.Add(itemSP.SanPhamID, itemSP.TenSanPham, 1, itemSP.GiaBan);
                    gridView1.RefreshData();
                }
            }
        }
Beispiel #11
0
        public ucLapPhieuNhapHang()
        {
            InitializeComponent();
            sanPham    = new SanPhamController();
            nhacungcap = new NhacungcapController();
            phieuNhap  = new PhieuNhapController();

            DataTable dt;

            dt = sanPham.GetDanhSachDonVi();
            foreach (DataRow row in dt.Rows)
            {
                cbbDonVi.Items.Add(row[0]);
            }
            dt = nhacungcap.GetAllNhacungcap();
            foreach (DataRow row in dt.Rows)
            {
                cbbTenNhaCC.Items.Add(row[1]);
            }
        }
Beispiel #12
0
        private void gridView1_DoubleClick(object sender, EventArgs e)
        {
            //sửa thông tin sản phẩm
            int intRow = gridView1.FocusedRowHandle;

            if (intRow >= 0)
            {
                string  strSanPhamID = gridView1.GetRowCellValue(intRow, "SanPhamID").ToString();
                SanPham item         = SanPhamController.GetItem(strSanPhamID);
                if (item != null)
                {
                    frmAddSanPham f = new frmAddSanPham();
                    f.formMode = "edit";
                    f.itemCopy = item;
                    f.ShowDialog(this);
                    gridControl1.DataSource    = SanPhamController.GetAllList(); // làm mới lại dữ liệu
                    gridView1.FocusedRowHandle = intRow;
                }
            }
        }
Beispiel #13
0
        void ThemMoi()
        {
            DataRow row = ctrl.NewRow();

            row["ID"]              = txtMaPhieu.Text;
            row["NGAY_NHAP"]       = dtNgayNhap.Value.Date;
            row["TONG_TIEN"]       = numTongTien.Value;
            row["ID_NHA_CUNG_CAP"] = cmbNhaCungCap.SelectedValue;
            row["DA_TRA"]          = numDaTra.Value;
            row["CON_NO"]          = numConNo.Value;
            ctrl.Add(row);

            PhieuNhapController ctrlPN = new PhieuNhapController();

            if (ctrlPN.LayPhieuNhap(txtMaPhieu.Text) != null)
            {
                MessageBox.Show("Mã Phiếu nhập này đã tồn tại !", "Phieu Nhap", MessageBoxButtons.OK, MessageBoxIcon.Error);
                return;
            }

            if (ThamSo.LaSoNguyen(txtMaPhieu.Text))
            {
                long so = Convert.ToInt64(txtMaPhieu.Text);
                if (so >= ThamSo.LayMaPhieuNhap())
                {
                    ThamSo.GanMaPhieuNhap(so + 1);
                }
            }

            ctrl.Save();
            ctrlMaSP.Save();

            SanPhamController ctrlSP = new SanPhamController();

            foreach (DataGridViewRow view in dataGridView.Rows)
            {
                ctrlSP.CapNhatGiaNhap(Convert.ToString(view.Cells["colSanPham"].Value),
                                      Convert.ToInt64(view.Cells["colDonGiaNhap"].Value),
                                      Convert.ToInt64(view.Cells["colSoLuong"].Value));
            }
        }
Beispiel #14
0
        private void frmTimSanPham_Load(object sender, System.EventArgs e)
        {
            KhoiTaoLuoi();
            //gridControl1.DataSource = SanPhamController.GetAllList();
            TableSanPham            = SanPhamController.TonKhoHeThong();
            dtView                  = TableSanPham.DefaultView;
            gridControl1.DataSource = dtView;
            gridView1.BestFitColumns();

            treeList1.DataSource           = NhomHangController.Getlist();
            treeList1.Columns[0].Caption   = "Nhóm Hàng";
            treeList1.Columns[0].FieldName = "TenNhomHang";
            treeList1.Columns[0].OptionsColumn.AllowEdit = false;

            treeList1.ParentFieldName = "NhomHangChaID";
            treeList1.KeyFieldName    = "NhomHangID";
            treeList1.ExpandAll();
            //treeList1.BestFitColumns();

            treeList1.OptionsView.ShowHorzLines = false;
            treeList1.OptionsView.ShowVertLines = false;
        }
Beispiel #15
0
        private void txtSearch_KeyDown(object sender, KeyEventArgs e)
        {
            if (e.KeyCode == Keys.Enter)
            {
                string strSanPhamID = string.Empty;
                if (txtSanPham.EditValue != null)
                {
                    strSanPhamID = txtSanPham.EditValue.ToString();
                }
                else
                {
                    return;
                }

                if (SanPhamController.IsExitsItem(strSanPhamID))
                {
                    SanPham itemSP = SanPhamController.GetItem(strSanPhamID);
                    if (tblDonHangChiTiet == null)
                    {
                        KhoiTaoTableDonHangChiTiet();
                    }

                    if (tblDonHangChiTiet.Select(string.Format("[SanPhamID]='{0}' and [Size] is null", strSanPhamID)).Count() < 1)
                    {
                        tblDonHangChiTiet.Rows.Add(itemSP.SanPhamID, itemSP.TenSanPham, 1, itemSP.GiaBan);
                        //gridView1.RefreshData();
                    }
                    else
                    {
                        DataRow findRow = tblDonHangChiTiet.Select(string.Format("[SanPhamID]='{0}' and [Size] is null", strSanPhamID))[0];
                        findRow["SoLuong"] = Convert.ToInt32(findRow["SoLuong"]) + 1;
                    }
                    gridView1.RefreshData();
                    txtSanPham.Focus();
                    txtSanPham.SelectAll();
                }
            }
        }
Beispiel #16
0
        public void LoadDTByGia()
        {
            int tu;
            int den;
            SanPhamController dt = new SanPhamController();
            DataTable         d  = new DataTable();
            string            id = Request.QueryString["id"].ToString();

            switch (id)
            {
            case "1":
            {
                tu  = 1000000;
                den = 3000000;
                d   = dt.SanPham_GetByGia(tu, den);
                if (d.Rows.Count == 0)
                {
                    khong.Visible = true;
                }
                else
                {
                    for (int i = 0; i < d.Rows.Count; i++)
                    {
                        double g = double.Parse(d.Rows[i]["Gia"].ToString());
                        string a = g.ToString("###,###").Replace(',', '.');

                        ltrSP.Text += @"
                             <div class='col_1_of_3 span_1_of_3'>
                                <a href = 'ThongTinSanPham.aspx?idsp=" + d.Rows[i]["IDSanPham"] + @"' >
                                <div class='inner_content clearfix'>
                                 <div class='product_image'>
                                    <img src = 'images/" + d.Rows[i]["HinhAnh1"] + @"' alt=''/>
                                    </div>
                                    <div class='price'>
                                        <div class='cart-left'>
                                            <p class='title'>" + d.Rows[i]["TenSP"] + @"</p>
                                            <div class='price1'>
                                                <span class='actual'>" + a + @" VND</span>
                                            </div>
                                        </div>
                                        <div class='cart-right'></div>
                                        <div class='clear'></div>
                                    </div>
                                  </div>
                                 </a>
                             </div>
                            ";
                    }
                }
                break;
            }

            case "2":
            {
                tu  = 3000000;
                den = 7000000;
                d   = dt.SanPham_GetByGia(tu, den);
                if (d.Rows.Count == 0)
                {
                    khong.Visible = true;
                }
                else
                {
                    for (int i = 0; i < d.Rows.Count; i++)
                    {
                        ltrSP.Text += @"
                             <div class='col_1_of_3 span_1_of_3'>
                                <a href = 'ThongTinSanPham.aspx?idsp=" + d.Rows[i]["IDSanPham"] + @"' >
                                <div class='inner_content clearfix'>
                                 <div class='product_image'>
                                    <img src = 'images/" + d.Rows[i]["HinhAnh1"] + @"' alt=''/>
                                    </div>
                                    <div class='price'>
                                        <div class='cart-left'>
                                            <p class='title'>" + d.Rows[i]["TenSP"] + @"</p>
                                            <div class='price1'>
                                                <span class='actual'>" + d.Rows[i]["Gia"] + @"</span>
                                            </div>
                                        </div>
                                        <div class='cart-right'></div>
                                        <div class='clear'></div>
                                    </div>
                                  </div>
                                 </a>
                             </div>
                            ";
                    }
                }
                break;
            }

            case "3":
            {
                tu  = 7000000;
                den = 10000000;
                d   = dt.SanPham_GetByGia(tu, den);
                if (d.Rows.Count == 0)
                {
                    khong.Visible = true;
                }
                else
                {
                    for (int i = 0; i < d.Rows.Count; i++)
                    {
                        ltrSP.Text += @"
                             <div class='col_1_of_3 span_1_of_3'>
                                <a href = 'ThongTinSanPham.aspx?idsp=" + d.Rows[i]["IDSanPham"] + @"' >
                                <div class='inner_content clearfix'>
                                 <div class='product_image'>
                                    <img src = 'images/" + d.Rows[i]["HinhAnh1"] + @"' alt=''/>
                                    </div>
                                    <div class='price'>
                                        <div class='cart-left'>
                                            <p class='title'>" + d.Rows[i]["TenSP"] + @"</p>
                                            <div class='price1'>
                                                <span class='actual'>" + d.Rows[i]["Gia"] + @"</span>
                                            </div>
                                        </div>
                                        <div class='cart-right'></div>
                                        <div class='clear'></div>
                                    </div>
                                  </div>
                                 </a>
                             </div>
                            ";
                    }
                }
                break;
            }

            case "4":
            {
                tu  = 10000000;
                den = 100000000;
                d   = dt.SanPham_GetByGia(tu, den);

                if (d.Rows.Count == 0)
                {
                    khong.Visible = true;
                }
                else
                {
                    for (int i = 0; i < d.Rows.Count; i++)
                    {
                        ltrSP.Text += @"
                             <div class='col_1_of_3 span_1_of_3'>
                                <a href = 'ThongTinSanPham.aspx?idsp=" + d.Rows[i]["IDSanPham"] + @"' >
                                <div class='inner_content clearfix'>
                                 <div class='product_image'>
                                    <img src = 'images/" + d.Rows[i]["HinhAnh1"] + @"' alt=''/>
                                    </div>
                                    <div class='price'>
                                        <div class='cart-left'>
                                            <p class='title'>" + d.Rows[i]["TenSP"] + @"</p>
                                            <div class='price1'>
                                                <span class='actual'>" + d.Rows[i]["Gia"] + @"</span>
                                            </div>
                                        </div>
                                        <div class='cart-right'></div>
                                        <div class='clear'></div>
                                    </div>
                                  </div>
                                 </a>
                             </div>
                            ";
                    }
                }
                break;
            }

            default:
            {
                string i = Request.QueryString["id"].ToString();
                d = dt.SanPham_GetBySreach(i);
                if (d.Rows.Count == 0)
                {
                    Label2.Text = "Không tìn thấy điện thoại";
                }
                else
                {
                    for (int j = 0; j < d.Rows.Count; j++)
                    {
                        ltrSP.Text += @"
                             <div class='col_1_of_3 span_1_of_3'>
                                <a href = 'ThongTinSanPham.aspx?idsp=" + d.Rows[j]["IDSanPham"] + @"' >
                                <div class='inner_content clearfix'>
                                 <div class='product_image'>
                                    <img src = 'images/" + d.Rows[j]["HinhAnh1"] + @"' alt=''/>
                                    </div>
                                    <div class='price'>
                                        <div class='cart-left'>
                                            <p class='title'>" + d.Rows[j]["TenSP"] + @"</p>
                                            <div class='price1'>
                                                <span class='actual'>" + d.Rows[j]["Gia"] + @"</span>
                                            </div>
                                        </div>
                                        <div class='cart-right'></div>
                                        <div class='clear'></div>
                                    </div>
                                  </div>
                                 </a>
                             </div>
                            ";
                    }
                }

                break;
            }
            }
        }
Beispiel #17
0
        private void Save()
        {
            if (!KiemTraNhap())
            {
                return;
            }
            SanPham item = new SanPham();

            //---------thông tin chung---------------------
            item.TenSanPham = txtTenSanPham.Text.Trim();
            item.SLTonKho   = Int32.Parse(txtSoLuong.EditValue.ToString());
            item.GiaVon     = Int32.Parse(txtGiaVon.EditValue.ToString());
            item.GiaBan     = Int32.Parse(txtGiaBan.EditValue.ToString());
            item.ChoXuatAm  = chkChoXuatAm.Checked;
            if (treelistNhomHang.EditValue != null)
            {
                item.NhomHangID  = Int32.Parse(treelistNhomHang.EditValue.ToString());
                item.TenNhomHang = treelistNhomHang.Text;
            }
            else
            {
                item.NhomHangID  = null;
                item.TenNhomHang = "Chưa chọn nhóm hàng";
            }


            if (lookupNSX.EditValue != null)
            {
                item.NhaSanXuatID  = Int32.Parse(lookupNSX.EditValue.ToString());
                item.TenNhaSanXuat = lookupNSX.Text;
            }
            else
            {
                item.NhaSanXuatID  = null;
                item.TenNhaSanXuat = "Chưa chọn nhà sản xuất";
            }

            item.ThuaVAT = Int32.Parse(cbbThueVAT.EditValue.ToString());
            // xử lý hình ảnh sản phẩm--------------------------------------
            if (imgHinhAnh.EditValue != null)
            {
                using (System.IO.MemoryStream ms = new System.IO.MemoryStream())
                {
                    imgHinhAnh.Image.Save(ms, System.Drawing.Imaging.ImageFormat.Png);
                    byte[] bytes = ms.ToArray();
                    item.HinhAnh = bytes;
                }
                //Image pic = Image.FromFile(imgHinhAnh);
                //DevExpress.XtraEditors.Controls.ByteImageConverter.ToByteArray()
                //item.HinhAnh =  imgHinhAnh.EditValue as byte[];
            }
            else
            {
                item.HinhAnh = null;
            }
            //-----------------------------------------------------------------
            //---Xử lý mã sản phẩm - trường hợp user tự tạo hoặc máy tính tạo tự động--------------
            if (!txtMaSanPham.Text.Equals(string.Empty)) // người dùng tự nhập
            {
                item.SanPhamID = txtMaSanPham.Text.Trim();
            }
            else //máy tính phải tự tạo ra.....
            {
                item.SanPhamID = SanPhamController.TaoMaSanPham("SP", 8);
            }

            if ((!formMode.ToUpper().Equals("EDIT")) && (SanPhamController.IsExitsItem(item.SanPhamID)))
            {
                MessageBox.Show("Mã sản phẩm này đã tồn tại, vui lòng nhập mã khác", "Cảnh báo", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                return;
            }


            // thông tin bao mật
            item.NguoiDungID  = Utility.NguoiSuDung.NguoiDungID;
            item.TenNguoiDung = Utility.NguoiSuDung.TenNguoiDung;
            item.LastUpdate   = DateTime.Now;
            //------------------------------------------------
            if (formMode.ToUpper().Equals("EDIT"))
            {
                SanPhamController.Edit(item);
                formMode = string.Empty;
            }
            else //trường hợp copy hoặc add sản phẩm mới
            {
                SanPhamController.Add(item);
            }
        }
Beispiel #18
0
 private void LayDuLieu()
 {
     gridControl1.DataSource = SanPhamController.GetAllList();
     gridView1.BestFitColumns();
 }
Beispiel #19
0
 public ucQlnhacungcap()
 {
     InitializeComponent();
     nhacungcap = new NhacungcapController();
     sanPham    = new SanPhamController();
 }
        private void btn_save_Click(object sender, EventArgs e)
        {
            if (MessageBox.Show("Bạn có muốn cập nhật danh mục sản phẩm vào hệ thống?", "Xác nhận", MessageBoxButtons.YesNo) == DialogResult.Yes)
            {
                int intTotalRow = gridView1.RowCount;
                int i           = 1;
                int intDongXL   = 0;
                splashScreenManager1.ShowWaitForm();
                splashScreenManager1.SetWaitFormCaption("Đợi xíu...");
                while (gridView1.RowCount > intDongXL) //xử lý từng dòng, từ dòng đầu tiên
                {
                    splashScreenManager1.SetWaitFormDescription(string.Format("Đang xử lý dòng {0}/{1}", i, intTotalRow));
                    i++;
                    try
                    {
                        //nếu dòng đó có mã và tên sản phẩm thì xử lý
                        string strID  = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["SanPhamID"]).ToString();
                        string strTen = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["TenSanPham"]).ToString();
                        if (strID != string.Empty)
                        {
                            //0:Ma SP
                            //1:TenSP
                            //2:GioTinh
                            //3:Nhom Size
                            //4:Gia ban le
                            //5:NhomSP
                            //6:DVT

                            SanPham objSanPham = new SanPham();
                            objSanPham.SanPhamID = strID;
                            string strNhomSize = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["NhomSize"]).ToString();
                            if (strNhomSize != string.Empty)
                            {
                                objSanPham.NhomSize = strNhomSize;
                            }

                            string strNhomHang = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["NhomSanPham"]).ToString();
                            if (strTen != string.Empty)
                            {
                                objSanPham.TenSanPham = strTen;
                            }
                            else
                            {
                                objSanPham.TenSanPham = strNhomHang;
                            }
                            if (gridView1.GetRowCellValue(intDongXL, gridView1.Columns[2]) != null)
                            {
                                objSanPham.GioTinh = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["GioTinh"]).ToString();
                            }
                            NhomHang objNhomHang = NhomHangController.GetByName(strNhomHang);
                            if (objNhomHang != null)
                            {
                                objSanPham.NhomHangID = objNhomHang.NhomHangID;
                            }
                            else
                            {
                                objNhomHang              = new NhomHang();
                                objNhomHang.TenNhomHang  = strNhomHang;
                                objNhomHang.NguoiDungID  = Utility.NguoiSuDung.NguoiDungID;
                                objNhomHang.TenNguoiDung = Utility.NguoiSuDung.TenNguoiDung;
                                objSanPham.NhomHangID    = NhomHangController.Add(objNhomHang);
                            }
                            //string strMaNhomHang = Utility.TenVietTat(strNhomHang);
                            //objSanPham.NhomHangID = strMaNhomHang;
                            if ((gridView1.GetRowCellValue(intDongXL, gridView1.Columns["GiaBanLe"]) != null))
                            {
                                int intGiaBan = 0;
                                if (Int32.TryParse(gridView1.GetRowCellValue(intDongXL, gridView1.Columns["GiaBanLe"]).ToString(), out intGiaBan))
                                {
                                    objSanPham.GiaBan = intGiaBan;
                                }
                                else
                                {
                                    objSanPham.GiaBan = 0;
                                }
                            }

                            //objSanPham.NgayKhoiTao = DateTime.Now;
                            if (gridView1.GetRowCellValue(intDongXL, gridView1.Columns["DVT"]) != null)
                            {
                                objSanPham.DVT = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["DVT"]).ToString();
                            }

                            if (gridView1.GetRowCellValue(intDongXL, gridView1.Columns["EXT_ID"]) != null)
                            {
                                objSanPham.EXT_ID = gridView1.GetRowCellValue(intDongXL, gridView1.Columns["EXT_ID"]).ToString();
                            }

                            objSanPham.NguoiDungID    = Utility.NguoiSuDung.NguoiDungID;
                            objSanPham.NgungKinhDoanh = false;
                            SanPhamController.Add(objSanPham);
                            gridView1.DeleteRow(intDongXL);//remove dong dang xly
                            //gridControl1.Invalidate();
                            //gridControl1.Update();
                        }
                        else
                        {
                            gridView1.SetRowCellValue(intDongXL, "ERROR", "Không có mã hoặc tên sản phẩm!");
                            intDongXL++; //bỏ qua dòng này không xly.
                        }
                    }
                    catch (Exception ex)
                    {
                        gridView1.SetRowCellValue(intDongXL, "ERROR", ex.Message);
                        //gridControl1.Invalidate();
                        //gridControl1.Update();
                        intDongXL++; //bỏ qua dòng lỗi; xly dòng tiep theo.
                        //throw;
                    }
                    //làm mới lại lưới
                    gridControl1.Invalidate();
                    gridControl1.Update();
                }

                //Them Danh Muc Nhom Hang vao he thong.

                splashScreenManager1.CloseWaitForm();
            }
        }