private static void LogDeleteTrainee(tbl_trainee tr)
{
using (var context = new TrainingSign_Entities())
{
var entity = new tbl_delete_trainee_log()
{
ref_training_id = tr.ref_training_id,
workid = tr.workid,
name = tr.name,
signinTime = tr.signinTime,
deleteTime = DateTime.Now
};
try
{
context.tbl_delete_trainee_log.Add(entity);
context.SaveChanges();
}
catch (Exception ex)
{
}
}
}
/// <summary>
///
/// </summary>
/// <param name="snr"></param>
/// <param name="gTrainingID"></param>
/// <param name="empInfo"></param>
/// <param name="serr"></param>
/// <returns>
/// 0 -- 失败
/// 1 -- 签到成功
/// -1 -- 已经签到过
/// </returns>
internal static int Add(string snr, Guid gTrainingID, out TPersonInfo empInfo, out string serr)
{
empInfo = null;
serr = string.Empty;
var info = WorkIDInfo.GetEmployeeInfo(snr);
if (null == info)
{
serr = "没有找到此员工信息";
return(0);
}
//insert
int nRet = -1;
using (var context = new TrainingSign_Entities())
{
//由于部门解释还是有问题，用来避免由于部门名称过长而插入失败，
//这里的限制与 tbl_trainee的department列一致
var sDept = StringUtility.LimitStr(info.shortDepartment, 80);
//insert
var entity = new tbl_trainee()
{
ref_training_id = gTrainingID
, workid = info.empID
, name = info.cnName
, department = sDept
, signinTime = DateTime.Now
//,organizer
//,memo
};
if (!context.tbl_trainee.Any(x => x.ref_training_id == entity.ref_training_id &&
0 == string.Compare(x.workid, entity.workid, StringComparison.InvariantCultureIgnoreCase)))
{
try
{
context.tbl_trainee.Add(entity);
context.SaveChanges();
nRet = 1;
empInfo = new TPersonInfo {
extra = entity.id, //!注意
workid = entity.workid,
cn_name = entity.name,
org_name = entity.department,
oper_time_str = LocalFormatStr.GetLocalTimeStr(entity.signinTime.Value)
};
}
catch (Exception ex)
{
//serr = ex.Message;
serr = "添加员工签到失败";
}
}
else
{
//已经签到过
empInfo = new TPersonInfo
{
workid = entity.workid,
cn_name = entity.name,
org_name = entity.department,
oper_time_str = ""
};
}
}
return(nRet);
}
