public static List <InstScoreTable> getInstScore(string INSTNO, string itemNo, string evalYear) { List <InstScoreTable> listData = new List <InstScoreTable>(); try { MysqlDBA <InstScoreTable> dbaHRAlloc = new MysqlDBA <InstScoreTable>(FunctionController.CONNSTR); DataSet ds = dbaHRAlloc.getDataSet(string.Format("SELECT * FROM InstScoreTable WHERE INSTNO='{0}' AND EvalYear='{1}' AND ItemNo='{2}'", INSTNO, evalYear, itemNo)); foreach (DataRow row in ds.Tables[0].Rows) { InstScoreTable data = new InstScoreTable(); data.EvalYear = row["EvalYear"].ToString(); data.INSTNO = row["INSTNO"].ToString(); data.ItemNo = row["ItemNo"].ToString(); data.SelfScore = row["SelfScore"].ToString(); data.EvalScore = row["EvalScore"].ToString(); data.EvalDesc = row["EvalDesc"].ToString(); data.EvalDate = row["EvalDate"].ToString(); data.SelfDate = row["SelfDate"].ToString(); listData.Add(data); } } catch (Exception ex) { throw ex; } return(listData); }
public static List <HRAlloc> getHRAlloc(HRAlloc hRAlloc) { List <HRAlloc> listData = new List <HRAlloc>(); try { MysqlDBA <HRAlloc> dbaHRAlloc = new MysqlDBA <HRAlloc>(FunctionController.CONNSTR); DataSet ds = dbaHRAlloc.getDataSet(string.Format("SELECT * FROM HRAlloc WHERE Year='{0}' AND INSTNO='{1}'", hRAlloc.Year, hRAlloc.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); } } catch (Exception ex) { throw ex; } return(listData); }
internal static string getAreaDDL(string city, string tagName, string selectedValue) { string ddl = string.Empty; try { Dictionary <string, string> optionData = new Dictionary <string, string>(); MysqlDBA <AreaBase> mysqlDBA = new MysqlDBA <AreaBase>(FunctionController.CONNSTR); AreaBase area = new AreaBase(); area.CityCode = city; List <AreaBase> areaBases = (List <AreaBase>)mysqlDBA.getDataListNoKey(area); if (areaBases.Count > 0) { foreach (AreaBase areaBase in areaBases) { optionData.Add(areaBase.AreaCode, areaBase.AreaName); } ddl = DropDownListHelper.GetDropdownList(tagName, optionData, null, selectedValue, true, null); } } catch (Exception ex) { throw ex; } return(ddl); }
// GET: CommitteeMember public ActionResult Index(int page = 1) { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { //Log.Error(ex + ex.StackTrace); TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } CommitteeMember cm = new CommitteeMember(); try { MysqlDBA <CommINSTYear> mysqlDBA = new MysqlDBA <CommINSTYear>(FunctionController.CONNSTR); CommINSTYear queryCrit = new CommINSTYear(); queryCrit.ACommNo = Session["INSTNO"].ToString(); List <CommINSTYear> commINSTYears = (List <CommINSTYear>)mysqlDBA.getDataListNoKey(queryCrit); queryCrit = new CommINSTYear(); queryCrit.BCommNo = Session["INSTNO"].ToString(); commINSTYears.AddRange((List <CommINSTYear>)mysqlDBA.getDataListNoKey(queryCrit)); cm.INSTList = commINSTYears.OrderBy(p => p.INSTNO).ToPagedList(page, DefaultPageSize); } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "committee"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "CommitteeMember", null)); } TempData["action"] = "committee"; return(View(cm)); }
internal static List <AttrBase> getAttrList(AttrBase.TypeList type) { List <AttrBase> retObj = new List <AttrBase>(); try { MysqlDBA <AttrBase> mysqlDBA = new MysqlDBA <AttrBase>(FunctionController.CONNSTR); AttrBase attrBase = new AttrBase(); switch (type) { case AttrBase.TypeList.Medical: attrBase.AttrType = "1"; break; case AttrBase.TypeList.Longterm: attrBase.AttrType = "2"; break; case AttrBase.TypeList.Other: attrBase.AttrType = "3"; break; } retObj = (List <AttrBase>)mysqlDBA.getDataListNoKey(attrBase); } catch (Exception ex) { throw ex; } return(retObj); }
public ActionResult Delete(string year, string INSTNO, string HRAllocSerNo) { try { 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)); } HRAlloc queryCrit = new HRAlloc(); queryCrit.Year = year; queryCrit.INSTNO = INSTNO; queryCrit.HRAllocSerNo = int.Parse(HRAllocSerNo); MysqlDBA <HRAlloc> mysqlDBA = new MysqlDBA <HRAlloc>(FunctionController.CONNSTR); mysqlDBA.Delete(queryCrit); TempData["success"] = "OK"; TempData["parentreload"] = "OK"; } 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)); }
// GET: HRAdd public ActionResult Index() { try { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } MysqlDBA <CodeBase> mysqlDBA = new MysqlDBA <CodeBase>(FunctionController.CONNSTR); CodeBase queryCrit = new CodeBase(); queryCrit.CodeTable = "HRAlloc"; queryCrit.CodeField = "ProfBack"; List <CodeBase> objLst = (List <CodeBase>)mysqlDBA.getDataList(queryCrit); TempData["CodeBase"] = objLst; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "HRAdd", null)); } return(View()); }
public ActionResult Delete(string MSerNo) { try { 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)); } UnitAMeeting queryCrit = new UnitAMeeting(); queryCrit.MSerialNo = int.Parse(MSerNo); MysqlDBA <UnitAMeeting> mysqlDBA = new MysqlDBA <UnitAMeeting>(FunctionController.CONNSTR); mysqlDBA.Delete(queryCrit); TempData["success"] = "OK"; TempData["parentreload"] = "OK"; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "MeetingAdd", null)); } return(RedirectToAction("Index", "MeetingAdd", null)); }
public ActionResult Index() { //if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) //{ // TempData["SessionExipred"] = "true"; // return RedirectToAction("Index", "Login", null); //} List <LatestNews> ViewModel = new List <LatestNews>(); List <MessageRec> dataSet = null; //List<AccountBase> retObj = null; try { MysqlDBA <MessageRec> mysqlDBA = new MysqlDBA <MessageRec>(FunctionController.CONNSTR); MessageRec messageRec = new MessageRec(); dataSet = (List <MessageRec>)mysqlDBA.getAllDataList(messageRec); dataSet.ForEach(obj => { LatestNews obj1 = new LatestNews(); obj1.MsgSerialNo = obj.MsgSerialNo.ToString(); obj1.MsgSub = obj.MsgSub; obj1.Attachs = obj.Attachs; obj1.CreateDate = obj.CreateDate; ViewModel.Add(obj1); }); TempData["action"] = "latest"; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "latest"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "Home", null)); } return(View(ViewModel)); }
// GET: LatestNews public ActionResult Index(string MsgSerialNo) { LatestNews model = new LatestNews(); try { //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 <MessageRec> mysqlDBA = new MysqlDBA <MessageRec>(FunctionController.CONNSTR); MessageRec messageRec = new MessageRec(); messageRec.MsgSerialNo = int.Parse(MsgSerialNo); messageRec = Utility.Utility.getUniqueMessageRec(Utility.Utility.getMessageDataSet(mysqlDBA, messageRec));// (List<MessageRec>)mysqlDBA.getDataSet(string.Format("SELECT * FROM ")); model.MsgData = messageRec.MsgData; model.MsgSerialNo = messageRec.MsgSerialNo.ToString(); model.MsgSub = messageRec.MsgSub; model.Attachs = messageRec.Attachs; model.CreateDate = messageRec.CreateDate; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "latest"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "Home", null)); } return(View(model)); }
// 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(MeetingView data) { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } try { MysqlDBA <UnitAMeeting> mysqlDBA = new MysqlDBA <UnitAMeeting>(FunctionController.CONNSTR); UnitAMeeting alloc = new UnitAMeeting(); alloc.Year = data.year; alloc.INSTNO = Session["INSTNO"].ToString(); //-1代表新增,取新流水號 if (data.MSerial == "-1" || string.IsNullOrEmpty(data.MSerial)) { alloc.MSerialNo = Utility.Utility.getMeetingSerNo(mysqlDBA); alloc.MSerialNo++; } else { //不是-1表修改,帶原來流水號 alloc.MSerialNo = int.Parse(data.MSerial); } alloc.MType = "2"; string verifyDateResult = Utility.Utility.verifyDate(data.date); if (verifyDateResult == "DateError") { TempData["error"] = "日期格式錯誤,需為民國年/月月/日日 如:109/09/08"; return(RedirectToAction("Index", "CaseDiscussAdd", null)); } alloc.MDate = Utility.Utility.convertROC2UDTDateFormat(data.date); alloc.Topic = data.topic; alloc.ProfCnt = int.Parse(string.IsNullOrEmpty(data.profcnt) ? "0" : data.profcnt); alloc.AttendNum = int.Parse(string.IsNullOrEmpty(data.attend) ? "0" :data.attend); alloc.ModifyDate = DateTime.Now.ToString("yyyy-MM-dd"); alloc.CreateDate = DateTime.Parse(alloc.CreateDate == null ? DateTime.Now.ToString("yyyy-MM-dd") : alloc.CreateDate).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", "CaseDiscussAdd", null)); } return(RedirectToAction("Index", "CaseDiscussAdd")); }
internal static DataSet getMessageDataSet(MysqlDBA <MessageRec> mysqlDBA, MessageRec messageRec) { DataSet dataSet = new DataSet(); try { dataSet = mysqlDBA.getDataSet(string.Format("SELECT * FROM MessageRec WHERE MsgSerialNo={0}", messageRec.MsgSerialNo)); } catch (Exception ex) { throw ex; } return(dataSet); }
public ActionResult Add(SupportUnitAdd data) { try { 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 <UnitAToBSum> mysqlDBA = new MysqlDBA <UnitAToBSum>(FunctionController.CONNSTR); UnitAToBSum alloc = new UnitAToBSum(); alloc.Year = (DateTime.Now.Year - 1911).ToString(); alloc.INSTNO = Session["INSTNO"].ToString(); //-1代表新增,取新流水號 if (data.TrSeialNo1 == "-1") { alloc.TrSeialNo = Utility.Utility.getUnitAToBSumSerNo(mysqlDBA); alloc.TrSeialNo++; } else { //不是-1表修改,帶原來流水號 alloc.TrSeialNo = int.Parse(data.TrSeialNo1); } alloc.INSTNO = Session["INSTNO"].ToString(); alloc.LCareType = data.ServiceType; alloc.UnitBNo = data.INSTNO; alloc.UnitBName = data.INSTName; alloc.TrCaseNum = data.CaseNo; //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", "SupportUnitAdd", null)); } return(RedirectToAction("Index", "SupportUnit", null)); }
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)); }
// GET: SelfRate public ActionResult Index() { try { 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 <ScoreItem> mysqlDBA = new MysqlDBA <ScoreItem>(FunctionController.CONNSTR); //MysqlDBA<InstScoreTable> mysqlDBAInstScoreTable = new MysqlDBA<InstScoreTable>(FunctionController.CONNSTR); List <ScoreItem> lstScoreItem = new List <ScoreItem>(); DataSet scoreItemsdateSet = mysqlDBA.getDataSet(string.Format("SELECT * FROM ScoreItem WHERE ItemParentNo='-1'")); List <InstScoreTable> instScoreTables = Utility.Utility.getInstScore(Session["INSTNO"].ToString(), (DateTime.Now.Year - 1911).ToString()); foreach (DataRow scoreItem in scoreItemsdateSet.Tables[0].Rows) { ScoreItem score_Item = new ScoreItem(); score_Item.ItemNo = scoreItem["ItemNo"].ToString(); score_Item.ItemParentNo = scoreItem["ItemParentNo"].ToString(); score_Item.ItemDesc = scoreItem["ItemDesc"].ToString(); score_Item.ItemGrade = scoreItem["ItemGrade"].ToString(); score_Item.ItemScore = scoreItem["ItemScore"].ToString(); score_Item.EvalYear = scoreItem["EvalYear"].ToString(); score_Item.EvalType = scoreItem["EvalType"].ToString(); score_Item.CreateDate = scoreItem["CreateDate"].ToString(); score_Item.getChildItem(Session["INSTNO"].ToString(), score_Item.ItemNo); lstScoreItem.Add(score_Item); if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } } TempData["ScoreItems"] = lstScoreItem; TempData["InstScores"] = instScoreTables; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "SelfRate", null)); } return(View()); }
public ActionResult Edit(string year, string INSTNO, string HRAllocSerNo) { try { 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)); } List <HRAlloc> listData = new List <HRAlloc>(); HRAlloc queryCrit = new HRAlloc(); queryCrit.Year = year; queryCrit.INSTNO = INSTNO; queryCrit.HRAllocSerNo = int.Parse(HRAllocSerNo); MysqlDBA <HRAlloc> mysqlDBA = new MysqlDBA <HRAlloc>(FunctionController.CONNSTR); DataSet ds = mysqlDBA.getDataSet(string.Format("SELECT * FROM HRAlloc WHERE Year='{0}' AND INSTNO='{1}' AND HRAllocSerNo = '{2}'", queryCrit.Year, queryCrit.INSTNO, queryCrit.HRAllocSerNo)); 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); } TempData["HRAlloc"] = listData; List <CodeBase> codeBaseData = new List <CodeBase>(); codeBaseData = (List <CodeBase>) new MysqlDBA <CodeBase>(FunctionController.CONNSTR).getAllDataList(new CodeBase()); 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(RedirectToAction("Index", "HRAdd", null)); }
public ActionResult Edit(string year, string INSTNO, string TrSeialNo1) { try { 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)); } List <UnitAToBSum> listData = new List <UnitAToBSum>(); UnitAToBSum queryCrit = new UnitAToBSum(); queryCrit.Year = year; queryCrit.INSTNO = INSTNO; queryCrit.TrSeialNo = int.Parse(TrSeialNo1); MysqlDBA <UnitAToBSum> mysqlDBA = new MysqlDBA <UnitAToBSum>(FunctionController.CONNSTR); DataSet ds = mysqlDBA.getDataSet(string.Format("SELECT * FROM UnitAToBSum WHERE Year='{0}' AND INSTNO='{1}' AND TrSeialNo = '{2}'", queryCrit.Year, queryCrit.INSTNO, queryCrit.TrSeialNo)); foreach (DataRow row in ds.Tables[0].Rows) { UnitAToBSum data = new UnitAToBSum(); data.Year = row["Year"].ToString(); data.INSTNO = row["INSTNO"].ToString(); data.TrSeialNo = int.Parse(row["TrSeialNo"].ToString()); data.LCareType = row["LCareType"].ToString(); data.UnitBNo = row["UnitBNo"].ToString(); data.UnitBName = row["UnitBName"].ToString(); data.TrCaseNum = row["TrCaseNum"].ToString(); listData.Add(data); } TempData["UnitAToBSum"] = listData; List <CodeBase> codeBaseData = new List <CodeBase>(); codeBaseData = (List <CodeBase>) new MysqlDBA <CodeBase>(FunctionController.CONNSTR).getAllDataList(new CodeBase()); TempData["CodeBase"] = codeBaseData; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "SupportUnit", null)); } return(RedirectToAction("Index", "SupportUnitAdd", null)); }
public ActionResult Calc(FormCollection formData) { MysqlDBA <InstScoreTable> mysqlDBA = new MysqlDBA <InstScoreTable>(FunctionController.CONNSTR); try { if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } string accountNo = Session["INSTNO"].ToString(); string year = (DateTime.Now.Year - 1911).ToString(); InstScoreTable instScore = new InstScoreTable(); foreach (var key in formData.AllKeys) { if (key.IndexOf("Score") != -1) { string value = formData[key].ToString(); if (!string.IsNullOrEmpty(value)) { double score = double.Parse(value); instScore = new InstScoreTable(); instScore.EvalYear = year; instScore.INSTNO = accountNo; instScore.ItemNo = key.Replace("Score", ""); instScore.SelfScore = score.ToString(); instScore.SelfDate = DateTime.Now.ToString("yyyy-MM-dd"); instScore.EvalScore = "0"; instScore.EvalDate = "1900-01-01"; mysqlDBA.InsertOrUpdate(instScore); } } } } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; return(RedirectToAction("Index", "SelfRate", null)); } return(RedirectToAction("Index", "Meeting")); }
// GET: Meeting public ActionResult Edit(string MSerNo) { try { 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)); } List <UnitAMeeting> listData = new List <UnitAMeeting>(); UnitAMeeting queryCrit = new UnitAMeeting(); queryCrit.MSerialNo = int.Parse(MSerNo); MysqlDBA <UnitAMeeting> mysqlDBA = new MysqlDBA <UnitAMeeting>(FunctionController.CONNSTR); DataSet ds = mysqlDBA.getDataSet(string.Format("SELECT * FROM UnitAMeeting WHERE MSerialNo = '{0}'", queryCrit.MSerialNo)); foreach (DataRow row in ds.Tables[0].Rows) { UnitAMeeting data = new UnitAMeeting(); data.Year = row["Year"].ToString(); data.INSTNO = row["INSTNO"].ToString(); data.MSerialNo = int.Parse(row["MSerialNo"].ToString()); data.MType = row["MType"].ToString(); data.MDate = Utility.Utility.convertUDT2ROCDateFormat(DateTime.Parse(row["MDate"].ToString()).ToString("MM/dd/yyyy")); data.Topic = row["Topic"].ToString(); data.AttendNum = int.Parse(row["AttendNum"].ToString()); data.ProfCnt = int.Parse(row["ProfCnt"].ToString()); data.CreateDate = row["CreateDate"].ToString(); data.ModifyDate = row["ModifyDate"].ToString(); listData.Add(data); } TempData["UnitAMeeting"] = listData; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "Meeting", null)); } return(RedirectToAction("Index", "MeetingAdd", null)); }
private static List <ScoreItem> getAllScoreItems() { if (SCORE_ITEMS != null) { return(SCORE_ITEMS); } List <ScoreItem> retObj = new List <ScoreItem>(); try { MysqlDBA <ScoreItem> dba = new MysqlDBA <ScoreItem>(FunctionController.CONNSTR); retObj = (List <ScoreItem>)dba.getAllDataList(new ScoreItem()); } catch (Exception ex) { throw ex; } return(retObj); }
public static List <CaseSvrEff> getCaseSvrEff(string year, string yearMonth, string INSTNO, string code) { List <CaseSvrEff> strRet = new List <CaseSvrEff>(); try { MysqlDBA <CaseSvrEff> dba = new MysqlDBA <CaseSvrEff>(FunctionController.CONNSTR); CaseSvrEff queryCrit = new CaseSvrEff(); queryCrit.Year = year; queryCrit.YM = yearMonth; queryCrit.INSTNO = INSTNO; queryCrit.SvrType = code; strRet = (List <CaseSvrEff>)dba.getDataList(queryCrit); } catch (Exception ex) { throw ex; } return(strRet); }
// GET: SupportUnit public ActionResult Index(int page = 1) { List <UnitAToBSum> listData = new List <UnitAToBSum>(); SupportUnitAdd model = new SupportUnitAdd(); try { 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 <UnitAToBSum> dbaHRAlloc = new MysqlDBA <UnitAToBSum>(FunctionController.CONNSTR); UnitAToBSum queryCrit = new UnitAToBSum(); queryCrit.Year = (DateTime.Now.Year - 1911).ToString(); if (Session["INSTNO"] == null || string.IsNullOrEmpty(Session["INSTNO"].ToString())) { TempData["SessionExipred"] = "true"; return(RedirectToAction("Index", "Login", null)); } queryCrit.INSTNO = Session["INSTNO"].ToString(); listData = (List <UnitAToBSum>)dbaHRAlloc.getDataList(queryCrit); model.SupportUnits = listData.OrderBy(p => p.TrSeialNo).ToPagedList(page, defaultPageSize); List <CodeBase> codeBaseData = new List <CodeBase>(); codeBaseData = (List <CodeBase>) new MysqlDBA <CodeBase>(FunctionController.CONNSTR).getAllDataList(new CodeBase()); //TempData["UnitAToBSumList"] = listData; TempData["CodeBase"] = codeBaseData; } catch (Exception ex) { Log.Error(ex + ex.StackTrace); TempData["action"] = "Function"; TempData["error"] = ex + ex.StackTrace; //tran.Rollback(); return(RedirectToAction("Index", "SupportUnit", null)); } return(View(model)); }
public static string getScoreTitle(string itemNo) { string strRet = string.Empty; try { MysqlDBA <ScoreItem> mysqlDBA_AttrBase = new MysqlDBA <ScoreItem>(FunctionController.CONNSTR); ScoreItem baseattr = new ScoreItem(); baseattr.ItemNo = itemNo; List <ScoreItem> objLst = (List <ScoreItem>)mysqlDBA_AttrBase.getDataList(baseattr); if (objLst.Count > 0) { strRet = objLst[0].ItemDesc; } } catch (Exception ex) { throw ex; } return(strRet); }
public static string getBaseAttr(string attrMed) { string strRet = string.Empty; try { MysqlDBA <AttrBase> mysqlDBA_AttrBase = new MysqlDBA <AttrBase>(FunctionController.CONNSTR); AttrBase baseattr = new AttrBase(); baseattr.AttrCode = attrMed; List <AttrBase> objLst = (List <AttrBase>)mysqlDBA_AttrBase.getDataList(baseattr); if (objLst.Count > 0) { strRet = objLst[0].AttrName; } } catch (Exception ex) { throw ex; } return(strRet); }
public static string getINSTName(string INSTNO) { string strRet = string.Empty; try { MysqlDBA <INSTBase> mysqlDBA_AttrBase = new MysqlDBA <INSTBase>(FunctionController.CONNSTR); INSTBase baseattr = new INSTBase(); baseattr.INSTNO = INSTNO; List <INSTBase> objLst = (List <INSTBase>)mysqlDBA_AttrBase.getDataList(baseattr); if (objLst.Count > 0) { strRet = objLst[0].INSTName; } } catch (Exception ex) { throw ex; } return(strRet); }
public string getBaseAttrCode(string medInst) { string strRet = string.Empty; try { MysqlDBA <AttrBase> mysqlDBA_AttrBase = new MysqlDBA <AttrBase>(CONNSTR); AttrBase baseattr = new AttrBase(); baseattr.AttrCode = medInst; List <AttrBase> objLst = (List <AttrBase>)mysqlDBA_AttrBase.getDataListNoKey(baseattr); if (objLst.Count > 0) { strRet = objLst[0].AttrCode; } } catch (Exception ex) { throw ex; } return(strRet); }
internal static string getAreaCode(string area) { string areaCode = string.Empty; try { MysqlDBA <AreaBase> mysqlDBA = new MysqlDBA <AreaBase>(FunctionController.CONNSTR); AreaBase queryCrit = new AreaBase(); queryCrit.AreaName = area; List <AreaBase> listr = (List <AreaBase>)mysqlDBA.getDataListNoKey(queryCrit); if (listr.Count > 0) { areaCode = listr[0].AreaCode; } } catch (Exception ex) { throw ex; } return(areaCode); }
internal static string getCityCode(string city) { string cityCode = string.Empty; try { MysqlDBA <CityBase> mysqlDBA = new MysqlDBA <CityBase>(FunctionController.CONNSTR); CityBase queryCrit = new CityBase(); queryCrit.CityName = city; List <CityBase> listr = (List <CityBase>)mysqlDBA.getDataListNoKey(queryCrit); if (listr.Count > 0) { cityCode = listr[0].CityCode; } } catch (Exception ex) { throw ex; } return(cityCode); }