public void InsertDataExtendFields(ExtendRelationType relationType, int relationId, IDictionary <int, string> extendData) { if (extendData.Count == 0) { return; } string sql = base.OptimizeSQL(SP.DataExtend_InsertOrUpdateFieldValue); IList <SqlQuery> querys = new List <SqlQuery>(); querys.Add(SqlQueryHelper.Format(SP.DataExtend_ClearupExtendFielValue, new object[, ] { { "@relationType", relationType }, { "@relationId", relationId } } )); foreach (int key in extendData.Keys) { if (!String.IsNullOrEmpty(extendData[key])) { querys.Add(new SqlQuery(sql, new object[, ] { { "@relationType", relationType }, { "@relationId", relationId }, { "@fieldId", key }, { "@fieldValue", extendData[key] } })); } } base.ExecuteNonQuery(querys.ToArray()); }
public void InsertDataExtendFields(ExtendRelationType relationType, int relationId, IDictionary<int, string> extendData) { if (extendData.Count == 0) return; string sql = base.OptimizeSql(DbSql.DataExtend_InsertOrUpdateFieldValue); IList<SqlQuery> querys = new List<SqlQuery>(); querys.Add(SqlQueryHelper.Format(DbSql.DataExtend_ClearupExtendFielValue, new object[,]{ {"@relationType",relationType}, {"@relationId",relationId} } )); foreach (int key in extendData.Keys) { if (!String.IsNullOrEmpty(extendData[key])) { querys.Add(new SqlQuery(sql, new object[,]{ {"@relationType",relationType}, {"@relationId",relationId}, {"@fieldId",key}, {"@fieldValue",extendData[key]} })); } } base.ExecuteNonQuery(querys.ToArray()); }
public IDictionary <int, IList <IExtendValue> > GetExtendFieldValuesList(int siteId, ExtendRelationType type, IList <int> idList) { int fieldId; int relationId; IDictionary <int, IList <IExtendValue> > extendValues = new Dictionary <int, IList <IExtendValue> >(); this._extendDal.GetExtendValuesList(siteId, (int)ExtendRelationType.Archive, idList, rd => { while (rd.Read()) { relationId = int.Parse(rd["relation_id"].ToString()); fieldId = int.Parse(rd["field_id"].ToString()); if (!extendValues.ContainsKey(relationId)) { extendValues.Add(relationId, new List <IExtendValue>()); } extendValues[relationId].Add( new ExtendValue(int.Parse(rd["id"].ToString()), this.GetExtendFieldById(siteId, fieldId), rd["field_value"].ToString().Replace("\n", "<br />") ) ); } }); return(extendValues); }
public IDictionary<int, IList<IExtendValue>> GetExtendFieldValuesList(int siteId, ExtendRelationType type, IList<int> idList) { int fieldId; int relationId; IDictionary<int, IList<IExtendValue>> extendValues = new Dictionary<int, IList<IExtendValue>>(); this.extendDAL.GetExtendValuesList(siteId, (int)ExtendRelationType.Archive, idList, rd => { while (rd.Read()) { relationId = int.Parse(rd["relationId"].ToString()); fieldId = int.Parse(rd["fieldId"].ToString()); if (!extendValues.ContainsKey(relationId)) { extendValues.Add(relationId, new List<IExtendValue>()); } extendValues[relationId].Add( new ExtendValue(int.Parse(rd["id"].ToString()), this.GetExtendFieldById(siteId, fieldId), rd["fieldValue"].ToString().Replace("\n","<br />") ) ); } }); return extendValues; }