tdsuserinfo.cs

航空公司用的简单管理系统

using System.Data;
using System.Data.Sql;
using System.Data.SqlClient;
using System.Data.Common;
using System.ComponentModel;
using System;

namespace SouthernAir.Business.TypeDataSet {

    [DataObject]
    partial class tdsUserInfo
    {
        protected static string spUpdateUserInfo = "dbo.UpdateUserInfo";
        protected static string spDeleteUserInfo = "dbo.DeleteUserInfo";

        [DataObjectMethod(DataObjectMethodType.Select,true)]
        public static BSAUserDataTable GetUserInfo()
        {
            try
            {
                string strConn = "Data Source=TRTGR\\SQLEXPRESS;AttachDbFilename=D:\\Project\\SouthernAir\\SouthernAir.Business\\SouthernAirData.mdf;Integrated Security=True";
                string strSQL = "SELECT * FROM BSAUser";

                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();
                    SqlDataAdapter da = new SqlDataAdapter(strSQL, conn);
                    DataSet ds = new DataSet();
                    da.Fill(ds, "UserInfo");
                    BSAUserDataTable oDataTable = new BSAUserDataTable();
                    oDataTable.Merge(ds.Tables["UserInfo"]);
                    return oDataTable;
                }
            }
            catch
            {
                BSAUserDataTable oDataTable = new BSAUserDataTable();
                return oDataTable;
            }
        }

        [DataObjectMethod(DataObjectMethodType.Update, true)]
        public static void UpdateUserInfo(string Pwd, string Popedom, string UserName,
            string OriginalID, string Tel, string MobilePhone, string Address, string original_UserID)
        {
            try
            {
                string strConn = "Data Source=TRTGR\\SQLEXPRESS;AttachDbFilename=D:\\Project\\SouthernAir\\SouthernAir.Business\\SouthernAirData.mdf;Integrated Security=True";
                int intPopedom = Convert.ToInt32(Popedom);
                decimal decMobilePhone = 0;
                if (MobilePhone != null)
                {
                    decMobilePhone = Convert.ToDecimal(MobilePhone);
                }

                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(spUpdateUserInfo, conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@Pwd", Pwd);
                    cmd.Parameters.AddWithValue("@Popedom", intPopedom);
                    cmd.Parameters.AddWithValue("@UserName", UserName);
                    cmd.Parameters.AddWithValue("@OriginalID", OriginalID);
                    cmd.Parameters.AddWithValue("@Tel", Tel);
                    cmd.Parameters.AddWithValue("@MobilePhone", decMobilePhone);
                    cmd.Parameters.AddWithValue("@Address", Address);
                    cmd.Parameters.AddWithValue("@UserID", original_UserID);
                    cmd.ExecuteNonQuery();
                }
            }
            catch
            {
            }
        }

        [DataObjectMethod(DataObjectMethodType.Delete, true)]
        public static void DeleteUserInfo(string original_UserID)
        {
            try
            {
                string strConn = "Data Source=TRTGR\\SQLEXPRESS;AttachDbFilename=D:\\Project\\SouthernAir\\SouthernAir.Business\\SouthernAirData.mdf;Integrated Security=True";

                using (SqlConnection conn = new SqlConnection(strConn))
                {
                    conn.Open();
                    SqlCommand cmd = new SqlCommand(spDeleteUserInfo, conn);
                    cmd.CommandType = CommandType.StoredProcedure;
                    cmd.Parameters.AddWithValue("@UserID", original_UserID);
                    cmd.ExecuteNonQuery();
                }
            }
            catch
            {
            }
        }


    }
}