//ɾ����Ʒ���Զ�������
public int DeleteAttribute2(int attribute2SysNo)
{
int _return = 0;
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
_return=new CategoryDac().DeleteAttribute2(attribute2SysNo);
scope.Complete();
}
return _return;
}
public void InitAttribute(int paramC3SysNo)
{
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();
CategoryAttributeInfo oItem = new CategoryAttributeInfo();
for(int i=1; i<=attributeCapacity; i++ )
{
oItem.C3SysNo = paramC3SysNo;
oItem.AttributeID = "A" + i.ToString();
oItem.AttributeName = "" + i.ToString();
oItem.OrderNum = i;
oItem.Status = (int)AppEnum.BiStatus.InValid;
oItem.AttributeType = (int)AppEnum.AttributeType.Text;
o.InsertAttribute(oItem);
}
scope.Complete();
}
}
public void MoveTop(CategoryAttribute1Info oParam)
{
if ( oParam.OrderNum == 1 )
{
throw new BizException("it's the top one already");
}
SortedList sl = GetAttribute1List(oParam.C3SysNo);
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(CategoryAttribute1Info 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(CategoryAttribute2Info oParam)
{
if ( oParam.OrderNum == 1 )
{
throw new BizException("it's the first one, can't be moved up");
}
SortedList sl = GetAttribute2List(oParam.A1SysNo);
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(CategoryAttribute2Info 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(CategoryAttribute2OptionInfo oParam)
{
SortedList sl = GetAttribute2OptionList(oParam.Attribute2SysNo);
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(CategoryAttribute2OptionInfo 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();
}
}
