cnumbergen.cs

Teacher Manager System

using System;
using System.Data;
using System.Data.SqlClient;

namespace tw.org.iii.crm.data
{
    public class CNumberGen
    {
        


        public static int getNext(string type,CDbManager p_manager)
        {
            SqlCommand l_cmd =
                new SqlCommand("SELECT * FROM dbo.tTemp WHERE fKey='SN' AND fType='" + type + "'", p_manager.getConnection());
            SqlDataReader l_reader = l_cmd.ExecuteReader();
            string l_str = "";
            int l_int=0;
            if (l_reader.Read())
            {
                l_int = Convert.ToInt32(l_reader["fValue"].ToString());
                l_int++;
                l_str = "UPDATE dbo.tTemp SET fValue='" + l_int.ToString() + "' WHERE fKey='SN' AND fType='" + type + "'";
                l_cmd = new SqlCommand(l_str, p_manager.getConnection());
                l_cmd.ExecuteNonQuery();
                
            }
            else
            {
                if ("CNumberGen".Equals(type))
                {
                    l_str = "INSERT INTO dbo.tTemp VALUES('0','SN','1','" + type + "')";
                    l_cmd = new SqlCommand(l_str, p_manager.getConnection());
                    l_cmd.ExecuteNonQuery();
                    p_manager.getConnection().Close();
                    return 1;
                }
                l_str = "INSERT INTO dbo.tTemp VALUES('" + getNext("CNumberGen", p_manager) + 
                    "','SN','0','" + type + "')";
                l_cmd = new SqlCommand(l_str, p_manager.getConnection());
                l_cmd.ExecuteNonQuery();
            }
            p_manager.getConnection().Close();
            return l_int;


        }
    }
}