コード例 #1
0
        public int SpAppUserAdd(int? shopid, string password, string usertype, string username, string status, System.DateTime? createdt, string createuser, string loginstatus, out int? appuserid)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var passwordParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@password", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = password, Size = 100 };
            if (passwordParam.Value == null)
                passwordParam.Value = System.DBNull.Value;

            var usertypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@usertype", SqlDbType = System.Data.SqlDbType.NChar, Direction = System.Data.ParameterDirection.Input, Value = usertype, Size = 1 };
            if (usertypeParam.Value == null)
                usertypeParam.Value = System.DBNull.Value;

            var usernameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@username", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = username, Size = 100 };
            if (usernameParam.Value == null)
                usernameParam.Value = System.DBNull.Value;

            var statusParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@status", SqlDbType = System.Data.SqlDbType.NChar, Direction = System.Data.ParameterDirection.Input, Value = status, Size = 1 };
            if (statusParam.Value == null)
                statusParam.Value = System.DBNull.Value;

            var createdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createdt.GetValueOrDefault() };
            if (!createdt.HasValue)
                createdtParam.Value = System.DBNull.Value;

            var createuserParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createuser", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = createuser, Size = 100 };
            if (createuserParam.Value == null)
                createuserParam.Value = System.DBNull.Value;

            var loginstatusParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@loginstatus", SqlDbType = System.Data.SqlDbType.NChar, Direction = System.Data.ParameterDirection.Input, Value = loginstatus, Size = 1 };
            if (loginstatusParam.Value == null)
                loginstatusParam.Value = System.DBNull.Value;

            var appuseridParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@appuserid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output, Precision = 10, Scale = 0 };
            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[SP_AppUser_ADD] @shopid, @password, @usertype, @username, @status, @createdt, @createuser, @loginstatus, @appuserid OUTPUT", shopidParam, passwordParam, usertypeParam, usernameParam, statusParam, createdtParam, createuserParam, loginstatusParam, appuseridParam, procResultParam);
            if (IsSqlParameterNull(appuseridParam))
                appuserid = null;
            else
                appuserid = (int)appuseridParam.Value;

            return (int)procResultParam.Value;
        }
コード例 #2
0
        public int SpMenuUpdate(int? mid, int? shopid, string menuCat, string menuName, string menuName2, string menuDesc, string menuDesc2, decimal? price1, decimal? price2, string menutype, string menulogo, string menucode, string servicePeriod, string displayweekday, string hasSideOrder, string hasPl, System.DateTime? updateDt, string flag, decimal? indexnum, int? mealamt)
        {
            var midParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@mid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = mid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!mid.HasValue)
                midParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var menuCatParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@menuCat", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menuCat, Size = 30 };
            if (menuCatParam.Value == null)
                menuCatParam.Value = System.DBNull.Value;

            var menuNameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@menuName", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menuName, Size = 200 };
            if (menuNameParam.Value == null)
                menuNameParam.Value = System.DBNull.Value;

            var menuName2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@menuName2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menuName2, Size = 200 };
            if (menuName2Param.Value == null)
                menuName2Param.Value = System.DBNull.Value;

            var menuDescParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@menuDesc", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menuDesc, Size = 500 };
            if (menuDescParam.Value == null)
                menuDescParam.Value = System.DBNull.Value;

            var menuDesc2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@menuDesc2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menuDesc2, Size = 500 };
            if (menuDesc2Param.Value == null)
                menuDesc2Param.Value = System.DBNull.Value;

            var price1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@price1", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = price1.GetValueOrDefault(), Precision = 10, Scale = 2 };
            if (!price1.HasValue)
                price1Param.Value = System.DBNull.Value;

            var price2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@price2", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = price2.GetValueOrDefault(), Precision = 10, Scale = 2 };
            if (!price2.HasValue)
                price2Param.Value = System.DBNull.Value;

            var menutypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@menutype", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = menutype, Size = 1 };
            if (menutypeParam.Value == null)
                menutypeParam.Value = System.DBNull.Value;

            var menulogoParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@menulogo", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menulogo, Size = 100 };
            if (menulogoParam.Value == null)
                menulogoParam.Value = System.DBNull.Value;

            var menucodeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@menucode", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menucode, Size = 20 };
            if (menucodeParam.Value == null)
                menucodeParam.Value = System.DBNull.Value;

            var servicePeriodParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@servicePeriod", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = servicePeriod, Size = 1 };
            if (servicePeriodParam.Value == null)
                servicePeriodParam.Value = System.DBNull.Value;

            var displayweekdayParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@displayweekday", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = displayweekday, Size = 50 };
            if (displayweekdayParam.Value == null)
                displayweekdayParam.Value = System.DBNull.Value;

            var hasSideOrderParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@hasSideOrder", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = hasSideOrder, Size = 1 };
            if (hasSideOrderParam.Value == null)
                hasSideOrderParam.Value = System.DBNull.Value;

            var hasPlParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@hasPL", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = hasPl, Size = 1 };
            if (hasPlParam.Value == null)
                hasPlParam.Value = System.DBNull.Value;

            var updateDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@UpdateDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = updateDt.GetValueOrDefault() };
            if (!updateDt.HasValue)
                updateDtParam.Value = System.DBNull.Value;

            var flagParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@flag", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = flag, Size = 50 };
            if (flagParam.Value == null)
                flagParam.Value = System.DBNull.Value;

            var indexnumParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@indexnum", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = indexnum.GetValueOrDefault(), Precision = 8, Scale = 1 };
            if (!indexnum.HasValue)
                indexnumParam.Value = System.DBNull.Value;

            var mealamtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@mealamt", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = mealamt.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!mealamt.HasValue)
                mealamtParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_menu_Update] @mid, @shopid, @menuCat, @menuName, @menuName2, @menuDesc, @menuDesc2, @price1, @price2, @menutype, @menulogo, @menucode, @servicePeriod, @displayweekday, @hasSideOrder, @hasPL, @UpdateDT, @flag, @indexnum, @mealamt", midParam, shopidParam, menuCatParam, menuNameParam, menuName2Param, menuDescParam, menuDesc2Param, price1Param, price2Param, menutypeParam, menulogoParam, menucodeParam, servicePeriodParam, displayweekdayParam, hasSideOrderParam, hasPlParam, updateDtParam, flagParam, indexnumParam, mealamtParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #3
