public OkObjectResult AddMD_POS_Type(MD_POS_Type entity) { ResultModel result = new ResultModel(); result.IsSuccess = true; int Total = 0;//这一步在优先次序上加一 //string sqlstr = "select count(ID) from SIDE_MD_POS_Type where POS_Channel=@POS_Channel and POS_Segment=@POS_Segment and Type_Sequence=@Type_Sequence "; //DynamicParameters parameters = new DynamicParameters(); //parameters.Add("@POS_Channel", entity.POS_Channel, DbType.String, ParameterDirection.Input); //parameters.Add("@POS_Segment", entity.POS_Segment, DbType.String, ParameterDirection.Input); //parameters.Add("@Type_Sequence", entity.Type_Sequence, DbType.Int32, ParameterDirection.Input); //entity.Type_Status = 1; //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 { int row = masterdataRepository.AddMD_POS_Type(entity); result.StatusCode = row.ToString(); result.Message = "OK"; } return(Ok(result)); }