/// <summary> /// /// </summary> /// <returns></returns> public int AddMD_POS_Type(MD_POS_Type model) { StringBuilder strSql = new StringBuilder(); StringBuilder strSqlupdate = new StringBuilder(); // 修改有限顺序序号 strSqlupdate.Append(" if exists(select * from SIDE_MD_POS_Type where POS_Channel = @POS_Channel and POS_Segment = @POS_Segment and Type_Sequence = @Type_Sequence)"); strSqlupdate.Append(" begin"); strSqlupdate.Append(" update SIDE_MD_POS_Type set Type_Sequence = Type_Sequence + 1 where POS_Channel = @POS_Channel and POS_Segment = @POS_Segment and Type_Sequence>= @Type_Sequence"); strSqlupdate.Append(" end "); strSql.Append("insert into SIDE_MD_POS_Type( POS_Channel, POS_Segment, POS_Type, Type_Sequence, Type_Status )"); strSql.Append(" values ( @POS_Channel, @POS_Segment, @POS_Type, @Type_Sequence, @Type_Status )"); DynamicParameters parameters = new DynamicParameters(); parameters.Add("@POS_Channel", model.POS_Channel, DbType.String, ParameterDirection.Input); parameters.Add("@POS_Segment", model.POS_Segment, DbType.String, ParameterDirection.Input); parameters.Add("@POS_Type", model.POS_Type, DbType.String, ParameterDirection.Input); parameters.Add("@Type_Sequence", model.Type_Sequence, DbType.Int32, ParameterDirection.Input); parameters.Add("@Type_Status", 1, DbType.String, ParameterDirection.Input); using (IDbConnection conn = DataBaseConfig.GetSqlConnection()) { conn.Execute(strSqlupdate.ToString(), parameters); return(conn.Execute(strSql.ToString(), parameters)); } }
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)); }
/// <summary> /// /// </summary> /// <returns></returns> public int UpdateMD_POS_Type(MD_POS_Type model) { StringBuilder strSqlupdate = new StringBuilder(); // 修改有限顺序序号 strSqlupdate.Append(" if exists(select * from SIDE_MD_POS_Type where POS_Channel = @POS_Channel and POS_Segment = @POS_Segment and Type_Sequence = @Type_Sequence and ID<>@ID)"); strSqlupdate.Append(" begin"); strSqlupdate.Append(" update SIDE_MD_POS_Type set Type_Sequence = Type_Sequence + 1 where POS_Channel = @POS_Channel and POS_Segment = @POS_Segment and Type_Sequence>= @Type_Sequence"); strSqlupdate.Append(" end "); string updateSql = @"update SIDE_MD_POS_Type set POS_Channel=@POS_Channel, POS_Segment=@POS_Segment, POS_Type=@POS_Type, Type_Sequence=@Type_Sequence, Type_Status=@Type_Status FROM [dbo].SIDE_MD_POS_Type WHERE ID=@ID"; DynamicParameters parameters = new DynamicParameters(); parameters.Add("@ID", model.ID, DbType.Int32, ParameterDirection.Input); parameters.Add("@POS_Channel", model.POS_Channel, DbType.String, ParameterDirection.Input); parameters.Add("@POS_Segment", model.POS_Segment, DbType.String, ParameterDirection.Input); parameters.Add("@POS_Type", model.POS_Type, DbType.String, ParameterDirection.Input); parameters.Add("@Type_Sequence", model.Type_Sequence, DbType.Int32, ParameterDirection.Input); parameters.Add("@Type_Status", model.Type_Status, DbType.Int32, ParameterDirection.Input); using (IDbConnection conn = DataBaseConfig.GetSqlConnection()) { conn.Execute(strSqlupdate.ToString(), parameters); return(conn.Execute(updateSql, parameters)); } }
public async Task <object> GetPOSTypeByID(int Id) { MD_POS_Type model = await masterdataRepository.GetMD_POS_TypeModel(Id); return(Ok(model)); }