util.cs

一个农村管理系统的程序 数据库那部分可能不全 大家可以

using System;
using System.Collections.Generic;
using System.Text;
using DataFieldClass;
using System.Data.SqlClient;

namespace MsgSystem
{
    static class Util
    {
        public static int id = 0;
        public static PersonInfo getPersonByPhone(string phone)
        {
            PersonInfo person = new PersonInfo();
            string sqlString = "SELECT * FROM Tab_Staff WHERE phone = '" + phone + "'";
            SqlConnection conn = Program.conns.getConnection();

            SqlCommand sqlCMD = conn.CreateCommand();
            sqlCMD.CommandText = sqlString;
            SqlDataReader sqlReader = sqlCMD.ExecuteReader();


            if (sqlReader.Read())
            {
                person.setID(Convert.ToInt32(sqlReader["id"].ToString().Trim()));
                person.setName(sqlReader["name"].ToString().Trim());
                person.setPhone(sqlReader["phone"].ToString().Trim());
                person.setPost(sqlReader["post"].ToString().Trim());
                person.setGroup(Convert.ToInt32(sqlReader["group"].ToString().Trim()));
                person.setSex(sqlReader["sex"].ToString());
                person.setDesc(sqlReader["desc"].ToString());
                person.setAddress(sqlReader["address"].ToString());
                person.setAge(Convert.ToInt32(sqlReader["age"].ToString().Trim()));

            }
            else
            {
                person = null;

            }
            Program.conns.releaseConnection(conn);
            return person;


        }

        public static int getId()
        {
            if (id == 0)
            {
                initId();
            }

            id += 1;
            
            string sqlString = "UPDATE Tab_Id SET maxId = " + id + " WHERE id = 0";
            SqlConnection conn = Program.conns.getConnection();

            SqlCommand sqlCMD = conn.CreateCommand();
            sqlCMD.CommandText = sqlString;
            int rtn = sqlCMD.ExecuteNonQuery();


            if ( rtn != 0)
            {


            }
            else
            {
                id = 50;
                Console.WriteLine("max id get error");

            }
            sqlCMD.Dispose();
            Program.conns.releaseConnection(conn);
            return id;


        }

        public static void initId()
        {
            string sqlString = "SELECT * FROM Tab_Id WHERE id = 0";
            SqlConnection conn = Program.conns.getConnection();

            SqlCommand sqlCMD = conn.CreateCommand();
            sqlCMD.CommandText = sqlString;
            SqlDataReader sqlReader = sqlCMD.ExecuteReader();


            if (sqlReader.Read())
            {
                id = Convert.ToInt32(sqlReader["maxId"].ToString().Trim());


            }
            else
            {
                id = 50;
                Console.WriteLine( "max id get error");

            }
            sqlReader.Dispose();
            sqlCMD.Dispose();

            Program.conns.releaseConnection( conn);
        }

    }
}