0
        public int JzDetailtmp(System.DateTime? frdt, System.DateTime? todt, int? shopid, int? jzid, out string ret)
        {
            var frdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@frdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = frdt.GetValueOrDefault() };
            if (!frdt.HasValue)
                frdtParam.Value = System.DBNull.Value;

            var todtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@todt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = todt.GetValueOrDefault() };
            if (!todt.HasValue)
                todtParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var jzidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@jzid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = jzid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!jzid.HasValue)
                jzidParam.Value = System.DBNull.Value;

            var retParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ret", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Output, Size = 50 };
            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[JZDetailtmp] @frdt, @todt, @shopid, @jzid, @ret OUTPUT", frdtParam, todtParam, shopidParam, jzidParam, retParam, procResultParam);
            if (IsSqlParameterNull(retParam))
                ret = default(string);
            else
                ret = (string)retParam.Value;

            return (int)procResultParam.Value;
        }
コード例 #4
0
        public int SpAdvpicAdd(int? advid, string pc, string townname, int? shopid, string shoploginname, System.DateTime? starttime, System.DateTime? endtime, string urllink, string advPic, int? indexno, int? clicknum)
        {
            var advidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@advid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = advid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!advid.HasValue)
                advidParam.Value = System.DBNull.Value;

            var pcParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@pc", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = pc, Size = 10 };
            if (pcParam.Value == null)
                pcParam.Value = System.DBNull.Value;

            var townnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@townname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = townname, Size = 50 };
            if (townnameParam.Value == null)
                townnameParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var shoploginnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shoploginname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = shoploginname, Size = 20 };
            if (shoploginnameParam.Value == null)
                shoploginnameParam.Value = System.DBNull.Value;

            var starttimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@starttime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = starttime.GetValueOrDefault() };
            if (!starttime.HasValue)
                starttimeParam.Value = System.DBNull.Value;

            var endtimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@endtime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = endtime.GetValueOrDefault() };
            if (!endtime.HasValue)
                endtimeParam.Value = System.DBNull.Value;

            var urllinkParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@urllink", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = urllink, Size = 300 };
            if (urllinkParam.Value == null)
                urllinkParam.Value = System.DBNull.Value;

            var advPicParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@advPic", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = advPic, Size = 100 };
            if (advPicParam.Value == null)
                advPicParam.Value = System.DBNull.Value;

            var indexnoParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@indexno", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = indexno.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!indexno.HasValue)
                indexnoParam.Value = System.DBNull.Value;

            var clicknumParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@clicknum", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = clicknum.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!clicknum.HasValue)
                clicknumParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_advpic_ADD] @advid, @pc, @townname, @shopid, @shoploginname, @starttime, @endtime, @urllink, @advPic, @indexno, @clicknum", advidParam, pcParam, townnameParam, shopidParam, shoploginnameParam, starttimeParam, endtimeParam, urllinkParam, advPicParam, indexnoParam, clicknumParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #5
0
        public int UpOrderczAdd(System.DateTime? czdt, string orderid, string comments, decimal? amt, string operateid)
        {
            var czdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@czdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = czdt.GetValueOrDefault() };
            if (!czdt.HasValue)
                czdtParam.Value = System.DBNull.Value;

            var orderidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderid, Size = 50 };
            if (orderidParam.Value == null)
                orderidParam.Value = System.DBNull.Value;

            var commentsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@comments", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = comments, Size = 200 };
            if (commentsParam.Value == null)
                commentsParam.Value = System.DBNull.Value;

            var amtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@amt", SqlDbType = System.Data.SqlDbType.Decimal, Direction = System.Data.ParameterDirection.Input, Value = amt.GetValueOrDefault(), Precision = 18, Scale = 2 };
            if (!amt.HasValue)
                amtParam.Value = System.DBNull.Value;

            var operateidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@operateid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = operateid, Size = 50 };
            if (operateidParam.Value == null)
                operateidParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_ordercz_ADD] @czdt, @orderid, @comments, @amt, @operateid", czdtParam, orderidParam, commentsParam, amtParam, operateidParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #6
0
        public int UpShoppingHolidayAdd(int? shopid, System.DateTime? fromDt, System.DateTime? toDt)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var fromDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@fromDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = fromDt.GetValueOrDefault() };
            if (!fromDt.HasValue)
                fromDtParam.Value = System.DBNull.Value;

            var toDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@toDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = toDt.GetValueOrDefault() };
            if (!toDt.HasValue)
                toDtParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_shoppingHoliday_ADD] @shopid, @fromDT, @toDT", shopidParam, fromDtParam, toDtParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #7
0
        public int SpShopDelieveryAreaAdd(int? shopid, string postcode1, decimal? delieveryCost, string comments, System.DateTime? createDt, string flag1, string bak001)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var postcode1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode1, Size = 10 };
            if (postcode1Param.Value == null)
                postcode1Param.Value = System.DBNull.Value;

            var delieveryCostParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@delieveryCost", SqlDbType = System.Data.SqlDbType.Decimal, Direction = System.Data.ParameterDirection.Input, Value = delieveryCost.GetValueOrDefault(), Precision = 8, Scale = 2 };
            if (!delieveryCost.HasValue)
                delieveryCostParam.Value = System.DBNull.Value;

            var commentsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@comments", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = comments, Size = 200 };
            if (commentsParam.Value == null)
                commentsParam.Value = System.DBNull.Value;

            var createDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createDt.GetValueOrDefault() };
            if (!createDt.HasValue)
                createDtParam.Value = System.DBNull.Value;

            var flag1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@flag1", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = flag1, Size = 1 };
            if (flag1Param.Value == null)
                flag1Param.Value = System.DBNull.Value;

            var bak001Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@bak001", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = bak001, Size = 50 };
            if (bak001Param.Value == null)
                bak001Param.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_shopDelieveryArea_ADD] @shopid, @postcode1, @delieveryCost, @comments, @createDT, @flag1, @bak001", shopidParam, postcode1Param, delieveryCostParam, commentsParam, createDtParam, flag1Param, bak001Param, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #8
