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