public void Update(CardSignLogInfo cardSignLogInfo)
{
IDataParameter[] parms = null;
var sqlUpdate = BaiRongDataProvider.TableStructureDao.GetUpdateSqlString(cardSignLogInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
ExecuteNonQuery(sqlUpdate, parms);
}
public int Insert(CardSignLogInfo cardSignLogInfo)
{
var cardSignLogId = 0;
IDataParameter[] parms = null;
var sqlInsert = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardSignLogInfo.ToNameValueCollection(), ConnectionString, TableName, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
cardSignLogId = ExecuteNonQueryAndReturnId(trans, sqlInsert, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(cardSignLogId);
}
public int Insert(CardSignLogInfo cardSignLogInfo)
{
var cardSignLogID = 0;
IDataParameter[] parms = null;
var SQL_INSERT = BaiRongDataProvider.TableStructureDao.GetInsertSqlString(cardSignLogInfo.ToNameValueCollection(), ConnectionString, TABLE_NAME, out parms);
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, SQL_INSERT, parms);
cardSignLogID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, TABLE_NAME);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(cardSignLogID);
}
public CardSignLogInfo GetCardSignLogInfo(int cardSignLogId)
{
CardSignLogInfo cardSignLogInfo = null;
string sqlWhere = $"WHERE ID = {cardSignLogId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
if (rdr.Read())
{
cardSignLogInfo = new CardSignLogInfo(rdr);
}
rdr.Close();
}
return(cardSignLogInfo);
}
public CardSignLogInfo GetCardSignLogInfo(int cardSignLogID)
{
CardSignLogInfo cardSignLogInfo = null;
string SQL_WHERE = $"WHERE ID = {cardSignLogID}";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
if (rdr.Read())
{
cardSignLogInfo = new CardSignLogInfo(rdr);
}
rdr.Close();
}
return(cardSignLogInfo);
}
public List <CardSignLogInfo> GetCardSignLogInfoList(int publishmentSystemId)
{
var cardSignLogInfoList = new List <CardSignLogInfo>();
string sqlWhere = $"WHERE PublishmentSystemID = {publishmentSystemId}";
var sqlSelect = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TableName, 0, SqlUtils.Asterisk, sqlWhere, null);
using (var rdr = ExecuteReader(sqlSelect))
{
while (rdr.Read())
{
var cardSignLogInfo = new CardSignLogInfo(rdr);
cardSignLogInfoList.Add(cardSignLogInfo);
}
rdr.Close();
}
return(cardSignLogInfoList);
}
public List <CardSignLogInfo> GetCardSignLogInfoList(int publishmentSystemID)
{
var cardSignLogInfoList = new List <CardSignLogInfo>();
string SQL_WHERE = $"WHERE PublishmentSystemID = {publishmentSystemID}";
var SQL_SELECT = BaiRongDataProvider.TableStructureDao.GetSelectSqlString(ConnectionString, TABLE_NAME, 0, SqlUtils.Asterisk, SQL_WHERE, null);
using (var rdr = ExecuteReader(SQL_SELECT))
{
while (rdr.Read())
{
var cardSignLogInfo = new CardSignLogInfo(rdr);
cardSignLogInfoList.Add(cardSignLogInfo);
}
rdr.Close();
}
return(cardSignLogInfoList);
}
