public int CompareTo(object obj)
        {
            CategoryAttribute2OptionInfo b = obj as CategoryAttribute2OptionInfo;

            if (this._ordernum > b._ordernum)
            {
                return(1);
            }
            else
            {
                return(-1);
            }
        }
Example #2
0
 public bool IsExistAttribute2Option(CategoryAttribute2OptionInfo oParam)
 {
     return new CategoryDac().IsExistAttribute2Option(oParam);
 }
Example #3
0
 public int InsertAttribute2Option(CategoryAttribute2OptionInfo oParam)
 {
     return new CategoryDac().InsertAttribute2Option(oParam);
 }
Example #4
0
 public int GetCatetoryAttribute2OptionNewOrderNum(CategoryAttribute2OptionInfo oParam)
 {
     return new CategoryDac().GetCatetoryAttribute2OptionNewOrderNum(oParam);
 }
Example #5
0
 private void Map(CategoryAttribute2OptionInfo oParam, DataRow tempdr)
 {
     oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
     oParam.Attribute2SysNo = Util.TrimIntNull(tempdr["Attribute2SysNo"]);
     oParam.Attribute2OptionName = Util.TrimNull(tempdr["Attribute2OptionName"]);
     oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
     oParam.IsRecommend  = Util.TrimIntNull(tempdr["IsRecommend"]);
     oParam.Status = Util.TrimIntNull(tempdr["Status"]);
 }
Example #6
0
 public SortedList GetAttribute2OptionList(int paramAttribute2SysNo)
 {
     string sql = " select * from category_attribute2_option where attribute2sysno = " + paramAttribute2SysNo;
     DataSet ds = SqlHelper.ExecuteDataSet(sql);
     if ( !Util.HasMoreRow(ds))
         return null;
     SortedList sl = new SortedList(ds.Tables[0].Rows.Count);
     foreach( DataRow dr in ds.Tables[0].Rows )
     {
         CategoryAttribute2OptionInfo item = new CategoryAttribute2OptionInfo();
         Map(item, dr);
         sl.Add(item, null);
     }
     return sl;
 }
Example #7
0
 public int UpdateAttribute2Option(CategoryAttribute2OptionInfo oParam)
 {
     return new CategoryDac().UpdateAttribute2Option(oParam);
 }
Example #8
0
        public void MoveUp(CategoryAttribute2OptionInfo oParam)
        {
            if ( oParam.OrderNum == 1 )
            {
                throw new BizException("it's the first one, can't be moved up");
            }
            SortedList sl = GetAttribute2OptionList(oParam.Attribute2SysNo);
            if ( sl == null )
            {
                throw new BizException("no attributes");
            }

            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                CategoryDac o = new CategoryDac();

                foreach(CategoryAttribute2OptionInfo item  in sl.Keys)
                {
                    if ( item.OrderNum == oParam.OrderNum-1 )
                    {
                        item.OrderNum += 1;
                        o.SetOrderNum(item);
                    }
                }
                oParam.OrderNum -= 1;
                o.SetOrderNum(oParam);

                scope.Complete();
            }
        }
