/// <summary>
/// 添加聊天计费历史
/// </summary>
/// <param name="tchatFeehis"></param>
/// <returns></returns>
public bool AddChatFee(TchatFeehis tchatFeehis, OracleTransaction transaction)
{
var sql = "INSERT INTO TCHAT_FEEHIS(HISID,NODEID,FEETYPE,BUSINESSTYPE,GROUPID,NUM,RECEIVER,AMOUNT,SENDTIME,STATUS,CREATETIME,REMARKS,SEQUENCEID) VALUES(SEQ_TCHAT_FEEHIS.NEXTVAL,'{0}','{1}','{2}','{3}','{4}','{5}','{6}',to_date('{7}','YYYY-MM-DD HH24:MI:SS'),'{8}',to_date('{9}','YYYY-MM-DD HH24:MI:SS'),'{10}','{11}')";
sql = string.Format(sql, tchatFeehis.Nodeid, tchatFeehis.Feetype, tchatFeehis.Businesstype, tchatFeehis.Groupid, tchatFeehis.Num, tchatFeehis.Receiver, tchatFeehis.Amount, tchatFeehis.Sendtime, tchatFeehis.Status, tchatFeehis.Createtime, tchatFeehis.Remarks, tchatFeehis.Sequenceid);
return(OracleHelper.ExecuteNonQuery(transaction, CommandType.Text, sql) > 0);
}
/// <summary>
/// 根据seq获取聊天计费历史
/// </summary>
/// <param name="nodeId"></param>
/// <returns></returns>
public TchatFeehis GetChatFeeHisBySeq(string seq)
{
string sql = "SELECT * FROM TCHAT_FEEHIS WHERE SEQUENCEID='{0}'";
sql = string.Format(sql, seq);
TchatFeehis tchatFeehis = new TchatFeehis();
using (var reader = OracleHelper.ExecuteReader(sql))
{
if (reader.Read())
{
tchatFeehis.Hisid = Convert.ToInt32(reader["Hisid"]);
}
}
return(tchatFeehis);
}
