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);
}
/// <summary>
/// 将DataRedar转换为List
/// </summary>
private List <FoWoSoft.Data.Model.WorkFlowTask> DataReaderToList(SqlDataReader dataReader)
{
List <FoWoSoft.Data.Model.WorkFlowTask> List = new List <FoWoSoft.Data.Model.WorkFlowTask>();
FoWoSoft.Data.Model.WorkFlowTask model = null;
while (dataReader.Read())
{
model = new FoWoSoft.Data.Model.WorkFlowTask();
model.ID = dataReader.GetGuid(0);
model.PrevID = dataReader.GetGuid(1);
model.PrevStepID = dataReader.GetGuid(2);
model.FlowID = dataReader.GetGuid(3);
model.StepID = dataReader.GetGuid(4);
model.StepName = dataReader.GetString(5);
model.InstanceID = dataReader.GetString(6);
model.GroupID = dataReader.GetGuid(7);
model.Type = dataReader.GetInt32(8);
model.Title = dataReader.GetString(9);
model.SenderID = dataReader.GetGuid(10);
model.SenderName = dataReader.GetString(11);
model.SenderTime = dataReader.GetDateTime(12);
model.ReceiveID = dataReader.GetGuid(13);
model.ReceiveName = dataReader.GetString(14);
model.ReceiveTime = dataReader.GetDateTime(15);
if (!dataReader.IsDBNull(16))
{
model.OpenTime = dataReader.GetDateTime(16);
}
if (!dataReader.IsDBNull(17))
{
model.CompletedTime = dataReader.GetDateTime(17);
}
if (!dataReader.IsDBNull(18))
{
model.CompletedTime1 = dataReader.GetDateTime(18);
}
if (!dataReader.IsDBNull(19))
{
model.Comment = dataReader.GetString(19);
}
if (!dataReader.IsDBNull(20))
{
model.IsSign = dataReader.GetInt32(20);
}
model.Status = dataReader.GetInt32(21);
if (!dataReader.IsDBNull(22))
{
model.Note = dataReader.GetString(22);
}
model.Sort = dataReader.GetInt32(23);
if (!dataReader.IsDBNull(24))
{
model.SubFlowGroupID = dataReader.GetGuid(24);
}
List.Add(model);
}
return(List);
}
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 int RoomisCreate(FoWoSoft.Data.Model.WorkFlowTask task)
{
Guid ID = Guid.NewGuid();
Guid GroupID = Guid.NewGuid();
var sql = @"INSERT INTO WorkFlowTask(ID, PrevID, PrevStepID, FlowID, StepID, StepName,
InstanceID, GroupID, Type, Title, SenderID, SenderName, SenderTime, ReceiveID, ReceiveName, ReceiveTime, Status, Sort )
VALUES ( @ID ,'00000000-0000-0000-0000-000000000000' ,'00000000-0000-0000-0000-000000000000' ,'2EA49481-3EE2-4805-AB85-53604D696976','307552C3-547D-445B-9C6B-E42737568B10','发起视频会议',
@InstanceID, @GroupID ,'0',@Title,@SenderID,@SenderName,GETDATE(), @SenderID,@SenderName,GETDATE(), 2 ,1)";
var parameters = new SqlParameter[] {
new SqlParameter("@ID", ID),
new SqlParameter("@InstanceID", task.InstanceID),
new SqlParameter("@GroupID", GroupID),
new SqlParameter("@Title", task.Title),
new SqlParameter("@SenderID", task.SenderID),
new SqlParameter("@SenderName", task.SenderName)
};
new DBHelper().Execute(sql, parameters);
var sql1 = @"INSERT INTO WorkFlowTask(ID, PrevID, PrevStepID, FlowID, StepID, StepName,
InstanceID, GroupID, Type, Title, SenderID, SenderName, SenderTime, ReceiveID, ReceiveName, ReceiveTime, Status, Sort )
VALUES ( @ID ,@PrevID ,'307552C3-547D-445B-9C6B-E42737568B10' ,'2EA49481-3EE2-4805-AB85-53604D696976','88B44E40-E9EB-44F9-9F2B-18B0AAE70A5A','会场管理员',
@InstanceID, @GroupID ,'0',@Title,@SenderID,@SenderName,GETDATE(), @ReceiveID,@ReceiveName,GETDATE(), 0 ,2)";
var parameters1 = new SqlParameter[] {
new SqlParameter("@ID", Guid.NewGuid()),
new SqlParameter("@PrevID", ID),
new SqlParameter("@InstanceID", task.InstanceID),
new SqlParameter("@GroupID", GroupID),
new SqlParameter("@Title", task.Title),
new SqlParameter("@SenderID", task.SenderID),
new SqlParameter("@SenderName", task.SenderName),
new SqlParameter("@ReceiveID", task.ReceiveID),
new SqlParameter("@ReceiveName", task.ReceiveName)
};
return(new DBHelper().Execute(sql1, parameters1));
}
/// <summary>
/// 添加记录
/// </summary>
/// <param name="model">FoWoSoft.Data.Model.WorkFlowTask实体类</param>
/// <returns>操作所影响的行数</returns>
public int Add(FoWoSoft.Data.Model.WorkFlowTask model)
{
string sql = @"INSERT INTO WorkFlowTask
(ID,PrevID,PrevStepID,FlowID,StepID,StepName,InstanceID,GroupID,Type,Title,SenderID,SenderName,SenderTime,ReceiveID,ReceiveName,ReceiveTime,OpenTime,CompletedTime,CompletedTime1,Comment,IsSign,Status,Note,Sort,SubFlowGroupID)
VALUES(@ID,@PrevID,@PrevStepID,@FlowID,@StepID,@StepName,@InstanceID,@GroupID,@Type,@Title,@SenderID,@SenderName,@SenderTime,@ReceiveID,@ReceiveName,@ReceiveTime,@OpenTime,@CompletedTime,@CompletedTime1,@Comment,@IsSign,@Status,@Note,@Sort,@SubFlowGroupID)" ;
SqlParameter[] parameters = new SqlParameter[] {
new SqlParameter("@ID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ID
},
new SqlParameter("@PrevID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.PrevID
},
new SqlParameter("@PrevStepID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.PrevStepID
},
new SqlParameter("@FlowID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.FlowID
},
new SqlParameter("@StepID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.StepID
},
new SqlParameter("@StepName", SqlDbType.NVarChar, 1000)
{
Value = model.StepName
},
new SqlParameter("@InstanceID", SqlDbType.VarChar, 50)
{
Value = model.InstanceID
},
new SqlParameter("@GroupID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.GroupID
},
new SqlParameter("@Type", SqlDbType.Int, -1)
{
Value = model.Type
},
new SqlParameter("@Title", SqlDbType.NVarChar, 4000)
{
Value = model.Title
},
new SqlParameter("@SenderID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.SenderID
},
new SqlParameter("@SenderName", SqlDbType.NVarChar, 100)
{
Value = model.SenderName
},
new SqlParameter("@SenderTime", SqlDbType.DateTime, 8)
{
Value = model.SenderTime
},
new SqlParameter("@ReceiveID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.ReceiveID
},
new SqlParameter("@ReceiveName", SqlDbType.NVarChar, 100)
{
Value = model.ReceiveName
},
new SqlParameter("@ReceiveTime", SqlDbType.DateTime, 8)
{
Value = model.ReceiveTime
},
model.OpenTime == null ? new SqlParameter("@OpenTime", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@OpenTime", SqlDbType.DateTime, 8)
{
Value = model.OpenTime
},
model.CompletedTime == null ? new SqlParameter("@CompletedTime", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@CompletedTime", SqlDbType.DateTime, 8)
{
Value = model.CompletedTime
},
model.CompletedTime1 == null ? new SqlParameter("@CompletedTime1", SqlDbType.DateTime, 8)
{
Value = DBNull.Value
} : new SqlParameter("@CompletedTime1", SqlDbType.DateTime, 8)
{
Value = model.CompletedTime1
},
model.Comment == null ? new SqlParameter("@Comment", SqlDbType.VarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Comment", SqlDbType.VarChar, -1)
{
Value = model.Comment
},
model.IsSign == null ? new SqlParameter("@IsSign", SqlDbType.Int, -1)
{
Value = DBNull.Value
} : new SqlParameter("@IsSign", SqlDbType.Int, -1)
{
Value = model.IsSign
},
new SqlParameter("@Status", SqlDbType.Int, -1)
{
Value = model.Status
},
model.Note == null ? new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = DBNull.Value
} : new SqlParameter("@Note", SqlDbType.NVarChar, -1)
{
Value = model.Note
},
new SqlParameter("@Sort", SqlDbType.Int, -1)
{
Value = model.Sort
},
model.SubFlowGroupID == null ? new SqlParameter("@SubFlowGroupID", SqlDbType.UniqueIdentifier, -1)
{
Value = DBNull.Value
} : new SqlParameter("@SubFlowGroupID", SqlDbType.UniqueIdentifier, -1)
{
Value = model.SubFlowGroupID
}
};
return(dbHelper.Execute(sql, parameters));
}
