public ActionResult AddModelFloorModel(NewAppData model)
{
int i = CategoryDicManager.GetMaxModelFloor(model);
i = i + 1;
model.modelfloor = i;
return(Json(CategoryDicManager.InsertNewAppData(model)));
}
public static int GetMaxModelFloor(SqlConnection conn, NewAppData model)
{
string sql = @" SELECT MAX(modelfloor) FROM [Gungnir].[dbo].[tal_newappsetdata] WITH(NOLOCK) WHERE apptype=@apptype";
var sqlprams = new SqlParameter[]
{
new SqlParameter("@apptype", model.apptype)
};
object obj = SqlHelper.ExecuteScalar(conn, CommandType.Text, sql, sqlprams);
return(Convert.ToInt32(obj));
}
public int GetMaxModelFloor(NewAppData model)
{
try
{
return(handler.GetMaxModelFloor(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new CategoryDicException(1, "GetMaxModelFloor", ex);
Logger.Log(Level.Error, "GetMaxModelFloor", exception);
throw;
}
}
public bool InsertNewAppData(NewAppData model)
{
try
{
return(handler.InsertNewAppData(model));
}
catch (TuhuBizException)
{
throw;
}
catch (Exception ex)
{
var exception = new CategoryDicException(1, "InsertNewAppData", ex);
Logger.Log(Level.Error, "InsertNewAppData", exception);
throw;
}
}
public static bool InsertNewAppData(SqlConnection conn, NewAppData model)
{
string sql = @" INSERT INTO Gungnir.dbo.tal_newappsetdata
( apptype ,
modelfloor
-- showorder ,
-- showstatic
)
VALUES ( @apptype ,
@modelfloor
-- @showorder ,
-- @showstatic
)";
var sqlprams = new SqlParameter[]
{
new SqlParameter("@apptype", model.apptype),
new SqlParameter("@modelfloor", model.modelfloor)
};
return(SqlHelper.ExecuteNonQuery(conn, CommandType.Text, sql, sqlprams) > 0);
}
public int GetMaxModelFloor(NewAppData model)
{
return(dbManager.Execute(conn => DALCategory.GetMaxModelFloor(conn, model)));
}
public bool InsertNewAppData(NewAppData model)
{
return(dbManager.Execute(conn => DALCategory.InsertNewAppData(conn, model)));
}
