Ejemplo n.º 1
0
        private static void InheritanceInterfaceExample()
        {
            var student = new CreateStudentService()
                          .Handle("Jon", "Snow", "*****@*****.**", "075698565", Guid.NewGuid());

            Console.WriteLine(student);
            Console.ReadKey();
        }
Ejemplo n.º 2
0
    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;
    }
Ejemplo n.º 3
0
    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;
    }
Ejemplo n.º 4
0
    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;
    }
Ejemplo n.º 5
0
 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 };
     }
 }
Ejemplo n.º 6
0
 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;
 }