DA/DBOpenBills.cs

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

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

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

namespace DA
{
    public class DBOpenBills : IDisposable
    {
        string sql;
        string sql1;
        SqlHelpers sqlh;
        DataSet ds;
        SqlDataReader dr;
        public  DBOpenBills()
        {
            sqlh = new SqlHelpers();
        }
        public DBOpenBills(SqlHelpers sh)
        {
            sqlh = sh;
        }
        public void Dispose()
        {
            sqlh.Dispose();
        }
        /// <summary>
        ///  插入结账信息的方法
        /// </summary>
        /// <param name="ob"></param>
        public bool DBOpenBillsInsert(COpenBills op)
        {
            /*List<SqlParameter> pars = new List<SqlParameter>();
            pars.Add(new SqlParameter("@opobId", SqlDbType.VarChar, 50));
            pars[0].Value = op.CobId1;
            pars.Add(new SqlParameter("@opTName", SqlDbType.VarChar, 50));
            pars[1].Value = op.TName;
            pars.Add(new SqlParameter("@mId", SqlDbType.VarChar, 50));
            pars[2].Value = op.CmId1;
            pars.Add(new SqlParameter("@opMoney", SqlDbType.Float));
            pars[3].Value = op.CopMoney1;
            pars.Add(new SqlParameter("@opSaveMoney", SqlDbType.Float));
            pars[4].Value = op.CopSaveMoney1;
            pars.Add(new SqlParameter("@opClientPay", SqlDbType.Float));
            pars[5].Value = op.CopClientPay1;
            pars.Add(new SqlParameter("@opRemark", SqlDbType.VarChar, 50));
            pars[6].Value = op.CopRemark1;
            pars.Add(new SqlParameter("@opAddress", SqlDbType.VarChar, 50));
            pars[7].Value = op.CopAddress1;
            // sql = "insert into OpenBills values(@opobId,@opTName,@mId,@opMoney,@opSaveMoney,@opClientPay,@opRemark)";
            sql = "insert into OpenBills values(@opobId,@opTName,@mId,@opMoney,@opSaveMoney,@opClientPay,@opRemark,@opAddress)";

            sqlh.NonQuery(sql, pars, CommandType.Text);*/

            string sqlStr = "insert into OpenBills(obId,TName,mId,opMoney,opSaveMoney,opClientPay,opRemark,opAddress,opCardPay,opTableMark,opPayType,opPerson)" +
                " values('{0}','{1}','{2}',{3},{4},{5},'{6}','{7}',{8},'{9}','{10}','{11}')";
            sql = string.Format(sqlStr, op.CobId1,op.TName,op.CmId1,op.CopMoney1,op.CopSaveMoney1,op.CopClientPay1,
                op.CopRemark1, op.CopAddress1, op.CopCardPay1, op.CopTableRemark1, op.CopPayType1,op.CopPerson1);