public int Insert(TonDauKyInfo tonDauKyInfo)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spTonDauKyInsert, tonDauKyInfo.IdDuDauKy,
tonDauKyInfo.ThoiGian, tonDauKyInfo.IdKho, tonDauKyInfo.IdSanPham, tonDauKyInfo.SoLuong,
tonDauKyInfo.DonGia, tonDauKyInfo.ThanhTien, tonDauKyInfo.NguoiTao);
return(Convert.ToInt32(Parameters["p_IdDuDauKy"].Value.ToString()));
}
public void Update(TonDauKyInfo tonDauKyInfo)
{
ExecuteCommand(Declare.StoreProcedureNamespace.spTonDauKyUpdate, tonDauKyInfo.IdDuDauKy,
tonDauKyInfo.ThoiGian, tonDauKyInfo.IdKho, tonDauKyInfo.IdSanPham, tonDauKyInfo.SoLuong,
tonDauKyInfo.DonGia, tonDauKyInfo.ThanhTien);
}
public void Update(TonDauKyInfo tonDauKyInfo)
{
TonDauKyDAO.Instance.Update(tonDauKyInfo);
}
public int Insert(TonDauKyInfo tonDauKyInfo)
{
return(TonDauKyDAO.Instance.Insert(tonDauKyInfo));
}
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
}
}