0
        public int UpMenuCatUpdate(int? catid, int? shopid, string catName, string catName2, string description, string description2, string servicePeriod, string displayweekday, string pcsetting, System.DateTime? modifiedDt, decimal? indexnum, string logostr)
        {
            var catidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@catid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = catid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!catid.HasValue)
                catidParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var catNameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@catName", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = catName, Size = 100 };
            if (catNameParam.Value == null)
                catNameParam.Value = System.DBNull.Value;

            var catName2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@catName2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = catName2, Size = 100 };
            if (catName2Param.Value == null)
                catName2Param.Value = System.DBNull.Value;

            var descriptionParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@description", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = description, Size = 500 };
            if (descriptionParam.Value == null)
                descriptionParam.Value = System.DBNull.Value;

            var description2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@description2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = description2, Size = 500 };
            if (description2Param.Value == null)
                description2Param.Value = System.DBNull.Value;

            var servicePeriodParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@servicePeriod", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = servicePeriod, Size = 1 };
            if (servicePeriodParam.Value == null)
                servicePeriodParam.Value = System.DBNull.Value;

            var displayweekdayParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@displayweekday", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = displayweekday, Size = 50 };
            if (displayweekdayParam.Value == null)
                displayweekdayParam.Value = System.DBNull.Value;

            var pcsettingParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@pcsetting", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = pcsetting, Size = 50 };
            if (pcsettingParam.Value == null)
                pcsettingParam.Value = System.DBNull.Value;

            var modifiedDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@modifiedDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = modifiedDt.GetValueOrDefault() };
            if (!modifiedDt.HasValue)
                modifiedDtParam.Value = System.DBNull.Value;

            var indexnumParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@indexnum", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = indexnum.GetValueOrDefault(), Precision = 8, Scale = 1 };
            if (!indexnum.HasValue)
                indexnumParam.Value = System.DBNull.Value;

            var logostrParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@logostr", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = logostr, Size = 80 };
            if (logostrParam.Value == null)
                logostrParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_menuCat_Update] @catid, @shopid, @catName, @catName2, @description, @description2, @servicePeriod, @displayweekday, @pcsetting, @modifiedDT, @indexnum, @logostr", catidParam, shopidParam, catNameParam, catName2Param, descriptionParam, description2Param, servicePeriodParam, displayweekdayParam, pcsettingParam, modifiedDtParam, indexnumParam, logostrParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #9
0
        public int SpShopUpdate2(int? shopid, string sname, string sname2, string mealtype, string tel1, string tel2, string fax, string email, string contactname, string contactTel, string addr1, string addr2, string cityname, string postcode1, string postcode2, string description, System.DateTime? updateTime, string alias, string acceptpay, string orderlang, string acceptorder)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var snameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@sname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = sname, Size = 100 };
            if (snameParam.Value == null)
                snameParam.Value = System.DBNull.Value;

            var sname2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@sname2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = sname2, Size = 100 };
            if (sname2Param.Value == null)
                sname2Param.Value = System.DBNull.Value;

            var mealtypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@mealtype", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = mealtype, Size = 50 };
            if (mealtypeParam.Value == null)
                mealtypeParam.Value = System.DBNull.Value;

            var tel1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@tel1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = tel1, Size = 50 };
            if (tel1Param.Value == null)
                tel1Param.Value = System.DBNull.Value;

            var tel2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@tel2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = tel2, Size = 50 };
            if (tel2Param.Value == null)
                tel2Param.Value = System.DBNull.Value;

            var faxParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@fax", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = fax, Size = 50 };
            if (faxParam.Value == null)
                faxParam.Value = System.DBNull.Value;

            var emailParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@email", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = email, Size = 100 };
            if (emailParam.Value == null)
                emailParam.Value = System.DBNull.Value;

            var contactnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@contactname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = contactname, Size = 50 };
            if (contactnameParam.Value == null)
                contactnameParam.Value = System.DBNull.Value;

            var contactTelParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@contactTel", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = contactTel, Size = 50 };
            if (contactTelParam.Value == null)
                contactTelParam.Value = System.DBNull.Value;

            var addr1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@addr1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = addr1, Size = 100 };
            if (addr1Param.Value == null)
                addr1Param.Value = System.DBNull.Value;

            var addr2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@addr2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = addr2, Size = 100 };
            if (addr2Param.Value == null)
                addr2Param.Value = System.DBNull.Value;

            var citynameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@cityname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = cityname, Size = 100 };
            if (citynameParam.Value == null)
                citynameParam.Value = System.DBNull.Value;

            var postcode1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode1, Size = 50 };
            if (postcode1Param.Value == null)
                postcode1Param.Value = System.DBNull.Value;

            var postcode2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode2, Size = 50 };
            if (postcode2Param.Value == null)
                postcode2Param.Value = System.DBNull.Value;

            var descriptionParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@description", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = description, Size = 3000 };
            if (descriptionParam.Value == null)
                descriptionParam.Value = System.DBNull.Value;

            var updateTimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@updateTime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = updateTime.GetValueOrDefault() };
            if (!updateTime.HasValue)
                updateTimeParam.Value = System.DBNull.Value;

            var aliasParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@alias", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = alias, Size = 100 };
            if (aliasParam.Value == null)
                aliasParam.Value = System.DBNull.Value;

            var acceptpayParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@acceptpay", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = acceptpay, Size = 10 };
            if (acceptpayParam.Value == null)
                acceptpayParam.Value = System.DBNull.Value;

            var orderlangParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderlang", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderlang, Size = 10 };
            if (orderlangParam.Value == null)
                orderlangParam.Value = System.DBNull.Value;

            var acceptorderParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@acceptorder", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = acceptorder, Size = 20 };
            if (acceptorderParam.Value == null)
                acceptorderParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_shop_Update2] @shopid, @sname, @sname2, @mealtype, @tel1, @tel2, @fax, @email, @contactname, @contactTel, @addr1, @addr2, @cityname, @postcode1, @postcode2, @description, @updateTime, @alias, @acceptpay, @orderlang, @acceptorder", shopidParam, snameParam, sname2Param, mealtypeParam, tel1Param, tel2Param, faxParam, emailParam, contactnameParam, contactTelParam, addr1Param, addr2Param, citynameParam, postcode1Param, postcode2Param, descriptionParam, updateTimeParam, aliasParam, acceptpayParam, orderlangParam, acceptorderParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #10
0
        public int SpShopUpdate3(int? shopid, string description, System.DateTime? updateTime, string alias, string orderlang)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var descriptionParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@description", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = description, Size = 3000 };
            if (descriptionParam.Value == null)
                descriptionParam.Value = System.DBNull.Value;

            var updateTimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@updateTime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = updateTime.GetValueOrDefault() };
            if (!updateTime.HasValue)
                updateTimeParam.Value = System.DBNull.Value;

            var aliasParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@alias", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = alias, Size = 100 };
            if (aliasParam.Value == null)
                aliasParam.Value = System.DBNull.Value;

            var orderlangParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderlang", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderlang, Size = 10 };
            if (orderlangParam.Value == null)
                orderlangParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_shop_Update3] @shopid, @description, @updateTime, @alias, @orderlang", shopidParam, descriptionParam, updateTimeParam, aliasParam, orderlangParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #11
