public int AddLeave(LeaveName data)
{
int count = 0;
var query = _DbContext.leavenames.FirstOrDefault(b => b.leaveName == data.leaveName && b.enable == false);
if (query != null)
{
try{
query.enable = true;
query.timeUnit = data.timeUnit;
query.halfVal = (data.timeUnit == 3? data.halfVal : false);
count = _DbContext.SaveChanges();
}catch (Exception e) {
count = ((MySqlException)e.InnerException).Number;
}
}
else
{
count = 1062;
}
if (count == 1)
{
var dic = new Dictionary <string, string> {
};
var opLog = new OperateLog()
{
operateID = data.lastOperaAccID, active = "新增",
category = "請假時間設定", createTime = definePara.dtNow()
};
toNameFn.AddUpLeave_convertToDic(ref dic, data);
opLog.content = toNameFn.AddUpLeave_convertToText(dic);
saveOperateLog(opLog); //紀錄操作紀錄
}
return(count);
}
public void AddUpLeave_convertToDic(ref Dictionary <string, string> Dic, LeaveName data)
{
data = (data == null? new LeaveName() : data);
Dic.Add("leaveName", data.leaveName);
Dic.Add("timeUnit", (data.timeUnit == 1? "全天":data.timeUnit == 2? "半天":"小時"));
Dic.Add("halfVal", (data.halfVal? "半小時" : "一小時"));
}
public int addUpLeave(LeaveName data)
{
data.lastOperaAccID = (int)loginID;
if (data.ID == 0)
{
data.createTime = definePara.dtNow();
return(Repository.AddLeave(data));
}
else
{
data.updateTime = definePara.dtNow();
return(Repository.UpdateLeave(data));
}
}
public void AddUpApplyLeave_convertToDic(ref Dictionary <string, string> Dic, LeaveOfficeApply data)
{
var query = _DbContext.leavenames.FirstOrDefault(b => b.ID == data.leaveID);
if (query == null)
{
query = new LeaveName();
}
data = (data == null? new LeaveOfficeApply() : data);
Dic.Add("note", data.note == null? "無" : data.note);
Dic.Add("sDate", data.startTime.ToString("yyyy-MM-dd HH:mm"));
Dic.Add("eDate", data.endTime.ToString("yyyy-MM-dd HH:mm"));
Dic.Add("applyDate", data.createTime.ToString("yyyy-MM-dd HH:mm"));
Dic.Add("leaveName", query.leaveName);
}
public object addUpLeave(LeaveName data)
{
data.lastOperaAccID = (int)loginID;
var result = 0;
if (data.ID == 0)
{
data.createTime = definePara.dtNow();
result = Repository.AddLeave(data);
}
else
{
data.updateTime = definePara.dtNow();
result = Repository.UpdateLeave(data);
}
return(cudAjaxResult(result));
}
public int UpdateLeave(LeaveName data)
{
var oDic = new Dictionary <string, string> {
};
var nDic = new Dictionary <string, string> {
};
var opLog = new OperateLog()
{
operateID = data.lastOperaAccID, active = "更新",
category = "請假時間設定", createTime = definePara.dtNow()
};
int count = 0;
try{
var context = _DbContext.leavenames.FirstOrDefault(b => b.ID == data.ID);
if (context != null)
{
var query = _DbContext.leavenames.FirstOrDefault(b => b.leaveName == data.leaveName);
if (query == null || query.ID == context.ID)
{
toNameFn.AddUpLeave_convertToDic(ref oDic, context);
context.leaveName = data.leaveName;
context.timeUnit = data.timeUnit;
context.halfVal = (data.timeUnit == 3? data.halfVal : false);
context.lastOperaAccID = data.lastOperaAccID;
context.updateTime = data.updateTime;
count = _DbContext.SaveChanges();
if (count == 1)
{
toNameFn.AddUpLeave_convertToDic(ref nDic, context);
opLog.content = toNameFn.AddUpLeave_convertToText(nDic, oDic);
saveOperateLog(opLog); //紀錄操作紀錄
}
}
else
{
count = 1062;
}
}
}catch (Exception e) {
count = ((MySqlException)e.InnerException).Number;
}
return(count);
}
public void initLeaveNames()
{
var defaultLeaveName = definePara.getDefaultLeaveName();
var query = _DbContext.leavenames.Select(b => b.leaveName).ToArray();
var noExist = defaultLeaveName.Where(b => !query.Contains(b)).ToArray();
for (var i = 0; i < noExist.Length; i++)
{
var id = Array.IndexOf(defaultLeaveName, noExist[i]) + 1;
var data = new LeaveName()
{
ID = id, leaveName = noExist[i], timeUnit = 1, enable = false,
createTime = definePara.dtNow(), updateTime = definePara.dtNow()
};
_DbContext.leavenames.Add(data);
_DbContext.SaveChanges();
}
}
