public void Add(Cl_CourseOrder model)
{
var tmp = _courseOrderDB.GetList(string.Format("Cl_CourseOrder.UserId = {0} and Cl_CourseOrder.CourseId = {1}", model.UserId, model.CourseId)).FirstOrDefault();
if (tmp == null)
{
_courseOrderDB.Add(model);
}
else
{
tmp.PassStatus = 2;
tmp.OrderStatus = model.OrderStatus;
tmp.LeaveTime = model.LeaveTime;
tmp.OrderTime = model.OrderTime;
tmp.OrderEndTime = model.OrderEndTime;
tmp.IsAppoint = model.IsAppoint;
tmp.IsLeave = 0;
tmp.Reson = "";
tmp.ApprovalFlag = 0;
tmp.ApprovalMemo = "";
tmp.ApprovalUser = "";
tmp.CourseName = model.CourseName;
tmp.CourseStartTime = model.CourseStartTime;
tmp.CourseEndTime = model.CourseEndTime;
tmp.FtriggerFlag = model.FtriggerFlag;
tmp.DropType = 0;
tmp.DropReason = "";
_courseOrderDB.Update(tmp);
}
}
/// <summary>
/// 添加签到表
/// </summary>
/// <param name="CourseId">课程ID</param>
/// <param name="DataTable"></param>
public string AddAttendces(int CourseId, DataTable dtlist)
{
int cg = 0;
int sb = 0;
for (int i = 0; i < dtlist.Rows.Count; i++)
{
try
{
int userid = Convert.ToInt32(dtlist.Rows[i][1].ToString());
string starttime = dtlist.Rows[i][4].ToString();
string endtime = dtlist.Rows[i][5].ToString();
if (starttime == "--" || string.IsNullOrEmpty(starttime))
{
starttime = "2050-1-1";
}
if (endtime == "--" || string.IsNullOrEmpty(endtime))
{
endtime = "2000-1-1";
}
//Co_Course coUser = AttDB.GetCoAndUser(CourseId, userid);
Sys_User leamodel = GetLeaderIdByUserId(userid);
decimal GetScore = 0;
decimal AttLessLength = 0;
string whereStr = string.Format(" where cco.CourseId={0} and cco.UserId={1}", CourseId, userid);
Cl_CourseOrder Comodel = CoDB.GetmodelbyAtt(whereStr);
//判断考勤之后的流程是否已经开始走下去了
//if (Comodel == null || Comodel.LearnStatus == 0)
//{
if (Comodel == null)
{
Comodel = new Cl_CourseOrder();
Comodel.CourseId = CourseId;
Comodel.UserId = userid;
Comodel.OrderTime = DateTime.Now;
Comodel.OrderStatus = 3;
Comodel.IsLeave = 0;
if (leamodel == null)
{
Comodel.ApprovalUser = "";
}
else
{
Comodel.ApprovalUser = leamodel.JobNum;
}
Comodel.ApprovalMemo = "";
Comodel.ApprovalFlag = 0;
Comodel.ApprovalDateTime = DateTime.Now;
Comodel.ApprovalLimitTime = DateTime.Now;
Comodel.OrderTimes = 0;
Comodel.LearnStatus = 0;
Comodel.GetScore = GetScore;
Comodel.PassStatus = 0;
Comodel.IsAppoint = 0;
Comodel.OrderEndTime = DateTime.Now;
Comodel.AttScore = 0;
Comodel.AttFlag = 0;
CoDB.Add(Comodel);
}
else
{
if (Comodel.OrderStatus == 0 || Comodel.OrderStatus == 2)
{
Comodel.OrderStatus = 3;
}
else if (Comodel.OrderStatus == 1 && Comodel.IsLeave == 1 && Comodel.ApprovalFlag == 1 && Comodel.ApprovalLimitTime > Comodel.ApprovalDateTime)
{
Comodel.OrderStatus = 3;
}
else if (Comodel.TimeOutLeaveApprovalFlag == 1)
{
Comodel.OrderStatus = 3;
}
//Comodel.OrderTime = DateTime.Now;
//Comodel.GetScore = GetScore;
//Comodel.OrderEndTime = DateTime.Now;
CoDB.Update(Comodel);
}
Cl_Attendce attmodel = clAttDB.GetCl_Attendce(CourseId, userid);
if (attmodel == null)
{
attmodel = new Cl_Attendce();
attmodel.CourseId = CourseId;
attmodel.UserId = userid;
attmodel.StartTime = DateTime.Parse(starttime);
attmodel.EndTime = DateTime.Parse(endtime);
attmodel.OnlineStartTime = DateTime.Parse(starttime);
attmodel.OnlineEndTime = DateTime.Parse(endtime);
attmodel.LessLength = AttLessLength;
if (leamodel == null)
{
attmodel.ApprovalUser = "";
}
else
{
attmodel.ApprovalUser = leamodel.JobNum;
}
attmodel.ApprovalMemo = "";
attmodel.ApprovalFlag = 0;
attmodel.ApprovalDateTime = DateTime.Now;
clAttDB.AddAttendce(attmodel);
}
else
{
attmodel.StartTime = DateTime.Parse(starttime);
attmodel.EndTime = DateTime.Parse(endtime);
attmodel.OnlineStartTime = DateTime.Parse(starttime);
attmodel.OnlineEndTime = DateTime.Parse(endtime);
attmodel.LessLength = AttLessLength;
if (leamodel == null)
{
attmodel.ApprovalUser = "";
}
else
{
attmodel.ApprovalUser = leamodel.JobNum;
}
attmodel.ApprovalMemo = "";
attmodel.ApprovalFlag = 0;
attmodel.ApprovalDateTime = DateTime.Now;
clAttDB.UpdateAttendce(attmodel);
}
if (dtlist.Columns.Count > 6)
{
for (int j = 0; j < (dtlist.Columns.Count - 6); j++)
{
string where = string.Format(" where CourseId={0} and UserId={1} and Time={2}", CourseId, userid, j + 1);
Cl_MidAttendce clmmodel = clMidDB.GetModel(where);
string lintime = dtlist.Rows[i][j + 6].ToString();
if (lintime == "--" || string.IsNullOrEmpty(lintime))
{
lintime = "2000-1-1";
}
if (clmmodel == null)
{
clmmodel = new Cl_MidAttendce();
clmmodel.CourseId = CourseId;
clmmodel.UserId = userid;
clmmodel.CreateTime = DateTime.Parse(lintime);
clmmodel.Time = j + 1;
clMidDB.Add(clmmodel);
}
else
{
clmmodel.CreateTime = DateTime.Parse(lintime);
clMidDB.Update(clmmodel);
}
}
}
cg += 1;
//}
//else
//{
// sb += 1;
//}
}
catch (Exception ex)
{
sb += 1;
}
}
return("成功" + cg + "条，失败" + sb + "条");
}