public static string SaveMeetingRoom(string mrInfo, string loginUserInfo)
{
string returnStr = "";
JObject objMr = JObject.Parse(mrInfo);
int mx = 0;
try
{
using (venuesEntities db = new venuesEntities())
{
string strSql = "SELECT MAX(s.MRSequence) as max FROM tbl_venue_meetingroom AS s";
ObjectQuery<DbDataRecord> resultm = db.CreateQuery<DbDataRecord>(strSql);
foreach (var item in resultm)
{
if (item["max"].ToString() != "")
{
mx = int.Parse(item["max"].ToString());
}
}
tbl_venue_meetingroom tbmr = new tbl_venue_meetingroom();
tbmr.Banquet = objMr["mrBanquet"].ToString();
tbmr.Boardroom = objMr["mrBoardroom"].ToString();
tbmr.Classroom = objMr["mrClassroom"].ToString();
tbmr.Dimensions = objMr["mrDimensions"].ToString();
tbmr.FunctionRoom = objMr["mrFunctionRoom"].ToString();
tbmr.Height = objMr["mrHeight"].ToString();
tbmr.HollowSquare = objMr["mrHollowSquare"].ToString();
tbmr.Reception = objMr["mrReception"].ToString();
tbmr.Size = objMr["mrSize"].ToString();
tbmr.Theatre = objMr["mrTheatre"].ToString();
tbmr.UShape = objMr["mrUShape"].ToString();
tbmr.VenueID = int.Parse(objMr["venueID"].ToString());
tbmr.MeetingImage = objMr["MeetingImage"].ToString();
tbmr.MRSequence = mx+1;
db.AddTotbl_venue_meetingroom(tbmr);
if (db.SaveChanges() != 0)
{
returnStr = KeyManager.RetrunSucceed;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增会议室成功，mrInfo=" + mrInfo, loginUserInfo);
}
else
returnStr = KeyManager.RetrunUnSucceed;
}
}
catch (Exception e)
{
returnStr = e.Message;
LogManager.addLog(KeyManager.LogTypeId_Error, KeyManager.MENUS.Menu_VenusManager, "新增会议室，mrInfo=" + mrInfo + ";错误信息：" + e.Message, loginUserInfo);
}
return returnStr;
}