global.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 System.Data.Common;
using System.Text;
using System.IO;
/// <summary>
/// Global 的摘要说明
/// </summary>
//该源码下载自www.51aspx.com(５１ａｓpｘ．ｃｏｍ)

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);
     }
 
}