DA/DBParamSettings.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

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

namespace DA
{
    public class DBParamSettings:IDisposable
    {
        SqlHelpers sqlh;
        string sql;
        DataSet ds;
        SqlDataReader dr;
        public  DBParamSettings()
        {
            sqlh = new SqlHelpers();
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }
        /// <summary>
        /// 查询参数设置
        /// </summary>
        /// <returns></returns>
        public CParamSettings GetParamSettings()
        {
            CParamSettings cps = new CParamSettings();
            sql = "select * from ParamSettings";
            dr = sqlh.RQuery(sql, null, CommandType.Text);
            if (dr.Read())
            {
                cps.PrintCheckYes = Convert.ToBoolean(dr["printCheckYes"]);
                cps.PointCheckYes = Convert.ToBoolean(dr["pointCheckYes"]);
                cps.PointTimes = Convert.ToSingle(dr["pointTimes"]);
                cps.PId = Convert.ToInt32(dr["pId"]);
            }
            else
            {
                sql = "insert into ParamSettings(printCheckYes,pointCheckYes,pointTimes) values(1,0,1)";
                sqlh.NonQuery(sql,null,CommandType.Text);
            }
            dr.Close();
            return cps;
        }
        /// <summary>
        /// 更新参数设置
        /// </summary>
        /// <param name="cps"></param>
        /// <returns></returns>
        public bool UpdateParamSettings(CParamSettings cps)
        {
            List<SqlParameter> param = new List<SqlParameter>();
            param.Add(new SqlParameter("@printCheckYes",SqlDbType.Bit));
            param.Add(new SqlParameter("@pointCheckYes",SqlDbType.Bit));
            param.Add(new SqlParameter("@pointTimes",SqlDbType.Float));
            param.Add(new SqlParameter("@pId", SqlDbType.Int));
            param[0].Value = cps.PrintCheckYes;