| | |
| | | using System.Security.Policy; |
| | | using System.Text; |
| | | using System.Threading.Tasks; |
| | | using WIDESEA_Common; |
| | | using WIDESEA_Core; |
| | | using WIDESEA_Core.BaseRepository; |
| | | using WIDESEA_Core.BaseServices; |
| | |
| | | var url = "http://121.37.118.63:80/GYZ2/95fck/goodsInfo"; |
| | | |
| | | |
| | | if (string.IsNullOrEmpty(SearchDate)) SearchDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | //if (string.IsNullOrEmpty(SearchDate)) SearchDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"); |
| | | //请æ±åæ° |
| | | var requestData = new |
| | | { |
| | | searchDate = "2009-1-10 20:45:16" // æ£ç¡®çæ ¼å¼ |
| | | searchDate = "2009-01-10 20:45:16" // æ£ç¡®çæ ¼å¼ |
| | | }; |
| | | //if (string.IsNullOrEmpty(SearchDate)) |
| | | //{ |
| | | // // é»è®¤æ¥è¯¢è¿å»24å°æ¶çæ°æ® |
| | | // SearchDate = DateTime.Now.AddDays(-1).ToString("yyyy-MM-dd HH:mm:ss"); |
| | | //} |
| | | //// 请æ±åæ° |
| | | // 请æ±åæ° |
| | | //var requestData = new |
| | | //{ |
| | | // searchDate = SearchDate |
| | |
| | | var entityList = response.data.Where(Medicat => !existingGoodsNos.Contains(Medicat.goods_no)).Select(Medicat => new Dt_MaterielInfo |
| | | { |
| | | MaterielCode = Medicat.goods_no, |
| | | MaterielErpType = Medicat.materialCode, |
| | | MaterielErpType = Medicat.goods_type, |
| | | item = Medicat.goods_tym, //éç¨å |
| | | MaterielName = Medicat.goods_spm,//ç©æåç§° |
| | | MaterielSpec = Medicat.model, |
| | |
| | | { |
| | | //å
æ¾å°æææªä¸åçè¯å |
| | | //var list = BaseDal.QueryData(x => x.GoodStatus == "æªä¸å").ToList(); |
| | | var list =BaseDal.Db.Queryable<Dt_MaterielInfo>().Where(x => x.GoodStatusState == "æªä¸å").ToList(); |
| | | //æå°ä»¶æªä¸åççä¿¡æ¯ |
| | | var list =BaseDal.Db.Queryable<Dt_MaterielInfo>().Where(x => x.GoodStatusState == "æªä¸å"&& x.MaterielSourceType== MaterielSourceTypeEnum.SelfMadePart).ToList(); |
| | | if (list == null || !list.Any()) |
| | | { |
| | | return new WebResponseContent().OK("æ æªä¸åè¯å"); |
| | |
| | | //åä½ |
| | | unit = item.MaterielUnit, |
| | | //é¿ |
| | | singleProductLongNum = item.MaterielLength.ToString(), |
| | | singleProductLongNum = (item.MaterielLength ?? 0).ToString(), |
| | | //宽 |
| | | singleProductWideNum = item.MaterielWide.ToString(), |
| | | singleProductWideNum = (item.MaterielWide ?? 0).ToString(), |
| | | //é« |
| | | singleProductHighNum = item.MaterielHeight.ToString(), |
| | | singleProductHighNum = (item.MaterielHeight ?? 0).ToString(), |
| | | //éé |
| | | singleProductWeight = item.MaterielWeight.ToString(), |
| | | singleProductWeight = (item.MaterielWeight ?? 0).ToString(), |
| | | //ä½ç§¯ |
| | | singleProductVolume = item.MaterielVolume.ToString(), |
| | | singleProductVolume = (item.MaterielVolume ?? 0).ToString(), |
| | | //æ¯å¦åæ¶ 0æ¯ä¸å é¤ï¼1å é¤ |
| | | isDelete = "0" |
| | | }; |
| | |
| | | //æ´æ°è¯åç¶æ-已宿 |
| | | BaseDal.Db.Updateable<Dt_MaterielInfo>() |
| | | .SetColumns(x => x.GoodStatusState == "ä¸å宿") |
| | | .Where(x => x.GoodStatusState == item.MaterielCode) |
| | | .Where(x => x.MaterielCode == item.MaterielCode) |
| | | .ExecuteCommand(); |
| | | } |
| | | else |