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); }
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); } }
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 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 DeleteChiTietTaiSan(ChiTietTaiSan input) { string sql = "DELETE FROM [VNAAccounting].[dbo].[ChiTietTaiSan] WHERE MaTaiSan = N'" + input.MaTaiSan.ToUpper() + "'"; return(DAL.CSDL.ThemSuaXoa(sql)); }
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 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)); }