Hidistro.SqlDal/Settings/ShippingModeDao.cs

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

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

namespace Hidistro.SqlDal.Settings
{
    using Hidistro.Core;
    using Hidistro.Entities;
    using Hidistro.Entities.Settings;
    using Microsoft.Practices.EnterpriseLibrary.Data;
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Text;

    public class ShippingModeDao
    {
        private Database database = DatabaseFactory.CreateDatabase();
        public string Error = "";

        public bool CreateShippingTemplate(FreightTemplate freightTemplate)
        {
            this.Error = "";
            bool flag = false;


            DbCommand sqlStringCommand = this.database.GetSqlStringCommand(@"
                    declare @RoleId int ;
                    declare @MemberId int ;
                    declare @UserName nvarchar(50);
                    declare @ShopName nvarchar(50);

                    select @MemberId=MemberId,@RoleId=RoleId from aspnet_Managers where userid=@userID;
                    IF(@RoleId=1 OR @RoleId=4)
                    BEGIN
                    SET @userID=0;
                    END
                    ELSE
                    BEGIN
                    select  @ShopName=StoreName from aspnet_Distributors where UserId=@MemberId;
                    select  @UserName=UserName from aspnet_Members where UserId=@MemberId;
                    END;
            INSERT INTO Hishop_FreightTemplate_Templates(Name,FreeShip,MUnit,HasFree,ShopManageUserID,ShopUserName,ShopName)VALUES(@Name,@FreeShip,@MUnit,@HasFree,@userid,@userName,@ShopName)");
            this.database.AddInParameter(sqlStringCommand, "Name", DbType.String, freightTemplate.Name);
            this.database.AddInParameter(sqlStringCommand, "FreeShip", DbType.Int16, freightTemplate.FreeShip);
            this.database.AddInParameter(sqlStringCommand, "MUnit", DbType.Int16, freightTemplate.MUnit);
            this.database.AddInParameter(sqlStringCommand, "HasFree", DbType.Int16, freightTemplate.HasFree);
            this.database.AddInParameter(sqlStringCommand, "userID", DbType.Int32, Globals.GetCurrentManagerUserId());
            using (DbConnection connection = this.database.CreateConnection())
            {
                connection.Open();
                DbTransaction transaction = connection.BeginTransaction();
                try
                {
                    try
                    {
                        this.database.ExecuteNonQuery(sqlStringCommand, transaction);
                        sqlStringCommand = this.database.GetSqlStringCommand("SELECT @@Identity");
                        object obj2 = this.database.ExecuteScalar(sqlStringCommand, transaction);
                        int result = 0;
                        if ((obj2 != null) && (obj2 != DBNull.Value))
                        {
                            int.TryParse(obj2.ToString(), out result);