예제 #1
0
        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));
        }