public static TransP TranDataBind(IDataReader drTran)
{
TransP tObject = new TransP();
if (drTran.Read())
{
tObject.ChannelID = null == drTran["channelid"] ? 0 : Convert.ToInt32(drTran["channelid"]);
tObject.price = null == drTran["price"] ? 0 : Convert.ToDouble(drTran["price"]);
tObject.state = null == drTran["state"] ? 0 : Convert.ToInt32(drTran["state"]);
tObject.TranGiftPoints = null == drTran["GiftPoints"] ? 0 : Convert.ToInt32(drTran["GiftPoints"]);
tObject.TranPoints = null == drTran["Points"] ? 0 : Convert.ToInt32(drTran["Points"]);
tObject.TranTime = null == drTran["time"] ? DateTime.Now : Convert.ToDateTime(drTran["time"]);
tObject.UserID = null == drTran["userid"] ? 0 : Convert.ToInt32(drTran["userid"]);
tObject.TranID = null == drTran["id"] ? string.Empty : drTran["id"].ToString();
tObject.TranIP = null == drTran["tranip"] ? string.Empty : drTran["tranip"].ToString();
tObject.phone = null == drTran["phone"] ? string.Empty : drTran["phone"].ToString();
}
drTran.Close();
return(tObject);
}
public static TransP TranPSelPointsByID(string sTranID)
{
Database dbUCenter = DatabaseFactory.CreateDatabase(sConn);
DbCommand dcTran = dbUCenter.GetStoredProcCommand("SP_TranP_SelPointsByID");
dbUCenter.AddInParameter(dcTran, "@id", DbType.String, sTranID);
IDataReader drRead = dbUCenter.ExecuteReader(dcTran);
TransP tpObject = new TransP();
if (drRead.Read())
{
tpObject.TranPoints = Convert.ToInt32(drRead["points"]);
tpObject.TranGiftPoints = Convert.ToInt32(drRead["giftpoints"]);
}
drRead.Close();
dcTran.Dispose();
return(tpObject);
}
public static void pointpaysend(string sPTranID)
{
TransP tpObject = TransPBLL.UserTranSel(sPTranID);
string sReturn = string.Empty;
if (tpObject.state == 1)
{
string sUrl = "http://union.dao50.com/tarns/transPoints.aspx";
StringBuilder sbText = new StringBuilder();
sbText.AppendFormat("orderid={0}&", tpObject.TranID.Trim());
sbText.AppendFormat("userid={0}&", tpObject.UserID);
sbText.AppendFormat("ordertime={0}&", tpObject.TranTime);
sbText.AppendFormat("channel={0}&", tpObject.ChannelID);
sbText.AppendFormat("price={0}&", tpObject.price);
sbText.AppendFormat("points={0}&", tpObject.TranPoints);
sbText.AppendFormat("giftpoints={0}&", tpObject.TranGiftPoints);
sbText.AppendFormat("tranip={0}", tpObject.TranIP);
sReturn = string.Format("{0}?{1}", sUrl, sbText.ToString());
}
ProvideCommon.GetPageInfo(sReturn);
}
