public void AddImportMaterial(Models.NhapNguyenLieu a) { Database db = new Database(); DataTable dtcn = db.Query("select MaChiNhanh from ChiNhanh where TenchiNhanh = N'" + a.ChiNhanh + "';"); DataTable dtnl = db.Query("select MaNguyenLieu from NguyenLieu where TenNguyenLieu = N'" + a.NguyenLieu + "';"); DataTable dtdv = db.Query("select MaDV from DonVi where TenDV = N'" + a.DonVi + "';"); db.Insert("insert into NhapNguyenLieu(MaChiNhanh, MaNguyenLieu, NgayNhap, MaDV, SoLuong, DonGia, ThanhTien) values (" + dtcn.Rows[0]["MaChiNhanh"].ToString() + "," + dtnl.Rows[0]["MaNguyenLieu"].ToString() + ",'" + a.NgayNhap + "'," + dtdv.Rows[0]["MaDV"].ToString() + "," + a.SoLuong + "," + a.DonGia + ", " + a.ThanhTien + " );"); }
public JsonResult ImportMaterialList() { List <Models.NhapNguyenLieu> ImportMaterialList = new List <Models.NhapNguyenLieu>(); Database db = new Database(); DataTable dt = db.Query("select * from NhapNguyenLieu as nnl, NguyenLieu as nl, DonVi as dv, ChiNhanh as cn where nnl.MaChiNhanh = cn.MaChiNhanh and nnl.MaDV = dv.MaDV and nnl.MaNguyenLieu = nl.MaNguyenLieu;"); for (int i = 0; i < dt.Rows.Count; i++) { Models.NhapNguyenLieu ImportMaterial = new Models.NhapNguyenLieu(); ImportMaterial.MaNhap = dt.Rows[i]["MaNhap"].ToString(); ImportMaterial.ChiNhanh = dt.Rows[i]["TenchiNhanh"].ToString(); ImportMaterial.NguyenLieu = dt.Rows[i]["TenNguyenLieu"].ToString(); ImportMaterial.NgayNhap = dt.Rows[i]["NgayNhap"].ToString(); ImportMaterial.DonVi = dt.Rows[i]["TenDV"].ToString(); ImportMaterial.DonGia = dt.Rows[i]["DonGia"].ToString(); ImportMaterial.SoLuong = dt.Rows[i]["SoLuong"].ToString(); ImportMaterial.ThanhTien = dt.Rows[i]["ThanhTien"].ToString(); ImportMaterialList.Add(ImportMaterial); } return(Json(ImportMaterialList)); }