public void InsertHangHoaChiTiet(HangHoaChiTietInfo SanXuatLenhInfo) { ExecuteCommand(Declare.StoreProcedureNamespace.spHangHoaChiTietInsert, SanXuatLenhInfo.IdSanPham, SanXuatLenhInfo.MaVach, SanXuatLenhInfo.SoLuong, SanXuatLenhInfo.IdKho); }
internal int Insert(HangHoaChiTietInfo hangHoaChiTietInfo) { ExecuteCommand(Declare.StoreProcedureNamespace.spTonDauKyChiTietInsert, hangHoaChiTietInfo.IdChiTiet, hangHoaChiTietInfo.IdDuDauKy, hangHoaChiTietInfo.IdKho, hangHoaChiTietInfo.IdSanPham, hangHoaChiTietInfo.MaVach, hangHoaChiTietInfo.SoLuong); return(Convert.ToInt32(Parameters["p_IdChiTiet"].Value)); }
public void Update(HangHoaChiTietInfo hangHoaChiTietInfo) { ExecuteCommand(Declare.StoreProcedureNamespace.spTonDauKyChiTietUpdate, hangHoaChiTietInfo.IdChiTiet, hangHoaChiTietInfo.IdDuDauKy, hangHoaChiTietInfo.IdKho, hangHoaChiTietInfo.IdSanPham, hangHoaChiTietInfo.MaVach, hangHoaChiTietInfo.SoLuong); }
internal void UpdateHangHoaChiTiet(HangHoaChiTietInfo hangHoaChiTietInfo) { BHangDoiMaDAO.Instance.UpdateHangHoaChiTiet(hangHoaChiTietInfo); }
internal static void InsertHangHoaChiTiet(HangHoaChiTietInfo SanXuatLenhInfo) { SanXuatLenhDAO.Instance.InsertHangHoaChiTiet(SanXuatLenhInfo); }
public int Insert(HangHoaChiTietInfo hangHoaChiTietInfo) { return(TonDauKyDAO.Instance.Insert(hangHoaChiTietInfo)); }
public void Update(HangHoaChiTietInfo hangHoaChiTietInfo) { TonDauKyDAO.Instance.Update(hangHoaChiTietInfo); }
internal void UpdateHangHoaChiTiet(HangHoaChiTietInfo hangHoaChiTietInfo) { ExecuteCommand(Declare.StoreProcedureNamespace.spUpdateHangHoaChiTietByInfo); }
private void btnImportNoiDungChiTiet_Click(object sender, EventArgs e) { try { DataSet ds; string sql; openFileDialog1.FileName = String.Empty; //openFileDialog1.Filter = "*.xls|*.xlsx"; if (openFileDialog1.ShowDialog() != DialogResult.OK) { return; } frmProgress.Instance.DoWork(DoVaoBangTam, openFileDialog1.FileName); //frmProgress.Instance.DoWork(GenMaVachTuDong); return; int idSanPham, idDuDauKy; openFileDialog1.FileName = String.Empty; //openFileDialog1.Filter = "*.xls|*.xlsx"; if (openFileDialog1.ShowDialog() != DialogResult.OK) { return; } try { using (OleDbConnection oConn = new OleDbConnection()) { oConn.ConnectionString = String.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source={0};Extended Properties=\"Excel 8.0;HDR=Yes\"", openFileDialog1.FileName); oConn.Open(); sql = "Select [ma fpt] as MaSanPham, [Ten] as TenSanPham, sum([số lượng]) as SoLuong from [Items$] group by [ma fpt], [Ten]"; //sql = "Select [Mã hàng] as MaSanPham, [Tên hàng] as TenSanPham, [Giá nhập] as DonGia, sum([Số lượng]) as SoLuong from [Items$] group by [Mã hàng], [Tên hàng], [Giá nhập]"; using (OleDbDataAdapter ad = new OleDbDataAdapter(sql, oConn)) { ds = new DataSet(); ad.Fill(ds, "HangHoaDuDauKy"); ad.SelectCommand.CommandText = "Select [ma fpt] as MaSanPham, [Ten] as TenSanPham, [Serial] as Mavach, [số lượng] as SoLuong from [Items$]"; ad.Fill(ds, "ImportTable"); } } } catch (Exception exception) { #if DEBUG MessageBox.Show(exception.ToString()); #else MessageBox.Show(exception.Message); #endif return; } ConnectionUtil.Instance.BeginTransaction(); foreach (DataRow dr in ds.Tables["HangHoaDuDauKy"].Rows) { if (dr["MaSanPham"] == DBNull.Value) { continue; } DMSanPhamInfo sanPhamInfo = DmSanPhamProvider.Instance.GetSanPhamByMa(dr["MaSanPham"].ToString()); if (sanPhamInfo == null) { continue; //throw new Exception(String.Format("Mã sản phẩm '{0}' này không có trong danh mục", dr["MaSanPham"])); } idSanPham = sanPhamInfo.IdSanPham; DataRow[] foundRows = ds.Tables["ImportTable"].Select(String.Format("MaSanPham='{0}'", dr["MaSanPham"])); if (foundRows.Length > 0) { TonDauKyInfo tonDauKyInfo = TonDauKyDataProvider.Instance.GetTonDauKy(idSanPham, Convert.ToInt32(cboKho.SelectedValue), dtNgayDuDau.Value, Declare.UserId) ?? new TonDauKyInfo(); tonDauKyInfo.ThoiGian = dtNgayDuDau.Value.Date; tonDauKyInfo.IdKho = Convert.ToInt32(cboKho.SelectedValue); tonDauKyInfo.IdSanPham = idSanPham; tonDauKyInfo.SoLuong = Convert.ToInt32(dr["SoLuong"]); tonDauKyInfo.DonGia = 0; //dr["DonGia"]); tonDauKyInfo.ThanhTien = 0; // Common.IntValue(dr["SoLuong"]) * Common.DoubleValue(dr["DonGia"])); if (tonDauKyInfo.IdDuDauKy != 0) { TonDauKyDataProvider.Instance.Update(tonDauKyInfo); } else { tonDauKyInfo.NguoiTao = Declare.UserId; _IdDuDauKy = TonDauKyDataProvider.Instance.Insert(tonDauKyInfo); } foreach (DataRow dr1 in foundRows) { HangHoaChiTietInfo hangHoaChiTietInfo = TonDauKyDataProvider.Instance. GetIdHangHoaChiTietMaVachTonDauKy( dr1["MaVach"].ToString(), _IdDuDauKy) ?? new HangHoaChiTietInfo(); hangHoaChiTietInfo.IdDuDauKy = _IdDuDauKy; hangHoaChiTietInfo.IdKho = Convert.ToInt32(cboKho.SelectedValue); hangHoaChiTietInfo.IdSanPham = idSanPham; hangHoaChiTietInfo.MaVach = Convert.ToString(dr1["MaVach"]); hangHoaChiTietInfo.SoLuong = Convert.ToInt32(dr1["SoLuong"]); if (hangHoaChiTietInfo.IdChiTiet != 0) { TonDauKyDataProvider.Instance.Update(hangHoaChiTietInfo); } else { TonDauKyDataProvider.Instance.Insert(hangHoaChiTietInfo); } } } }// end for each row in the grid TonDauKyDataProvider.Instance.Update(DateTime.Now, Convert.ToInt32(cboKho.SelectedValue)); ConnectionUtil.Instance.CommitTransaction(); MessageBox.Show("Cập nhật thành công"); } catch (Exception exception) { ConnectionUtil.Instance.RollbackTransaction(); #if DEBUG MessageBox.Show(exception.ToString()); #else MessageBox.Show(exception.Message); #endif } }