public ActionResult StartRoutine(int teachingRoutineID)
{
DateTime currDate = DateTime.Now.Date;
int currUserID = CurrentUser.GetUserID();
using (FATContainer dataContainer = new FATContainer())
{
TeachingRoutine tchRoutine = SharedCasePool.GetCasePool().GetRoutine(teachingRoutineID);
TeachingNode firstNode = tchRoutine.NodeList[tchRoutine.NodeList.Keys[0]];
StudentActivity activity = dataContainer.StudentActivity.FirstOrDefault(act => (act.UserID == currUserID) && (act.TimeMark >= currDate) && (act.TchRoutineID == teachingRoutineID));
if (activity == null)
{
activity = dataContainer.StudentActivity.Create();
}
activity.TchNodeID = firstNode.Row_ID;
activity.IsFinished = 0;
activity.TchRoutineID = teachingRoutineID;
activity.UserID = CurrentUser.GetUserID();
activity.TimeMark = DateTime.Now.Date;
if (activity.Row_ID == 0)
{
dataContainer.StudentActivity.Add(activity);
dataContainer.SaveChanges();
}
else
{
dataContainer.Entry <StudentActivity>(activity).CurrentValues.SetValues(activity);
dataContainer.SaveChanges();
}
JsonResult result = new JsonResult();
result.Data = string.Format("{0}/{1}/{2}", firstNode.NodeType, firstNode.NodeTag, firstNode.Row_ID);
return(result);
}
}
public ActionResult GetNextNode(int teachingRoutineID, int teachingNodeID)
{
using (FATContainer dataContainer = new FATContainer())
{
TeachingNode nextNode = SharedCasePool.GetCasePool().NavigateToNextNode(teachingRoutineID, teachingNodeID);
StudentActivity activity = dataContainer.StudentActivity.FirstOrDefault(act => act.UserID == CurrentUser.GetUserID() && act.TimeMark == DateTime.Now.Date && act.TchRoutineID == teachingRoutineID);
if (activity == null)
{
activity = dataContainer.StudentActivity.Create();
}
JsonResult result = new JsonResult();
if (nextNode == null)
{
CurrentUser.SetLastFinishedRoutineID(teachingRoutineID);
result.Data = "/Teachings/TeachingInit/SelectT1Case";
if (activity.Row_ID == 0)
{
activity.TchNodeID = -1;
activity.IsFinished = 1;
activity.TchRoutineID = teachingRoutineID;
activity.UserID = CurrentUser.GetUserID();
activity.TimeMark = DateTime.Now.Date;
dataContainer.StudentActivity.Add(activity);
dataContainer.SaveChanges();
}
else
{
activity.TchNodeID = -1;
activity.IsFinished = 1;
dataContainer.Entry <StudentActivity>(activity).CurrentValues.SetValues(activity);
dataContainer.SaveChanges();
}
}
else
{
TeachingRoutine routine = SharedCasePool.GetCasePool().GetRoutine(teachingNodeID);
if (routine.NodeList.Keys.IndexOf(activity.TchNodeID) < routine.NodeList.Keys.IndexOf(nextNode.Row_ID))
{
activity.TchNodeID = nextNode.Row_ID;
activity.IsFinished = 0;
//dataContainer.Entry<StudentActivity>(activity).CurrentValues.SetValues(activity);
dataContainer.SaveChanges();
}
result.Data = string.Format("{0}/{1}/{2}", nextNode.NodeType, nextNode.NodeTag, nextNode.Row_ID);
}
return(result);
}
}
public ActionResult InitIndividualSavingData()
{
using (FATContainer dataContainer = new FATContainer())
{
int tchRoutineID = Convert.ToInt32(RouteData.Values["tchRoutineID"]);
TeachingRoutine routine = SharedCasePool.GetCasePool().GetRoutine(tchRoutineID);
//all tags: DWHQ_Deposit DWHQ_Withdraw DWHQ_Interest DWHQ_Clear DWZZ_Deposit DWZZ_Withdraw DWLZ_Deposit DWLZ_Withdraw DWZL_Deposit DWZL_Withdraw DWZL_Interest DWTI_Deposit DWTI_Interest DWTI_Withdraw
//Section controls which section should be displayed and filled
ViewBag.Section = routine.RelTmpRoutine.RoutineTag.Split('_')[1];
IndividualSaving info = dataContainer.IndividualSaving.FirstOrDefault(item => (item.TchRoutineID == tchRoutineID));
if (info == null)
{
info = dataContainer.IndividualSaving.Create();
info.TchRoutineID = tchRoutineID;
info.AccountCreateTime = DateTime.Now;
info.DepositTime = DateTime.Now;
info.WithdrawTime = DateTime.Now;
info.InterestTime = DateTime.Now;
dataContainer.IndividualSaving.Add(info);
dataContainer.SaveChanges();
}
return(View("IndividualSaving", info));
}
}
public ActionResult AppendSubjectItem(SubjectItem subject)
{
using (FATContainer dbContainer = new FATContainer())
{
dbContainer.SubjectItem.Add(subject);
dbContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = subject;
return(result);
}
}
public ActionResult DetailedLedger_Insert(DetailedLedger info)
{
using (FATContainer dataContainer = new FATContainer())
{
dataContainer.DetailedLedger.Add(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult OuterSubject_Insert(OuterSubject info)
{
using (FATContainer dataContainer = new FATContainer())
{
dataContainer.OuterSubject.Add(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult CashJournal_Insert(CashJournal info)
{
using (FATContainer dataContainer = new FATContainer())
{
dataContainer.CashJournal.Add(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult AppendCase(TeachingRoutine routine)
{
using (FATContainer dataContainer = new FATContainer())
{
dataContainer.TeachingRoutine.Add(routine);
dataContainer.SaveChanges();
}
JsonResult result = new JsonResult();
result.Data = routine;
return(result);
}
public ActionResult DetailedLedger_Update(DetailedLedger info)
{
using (FATContainer dataContainer = new FATContainer())
{
DetailedLedger existedInfo = dataContainer.DetailedLedger.FirstOrDefault(item => item.Row_ID == info.Row_ID);
dataContainer.Entry <DetailedLedger>(existedInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult DetailedLedger_Delete(int glRowID)
{
using (FATContainer dataContainer = new FATContainer())
{
DetailedLedger dlInfo = dataContainer.DetailedLedger.FirstOrDefault(item => item.Row_ID == glRowID);
dataContainer.DetailedLedger.Remove(dlInfo);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult OuterSubject_Update(OuterSubject info)
{
using (FATContainer dataContainer = new FATContainer())
{
OuterSubject existedInfo = dataContainer.OuterSubject.FirstOrDefault(item => item.Row_ID == info.Row_ID);
dataContainer.Entry <OuterSubject>(existedInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult OuterSubject_Delete(int glRowID)
{
using (FATContainer dataContainer = new FATContainer())
{
OuterSubject osInfo = dataContainer.OuterSubject.FirstOrDefault(item => item.Row_ID == glRowID);
dataContainer.OuterSubject.Remove(osInfo);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult CashJournal_Update(CashJournal info)
{
using (FATContainer dataContainer = new FATContainer())
{
CashJournal existedInfo = dataContainer.CashJournal.FirstOrDefault(item => item.Row_ID == info.Row_ID);
dataContainer.Entry <CashJournal>(existedInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = info;
return(result);
}
}
public ActionResult CashJournal_Delete(int glRowID)
{
using (FATContainer dataContainer = new FATContainer())
{
CashJournal cjInfo = dataContainer.CashJournal.FirstOrDefault(item => item.Row_ID == glRowID);
dataContainer.CashJournal.Remove(cjInfo);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult GeneralLedger_Delete(int glRowID)
{
using (FATContainer dataContainer = new FATContainer())
{
GeneralLedger glInfo = dataContainer.GeneralLedger.FirstOrDefault(item => item.Row_ID == glRowID);
dataContainer.GeneralLedger.Remove(glInfo);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = glInfo;
return(result);
}
}
public ActionResult SaveDebitTransferCheckData(TransferCheck info)
{
using (FATContainer dataContainer = new FATContainer())
{
TransferCheck orgInfo = dataContainer.TransferCheck.Find(info.Row_ID);
dataContainer.Entry <TransferCheck>(orgInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult SaveMoneyRemittanceData(MoneyRemittance info)
{
using (FATContainer dataContainer = new FATContainer())
{
MoneyRemittance orgInfo = dataContainer.MoneyRemittance.Find(info.Row_ID);
dataContainer.Entry <MoneyRemittance>(orgInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult SaveBankDraftData(BankDraft info)
{
using (FATContainer dataContainer = new FATContainer())
{
BankDraft orgInfo = dataContainer.BankDraft.Find(info.Row_ID);
dataContainer.Entry <BankDraft>(orgInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult SaveIndividualSavingData(IndividualSaving info)
{
using (FATContainer dataContainer = new FATContainer())
{
IndividualSaving orgInfo = dataContainer.IndividualSaving.Find(info.Row_ID);
dataContainer.Entry <IndividualSaving>(orgInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult SaveCollectAcceptData(CollectAccept info)
{
using (FATContainer dataContainer = new FATContainer())
{
CollectAccept orgInfo = dataContainer.CollectAccept.Find(info.Row_ID);
dataContainer.Entry <CollectAccept>(orgInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult SaveEntrustCorpPaymentData(EntrustCorpPayment info)
{
using (FATContainer dataContainer = new FATContainer())
{
EntrustCorpPayment orgInfo = dataContainer.EntrustCorpPayment.Find(info.Row_ID);
dataContainer.Entry <EntrustCorpPayment>(orgInfo).CurrentValues.SetValues(info);
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = string.Empty;
return(result);
}
}
public ActionResult DoRegister(FATUser user, string valCode)
{
JsonResult result = new JsonResult();
using (FATContainer dbContainer = new FATContainer())
{
valCode = valCode.Trim();
ActivationCode existedCode = dbContainer.ActivationCode.FirstOrDefault(n => n.ActivateCode == valCode && n.CurrStatus == ConstDefine.ActivationCode_Status_Unused);
if (existedCode == null)
{
result.Data = "激活码不存在或者已被使用";
return(result);
}
existedCode.CurrStatus = ConstDefine.ActivationCode_Status_Used;
FATUser existedUser = dbContainer.FATUser.FirstOrDefault(n => n.UserCode == user.UserCode && n.School == user.School);
if (existedUser != null)
{
result.Data = "用户登录名已存在";
return(result);
}
if ((user.Password.Length < 6) || (user.Password.Length > 15))
{
result.Data = "密码必须在6-15位之间";
return(result);
}
user.UserCode = user.UserCode.Trim();
if (string.IsNullOrEmpty(user.UserCode))
{
result.Data = "登录名不能为空";
return(result);
}
FATUser newUser = dbContainer.FATUser.Create();
newUser.UserCode = user.UserCode;
newUser.School = user.School;
newUser.UserName = user.UserName;
newUser.IsStudent = 1;
newUser.IsAdmin = 0;
newUser.IsTeacher = 0;
newUser.Password = user.Password;
newUser.CurrStatus = ConstDefine.UserStatus_Valid;
newUser.CreatedDate = DateTime.Now;
dbContainer.FATUser.Add(newUser);
dbContainer.SaveChanges();
CurrentUser.UserLogin(newUser);
result.Data = string.Empty;
return(result);
}
}
public ActionResult ChangeCaseStatus(bool isEnabled, int tchRoutineID)
{
using (FATContainer dataContainer = new FATContainer())
{
TeachingRoutine cachedRoutine = SharedCasePool.GetCasePool().GetRoutine(tchRoutineID);
cachedRoutine.CurrStatus = Convert.ToInt16(isEnabled ? 1 : 0);
TeachingRoutine dbRoutine = dataContainer.TeachingRoutine.Find(tchRoutineID);
dbRoutine.CurrStatus = cachedRoutine.CurrStatus;
dataContainer.SaveChanges();
}
return(null);
}
public ActionResult UpdateCase(int tchRoutineID, string caseName, string caseText)
{
using (FATContainer dataContainer = new FATContainer())
{
TeachingRoutine cachedRoutine = SharedCasePool.GetCasePool().GetRoutine(tchRoutineID);
cachedRoutine.CaseName = caseName;
TeachingRoutine dbRoutine = dataContainer.TeachingRoutine.Find(tchRoutineID);
dataContainer.Entry <TeachingRoutine>(dbRoutine).CurrentValues.SetValues(cachedRoutine);
dataContainer.SaveChanges();
}
return(null);
}
public ActionResult SaveT2RoutineData(List <TransferCheck> tcList)
{
using (FATContainer dataContainer = new FATContainer())
{
foreach (TransferCheck tc in tcList)
{
TransferCheck orgInfo = dataContainer.TransferCheck.Find(tc.Row_ID);
dataContainer.Entry <TransferCheck>(orgInfo).CurrentValues.SetValues(tc);
}
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
return(result);
}
}
public ActionResult ResetRoutine(int activityID)
{
using (FATContainer dataContainer = new FATContainer())
{
StudentActivity activity = dataContainer.StudentActivity.First(act => act.Row_ID == activityID);
TeachingRoutine tchRoutine = SharedCasePool.GetCasePool().GetRoutine(activity.TchRoutineID);
activity.IsFinished = 0;
activity.TchNodeID = tchRoutine.NodeList[tchRoutine.NodeList.Keys[0]].Row_ID;
dataContainer.SaveChanges();
JsonResult result = new JsonResult();
TeachingNode firstNode = tchRoutine.NodeList[tchRoutine.NodeList.Keys[0]];
result.Data = string.Format("{0}/{1}/{2}", firstNode.NodeType, firstNode.NodeTag, firstNode.Row_ID);
return(result);
}
}
public ActionResult ImportUserList(string inputStr)
{
JsonResult importResult = new JsonResult();
importResult.Data = string.Empty;
using (FATContainer dbContainer = new FATContainer())
{
bool isAllProcessed = true;
using (StreamReader textReader = new StreamReader(new MemoryStream(Encoding.UTF8.GetBytes(inputStr ?? ""))))
{
string newLine = string.Empty;
int lineCount = 0;
while ((newLine = textReader.ReadLine()) != null)
{
lineCount++;
string[] splitArr = newLine.Split('\t');
if (splitArr.Length != 3)
{
isAllProcessed = false;
importResult.Data = "第" + lineCount + "行数据读取失败";
break;
}
string importUName = splitArr[0];
FATUser existedUser = dbContainer.FATUser.FirstOrDefault(n => n.UserName == importUName);
if (existedUser != null)
{
isAllProcessed = false;
importResult.Data = "第" + lineCount + "行数据中的登录名已存在";
break;
}
existedUser = dbContainer.FATUser.Create();
existedUser.UserName = splitArr[0];
existedUser.IsStudent = Convert.ToInt16(splitArr[1]);
existedUser.IsTeacher = Convert.ToInt16(splitArr[2]);
existedUser.IsAdmin = 0;
existedUser.CreatedDate = DateTime.Now;
existedUser.CurrStatus = 1;
existedUser.Password = "******";
dbContainer.FATUser.Add(existedUser);
}
}
if (isAllProcessed)
{
dbContainer.SaveChanges();
}
}
return(importResult);
}
public ActionResult DeleteSubjectItem(int dbRowID)
{
using (FATContainer dbContainer = new FATContainer())
{
SubjectItem existedItem = dbContainer.SubjectItem.FirstOrDefault(item => item.Row_ID == dbRowID);
if (existedItem == null)
{
return(null);
}
dbContainer.SubjectItem.Remove(existedItem);
dbContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = "SUCC";
return(result);
}
}
public ActionResult UpdateSubjectItem(SubjectItem subject)
{
using (FATContainer dbContainer = new FATContainer())
{
SubjectItem existedItem = dbContainer.SubjectItem.FirstOrDefault(item => item.Row_ID == subject.Row_ID);
if (existedItem == null)
{
return(null);
}
dbContainer.Entry <SubjectItem>(existedItem).CurrentValues.SetValues(subject);
dbContainer.SaveChanges();
JsonResult result = new JsonResult();
result.Data = "SUCC";
return(result);
}
}
public ActionResult InitEntrustBankPaymentData()
{
using (FATContainer dataContainer = new FATContainer())
{
int tchRoutineID = Convert.ToInt32(RouteData.Values["tchRoutineID"]);
EntrustBankPayment info = dataContainer.EntrustBankPayment.FirstOrDefault(item => (item.TchRoutineID == tchRoutineID));
if (info == null)
{
info = dataContainer.EntrustBankPayment.Create();
info.TchRoutineID = tchRoutineID;
info.EntrustDate = DateTime.Now;
info.PaymentDate = DateTime.Now;
dataContainer.EntrustBankPayment.Add(info);
dataContainer.SaveChanges();
}
return(View("EntrustBankPayment", info));
}
}