예제 #1
0
 /// <summary>
 /// 插入t_Screen_Library
 /// </summary>
 public virtual bool Insert(t_ScreenLibrary screenLibrary)
 {
     string sql = "insert into t_Screen_Library (ScreenID, ScreenName, ImageURL, ParentScreenID, StationID) values (@ScreenID, @ScreenName, @ImageURL, @ParentScreenID, @StationID)";
     SqlParameter [] parameters = new SqlParameter[]
     {
         new SqlParameter("@ScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ScreenID", DataRowVersion.Default, screenLibrary.Screenid),
         new SqlParameter("@ScreenName", SqlDbType.VarChar, 64, ParameterDirection.Input, false, 0, 0, "ScreenName", DataRowVersion.Default, screenLibrary.Screenname),
         new SqlParameter("@ImageURL", SqlDbType.VarChar, 256, ParameterDirection.Input, false, 0, 0, "ImageURL", DataRowVersion.Default, screenLibrary.Imageurl),
         new SqlParameter("@ParentScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ParentScreenID", DataRowVersion.Default, screenLibrary.Parentscreenid),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, screenLibrary.Stationid)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }
예제 #2
0
        public ObservableCollection<t_ScreenLibrary> selectAllDate()
        {
            string sql = "select * from t_Screen_Library";

            DataTable dt = null;
            try
            {
                dt = db.ExecuteQuery(sql);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            ObservableCollection<t_ScreenLibrary> _List = new ObservableCollection<t_ScreenLibrary>();
            foreach (DataRow dr in dt.Rows)
            {
                t_ScreenLibrary obj = new t_ScreenLibrary(dr);
                _List.Add(obj);
            }
            return _List;
        }
예제 #3
0
 public void Clone(t_ScreenLibrary obj)
 {
     //
     Screenid = obj.Screenid;
     //
     Screenname = obj.Screenname;
     //
     Imageurl = obj.Imageurl;
     //
     Parentscreenid = obj.Parentscreenid;
     //
     Stationid = obj.Stationid;
 }
예제 #4
0
 public t_ScreenLibrary selectARowDate(string m_id)
 {
     string sql = string.Format("select * from t_Screen_Library where  Screenid='{0}'",m_id);
       DataTable dt = null;
     try
      {
      dt = db.ExecuteQueryDataSet(sql).Tables[0];
     }
       catch (Exception ex)
     {
      throw ex;
       }
     if (dt == null)
      return null;
     if (dt.Rows.Count == 0)
     return null;
     DataRow dr = dt.Rows[0];
     t_ScreenLibrary m_Scre=new t_ScreenLibrary(dr);
      return m_Scre;
 }
예제 #5
0
 /// <summary>
 /// 更新t_Screen_Library
 /// </summary>
 public virtual bool Update(t_ScreenLibrary screenLibrary)
 {
     string sql = "update t_Screen_Library set  ScreenName = @ScreenName,  ImageURL = @ImageURL,  ParentScreenID = @ParentScreenID,  StationID = @StationID where  ScreenID = @ScreenID";
     SqlParameter [] parameters = new SqlParameter[]
     {
         new SqlParameter("@ScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ScreenID", DataRowVersion.Default, screenLibrary.Screenid),
         new SqlParameter("@ScreenName", SqlDbType.VarChar, 64, ParameterDirection.Input, false, 0, 0, "ScreenName", DataRowVersion.Default, screenLibrary.Screenname),
         new SqlParameter("@ImageURL", SqlDbType.VarChar, 256, ParameterDirection.Input, false, 0, 0, "ImageURL", DataRowVersion.Default, screenLibrary.Imageurl),
         new SqlParameter("@ParentScreenID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "ParentScreenID", DataRowVersion.Default, screenLibrary.Parentscreenid),
         new SqlParameter("@StationID", SqlDbType.Int, 4, ParameterDirection.Input, false, 0, 0, "StationID", DataRowVersion.Default, screenLibrary.Stationid)
     };
     return db.ExecuteNoQuery(sql, parameters) > -1;
 }