/// <summary>
/// 增加一条记录，返回新的ID号。需要有一个单一主键，并且开启有标识符属性（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <returns></returns>
public virtual async Task <int> InsertAsync(WorkEntity entity)
{
if (entity.WorkID <= 0)
{
entity.WorkID = GetNewID();
}
Dictionary <string, object> dict = new Dictionary <string, object>();
GetParameters(entity, dict);
string strSQL = "insert into Work (" +
"WorkID," +
"WorkName," +
"WorkCategoryID," +
"UserName," +
"IP," +
"InputTime," +
"FormID," +
"FormTable," +
"FlowID," +
"Status) " +
"values(" +
"@WorkID," +
"@WorkName," +
"@WorkCategoryID," +
"@UserName," +
"@IP," +
"@InputTime," +
"@FormID," +
"@FormTable," +
"@FlowID," +
"@Status)";
if (await Task.Run(() => _DB.ExeSQLResult(strSQL, dict)))
{
return(DataConverter.CLng(entity.WorkID));
}
return(-1);
}
public static async Task <WorkItemEntity> ViewInfo(int id)
{
WorkItemEntity work = new WorkItemEntity();
work.total = 0;
work.workItem = new List <WorkEntity>();
var query = "SELECT teacher_id,work_id,work_name,cover,work_description,address,salary,work_time,likes_num,collect_num,share_num FROM work WHERE work_id=ANY (SELECT work_id FROM favorite_has_work WHERE favorite_id=@id);";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@id", id);
using var reader = await command.ExecuteReaderAsync();
while (reader.Read())
{
WorkEntity temp = new WorkEntity();
temp.teacher_id = reader.GetInt32("teacher_id");
temp.work_id = reader.GetInt32("work_id");
temp.work_name = reader.GetString("work_name");
temp.cover = reader.GetString("cover");
temp.work_description = reader.GetString("work_description");
temp.address = reader.GetString("address");
temp.work_time = reader.GetString("work_time");
temp.salary = reader.GetInt32("salary");
temp.likes_num = reader.GetInt32("likes_num");
temp.collect_num = reader.GetInt32("collect_num");
temp.share_num = reader.GetInt32("share_num");
work.total++;
work.workItem.Add(temp);
}
return(work);
}
public void WorkEntity2ProjectDTO()
{
var parent = new WorkEntity
{
ID = 1,
Name = "All Products",
SubItems = new List <WorkEntity>()
};
var child1 = new WorkEntity
{
ID = 2,
Name = "Product 1",
ParentID = 1,
Parent = parent
};
var child2 = new WorkEntity
{
ID = 3,
Name = "Product 2",
Parent = parent,
ParentID = 1
};
parent.SubItems.Add(child1);
parent.SubItems.Add(child2);
var dto0 = _mapper.Map <ProjectDtoWithParent>(parent);
var dto1 = _mapper.Map <ProjectDtoWithParent>(child1);
Assert.AreEqual(parent.ID, dto0.ID, "copying parent.ID");
Assert.AreEqual(parent.Name, dto0.Name, "copying parent.name");
Assert.AreEqual(child1.ID, dto1.ID, "copying child.ID");
Assert.AreEqual(child1.Name, dto1.Name, "copying child.name");
}
private async Task <T> DoWorkAsync <T>(Func <WebClient, Task <WorkEntity <T> > > work, Uri uri, HttpMethod method)
{
int httpStatusCode = -3;
long responseLength = -1;
long requestLength = -1;
Stopwatch requestTimer = UseHttpLog ? Stopwatch.StartNew() : null;
try
{
using (WebClient webClient = CreateWebClient())
{
WorkEntity <T> res = await work(webClient).ConfigureAwait(false);
httpStatusCode = 200;
responseLength = res?.ResponseLength ?? 0;
requestLength = res?.RequestLength ?? 0;
T result = res == null ? default(T) : res.Result;
return(result);
}
}
catch (WebException wex)
{
httpStatusCode = GetHttpStatusCodeFromWex(wex);
throw;
}
finally
{
if (requestTimer != null)
{
requestTimer.Stop();
HttpLog(requestTimer.ElapsedMilliseconds, uri, method, requestLength, responseLength, httpStatusCode);
}
}
}
///<summery>
/// (非学生用户)创建工作
/// 设置 likes_num, collect_num, share_num 为 0
/// dumei 08.23
///</summery>
///<summery>
/// 增加start_time,end_time,start_day,end_day,week_day
/// dumei 09.08
///</summery>
public static async Task <int> Create(WorkEntity work)
{
var query = @"INSERT INTO work(teacher_id,work_name,cover,work_description,address,salary,
likes_num,collect_num,start_day,end_day,start_time,end_time,total_time,week_day)
VALUES(@teacher_id,@work_name,@cover,@description,@address,@salary,
@likes,@collect,@start_day,@end_day,@start_time,@end_time,@total_time,@week_day)";
using var connection = DatabaseConnector.Connect();
await connection.OpenAsync();
using var command = connection.CreateCommand();
command.CommandText = query;
command.Parameters.AddWithValue("@teacher_id", work.teacher_id);
//command.Parameters.AddWithValue("@work_id", work.work_id);
command.Parameters.AddWithValue("@work_name", work.work_name);
command.Parameters.AddWithValue("@cover", work.cover);
command.Parameters.AddWithValue("@description", work.work_description);
command.Parameters.AddWithValue("@address", work.address);
command.Parameters.AddWithValue("@salary", work.salary);
//command.Parameters.AddWithValue("@work_time", work.work_time);
//command.Parameters.AddWithValue("@work_time", "none"); //to be delete
command.Parameters.AddWithValue("@start_day", work.start_day);
command.Parameters.AddWithValue("@end_day", work.end_day);
command.Parameters.AddWithValue("@start_time", work.start_time);
command.Parameters.AddWithValue("@end_time", work.end_time);
command.Parameters.AddWithValue("@total_time", work.total_time);
command.Parameters.AddWithValue("@week_day", work.week_day);
command.Parameters.AddWithValue("@likes", 0);
command.Parameters.AddWithValue("@collect", 0);
//command.Parameters.AddWithValue("@share", 0);
await command.ExecuteNonQueryAsync();
return((int)command.LastInsertedId);
}
private void edit_work_Click(object sender, RoutedEventArgs e)
{
try
{
int workId = int.Parse(workId_txt.Text);
string batchType = batch_txt.Text;
int noOfWorkingDays = int.Parse(working_days_no_txt.Text);
int noOfWorkingHours = int.Parse(working_hours_no_txt.Text);
String startTime = startTime_txt.Text;
String endTime = endTime_txt.Text;
String monday = "";
String tuesday = "";
String wednesday = "";
String thursday = "";
String friday = "";
String saturday = "";
String sunday = "";
int count = 0;
//String[] days = new String[7];
ArrayList days = new ArrayList();
if (chk_mon.IsChecked == true)
{
monday = "Monday,";
days.Add(monday);
count++;
}
else
{
monday = null;
}
if (chk_tue.IsChecked == true)
{
tuesday = "Tuesday,";
days.Add(tuesday);
count++;
}
else
{
tuesday = null;
}
if (chk_wed.IsChecked == true)
{
wednesday = "Wednesday,";
days.Add(wednesday);
count++;
}
else
{
wednesday = null;
}
if (chk_thr.IsChecked == true)
{
thursday = "Thursday,";
days.Add(thursday);
count++;
}
else
{
thursday = null;
}
if (chk_fri.IsChecked == true)
{
friday = "Friday,";
days.Add(friday);
count++;
}
else
{
friday = null;
}
if (chk_sat.IsChecked == true)
{
saturday = "Saturday,";
days.Add(saturday);
count++;
}
else
{
saturday = null;
}
if (chk_sun.IsChecked == true)
{
sunday = "Sunday";
days.Add(sunday);
count++;
}
else
{
sunday = null;
}
String workingDays = "";
string[] array = days.ToArray(typeof(string)) as string[];
if (count == int.Parse(working_days_no_txt.Text))
{
foreach (string value in array)
{
edit_txt_hide.AppendText(value.ToString());
workingDays = edit_txt_hide.Text;
}
workEntity = new WorkEntity(workId, batchType, noOfWorkingDays, workingDays, noOfWorkingHours, startTime, endTime);
//workEntity = CreateWorkEntity();
_viewModel.UpdateWorkData(workEntity);
view_grid.ItemsSource = _viewModel.LoadData();
clear();
}
else
{
MessageBox.Show("Count of Working days and No of working days are not matching");
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
private void GenerateStudent_btn_Click(object sender, RoutedEventArgs e)
{
try
{
//string lecturername = lec_name_txt.Text;
//var s = _sessionViewModel.LoadSessionData();
int workdID = int.Parse(timeTable_Id_txt.Text);
List <WorkEntity> list = new List <WorkEntity>();
_viewModel = new WorkViewModel();
list = _viewModel.LoadWorkingDaysData(workdID);
studentTable_grid.ItemsSource = list;
WorkEntity work = studentTable_grid.Items[0] as WorkEntity;
String res = work.workingDays.ToString();
int num = work.noOfWorkingHours;
String res1 = work.timeSlotStartTime.ToString();
String res2 = work.timeSlotEndTime.ToString();
//data.items = works.Split(',');
//List<string> list1 = new List<string>();
//Data data = new Data();
string[] days;
string[] start;
string[] end;
start = res1.Split(',');
end = res2.Split(',');
_timeSlotViewModel = new TimeSlotViewModel();
string batch = batchType_txt.Text;
if (batch == "Main Group")
{
days = res.Split(',');
int len = (end.Length) - 2;
string x = end[len];
string batchId = batchId_txt.Text;
List <int> sessionIdsMainGrp = new List <int>();
_sessionViewModel.LoadSessionDataByGroup(batchId).Select(ee => { sessionIdsMainGrp.Add(ee.SessionId); return(ee); }).ToList();
var c = sessionIdsMainGrp;
// _sessionViewModel.LoadSessionDataByLecturer(lecId).Select(e => { sessionIds.Add(e.SessionId); return e; }).ToList();
//var c = sessionIds;
_timeSlotEntities = new List <TimeSlotEntity>();
double startTime = double.Parse(start[0]);
int currentDate = 0;
double endTime = double.Parse(end[len]);
int num1 = num * days.Length;
for (int i = 0; i < num1; i++)
{
if (startTime == endTime)
{
startTime = double.Parse(start[0]);
currentDate++;
}
if (i >= c.Count)
{
_timeSlotEntities.Add(
new TimeSlotEntity {
ID = i, TimeSlots = $"{startTime}-{++startTime}", Days = days[currentDate], SessionId = 0
}
);
}
else
{
_timeSlotEntities.Add(
new TimeSlotEntity {
ID = i, TimeSlots = $"{startTime}-{++startTime}", Days = days[currentDate], SessionId = c[i]
}
);
}
}
foreach (TimeSlotEntity t in _timeSlotEntities)
{
_timeSlotViewModel.SaveTimeSlotsData(t);
}
var y = _timeSlotViewModel.LoadTimeSlotData();
student_timetable.ItemsSource = y;
_timeSlotViewModel.DeleteTimeData();
}
if (batch == "Sub Group")
{
days = res.Split(',');
int len = (end.Length) - 2;
string x = end[len];
string batchId = batchId_txt.Text;
List <int> sessionIdsSubGrp = new List <int>();
_sessionViewModel.LoadSessionDataBySubGroup(batchId).Select(ee => { sessionIdsSubGrp.Add(ee.SessionId); return(ee); }).ToList();
var c = sessionIdsSubGrp;
_timeSlotEntities = new List <TimeSlotEntity>();
double startTime = double.Parse(start[0]);
int currentDate = 0;
double endTime = double.Parse(end[len]);
int num1 = num * days.Length;
for (int i = 0; i < num1; i++)
{
if (startTime == endTime)
{
startTime = double.Parse(start[0]);
currentDate++;
}
if (i >= c.Count)
{
_timeSlotEntities.Add(
new TimeSlotEntity {
ID = i, TimeSlots = $"{startTime}-{++startTime}", Days = days[currentDate], SessionId = 0
}
);
}
else
{
_timeSlotEntities.Add(
new TimeSlotEntity {
ID = i, TimeSlots = $"{startTime}-{++startTime}", Days = days[currentDate], SessionId = c[i]
}
);
}
}
foreach (TimeSlotEntity t in _timeSlotEntities)
{
_timeSlotViewModel.SaveTimeSlotsData(t);
}
var y = _timeSlotViewModel.LoadTimeSlotData();
student_timetable.ItemsSource = y;
_timeSlotViewModel.DeleteTimeData();
}
}
catch (NullReferenceException ex)
{
MessageBox.Show(ex.Message);
}
}
public void AddForm(string flowId, int status, string contents, List <WorkControlEntity> controls, List <WorkFileEntity> files)
{
WorkEntity workEntity = new WorkEntity();
if (status == (int)WorkStatus.Save || status == (int)WorkStatus.Applying)
{
if (flowId != null)
{
FlowEntity flowentity = flowApp.GetForm(flowId);
if (flowentity != null && !string.IsNullOrEmpty(flowentity.Id))
{
FormEntity formEntity = formApp.GetForm(flowentity.FormId);
FlowVersionEntity flowVersionEntity = flowApp.GetDesign(flowId);
if (flowentity != null && !string.IsNullOrEmpty(flowentity.Id) &&
formEntity != null && !string.IsNullOrEmpty(formEntity.Id) &&
flowVersionEntity != null && !string.IsNullOrEmpty(flowVersionEntity.Id))
{
workEntity.Create();
workEntity.FullName = flowentity.FullName;
workEntity.FlowVersionId = flowVersionEntity.Id;
workEntity.FlowStatus = (int)WorkStatus.Save;
workEntity.Codes = formEntity.Codes;
workEntity.Contents = contents;
var loguser = OperatorProvider.Provider.GetCurrent();
if (loguser != null)
{
workEntity.ApplyUserId = loguser.UserId;
}
service.AddForm(workEntity, controls, files);
if (status == (int)WorkStatus.Applying)
{
try
{
workFlowApp.Start(workEntity.Id);
}
catch (Exception ex)
{
workEntity.FlowStatus = (int)WorkStatus.Save;
service.Update(workEntity);
throw ex;
}
}
}
else
{
throw new Exception("操作失败！");
}
}
else
{
throw new Exception("操作失败！");
}
}
else
{
throw new Exception("操作失败！");
}
}
else
{
throw new Exception("操作失败，提交状态无效！");
}
}
/// <summary>
/// 增加或更新一条记录（异步方式）
/// </summary>
/// <param name="entity">实体模型</param>
/// <param name="IsSave">是否增加</param>
/// <returns></returns>
public virtual async Task <bool> AddOrUpdateAsync(WorkEntity entity, bool IsSave)
{
return(IsSave ? await AddAsync(entity) : await UpdateAsync(entity));
}
/// <summary>
/// 增加或更新一条记录
/// </summary>
/// <param name="entity">实体模型</param>
/// <param name="IsSave">是否增加</param>
/// <returns></returns>
public virtual bool AddOrUpdate(WorkEntity entity, bool IsSave)
{
return(IsSave ? Add(entity) : Update(entity));
}
public static IEnumerable <WorkEntity> GetWorkCompletedMetadata(CloudTableClient client, string resultPath, string container)
{
var workTable = client.GetTableReference(WorkTableName);
TableQuery <WorkEntity> workItemQuery = new TableQuery <WorkEntity>().Where(
TableQuery.CombineFilters(
TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, WorkEntity.EncodeResultPath(resultPath, container)),
TableOperators.And,
TableQuery.GenerateFilterCondition("CompletedTime", QueryComparisons.NotEqual, "")));
return(workTable.ExecuteQuery(workItemQuery));
}
private void ApplySuccess(string workId, string desc, ref bool IsEnd)
{
try
{
string applyUserId = string.Empty;
var loguser = OperatorProvider.Provider.GetCurrent();
if (loguser != null)
{
applyUserId = loguser.UserId;
}
else
{
throw new Exception("当前用户信息异常！");
}
using (var db = new RepositoryBase().BeginTrans())
{
WorkEntity workEntity = db.FindEntity <WorkEntity>(m => m.Id == workId);
if (workEntity != null && !string.IsNullOrEmpty(workEntity.Id))
{
if (!workEntity.CurrentUsers.Contains(applyUserId))
{
throw new Exception("当前用户无权限审核此流程！");
}
if (workEntity.FlowStatus != (int)WorkStatus.Applying)
{
throw new Exception("当前审批状态不能进行审核！");
}
workEntity.Modify(workEntity.Id);
FlowNodeEntity currentNode = db.FindEntity <FlowNodeEntity>(m => m.Id == workEntity.CurrentNodeId);
if (currentNode != null && !string.IsNullOrEmpty(currentNode.Id))
{
if (currentNode.StepType == (int)StepType.One)
{
ApplySuccessOne(workId, desc, db, workEntity, currentNode, ref IsEnd);
}
else
{
string[] strUsers = workEntity.CurrentUsers.Split(',');
if (strUsers != null && strUsers.Length == 1)
{
ApplySuccessOne(workId, desc, db, workEntity, currentNode, ref IsEnd);
}
else
{
string[] strUsersNew = strUsers?.Where(m => m != applyUserId)?.ToArray();
if (strUsersNew != null && strUsersNew.Length > 0)
{
workEntity.CurrentUsers = string.Join(",", strUsersNew.ToArray());
AddApproProcess(workId, desc, ApprovalStatus.Pass, currentNode, db);
AddCcSuccess(workId, workEntity.CurrentNodeId, applyUserId, db);
}
}
}
}
else
{
throw new Exception("获取当前流程节点异常！");
}
db.Update(workEntity);
db.Commit();
}
else
{
throw new Exception("获取当前流程信息异常！");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public void SaveData(WorkEntity work)
{
_workData.saveWorkingData(work);
}
private void ApplyFail(string workId, string desc)
{
try
{
string applyUserId = string.Empty;
var loguser = OperatorProvider.Provider.GetCurrent();
if (loguser != null)
{
applyUserId = loguser.UserId;
}
else
{
throw new Exception("当前用户信息异常！");
}
using (var db = new RepositoryBase().BeginTrans())
{
WorkEntity workEntity = db.FindEntity <WorkEntity>(m => m.Id == workId);
if (workEntity != null && !string.IsNullOrEmpty(workEntity.Id))
{
if (!workEntity.CurrentUsers.Contains(applyUserId))
{
throw new Exception("当前用户无权限审核此流程！");
}
if (workEntity.FlowStatus != (int)WorkStatus.Applying)
{
throw new Exception("当前审批状态不能进行审核！");
}
workEntity.Modify(workEntity.Id);
FlowNodeEntity currentNode = db.FindEntity <FlowNodeEntity>(m => m.Id == workEntity.CurrentNodeId);
bool isFail = false;
FlowNodeEntity lastNode = GetFailNextNodeId(workId, out isFail);
if (isFail)
{
AddApproProcess(workId, desc, ApprovalStatus.Fail, currentNode, db);
workEntity.FlowStatus = (int)WorkStatus.Fail;
AddEndApproProcess(workId, lastNode, db);
}
else
{
if (lastNode != null && !string.IsNullOrEmpty(lastNode.Id))
{
workEntity.CurrentNodeId = lastNode.Id;
string lastUserId = GetApplyUserByNode(lastNode, workId);
bool isNeedSkip = false;
string userIds = GetCurrentUserIds(lastNode, lastUserId, out isNeedSkip);
if (!string.IsNullOrEmpty(userIds))
{
workEntity.CurrentUsers = userIds;
}
workEntity.FlowStatus = (int)WorkStatus.Applying;
AddApproProcess(workId, desc, ApprovalStatus.Fail, currentNode, db);
}
else
{
throw new Exception("当前节点驳回配置异常,请联系管理员！");
}
}
AddCcFail(workId, lastNode.Id, applyUserId, db);
db.Update(workEntity);
db.Commit();
}
else
{
throw new Exception("获取当前流程信息异常！");
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private FlowNodeEntity GetNextNodeId(string workId, ApprovalStatus approvalStatus, ref FlowLineEntity flowLineEntity, RejectType rejectType = RejectType.Last)
{
try
{
FlowNodeEntity nextNode = new FlowNodeEntity();
using (var db = new RepositoryBase())
{
WorkEntity workEntity = db.FindEntity <WorkEntity>(m => m.Id == workId);
if (workEntity != null && !string.IsNullOrEmpty(workEntity.Id))
{
if (approvalStatus == ApprovalStatus.Pass)
{
if (string.IsNullOrEmpty(workEntity.CurrentNodeId))
{
FlowNodeEntity flowNodeEntity = db.FindEntity <FlowNodeEntity>(m => m.IsStartNode == true && m.FlowVersionId == workEntity.FlowVersionId);
if (flowNodeEntity != null && !string.IsNullOrEmpty(flowNodeEntity.Id))
{
workEntity.CurrentNodeId = flowNodeEntity.Id;
}
}
nextNode = GetNextNodeIdPass(workId, workEntity.CurrentNodeId, workEntity.FlowVersionId, ref flowLineEntity);
}
else
if (approvalStatus == ApprovalStatus.Fail)
{
if (!string.IsNullOrEmpty(workEntity.CurrentNodeId))
{
FlowNodeEntity flowNodeEntity = db.FindEntity <FlowNodeEntity>(m => m.Id == workEntity.CurrentNodeId);
if (flowNodeEntity != null && !string.IsNullOrEmpty(flowNodeEntity.Id))
{
switch (flowNodeEntity.RejectType)
{
case (int)RejectType.Reviewer:
FlowNodeEntity startflowNodeEntity = db.FindEntity <FlowNodeEntity>(m => m.IsStartNode == true && m.FlowVersionId == workEntity.FlowVersionId);
if (flowNodeEntity != null && !string.IsNullOrEmpty(flowNodeEntity.Id))
{
workEntity.CurrentNodeId = flowNodeEntity.Id;
}
nextNode = GetNextNodeIdPass(workId, workEntity.CurrentNodeId, workEntity.FlowVersionId, ref flowLineEntity);
break;
case (int)RejectType.Last:
nextNode = GetNextNodeIdFail(workId, workEntity.CurrentNodeId, workEntity.FlowVersionId, ref flowLineEntity);
break;
case (int)RejectType.Specified:
break;
default:
throw new Exception("当前节点驳回配置异常！");
}
}
}
else
{
throw new Exception("当前节点异常！");
}
}
}
}
return(nextNode);
}
catch (Exception ex)
{
throw ex;
}
}
public WorkEntity GetForm(string keyValue)
{
WorkEntity model = service.FindEntity(keyValue);
return(model);
}
private void GenerateLecturerTable_btn_Click(object sender, RoutedEventArgs ev)
{
try
{
//string lecturername = lec_name_txt.Text;
//var s = _sessionViewModel.LoadSessionData();
int workdID = int.Parse(timeTable_Id_txt.Text);
List <WorkEntity> list = new List <WorkEntity>();
_viewModel = new WorkViewModel();
list = _viewModel.LoadWorkingDaysData(workdID);
lecturerTable_grid.ItemsSource = list;
WorkEntity work = lecturerTable_grid.Items[0] as WorkEntity;
String res = work.workingDays.ToString();
int num = work.noOfWorkingHours;
String res1 = work.timeSlotStartTime.ToString();
String res2 = work.timeSlotEndTime.ToString();
//data.items = works.Split(',');
//List<string> list1 = new List<string>();
//Data data = new Data();
string[] days;
string[] start;
string[] end;
start = res1.Split(',');
end = res2.Split(',');
//string full;
//List<Data> datalist = new List<Data>();
/*for (int i=0; i<start.Length; i++)
* {
* full = start[i] + end[i];
* list1.Add(full);
*
* }
*
* for (int i = 0; i < list1.Count; i++)
* {
* datalist.Add(new Data
* {
* fullTime = list1[i].ToString()
* });
* }*/
//lecturer_timetable.DataContext = datalist;
//string[] test = list1.ToArray();
//data.fullTime = list1.ToArray();
_timeSlotViewModel = new TimeSlotViewModel();
days = res.Split(',');
//data.items[0] = "";
//data.items = res.Split(',');
//DataContext = data;
//lecturer_timetable.Items.Add(data);
//lecturer_timetable.DataContext = data.fullTime;
int len = (end.Length) - 2;
string x = end[len];
string name = lec_name_txt.Text;
int lecId = lecturers.Find(e => e.Name == name).EmployeeId;
List <int> sessionIds = new List <int>();
_sessionViewModel.LoadSessionDataByLecturer(lecId).Select(e => { sessionIds.Add(e.SessionId); return(e); }).ToList();
var c = sessionIds;
//var f = _sessionViewModel.LoadSessionDataByLecturer(lecId);
// for(int i; i < )
//for (int i = 0; i < days.Length; i++)
//{
// days[i] =
//}
//For day : - 9 ?
// # of days : - 5 ?
// TOT = 9*5 = 45
_timeSlotEntities = new List <TimeSlotEntity>();
double startTime = double.Parse(start[0]);
//int sttime = 8;
//float st = ++startTime;
int currentDate = 0;
//int edtime = 17;
double endTime = double.Parse(end[len]);
int num1 = num * days.Length;
for (int i = 0; i < num1; i++)
{
if (startTime == endTime)
{
startTime = double.Parse(start[0]);
currentDate++;
}
if (i >= c.Count)
{
_timeSlotEntities.Add(
new TimeSlotEntity {
ID = i, TimeSlots = $"{startTime}-{++startTime}", Days = days[currentDate], SessionId = 0
}
);
}
else
{
_timeSlotEntities.Add(
new TimeSlotEntity {
ID = i, TimeSlots = $"{startTime}-{++startTime}", Days = days[currentDate], SessionId = c[i]
}
);
}
}
//timeSlotEntity = new TimeSlotEntity(2, "8-9", "tue");
//_timeSlotViewModel.SaveTimeSlotsData(timeSlotEntity);
foreach (TimeSlotEntity t in _timeSlotEntities)
{
_timeSlotViewModel.SaveTimeSlotsData(t);
}
var y = _timeSlotViewModel.LoadTimeSlotData();
lecturer_timetable.ItemsSource = y;
_timeSlotViewModel.DeleteTimeData();
//string name = "Arosha";
//int lecId = lecturers.Find(e => e.Name == name).EmployeeId;
//List<int> sessionIds = new List<int>();
//_sessionViewModel.LoadSessionDataByLecturer(lecId).Select(e => { sessionIds.Add(e.SessionId); return e; });
//var c = sessionIds;
/*string[,] daysAndSlots = {
* { "Monday", "8.30-9.30" },
* { "Tuesday", "9.30-10.30" },
* { "Wednesday", "10.30-11.30" },
* { "Thursday", "11.30-12.30" },
* { "Friday", "12.30-13.30" },
* { "Saturday", "13.30-14.30" }
* };*/
}
catch (NullReferenceException ex)
{
MessageBox.Show(ex.Message);
}
}
public static int GetWorkCompletedCount(CloudTableClient client, string resultPath, string container)
{
var workTable = client.GetTableReference(WorkTableName);
TableQuery <WorkEntity> workItemQuery = new TableQuery <WorkEntity>().Where(
TableQuery.CombineFilters(
TableQuery.GenerateFilterCondition("PartitionKey", QueryComparisons.Equal, WorkEntity.EncodeResultPath(resultPath, container)),
TableOperators.And,
TableQuery.GenerateFilterCondition("CompletedTime", QueryComparisons.NotEqual, ""))).Select(new[] { "RowKey" });
var completedItems = workTable.ExecuteQuery(workItemQuery);
return(completedItems.ToList().Count);
}
public void UpdateWorkData(WorkEntity work)
{
_workData.UpdateData(work);
}
private void add_work_btn_Click(object sender, RoutedEventArgs e)
{
/*try
* {
*
*
* }
* catch(Exception ex)
* {
* MessageBox.Show(ex.Message);
* }*/
String monday = "";
String tuesday = "";
String wednesday = "";
String thursday = "";
String friday = "";
String saturday = "";
String sunday = "";
int count = 0;
//String[] days = new String[7];
ArrayList days = new ArrayList();
if (chk_mon.IsChecked == true)
{
monday = "Monday,";
days.Add(monday);
count++;
}
else
{
monday = null;
}
if (chk_tues.IsChecked == true)
{
tuesday = "Tuesday,";
days.Add(tuesday);
count++;
}
else
{
tuesday = null;
}
if (chk_wed.IsChecked == true)
{
wednesday = "Wednesday,";
days.Add(wednesday);
count++;
}
else
{
wednesday = null;
}
if (chk_thurs.IsChecked == true)
{
thursday = "Thursday,";
days.Add(thursday);
count++;
}
else
{
thursday = null;
}
if (chk_fri.IsChecked == true)
{
friday = "Friday,";
days.Add(friday);
count++;
}
else
{
friday = null;
}
if (chk_sat.IsChecked == true)
{
saturday = "Saturday,";
days.Add(saturday);
count++;
}
else
{
saturday = null;
}
if (chk_sun.IsChecked == true)
{
sunday = "Sunday";
days.Add(sunday);
count++;
}
else
{
sunday = null;
}
foreach (String obj in days)
{
}
String workingDays = "";
//workId = Convert.ToInt16(workId_txt.Text);
String batch = batch_txtbx.Text;
//int wdNo = int.Parse(workdays_no_txtbx.Text);
string[] array = days.ToArray(typeof(string)) as string[];
//int whNo = int.Parse(workinghr_no_txtbx.Text);
// String time = timeslots_txtbx.Text;
if (workdays_no_txtbx.Text == "" || batch_txtbx.Text == "" || workId_txt.Text == "" || workinghr_no_txtbx.Text == "")
{
MessageBox.Show("Please fill the fields");
}
else
{
if (count == int.Parse(workdays_no_txtbx.Text))
{
foreach (string value in array)
{
txtbxcp.AppendText(value.ToString());
workingDays = txtbxcp.Text;
}
string[] array1 = getstartTimes.ToArray(typeof(string)) as string[];
foreach (string value1 in array1)
{
time1.AppendText(value1.ToString());
startTimes = time1.Text;
}
string[] array2 = getendTimes.ToArray(typeof(string)) as string[];
foreach (string value2 in array2)
{
time2.AppendText(value2.ToString());
endTimes = time2.Text;
}
string[] array3 = getfullTimes.ToArray(typeof(string)) as string[];
foreach (string value3 in array3)
{
time3.AppendText(value3.ToString());
fullTimes = time3.Text;
}
workEntity = new WorkEntity(int.Parse(workId_txt.Text), batch, int.Parse(workdays_no_txtbx.Text), workingDays, int.Parse(workinghr_no_txtbx.Text), startTimes, endTimes);
_viewModel.SaveData(workEntity);
clear();
}
else
{
MessageBox.Show("Count of Working days and No of working days are not matching");
}
}
}
public void UpdateEntity(WorkEntity entity)
{
entity.NewPlannedStartDate = NewPlannedStartDate;
entity.AddedCost = AddedCost;
AddedChildrenCost = AddedChildrenCost;
}
public ActionResult WorkMeeting()
{
List <TempProjectData> tempData = new List <TempProjectData>();
string sql = string.Format(@"select b.engineerletdept,e.engineerletdeptid,sum(b.realpernum) realpernum
from bis_workmeeting b
left join epg_outsouringengineer e on e.id=b.engineerid
where b.iscommit=1 and b.meetingtype = '开工会' and to_char(b.meetingdate,'yyyy-MM-dd')=to_char(sysdate,'yyyy-MM-dd') and b.engineerid in
(select e.id from epg_outsouringengineer e where e.engineertype = '002') and b.id not in(select startmeetingid from bis_workmeeting where meetingtype = '收工会' and startmeetingid is not null)
group by b.engineerletdept,e.engineerletdeptid");
var data = workMeetingbll.GetTable(sql);
var totalProNum = 0;
var totalPersonNum = 0;
if (data.Rows.Count > 0)
{
totalPersonNum = Convert.ToInt32(data.Compute("Sum(realpernum)", ""));
}
for (int i = 0; i < data.Rows.Count; i++)
{
TempProjectData itemData = new TempProjectData();
List <ProEntity> ProList = new List <ProEntity>();
itemData.DeptName = data.Rows[i]["engineerletdept"].ToString();
itemData.DeptId = data.Rows[i]["engineerletdeptid"].ToString();
itemData.RealperNum = Convert.ToInt32(data.Rows[i]["realpernum"].ToString());
string sqlWhere = string.Format(@"select distinct b.engineerid
from bis_workmeeting b
where b.iscommit=1 and b.meetingtype = '开工会'
and to_char(b.meetingdate, 'yyyy-MM-dd') =
to_char(sysdate, 'yyyy-MM-dd')
and b.engineerid in (select e.id
from epg_outsouringengineer e
where e.engineertype = '002' and e.engineerletdeptid='{0}')", data.Rows[i]["engineerletdeptid"].ToString());
itemData.ProNum = workMeetingbll.GetTable(sqlWhere).Rows.Count;
totalProNum += itemData.ProNum;
string Sql1 = string.Format(@" select b.id,b.engineername,b.engineerletdept,b.address,realpernum,risklevel,e.engineerletpeople,e.outprojectid
from bis_workmeeting b
left join epg_outsouringengineer e on e.id=b.engineerid
where b.iscommit=1 and b.meetingtype='开工会' and to_char(b.meetingdate,'yyyy-MM-dd')=to_char(sysdate,'yyyy-MM-dd') and b.engineerid in( select e.id from epg_outsouringengineer e where e.engineertype='002' and b.id not in(select startmeetingid from bis_workmeeting where meetingtype = '收工会' and startmeetingid is not null)
and e.engineerletdeptid='{0}')", data.Rows[i]["engineerletdeptid"].ToString());
var dt = workMeetingbll.GetTable(Sql1);
foreach (DataRow item in dt.Rows)
{
ProEntity pro = new ProEntity();
List <WorkEntity> workList = new List <WorkEntity>();
pro.Address = item["address"].ToString();
pro.DeptName = data.Rows[i]["engineerletdept"].ToString();
pro.DeptPersonName = item["engineerletpeople"].ToString();
pro.ProName = item["engineername"].ToString();
pro.RealperNum = Convert.ToInt32(item["realpernum"].ToString());
pro.RiskLevel = item["risklevel"].ToString();
pro.UnitName = new DepartmentBLL().GetEntity(item["outprojectid"].ToString()) == null ? "" : new DepartmentBLL().GetEntity(item["outprojectid"].ToString()).FullName;
pro.Meetingid = item["id"].ToString();
var list = new WorkmeetingmeasuresBLL().GetList("").Where(x => x.Workmeetingid == item["id"].ToString()).Select(x => new
{
x.WorkTask,
x.DangerPoint,
x.Measures,
x.Remark1
}).ToList();
foreach (var workitem in list)
{
WorkEntity e = new WorkEntity();
e.DangerPoint = workitem.DangerPoint;
e.WorkTask = workitem.WorkTask;
e.Measures = workitem.Measures;
e.WorkAddress = workitem.Remark1;
workList.Add(e);
}
pro.workList = workList;
ProList.Add(pro);
}
itemData.ProList = ProList;
tempData.Add(itemData);
}
var jsonData = new
{
tempData = tempData,
totalProNum = totalProNum,
totalPersonNum = totalPersonNum
};
var jsonDataReturn = new { code = 0, count = tempData.Count, info = "获取数据成功", data = jsonData };
return(Content(jsonDataReturn.ToJson()));
}
