CSWDAL/DALServerclass.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using DBUtility;
using CSWModel;
namespace CSWDAL
{
   public class DALServerclass
    {
       public static bool EditServerClass(string ServerID,ModelServerclass ServerClass)
       {
           StringBuilder strsql = new StringBuilder();
           strsql.Append("update csw_serverclass set serverName='"+ServerClass.serverName+"',");
           strsql.Append("keywords='" + ServerClass.keywords + "',description='"+ServerClass.description+"'");
           strsql.Append("where serverid="+ServerID);
           int reValue = new AcsHelper().ExecuteNonQuery(strsql.ToString());
           if (reValue > 0)
           {
               return true;
           }
           else
           {
               return false;
           }
       }

       public static List<ModelServerclass> LoadServerClass(string serverID)
       {
           ModelServerclass serverclass = new ModelServerclass();
           List<ModelServerclass> lt = new List<ModelServerclass>();
           string strsql = "select * from csw_serverclass where serverid="+serverID;
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql);
           if (ds.Tables[0].Rows.Count > 0)
           {
               serverclass.serverName = ds.Tables[0].Rows[0][1].ToString();
               serverclass.keywords = ds.Tables[0].Rows[0][2].ToString();
               serverclass.description =ds.Tables[0].Rows[0][3].ToString();
           }
           lt.Add(serverclass);
           return lt;
       }

       public static void BindRpClass(System.Web.UI.WebControls.Repeater rp)
       {
           string strsql = "select * from csw_serverclass";
           DataSet ds = new AcsHelper().ExecuteDataSet(strsql);
           rp.DataSource = ds.Tables[0];
           rp.DataBind();
       }

    }
}