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("班级号码应该为数字!"); } } }
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 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 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 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 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 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); } } }
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 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 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 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 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 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 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 InsertTeaCardInfo(string getID, string getCardNumber, DateTime getCardSendDate, int getCardSeq) { using (OptionDataAccess optionDataAccess = new OptionDataAccess()) { try { return(optionDataAccess.InsertTeaCardInfo(getID, getCardNumber, getCardSendDate, getCardSeq)); } catch (Exception e) { Util.WriteLog(e.Message, Util.EXCEPTION_LOG_TITLE); 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 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 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 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 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 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 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); } } }
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 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 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 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 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); } }
static void Main(string[] args) { var traditional = new TraditionalDataAccess(); var withOption = new OptionDataAccess(); while (true) { Console.Write("Input, please: "); var data = Console.ReadLine(); if (String.IsNullOrEmpty(data)) { continue; } Console.WriteLine(); Console.WriteLine("TRADTIONAL:"); HandleInput(data, traditional); Console.WriteLine("----------------------------------------------"); Console.WriteLine("WITH OPTION:"); HandleInput(data, withOption); } }
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); } } } }