//删除数据 protected void notarizeDelete(object sender, EventArgs e) { int loginid = getLoginUserID(); if (loginid == -1) { return; } int vendor_id = -1; try { vendor_id = int.Parse(vendor_id_delete.Value.ToString()); } catch (Exception ex) { PageUtil.showToast(this, "数据异常,删除失败!"); return; } SupplierDC supplierDC = new SupplierDC(); if (supplierDC.deleteSupplier(vendor_id)) { PageUtil.showToast(this, "数据删除成功!"); string vendor_name1 = vendor_name_id.Value.Trim(); string vendor_key1 = vendor_key_id.Value.Trim(); Line_Repeater.DataSource = supplierDC.getSupplierBySome(vendor_name1, vendor_key1); Line_Repeater.DataBind(); } else { PageUtil.showToast(this, "数据删除失败!"); } }
//Where Used: SupplierProduct public List <Supplier> IsValidClientDetailSupplierProduct(int clientDetailId, int productId, string supplierCode) { SupplierDC db = new SupplierDC(Settings.getConnectionString()); var result = from n in db.Suppliers where ((n.ProductId == productId) && (n.SupplierCode.Equals(supplierCode))) select n; return(result.ToList()); }
//Where Used: Client-Side Validation of Supplier/Product combos public List <Supplier> IsValidSupplierName(string supplierName) { SupplierDC db = new SupplierDC(Settings.getConnectionString()); SupplierRepository supplierRepository = new SupplierRepository(); var result = from n in db.Suppliers where (n.SupplierName.Equals(supplierName)) select n; return(result.ToList()); }
public void ProcessRequest(HttpContext context) { SupplierDC supplierDC = new SupplierDC(); List <string> list = new List <string>(); list = supplierDC.getAllVendor_key(); string json = toJson(list); context.Response.ContentType = "text/plain"; context.Response.Write(json); }
//查询 protected void selectSome(object sender, EventArgs e) { string vendor_name = vendor_name_id.Value.Trim(); string vendor_key = vendor_key_id.Value.Trim(); SupplierDC supplierDC = new SupplierDC(); DataSet ds = supplierDC.getSupplierBySome(vendor_name, vendor_key); if (ds == null) { PageUtil.showToast(this, "未查询到数据!"); return; } Line_Repeater.DataSource = ds; Line_Repeater.DataBind(); }
//Eager Loading: return a singleton value public JsonResult EagerLoadingSingletonValue() { var context = new OrdersContext(); var supplier = context.Suppliers.Include(s => s.Products).First(); //check SQL Profiler here var supplierDC = new SupplierDC { SupplierId = supplier.SupplierId, CompanyName = supplier.CompanyName, Products = supplier.Products.Select(p => new ProductDC { ProductId = p.ProductId, ProductName = p.ProductName }) }; //check SQL Profiler here return(Json(supplierDC, JsonRequestBehavior.AllowGet)); }
//Find() method Versus FirstOrDefault() method public JsonResult FindVersusFirstOrDefault() { var context = new OrdersContext(); //Using Find() var supplierX1 = context.Suppliers.Find(1); // it will be cached var supplierX2 = context.Suppliers.Find(1); var supplierXDC = new SupplierDC { SupplierId = supplierX2.SupplierId, CompanyName = supplierX2.CompanyName, Products = supplierX2.Products.Select(p => new ProductDC { ProductId = p.ProductId, ProductName = p.ProductName }) }; //Using FirstOrDefault() var supplierY = context.Suppliers.Include(x => x.Products).FirstOrDefault(x => x.SupplierId == 1); var supplierYDC = new SupplierDC { SupplierId = supplierY.SupplierId, CompanyName = supplierY.CompanyName, Products = supplierX2.Products.Select(p => new ProductDC { ProductId = p.ProductId, ProductName = p.ProductName }) }; return(Json(new { supplierXDC, supplierYDC }, JsonRequestBehavior.AllowGet)); }
//更新数据 protected void notarizeUpdate(object sender, EventArgs e) { int loginid = getLoginUserID(); if (loginid == -1) { return; } string vendor_id = vendor_id_update.Value.Trim(); string vendor_name = vendor_name_update.Value.Trim(); string vendor_key = vendor_key_update.Value.Trim(); if (!checkData(vendor_name, vendor_key)) { return; } SupplierDC supplierDC = new SupplierDC(); DataSet search_ds = supplierDC.getSupplierByNameAndKeyAndId(vendor_id, vendor_name, vendor_key); //如过大于2,则数据库中已存在该name和key,否则 就可以更新 if (search_ds != null && search_ds.Tables[0].Rows.Count > 0) { PageUtil.showToast(this, "供应商名称或者供应商代码已存在!"); return; } if (supplierDC.updateSupplier(vendor_id, vendor_name, loginid, vendor_key, DateTime.Now)) { PageUtil.showToast(this, "数据更新成功!"); string vendor_name1 = vendor_name_id.Value.Trim(); string vendor_key1 = vendor_key_id.Value.Trim(); Line_Repeater.DataSource = supplierDC.getSupplierBySome(vendor_name1, vendor_key1); Line_Repeater.DataBind(); } else { PageUtil.showToast(this, "数据更新失败!"); } }
//Lazy Loading: return a singleton value public JsonResult LazyLoadingSingletonValue() { var context = new OrdersContext(); //Queries that return a singleton value are executed immediately //e.g: Average, Count, First, Single, and Max var supplier = context.Suppliers.First(); //check SQL Profiler here var supplierDC = new SupplierDC { SupplierId = supplier.SupplierId, CompanyName = supplier.CompanyName, Products = supplier.Products.Select(p => new ProductDC { ProductId = p.ProductId, ProductName = p.ProductName }) }; //check SQL Profiler here return(Json(supplierDC, JsonRequestBehavior.AllowGet)); }
//插入数据 protected void notarizeInsert(object sender, EventArgs e) { int loginid = getLoginUserID(); if (loginid == -1) { return; } string vendor_name = vendor_name_insert.Value.Trim(); string vendor_key = vendor_key_insert.Value.Trim(); if (!checkData(vendor_name, vendor_key)) { return; } SupplierDC supplierDC = new SupplierDC(); DataSet search_ds = supplierDC.getSupplierByNameAndKey(vendor_name, vendor_key); if (search_ds != null && search_ds.Tables[0].Rows.Count > 0) { PageUtil.showToast(this, "供应商名称或者供应商代码已存在!"); return; } else if (supplierDC.insertSupplier(vendor_name, loginid, vendor_key, DateTime.Now)) { PageUtil.showToast(this, "数据插入成功!"); vendor_name_insert.Value = ""; vendor_key_insert.Value = ""; Line_Repeater.DataSource = supplierDC.getSupplierBySome("", ""); Line_Repeater.DataBind(); } else { PageUtil.showToast(this, "数据插入失败!"); } }