asp.net+javascript+css(模仿google的拖拽的个性网页布局)(操作数据库篇)

最新推荐文章于 2012-07-27 14:39:53 发布

转载最新推荐文章于 2012-07-27 14:39:53 发布 · 980 阅读

文章标签：

#javascript #asp.net #数据库 #google #css #string

本文介绍了一种使用两个表格实现个性化网页布局的方法，并提供了详细的代码示例。包括Side.cs用于定义布局，WinInfo.cs用于窗口信息，SideSql.cs用于保存布局到数据库，WinInfoSql.cs用于获取窗口信息。

个性网页布局的用到了2张表.具体的操作表的代码如下:(有4个文件)
Side.cs
public class Side
{
  int _SideID;
  string _SideLeft;
  string _SideCenter;
  string _SideRight;

  public Side()
  {
  }

  public int SideID
  {
   get{return this._SideID;}
   set{this._SideID=value;}
  }

  public string SideLeft
  {
   get{return this._SideLeft;}
   set{this._SideLeft=value;}
  }

  public string SideCenter
  {
   get{return this._SideCenter;}
   set{this._SideCenter=value;}
  }

  public string SideRight
  {
   get{return this._SideRight;}
   set{this._SideRight=value;}
  }

}
}
WinInfo.cs

public class WinInfo
{
  int _WinID;
  string _WinName;
  int _WinFlag;
  public WinInfo()
  {
  }
  public int WinID
  {
   get{return this._WinID;}
   set{this._WinID=value;}
  }

  public string WinName
  {
   get{return this._WinName;}
   set{this._WinName=value;}
  }

  public int WinFlag
  {
      get{return this._WinFlag;}
         set{this._WinFlag=value;}
        }

}

SideSql.cs
public class SideSql
{
public string conn=ConfigurationSettings.AppSettings["connstr"];

  public SideSql()
  {
  }
  /// <summary>
  /// 保存窗口的布局到数据库
  /// </summary>
  /// <param name="sideLeft">左侧布局容器的窗口的ID字符串,中间用逗号隔开</param>
  /// <param name="sideCenter">中间布局容器的窗口的ID字符串,中间用逗号隔开</param>
  /// <param name="sideRigth">右侧布局容器的窗口的ID字符串,中间用逗号隔开</param>
  /// <param name="sideID"></param>
  public void SaveSide(string sideLeft,string sideCenter,string sideRigth,int sideID)
  {
   using(SqlConnection con = new SqlConnection(conn))
   {
    con.Open();
    using(SqlTransaction trans=con.BeginTransaction())
    {
     try
     {
      SqlHelper.ExecuteNonQuery(trans,System.Data.CommandType.Text,"update Side set SideLeft='"+sideLeft+"',SideCenter='"+sideCenter+"',SideRight='"+sideRigth+"' where SideID="+sideID);
      trans.Commit();
     }
     catch
     {
      trans.Rollback();
     }
    }
   }

}

  public Side InitSide(int sideID)//初始化窗口用的
  {

    using(SqlDataReader dr=SqlHelper.ExecuteReader(conn,System.Data.CommandType.Text,"select * from side where SideID=1"))
    {
     if(dr.Read())
      {
          Side TempSide=new Side();
       TempSide.SideLeft=dr["SideLeft"].ToString();
       TempSide.SideCenter=dr["SideCenter"].ToString();
       TempSide.SideRight=dr["SideRight"].ToString();
       return TempSide;
      }
      else
      {
       return null;
      }
    }

}

WinInfoSql.cs

public class WinInfoSql
{
  public static string conn=ConfigurationSettings.AppSettings["connstr"];
        WinInfo TempWinInfo=new WinInfo();
  public WinInfoSql()
  {
  }

  public WinInfo GetWinInfo(int winID)//获取窗口信息
  {
   using(SqlDataReader dr=SqlHelper.ExecuteReader(conn,System.Data.CommandType.Text,"select * from WinInfo where WinFlag=1 and WinID="+winID))
   {
    if(dr.Read())
    {
     TempWinInfo.WinName=dr["WinName"].ToString();
     TempWinInfo.WinID=Convert.ToInt32(dr["WinID"]);
     return TempWinInfo;
    }
    else
    {
     return null;
    }
   }
  }
}