approvedrecorddal.cs

来自「工作流方面的简单实例」· CS 代码 · 共 67 行

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

namespace MyApplication
{
    public class ApprovedRecordDAL
    {
         string connStr = "Data Source=(local);Initial Catalog=MyProject;User ID=sa;Password=digidigi";
        SqlConnection mysqlconn;

        public ApprovedRecordDAL()
        {
            mysqlconn = new SqlConnection(connStr);
            if (mysqlconn.State == ConnectionState.Closed)
            {
                mysqlconn.Open();
            }
        }
        /// <summary>
        /// open database connection
        /// </summary>
        private  void OpenDBConn()
        {
            mysqlconn = new SqlConnection(connStr);
            if (mysqlconn.State == ConnectionState.Closed)
            {
                mysqlconn.Open();
            }
        }
        /// <summary>
        /// close database connection
        /// </summary>
        private void CloseDBConn()
        {
            if (mysqlconn.State == ConnectionState.Open)
            {
                mysqlconn.Close();
            }
        }

        public void insertApprovedRecord(ExpenseAccountInfo eainfo)
        {
            OpenDBConn();
            SqlCommand ExpAccount = new SqlCommand("ApprovedRecord_Insert", mysqlconn);

            ExpAccount.CommandType = CommandType.StoredProcedure;
            ExpAccount.Parameters.Add("@ExpenseID", SqlDbType.UniqueIdentifier);
            ExpAccount.Parameters.Add("@UserName", SqlDbType.VarChar, 50);
            ExpAccount.Parameters.Add("@AppDate", SqlDbType.DateTime);
            ExpAccount.Parameters.Add("@AppStatus", SqlDbType.VarChar, 50);
            ExpAccount.Parameters.Add("@Notes", SqlDbType.VarChar);

            ExpAccount.Parameters["@ExpenseID"].Value = eainfo.ExpID;
            ExpAccount.Parameters["@UserName"].Value = eainfo.UserName;
            ExpAccount.Parameters["@AppDate"].Value = Convert.ToDateTime(eainfo.AppDate);
            ExpAccount.Parameters["@AppStatus"].Value = eainfo.ExpStatus;
            ExpAccount.Parameters["@Notes"].Value = eainfo.Notes;
            ExpAccount.ExecuteNonQuery();

            CloseDBConn();
        }
    }
}