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); }