_psdata.cs

是一个合格证打印系统

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

namespace PrintSystem
{

    public class DataPrint : DataBase
    {
        public DataPrint() { }
        public DataPrint(string strConn) : base(strConn) { }

        public InfoPrint GetPrint(string strID)
        {
            InfoPrint m_Info = new InfoPrint();
            string strSQL = string.Format(" SELECT * FROM PrintSystem WHERE id ={0} ", strID);
            DataTable dtTable = base.ExecSQLTableDirect(strSQL);
            foreach (DataRow dr in dtTable.Rows)
            {
                m_Info.lID = System.Convert.ToInt32(dr["ID"]);
                m_Info.strName  = dr["Name"].ToString();
                m_Info.strCode = dr["Code"].ToString();
                m_Info.strTrainRecord = dr["TrainRecord"].ToString();
                m_Info.dtPrint  = System.Convert.ToDateTime(dr["PrintTime"]);
            }
            return m_Info;
        }
        public void InsertPrint(InfoPrint info)
        {
            string strSQL = @" INSERT INTO PrintSystem (  Name,code,trainrecord) VALUES ( ? ,?,?)";
            base.Prepare(strSQL,  
                 new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarChar, 20, "Name"),
                new System.Data.OleDb.OleDbParameter("Code", System.Data.OleDb.OleDbType.VarChar, 30, "Code"),
                new System.Data.OleDb.OleDbParameter("TrainRecord", System.Data.OleDb.OleDbType.VarChar, 100, "TrainRecord"));
            base.ExecSQLNonQuery(info.strName ,info.strCode ,info.strTrainRecord);
        }

        public void UpdatePrint(InfoPrint info)
        {
            string strSQL = @" Update PrintSystem set Name = ?,Code = ? ,TrainRecord = ? WHERE ID = ?";
            base.Prepare(strSQL,                
                new System.Data.OleDb.OleDbParameter("Name", System.Data.OleDb.OleDbType.VarChar, 20, "Name"),
                new System.Data.OleDb.OleDbParameter("Code", System.Data.OleDb.OleDbType.VarChar, 30, "Code"),
                new System.Data.OleDb.OleDbParameter("TrainRecord", System.Data.OleDb.OleDbType.VarChar, 100, "TrainRecord"),
                new System.Data.OleDb.OleDbParameter("ID", System.Data.OleDb.OleDbType.BigInt ,8, "ID"));
            base.ExecSQLNonQuery(info.strName ,info.strCode ,info.strTrainRecord ,info.lID);

        }
        public void DeletePrint(string strID)
        {
            string strSQL = @"DELETE FROM PrintSystem WHERE id  =" + strID;
            base.ExecSQLNonQueryDirect(strSQL);
        }
    }
    public class InfoPrint
    {
       public  InfoPrint()
        {
            lID = 0;
            strName = string.Empty;
            strCode = string.Empty;
            dtPrint = DateTime.Parse("1900-01-01 00:00");
            strTrainRecord = string.Empty;
        }
        public System.Int64 lID;
        public System.String strName;
        public System.String strCode;
        public System.DateTime dtPrint;
        public System.String strTrainRecord;
    }
}