public void MarkMsgRetransmitted(List <int> updMsgs)
{
string ids = "";
for (int i = 0; i < updMsgs.Count; i++)
{
if (i > 0)
{
ids += " or ";
}
ids += "id=" + updMsgs[i];
/* if (i != updMsgs.Count-1)
* {
* ids += " or ";
* }
*/
}
string sql = new CSQLUpdateBuilder()
._1_UpdateTable("chat_messages")
._2_SetColumn("retransmited", 1)
._3_Where(ids)
.Build();
_mysqlConnector.ExecuteInsertOrUpdate(sql);
}
public void UpdTrdWithDrawReq(int id)
{
string sql = new CSQLUpdateBuilder()
._1_UpdateTable("traders_request_withdraw")
._2_SetColumnExpr("dt_complete", "Now()")
//._2_SetColumn("dt_complete", DateTime.Now)
._3_Where(String.Format("id={0}", id))
.Build();
_mysqlConnector.ExecuteInsertOrUpdate(sql);
}
public long UpdateProcFeeDealing(int accountId, int stockExchId, decimal value)
{
string sql = new CSQLUpdateBuilder()
._1_UpdateTable("accounts_trade")
._2_SetColumn("proc_fee_dealing", value)
._3_Where(String.Format("accounts_money_id={0} and stock_exchange_id={1}", accountId, stockExchId))
.Build();
long id = _mysqlConnector.ExecuteInsertOrUpdate(sql);
return(id);
}
