public JsonResult GetIsHaveBatch(string batchCode) { InStorDetailEntity detail = new InStorDetailEntity(); detail.Where(a => a.BatchNum == batchCode); var con = new DataFactory().InStorDetail; int icount = con.GetCount(detail); var re = new { num = icount }; return(Json(re)); }
/// <summary> /// 编辑入库单详细数量 /// </summary> /// <param name="snNum"></param> /// <param name="num"></param> /// <returns></returns> public int EditInOrderNum(string snNum, double num) { InStorDetailEntity detail = new InStorDetailEntity(); detail = new InStorDetailEntity(); detail.Include(a => new { a.OrderNum, a.Num, a.InPrice }); detail.Where(a => a.SnNum == snNum); detail = this.InStorDetail.GetSingle(detail); int line = 0; if (detail != null) { InStorDetailEntity editEntity = new InStorDetailEntity(); editEntity.IncludeNum(true).IncludeAmount(true); editEntity.Num = num; editEntity.Amount = num * detail.InPrice; editEntity.Where(a => a.SnNum == snNum); line = this.InStorDetail.Update(editEntity); string orderNum = detail.OrderNum; detail = new InStorDetailEntity(); detail.IncludeNum(true).IncludeAmount(true); detail.Where(a => a.OrderNum == orderNum); List <InStorDetailEntity> list = this.InStorDetail.GetList(detail); double total = list.Sum(a => a.Num); double amount = list.Sum(a => a.Amount); InStorageEntity entity = new InStorageEntity(); entity.Num = total; entity.Amount = amount; entity.IncludeNum(true).IncludeAmount(true); entity.Where(a => a.OrderNum == orderNum); line += this.InStorage.Update(entity); } return(line); }