public int InsertDetailTransWarehouse(DetailTransWarehouseDTO detailTrans) { string sql = string.Format("INSERT INTO [CT_CHUYENKHO](MAPHIEUCHUYEN, MAHANG, TENHANG, DONVI, DONGIA, SOLUONG, THANHTIEN) VALUES('{0}', '{1}', N'{2}', N'{3}', {4}, {5}, {6})", detailTrans.MaPhieuChuyen, detailTrans.MaHang, detailTrans.TenHang, detailTrans.DonVi, detailTrans.DonGia, detailTrans.SoLuong, detailTrans.ThanhTien); return(ConnectionDB.ExcuteNonQuery(sql)); }
public List <DetailTransWarehouseDTO> getListDetailTrans() { string sql = "SELECT * FROM CT_ChUYENKHO"; DataTable data = ConnectionDB.getData(sql); List <DetailTransWarehouseDTO> listDetailTrans = new List <DetailTransWarehouseDTO>(); if (data.Rows.Count > 0) { foreach (DataRow dataRow in data.Rows) { DetailTransWarehouseDTO detailTrans = new DetailTransWarehouseDTO(); detailTrans.MaPhieuChuyen = dataRow["MaPhieuChuyen"].ToString(); detailTrans.MaHang = dataRow["MaHang"].ToString(); detailTrans.TenHang = dataRow["TenHang"].ToString(); detailTrans.DonVi = dataRow["DonVi"].ToString(); detailTrans.DonGia = float.Parse(dataRow["DonGia"].ToString()); detailTrans.SoLuong = int.Parse(dataRow["SoLuong"].ToString()); detailTrans.ThanhTien = float.Parse(dataRow["ThanhTien"].ToString()); listDetailTrans.Add(detailTrans); } } return(listDetailTrans); }
public int InsertDetailTransWarehouse(DetailTransWarehouseDTO detailTrans) { return(ckDao.InsertDetailTransWarehouse(detailTrans)); }