private List<VChiTietDatHang_DTO> ConvertToList(DataTable dt) { List<VChiTietDatHang_DTO> ls = new List<VChiTietDatHang_DTO>(); foreach (DataRow row in dt.Rows) { VChiTietDatHang_DTO ct = new VChiTietDatHang_DTO(); ct.MaHoaDon = (int)row.ItemArray[0]; ct.MaNL = (int)row.ItemArray[1]; ct.SoLuong = (int)row.ItemArray[2]; ct.ThanhTien = (Double)row.ItemArray[3]; ct.TenNL = row.ItemArray[4].ToString(); ct.DonVi= row.ItemArray[5].ToString(); ls.Add(ct); } return ls; }
public int InsertChiTietDatHang(int mode, VChiTietDatHang_DTO ctdh) { String store = "SPoV_InsertChiTietDatHang"; CreateCommand_StoreName(store); cm.Parameters.Add("@MaHoaDon", SqlDbType.Int); cm.Parameters.Add("@MaNL", SqlDbType.Int); cm.Parameters.Add("@SoLuong", SqlDbType.Int); cm.Parameters.Add("@ThanhTien", SqlDbType.Float); cm.Parameters["@MaHoaDon"].Value = ctdh.MaHoaDon; cm.Parameters["@MaNL"].Value = ctdh.MaNL; cm.Parameters["@SoLuong"].Value = ctdh.SoLuong; cm.Parameters["@ThanhTien"].Value = ctdh.ThanhTien; return ExecuteInsertUpdateDelete(); }
public int InsertChiTietDatHang(int mode, VChiTietDatHang_DTO ctdh) { return ((VChiTietDatHang_DAO)daoChiTietDatHang).InsertChiTietDatHang(mode, ctdh); }