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));
}
