/// <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); }