public async Task<IHttpActionResult> PostSetCustomerAgent([FromBody]ParmSetCustomerAgent parm) { ResultInfo r = new ResultInfo(); try { #region working a db0 = getDB0(); var map = await db0.MapCustomerAgnet.FindAsync(parm.customer_id, parm.agent_id); if (map != null && parm.is_take == false) { db0.MapCustomerAgnet.Remove(map); } if (map == null && parm.is_take == true) { var add_map = new MapCustomerAgnet() { customer_id = parm.customer_id, agent_id = parm.agent_id, i_InsertUserID = this.UserId, i_InsertDateTime = DateTime.Now, i_InsertDeptID = this.departmentId, i_Lang = "zh-TW" }; db0.MapCustomerAgnet.Add(add_map); } await db0.SaveChangesAsync(); r.result = true; return Ok(r); #endregion } catch (Exception ex) { r.result = false; r.message = ex.Message; return Ok(r); } finally { db0.Dispose(); } }
public async Task<IHttpActionResult> PostSetStockSelectCustomer([FromBody]ParmPostSetStockSelectCustomer parm) { try { #region working a db0 = getDB0(); foreach (var p in parm.products) { foreach (var c in parm.customers) { var md = new StockDetailQty() { stock_detail_qty_id = GetNewId(), stock_detail_id = p.stock_detail_id, customer_id = c.customer_id, i_InsertUserID = this.UserId, i_InsertDateTime = DateTime.Now, i_InsertDeptID = this.departmentId, i_Lang = "zh-TW" }; db0.StockDetailQty.Add(md); } } #region 新增經銷商對應 foreach (var c in parm.customers) { var exist = db0.MapCustomerAgnet.Any(x => x.agent_id == parm.agent_id && x.customer_id == c.customer_id); if (!exist) { var item = new MapCustomerAgnet() { agent_id = parm.agent_id, customer_id = c.customer_id, i_InsertUserID = this.UserId, i_InsertDateTime = DateTime.Now, i_InsertDeptID = this.departmentId, i_Lang = "zh-TW" }; db0.MapCustomerAgnet.Add(item); } } #endregion await db0.SaveChangesAsync(); var getStockDeatil = db0.StockDetail.Where(x => x.stock_detail_id == parm.detail_id).First(); var items = await db0.StockDetailQty.Where(x => x.StockDetail.stock_id == parm.stock_id && x.StockDetail.item_no == getStockDeatil.item_no) .GroupBy(x => x.Customer) .Select(x => new { customers = new { x.Key.customer_id, x.Key.customer_name }, products = x.Select(y => new { y.stock_detail_qty_id, y.StockDetail.product_id, y.qty }) }) .ToListAsync(); return Ok(new { result = true, data = items }); #endregion } catch (Exception ex) { return Ok(new { result = false, data = ex.Message }); } finally { db0.Dispose(); } }
public async Task<IHttpActionResult> PostMapAgentCustomer([FromBody]ParmMapAgentCustomer parm) { ResultInfo r = new ResultInfo(); try { #region working a db0 = getDB0(); var item = db0.MapCustomerAgnet.Where(x => x.agent_id == parm.agent_id && x.customer_id == parm.customer_id).FirstOrDefault(); if (item == null) { item = new MapCustomerAgnet() { agent_id = parm.agent_id, customer_id = parm.customer_id, i_InsertUserID = this.UserId, i_InsertDateTime = DateTime.Now, i_InsertDeptID = this.departmentId, i_Lang = "zh-TW" }; db0.MapCustomerAgnet.Add(item); } await db0.SaveChangesAsync(); r.result = true; r.id = item.agent_id; return Ok(r); #endregion } catch (Exception ex) { r.result = false; r.message = ex.Message; return Ok(r); } finally { db0.Dispose(); } }