Example #9
0
        //old version for category attribute option
        /*
        //---------------------------CategoryAttributeOption------------------------
        public CategoryAttributeOptionInfo LoadAttributeOption(int paramAttributeOptionSysNo)
        {
            string sql = "select * from category_attribute_option where sysno=" + paramAttributeOptionSysNo;
            DataSet ds = SqlHelper.ExecuteDataSet(sql);
            if ( !Util.HasMoreRow(ds))
                return null;
            CategoryAttributeOptionInfo item = new CategoryAttributeOptionInfo();
            Map( item, ds.Tables[0].Rows[0]);
            return item;
        }
        public bool IsAttributeOption(int paramAttributeSysNo)
        {
            string sql = "select top 1 sysno from category_attribute_option where AttributeSysNo = " + paramAttributeSysNo;
            DataSet ds = SqlHelper.ExecuteDataSet(sql);
            if ( Util.HasMoreRow(ds))
                return true;
            else
                return false;
        }

        public bool IsExistAttributeOption(CategoryAttributeOptionInfo oParam)
        {
            return new CategoryDac().IsExistAttributeOption(oParam);
        }

        public SortedList GetAttributeOptionList(int paramAttributeSysNo)
        {
            string sql = " select * from category_attribute_option where attributesysno = " + paramAttributeSysNo;
            DataSet ds = SqlHelper.ExecuteDataSet(sql);
            if ( !Util.HasMoreRow(ds))
                return null;
            SortedList sl = new SortedList(attributeCapacity);
            foreach( DataRow dr in ds.Tables[0].Rows )
            {
                CategoryAttributeOptionInfo item = new CategoryAttributeOptionInfo();
                Map(item, dr);
                sl.Add(item, null);
            }
            return sl;
        }
        private void Map(CategoryAttributeOptionInfo oParam, DataRow tempdr)
        {
            oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
            oParam.AttributeSysNo = Util.TrimIntNull(tempdr["AttributeSysNo"]);
            oParam.AttributeOptionName = Util.TrimNull(tempdr["AttributeOptionName"]);
            oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
            oParam.IsRecommend  = Util.TrimIntNull(tempdr["IsRecommend"]);
            oParam.Status = Util.TrimIntNull(tempdr["Status"]);
        }
        public void InitAttributeOption(int paramAttributeSysNo)
        {
            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                CategoryDac o = new CategoryDac();

                CategoryAttributeOptionInfo oItem = new CategoryAttributeOptionInfo();
                for(int i=1; i<=attributeCapacity; i++ )
                {
                    oItem.AttributeSysNo = paramAttributeSysNo;
                    oItem.AttributeOptionName = "";
                    oItem.OrderNum = i;
                    oItem.IsRecommend = (int)AppEnum.YNStatus.No;
                    oItem.Status = (int)AppEnum.BiStatus.InValid;
                    o.InsertAttributeOption(oItem);
                }

                scope.Complete();
            }
        }

        public int GetCatetoryAttributeOptionNewOrderNum(CategoryAttributeOptionInfo oParam)
        {
            return new CategoryDac().GetCatetoryAttributeOptionNewOrderNum(oParam);
        }

        public int InsertAttributeOption(CategoryAttributeOptionInfo oParam)
        {
            return new CategoryDac().InsertAttributeOption(oParam);
        }

        public int UpdateAttributeOption(CategoryAttributeOptionInfo oParam)
        {
            return new CategoryDac().UpdateAttributeOption(oParam);
        }

        public void MoveTop(CategoryAttributeOptionInfo oParam)
        {
            if ( oParam.OrderNum == 1 )
            {
                throw new BizException("it's the top one already");
            }
            SortedList sl = GetAttributeOptionList(oParam.AttributeSysNo);
            if ( sl == null )
            {
                throw new BizException("no attribute for this third category");
            }

            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                CategoryDac o = new CategoryDac();

                foreach(CategoryAttributeOptionInfo item  in sl.Keys)
                {
                    if ( item.OrderNum < oParam.OrderNum )
                    {
                        item.OrderNum = item.OrderNum+1;
                        o.SetOrderNum(item);
                    }
                }
                oParam.OrderNum = 1;
                o.SetOrderNum(oParam);

                scope.Complete();
            }
        }
        public void MoveUp(CategoryAttributeOptionInfo oParam)
        {
            if ( oParam.OrderNum == 1 )
            {
                throw new BizException("it's the first one, can't be moved up");
            }
            SortedList sl = GetAttributeOptionList(oParam.AttributeSysNo);
            if ( sl == null )
            {
                throw new BizException("no attributes");
            }

            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                CategoryDac o = new CategoryDac();

                foreach(CategoryAttributeOptionInfo item  in sl.Keys)
                {
                    if ( item.OrderNum == oParam.OrderNum-1 )
                    {
                        item.OrderNum += 1;
                        o.SetOrderNum(item);
                    }
                }
                oParam.OrderNum -= 1;
                o.SetOrderNum(oParam);

                scope.Complete();
            }
        }
        public void MoveDown(CategoryAttributeOptionInfo oParam)
        {
            SortedList sl = GetAttributeOptionList(oParam.AttributeSysNo);
            if ( sl == null )
            {
                throw new BizException("no attributes");
            }

            if ( oParam.OrderNum == sl.Count )
            {
                throw new BizException("it's the last one, can't be moved down");
            }

            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                CategoryDac o = new CategoryDac();

                foreach(CategoryAttributeOptionInfo item  in sl.Keys)
                {
                    if ( item.OrderNum == oParam.OrderNum+1 )
                    {
                        item.OrderNum -= 1;
                        o.SetOrderNum(item);
                    }
                }
                oParam.OrderNum += 1;
                o.SetOrderNum(oParam);

                scope.Complete();
            }
        }
        public void MoveBottom(CategoryAttributeOptionInfo oParam)
        {
            SortedList sl = GetAttributeOptionList(oParam.AttributeSysNo);
            if ( sl == null )
            {
                throw new BizException("no attributes");
            }

            if ( oParam.OrderNum == sl.Count )
            {
                throw new BizException("it's the last one, can't be moved down");
            }

            TransactionOptions options = new TransactionOptions();
            options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
            options.Timeout = TransactionManager.DefaultTimeout;

            using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
            {

                CategoryDac o = new CategoryDac();

                foreach(CategoryAttributeOptionInfo item  in sl.Keys)
                {
                    if ( item.OrderNum > oParam.OrderNum )
                    {
                        item.OrderNum = item.OrderNum-1;
                        o.SetOrderNum(item);
                    }
                }
                oParam.OrderNum = attributeCapacity;
                o.SetOrderNum(oParam);

                scope.Complete();
            }
        }
        //---------------------------CategoryAttributeOption------------------------
        */
        //---------------------------Category_Attribute2_Option------------------------
        public CategoryAttribute2OptionInfo LoadAttribute2Option(int paramAttribute2OptionSysNo)
        {
            string sql = "select * from category_attribute2_option where sysno=" + paramAttribute2OptionSysNo;
            DataSet ds = SqlHelper.ExecuteDataSet(sql);
            if ( !Util.HasMoreRow(ds))
                return null;
            CategoryAttribute2OptionInfo item = new CategoryAttribute2OptionInfo();
            Map( item, ds.Tables[0].Rows[0]);
            return item;
        }
