public int CompareTo(object obj)
{
ShipTypeInfo b = obj as ShipTypeInfo;
if (String.Compare(this.OrderNumber, b.OrderNumber) >= 0)
{
return(1);
}
else
{
return(-1);
}
}
private void Map(ShipTypeInfo oParam, DataRow tempdr)
{
oParam.SysNo = Util.TrimIntNull(tempdr["SysNo"]);
oParam.ShipTypeID = Util.TrimNull(tempdr["ShipTypeID"]);
oParam.ShipTypeName = Util.TrimNull(tempdr["ShipTypeName"]);
oParam.ShipTypeDesc = Util.TrimNull(tempdr["ShipTypeDesc"]);
oParam.Period = Util.TrimNull(tempdr["Period"]);
oParam.Provider = Util.TrimNull(tempdr["Provider"]);
oParam.PremiumRate = Util.TrimDecimalNull(tempdr["PremiumRate"]);
oParam.PremiumBase = Util.TrimDecimalNull(tempdr["PremiumBase"]);
oParam.FreeShipBase = Util.TrimDecimalNull(tempdr["FreeShipBase"]);
oParam.OrderNumber = Util.TrimNull(tempdr["OrderNumber"]);
oParam.IsOnlineShow = Util.TrimIntNull(tempdr["IsOnlineShow"]);
oParam.IsWithPackFee = Util.TrimIntNull(tempdr["IsWithPackFee"]);
oParam.StatusQueryType = Util.TrimIntNull(tempdr["StatusQueryType"]);
oParam.StatusQueryUrl = Util.TrimNull(tempdr["StatusQueryUrl"]);
}
public int UpdateShipType(ShipTypeInfo oParam)
{
string sql = @"UPDATE ShipType SET
ShipTypeID=@ShipTypeID,
ShipTypeName=@ShipTypeName, ShipTypeDesc=@ShipTypeDesc,
Period=@Period, Provider=@Provider,
PremiumRate=@PremiumRate, PremiumBase=@PremiumBase,
FreeShipBase=@FreeShipBase, OrderNumber=@OrderNumber,
IsOnlineShow=@IsOnlineShow, IsWithPackFee=@IsWithPackFee,
StatusQueryType=@StatusQueryType,StatusQueryUrl=@StatusQueryUrl
WHERE SysNo=@SysNo";
SqlCommand cmd = new SqlCommand(sql);
SqlParameter paramSysNo = new SqlParameter("@SysNo", SqlDbType.Int, 4);
SqlParameter paramShipTypeID = new SqlParameter("@ShipTypeID", SqlDbType.NVarChar, 20);
SqlParameter paramShipTypeName = new SqlParameter("@ShipTypeName", SqlDbType.NVarChar, 50);
SqlParameter paramShipTypeDesc = new SqlParameter("@ShipTypeDesc", SqlDbType.NVarChar, 500);
SqlParameter paramPeriod = new SqlParameter("@Period", SqlDbType.NVarChar, 50);
SqlParameter paramProvider = new SqlParameter("@Provider", SqlDbType.NVarChar, 50);
SqlParameter paramPremiumRate = new SqlParameter("@PremiumRate", SqlDbType.Decimal, 9);
SqlParameter paramPremiumBase = new SqlParameter("@PremiumBase", SqlDbType.Decimal, 9);
SqlParameter paramFreeShipBase = new SqlParameter("@FreeShipBase", SqlDbType.Decimal, 9);
SqlParameter paramOrderNumber = new SqlParameter("@OrderNumber", SqlDbType.NVarChar, 10);
SqlParameter paramIsOnlineShow = new SqlParameter("@IsOnlineShow", SqlDbType.Int, 4);
SqlParameter paramIsWithPackFee = new SqlParameter("@IsWithPackFee", SqlDbType.Int, 4);
SqlParameter paramStatusQueryType = new SqlParameter("@StatusQueryType", SqlDbType.Int, 4);
SqlParameter paramStatusQueryUrl = new SqlParameter("@StatusQueryUrl", SqlDbType.NVarChar, 500);
paramSysNo.Value = oParam.SysNo;
paramShipTypeID.Value = oParam.ShipTypeID;
paramShipTypeName.Value = oParam.ShipTypeName;
paramShipTypeDesc.Value = oParam.ShipTypeDesc;
paramPeriod.Value = oParam.Period;
paramProvider.Value = oParam.Provider;
paramPremiumRate.Value = oParam.PremiumRate;
paramPremiumBase.Value = oParam.PremiumBase;
paramFreeShipBase.Value = oParam.FreeShipBase;
paramOrderNumber.Value = oParam.OrderNumber;
paramIsOnlineShow.Value = oParam.IsOnlineShow;
paramIsWithPackFee.Value = oParam.IsWithPackFee;
paramStatusQueryType.Value = oParam.StatusQueryType;
paramStatusQueryUrl.Value = oParam.StatusQueryUrl;
cmd.Parameters.Add(paramSysNo);
cmd.Parameters.Add(paramShipTypeID);
cmd.Parameters.Add(paramShipTypeName);
cmd.Parameters.Add(paramShipTypeDesc);
cmd.Parameters.Add(paramPeriod);
cmd.Parameters.Add(paramProvider);
cmd.Parameters.Add(paramPremiumRate);
cmd.Parameters.Add(paramPremiumBase);
cmd.Parameters.Add(paramFreeShipBase);
cmd.Parameters.Add(paramOrderNumber);
cmd.Parameters.Add(paramIsOnlineShow);
cmd.Parameters.Add(paramIsWithPackFee);
cmd.Parameters.Add(paramStatusQueryType);
cmd.Parameters.Add(paramStatusQueryUrl);
return SqlHelper.ExecuteNonQuery(cmd);
}
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 void InitShipType()
{
lock (shipTypeLock)
{
if (shipTypeHash != null)
shipTypeHash.Clear();
string sql = "select * from shiptype";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (!Util.HasMoreRow(ds))
return;
foreach (DataRow dr in ds.Tables[0].Rows)
{
ShipTypeInfo item = new ShipTypeInfo();
Map(item, dr);
shipTypeHash.Add(item.SysNo, item);
}
}
}
public void ImportShipType()
{
if (!AppConfig.IsImportable)
throw new BizException("Is Importable is false");
/* do not use the following code after Data Pour in */
string sql = @"select * from ShipType";
DataSet ds = SqlHelper.ExecuteDataSet(sql);
if (Util.HasMoreRow(ds))
throw new BizException("the table ship type is not empty");
TransactionOptions options = new TransactionOptions();
options.IsolationLevel = System.Transactions.IsolationLevel.ReadCommitted;
options.Timeout = TransactionManager.DefaultTimeout;
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required, options))
{
string sql1 = @"select st.*, st.withpackfee as iswithpackfee, stl.shiptypename, stl.company, stl.period from ipp2003..ship_type as st, ipp2003..ship_type_language as stl
where st.sysno = stl.shiptypesysno and stl.languageid = 'cn'";
DataSet ds1 = SqlHelper.ExecuteDataSet(sql1);
foreach (DataRow dr1 in ds1.Tables[0].Rows)
{
ShipTypeInfo oShipType = new ShipTypeInfo();
oShipType.ShipTypeID = Util.TrimNull(dr1["ShipTypeID"]);
oShipType.ShipTypeName = Util.TrimNull(dr1["ShipTypeName"]);
oShipType.ShipTypeDesc = "";
oShipType.Period = Util.TrimNull(dr1["Period"]);
oShipType.Provider = Util.TrimNull(dr1["Company"]);
oShipType.PremiumRate = Util.TrimDecimalNull(dr1["PremiumRate"]);
oShipType.PremiumBase = Util.TrimDecimalNull(dr1["PremiumBase"]);
oShipType.FreeShipBase = 0;
oShipType.OrderNumber = "zzz";
oShipType.IsOnlineShow = Util.TrimIntNull(dr1["sstatus"]);
oShipType.IsWithPackFee = Util.TrimIntNull(dr1["IsWithPackFee"]);
oShipType.StatusQueryType = Util.TrimIntNull(dr1["StatusQueryType"]);
oShipType.StatusQueryUrl = Util.TrimNull(dr1["StatusQueryUrl"]);
this.InsertShipType(oShipType);
//insert into convert table
ImportInfo oImport = new ImportInfo();
oImport.OldSysNo = Util.TrimIntNull(dr1["SysNo"]);
oImport.NewSysNo = oShipType.SysNo;
new ImportDac().Insert(oImport, "ShipType");
}
scope.Complete();
}
}
private void GetLastOneSo()
{
DataSet ds = new DataSet();
ds = SaleManager.GetInstance().GetSOOnlineDs(oSession.sCustomer.SysNo, 1);
if (Util.HasMoreRow(ds))
{
if (ds.Tables[0].Rows.Count == 1)
{
DataRow dr = ds.Tables[0].Rows[0];
int soSysNo = int.Parse(dr["sysno"].ToString());
oldSoInfo = SaleManager.GetInstance().LoadSOMaster(soSysNo);
shipTypeInfo = (ShipTypeInfo)ASPManager.GetInstance().GetShipTypeHash()[oldSoInfo.ShipTypeSysNo];
payTypeInfo = (PayTypeInfo)ASPManager.GetInstance().GetPayTypeHash()[oldSoInfo.PayTypeSysNo];
}
else
{
Response.Redirect("ShoppingCart.aspx");
}
}
}