Example #1
0
 /// <summary>
 /// 添加一条数据
 /// </summary>
 /// <param name="link"></param>
 /// <returns></returns>
 public bool Add(LinkInfo link)
 {
     StringBuilder sql = new StringBuilder();
     sql.Append("inser into BigDog_Link (Link_Name,Description,Link_Url)");
     sql.Append("values(@Link_Name,@Description,@Link_Url)");
     SqlParameter[] parms = new SqlParameter[]{
         new SqlParameter("@Link_Name",SqlDbType.NVarChar,50),
         new SqlParameter("@Description",SqlDbType.Int),
         new SqlParameter("@Link_Url",SqlDbType.NVarChar,200)
     };
     parms[0].Value = link.Link_Name;
     parms[1].Value = link.Description;
     parms[2].Value = link.Link_Url;
     return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
 }
Example #2
0
 /// <summary>
 /// 根据Id获取实体
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 public LinkInfo GetById(int id)
 {
     StringBuilder sql = new StringBuilder();
     sql.Append("select Id,Link_Name,Description,Link_Url from BigDog_Link where Id=@Id");
     SqlParameter[] parms = new SqlParameter[] {
         new SqlParameter("@Id",SqlDbType.Int)
     };
     parms[0].Value = id;
     LinkInfo link = new LinkInfo();
     DataTable dt = SQLHelper.GetDs(sql.ToString(),parms).Tables[0];
     if (dt.Rows.Count > 0)
     {
         link.Id = Convert.ToInt32(dt.Rows[0]["Id"]);
         link.Link_Name = dt.Rows[0]["Link_Name"].ToString();
         link.Link_Url = dt.Rows[0]["Link_Url"].ToString();
         return link;
     }
     return null;
 }
Example #3
0
 public static bool Update(LinkInfo link)
 {
     return Dal.Update(link);
 }
Example #4
0
 public static bool Add(LinkInfo link)
 {
     return Dal.Add(link);
 }
Example #5
0
 /// <summary>
 /// 更新一条数据
 /// </summary>
 /// <param name="link"></param>
 /// <returns></returns>
 public bool Update(LinkInfo link)
 {
     StringBuilder sql = new StringBuilder();
     sql.Append("update BigDog_Shop set Link_Name=@Link_Name,Description=@Description,Link_Url=@Link_Url where Id=@Id");
     SqlParameter[] parms = new SqlParameter[] {
         new SqlParameter("@Link_Name",SqlDbType.NVarChar,50),
         new SqlParameter("@Description",SqlDbType.NVarChar,100),
         new SqlParameter("@Link_Url",SqlDbType.NVarChar,200),
         new SqlParameter("@Id",SqlDbType.Int)
     };
     parms[0].Value = link.Link_Name;
     parms[1].Value = link.Description;
     parms[2].Value = link.Link_Url;
     parms[3].Value = link.Id;
     return SQLHelper.ExecuteNonQuery(CommandType.Text, sql.ToString(), parms) > 0;
 }