public DataSet getClassInfo(string className,string classNumber,string gradeNumber,bool isForStu) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.GetClassList(className,classNumber,gradeNumber,isForStu); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
public DataSet GetStuCard(string getGrade,string getClass,string getName,string getNumber,string getCardNumber) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.GetStuCard(getGrade,getClass,getName,getNumber,getCardNumber); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
public void AddOrUpdateBackupPath(string path) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { optionDataAccess.AddOrUpdateBackupPath(path); } catch (Exception ex) { Util.WriteLog(ex.Message, Util.EXCEPTION_LOG_TITLE); } } }
public void WriteStuCardInfoXLS(string getPath) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { optionRules.WriteStuCardInfoXLS(optionDataAccess.GetStuInfo(),getPath); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); } } }
public void InsertTeaInfo(Option option) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { optionDataAccess.InsertTeaInfo(option); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); } } }
public void InsertMachine(string terminalNumbers,string machineVol) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { optionDataAccess.InsertMachine(terminalNumbers,machineVol); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); } } }
public int InsertNewStudentForGradeChange(string stuName,int stuGrade,int stuClass,string stuType) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { return optionDataAccess.InsertNewStudentForGradeChange(stuName,stuGrade,stuClass,stuType); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return -1; } } }
public int UpdateClassNameByNumber(string getGradeNumber,string getClassNumber,string getClassName) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { return optionDataAccess.UpdateClassNameByNumber(getGradeNumber,getClassNumber,getClassName); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return -1; } } }
public int UpdateGradeInfo(string getOriNumber,string getChNumber,string getChName,string getChRemark) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.UpdateGradeInfo(getOriNumber,getChNumber,getChName,getChRemark); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public bool ExecuteKillSysdbProcesses() { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { optionDataAccess.KillSysdbProcesses(); return true; } catch(Exception ex) { Util.WriteLog(ex.Message,Util.EXCEPTION_LOG_TITLE); return false; } } }
public DataSet GetMachine() { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.GetMachine(); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
public bool ExecuteRestoreDiff(string root) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { optionDataAccess.ExecuteRestoreDiff(root); return true; } catch(Exception ex) { Util.WriteLog(ex.Message,Util.EXCEPTION_LOG_TITLE); return false; } } }
public bool AddBackupJob(int type,string root) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { optionDataAccess.AddBackupJob(type,root); return true; } catch(Exception ex) { Util.WriteLog(ex.Message,Util.EXCEPTION_LOG_TITLE); return false; } } }
public string GetBackupPath() { var backupPath = string.Empty; using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { backupPath = optionDataAccess.GetBackupPath(); } catch (Exception ex) { Util.WriteLog(ex.Message, Util.EXCEPTION_LOG_TITLE); } return backupPath; } }
public int DeleteClassInfo(string getOriClassNumber,string getOriGradeNumber) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.DeleteClassInfo(getOriClassNumber,getOriGradeNumber); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public DataTable GetClassNumberList(string getGradeNumber) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { return optionDataAccess.GetClassNumberList(getGradeNumber); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
private int UpdateStudentInfo(Option option) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.UpdateStudentInfo(option); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public bool UpdateStudentForGradeChange(string getName,int getGrade,int getClass,string getType) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { bool rtnValue = false; try { int isStudentExisits = optionDataAccess.UpdateStudentForGradeChange(getName,getGrade,getClass,getType); if ( isStudentExisits != 0 ) rtnValue = true; else rtnValue = false; } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); rtnValue = false; } return rtnValue; } }
public int UpdateTeaInfo(string getID,string getName,string getNumber,string getDept,string getDuty,string getGender) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.UpdateTeaInfo(getID,getName,getNumber,getDept,getDuty,getGender); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public DataTable GetStuNameByNumber(string stuNumber) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { return optionDataAccess.GetStuNameByNumber(stuNumber); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
public int UpdateTeaCardInfo(string getID,string getNumber,int getSeq,DateTime getDate) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.UpdateTeaCardInfo(getID,getNumber,getSeq,getDate); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public int InsertStuInfo(Option option) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.InsertStuInfo(option); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public int DeleteTeaCardInfo(string getID,int getSeq) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.DeleteTeaCardInfo(getID,getSeq); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public int InsertMachine(string getAddr,string getType,string getVol) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.InsertMachine(getAddr,getType,getVol); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return -1; } } }
public int UpdateMachineInfo(int getOriMachineAddr,int getOriMachineType,int getChMachineAddr,int getChMachineType,int getChMachineVol) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.UpdateMachineInfo(getOriMachineAddr,getOriMachineType,getChMachineAddr,getChMachineType,getChMachineVol); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); if ( e.Message.IndexOf("重复键") > 0 ) return -1; else return 0; } } }
public DataSet GetTeaBasicInfo(string getDept,string getDuty,string getName,string getNumber) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.GetTeaBasicInfo(getDept,getDuty,getName,getNumber); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return null; } } }
public int DeleteMachineInfo(int getMachineAddr,int getMachineType) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return optionDataAccess.DeleteMachineInfo(getMachineAddr,getMachineType); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public int InsertNewAddCardInfo(string getNumber,string getCardNumber,string getHolder,DateTime getSendDate) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { return optionDataAccess.InsertNewAddCardInfo(getNumber,getCardNumber,getHolder,getSendDate); } catch(Exception e) { Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return 0; } } }
public string CheckIsClassExists(string getGrade,string getClass,ref bool isOk) { using ( OptionDataAccess optionDataAccess = new OptionDataAccess() ) { try { int gradeNumber = Convert.ToInt32(getGrade.Replace(" ","")); int classNumber = Convert.ToInt32(getClass.Replace(" ","")); DataTable dtClass = optionDataAccess.IsExistClass(gradeNumber,classNumber); if ( dtClass.Rows.Count > 0 ) { isOk = true; return "ok"; } else { isOk = false; return "班级不存在请重试!"; } } catch(Exception e) { isOk = false; Util.WriteLog(e.Message,Util.EXCEPTION_LOG_TITLE); return "班级号码应该为数字!"; } } }