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