public Rain.Model.channel DataRowToModel(
OleDbConnection conn,
OleDbTransaction trans,
DataRow row)
{
Rain.Model.channel channel = new Rain.Model.channel();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
channel.id = int.Parse(row["id"].ToString());
}
if (row["site_id"] != null && row["site_id"].ToString() != "")
{
channel.site_id = int.Parse(row["site_id"].ToString());
}
if (row["name"] != null)
{
channel.name = row["name"].ToString();
}
if (row["title"] != null)
{
channel.title = row["title"].ToString();
}
if (row["is_albums"] != null && row["is_albums"].ToString() != "")
{
channel.is_albums = int.Parse(row["is_albums"].ToString());
}
if (row["is_attach"] != null && row["is_attach"].ToString() != "")
{
channel.is_attach = int.Parse(row["is_attach"].ToString());
}
if (row["is_spec"] != null && row["is_spec"].ToString() != "")
{
channel.is_spec = int.Parse(row["is_spec"].ToString());
}
if (row["sort_id"] != null && row["sort_id"].ToString() != "")
{
channel.sort_id = int.Parse(row["sort_id"].ToString());
}
StringBuilder stringBuilder = new StringBuilder();
stringBuilder.Append("select top 1 id,channel_id,field_id from " + this.databaseprefix + "channel_field ");
stringBuilder.Append(" where channel_id=@channel_id ");
OleDbParameter[] oleDbParameterArray = new OleDbParameter[1]
{
new OleDbParameter("@channel_id", OleDbType.Integer, 4)
};
oleDbParameterArray[0].Value = (object)channel.id;
DataSet dataSet = DbHelperOleDb.Query(conn, trans, stringBuilder.ToString(), oleDbParameterArray);
if (dataSet.Tables[0].Rows.Count > 0)
{
int count = dataSet.Tables[0].Rows.Count;
List <channel_field> channelFieldList = new List <channel_field>();
for (int index = 0; index < count; ++index)
{
channel_field channelField = new channel_field();
if (dataSet.Tables[0].Rows[index]["id"].ToString() != "")
{
channelField.id = int.Parse(dataSet.Tables[0].Rows[index]["id"].ToString());
}
if (dataSet.Tables[0].Rows[index]["channel_id"].ToString() != "")
{
channelField.channel_id = int.Parse(dataSet.Tables[0].Rows[index]["channel_id"].ToString());
}
if (dataSet.Tables[0].Rows[index]["field_id"].ToString() != "")
{
channelField.field_id = int.Parse(dataSet.Tables[0].Rows[index]["field_id"].ToString());
}
channelFieldList.Add(channelField);
}
channel.channel_fields = channelFieldList;
}
}
return(channel);
}
public bool Update(Rain.Model.channel model)
{
Rain.Model.channel model1 = this.GetModel(model.id);
int siteNavId = new channel_site(this.databaseprefix).GetSiteNavId(model.site_id);
if (siteNavId == 0)
{
return(false);
}
using (OleDbConnection oleDbConnection = new OleDbConnection(DbHelperOleDb.connectionString))
{
oleDbConnection.Open();
using (OleDbTransaction trans = oleDbConnection.BeginTransaction())
{
try
{
StringBuilder stringBuilder1 = new StringBuilder();
stringBuilder1.Append("update " + this.databaseprefix + "channel set ");
stringBuilder1.Append("site_id=@site_id,");
stringBuilder1.Append("[name]=@name,");
stringBuilder1.Append("title=@title,");
stringBuilder1.Append("is_albums=@is_albums,");
stringBuilder1.Append("is_attach=@is_attach,");
stringBuilder1.Append("is_spec=@is_spec,");
stringBuilder1.Append("sort_id=@sort_id");
stringBuilder1.Append(" where id=@id ");
OleDbParameter[] oleDbParameterArray1 = new OleDbParameter[8]
{
new OleDbParameter("@site_id", OleDbType.Integer, 4),
new OleDbParameter("@name", OleDbType.VarChar, 50),
new OleDbParameter("@title", OleDbType.VarChar, 100),
new OleDbParameter("@is_albums", OleDbType.Integer, 4),
new OleDbParameter("@is_attach", OleDbType.Integer, 4),
new OleDbParameter("@is_spec", OleDbType.Integer, 4),
new OleDbParameter("@sort_id", OleDbType.Integer, 4),
new OleDbParameter("@id", OleDbType.Integer, 4)
};
oleDbParameterArray1[0].Value = (object)model.site_id;
oleDbParameterArray1[1].Value = (object)model.name;
oleDbParameterArray1[2].Value = (object)model.title;
oleDbParameterArray1[3].Value = (object)model.is_albums;
oleDbParameterArray1[4].Value = (object)model.is_attach;
oleDbParameterArray1[5].Value = (object)model.is_spec;
oleDbParameterArray1[6].Value = (object)model.sort_id;
oleDbParameterArray1[7].Value = (object)model.id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder1.ToString(), oleDbParameterArray1);
this.FieldDelete(oleDbConnection, trans, model.channel_fields, model.id);
if (model.channel_fields != null)
{
using (List <channel_field> .Enumerator enumerator = model.channel_fields.GetEnumerator())
{
while (enumerator.MoveNext())
{
channel_field modelt = enumerator.Current;
StringBuilder stringBuilder2 = new StringBuilder();
channel_field channelField = (channel_field)null;
if (model1.channel_fields != null)
{
channelField = model1.channel_fields.Find((Predicate <channel_field>)(p => p.field_id == modelt.field_id));
}
if (channelField == null)
{
stringBuilder2.Append("insert into " + this.databaseprefix + "channel_field(");
stringBuilder2.Append("channel_id,field_id)");
stringBuilder2.Append(" values (");
stringBuilder2.Append("@channel_id,@field_id)");
OleDbParameter[] oleDbParameterArray2 = new OleDbParameter[2]
{
new OleDbParameter("@channel_id", OleDbType.Integer, 4),
new OleDbParameter("@field_id", OleDbType.Integer, 4)
};
oleDbParameterArray2[0].Value = (object)modelt.channel_id;
oleDbParameterArray2[1].Value = (object)modelt.field_id;
DbHelperOleDb.ExecuteSql(oleDbConnection, trans, stringBuilder2.ToString(), oleDbParameterArray2);
}
}
}
}
this.RehabChannelViews(oleDbConnection, trans, model, model1.name);
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name, siteNavId, "channel_" + model.name, model.title, model.sort_id);
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name + "_list", "channel_" + model.name + "_list");
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name + "_category", "channel_" + model.name + "_category");
new navigation(this.databaseprefix).Update(oleDbConnection, trans, "channel_" + model1.name + "_comment", "channel_" + model.name + "_comment");
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