0
        public int SpOrdersAdd(out string orderId, int? shopid, int? uid, string useremail, string payway, string ispaid, string ticketnumber, int? ticketvalue, string deliveryway, string comments, string orderstatus, System.DateTime? ordercreatedt, string isCancelled, decimal? totalprice1, decimal? discountRate, decimal? afterdiscount, decimal? deliverycharge, decimal? serviceCharge, decimal? creditcardCharge, decimal? tips, string isjz, decimal? totalamount, string userIp, System.DateTime? pickupdt, decimal? commrate, string isnew, decimal? shopcardcharge, decimal? paidwithcredit, string vouchercode)
        {
            var orderIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@OrderID", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Output, Size = 30 };
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var uidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@uid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = uid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!uid.HasValue)
                uidParam.Value = System.DBNull.Value;

            var useremailParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@useremail", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = useremail, Size = 100 };
            if (useremailParam.Value == null)
                useremailParam.Value = System.DBNull.Value;

            var paywayParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@payway", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = payway, Size = 1 };
            if (paywayParam.Value == null)
                paywayParam.Value = System.DBNull.Value;

            var ispaidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ispaid", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = ispaid, Size = 1 };
            if (ispaidParam.Value == null)
                ispaidParam.Value = System.DBNull.Value;

            var ticketnumberParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ticketnumber", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = ticketnumber, Size = 50 };
            if (ticketnumberParam.Value == null)
                ticketnumberParam.Value = System.DBNull.Value;

            var ticketvalueParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ticketvalue", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = ticketvalue.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!ticketvalue.HasValue)
                ticketvalueParam.Value = System.DBNull.Value;

            var deliverywayParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@deliveryway", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = deliveryway, Size = 1 };
            if (deliverywayParam.Value == null)
                deliverywayParam.Value = System.DBNull.Value;

            var commentsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@comments", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = comments, Size = 500 };
            if (commentsParam.Value == null)
                commentsParam.Value = System.DBNull.Value;

            var orderstatusParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderstatus", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderstatus, Size = 50 };
            if (orderstatusParam.Value == null)
                orderstatusParam.Value = System.DBNull.Value;

            var ordercreatedtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ordercreatedt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = ordercreatedt.GetValueOrDefault() };
            if (!ordercreatedt.HasValue)
                ordercreatedtParam.Value = System.DBNull.Value;

            var isCancelledParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isCancelled", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isCancelled, Size = 1 };
            if (isCancelledParam.Value == null)
                isCancelledParam.Value = System.DBNull.Value;

            var totalprice1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@totalprice1", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = totalprice1.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!totalprice1.HasValue)
                totalprice1Param.Value = System.DBNull.Value;

            var discountRateParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@discountRate", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = discountRate.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!discountRate.HasValue)
                discountRateParam.Value = System.DBNull.Value;

            var afterdiscountParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@afterdiscount", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = afterdiscount.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!afterdiscount.HasValue)
                afterdiscountParam.Value = System.DBNull.Value;

            var deliverychargeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@deliverycharge", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = deliverycharge.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!deliverycharge.HasValue)
                deliverychargeParam.Value = System.DBNull.Value;

            var serviceChargeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@serviceCharge", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = serviceCharge.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!serviceCharge.HasValue)
                serviceChargeParam.Value = System.DBNull.Value;

            var creditcardChargeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@creditcardCharge", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = creditcardCharge.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!creditcardCharge.HasValue)
                creditcardChargeParam.Value = System.DBNull.Value;

            var tipsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@tips", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = tips.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!tips.HasValue)
                tipsParam.Value = System.DBNull.Value;

            var isjzParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isjz", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isjz, Size = 1 };
            if (isjzParam.Value == null)
                isjzParam.Value = System.DBNull.Value;

            var totalamountParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@totalamount", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = totalamount.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!totalamount.HasValue)
                totalamountParam.Value = System.DBNull.Value;

            var userIpParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@userIP", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = userIp, Size = 100 };
            if (userIpParam.Value == null)
                userIpParam.Value = System.DBNull.Value;

            var pickupdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@pickupdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = pickupdt.GetValueOrDefault() };
            if (!pickupdt.HasValue)
                pickupdtParam.Value = System.DBNull.Value;

            var commrateParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@commrate", SqlDbType = System.Data.SqlDbType.Decimal, Direction = System.Data.ParameterDirection.Input, Value = commrate.GetValueOrDefault(), Precision = 5, Scale = 2 };
            if (!commrate.HasValue)
                commrateParam.Value = System.DBNull.Value;

            var isnewParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isnew", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isnew, Size = 1 };
            if (isnewParam.Value == null)
                isnewParam.Value = System.DBNull.Value;

            var shopcardchargeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopcardcharge", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = shopcardcharge.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!shopcardcharge.HasValue)
                shopcardchargeParam.Value = System.DBNull.Value;

            var paidwithcreditParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@paidwithcredit", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = paidwithcredit.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!paidwithcredit.HasValue)
                paidwithcreditParam.Value = System.DBNull.Value;

            var vouchercodeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@vouchercode", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = vouchercode, Size = 30 };
            if (vouchercodeParam.Value == null)
                vouchercodeParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_orders_ADD] @OrderID OUTPUT, @shopid, @uid, @useremail, @payway, @ispaid, @ticketnumber, @ticketvalue, @deliveryway, @comments, @orderstatus, @ordercreatedt, @isCancelled, @totalprice1, @discountRate, @afterdiscount, @deliverycharge, @serviceCharge, @creditcardCharge, @tips, @isjz, @totalamount, @userIP, @pickupdt, @commrate, @isnew, @shopcardcharge, @paidwithcredit, @vouchercode", orderIdParam, shopidParam, uidParam, useremailParam, paywayParam, ispaidParam, ticketnumberParam, ticketvalueParam, deliverywayParam, commentsParam, orderstatusParam, ordercreatedtParam, isCancelledParam, totalprice1Param, discountRateParam, afterdiscountParam, deliverychargeParam, serviceChargeParam, creditcardChargeParam, tipsParam, isjzParam, totalamountParam, userIpParam, pickupdtParam, commrateParam, isnewParam, shopcardchargeParam, paidwithcreditParam, vouchercodeParam, procResultParam);
            if (IsSqlParameterNull(orderIdParam))
                orderId = default(string);
            else
                orderId = (string)orderIdParam.Value;

            return (int)procResultParam.Value;
        }
