public async Task <object> InsertPos_MasterInfo(POS_Master entity) { ResultModel result = new ResultModel(); result.IsSuccess = false; try { string userid = HttpContext.User.Claims.Where(item => item.Type == System.Security.Claims.ClaimTypes.NameIdentifier).FirstOrDefault().Value; Users _users = await userRepository.GetUserAndRoles(int.Parse(userid)); entity.Modified_User = _users.name; entity.Created_Date = DateTime.Now; #region 生成Dummy Code 即POS_CODE //Dummy Code的生成规则:Dummy Year(2 digit sequential number)&Quarter+"-"+Customer Short Name+Branch+"-"+Channel short Name+2 digit sequential number string paraname = entity.TM_YEAR.Substring(2, 2) + entity.TM_SEASON + "-" + entity.CUSTOMER_GROUP + entity.BRANCH_EN + "-" + entity.POS_CHANNEL.Substring(0, 1); var maxindex = Repository.GetMaxPOSCode(paraname); if (!string.IsNullOrEmpty(maxindex.ToString())) { int index = int.Parse(maxindex.ToString()); if (index > 0) { index++; entity.POS_CODE = paraname + (index < 10 ? "0" + index : index + ""); } else { entity.POS_CODE = paraname + "01"; } } else { entity.POS_CODE = paraname + "01"; } #endregion #region 验证 ship to Code if (!string.IsNullOrEmpty(entity.STC_CORE)) { entity.STC_CORE = entity.STC_CORE.ToUpper(); if (entity.STC_CORE != "TBD") { string Productchannel = Repository.GetProductchannel(entity.STC_CORE); entity.Product_Channel = Productchannel; if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToString().ToLower() != "core") { result.Message = "Ship to Code(Core) is Error!"; return(Ok(result)); } int reuslt = Repository.ExistshipCode(entity.STC_CORE, 1); if (reuslt > 0) { //ship to code 是否正确 result.Message = "Ship to Code(Core) is exist!"; return(Ok(result)); } } } if (!string.IsNullOrEmpty(entity.STC_OCS)) { entity.STC_OCS = entity.STC_OCS.ToUpper(); if (entity.STC_OCS != "TBD") { string Productchannel = Repository.GetProductchannel(entity.STC_OCS); entity.Product_Channel = Productchannel; if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "originals") { result.Message = "Ship to Code(Originals) is Error!"; return(Ok(result)); } int reuslt = Repository.ExistshipCode(entity.STC_OCS, 2); if (reuslt > 0) { //ship to code 是否正确 result.Message = "Ship to Code(Originals) is exist!"; return(Ok(result)); } } } if (!string.IsNullOrEmpty(entity.STC_NEO)) { entity.STC_NEO = entity.STC_NEO.ToUpper(); if (entity.STC_NEO != "TBD") { string Productchannel = Repository.GetProductchannel(entity.STC_NEO); entity.Product_Channel = Productchannel; if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "neo") { result.Message = "Ship to Code(Neo) is Error!"; return(Ok(result)); } int reuslt = Repository.ExistshipCode(entity.STC_NEO, 3); if (reuslt > 0) { //ship to code 是否正确 result.Message = "Ship to Code(Neo) is exist!"; return(Ok(result)); } } } if (!string.IsNullOrEmpty(entity.STC_KIDS)) { entity.STC_KIDS = entity.STC_KIDS.ToUpper(); if (entity.STC_KIDS != "TBD") { string Productchannel = Repository.GetProductchannel(entity.STC_KIDS); entity.Product_Channel = Productchannel; if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "kids") { result.Message = "Ship to Code(Kids) is Error!"; return(Ok(result)); } int reuslt = Repository.ExistshipCode(entity.STC_KIDS, 4); if (reuslt > 0) { //ship to code 是否正确 result.Message = "Ship to Code(Kids) is exist!"; return(Ok(result)); } } } #endregion #region CURRENT_STATUS和 CURRENT_COMPSTATUS if (entity.TM_SEASON == "Q1") { entity.CURRENT_STATUS = entity.BLRQ1; entity.CURRENT_COMPSTATUS = entity.COMPQ1; } else if (entity.TM_SEASON == "Q2") { entity.CURRENT_STATUS = entity.BLRQ2; entity.CURRENT_COMPSTATUS = entity.COMPQ2; } else if (entity.TM_SEASON == "Q3") { entity.CURRENT_STATUS = entity.BLRQ3; entity.CURRENT_COMPSTATUS = entity.COMPQ3; } else if (entity.TM_SEASON == "Q4") { entity.CURRENT_STATUS = entity.BLRQ4; entity.CURRENT_COMPSTATUS = entity.COMPQ4; } #endregion await Repository.PostEntity(entity); result.Message = "ok"; result.IsSuccess = true; } catch (Exception ex) { result.Message = "" + ex.Message; } return(Ok(result)); }
public OkObjectResult EditMD_BulkShipTo(MD_BulkShipTo entity) { ResultModel result = new ResultModel(); try { result.IsSuccess = false; int Total = 0; //获取customerInfo #region 验证 ship to Code 的输入是否正确 if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Core)) { entity.Bulk_Ship_to_Code_Core = entity.Bulk_Ship_to_Code_Core.ToUpper(); if (entity.Bulk_Ship_to_Code_Core != "TBD") { string[] codelist = entity.Bulk_Ship_to_Code_Core.Split('/'); foreach (string Code in codelist) { string Productchannel = PosRepository.GetProductchannel(Code); if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToString().ToLower() != "core") { result.Message = "Bulk Ship to Code(Core) is Error!"; return(Ok(result)); } } } } if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Originals)) { entity.Bulk_Ship_to_Code_Originals = entity.Bulk_Ship_to_Code_Originals.ToUpper(); if (entity.Bulk_Ship_to_Code_Originals != "TBD") { string[] codelist = entity.Bulk_Ship_to_Code_Originals.Split('/'); foreach (string Code in codelist) { string Productchannel = PosRepository.GetProductchannel(Code); if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "originals") { result.Message = "Bulk Ship to Code(Originals) is Error!"; return(Ok(result)); } } } } if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Neo)) { entity.Bulk_Ship_to_Code_Neo = entity.Bulk_Ship_to_Code_Neo.ToUpper(); if (entity.Bulk_Ship_to_Code_Neo != "TBD") { string[] codelist = entity.Bulk_Ship_to_Code_Neo.Split('/'); foreach (string Code in codelist) { string Productchannel = PosRepository.GetProductchannel(Code); if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "neo") { result.Message = "Bulk Ship to Code(Neo) is Error!"; return(Ok(result)); } } } } if (!string.IsNullOrEmpty(entity.Bulk_Ship_to_Code_Kids)) { entity.Bulk_Ship_to_Code_Kids = entity.Bulk_Ship_to_Code_Kids.ToUpper(); if (entity.Bulk_Ship_to_Code_Kids != "TBD") { string[] codelist = entity.Bulk_Ship_to_Code_Kids.Split('/'); foreach (string Code in codelist) { string Productchannel = PosRepository.GetProductchannel(Code); if (string.IsNullOrEmpty(Productchannel) || Productchannel.ToLower() != "kids") { result.Message = "Bulk Ship to Code(Kids) is Error!"; return(Ok(result)); } } } } #endregion //string sqlstr = "select count(ID) from SIDE_MD_BulkShipTo where BRANCH_CN=@BRANCH_CN and BRANCH_EN=@BRANCH_EN and WHS_Channel=@WHS_Channel "; //if (entity.ID > 0) //{ // sqlstr = sqlstr + " and ID<>@ID "; //} //DynamicParameters parameters = new DynamicParameters(); //parameters.Add("@ID", entity.ID, DbType.Int32, ParameterDirection.Input); //parameters.Add("@BRANCH_CN", entity.BRANCH_CN, DbType.String, ParameterDirection.Input); //parameters.Add("@BRANCH_EN", entity.BRANCH_EN, DbType.String, ParameterDirection.Input); //parameters.Add("@WHS_Channel", entity.WHS_Channel, DbType.String, ParameterDirection.Input); //using (IDbConnection conn = DataBaseConfig.GetSqlConnection()) //{ // Total = (Int32)conn.ExecuteScalar(sqlstr, parameters); //} if (Total > 0) { result.IsSuccess = false; result.Message = "Already exist"; result.StatusCode = "-4"; } else { if (entity.ID == 0) { int row = masterdataRepository.AddMD_BulkShipTo(entity); result.StatusCode = row.ToString(); result.Message = "OK"; result.IsSuccess = true; } else { int row = masterdataRepository.UpdateMD_BulkShipTo(entity); result.StatusCode = row.ToString(); result.Message = "OK"; result.IsSuccess = true; } } } catch (Exception ex) { result.Message = ex.Message; result.IsSuccess = false; } return(Ok(result)); }