private void ddlDB_SelectedIndexChanged(object sender, EventArgs e)
{
int dbid = ddlDB.SelectedValue.ToString().ToLower() == "select" ? 0 : Convert.ToInt32(ddlDB.SelectedValue);
string manid = Program.ManInfo.Man.ManID;
Program.DBID = dbid;
BusProject project = SqlBaseProvider.GetBusProjectByDB(dbid);
Program.ProjectCode = project.ProjectCode;
CtrlHelper.SetDropDownList(ddlTable, SqlBaseProvider.GetTableNoPmtByDB(dbid), DropAddType.New, DropAddFlag.Select, String.Empty, "TableName,TableCode");
pTable.OnInit();
txtSet.Text = String.Empty;
txtResult.Text = String.Empty;
txtPackage.Text = String.Empty;
txtPrefix.Text = String.Empty;
txtCatalog.Text = String.Empty;
txtClassName.Text = String.Empty;
txtValue.Text = String.Empty;
BusHours hours = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (hours != null)
{
isHours = true;
}
else
{
isHours = false;
}
}
private void btnExit_Click(object sender, EventArgs e)
{
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
}
this.Close();
}
private void MainForm_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
SqlBaseProvider.LoginOutSysOnline(Program.ManInfo.Man.ManID, Program.ManInfo.Register.RegID);
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
}
}
catch (Exception)
{
}
}
private void MybatisCode_FormClosing(object sender, FormClosingEventArgs e)
{
try
{
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
Program.DBID = -1;
}
}
catch (Exception)
{
}
}
private void tmTime_Tick(object sender, EventArgs e)
{
sslTime.Text = " 当前时间：" + DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
string NowDate = DateTime.Now.ToString("yyyy-MM-dd");
if (Program.LoginDate != NowDate)
{
BusHours item = SqlBaseProvider.GetHoursByDB(Program.DBID, Program.ManInfo.Man.ManID, Program.LoginDate);
if (item != null)
{
item.DBID = Program.DBID;
item.ManID = Program.ManInfo.Man.ManID;
item.WorkEnd = Convert.ToDateTime(Program.LoginDate + " 23:59:59");
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Update);
Program.LoginDate = NowDate;
// 跨天的情况，将WorkEnd作为临时变量，传递到后台，判断过12点后是否有打卡记录，如果没有，则会补打
item.WorkEnd = Convert.ToDateTime(Program.LoginDate);
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Create);
}
}
}
private void btnWork_Click(object sender, EventArgs e)
{
try
{
if (ddlDB.SelectedValue.ToString().ToLower() == "select")
{
Global.ShowSysInfo("请选择数据库！");
return;
}
BusHours item = new BusHours();
item.DBID = ddlDB.SelectedValue.ToString().ToLower() == "select" ? 0 : Convert.ToInt32(ddlDB.SelectedValue);
item.ManID = Program.ManInfo.Man.ManID;
item.WorkEnd = DateTime.Now;
SqlBaseProvider.SaveBusHours(item, DataProviderAction.Create);
isHours = true;
Global.ShowSysInfo("打卡成功！");
}
catch (Exception)
{
throw;
}
}
public IActionResult CreateBizHours(BusHoursViewModel NewBizHrsVM, int biz_id)
{
if (checkLogStatus() == false)
{
return(RedirectToAction("Index", "Home"));
}
if (ModelState.IsValid)
{
// Confirm the business does not already have a 1:1 hours record
try
{
BusHours CheckHours = _context.Hours.SingleOrDefault(biz => biz.BusinessId == biz_id);
if (CheckHours != null)
{
// the business already has an existing hours record
// update the record instead of creating a new one
BusHours updateBizHours = new BusHours(NewBizHrsVM);
CheckHours.AlwaysOpen = updateBizHours.AlwaysOpen;
CheckHours.FriClosed = updateBizHours.FriClosed;
CheckHours.FriCloseTime = updateBizHours.FriCloseTime;
CheckHours.FriOpenTime = updateBizHours.FriOpenTime;
CheckHours.MonClosed = updateBizHours.MonClosed;
CheckHours.MonCloseTime = updateBizHours.MonCloseTime;
CheckHours.MonOpenTime = updateBizHours.MonOpenTime;
CheckHours.SatClosed = updateBizHours.SatClosed;
CheckHours.SatCloseTime = updateBizHours.SatCloseTime;
CheckHours.SatOpenTime = updateBizHours.SatOpenTime;
CheckHours.SunClosed = updateBizHours.SunClosed;
CheckHours.SunCloseTime = updateBizHours.SunCloseTime;
CheckHours.SunOpenTime = updateBizHours.SunOpenTime;
CheckHours.ThuClosed = updateBizHours.ThuClosed;
CheckHours.ThuCloseTime = updateBizHours.ThuCloseTime;
CheckHours.ThuOpenTime = updateBizHours.ThuOpenTime;
CheckHours.TueClosed = updateBizHours.TueClosed;
CheckHours.TueCloseTime = updateBizHours.TueCloseTime;
CheckHours.TueOpenTime = updateBizHours.TueOpenTime;
CheckHours.WedClosed = updateBizHours.WedClosed;
CheckHours.WedCloseTime = updateBizHours.WedCloseTime;
CheckHours.WedOpenTime = updateBizHours.WedOpenTime;
CheckHours.UpdatedAt = DateTime.Now;
_context.SaveChanges();
return(RedirectToAction("ViewBiz", new { biz_id = biz_id }));
// AddBusHoursError(biz_id);
// return RedirectToAction("NewBizHours");
}
}
catch (Exception ex)
{
// there were not any existing businesses with the same name
// proceed with code
}
BusHours newBizHours = new BusHours(NewBizHrsVM);
newBizHours.BusinessId = biz_id;
_context.Hours.Add(newBizHours);
_context.SaveChanges();
}
else
{
return(RedirectToAction("NewBizHours"));
}
return(RedirectToAction("ViewBiz", new { biz_id = biz_id }));
}
