// GET: HR public ActionResult Index(int page = 1) { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { //Log.Error(ex + ex.StackTrace); TempData["SessionExipred"] = "true"; //TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "Login", null)); } MysqlDBA <HRAlloc> dbaHRAlloc = new MysqlDBA <HRAlloc>(FunctionController.CONNSTR); MysqlDBA <UnitAYear> dbaUnitAYear = new MysqlDBA <UnitAYear>(FunctionController.CONNSTR); List <HRAlloc> listData = new List <HRAlloc>(); HRData hrData = new HRData(); try { UnitAYear queryCritUAY = new UnitAYear(); queryCritUAY.INSTNO = Session["INSTNO"].ToString(); queryCritUAY.Year = (DateTime.Now.Year - 1911).ToString(); List <UnitAYear> UAYS = (List <UnitAYear>)dbaUnitAYear.getDataList(queryCritUAY); HRAlloc queryCrit = new HRAlloc(); queryCrit.Year = (DateTime.Now.Year - 1911).ToString(); queryCrit.INSTNO = Session["INSTNO"].ToString(); DataSet ds = dbaHRAlloc.getDataSet(string.Format("SELECT * FROM HRAlloc WHERE Year='{0}' AND INSTNO='{1}'", queryCrit.Year, queryCrit.INSTNO)); foreach (DataRow row in ds.Tables[0].Rows) { HRAlloc data = new HRAlloc(); data.Year = row["Year"].ToString(); data.INSTNO = row["INSTNO"].ToString(); data.HRAllocSerNo = int.Parse(row["HRAllocSerNo"].ToString()); data.JobType = row["JobType"].ToString(); data.PROBG = row["PROBG"].ToString(); data.FullTimeNum = int.Parse(row["FullTimeNum"].ToString()); data.PartTimeNum = int.Parse(row["PartTimeNum"].ToString()); listData.Add(data); } List <CodeBase> codeBaseData = new List <CodeBase>(); codeBaseData = (List <CodeBase>) new MysqlDBA <CodeBase>(FunctionController.CONNSTR).getAllDataList(new CodeBase()); hrData.hrDataList = listData.OrderBy(p => p.HRAllocSerNo).ToPagedList(page == 0 ? 1 : page, DefaultPageSize); if (UAYS.Count > 0) { hrData.YearLeaveCnt = UAYS[0].ResignNum; hrData.YearStartCnt = UAYS[0].CMDBegYearNum; hrData.RateAddCnt = UAYS[0].CMDPeriodAddNum; } TempData["CodeBase"] = codeBaseData; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "HR", null)); } return(View(hrData)); }
public ActionResult Add(HRData data) { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { //Log.Error(ex + ex.StackTrace); TempData["SessionExipred"] = "true"; //TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "Login", null)); } try { MysqlDBA <HRAlloc> mysqlDBA = new MysqlDBA <HRAlloc>(FunctionController.CONNSTR); HRAlloc alloc = new HRAlloc(); alloc.Year = (DateTime.Now.Year - 1911).ToString(); alloc.INSTNO = Session["INSTNO"].ToString(); //-1代表新增,取新流水號 if (data.HRAllocSerNo1 == "-1") { alloc.HRAllocSerNo = Utility.Utility.getHRAllocSerNo(mysqlDBA); alloc.HRAllocSerNo++; } else { //不是-1表修改,帶原來流水號 alloc.HRAllocSerNo = int.Parse(data.HRAllocSerNo1); } alloc.JobType = data.personadmin; alloc.PROBG = data.ProfBackSelect; alloc.FullTimeNum = int.Parse(data.ProfCount); alloc.PartTimeNum = int.Parse(data.BeitCount); alloc.Modifydate = DateTime.Now.ToString("yyyy-MM-dd"); alloc.CreateDate = DateTime.Now.ToString("yyyy-MM-dd"); mysqlDBA.InsertOrUpdate(alloc); TempData["success"] = "OK"; TempData["parentreload"] = "OK"; //alloc } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "HRAdd", null)); } return(RedirectToAction("Index", "HRAdd", null)); }
public ActionResult Index(HRData data) { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { //Log.Error(ex + ex.StackTrace); TempData["SessionExipred"] = "true"; //TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "Login", null)); } UnitAYear unitAYear = new UnitAYear(); MysqlDBA <UnitAYear> mysqlDBA = new MysqlDBA <UnitAYear>(FunctionController.CONNSTR); try { unitAYear.INSTNO = Session["INSTNO"].ToString(); unitAYear.Year = (DateTime.Now.Year - 1911).ToString(); List <UnitAYear> unitAYears = (List <UnitAYear>)mysqlDBA.getDataList(unitAYear); if (unitAYears.Count > 0) { unitAYear = unitAYears[0]; } unitAYear.ResignNum = data.YearLeaveCnt; unitAYear.CMDBegYearNum = data.YearStartCnt; unitAYear.CMDPeriodAddNum = data.RateAddCnt; unitAYear.Modifydate = DateTime.Now.ToString("yyyy-MM-dd"); if (!string.IsNullOrEmpty(unitAYear.EvalDate)) { unitAYear.EvalDate = DateTime.Parse(unitAYear.EvalDate).ToString("yyyy-MM-dd"); } if (!string.IsNullOrEmpty(unitAYear.CreateDate)) { unitAYear.CreateDate = DateTime.Parse(unitAYear.CreateDate).ToString("yyyy-MM-dd"); } unitAYear.ModifyUser = Session["AccountNo"].ToString(); mysqlDBA.InsertOrUpdate(unitAYear); } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "HR", null)); } return(RedirectToAction("Index", "CaseListCount", null)); }