SQLServerDAL/ETogo.cs

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

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

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

using WMPT.DBUtility;
using WMPT.Model;

// ETogo.cs:点餐商家数据访问层
// CopyRight (c) 2009-2016 WMPT Teconology. All Rights Reserved.
// 123@163.com.com 更新
// 2010-07-08

namespace WMPT.SQLServerDAL
{
    /// <summary>
    /// 数据访问类ETogo。
    /// </summary>
    public class Togo 
    {
        /// <summary>
        /// togo
        /// </summary>
        /// <param name="togono"></param>
        /// <returns></returns>
        public string GetPassKeyWithSN(string sn1)
        {
            string sql = "select PrinterKey from EPrinterSecret where PrinterNum = @togono";
            SqlParameter parameter = new SqlParameter("@togono", SqlDbType.VarChar, 20);
            parameter.Value = sn1;
            string pkey = "";

            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.Text, sql, parameter))
            {
                while (dr.Read())
                {
                    pkey = HJConvert.ToString(dr["PrinterKey"]);
                }
            }
            return pkey;
        }

        /// <summary>
        /// 根据打印机编号获取dataid,做为获取订单的编号
        /// </summary>
        /// <param name="sn2"></param>
        /// <returns></returns>
        public TogoPrinterInfo GetModelByTogoSN(string num)
        {
            string sql = "select *  from ETogoPrinter where PrinterSn = @togosn";
            SqlParameter parameter = new SqlParameter("@togosn", SqlDbType.VarChar, 20);
            parameter.Value = num;
            TogoPrinterInfo model = null;
            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.Text, sql, parameter))
            {
                while (dr.Read())
                {