public static List <tb_ActiveCode> GetActiveCode()
{
try
{
var command = ConnectManager.DataProvider.CreateCommandStruct("tb_ActiveCode", CommandMode.Inquiry);
command.Columns = "Activecode,GenerateUserId,UseUserId,CreateDate";
command.Parser();
using (var reader = ConnectManager.DataProvider.ExecuteReader(CommandType.Text, command.Sql, command.Parameters))
{
List <tb_ActiveCode> olist = new List <tb_ActiveCode>();
while (reader.Read())
{
tb_ActiveCode ordermode = new tb_ActiveCode
{
Activecode = reader["Activecode"].ToStringEmpty(),
GenerateUserId = reader["GenerateUserId"].ToInt32(),
UseUserId = reader["UseUserId"].ToInt32(),
CreateDate = reader["CreateDate"].ToDateTime()
};
olist.Add(ordermode);
}
return(olist);
}
}
catch (Exception ex)
{
TraceLog.WriteError("ChangeGameServerStatus error:{0}", ex);
}
return(new List <tb_ActiveCode>());
}
public static bool AddActiveCode(tb_ActiveCode model)
{
var command = ConnectManager.DataProvider.CreateCommandStruct("tb_ActiveCode", CommandMode.Insert);
command.AddParameter("Activecode", model.Activecode);
command.AddParameter("GenerateUserId", model.GenerateUserId);
command.AddParameter("UseUserId", model.UseUserId);
command.AddParameter("CreateDate", model.CreateDate);
command.Parser();
return(ConfigManger.Provider.ExecuteQuery(CommandType.Text, command.Sql, command.Parameters) > 0);
}