public int CompareTo(object obj) { CategoryAttribute2OptionInfo b = obj as CategoryAttribute2OptionInfo; if (this._ordernum > b._ordernum) { return(1); } else { return(-1); } }
public bool IsExistAttribute2Option(CategoryAttribute2OptionInfo oParam) { return new CategoryDac().IsExistAttribute2Option(oParam); }
public int InsertAttribute2Option(CategoryAttribute2OptionInfo oParam) { return new CategoryDac().InsertAttribute2Option(oParam); }
public int GetCatetoryAttribute2OptionNewOrderNum(CategoryAttribute2OptionInfo oParam) { return new CategoryDac().GetCatetoryAttribute2OptionNewOrderNum(oParam); }
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"]); }
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; }
public int UpdateAttribute2Option(CategoryAttribute2OptionInfo oParam) { return new CategoryDac().UpdateAttribute2Option(oParam); }
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(); } }
//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; }
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); }
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); }
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; }
/* 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); }
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; } }