/// <summary>
/// 编辑栏目
/// </summary>
/// <param name="columninfo"></param>
public static void EditColumn(ColumnInfo columninfo)
{
DatabaseProvider.GetInstance().EditColumn(columninfo);
}
/// <summary>
/// 新建栏目
/// </summary>
/// <param name="columninfo"></param>
public static void CreateColumn(ColumnInfo columninfo)
{
DatabaseProvider.GetInstance().CreateColumn(columninfo);
}
public void EditColumn(ColumnInfo columninfo)
{
DbParameter[] prams =
{
DbHelper.MakeInParam("@columnname", DbType.String, 100,columninfo.Columnname),
DbHelper.MakeInParam("@columnid", DbType.Int32, 4,columninfo.Columnid),
DbHelper.MakeInParam("@parentid", DbType.Int32, 4,columninfo.Parentid)
};
DbHelper.ExecuteNonQuery(CommandType.Text, "UPDATE wy_columns SET columnname=@columnname,parentid=@parentid WHERE columnid=@columnid", prams);
}
/// <summary>
/// 将DataReader的Column转换为ColumnInfo泛型列表
/// </summary>
/// <param name="reader"></param>
/// <returns></returns>
private static ColumnInfo DataReader2ColumnInfo(IDataReader reader)
{
ColumnInfo columninfo = new ColumnInfo();
columninfo.Columnid = Convert.ToInt32(reader["columnid"]);
columninfo.Columnname= reader["columnname"].ToString();
columninfo.Parentid = Convert.ToInt32(reader["parentid"]);
return columninfo;
}
public void CreateColumn(ColumnInfo columninfo)
{
DbParameter[] prams =
{
//DbHelper.MakeInParam("@columnid", DbType.Int32, 4,columninfo.Columnid),
DbHelper.MakeInParam("@columnname", DbType.String, 50,columninfo.Columnname),
DbHelper.MakeInParam("@parentid", DbType.Int32, 4,columninfo.Parentid)
};
DbHelper.ExecuteNonQuery(CommandType.Text, "INSERT INTO wy_columns(columnname,parentid) VALUES(@columnname,@columnname)", prams);
}