public async Task <JsonResult> GetInitData() { //查找数据库中的所有预定义会议(个人) var data = await Task.Run(() => { List <MeetInfoModel> list_model = new List <MeetInfoModel>(); var sqlobj = new SqlOperation(); sqlobj.OpenConnection(); string sqlstr = $"select * from MeetInfo"; SqlDataReader dbdata = sqlobj.ExecuteQuery(sqlstr); if (dbdata.HasRows) { while (dbdata.Read()) { MeetInfoModel model = new MeetInfoModel { RoomNo = dbdata["RoomNo"].ToString(), Theme = dbdata["Theme"].ToString(), StartTime = Convert.ToDateTime(dbdata["StartTime"]), EndTime = Convert.ToDateTime(dbdata["EndTime"]), Password = dbdata["Password"].ToString(), }; list_model.Add(model); } } sqlobj.CloseConnection(); return(list_model); }); return(Json(data)); }
public async Task <IActionResult> Book(string id) { if (!string.IsNullOrEmpty(id)) { MeetInfoModel model = new MeetInfoModel(); await Task.Run(() => { var sqlobj = new SqlOperation(); sqlobj.OpenConnection(); string sqlstr = $"select * from MeetInfo where RoomNo='{id}'"; SqlDataReader dbdata = sqlobj.ExecuteQuery(sqlstr); if (dbdata.HasRows) { while (dbdata.Read()) { model.RoomNo = dbdata["RoomNo"].ToString(); model.Theme = dbdata["Theme"].ToString(); model.StartTime = dbdata.GetDateTime(2); model.EndTime = dbdata.GetDateTime(3); model.Password = dbdata["Password"].ToString(); } } sqlobj.CloseConnection(); }); return(View(model)); } return(View()); }
public void CreateNewTempTestMeet(FoWoSoft.Data.Model.MeetInfo meetInfot) { MeetInfoModel meetInfo = meetInfot as MeetInfoModel; string testMeetid; meetInfoService.RoomisUpdate(meetInfo, out testMeetid); var tempmeet = Common.Tools.MeetInfoToTempTestMeet(meetInfo, testMeetid); new FoWoSoft.Platform.TempTestMeet().RoomisAdd(tempmeet); var aplicatUser = new FoWoSoft.Platform.Users().GetByAccount(meetInfo.ApplicatId); var adminUser = new FoWoSoft.Platform.Users().GetByAccount(meetInfo.AdminId); var task = new FoWoSoft.Data.Model.WorkFlowTask { InstanceID = testMeetid, Title = meetInfo.temp2, SenderID = aplicatUser.ID, SenderName = aplicatUser.Name, ReceiveID = adminUser.ID, ReceiveName = adminUser.Name }; new FoWoSoft.Platform.WorkFlowTask().RoomisCreate(task); }
public void CreateNewTempTestMeet(FoWoSoft.Data.Model.MeetInfo meetInfot) { MeetInfoModel meetInfo = meetInfot as MeetInfoModel; string testMeetid; meetInfoService.RoomisUpdate(meetInfo, out testMeetid); var tempmeet = Common.Tools.MeetInfoToTempTestMeet(meetInfo, testMeetid); new FoWoSoft.Platform.TempTestMeet().RoomisAdd(tempmeet); var aplicatUser = new FoWoSoft.Platform.Users().GetByAccount(meetInfo.ApplicatId); var adminUser = new FoWoSoft.Platform.Users().GetByAccount(meetInfo.AdminId); var task = new FoWoSoft.Data.Model.WorkFlowTask { InstanceID = testMeetid, Title = meetInfo.temp2, SenderID = aplicatUser.ID, SenderName = aplicatUser.Name, ReceiveID = adminUser.ID, ReceiveName = adminUser.Name }; new FoWoSoft.Platform.WorkFlowTask().RoomisCreate(task); //由***部门,***(人名),申请的会议名称为:****会议申请,需要您审核。 var userInfoEdu = new EduWebService().GetUser(meetInfo.ApplicatId); if (userInfoEdu != null) { // var meetMsgProgress = $"由{userInfoEdu.BMMC}部门,{userInfoEdu.XM}(人名),申请的会议名称为:{meetInfo.temp2},"; // var msg = $"{meetMsgProgress}会议申请,需要您审核。"; var msg = string.Format(DuanxinService.DuanxinSendMsg4, userInfoEdu.BMMC, userInfoEdu.XM, meetInfo.temp2); //20180110短信发送 new DuanxinService().smsSend(meetInfo.AdminId, msg); } }
public async Task <ActionResult> Book([ModelBinder] MeetInfoModel meetinfo) { if (!ModelState.IsValid) { return(View()); } //TODO:首先判断数据库里面有没有该数据;有的话属于更新,没的话就是插入 Console.WriteLine($"---输出提交信息的房间号:{meetinfo.RoomNo}"); SqlOperation DB = new SqlOperation(); DB.OpenConnection(); string commondStr = $"select * from MeetInfo MI where MI.RoomNo='{meetinfo.RoomNo}'"; SqlDataReader sqlQueryResult = DB.ExecuteQuery(commondStr); if (sqlQueryResult.HasRows) { //更新操作 await Task.Run(() => { string _commondStr = $"update MeetInfo set Theme='{meetinfo.Theme}'," + $"StartTime='{meetinfo.StartTime}',EndTime='{meetinfo.EndTime}'," + $" Password='******' where MeetInfo.RoomNo='{meetinfo.RoomNo}'"; DB.ExecuteQuery(_commondStr); }); } else { //插入操作 await Task.Run(() => { string sqlstr = $"insert into MeetInfo values('{meetinfo.RoomNo}','{meetinfo.Theme}','{meetinfo.StartTime}','{meetinfo.EndTime}','{meetinfo.Password}')"; DB.ExecuteQuery(sqlstr); }); } DB.CloseConnection(); return(View(nameof(Index))); }