public int CompareTo(object obj)
{
CategoryAttribute2Info b = obj as CategoryAttribute2Info;
if (this._ordernum > b._ordernum)
{
return(2);
}
else
{
return(-2);
}
}
//---------------------------Category_Attribute1-------------------------
//---------------------------Category_Attribute2-------------------------
public bool IsExistAttribute2(CategoryAttribute2Info oParam)
{
return new CategoryDac().IsExistAttribute2(oParam);
}
public int InsertAttribute2(CategoryAttribute2Info oParam)
{
string _atrribute2ID = "";
string _tmpStr = "";
int _tmpInt = -1;
string sql = "select max(Attribute2ID) from Category_Attribute2 where A1SysNo=" + oParam.A1SysNo.ToString();
_tmpStr = SqlHelper.ExecuteScalar(sql).ToString();
if (_tmpStr.Trim() == "")
_tmpStr = "0";
if (!Util.IsInteger(_tmpStr))
throw new BizException("�Բ������ɱ�Ŵ��������");
_tmpInt = Convert.ToInt32(_tmpStr);
_tmpInt++;
_atrribute2ID = _tmpInt.ToString();
oParam.Attribute2ID = _atrribute2ID;
return new CategoryDac().InsertAttribute2(oParam);
}
public int GetCatetoryAttribute2NewOrderNum(CategoryAttribute2Info oParam)
{
return new CategoryDac().GetCatetoryAttribute2NewOrderNum(oParam);
}
private void Map(CategoryAttribute2Info oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.A1SysNo = Util.TrimIntNull(tempdr["A1SysNo"]);
oParam.Attribute2ID = Util.TrimNull(tempdr["Attribute2ID"]);
oParam.Attribute2Name = Util.TrimNull(tempdr["Attribute2Name"]);
oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
oParam.Status = Util.TrimIntNull(tempdr["Status"]);
oParam.Attribute2Type = Util.TrimIntNull(tempdr["Attribute2Type"]);
}
public SortedList GetAttribute2List(int paramA1SysNo)
{
string sql = " select * from category_attribute2 where a1sysno = " + paramA1SysNo;
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 )
{
CategoryAttribute2Info item = new CategoryAttribute2Info();
Map(item, dr);
sl.Add(item, null);
}
return sl;
}
public int UpdateAttribute2(CategoryAttribute2Info oParam)
{
return new CategoryDac().UpdateAttribute2(oParam);
}
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 CategoryAttribute2Info LoadCategoryAttribute2(int paramAttribute2SysNo)
{
string sql = "select * from category_attribute2 where sysno=" + paramAttribute2SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if ( !Util.HasMoreRow(ds))
return null;
CategoryAttribute2Info item = new CategoryAttribute2Info();
Map( item, ds.Tables[0].Rows[0]);
return item;
}
public int UpdateAttribute2(CategoryAttribute2Info oParam)
{
string sql = @"UPDATE Category_Attribute2 SET
A1SysNo=@A1SysNo,
Attribute2ID=@Attribute2ID, Attribute2Name=@Attribute2Name,
OrderNum=@OrderNum, Status=@Status,Attribute2Type=@Attribute2Type
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int,4);
SqlParameter paramA1SysNo = new SqlParameter("@A1SysNo", SqlDbType.Int,4);
SqlParameter paramAttribute2ID = new SqlParameter("@Attribute2ID", SqlDbType.NVarChar,20);
SqlParameter paramAttribute2Name = new SqlParameter("@Attribute2Name", SqlDbType.NVarChar,50);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
SqlParameter paramAttribute2Type = new SqlParameter("@Attribute2Type", SqlDbType.Int,4);
paramSysNo.Value = oParam.SysNo;
paramA1SysNo.Value = oParam.A1SysNo;
paramAttribute2ID.Value = oParam.Attribute2ID;
paramAttribute2Name.Value = oParam.Attribute2Name;
paramOrderNum.Value = oParam.OrderNum;
paramStatus.Value = oParam.Status;
paramAttribute2Type.Value = oParam.Attribute2Type;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramA1SysNo);
cmd.Parameters.Add(paramAttribute2ID);
cmd.Parameters.Add(paramAttribute2Name);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAttribute2Type);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int SetOrderNum(CategoryAttribute2Info oParam)
{
string sql = "update category_attribute2 set ordernum = " + oParam.OrderNum + " where sysno = " + oParam.SysNo;
SqlCommand cmd = new SqlCommand(sql);
return SqlHelper.ExecuteNonQuery(cmd);
}
public bool IsExistAttribute2(CategoryAttribute2Info oParam)
{
string sql = "select top 1 sysno from category_attribute2 where a1sysno=@a1sysno and Attribute2Name=@Attribute2Name and SysNo!=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramA1SysNo = new SqlParameter("@A1SysNo", SqlDbType.Int,4);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramAttribute2Name = new SqlParameter("@Attribute2Name", SqlDbType.NVarChar,50);
paramA1SysNo.Value = oParam.A1SysNo;
paramAttribute2Name.Value = oParam.Attribute2Name;
paramSysNo.Value = oParam.SysNo;
cmd.Parameters.Add(paramA1SysNo);
cmd.Parameters.Add(paramAttribute2Name);
cmd.Parameters.Add(paramSysNo);
DataSet ds = SqlHelper.ExecuteDataSet(cmd);;
if ( Util.HasMoreRow(ds))
return true;
else
return false;
}
public int InsertAttribute2(CategoryAttribute2Info oParam)
{
string sql = @"INSERT INTO Category_Attribute2
(
A1SysNo, Attribute2ID, Attribute2Name,
OrderNum, Status, Attribute2Type
)
VALUES (
@A1SysNo, @Attribute2ID, @Attribute2Name,
@OrderNum, @Status, @Attribute2Type
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramA1SysNo = new SqlParameter("@A1SysNo", SqlDbType.Int,4);
SqlParameter paramAttribute2ID = new SqlParameter("@Attribute2ID", SqlDbType.NVarChar,20);
SqlParameter paramAttribute2Name = new SqlParameter("@Attribute2Name", SqlDbType.NVarChar,50);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int,4);
SqlParameter paramStatus = new SqlParameter("@Status", SqlDbType.Int,4);
SqlParameter paramAttribute2Type = new SqlParameter("@Attribute2Type",SqlDbType.Int,4);
paramA1SysNo.Value = oParam.A1SysNo;
paramAttribute2ID.Value = oParam.Attribute2ID;
paramAttribute2Name.Value = oParam.Attribute2Name;
paramOrderNum.Value = oParam.OrderNum;
paramStatus.Value = oParam.Status;
paramAttribute2Type.Value = oParam.Attribute2Type;
cmd.Parameters.Add(paramA1SysNo);
cmd.Parameters.Add(paramAttribute2ID);
cmd.Parameters.Add(paramAttribute2Name);
cmd.Parameters.Add(paramOrderNum);
cmd.Parameters.Add(paramStatus);
cmd.Parameters.Add(paramAttribute2Type);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int GetCatetoryAttribute2NewOrderNum(CategoryAttribute2Info oParam)
{
string sql = "select isnull(max(OrderNum),0)+1 as newOrderNum from Category_Attribute2 where A1SysNo=" + oParam.A1SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if(Util.HasMoreRow(ds))
{
return Int32.Parse(ds.Tables[0].Rows[0][0].ToString());
}
else
{
return 1;
}
}