SQLServerDAL/PayPlatform.cs

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

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

using System;
using System.Data;
using System.Data.SqlClient;
using MyShop.IDAL;
using MyShop.Model;
using MyShop.Config;
using MyShop.Common;



namespace MyShop.SQLServerDAL
{
    public class PayPlatform : IPayPlatform
    {

        
        private string tableName = "PayPlatform";

        public PayPlatform()
        {
            if (!string.IsNullOrEmpty(BaseConfig.GetBaseConfig().TablePrefix.Trim()))
                tableName = BaseConfig.GetBaseConfig().TablePrefix + "PayPlatform";
        }

        #region IPayPlatform member


        /// <summary>
        /// add PayPlatform 
        /// </summary>
        /// <param name="model"></param>
        /// <returns>返回ID, 如果发生错误则返回-1</returns>
        public int Add(PayPlatformInfo model)
        {
            int result = 0;
            if (model == null)
            {
                return -1;
            }
            string sql = @"insert into " + tableName + "([PayPlatformName]	,[AccountsID]	,[MD5]	,[Rate]	,OrderId	,IsDisabled	,IsDefault	) values(@PayPlatformName,@AccountsID,@MD5,@Rate,@OrderId,@IsDisabled,@IsDefault) " + "; SELECT @@IDENTITY  ";

            SqlParameter[] prams = {
                Database.MakeInParam("@PayPlatformName",SqlDbType.NVarChar	,	50	,model.PayPlatformName	),
                Database.MakeInParam("@AccountsID",SqlDbType.NVarChar	,	50	,model.AccountsId	),
                Database.MakeInParam("@MD5",SqlDbType.NVarChar	,	255	,model.MD5	),
                Database.MakeInParam("@Rate",SqlDbType.Decimal,9,model.Rate	),
                Database.MakeInParam("@OrderId",SqlDbType.Int	,	4	,model.OrderId	),
                Database.MakeInParam("@IsDisabled",SqlDbType.TinyInt	,	1	,model.IsDisabled	),
                Database.MakeInParam("@IsDefault",SqlDbType.TinyInt	,	1	,model.IsDefault	)
            };

            try
            {

                result = (Convert.ToInt32(Database.ExecuteDataSet(sql, prams).Tables[0].Rows[0][0]));
            }
            catch
            {
                result = -1;
            }