1using System;
  2using System.Data;
  3using System.Configuration;
  4using System.Web;
  5using System.Web.Security;
  6using System.Web.UI;
  7using System.Web.UI.WebControls;
  8using System.Web.UI.WebControls.WebParts;
  9using System.Web.UI.HtmlControls;
 10using System.Data.Common;
 11using System.Text;
 12using System.IO;
 13/**//// <summary>
 14/// Global 的摘要说明
 15/// </summary>
 16/// 
 17namespace projmanager
 18...{
 19    public class Global
 20    ...{
 21        public Global()
 22        ...{
 23            //
 24            // TODO: 在此处添加构造函数逻辑
 25            //
 26        }
 27
 28        public static bool CheckStudentLogin(string ID, string password)
 29        ...{
 30            bool flag = false;
 31            string sql = "select * from Student where StudentID='" + ID + "' and Password = '" + password + "'";
 32            DbDataReader dda = DataAccess.ExecuteDataReader(sql);
 33            if (dda != null && dda.HasRows)
 34            ...{
 35                flag = true;
 36            }
 37            dda.Close();
 38            return flag;
 39        }
 40
 41
 42        public static bool CheckTeacherLogin(string ID, string password)
 43        ...{
 44            bool flag = false;
 45            string sql = "select * from Teacher where TeacherID='" + ID + "' and Password = '" + password + "'";
 46            DbDataReader dda = DataAccess.ExecuteDataReader(sql);
 47            if (dda != null && dda.HasRows)
 48            ...{
 49                flag = true;
 50            }
 51            dda.Close();
 52            return flag;
 53        }
 54
 55        public static string GetNameByID(string id)
 56        ...{
 57            string sql = "select name from student where Studentid ='" + id + "' union " +
 58                " select name from teacher where Teacherid='" + id + "'";
 59            string name = "";
 60            DbDataReader reader = DataAccess.ExecuteDataReader(sql);
 61            if (reader.Read())
 62            ...{
 63                name = reader.GetString(0);
 64            }
 65            reader.Close();
 66            return name;
 67        }
 68
 69        public static string GeneralizeFileNameByDate()
 70        ...{
 71            DateTime now = DateTime.Now;
 72            StringBuilder sb = new StringBuilder();
 73            sb.Append(now.Year.ToString());
 74            sb.Append(now.Month.ToString().PadLeft(2, '0'));
 75            sb.Append(now.Day.ToString().PadLeft(2, '0'));
 76            sb.Append(now.Hour.ToString().PadLeft(2, '0'));
 77            sb.Append(now.Minute.ToString().PadLeft(2, '0'));
 78            sb.Append(now.Second.ToString().PadLeft(2, '0'));
 79            sb.Append(".doc");
 80            return sb.ToString();
 81
 82        }
 83        public static string GeneralizeDocPathByUserID(string id)
 84        ...{
 85            string RootPath = ConfigurationManager.AppSettings["PaperPath"].ToString();
 86            return (RootPath + "/" + id);
 87        }
 88
 89        public static DataTable GetFieldsFromTablesByCondiction(string fields, string tables, string condiction)
 90        ...{
 91            string sql = "select ";
 92            if (fields == "*")
 93            ...{
 94                sql += " * ";
 95            }
 96            else
 97            ...{
 98                sql += " " + fields;
 99            }
100
101            sql += " from " + tables;
102            if (String.IsNullOrEmpty(condiction) == false)
103            ...{
104                sql += " where " + condiction;
105            }
106
107            return DataAccess.ExecuteDataTable(sql);
108        }
109
110    }
111}