/// <summary>
/// 更新一条数据(补预订专用)
/// </summary>
public bool Update(Cl_MakeUpOrder model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere = @"UPDATE Cl_MakeUpOrder SET CourseId=@CourseId,UserId=@UserId,ApprovalUser=@ApprovalUser,ApprovalMemo=@ApprovalMemo,ApprovalFlag=@ApprovalFlag,ApprovalDateTime=@ApprovalDateTime,ApprovalLimitTime=@ApprovalLimitTime,IsTimeOut=@IsTimeOut,LeaveUserID=@LeaveUserID,Name=@Name,CourseName=@CourseName,LeaveTime=@LeaveTime,CourseStartTime=@CourseStartTime,CourseEndTime=@CourseEndTime,AttStartTime=@AttStartTime,AttEndTime=@AttEndTime WHERE Id=@Id";
var param = new
{
model.CourseId,
model.UserId,
model.ApprovalUser,
model.ApprovalMemo,
model.ApprovalFlag,
model.ApprovalDateTime,
model.ApprovalLimitTime,
model.IsTimeOut,
model.LeaveUserID,
model.Name,
model.CourseName,
model.LeaveTime,
model.CourseStartTime,
model.CourseEndTime,
model.AttStartTime,
model.AttEndTime
};
return(conn.Execute(sqlwhere, param) > 0);
}
}
/// <summary>
/// 增加一条数据(补预订专用)
/// </summary>
public void Add(Cl_MakeUpOrder model)
{
using (IDbConnection conn = OpenConnection())
{
const string sqlwhere = @"INSERT INTO Cl_MakeUpOrder (CourseId,UserId,ApprovalUser,ApprovalMemo,ApprovalFlag,ApprovalDateTime,ApprovalLimitTime,IsTimeOut,LeaveUserID,Name,CourseName,LeaveTime,CourseStartTime,CourseEndTime,AttStartTime,AttEndTime) VALUES (@CourseId,@UserId,@ApprovalUser,@ApprovalMemo,@ApprovalFlag,@ApprovalDateTime,@ApprovalLimitTime,@IsTimeOut,@LeaveUserID,@Name,@CourseName,@LeaveTime,@CourseStartTime,@CourseEndTime,@AttStartTime,@AttEndTime) SELECT @@IDENTITY AS Id";
var param = new
{
model.CourseId,
model.UserId,
model.ApprovalUser,
model.ApprovalMemo,
model.ApprovalFlag,
model.ApprovalDateTime,
model.ApprovalLimitTime,
model.IsTimeOut,
model.LeaveUserID,
model.Name,
model.CourseName,
model.LeaveTime,
model.CourseStartTime,
model.CourseEndTime,
model.AttStartTime,
model.AttEndTime
};
decimal id = conn.Query <decimal>(sqlwhere, param).FirstOrDefault();
model.Id = decimal.ToInt32(id);
}
}
/// <summary>
/// 补预订
/// </summary>
/// <param name="CourseId">课程ID</param>
/// <param name="userid">用户ID</param>
public void MakeUpOrder(int CourseId, int userid)
{
Co_Course jobmodel = AttDB.GetJobID(CourseId, userid);
Sys_User leamodel = GetLeaderIdByUserId(userid);
string where = string.Format(" where CourseId={0} and UserId={1}", CourseId, userid);
Cl_MakeUpOrder model = clMakeDB.GetModel(where);
Sys_ParamConfig param = paramConfigDB.GetSys_ParamConfig(23);
if (model == null)
{
model = new Cl_MakeUpOrder();
model.CourseId = CourseId;
model.UserId = userid;
if (leamodel == null)
{
model.ApprovalUser = "";
}
else
{
model.ApprovalUser = leamodel.JobNum;
}
model.ApprovalMemo = "";
model.ApprovalFlag = 0;
model.ApprovalDateTime = DateTime.Now;
model.ApprovalLimitTime = DateTime.Now.AddHours(Convert.ToDouble(param.ConfigValue));
model.LeaveUserID = jobmodel.JobNum;
model.IsTimeOut = 0;
model.Name = jobmodel.TeacherName;
model.CourseName = jobmodel.CourseName;
model.LeaveTime = DateTime.Now;
model.CourseStartTime = jobmodel.StartTime;
model.CourseEndTime = jobmodel.EndTime;
model.AttStartTime = jobmodel.attStartTime;
model.AttEndTime = jobmodel.attEndTime;
clMakeDB.Add(model);
}
else
{
if (leamodel == null)
{
model.ApprovalUser = "";
}
else
{
model.ApprovalUser = leamodel.JobNum;
}
model.ApprovalMemo = "";
model.ApprovalFlag = 0;
model.ApprovalDateTime = DateTime.Now;
model.ApprovalLimitTime = DateTime.Now.AddHours(Convert.ToDouble(param.ConfigValue));
model.IsTimeOut = 0;
model.LeaveUserID = jobmodel.JobNum;
model.Name = jobmodel.TeacherName;
model.CourseName = jobmodel.CourseName;
model.LeaveTime = DateTime.Now;
model.CourseStartTime = jobmodel.StartTime;
model.CourseEndTime = jobmodel.EndTime;
model.AttStartTime = jobmodel.attStartTime;
model.AttEndTime = jobmodel.attEndTime;
clMakeDB.Update(model);
}
}
