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