/// <summary>
/// BTApply对象转为数据库对象
/// </summary>
/// <param name="flag">标志，1为添加，2为修改需要复制修改人信息</param>
/// <returns>T_HR_BusinessTrip数据库对象</returns>
public T_HR_BusinessTrip ToDB(int flag)
{
T_HR_BusinessTrip bt = new T_HR_BusinessTrip();
bt.ID = ID;
bt.StaffID = StaffID;
bt.BTPlace = BTPlace;
bt.StartTime = StartTime;
bt.EndTime = EndTime;
bt.TimeSpan = TimeSpan;
bt.BTReason = BTReason;
bt.Valid = Valid;
bt.Remark = Remark;
bt.CreaterName = CreaterName;
bt.CreateTime = CreateTime;
bt.OperationListID = OperationListID;
if (flag != 1)
{
bt.EditorName = EditorName;
bt.EditeTime = EditeTime;
}
bt.LastID = LastID;
bt.BTEdit = BTEdit;
bt.BTDelete = BTDelete;
bt.EditOrDelete = EditOrDelete;
return(bt);
}
public ActionResult BRSubmit(BTApply businesstrip)
{
DirectResult r = new DirectResult();
string orid = businesstrip.ID;
var prelists = from o in entities.T_HR_BusinessTrip
where o.BTDelete == true && o.LastID == orid
select o;
foreach (T_HR_BusinessTrip item in prelists)
{
T_HR_BusinessTrip prelist = entities.T_HR_BusinessTrip.Find(item.ID);
prelist.BTDelete = false;
}
T_HR_BusinessTrip orlist = entities.T_HR_BusinessTrip.Find(orid);
orlist.BTDelete = true;
orlist.EditOrDelete = "Delete";
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = false;
businesstrip.CreaterName = new LoginUser().EmployeeId;
businesstrip.CreateTime = DateTime.Now;
businesstrip.BTEdit = false;
businesstrip.BTDelete = true;
businesstrip.EditOrDelete = "";
businesstrip.LastID = orid;
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
return(r);
}
public bool GetPreState(string id)
{
T_HR_BusinessTrip last = entities.T_HR_BusinessTrip.Find(id);
bool flag = true;
string opid;
if (Convert.ToBoolean(last.BTEdit))
{
var pre = (from o in entities.T_HR_BusinessTrip
where o.LastID == id && o.BTEdit == true
select o).ToList();
if (pre.Any())
{
opid = pre.First().OperationListID;
var list = from o in entities.T_CH_Operation_list
where o.ID == opid
select o;
if (list.Any())
{
if (list.First().State == 1)
{
flag = false;
}
}
}
}
if (Convert.ToBoolean(last.BTDelete))
{
var pre = (from o in entities.T_HR_BusinessTrip
where o.LastID == id && o.BTDelete == true
select o).ToList();
if (pre.Any())
{
opid = pre.First().OperationListID;
var list = from o in entities.T_CH_Operation_list
where o.ID == opid
select o;
if (list.Any())
{
if (list.First().State == 1)
{
flag = false;
}
}
}
}
return(flag);
}
public ActionResult BESubmit(BTApply businesstrip)
{
try
{
businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
}
catch (FormatException fe)
{
X.Msg.Alert("警告", "日期不正确，请检查！").Show();
return(this.Direct());
}
if (businesstrip.StartTime.Year == businesstrip.EndTime.Year && businesstrip.StartTime.Month == businesstrip.EndTime.Month && businesstrip.StartTime <= businesstrip.EndTime)
{
DirectResult r = new DirectResult();
string orid = businesstrip.ID;
var prelists = from o in entities.T_HR_BusinessTrip
where o.BTEdit == true && o.LastID == orid
select o;
foreach (T_HR_BusinessTrip item in prelists)
{
T_HR_BusinessTrip prelist = entities.T_HR_BusinessTrip.Find(item.ID);
prelist.BTEdit = false;
}
T_HR_BusinessTrip orlist = entities.T_HR_BusinessTrip.Find(orid);
orlist.BTEdit = true;
orlist.EditOrDelete = "Edit";
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = false;
businesstrip.CreaterName = new LoginUser().EmployeeId;
businesstrip.CreateTime = DateTime.Now;
businesstrip.BTEdit = true;
businesstrip.BTDelete = false;
businesstrip.EditOrDelete = "";
businesstrip.LastID = orid;
//businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime);
//businesstrip.TiaoxiuHours = GetTH(businesstrip.StartTime, businesstrip.EndTime);
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
return(r);
}
else
{
X.Msg.Alert("警告", "请假不可跨月！").Show();
return(this.Direct());
}
}
public ActionResult AddOrEditBusinessTrip(BTApply businesstrip)
{
try
{
businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
}
catch (FormatException fe)
{
X.Msg.Alert("警告", "日期不正确，请检查！").Show();
return(this.Direct());
}
if (businesstrip.StartTime.Year == businesstrip.EndTime.Year && businesstrip.StartTime.Month == businesstrip.EndTime.Month && businesstrip.StartTime <= businesstrip.EndTime)
{
DirectResult r = new DirectResult();
T_HR_BusinessTrip businesstripupdate = entities.T_HR_BusinessTrip.Find(businesstrip.ID);
if (businesstripupdate == null)//为空为添加
{
//businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
//businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = true;
businesstrip.CreaterName = new LoginUser().EmployeeId;
businesstrip.CreateTime = DateTime.Now;
businesstrip.BTEdit = false;
businesstrip.BTDelete = false;
//businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime);
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(1));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "保存成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
else//否则为修改
{
//businesstrip.StartTime = Convert.ToDateTime(businesstrip.StartTimeStr);//计算TimeSpan
//businesstrip.EndTime = Convert.ToDateTime(businesstrip.EndTimeStr);
businesstrip.EditorName = new LoginUser().EmployeeId;
businesstrip.EditeTime = DateTime.Now;
businesstripupdate.Valid = false;
businesstrip.ID = Guid.NewGuid().ToString();
businesstrip.OperationListID = Guid.NewGuid().ToString();
businesstrip.Valid = true;
businesstrip.BTEdit = false;
businesstrip.BTDelete = false;
//businesstrip.TimeSpan = GetTimeSpan(businesstrip.StartTime, businesstrip.EndTime);
T_CH_Operation_list newList = new T_CH_Operation_list();
newList.ID = businesstrip.OperationListID;
newList.State = (int)CheckState.Checking;//审核中
newList.Check_flowID = businesstrip.CheckFlowId;
newList.Check_funcID = businesstrip.FuncId;
newList.CreateTime = DateTime.Now;
newList.Creator = new LoginUser().EmployeeId;
newList.Url = Url.Action("CheckBusinessTrip", "BusinessTrip", new { id = businesstrip.ID });
entities.T_HR_BusinessTrip.Add(businesstrip.ToDB(2));
entities.T_CH_Operation_list.Add(newList);
try
{
entities.SaveChanges();
r.Success = true;
X.Msg.Alert("提示", "修改成功！", new JFunction {
Fn = "closewindow"
}).Show();
}
catch (Exception e)
{
X.Msg.Alert("警告", "数据保存失败！<br /> note:" + e.Message, new JFunction {
Fn = "closewindow"
}).Show();
r.Success = false;
}
}
return(r);
}
else
{
X.Msg.Alert("警告", "出差申请不可跨月！").Show();
return(this.Direct());
}
}
