public int Insert(KeywordGroupInfo groupInfo)
{
var groupId = 0;
var sqlString = "INSERT INTO wx_KeywordGroup (PublishmentSystemID, GroupName, Taxis) VALUES (@PublishmentSystemID, @GroupName, @Taxis)";
var taxis = GetMaxTaxis() + 1;
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, groupInfo.PublishmentSystemId),
GetParameter(ParmGroupName, EDataType.NVarChar, 255, groupInfo.GroupName),
GetParameter(ParmTaxis, EDataType.Integer, taxis)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
groupId = ExecuteNonQueryAndReturnId(trans, sqlString, parms);
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(groupId);
}
public int Insert(KeywordGroupInfo groupInfo)
{
var groupID = 0;
var sqlString = "INSERT INTO wx_KeywordGroup (PublishmentSystemID, GroupName, Taxis) VALUES (@PublishmentSystemID, @GroupName, @Taxis)";
var taxis = GetMaxTaxis() + 1;
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, groupInfo.PublishmentSystemID),
GetParameter(PARM_GROUP_NAME, EDataType.NVarChar, 255, groupInfo.GroupName),
GetParameter(PARM_TAXIS, EDataType.Integer, taxis)
};
using (var conn = GetConnection())
{
conn.Open();
using (var trans = conn.BeginTransaction())
{
try
{
ExecuteNonQuery(trans, sqlString, parms);
groupID = BaiRongDataProvider.DatabaseDao.GetSequence(trans, "wx_KeywordGroup");
trans.Commit();
}
catch
{
trans.Rollback();
throw;
}
}
}
return(groupID);
}
public void Update(KeywordGroupInfo groupInfo)
{
var parms = new IDataParameter[]
{
GetParameter(ParmPublishmentSystemId, EDataType.Integer, groupInfo.PublishmentSystemId),
GetParameter(ParmGroupName, EDataType.NVarChar, 255, groupInfo.GroupName),
GetParameter(ParmTaxis, EDataType.Integer, groupInfo.Taxis),
GetParameter(ParmGroupId, EDataType.Integer, groupInfo.GroupId)
};
ExecuteNonQuery(SqlUpdate, parms);
}
public void Update(KeywordGroupInfo groupInfo)
{
var parms = new IDataParameter[]
{
GetParameter(PARM_PUBLISHMENT_SYSTEM_ID, EDataType.Integer, groupInfo.PublishmentSystemID),
GetParameter(PARM_GROUP_NAME, EDataType.NVarChar, 255, groupInfo.GroupName),
GetParameter(PARM_TAXIS, EDataType.Integer, groupInfo.Taxis),
GetParameter(PARM_GROUP_ID, EDataType.Integer, groupInfo.GroupID)
};
ExecuteNonQuery(SQL_UPDATE, parms);
}
public List <KeywordGroupInfo> GetKeywordGroupInfoList()
{
var list = new List <KeywordGroupInfo>();
using (var rdr = ExecuteReader(SqlSelectAll))
{
while (rdr.Read())
{
var groupInfo = new KeywordGroupInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), rdr.GetInt32(3));
list.Add(groupInfo);
}
rdr.Close();
}
return(list);
}
public KeywordGroupInfo GetKeywordGroupInfo(int groupId)
{
KeywordGroupInfo groupInfo = null;
var parms = new IDataParameter[]
{
GetParameter(ParmGroupId, EDataType.Integer, groupId)
};
using (var rdr = ExecuteReader(SqlSelect, parms))
{
if (rdr.Read())
{
groupInfo = new KeywordGroupInfo(rdr.GetInt32(0), rdr.GetInt32(1), rdr.GetValue(2).ToString(), rdr.GetInt32(3));
}
rdr.Close();
}
return(groupInfo);
}