Example #10
0
        public int UpdateAttribute2Option(CategoryAttribute2OptionInfo oParam)
        {
            string sql = @"UPDATE Category_Attribute2_Option SET
                            Attribute2SysNo=@Attribute2SysNo, Attribute2OptionName=@Attribute2OptionName,
                            OrderNum=@OrderNum, IsRecommend=@IsRecommend, Status=@Status
                            WHERE SysNo=@SysNo";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
            SqlParameter paramAttribute2SysNo = new SqlParameter("@Attribute2SysNo", SqlDbType.Int,4);
            SqlParameter paramAttribute2OptionName = new SqlParameter("@Attribute2OptionName", SqlDbType.NVarChar,500);
            SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
            SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int,4);
            SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);

            paramSysNo.Value = oParam.SysNo;
            paramAttribute2SysNo.Value = oParam.Attribute2SysNo;
            paramAttribute2OptionName.Value = oParam.Attribute2OptionName;
            paramOrderNum.Value = oParam.OrderNum;
            paramIsRecommend.Value = oParam.IsRecommend;
            paramStatus.Value = oParam.Status;

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramAttribute2SysNo);
            cmd.Parameters.Add(paramAttribute2OptionName);
            cmd.Parameters.Add(paramOrderNum);
            cmd.Parameters.Add(paramIsRecommend);
            cmd.Parameters.Add(paramStatus);

            return SqlHelper.ExecuteNonQuery(cmd);
        }