コード例 #12
0
        public int SpOrderpaymentAdd(string orderid, string cardnumber, string cardtype, string name1, string name2, System.DateTime? paidtime, System.DateTime? applytime, decimal? paidamount, string isret)
        {
            var orderidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderid, Size = 30 };
            if (orderidParam.Value == null)
                orderidParam.Value = System.DBNull.Value;

            var cardnumberParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@cardnumber", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = cardnumber, Size = 50 };
            if (cardnumberParam.Value == null)
                cardnumberParam.Value = System.DBNull.Value;

            var cardtypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@cardtype", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = cardtype, Size = 1 };
            if (cardtypeParam.Value == null)
                cardtypeParam.Value = System.DBNull.Value;

            var name1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@name1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = name1, Size = 50 };
            if (name1Param.Value == null)
                name1Param.Value = System.DBNull.Value;

            var name2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@name2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = name2, Size = 50 };
            if (name2Param.Value == null)
                name2Param.Value = System.DBNull.Value;

            var paidtimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@paidtime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = paidtime.GetValueOrDefault() };
            if (!paidtime.HasValue)
                paidtimeParam.Value = System.DBNull.Value;

            var applytimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@applytime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = applytime.GetValueOrDefault() };
            if (!applytime.HasValue)
                applytimeParam.Value = System.DBNull.Value;

            var paidamountParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@paidamount", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = paidamount.GetValueOrDefault(), Precision = 10, Scale = 4 };
            if (!paidamount.HasValue)
                paidamountParam.Value = System.DBNull.Value;

            var isretParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isret", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isret, Size = 1 };
            if (isretParam.Value == null)
                isretParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_orderpayment_ADD] @orderid, @cardnumber, @cardtype, @name1, @name2, @paidtime, @applytime, @paidamount, @isret", orderidParam, cardnumberParam, cardtypeParam, name1Param, name2Param, paidtimeParam, applytimeParam, paidamountParam, isretParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #13
0
        public int SpOrderdeliveryAdd(string orderid, string addr1, string addr2, string addr3, string townname, string postcode1, string postcode2, string contactname, string tel1, string tel2, System.DateTime? deliverdt, string deliverpeople, string comments)
        {
            var orderidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderid, Size = 30 };
            if (orderidParam.Value == null)
                orderidParam.Value = System.DBNull.Value;

            var addr1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@addr1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = addr1, Size = 100 };
            if (addr1Param.Value == null)
                addr1Param.Value = System.DBNull.Value;

            var addr2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@addr2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = addr2, Size = 100 };
            if (addr2Param.Value == null)
                addr2Param.Value = System.DBNull.Value;

            var addr3Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@addr3", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = addr3, Size = 100 };
            if (addr3Param.Value == null)
                addr3Param.Value = System.DBNull.Value;

            var townnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@townname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = townname, Size = 100 };
            if (townnameParam.Value == null)
                townnameParam.Value = System.DBNull.Value;

            var postcode1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode1, Size = 10 };
            if (postcode1Param.Value == null)
                postcode1Param.Value = System.DBNull.Value;

            var postcode2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode2, Size = 10 };
            if (postcode2Param.Value == null)
                postcode2Param.Value = System.DBNull.Value;

            var contactnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@contactname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = contactname, Size = 50 };
            if (contactnameParam.Value == null)
                contactnameParam.Value = System.DBNull.Value;

            var tel1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@tel1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = tel1, Size = 50 };
            if (tel1Param.Value == null)
                tel1Param.Value = System.DBNull.Value;

            var tel2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@tel2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = tel2, Size = 50 };
            if (tel2Param.Value == null)
                tel2Param.Value = System.DBNull.Value;

            var deliverdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@deliverdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = deliverdt.GetValueOrDefault() };
            if (!deliverdt.HasValue)
                deliverdtParam.Value = System.DBNull.Value;

            var deliverpeopleParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@deliverpeople", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = deliverpeople, Size = 50 };
            if (deliverpeopleParam.Value == null)
                deliverpeopleParam.Value = System.DBNull.Value;

            var commentsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@comments", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = comments, Size = 300 };
            if (commentsParam.Value == null)
                commentsParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_orderdelivery_ADD] @orderid, @addr1, @addr2, @addr3, @townname, @postcode1, @postcode2, @contactname, @tel1, @tel2, @deliverdt, @deliverpeople, @comments", orderidParam, addr1Param, addr2Param, addr3Param, townnameParam, postcode1Param, postcode2Param, contactnameParam, tel1Param, tel2Param, deliverdtParam, deliverpeopleParam, commentsParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #14
0
        public int UpFavouritesAdd(out int? fid, int? uid, string ftype, int? shopid, int? mid, System.DateTime? createDt, string flag)
        {
            var fidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@fid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output, Precision = 10, Scale = 0 };
            var uidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@uid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = uid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!uid.HasValue)
                uidParam.Value = System.DBNull.Value;

            var ftypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ftype", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = ftype, Size = 10 };
            if (ftypeParam.Value == null)
                ftypeParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var midParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@mid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = mid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!mid.HasValue)
                midParam.Value = System.DBNull.Value;

            var createDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createDt.GetValueOrDefault() };
            if (!createDt.HasValue)
                createDtParam.Value = System.DBNull.Value;

            var flagParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@flag", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = flag, Size = 50 };
            if (flagParam.Value == null)
                flagParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_favourites_ADD] @fid OUTPUT, @uid, @ftype, @shopid, @mid, @createDT, @flag", fidParam, uidParam, ftypeParam, shopidParam, midParam, createDtParam, flagParam, procResultParam);
            if (IsSqlParameterNull(fidParam))
                fid = null;
            else
                fid = (int)fidParam.Value;

            return (int)procResultParam.Value;
        }
コード例 #15
0
        public int SpShoppingCartAdd(int? customerId, string customerSessionId, System.DateTime? createdOn, System.DateTime? updateOn, int? shopid, int? productId, int? mainfoodid, string menuOptionIDs, string subProductId, int? quantity)
        {
            var customerIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@customerID", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = customerId.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!customerId.HasValue)
                customerIdParam.Value = System.DBNull.Value;

            var customerSessionIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@customerSessionID", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = customerSessionId, Size = 50 };
            if (customerSessionIdParam.Value == null)
                customerSessionIdParam.Value = System.DBNull.Value;

            var createdOnParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@CreatedOn", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createdOn.GetValueOrDefault() };
            if (!createdOn.HasValue)
                createdOnParam.Value = System.DBNull.Value;

            var updateOnParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@UpdateOn", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = updateOn.GetValueOrDefault() };
            if (!updateOn.HasValue)
                updateOnParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var productIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ProductID", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = productId.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!productId.HasValue)
                productIdParam.Value = System.DBNull.Value;

            var mainfoodidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@mainfoodid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = mainfoodid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!mainfoodid.HasValue)
                mainfoodidParam.Value = System.DBNull.Value;

            var menuOptionIDsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@MenuOptionIDs", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = menuOptionIDs, Size = 1000 };
            if (menuOptionIDsParam.Value == null)
                menuOptionIDsParam.Value = System.DBNull.Value;

            var subProductIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@SubProductID", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = subProductId, Size = 1000 };
            if (subProductIdParam.Value == null)
                subProductIdParam.Value = System.DBNull.Value;

            var quantityParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@Quantity", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = quantity.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!quantity.HasValue)
                quantityParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_ShoppingCart_ADD] @customerID, @customerSessionID, @CreatedOn, @UpdateOn, @shopid, @ProductID, @mainfoodid, @MenuOptionIDs, @SubProductID, @Quantity", customerIdParam, customerSessionIdParam, createdOnParam, updateOnParam, shopidParam, productIdParam, mainfoodidParam, menuOptionIDsParam, subProductIdParam, quantityParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #16
