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