public static string UserTranSelByUID(int iUserID, int iPage, int iNum)
{
StringBuilder sbText = new StringBuilder("{root:[");
if (iPage == 1)
{
IDataReader drTran = TransPDAL.TransSelOneByUID(iUserID, iNum);
while (drTran.Read())
{
sbText.Append("{");
sbText.AppendFormat("time:'{0}',price:'{1}',points:'{2}',name:'{3}'", drTran["time"].ToString(), drTran["price"].ToString(), drTran["points"].ToString(), drTran["name"].ToString());
sbText.Append("},");
}
drTran.Close();
drTran.Dispose();
}
if (sbText.Length == 7)
{
return("");
}
int iIndex = sbText.Length - 1;
sbText.Remove(iIndex, 1);
sbText.Append("]}");
return(sbText.ToString());
}
public static int PointSalesCommit(string sTranID, string sAccount, decimal dPrice)
{
int iRes = -1;
if (TranIDVal(sTranID))
{
int iState = TranIDStateSel(sTranID);
if (iState == 0)
{
iRes = TransPDAL.PointSalesCommit(sTranID, sAccount, dPrice);
if (0 == iRes)
{
PInfoSendToU.pointpaysend(sTranID);
}
}
else if (iState == 1)
{
iRes = 0;
}
}
return(iRes);
}
public static string getDingDanId(string rtcoid)//根据日期获取订单号
{
return(TransPDAL.getDingDanId(rtcoid));
}
public static int TranPSelUserIDByID(string sTranID)
{
return(TransPDAL.TranPSelUserIDByID(sTranID));
}
public static TransP TranPSelPointsByID(string sTranID)
{
return(TransPDAL.TranPSelPointsByID(sTranID));
}
public static TransP UserTranSel(string sTranID)
{
return(TransPDAL.TransSelectByID(sTranID));
}
public static string SelIsTranByUID(int iUserID)
{
return(TransPDAL.SelIsTranByUID(iUserID));
}
public static string FirstGiftSend(int iUserID, int iGiftPoint, string sTranIP, int iChannid)
{
return(TransPDAL.FirstGiftSend(iUserID, iGiftPoint, sTranIP, iChannid));
}
public static int TranPTodayNumSel(double dPrice, DateTime dtBegin, DateTime dtEnd)
{
return(TransPDAL.TranPTodayNumSel(dPrice, dtBegin, dtEnd));
}
public static string YRTSalesInit(int iUserID, int iPoint, decimal dPrice, string sTranIP)
{
return(TransPDAL.YRTSalesInit(iUserID, iPoint, dPrice, sTranIP));
}
public static string GiftPointsSend(int iUserID, int iGiftPoint, string sTranIP)
{
return(TransPDAL.GiftPointsSend(iUserID, iGiftPoint, sTranIP));
}
public static int TranIDStateSel(string sTranID)
{
return(TransPDAL.TranPSelStateByID(sTranID));
}
public static string PointSalesInit(string sChannel, string sPhone, string sAccount, decimal dPrice, int iCount, string sTranIP)
{
return(TransPDAL.PointSalesInit(sChannel, sPhone, sAccount, dPrice, iCount, sTranIP));
}
public static List <TextTwo> TranPTop20PaySel(DateTime dtBegin, DateTime dtEnd)
{
return(TransPDAL.TranPTop20PaySel(dtBegin, dtEnd));
}
public static double TranPTodayPriceSel(int iUserID, DateTime dtBegin, DateTime dtEnd)
{
return(TransPDAL.TranPTodayPriceSel(iUserID, dtBegin, dtEnd));
}
public static int YRTSalesCommit(string sTranID, int iUserID, int iPoint)
{
return(TransPDAL.YRTSalesCommit(sTranID, iUserID, iPoint));
}
public static void TransMsgSave(string sAccount, string sTranID, decimal dPrice, string sCode, string sCodeMsg, string sBid)
{
TransPDAL.TransMsgSave(sAccount, sTranID, dPrice, sCode, sCodeMsg, sBid);
}
public static int TranPSelPointsByUser(int iUserID)
{
return(TransPDAL.TranPSelPointsByUser(iUserID));
}