public int Insert(OnlineC1_C2Info oParam)
{
string sql = @"INSERT INTO OnlineC1_C2
(
C2SysNo, OrderNum
)
VALUES (
@C2SysNo, @OrderNum
)";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC2SysNo = new SqlParameter("@C2SysNo", SqlDbType.Int, 4);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
if (oParam.C2SysNo != AppConst.IntNull)
paramC2SysNo.Value = oParam.C2SysNo;
else
paramC2SysNo.Value = System.DBNull.Value;
if (oParam.OrderNum != AppConst.IntNull)
paramOrderNum.Value = oParam.OrderNum;
else
paramOrderNum.Value = System.DBNull.Value;
cmd.Parameters.Add(paramC2SysNo);
cmd.Parameters.Add(paramOrderNum);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int CompareTo(object obj)
{
OnlineC1_C2Info b = obj as OnlineC1_C2Info;
if (this.OrderNum > b.OrderNum)
{
return(1);
}
else
{
return(-1);
}
}
public int Delete(OnlineC1_C2Info oParam)
{
string sql = "DELETE OnlineC1_C2 where C2SysNo=@C2SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC2SysNo = new SqlParameter("@C2SysNo", SqlDbType.Int, 4);
if (oParam.C2SysNo != AppConst.IntNull)
paramC2SysNo.Value = oParam.C2SysNo;
else
paramC2SysNo.Value = System.DBNull.Value;
cmd.Parameters.Add(paramC2SysNo);
return SqlHelper.ExecuteNonQuery(cmd);
}
public int Update(OnlineC1_C2Info oParam)
{
string sql = @"UPDATE OnlineC1_C2 SET
C2SysNo=@C2SysNo, OrderNum=@OrderNum
WHERE C2SysNo=@C2SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramC2SysNo = new SqlParameter("@C2SysNo", SqlDbType.Int, 4);
SqlParameter paramOrderNum = new SqlParameter("@OrderNum", SqlDbType.Int, 4);
if (oParam.C2SysNo != AppConst.IntNull)
paramC2SysNo.Value = oParam.C2SysNo;
else
paramC2SysNo.Value = System.DBNull.Value;
if (oParam.OrderNum != AppConst.IntNull)
paramOrderNum.Value = oParam.OrderNum;
else
paramOrderNum.Value = System.DBNull.Value;
cmd.Parameters.Add(paramC2SysNo);
cmd.Parameters.Add(paramOrderNum);
return SqlHelper.ExecuteNonQuery(cmd);
}
private void map(OnlineC1_C2Info oParam, DataRow tempdr)
{
oParam.C2SysNo = Util.TrimIntNull(tempdr["C2SysNo"]);
oParam.OrderNum = Util.TrimIntNull(tempdr["OrderNum"]);
}
public void MoveUp(OnlineC1_C2Info oParam)
{
if (oParam.OrderNum == 1)
{
throw new BizException("it's the first one, can't be moved up");
}
SortedList sl = GetOnlineC1_C2List(oParam.C2SysNo);
if (sl == null)
{
throw new BizException("no items");
}
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
OnlineC1_C2Dac o = new OnlineC1_C2Dac();
foreach (OnlineC1_C2Info 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 OnlineC1_C2Info LoadOnlineC1_C2(int C2SysNo)
{
string sql = "select * from onlineC1_C2(nolock) where c2sysno=" + C2SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
{
OnlineC1_C2Info o = new OnlineC1_C2Info();
map(o, ds.Tables[0].Rows[0]);
return o;
}
else
return null;
}
public void Delete(OnlineC1_C2Info oParam)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
MoveBottom(oParam);
new OnlineC1_C2Dac().Delete(oParam);
DataSet ds = GetOnlineC1_C2_ProductDs(oParam.C2SysNo);
foreach (DataRow dr in ds.Tables[0].Rows)
{
OnlineC1_ProductInfo o = LoadOnlineC1_Product(Util.TrimIntNull(dr["SysNo"]));
new OnlineC1_ProductDac().Delete(o);
}
scope.Complete();
}
}
public SortedList GetOnlineC1_C2List(int C2SysNo)
{
Category2Info c2 = CategoryManager.GetInstance().GetC2Hash()[C2SysNo] as Category2Info;
int c1SysNo = c2.C1SysNo;
string sql = @"select * from OnlineC1_C2 oc(nolock) inner join category2 c2(nolock) on oc.c2sysno=c2.sysno where c2.c1sysno=" + c1SysNo + " order by ordernum";
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)
{
OnlineC1_C2Info item = new OnlineC1_C2Info();
map(item, dr);
sl.Add(item, null);
}
return sl;
}
public int SetOrderNum(OnlineC1_C2Info oParam)
{
string sql = "update onlineC1_C2 set ordernum = " + oParam.OrderNum + " where c2sysno = " + oParam.C2SysNo;
SqlCommand cmd = new SqlCommand(sql);
return SqlHelper.ExecuteNonQuery(cmd);
}