0
        public int CancelOrders(string orderid, string isCancelled, System.DateTime? orderCancelledDt, string cancelComments)
        {
            var orderidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderid, Size = 30 };
            if (orderidParam.Value == null)
                orderidParam.Value = System.DBNull.Value;

            var isCancelledParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isCancelled", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isCancelled, Size = 1 };
            if (isCancelledParam.Value == null)
                isCancelledParam.Value = System.DBNull.Value;

            var orderCancelledDtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderCancelledDT", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = orderCancelledDt.GetValueOrDefault() };
            if (!orderCancelledDt.HasValue)
                orderCancelledDtParam.Value = System.DBNull.Value;

            var cancelCommentsParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@cancelComments", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = cancelComments, Size = 300 };
            if (cancelCommentsParam.Value == null)
                cancelCommentsParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[CancelOrders] @orderid, @isCancelled, @orderCancelledDT, @cancelComments", orderidParam, isCancelledParam, orderCancelledDtParam, cancelCommentsParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #17
0
        public int SpShoppingCartUpdate(int? cartid, int? customerId, string customerSessionId, System.DateTime? updateOn, int? quantity, int? productId, string subProductId, string opt)
        {
            var cartidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@cartid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = cartid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!cartid.HasValue)
                cartidParam.Value = System.DBNull.Value;

            var customerIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@customerID", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = customerId.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!customerId.HasValue)
                customerIdParam.Value = System.DBNull.Value;

            var customerSessionIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@customerSessionID", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = customerSessionId, Size = 50 };
            if (customerSessionIdParam.Value == null)
                customerSessionIdParam.Value = System.DBNull.Value;

            var updateOnParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@UpdateOn", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = updateOn.GetValueOrDefault() };
            if (!updateOn.HasValue)
                updateOnParam.Value = System.DBNull.Value;

            var quantityParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@Quantity", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = quantity.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!quantity.HasValue)
                quantityParam.Value = System.DBNull.Value;

            var productIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ProductID", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = productId.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!productId.HasValue)
                productIdParam.Value = System.DBNull.Value;

            var subProductIdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@SubProductID", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = subProductId, Size = 500 };
            if (subProductIdParam.Value == null)
                subProductIdParam.Value = System.DBNull.Value;

            var optParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@opt", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = opt, Size = 1 };
            if (optParam.Value == null)
                optParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_ShoppingCart_Update] @cartid, @customerID, @customerSessionID, @UpdateOn, @Quantity, @ProductID, @SubProductID, @opt", cartidParam, customerIdParam, customerSessionIdParam, updateOnParam, quantityParam, productIdParam, subProductIdParam, optParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #18
0
        public int UpOnlineUserAdd(int? uid, string urealname, System.DateTime? loginTime, System.DateTime? lastUpdateTime, string utype)
        {
            var uidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@uid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = uid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!uid.HasValue)
                uidParam.Value = System.DBNull.Value;

            var urealnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@urealname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = urealname, Size = 50 };
            if (urealnameParam.Value == null)
                urealnameParam.Value = System.DBNull.Value;

            var loginTimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@loginTime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = loginTime.GetValueOrDefault() };
            if (!loginTime.HasValue)
                loginTimeParam.Value = System.DBNull.Value;

            var lastUpdateTimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@lastUpdateTime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = lastUpdateTime.GetValueOrDefault() };
            if (!lastUpdateTime.HasValue)
                lastUpdateTimeParam.Value = System.DBNull.Value;

            var utypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@utype", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = utype, Size = 1 };
            if (utypeParam.Value == null)
                utypeParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_onlineUser_ADD] @uid, @urealname, @loginTime, @lastUpdateTime, @utype", uidParam, urealnameParam, loginTimeParam, lastUpdateTimeParam, utypeParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #19
0
        public int SpShopunjz(System.DateTime? frdt, System.DateTime? todt, decimal? stdcommrate, string shoploginname, string createUser, out string ret)
        {
            var frdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@frdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = frdt.GetValueOrDefault() };
            if (!frdt.HasValue)
                frdtParam.Value = System.DBNull.Value;

            var todtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@todt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = todt.GetValueOrDefault() };
            if (!todt.HasValue)
                todtParam.Value = System.DBNull.Value;

            var stdcommrateParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@stdcommrate", SqlDbType = System.Data.SqlDbType.Decimal, Direction = System.Data.ParameterDirection.Input, Value = stdcommrate.GetValueOrDefault(), Precision = 5, Scale = 2 };
            if (!stdcommrate.HasValue)
                stdcommrateParam.Value = System.DBNull.Value;

            var shoploginnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shoploginname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = shoploginname, Size = 50 };
            if (shoploginnameParam.Value == null)
                shoploginnameParam.Value = System.DBNull.Value;

            var createUserParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createUser", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = createUser, Size = 30 };
            if (createUserParam.Value == null)
                createUserParam.Value = System.DBNull.Value;

            var retParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@ret", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Output, Size = 50 };
            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_shopunjz] @frdt, @todt, @stdcommrate, @shoploginname, @createUser, @ret OUTPUT", frdtParam, todtParam, stdcommrateParam, shoploginnameParam, createUserParam, retParam, procResultParam);
            if (IsSqlParameterNull(retParam))
                ret = default(string);
            else
                ret = (string)retParam.Value;

            return (int)procResultParam.Value;
        }
