public int AddMD_BulkShipTo(MD_BulkShipTo model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SIDE_MD_BulkShipTo(BRANCH_EN,BRANCH_CN,BLR,Province,City,StoreFormat,WHS_Channel,Bulk_Ship_to_Code_Core,Bulk_Ship_to_Code_Originals,Bulk_Ship_to_Code_Neo,Bulk_Ship_to_Code_Kids )"); strSql.Append(" values (@BRANCH_EN,@BRANCH_CN,@BLR,@Province,@City,@StoreFormat,@WHS_Channel,@Bulk_Ship_to_Code_Core,@Bulk_Ship_to_Code_Originals,@Bulk_Ship_to_Code_Neo,@Bulk_Ship_to_Code_Kids )"); DynamicParameters parameters = new DynamicParameters(); parameters.Add("@BRANCH_EN", model.BRANCH_EN, DbType.String, ParameterDirection.Input); parameters.Add("@BRANCH_CN", model.BRANCH_CN, DbType.String, ParameterDirection.Input); parameters.Add("@WHS_Channel", model.WHS_Channel, DbType.String, ParameterDirection.Input); parameters.Add("@BLR", model.BLR, DbType.String, ParameterDirection.Input); parameters.Add("@City", model.City, DbType.String, ParameterDirection.Input); parameters.Add("@Province", model.Province, DbType.String, ParameterDirection.Input); parameters.Add("@StoreFormat", model.StoreFormat, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Core", model.Bulk_Ship_to_Code_Core, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Originals", model.Bulk_Ship_to_Code_Originals, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Neo", model.Bulk_Ship_to_Code_Neo, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Kids", model.Bulk_Ship_to_Code_Kids, DbType.String, ParameterDirection.Input); using (IDbConnection conn = DataBaseConfig.GetSqlConnection()) { return(conn.Execute(strSql.ToString(), parameters)); } }
public int UpdateMD_BulkShipTo(MD_BulkShipTo model) { string updateSql = @"update SIDE_MD_BulkShipTo set BRANCH_EN=@BRANCH_EN,City=@City, BRANCH_CN=@BRANCH_CN,BLR=@BLR,Province=@Province,StoreFormat=@StoreFormat, WHS_Channel=@WHS_Channel, Bulk_Ship_to_Code_Core=@Bulk_Ship_to_Code_Core, Bulk_Ship_to_Code_Originals=@Bulk_Ship_to_Code_Originals, Bulk_Ship_to_Code_Neo=@Bulk_Ship_to_Code_Neo, Bulk_Ship_to_Code_Kids=@Bulk_Ship_to_Code_Kids WHERE ID=@ID"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("@ID", model.ID, DbType.Int32, ParameterDirection.Input); parameters.Add("@BRANCH_EN", model.BRANCH_EN, DbType.String, ParameterDirection.Input); parameters.Add("@BRANCH_CN", model.BRANCH_CN, DbType.String, ParameterDirection.Input); parameters.Add("@WHS_Channel", model.WHS_Channel, DbType.String, ParameterDirection.Input); parameters.Add("@BLR", model.BLR, DbType.String, ParameterDirection.Input); parameters.Add("@City", model.City, DbType.String, ParameterDirection.Input); parameters.Add("@Province", model.Province, DbType.String, ParameterDirection.Input); parameters.Add("@StoreFormat", model.StoreFormat, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Core", model.Bulk_Ship_to_Code_Core, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Originals", model.Bulk_Ship_to_Code_Originals, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Neo", model.Bulk_Ship_to_Code_Neo, DbType.String, ParameterDirection.Input); parameters.Add("@Bulk_Ship_to_Code_Kids", model.Bulk_Ship_to_Code_Kids, DbType.String, ParameterDirection.Input); using (IDbConnection conn = DataBaseConfig.GetSqlConnection()) { return(conn.Execute(updateSql, parameters)); } }
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)); }