public int DeleteFreightManArea(int paramSysNo)
{
if (freightManAreaHash == null || !freightManAreaHash.ContainsKey(paramSysNo))
throw new BizException("delete failed");
int result = new ASPDac().DeleteFreightManArea(paramSysNo);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
freightManAreaHash.Remove(paramSysNo);
return result;
}
public int DeleteShipPayUn(int paramSysNo)
{
if (shipPayHash == null || !shipPayHash.ContainsKey(paramSysNo))
throw new BizException("the un ShipType PayType record does not exist, delete failed");
int result = new ASPDac().DeleteShipPay(paramSysNo);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
shipPayHash.Remove(paramSysNo);
return result;
}
public int UpdateArea(AreaInfo oParam)
{
if (!areaHash.ContainsKey(oParam.SysNo))
throw new BizException("the area does not exist, update failed");
int result = new ASPDac().UpdateArea(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
areaHash.Remove(oParam.SysNo);
areaHash.Add(oParam.SysNo, oParam);
return result;
}
public int UpdateShipType(ShipTypeInfo oParam)
{
string sql = "select * from shiptype where shiptypeid=" + Util.ToSqlString(oParam.ShipTypeID) + " and sysno <>" + oParam.SysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("the same ship type id exists");
if (shipTypeHash == null || !shipTypeHash.ContainsKey(oParam.SysNo))
throw new BizException("the ship type does not exist, update failed");
int result = new ASPDac().UpdateShipType(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
shipTypeHash.Remove(oParam.SysNo);
shipTypeHash.Add(oParam.SysNo, oParam);
return result;
}
public int InsertShipType(ShipTypeInfo oParam)
{
string sql = "select * from shiptype where shiptypeid = " + Util.ToSqlString(oParam.ShipTypeID);
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("the same ship type id exists");
oParam.SysNo = SequenceDac.GetInstance().Create("ShipType_Sequence");
int result = new ASPDac().InsertShipType(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
if (shipTypeHash == null)
shipTypeHash = new Hashtable(10);
shipTypeHash.Add(oParam.SysNo, oParam);
return result;
}
public int InsertShipPayUn(ShipPayInfo oParam)
{
string sql = "select * from shiptype_paytype_un where ShipTypeSysNo = " + oParam.ShipTypeSysNo + " and PayTypeSysNo = " + oParam.PayTypeSysNo;
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("this shiptype_paytype_un record exists");
int result = new ASPDac().InsertShipPay(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
if (shipPayHash == null)
shipPayHash = new Hashtable(10);
shipPayHash.Add(oParam.SysNo, oParam);
return result;
}
public int InsertShipAreaPrice(ShipAreaPriceInfo oParam)
{
int result = new ASPDac().InsertShipAreaPrice(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
if (shipAreaPriceHash == null)
shipAreaPriceHash = new Hashtable(10);
shipAreaPriceHash.Add(oParam.SysNo, oParam);
return result;
}
public void InsertFreightManArea(string FreightMenList, string AreaSysNoList)
{
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string[] FreightMen = FreightMenList.Split(',');
string[] AreaSysNo = AreaSysNoList.Split(',');
for (int i = 0; i < FreightMen.Length; i++)
{
for (int j = 0; j < AreaSysNo.Length; j++)
{
string sql = "select * from FreightMan_Area where FreightUserSysNo = " + Int32.Parse(FreightMen[i]) + " and AreaSysNo = " + Int32.Parse(AreaSysNo[j]);
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
{
FreightManAreaInfo oParam = new FreightManAreaInfo();
oParam.FreightUserSysNo = Int32.Parse(FreightMen[i]);
oParam.AreaSysNo = Int32.Parse(AreaSysNo[j]);
int result = new ASPDac().InsertFreightManArea(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
if (freightManAreaHash == null)
freightManAreaHash = new Hashtable(10);
freightManAreaHash.Add(oParam.SysNo, oParam);
}
}
}
scope.Complete();
}
}
public int InsertArea(AreaInfo oParam)
{
if (!AppConfig.IsImportable)
foreach (AreaInfo item in areaHash.Values)
{
if (item.GetWholeName() == oParam.GetWholeName())
throw new BizException("area duplicated");
}
oParam.SysNo = SequenceDac.GetInstance().Create("Area_Sequence");
int result = new ASPDac().InsertArea(oParam);
SyncManager.GetInstance().SetDbLastVersion((int)AppEnum.Sync.ASP);
areaHash.Add(oParam.SysNo, oParam);
return result;
}