コード例 #20
0
        public int UpShopAdd(int? shopid, string sname, string sname2, string tel1, string tel2, string fax, string email, string contactname, string contactTel, string addr1, string cityname, string postcode1, string postcode2, string description, string acceptpay, string acceptorder, string bankname, string bankusername, string banksortcode, string bankno, decimal? webcommision, System.DateTime? expireddt, string alias)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var snameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@sname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = sname, Size = 100 };
            if (snameParam.Value == null)
                snameParam.Value = System.DBNull.Value;

            var sname2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@sname2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = sname2, Size = 100 };
            if (sname2Param.Value == null)
                sname2Param.Value = System.DBNull.Value;

            var tel1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@tel1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = tel1, Size = 50 };
            if (tel1Param.Value == null)
                tel1Param.Value = System.DBNull.Value;

            var tel2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@tel2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = tel2, Size = 50 };
            if (tel2Param.Value == null)
                tel2Param.Value = System.DBNull.Value;

            var faxParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@fax", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = fax, Size = 50 };
            if (faxParam.Value == null)
                faxParam.Value = System.DBNull.Value;

            var emailParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@email", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = email, Size = 100 };
            if (emailParam.Value == null)
                emailParam.Value = System.DBNull.Value;

            var contactnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@contactname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = contactname, Size = 50 };
            if (contactnameParam.Value == null)
                contactnameParam.Value = System.DBNull.Value;

            var contactTelParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@contactTel", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = contactTel, Size = 50 };
            if (contactTelParam.Value == null)
                contactTelParam.Value = System.DBNull.Value;

            var addr1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@addr1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = addr1, Size = 100 };
            if (addr1Param.Value == null)
                addr1Param.Value = System.DBNull.Value;

            var citynameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@cityname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = cityname, Size = 100 };
            if (citynameParam.Value == null)
                citynameParam.Value = System.DBNull.Value;

            var postcode1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode1", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode1, Size = 50 };
            if (postcode1Param.Value == null)
                postcode1Param.Value = System.DBNull.Value;

            var postcode2Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode2", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode2, Size = 50 };
            if (postcode2Param.Value == null)
                postcode2Param.Value = System.DBNull.Value;

            var descriptionParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@description", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = description, Size = 3000 };
            if (descriptionParam.Value == null)
                descriptionParam.Value = System.DBNull.Value;

            var acceptpayParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@acceptpay", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = acceptpay, Size = 10 };
            if (acceptpayParam.Value == null)
                acceptpayParam.Value = System.DBNull.Value;

            var acceptorderParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@acceptorder", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = acceptorder, Size = 20 };
            if (acceptorderParam.Value == null)
                acceptorderParam.Value = System.DBNull.Value;

            var banknameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@bankname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = bankname, Size = 50 };
            if (banknameParam.Value == null)
                banknameParam.Value = System.DBNull.Value;

            var bankusernameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@bankusername", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = bankusername, Size = 50 };
            if (bankusernameParam.Value == null)
                bankusernameParam.Value = System.DBNull.Value;

            var banksortcodeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@banksortcode", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = banksortcode, Size = 50 };
            if (banksortcodeParam.Value == null)
                banksortcodeParam.Value = System.DBNull.Value;

            var banknoParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@bankno", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = bankno, Size = 50 };
            if (banknoParam.Value == null)
                banknoParam.Value = System.DBNull.Value;

            var webcommisionParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@webcommision", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = webcommision.GetValueOrDefault(), Precision = 5, Scale = 2 };
            if (!webcommision.HasValue)
                webcommisionParam.Value = System.DBNull.Value;

            var expireddtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@expireddt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = expireddt.GetValueOrDefault() };
            if (!expireddt.HasValue)
                expireddtParam.Value = System.DBNull.Value;

            var aliasParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@alias", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = alias, Size = 100 };
            if (aliasParam.Value == null)
                aliasParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_shop_ADD] @shopid, @sname, @sname2, @tel1, @tel2, @fax, @email, @contactname, @contactTel, @addr1, @cityname, @postcode1, @postcode2, @description, @acceptpay, @acceptorder, @bankname, @bankusername, @banksortcode, @bankno, @webcommision, @expireddt, @alias", shopidParam, snameParam, sname2Param, tel1Param, tel2Param, faxParam, emailParam, contactnameParam, contactTelParam, addr1Param, citynameParam, postcode1Param, postcode2Param, descriptionParam, acceptpayParam, acceptorderParam, banknameParam, bankusernameParam, banksortcodeParam, banknoParam, webcommisionParam, expireddtParam, aliasParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #21
0
        public int SpSysLogAdd(string userid, string actstr, System.DateTime? actdt, string priority)
        {
            var useridParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@userid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = userid, Size = 50 };
            if (useridParam.Value == null)
                useridParam.Value = System.DBNull.Value;

            var actstrParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@actstr", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = actstr, Size = 800 };
            if (actstrParam.Value == null)
                actstrParam.Value = System.DBNull.Value;

            var actdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@actdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = actdt.GetValueOrDefault() };
            if (!actdt.HasValue)
                actdtParam.Value = System.DBNull.Value;

            var priorityParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@priority", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = priority, Size = 10 };
            if (priorityParam.Value == null)
                priorityParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_sysLog_ADD] @userid, @actstr, @actdt, @priority", useridParam, actstrParam, actdtParam, priorityParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #22
0
        public int UpSysMsgAdd(string msgtitle, string msgcontent, System.DateTime? msgdt, int? msgto)
        {
            var msgtitleParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@msgtitle", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = msgtitle, Size = 100 };
            if (msgtitleParam.Value == null)
                msgtitleParam.Value = System.DBNull.Value;

            var msgcontentParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@msgcontent", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = msgcontent, Size = 500 };
            if (msgcontentParam.Value == null)
                msgcontentParam.Value = System.DBNull.Value;

            var msgdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@msgdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = msgdt.GetValueOrDefault() };
            if (!msgdt.HasValue)
                msgdtParam.Value = System.DBNull.Value;

            var msgtoParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@msgto", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = msgto.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!msgto.HasValue)
                msgtoParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_sysMsg_ADD] @msgtitle, @msgcontent, @msgdt, @msgto", msgtitleParam, msgcontentParam, msgdtParam, msgtoParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #23
0
        public int SpUserCreditInfoAdd(int? shopid, int? userid, string moneydirection, decimal? amt, string comment, string orderid, System.DateTime? createdt)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var useridParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@userid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = userid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!userid.HasValue)
                useridParam.Value = System.DBNull.Value;

            var moneydirectionParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@moneydirection", SqlDbType = System.Data.SqlDbType.NChar, Direction = System.Data.ParameterDirection.Input, Value = moneydirection, Size = 2 };
            if (moneydirectionParam.Value == null)
                moneydirectionParam.Value = System.DBNull.Value;

            var amtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@amt", SqlDbType = System.Data.SqlDbType.VarChar, Direction = System.Data.ParameterDirection.Input, Value = amt.GetValueOrDefault(), Precision = 5, Scale = 2 };
            if (!amt.HasValue)
                amtParam.Value = System.DBNull.Value;

            var commentParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@comment", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = comment, Size = 500 };
            if (commentParam.Value == null)
                commentParam.Value = System.DBNull.Value;

            var orderidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderid, Size = 30 };
            if (orderidParam.Value == null)
                orderidParam.Value = System.DBNull.Value;

            var createdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createdt.GetValueOrDefault() };
            if (!createdt.HasValue)
                createdtParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_UserCreditInfo_Add] @shopid, @userid, @moneydirection, @amt, @comment, @orderid, @createdt", shopidParam, useridParam, moneydirectionParam, amtParam, commentParam, orderidParam, createdtParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #24
