/// <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));
}
