public static int EditTaiSan(TaiSan input)
{
string sql = "UPDATE [VNAAccounting].[dbo].[TaiSan] SET ";
sql += "TenTaiSan = N'" + input.TenTaiSan + "',MaLoaiTaiSan = N'" + input.MaLoaiTaiSan.ToUpper() + "',MaLyDoTangGiamTaiSan = N'" + input.MaLyDoTangGiamTaiSan.ToUpper() + "',NgayTangTaiSan = '" + input.NgayTangTaiSan.ToString("MM/dd/yyyy") + "',NgayTinhKhauHao = '" + input.NgayTinhKhauHao.ToString("MM/dd/yyyy") + "',";
sql += "SoKyKhauHao = N'" + input.SoKyKhauHao + "',MaBoPhanHachToan = N'" + input.MaBoPhanHachToan.ToUpper() + "',MaPhanXuong = N'" + input.MaPhanXuong.ToUpper() + "',MaPhi = N'" + input.MaPhi.ToUpper() + "',MaBoPhanSuDung = N'" + input.MaBoPhanSuDung.ToUpper() + "',";
sql += "TKTaiSan = N'" + input.TKTaiSan.ToUpper() + "',TKKhauHao = N'" + input.TKKhauHao.ToUpper() + "',TKChiPhi = N'" + input.TKChiPhi.ToUpper() + "',PhanNhom1 = N'" + input.PhanNhom1 + "',PhanNhom2 = N'" + input.PhanNhom2 + "',";
sql += "PhanNhom3 = N'" + input.PhanNhom3 + "',TenKhac = N'" + input.TenKhac + "',SoHieuTaiSan = N'" + input.SoHieuTaiSan.ToUpper() + "',ThongSoKyThuat = N'" + input.ThongSoKyThuat + "',NuocSanXuat = N'" + input.NuocSanXuat + "',";
sql += "NamSanXuat = N'" + input.NamSanXuat + "',NgayDuaVaoSuDung = '" + input.NgayDuaVaoSuDung.ToString("MM/dd/yyyy") + "',NgayDinhChiSuDung = '" + input.NgayDinhChiSuDung.ToString("MM/dd/yyyy") + "',LyDoDinhChi = N'" + input.LyDoDinhChi + "',GhiChu = N'" + input.GhiChu + "'";
sql += " WHERE MaTaiSan = N'" + input.MaTaiSan.ToUpper() + "'";
int kq = DAL.CSDL.ThemSuaXoa(sql);
if (kq > 0)
{
//Delete chi tiết tài sản
ChiTietTaiSan xoactts = new ChiTietTaiSan(); xoactts.MaTaiSan = input.MaTaiSan;
ChiTietTaiSanBiz.DeleteChiTietTaiSan(xoactts);
//Delete phụ tùng kèm theo
PhuTungKemTheo xoaptkt = new PhuTungKemTheo(); xoaptkt.MaTaiSan = input.MaTaiSan;
PhuTungKemTheoBiz.DeletePhuTungKemTheo(xoaptkt);
//Insert chi tiết tài sản
foreach (ChiTietTaiSan item in input.Lchitiettaisan)
{
ChiTietTaiSanBiz.AddChiTietTaiSan(item);
}
//Insert phụ tùng kèm theo
foreach (PhuTungKemTheo item in input.Lphutungkemtheo)
{
PhuTungKemTheoBiz.AddPhuTungKemTheo(item);
}
}
return kq;
}
public static int DeleteTaiSan(TaiSan input)
{
string sql = "DELETE FROM [VNAAccounting].[dbo].[TaiSan] WHERE MaTaiSan = N'" + input.MaTaiSan.ToUpper() + "'";
//Delete chi tiết tài sản
ChiTietTaiSan xoactts = new ChiTietTaiSan(); xoactts.MaTaiSan = input.MaTaiSan;
ChiTietTaiSanBiz.DeleteChiTietTaiSan(xoactts);
//Delete phụ tùng kèm theo
PhuTungKemTheo xoaptkt = new PhuTungKemTheo(); xoaptkt.MaTaiSan = input.MaTaiSan;
PhuTungKemTheoBiz.DeletePhuTungKemTheo(xoaptkt);
return DAL.CSDL.ThemSuaXoa(sql);
}
public ChiTietTaiSan Copy()
{
ChiTietTaiSan kq = new ChiTietTaiSan();
kq.MaTaiSan = maTaiSan;
kq.MaNguonVon = maNguonVon;
kq.NgayChungTu = ngayChungTu;
kq.SoChungTu = soChungTu;
kq.NguyenGia = nguyenGia;
kq.GiaTriDaKhauHao = giaTriDaKhauHao;
kq.GiaTriConLai = giaTriConLai;
kq.GiaTriKhauHao1Ky = giaTriKhauHao1Ky;
kq.DienGiai = dienGiai;
return(kq);
}
public static List<ChiTietTaiSan> getListChiTietTaiSan(string MaTaiSan)
{
List<ChiTietTaiSan> kq = new List<ChiTietTaiSan>();
string sql = "SELECT [MaTaiSan],[MaNguonVon],[NgayChungTu],[SoChungTu],[NguyenGia],[GiaTriDaKhauHao],[GiaTriConLai],[GiaTriKhauHao1Ky],[DienGiai] FROM [VNAAccounting].[dbo].[ChiTietTaiSan] WHERE MaTaiSan=N'" + MaTaiSan.ToUpper() + "'";
System.Data.DataTable dt = DAL.CSDL.hienthi(sql);
for (int i = 0; i < dt.Rows.Count; i++)
{
ChiTietTaiSan temp = new ChiTietTaiSan();
temp.MaTaiSan = dt.Rows[i]["MaTaiSan"].ToString();
temp.MaNguonVon = dt.Rows[i]["MaNguonVon"].ToString();
temp.NgayChungTu = DateTime.Parse(dt.Rows[i]["NgayChungTu"].ToString());
temp.SoChungTu = dt.Rows[i]["SoChungTu"].ToString();
temp.NguyenGia = double.Parse(dt.Rows[i]["NguyenGia"].ToString());
temp.GiaTriDaKhauHao = double.Parse(dt.Rows[i]["GiaTriDaKhauHao"].ToString());
temp.GiaTriConLai = double.Parse(dt.Rows[i]["GiaTriConLai"].ToString());
temp.GiaTriKhauHao1Ky = double.Parse(dt.Rows[i]["GiaTriKhauHao1Ky"].ToString());
temp.DienGiai = dt.Rows[i]["DienGiai"].ToString();
kq.Add(temp);
}
return kq;
}
public static int EditChiTietTaiSan(ChiTietTaiSan input)
{
string sql = "UPDATE [VNAAccounting].[dbo].[ChiTietTaiSan] SET MaNguonVon = N'" + input.MaNguonVon.ToUpper() + "',NgayChungTu = " + input.NgayChungTu.ToString("MM/dd/yyyy") + ",SoChungTu = N'" + input.SoChungTu + "',NguyenGia = " + input.NguyenGia + ",GiaTriDaKhauHao = " + input.GiaTriDaKhauHao + ",GiaTriConLai = " + input.GiaTriConLai + ",GiaTriKhauHao1Ky = " + input.GiaTriKhauHao1Ky + ",DienGiai = N'" + input.DienGiai + "' WHERE MaTaiSan = N'" + input.MaTaiSan.ToUpper() + "'";
return DAL.CSDL.ThemSuaXoa(sql);
}
public static int DeleteChiTietTaiSan(ChiTietTaiSan input)
{
string sql = "DELETE FROM [VNAAccounting].[dbo].[ChiTietTaiSan] WHERE MaTaiSan = N'" + input.MaTaiSan.ToUpper() + "'";
return DAL.CSDL.ThemSuaXoa(sql);
}
public static int AddChiTietTaiSan(ChiTietTaiSan input)
{
string sql = "INSERT INTO [VNAAccounting].[dbo].[ChiTietTaiSan]([MaTaiSan],[MaNguonVon],[NgayChungTu],[SoChungTu],[NguyenGia],[GiaTriDaKhauHao],[GiaTriConLai],[GiaTriKhauHao1Ky],[DienGiai]) VALUES(N'" + input.MaTaiSan.ToUpper() + "',N'" + input.MaNguonVon.ToUpper() + "'," + input.NgayChungTu.ToString("MM/dd/yyyy") + ",N'" + input.SoChungTu + "'," + input.NguyenGia + "," + input.GiaTriDaKhauHao + "," + input.GiaTriConLai + "," + input.GiaTriKhauHao1Ky + ",N'" + input.DienGiai + "')";
return DAL.CSDL.ThemSuaXoa(sql);
}
public ChiTietTaiSan Copy()
{
ChiTietTaiSan kq = new ChiTietTaiSan();
kq.MaTaiSan = maTaiSan;
kq.MaNguonVon = maNguonVon;
kq.NgayChungTu = ngayChungTu;
kq.SoChungTu = soChungTu;
kq.NguyenGia = nguyenGia;
kq.GiaTriDaKhauHao = giaTriDaKhauHao;
kq.GiaTriConLai = giaTriConLai;
kq.GiaTriKhauHao1Ky = giaTriKhauHao1Ky;
kq.DienGiai = dienGiai;
return kq;
}
private void btnNguonVonOK_Click(object sender, EventArgs e)
{
try
{
ChiTietTaiSan temp = new ChiTietTaiSan();
temp.MaTaiSan = txtMaTaiSan.Text.ToUpper();
temp.MaNguonVon = txtNguonVon.Text.ToUpper();
temp.NgayChungTu = DateTime.Parse(txtNgayChungTu.Text);
temp.SoChungTu = txtSoChungTu.Text;
temp.NguyenGia = double.Parse(txtNguyenGia.Text);
temp.GiaTriDaKhauHao = double.Parse(txtGiaTriDaKhauHao.Text);
temp.GiaTriConLai = double.Parse(txtGiaTriConLai.Text);
temp.GiaTriKhauHao1Ky = double.Parse(txtGiaTriKhauHao1Ky.Text);
temp.DienGiai = txtDienGiai.Text;
//Check lỗi nguồn vốn
LChiTietTaiSan.Add(temp);
DataGridViewCTNguonVon.DataSource = LChiTietTaiSan.ToArray();
FixDataGirdView(DataGridViewCTNguonVon, false);
ResetNguonVon();
if (isEditChiTietTaiSan) isEditChiTietTaiSan = false;
}
catch (Exception ex)
{
MSG.Error(ex);
}
}
