SQLServerDAL/Custorder.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

using WMPT.Model;
using WMPT.Common;
using WMPT.DBUtility;
using System.Data;
using System.Collections;
using System.Data.SqlClient;

namespace WMPT.SQLServerDAL
{
    public class Custorder
    {
        /// <summary>
        /// 根据订单自增id 或者 订单编号  获取记录所有字段
        /// </summary>
        /// 此代码由杭景科技代码内部生成器自动生成
        /// <param>Unid</param>
        /// <returns>CustorderInfo</returns>
        public CustorderInfo GetOpenidAndDeliver(string orderid)
        {
            string sql = "SELECT P2Sign,Name,Phone FROM  dbo.Custorder LEFT JOIN dbo.Deliver ON dbo.Custorder.deliverid = dbo.Deliver.DataId WHERE orderid = '"+orderid+"' ";
            CustorderInfo model = null;
            using (SqlDataReader dr = SQLHelper.ExecuteReader(CommandType.Text, sql, null))
            {
                if (dr.Read())
                {
                    model = new CustorderInfo();

                    model.Sender = HJConvert.ToString(dr["Name"]);
                    model.CallPhoneNo = HJConvert.ToString(dr["Phone"]);
                    model.P2Sign = HJConvert.ToString(dr["P2Sign"]);
                    
                }
            }
            return model;
        }


        /// <summary>
        /// 增加一条数据
        /// </summary>
        public int Add(WMPT.Model.CustorderInfo model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("insert into custorder(");
            strSql.Append("Unid,InUse,OrderDateTime,OrderChecker,OrderStatus,OrderRcver,OrderComm,OrderAddress,AddressText,OrderAddrEx,OrderAttach,OrderSums,Sender,SendTime,CallPhoneNo,P2Sign,SendFee,paymode,paytime,paymoney,paystate,SetStateTime, UserId, TogoId)");
            strSql.Append(" values (");
            strSql.Append("@Unid,@InUse,@OrderDateTime,@OrderChecker,@OrderStatus,@OrderRcver,@OrderComm,@OrderAddress,@AddressText,@OrderAddrEx,@OrderAttach,@OrderSums,@Sender,@SendTime,@CallPhoneNo,@P2Sign,@SendFee,@paymode,@paytime,@paymoney,@paystate,@SetStateTime,@UserId, @TogoId)");
            SqlParameter[] parameters =
            {
                new SqlParameter("@Unid", SqlDbType.Int,4),
                new SqlParameter("@InUse", SqlDbType.VarChar,10),
                new SqlParameter("@OrderDateTime", SqlDbType.DateTime),
                new SqlParameter("@OrderChecker", SqlDbType.Int,4),
                new SqlParameter("@OrderStatus", SqlDbType.Int,4),
                new SqlParameter("@OrderRcver", SqlDbType.VarChar,50),