Example #11
0
 public int SetOrderNum(CategoryAttribute2OptionInfo oParam)
 {
     string sql = "update category_attribute2_option set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
     SqlCommand cmd = new SqlCommand(sql);
     return SqlHelper.ExecuteNonQuery(cmd);
 }
Example #12
0
        public bool IsExistAttribute2Option(CategoryAttribute2OptionInfo oParam)
        {
            string sql = "select top 1 sysno from category_attribute2_option where Attribute2SysNo=@Attribute2SysNo and Attribute2OptionName=@Attribute2OptionName and SysNo!=@SysNo";
            SqlCommand cmd = new SqlCommand(sql);
            SqlParameter paramAttribute2SysNo = new SqlParameter("@Attribute2SysNo", SqlDbType.Int,4);
            SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
            SqlParameter paramAttribute2OptionName = new SqlParameter("@Attribute2OptionName", SqlDbType.NVarChar,500);

            paramAttribute2SysNo.Value = oParam.Attribute2SysNo;
            paramAttribute2OptionName.Value = oParam.Attribute2OptionName;
            paramSysNo.Value = oParam.SysNo;

            cmd.Parameters.Add(paramAttribute2SysNo);
            cmd.Parameters.Add(paramAttribute2OptionName);
            cmd.Parameters.Add(paramSysNo);

            DataSet ds = SqlHelper.ExecuteDataSet(cmd);
            if ( Util.HasMoreRow(ds))
                return true;
            else
                return false;
        }
