public channel()
{
dal = new DAL.channel(siteConfig.sysdatabaseprefix);
}
private readonly Model.siteconfig siteConfig = new BLL.siteconfig().loadConfig(); //���վ��������Ϣ
#endregion Fields
#region Constructors
public channel()
{
dal = new DAL.channel(siteConfig.sysdatabaseprefix);
}
/// <summary>
/// ɾ��һ������
/// </summary>
public bool Delete(int id)
{
//ȡ��Model��Ϣ
Model.article_attribute_field model = GetModel(id);
//��ʼɾ��
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
//���ҹ�����Ƶ��ID���õ����Ա�ʹ��
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select channel_id,field_id from " + databaseprefix + "channel_field ");
strSql1.Append(" where field_id=@field_id");
SqlParameter[] parameters1 = {
new SqlParameter("@field_id", SqlDbType.Int,4)};
parameters1[0].Value = id;
DataTable dt = DbHelperSQL.Query(conn, trans, strSql1.ToString(), parameters1).Tables[0];
//ɾ��Ƶ���������ֶα�
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "channel_field");
strSql2.Append(" where field_id=@field_id");
SqlParameter[] parameters2 = {
new SqlParameter("@field_id", SqlDbType.Int,4)};
parameters2[0].Value = id;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//�ؽ���ӦƵ������ͼ
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Model.channel modelt = new DAL.channel(databaseprefix).GetModel(conn, trans, int.Parse(dr["channel_id"].ToString()));
if (modelt != null)
{
new DAL.channel(databaseprefix).RehabChannelViews(conn, trans, modelt, modelt.name);
}
}
}
//ɾ������
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "article_attribute_field ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//ɾ����չ�ֶα���һ��
DbHelperSQL.ExecuteSql(conn, trans, "alter table " + databaseprefix + "article_attribute_value drop column " + model.name);
//û�д���ȷ������
trans.Commit();
}
catch
{
trans.Rollback();
return false;
}
}
}
return true;
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
//取得Model信息
Model.article_attribute_field model = GetModel(id);
//开始删除
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
//查找关联的频道ID，得到后以备使用
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select channel_id,field_id from " + databaseprefix + "channel_field ");
strSql1.Append(" where field_id=@field_id");
SqlParameter[] parameters1 =
{
new SqlParameter("@field_id", SqlDbType.Int, 4)
};
parameters1[0].Value = id;
DataTable dt = DbHelperSQL.Query(conn, trans, strSql1.ToString(), parameters1).Tables[0];
//删除频道关联的字段表
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "channel_field");
strSql2.Append(" where field_id=@field_id");
SqlParameter[] parameters2 =
{
new SqlParameter("@field_id", SqlDbType.Int, 4)
};
parameters2[0].Value = id;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//重建对应频道的视图
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Model.channel modelt = new DAL.channel(databaseprefix).GetModel(conn, trans, int.Parse(dr["channel_id"].ToString()));
if (modelt != null)
{
new DAL.channel(databaseprefix).RehabChannelViews(conn, trans, modelt, modelt.name);
}
}
}
//删除主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "article_attribute_field ");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//删除扩展字段表中一列
DbHelperSQL.ExecuteSql(conn, trans, "alter table " + databaseprefix + "article_attribute_value drop column " + model.name);
//没有错误确认事务
trans.Commit();
}
catch
{
trans.Rollback();
return(false);
}
}
}
return(true);
}
/// <summary>
/// 删除一条数据
/// </summary>
public bool Delete(int id)
{
//取得Model信息
Model.article_attribute_field model = GetModel(id);
//开始删除
using (SqlConnection conn = new SqlConnection(DbHelperSQL.connectionString))
{
conn.Open();
using (SqlTransaction trans = conn.BeginTransaction())
{
try
{
//查找关联的频道ID，得到后以备使用
StringBuilder strSql1 = new StringBuilder();
strSql1.Append("select channel_id,field_id from " + databaseprefix + "channel_field ");
strSql1.Append(" where field_id=@field_id");
SqlParameter[] parameters1 = {
new SqlParameter("@field_id", SqlDbType.Int,4)};
parameters1[0].Value = id;
DataTable dt = DbHelperSQL.Query(conn, trans, strSql1.ToString(), parameters1).Tables[0];
//删除频道关联的字段表
StringBuilder strSql2 = new StringBuilder();
strSql2.Append("delete from " + databaseprefix + "channel_field");
strSql2.Append(" where field_id=@field_id");
SqlParameter[] parameters2 = {
new SqlParameter("@field_id", SqlDbType.Int,4)};
parameters2[0].Value = id;
DbHelperSQL.ExecuteSql(conn, trans, strSql2.ToString(), parameters2);
//重建对应频道的视图
if (dt.Rows.Count > 0)
{
foreach (DataRow dr in dt.Rows)
{
Model.channel modelt = new DAL.channel(databaseprefix).GetModel(conn, trans, int.Parse(dr["channel_id"].ToString()));
if (modelt != null)
{
new DAL.channel(databaseprefix).RehabChannelViews(conn, trans, modelt, modelt.name);
}
}
}
//删除主表
StringBuilder strSql = new StringBuilder();
strSql.Append("delete from " + databaseprefix + "article_attribute_field ");
strSql.Append(" where id=@id");
SqlParameter[] parameters = {
new SqlParameter("@id", SqlDbType.Int,4)};
parameters[0].Value = id;
DbHelperSQL.ExecuteSql(conn, trans, strSql.ToString(), parameters);
//删除扩展字段表中一列
DbHelperSQL.ExecuteSql(conn, trans, "alter table " + databaseprefix + "article_attribute_value drop column " + model.name);
//没有错误确认事务
trans.Commit();
}
catch
{
trans.Rollback();
return false;
}
}
}
return true;
}