0
        public int SpAdminAccAdd(string loginname, string loginpwd, System.DateTime? createtime, string rightcode, string isvalid, string isadmin)
        {
            var loginnameParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@loginname", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = loginname, Size = 50 };
            if (loginnameParam.Value == null)
                loginnameParam.Value = System.DBNull.Value;

            var loginpwdParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@loginpwd", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = loginpwd, Size = 100 };
            if (loginpwdParam.Value == null)
                loginpwdParam.Value = System.DBNull.Value;

            var createtimeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createtime", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createtime.GetValueOrDefault() };
            if (!createtime.HasValue)
                createtimeParam.Value = System.DBNull.Value;

            var rightcodeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@rightcode", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = rightcode, Size = 1000 };
            if (rightcodeParam.Value == null)
                rightcodeParam.Value = System.DBNull.Value;

            var isvalidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isvalid", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isvalid, Size = 1 };
            if (isvalidParam.Value == null)
                isvalidParam.Value = System.DBNull.Value;

            var isadminParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@isadmin", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = isadmin, Size = 1 };
            if (isadminParam.Value == null)
                isadminParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_adminAcc_ADD] @loginname, @loginpwd, @createtime, @rightcode, @isvalid, @isadmin", loginnameParam, loginpwdParam, createtimeParam, rightcodeParam, isvalidParam, isadminParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #25
0
        public int SpViewtelAdd(int? shopid, System.DateTime? actdt)
        {
            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = shopid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!shopid.HasValue)
                shopidParam.Value = System.DBNull.Value;

            var actdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@actdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = actdt.GetValueOrDefault() };
            if (!actdt.HasValue)
                actdtParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_viewtel_ADD] @shopid, @actdt", shopidParam, actdtParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #26
0
        public int SpAdvsearchAdd(string postcode, int? indexno, string shopid, System.DateTime? startdt, System.DateTime? enddt, System.DateTime? createdt, string createuser)
        {
            var postcodeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@postcode", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = postcode, Size = 10 };
            if (postcodeParam.Value == null)
                postcodeParam.Value = System.DBNull.Value;

            var indexnoParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@indexno", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = indexno.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!indexno.HasValue)
                indexnoParam.Value = System.DBNull.Value;

            var shopidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@shopid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = shopid, Size = 50 };
            if (shopidParam.Value == null)
                shopidParam.Value = System.DBNull.Value;

            var startdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@startdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = startdt.GetValueOrDefault() };
            if (!startdt.HasValue)
                startdtParam.Value = System.DBNull.Value;

            var enddtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@enddt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = enddt.GetValueOrDefault() };
            if (!enddt.HasValue)
                enddtParam.Value = System.DBNull.Value;

            var createdtParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createdt", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = createdt.GetValueOrDefault() };
            if (!createdt.HasValue)
                createdtParam.Value = System.DBNull.Value;

            var createuserParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@createuser", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = createuser, Size = 50 };
            if (createuserParam.Value == null)
                createuserParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[sp_advsearch_ADD] @postcode, @indexno, @shopid, @startdt, @enddt, @createdt, @createuser", postcodeParam, indexnoParam, shopidParam, startdtParam, enddtParam, createdtParam, createuserParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #27
0
        public int UpCustomerReviewForMealAdd(int? uid, string email, decimal? rate1, System.DateTime? reviewDate, string reviewtype, int? objid, string orderid)
        {
            var uidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@uid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = uid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!uid.HasValue)
                uidParam.Value = System.DBNull.Value;

            var emailParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@email", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = email, Size = 50 };
            if (emailParam.Value == null)
                emailParam.Value = System.DBNull.Value;

            var rate1Param = new System.Data.SqlClient.SqlParameter { ParameterName = "@rate1", SqlDbType = System.Data.SqlDbType.Decimal, Direction = System.Data.ParameterDirection.Input, Value = rate1.GetValueOrDefault(), Precision = 2, Scale = 1 };
            if (!rate1.HasValue)
                rate1Param.Value = System.DBNull.Value;

            var reviewDateParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@reviewDate", SqlDbType = System.Data.SqlDbType.DateTime, Direction = System.Data.ParameterDirection.Input, Value = reviewDate.GetValueOrDefault() };
            if (!reviewDate.HasValue)
                reviewDateParam.Value = System.DBNull.Value;

            var reviewtypeParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@reviewtype", SqlDbType = System.Data.SqlDbType.Char, Direction = System.Data.ParameterDirection.Input, Value = reviewtype, Size = 1 };
            if (reviewtypeParam.Value == null)
                reviewtypeParam.Value = System.DBNull.Value;

            var objidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@objid", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Input, Value = objid.GetValueOrDefault(), Precision = 10, Scale = 0 };
            if (!objid.HasValue)
                objidParam.Value = System.DBNull.Value;

            var orderidParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@orderid", SqlDbType = System.Data.SqlDbType.NVarChar, Direction = System.Data.ParameterDirection.Input, Value = orderid, Size = 30 };
            if (orderidParam.Value == null)
                orderidParam.Value = System.DBNull.Value;

            var procResultParam = new System.Data.SqlClient.SqlParameter { ParameterName = "@procResult", SqlDbType = System.Data.SqlDbType.Int, Direction = System.Data.ParameterDirection.Output };

            Database.ExecuteSqlCommand("EXEC @procResult = [dbo].[UP_customerReviewForMeal_ADD] @uid, @email, @rate1, @reviewDate, @reviewtype, @objid, @orderid", uidParam, emailParam, rate1Param, reviewDateParam, reviewtypeParam, objidParam, orderidParam, procResultParam);

            return (int)procResultParam.Value;
        }
コード例 #28
0
ファイル: Glyph.cs プロジェクト: GhostTap/MonoGame
		// Constructor.
		public Glyph(char character, Bitmap bitmap, System.Drawing.Rectangle? subrect = null)
		{
			this.Character = character;
			this.Bitmap = bitmap;
			this.Subrect = subrect.GetValueOrDefault(new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height));
		}
コード例 #29
0
ファイル: BitmapUtils.cs プロジェクト: KennethYap/MonoGame
			// Constructor locks the bitmap.
			public PixelAccessor(Bitmap bitmap, ImageLockMode mode, System.Drawing.Rectangle? region = null)
			{
				this.bitmap = bitmap;

				this.Region = region.GetValueOrDefault(new System.Drawing.Rectangle(0, 0, bitmap.Width, bitmap.Height));

				this.data = bitmap.LockBits(Region, mode, PixelFormat.Format32bppArgb);
			}