global.cs

简单项目管理系统源码 该源码为某公司的项目管理系统Demo版

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 System.Data.Common;
using System.Text;
using System.IO;
/// <summary>
/// Global 的摘要说明
/// </summary>
/// 
namespace projmanager
{
    public class Global
    {
        public Global()
        {
            //
            // TODO: 在此处添加构造函数逻辑
            //
        }

        public static bool CheckStudentLogin(string ID, string password)
        {
            bool flag = false;
            string sql = "select * from Student where StudentID='" + ID + "' and Password = '" + password + "'";
            DbDataReader dda = DataAccess.ExecuteDataReader(sql);
            if (dda != null && dda.HasRows)
            {
                flag = true;
            }
            dda.Close();
            return flag;
        }


        public static bool CheckTeacherLogin(string ID, string password)
        {
            bool flag = false;
            string sql = "select * from Teacher where TeacherID='" + ID + "' and Password = '" + password + "'";
            DbDataReader dda = DataAccess.ExecuteDataReader(sql);
            if (dda != null && dda.HasRows)
            {
                flag = true;
            }
            dda.Close();
            return flag;
        }

        public static string GetNameByID(string id)
        {
            string sql = "select name from student where Studentid ='" + id + "' union " +
                " select name from teacher where Teacherid='" + id + "'";
            string name = "";
            DbDataReader reader = DataAccess.ExecuteDataReader(sql);
            if (reader.Read())
            {
                name = reader.GetString(0);
            }
            reader.Close();
            return name;
        }

        public static string GeneralizeFileNameByDate()
        {
            DateTime now = DateTime.Now;
            StringBuilder sb = new StringBuilder();
            sb.Append(now.Year.ToString());
            sb.Append(now.Month.ToString().PadLeft(2, '0'));
            sb.Append(now.Day.ToString().PadLeft(2, '0'));
            sb.Append(now.Hour.ToString().PadLeft(2, '0'));
            sb.Append(now.Minute.ToString().PadLeft(2, '0'));
            sb.Append(now.Second.ToString().PadLeft(2, '0'));
            sb.Append(".doc");
            return sb.ToString();

        }
        public static string GeneralizeDocPathByUserID(string id)
        {
            string RootPath = ConfigurationManager.AppSettings["PaperPath"].ToString();
            return (RootPath + "/" + id);
        }

        public static DataTable GetFieldsFromTablesByCondiction(string fields, string tables, string condiction)
        {
            string sql = "select ";
            if (fields == "*")
            {
                sql += " * ";
            }
            else
            {
                sql += " " + fields;
            }

            sql += " from " + tables;
            if (String.IsNullOrEmpty(condiction) == false)
            {
                sql += " where " + condiction;
            }

            return DataAccess.ExecuteDataTable(sql);
        }

    }
}