public int ExecuteNonQuery(string sql)
{
var cmd = db2.Command();
cmd.CommandText = sql;
TimerStart();
try
{
return(cmd.ExecuteNonQuery());
}
catch (System.Data.Common.DbException ex)
{
Shotgun.Library.ErrLogRecorder.SqlError(ex, cmd);
throw;
}
finally
{
TimerEnd(sql);
cmd.Dispose();
}
}
public static PoolSetModel TroneOrderToPoolSetMode(IBaseDataClass2 dBase, int troneOrderId)
{
var data = cache.GetCacheData(false);
PoolSetModel m = null;
if (data == null)
{//此处要保证正常poolset的加载
QueryPoolSetById(dBase, 0);
}
else
{
lock (cache.SyncRoot)
{
m = data.FirstOrDefault(e => e.trone_order_id == troneOrderId);
}
}
if (m != null)
{
return(m);
}
var sql = "select sp_trone_id,tod.trone_id , ( stn.status=1 and tn.status=1 and tod.disable=0 and stn.is_on_api=1) status "
+ " FROM tbl_trone_order tod "
+ " left join tbl_trone tn on tn.id= tod.trone_id "
+ " left join tbl_sp_trone stn on stn.id= tn.sp_trone_id "
+ " where tod.id= " + troneOrderId;
var cmd = dBase.Command();
cmd.CommandText = sql;
IDataReader dr = null;
m = new PoolSetModel();
m.trone_order_id = troneOrderId;
m.id = 100000 + troneOrderId;
m.priority = 30;
try
{
dr = dBase.ExecuteReader(cmd);
if (!dr.Read())
{
m.status = 0;
}
else
{
m.sp_trone_id = dr.GetInt32(0);
m.trone_id = dr.GetInt32(1);
m.status = dr.GetInt32(2);
}
}
finally
{
if (dr != null)
{
dr.Dispose();
}
cmd.Dispose();
}
lock (cache)
cache.InsertItem(m);
return(m);
}
