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