getlogin.cs

财务凭证管理系统主要由【系统管理】、【凭证管理】、【科目信息】、【账目查询】和【报表】等模块组成。进入该系统后

using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using property.model.SystemInfo;
using property.model.GetConnection;//引用类名空间 
namespace property.control.LogInfo
{
    class GetLogin
    {
        /// <summary>
        /// 些类功能方是登陆信息的验证
        /// public string loginDen(admInfo adm)方法
        /// </summary>
        SqlCommand com = null;
        SqlConnection con = null;
        admInfo adm = new admInfo();
        GetConnection getcon = new GetConnection();

        #region //登陆
        public string loginDen(admInfo adm)
        {
            string P_str_result = null;
            try {
                con = getcon.GetCon();
                if (con.State == ConnectionState.Open)
                {
                    com = new SqlCommand();
                    string select = "select  count(*) from tb_adminfo where  admName='" + adm.getadmName() + "' and  admPassword='" + adm.getadmPassword() + "'";
                    com.CommandText = select;
                    com.Connection = con;
                    int P_int_Select = (int)com.ExecuteScalar();
                    // int t = com.ExecuteNonQuery();
                    com.Connection.Close();
                    con.Close();
                    if (P_int_Select == 1)
                    {
                        P_str_result = "adminOK";
                    }
                    else
                    {
                        P_str_result = "adminNO";
                    }//end block else if 
                }// end block 
                if(con==null)
                {
                    P_str_result = "ConClose";
                }
                return P_str_result;
                
            }
            catch(Exception e) {

              //  result = "Error";
                return e.ToString();
                
            }//end block 
        
        }// end block
        #endregion 
    }// end block class

}