Example #13
0
        /*
        public int InsertAttributeOption(CategoryAttributeOptionInfo oParam)
        {
            string sql = @"INSERT INTO Category_Attribute_Option
                            (
                            AttributeSysNo, AttributeOptionName,
                            OrderNum, IsRecommend, Status
                            )
                            VALUES (
                            @AttributeSysNo, @AttributeOptionName,
                            @OrderNum, @IsRecommend, @Status
                            )";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramAttributeSysNo = new SqlParameter("@AttributeSysNo", SqlDbType.Int,4);
            SqlParameter paramAttributeOptionName = new SqlParameter("@AttributeOptionName", SqlDbType.NVarChar,500);
            SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
            SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int,4);
            SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);

            paramAttributeSysNo.Value = oParam.AttributeSysNo;
            paramAttributeOptionName.Value = oParam.AttributeOptionName;
            paramOrderNum.Value = oParam.OrderNum;
            paramIsRecommend.Value = oParam.IsRecommend;
            paramStatus.Value = oParam.Status;

            cmd.Parameters.Add(paramAttributeSysNo);
            cmd.Parameters.Add(paramAttributeOptionName);
            cmd.Parameters.Add(paramOrderNum);
            cmd.Parameters.Add(paramIsRecommend);
            cmd.Parameters.Add(paramStatus);

            return SqlHelper.ExecuteNonQuery(cmd);
        }
        public int UpdateAttributeOption(CategoryAttributeOptionInfo oParam)
        {
            string sql = @"UPDATE Category_Attribute_Option SET
                            AttributeSysNo=@AttributeSysNo, AttributeOptionName=@AttributeOptionName,
                            OrderNum=@OrderNum, IsRecommend=@IsRecommend, Status=@Status
                            WHERE SysNo=@SysNo";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
            SqlParameter paramAttributeSysNo = new SqlParameter("@AttributeSysNo", SqlDbType.Int,4);
            SqlParameter paramAttributeOptionName = new SqlParameter("@AttributeOptionName", SqlDbType.NVarChar,500);
            SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
            SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int,4);
            SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);

            paramSysNo.Value = oParam.SysNo;
            paramAttributeSysNo.Value = oParam.AttributeSysNo;
            paramAttributeOptionName.Value = oParam.AttributeOptionName;
            paramOrderNum.Value = oParam.OrderNum;
            paramIsRecommend.Value = oParam.IsRecommend;
            paramStatus.Value = oParam.Status;

            cmd.Parameters.Add(paramSysNo);
            cmd.Parameters.Add(paramAttributeSysNo);
            cmd.Parameters.Add(paramAttributeOptionName);
            cmd.Parameters.Add(paramOrderNum);
            cmd.Parameters.Add(paramIsRecommend);
            cmd.Parameters.Add(paramStatus);

            return SqlHelper.ExecuteNonQuery(cmd);
        }

        public bool IsExistAttributeOption(CategoryAttributeOptionInfo oParam)
        {
            string sql = "select top 1 sysno from category_attribute_option where AttributeSysNo=@AttributeSysNo and AttributeOptionName=@AttributeOptionName";
            SqlCommand cmd = new SqlCommand(sql);
            SqlParameter paramAttributeSysNo = new SqlParameter("@AttributeSysNo", SqlDbType.Int,4);
            SqlParameter paramAttributeOptionName = new SqlParameter("@AttributeOptionName", SqlDbType.NVarChar,500);

            paramAttributeSysNo.Value = oParam.AttributeSysNo;
            paramAttributeOptionName.Value = oParam.AttributeOptionName;

            cmd.Parameters.Add(paramAttributeSysNo);
            cmd.Parameters.Add(paramAttributeOptionName);

            DataSet ds = SqlHelper.ExecuteDataSet(cmd);;
            if ( Util.HasMoreRow(ds))
                return true;
            else
                return false;
        }

        public int SetOrderNum(CategoryAttributeOptionInfo oParam)
        {
            string sql = "update category_attribute_option set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
            SqlCommand cmd = new SqlCommand(sql);
            return SqlHelper.ExecuteNonQuery(cmd);
        }
        */
        public int InsertAttribute2Option(CategoryAttribute2OptionInfo oParam)
        {
            string sql = @"INSERT INTO Category_Attribute2_Option
                            (
                            Attribute2SysNo, Attribute2OptionName,
                            OrderNum, IsRecommend, Status
                            )
                            VALUES (
                            @Attribute2SysNo, @Attribute2OptionName,
                            @OrderNum, @IsRecommend, @Status
                            )";
            SqlCommand cmd = new SqlCommand(sql);

            SqlParameter paramAttribute2SysNo = new SqlParameter("@Attribute2SysNo", SqlDbType.Int,4);
            SqlParameter paramAttribute2OptionName = new SqlParameter("@Attribute2OptionName", SqlDbType.NVarChar,500);
            SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
            SqlParameter paramIsRecommend = new SqlParameter("@IsRecommend", SqlDbType.Int,4);
            SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);

            paramAttribute2SysNo.Value = oParam.Attribute2SysNo;
            paramAttribute2OptionName.Value = oParam.Attribute2OptionName;
            paramOrderNum.Value = oParam.OrderNum;
            paramIsRecommend.Value = oParam.IsRecommend;
            paramStatus.Value = oParam.Status;

            cmd.Parameters.Add(paramAttribute2SysNo);
            cmd.Parameters.Add(paramAttribute2OptionName);
            cmd.Parameters.Add(paramOrderNum);
            cmd.Parameters.Add(paramIsRecommend);
            cmd.Parameters.Add(paramStatus);

            return SqlHelper.ExecuteNonQuery(cmd);
        }
Example #14
0
 public int GetCatetoryAttribute2OptionNewOrderNum(CategoryAttribute2OptionInfo oParam)
 {
     string sql = "select isnull(max(OrderNum),0)+1 as newOrderNum from Category_Attribute2_Option where Attribute2SysNo=" + oParam.Attribute2SysNo;
     DataSet ds = SqlHelper.ExecuteDataSet(sql);
     if(Util.HasMoreRow(ds))
     {
         return Int32.Parse(ds.Tables[0].Rows[0][0].ToString());
     }
     else
     {
         return 1;
     }
 }