public static int Add(YRTPay yrtObject)
{
Database dbDCenter = DatabaseFactory.CreateDatabase(sConn);
DbCommand dcFirstOfPayPoint = dbDCenter.GetStoredProcCommand("YRTPay_Add");
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@tid", DbType.String, yrtObject.TID);
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@trantime", DbType.String, yrtObject.TranTime);
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@point", DbType.Int32, yrtObject.Point);
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@tranip", DbType.String, yrtObject.TranIP);
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@userid", DbType.Int32, yrtObject.UserID);
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@tranid", DbType.String, yrtObject.TranID);
dbDCenter.AddInParameter(dcFirstOfPayPoint, "@offername", DbType.String, yrtObject.OfferName);
return(dbDCenter.ExecuteNonQuery(dcFirstOfPayPoint));
}
public static string Pay(string sTID, int iPoint, int iUserID, string sOfferName)
{
string sRes = string.Empty;
if (iPoint > 2000)
{
sRes = string.Format("{\"uid\":\"{0}\",\"vcpoints\":\"{1}\",\"tid\":\"{2}\",\"offer_name\":\"{3}\",\"status\":\"1004\"}",
iUserID, iPoint, sTID, sOfferName);
}
else
{
decimal dPrice = Convert.ToDecimal(iPoint / 10);
string sTranIP = ProvideCommon.GetRealIP();
string sTranID = TransPBLL.YRTSalesInit(iUserID, iPoint, dPrice, sTranIP);
if (sTranID.Length < 10)
{
return("tranid init err");
}
YRTPay yrtPayObject = new YRTPay();
yrtPayObject.OfferName = sOfferName;
yrtPayObject.Point = iPoint;
yrtPayObject.TID = sTID;
yrtPayObject.TranID = sTranID;
yrtPayObject.TranIP = ProvideCommon.GetRealIP();
yrtPayObject.TranTime = DateTime.Now;
yrtPayObject.UserID = iUserID;
int iAddNum = YRTPayAdd(yrtPayObject);
if (iAddNum > 0)
{
int iTranRes = TransPBLL.YRTSalesCommit(sTranID, iUserID, iPoint);
if (iTranRes == 0)
{
sRes = string.Format("{\"uid\":\"{0}\",\"vcpoints\":\"{1}\",\"tid\":\"{2}\",\"offer_name\":\"{3}\",\"status\":\"success\"}",
iUserID, iPoint, sTID, sOfferName);
}
else
{
sRes = iTranRes.ToString();
}
}
else
{
sRes = string.Format("{\"uid\":\"{0}\",\"vcpoints\":\"{1}\",\"tid\":\"{2}\",\"offer_name\":\"{3}\",\"status\":\"yrtpay insert err\"}",
iUserID, iPoint, sTID, sOfferName);
}
}
return(sRes);
}
public static int YRTPayAdd(YRTPay yrtPayObject)
{
return(YRTPayDAL.Add(yrtPayObject));
}
