public object CreateTheater([FromBody] CreateTheaterModel cm)
{
try
{
// var addr = Server.GetUserIp(Request.HttpContext);
// if (Server.IpHandle(addr) == 0)
// {
// return new[] { "your ip can't using our api , please contact administrator" };
// }
//
var account = HttpContext.Session.GetString("user_account");
if (account == null)
{
return(new
{
result = 401,
msg = "not login"
});
}
var re = TheaterServer.CreateTheater(cm);
return(re);
}
catch (Exception e)
{
return(new
{
result = e.HResult,
msg = e.Message
});
}
}
/// <summary>
/// 创建一个新演出厅
/// </summary>
/// <param name="cm">演出厅信息</param>
/// <returns>创建结果</returns>
public static object CreateTheater(CreateTheaterModel cm)
{
using (var con = new SqlConnection(Server.SqlConString))
{
con.Open();
var sqlCom = new SqlCommand("sp_CreateTheater", con)
{
CommandType = CommandType.StoredProcedure
};
sqlCom.Parameters.AddRange(new[]
{
new SqlParameter
{
ParameterName = "@theaterName",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.NVarChar,
Size = 30,
Value = cm.TheaterName
},
new SqlParameter
{
ParameterName = "@Location",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.NVarChar,
Size = 30,
Value = cm.Location
},
new SqlParameter
{
ParameterName = "@MapSite",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.NVarChar,
Size = 30,
Value = cm.MapSite
},
new SqlParameter
{
ParameterName = "@seatRowsCount",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Int,
Value = cm.SeatRowCount
},
new SqlParameter
{
ParameterName = "@seatColsCount",
Direction = ParameterDirection.Input,
SqlDbType = SqlDbType.Int,
Value = cm.SeatColCount
},
new SqlParameter
{
ParameterName = "@message",
Direction = ParameterDirection.Output,
Size = 30,
SqlDbType = SqlDbType.VarChar
},
new SqlParameter
{
ParameterName = "@return",
Direction = ParameterDirection.ReturnValue,
SqlDbType = SqlDbType.Int
}
});
sqlCom.ExecuteNonQuery();
return(new
{
result = (int)sqlCom.Parameters["@return"].Value,
msg = (string)sqlCom.Parameters["@message"].Value
});
}
}
