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 })); }