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