userinfo.cs

学生成绩管理系统

using System;
using System.Data;
using System.Configuration;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using Microsoft.Practices.EnterpriseLibrary.Data;
using Microsoft.Practices.EnterpriseLibrary.Data.Sql;
using System.Data.Common;
using TeachHelper.DataAccessLayer;

namespace TeachHelper.BusinessLogicLayer
{

    /// <summary>
    /// Summary description for UserInfo
    /// </summary>
    public class UserInfo
    {
        public UserInfo()
        {
            //
            // TODO: Add constructor logic here
            //
        }

        public static bool IsExist(object providerUserKey)
        {
            string sqlCommand = string.Format("SELECT * FROM TeachHelper_UserInfo WHERE (UserId LIKE '{0}')", providerUserKey.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            object obj = db.ExecuteScalar(dbCommand);
            if (obj != null)
                return true;
            else
                return false;
        }

        public static string GetName(string username)
        {
            object userId = Membership.GetUser(username).ProviderUserKey;
            return GetName(userId);
        }

        public static string GetName(object userId)
        {
            string sqlCommand = string.Format("SELECT Name FROM TeachHelper_UserInfo WHERE (UserId LIKE '{0}')", userId.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            object name = db.ExecuteScalar(dbCommand);
            if (name == null)
                return string.Empty;
            else
                return name.ToString();
        }

        public static string[] GetTeacherCollect()
        {
            string roleName = "科任老师";
            string[] teachersArray = Roles.GetUsersInRole(roleName);
            return teachersArray;
        }

        public static DataSet GetInfo(object providerUserKey)
        {
            string sqlCommand = string.Format("SELECT * FROM TeachHelper_UserInfo WHERE (UserId LIKE '{0}')", providerUserKey.ToString());
            Database db = DatabaseFactory.CreateDatabase();
            DbCommand dbCommand = db.GetSqlStringCommand(sqlCommand);
            DataSet ds = db.ExecuteDataSet(dbCommand);
            return ds;
        }

        public static bool InsertUpdate(object userId, string name, int gender, string telephone, string mobileTel, 
            string postalcode, string departments, int grade, string majors, string classes, int seat, int? subjectId, string remark)
        {
            Database db = DatabaseFactory.CreateDatabase();

            string sqlCommand = "usp_InsertUpdateTeachHelper_UserInfo";
            DbCommand dbCommand = db.GetStoredProcCommand(sqlCommand);

            db.AddInParameter(dbCommand, "UserId", DbType.String, userId.ToString());
            db.AddInParameter(dbCommand, "Name", DbType.String, name);
            db.AddInParameter(dbCommand, "Gender", DbType.Int32, gender);
            db.AddInParameter(dbCommand, "Telephone", DbType.String, telephone);
            db.AddInParameter(dbCommand, "MobileTel", DbType.String, mobileTel);
            db.AddInParameter(dbCommand, "Postalcode", DbType.String, postalcode);
            db.AddInParameter(dbCommand, "Departments", DbType.String, departments);
            db.AddInParameter(dbCommand, "Grade", DbType.Int32, grade);
            db.AddInParameter(dbCommand, "Majors", DbType.String, majors);
            db.AddInParameter(dbCommand, "Classes", DbType.String, classes);
            db.AddInParameter(dbCommand, "Seat", DbType.Int32, seat);
            db.AddInParameter(dbCommand, "SubjectId", DbType.Int32, subjectId);
            db.AddInParameter(dbCommand, "Remark", DbType.String, remark);

            int result = db.ExecuteNonQuery(dbCommand);

            if (result == 1)
                return true;
            else
                return false;
        }

        public static bool InsertUpdate(object userId, string name, int gender, string telephone, string mobileTel,
            string postalcode, string departments, int grade, string majors, string classes, int seat)
        {
            return InsertUpdate(userId, name, gender, telephone, mobileTel, postalcode, departments, grade, majors, classes, seat, null, "");
        }
    }

}