private static void InheritanceInterfaceExample() { var student = new CreateStudentService() .Handle("Jon", "Snow", "*****@*****.**", "075698565", Guid.NewGuid()); Console.WriteLine(student); Console.ReadKey(); }
public string[] createStudentService(CreateStudentService StudentService) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; CaseDataBase CData = new CaseDataBase(); DataBase Base = new DataBase(); SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()); int viewStaff1 = 0; int viewStaff2 = 0; if (StudentService.viewStaff.Count < 2) { viewStaff1 = Chk.CheckStringtoIntFunction(StudentService.viewStaff[0]); } else if (StudentService.viewStaff.Count >= 2) { viewStaff1 = Chk.CheckStringtoIntFunction(StudentService.viewStaff[0]); viewStaff2 = Chk.CheckStringtoIntFunction(StudentService.viewStaff[1]); } using (Sqlconn) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "INSERT INTO CaseServiceRecord(Unit, StudentID, ServiceDate, ServiceTime, Method, Theme, Objects, Place, Personnel1, Personnel2, Item, CreateFileBy, UpFileBy, UpFileDate ) " + "VALUES (@Unit, @StudentID, @ServiceDate, @ServiceTime, @Method, @Theme, @Objects, @Place, @Personnel1, @Personnel2, @Item, @CreateFileBy, @UpFileBy, (getDate()) )"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@Unit", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(CreateFileName[2]); cmd.Parameters.Add("@StudentID", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.studentID); cmd.Parameters.Add("@ServiceDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentService.viewData); cmd.Parameters.Add("@ServiceTime", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewTime); cmd.Parameters.Add("@Method", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentService.viewStyle); cmd.Parameters.Add("@Theme", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewTitle); cmd.Parameters.Add("@Objects", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewPeople); cmd.Parameters.Add("@Place", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewPlace); cmd.Parameters.Add("@Personnel1", SqlDbType.Int).Value = viewStaff1; cmd.Parameters.Add("@Personnel2", SqlDbType.Int).Value = viewStaff2; cmd.Parameters.Add("@Item", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewContent); cmd.Parameters.Add("@CreateFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); returnValue[0] = cmd.ExecuteNonQuery().ToString(); if (returnValue[0] != "0") { sql = "select IDENT_CURRENT('CaseServiceRecord') AS cID"; cmd = new SqlCommand(sql, Sqlconn); SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue[1] = dr["cID"].ToString(); } dr.Close(); } Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message; } } return returnValue; }
public string[] setStudentService(CreateStudentService StudentService) { string[] returnValue = new string[2]; returnValue[0] = "0"; returnValue[1] = "0"; CaseDataBase CData = new CaseDataBase(); DataBase Base = new DataBase(); SqlConnection Sqlconn = new SqlConnection(Base.GetConnString()); int viewStaff1 = 0; int viewStaff2 = 0; if (StudentService.viewStaff.Count < 2 && StudentService.viewStaff.Count != 0) { viewStaff1 = Chk.CheckStringtoIntFunction(StudentService.viewStaff[0]); } else if (StudentService.viewStaff.Count >= 2) { viewStaff1 = Chk.CheckStringtoIntFunction(StudentService.viewStaff[0]); viewStaff2 = Chk.CheckStringtoIntFunction(StudentService.viewStaff[1]); } using (Sqlconn) { try { StaffDataBase sDB = new StaffDataBase(); List<string> CreateFileName = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); Sqlconn.Open(); string sql = "UPDATE CaseServiceRecord SET ServiceDate=@ServiceDate, ServiceTime=@ServiceTime, Method=@Method, Theme=@Theme, Objects=@Objects, " + "Place=@Place, Personnel1=@Personnel1, Personnel2=@Personnel2, Item=@Item, UpFileBy=@UpFileBy, UpFileDate=(getDate()) " + "WHERE ID=@ID"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = Chk.CheckStringtoIntFunction(StudentService.ID); cmd.Parameters.Add("@ServiceDate", SqlDbType.Date).Value = Chk.CheckStringtoDateFunction(StudentService.viewData); cmd.Parameters.Add("@ServiceTime", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewTime); cmd.Parameters.Add("@Method", SqlDbType.TinyInt).Value = Chk.CheckStringtoIntFunction(StudentService.viewStyle); cmd.Parameters.Add("@Theme", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewTitle); cmd.Parameters.Add("@Objects", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewPeople); cmd.Parameters.Add("@Place", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewPlace); cmd.Parameters.Add("@Personnel1", SqlDbType.Int).Value = viewStaff1; cmd.Parameters.Add("@Personnel2", SqlDbType.Int).Value = viewStaff2; cmd.Parameters.Add("@Item", SqlDbType.NVarChar).Value = Chk.CheckStringFunction(StudentService.viewContent); cmd.Parameters.Add("@UpFileBy", SqlDbType.Int).Value = Chk.CheckStringtoIntFunction(CreateFileName[0]); returnValue[0] = cmd.ExecuteNonQuery().ToString(); Sqlconn.Close(); } catch (Exception e) { returnValue[0] = "-1"; returnValue[1] = e.Message; } } return returnValue; }
public CreateStudentService getStudentService(Int64 ID) { CreateStudentService returnValue = new CreateStudentService(); returnValue.viewStaff = new List<string>(); DataBase Base = new DataBase(); using (SqlConnection Sqlconn = new SqlConnection(Base.GetConnString())) { try { Sqlconn.Open(); string sql = "SELECT CaseServiceRecord.*, StudentDatabase.StudentName, StudentDatabase.StudentBirthday, StudentDatabase.StudentSex " + "FROM CaseServiceRecord INNER JOIN StudentDatabase ON CaseServiceRecord.StudentID=StudentDatabase.StudentID AND StudentDatabase.isDeleted=0 " + "WHERE CaseServiceRecord.isDeleted=0 AND CaseServiceRecord.ID=@ID"; SqlCommand cmd = new SqlCommand(sql, Sqlconn); cmd.Parameters.Add("@ID", SqlDbType.BigInt).Value = ID; SqlDataReader dr = cmd.ExecuteReader(); while (dr.Read()) { returnValue.ID = dr["ID"].ToString(); returnValue.studentID = dr["StudentID"].ToString(); returnValue.studentName = dr["StudentName"].ToString(); returnValue.studentSex = dr["StudentSex"].ToString(); returnValue.studentbirthday = DateTime.Parse(dr["StudentBirthday"].ToString()).ToString("yyyy-MM-dd"); returnValue.sUnit = dr["Unit"].ToString(); returnValue.viewData = DateTime.Parse(dr["ServiceDate"].ToString()).ToString("yyyy-MM-dd"); returnValue.viewTime = dr["ServiceTime"].ToString(); returnValue.viewStyle = dr["Method"].ToString(); returnValue.viewTitle = dr["Theme"].ToString(); returnValue.viewPeople = dr["Objects"].ToString(); returnValue.viewPlace = dr["Place"].ToString(); returnValue.viewStaff.Add(dr["Personnel1"].ToString()); returnValue.viewStaff.Add(dr["Personnel2"].ToString()); returnValue.viewContent = dr["Item"].ToString(); } dr.Close(); Sqlconn.Close(); } catch (Exception e) { returnValue.checkNo = "-1"; returnValue.errorMsg = e.Message; } } return returnValue; }
public string[] setStudentServiceData(CreateStudentService StudentService) { CaseDataBase SDB = new CaseDataBase(); if (int.Parse(SDB._StaffhaveRoles[1]) == 1) { return SDB.setStudentService(StudentService); } else { return new string[2] { _noRole, _errorMsg }; } }
public CreateStudentService getStudentServiceData(Int64 ID) { CaseDataBase SDB = new CaseDataBase(); CreateStudentService returnValue = new CreateStudentService(); if (int.Parse(SDB._StaffhaveRoles[3]) == 1) { returnValue=SDB.getStudentService(ID); } else { returnValue.checkNo = _getcheckNo; returnValue.errorMsg = _errorMsg; } StaffDataBase sDB = new StaffDataBase(); List<string> UserFile = sDB.getStaffDataName(HttpContext.Current.User.Identity.Name); if (returnValue.sUnit != UserFile[2] && int.Parse(SDB._StaffhaveRoles[4]) == 0 && UserFile[1].Length > 0) { returnValue.checkNo = _getcheckNo; returnValue.errorMsg = _errorMsg; } return returnValue; }