public bool UpdateJournalSetInfo(JournalSetInfoEntity journalSetInfoEntity) { bool flag = false; StringBuilder whereCommandText = new StringBuilder(); whereCommandText.Append(" SetID=@SetID"); StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" JournalID=@JournalID"); sqlCommandText.Append(", ApiSiteID=@ApiSiteID"); sqlCommandText.Append(", DBServerID=@DBServerID"); sqlCommandText.Append(", AddDate=@AddDate"); DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.JournalSetInfo SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString())); db.AddInParameter(cmd, "@SetID", DbType.Int32, journalSetInfoEntity.SetID); db.AddInParameter(cmd, "@JournalID", DbType.Int64, journalSetInfoEntity.JournalID); db.AddInParameter(cmd, "@ApiSiteID", DbType.Int32, journalSetInfoEntity.ApiSiteID); db.AddInParameter(cmd, "@DBServerID", DbType.Int32, journalSetInfoEntity.DBServerID); db.AddInParameter(cmd, "@AddDate", DbType.DateTime, journalSetInfoEntity.AddDate); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public bool AddJournalSetInfo(JournalSetInfoEntity journalSetInfoEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append(" @SetID"); sqlCommandText.Append(", @JournalID"); sqlCommandText.Append(", @ApiSiteID"); sqlCommandText.Append(", @DBServerID"); sqlCommandText.Append(", @AddDate"); DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.JournalSetInfo ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString())); db.AddInParameter(cmd, "@SetID", DbType.Int32, journalSetInfoEntity.SetID); db.AddInParameter(cmd, "@JournalID", DbType.Int64, journalSetInfoEntity.JournalID); db.AddInParameter(cmd, "@ApiSiteID", DbType.Int32, journalSetInfoEntity.ApiSiteID); db.AddInParameter(cmd, "@DBServerID", DbType.Int32, journalSetInfoEntity.DBServerID); db.AddInParameter(cmd, "@AddDate", DbType.DateTime, journalSetInfoEntity.AddDate); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
public List <JournalSetInfoEntity> MakeJournalSetInfoList(DataTable dt) { List <JournalSetInfoEntity> list = new List <JournalSetInfoEntity>(); if (dt != null) { for (int i = 0; i < dt.Rows.Count; i++) { JournalSetInfoEntity journalSetInfoEntity = MakeJournalSetInfo(dt.Rows[i]); list.Add(journalSetInfoEntity); } } return(list); }
public JournalSetInfoEntity MakeJournalSetInfo(DataRow dr) { JournalSetInfoEntity journalSetInfoEntity = null; if (dr != null) { journalSetInfoEntity = new JournalSetInfoEntity(); journalSetInfoEntity.SetID = (Int32)dr["SetID"]; journalSetInfoEntity.JournalID = (Int64)dr["JournalID"]; journalSetInfoEntity.ApiSiteID = (Int32)dr["ApiSiteID"]; journalSetInfoEntity.DBServerID = (Int32)dr["DBServerID"]; journalSetInfoEntity.AddDate = (DateTime)dr["AddDate"]; } return(journalSetInfoEntity); }
public JournalSetInfoEntity MakeJournalSetInfo(IDataReader dr) { JournalSetInfoEntity journalSetInfoEntity = null; if (dr.Read()) { journalSetInfoEntity = new JournalSetInfoEntity(); journalSetInfoEntity.SetID = (Int32)dr["SetID"]; journalSetInfoEntity.JournalID = (Int64)dr["JournalID"]; journalSetInfoEntity.ApiSiteID = (Int32)dr["ApiSiteID"]; journalSetInfoEntity.DBServerID = (Int32)dr["DBServerID"]; journalSetInfoEntity.AddDate = (DateTime)dr["AddDate"]; } dr.Close(); return(journalSetInfoEntity); }
public List <JournalSetInfoEntity> MakeJournalSetInfoList(IDataReader dr) { List <JournalSetInfoEntity> list = new List <JournalSetInfoEntity>(); while (dr.Read()) { JournalSetInfoEntity journalSetInfoEntity = new JournalSetInfoEntity(); journalSetInfoEntity.SetID = (Int32)dr["SetID"]; journalSetInfoEntity.JournalID = (Int64)dr["JournalID"]; journalSetInfoEntity.ApiSiteID = (Int32)dr["ApiSiteID"]; journalSetInfoEntity.DBServerID = (Int32)dr["DBServerID"]; journalSetInfoEntity.AddDate = (DateTime)dr["AddDate"]; list.Add(journalSetInfoEntity); } dr.Close(); return(list); }
public JournalSetInfoEntity GetJournalSetInfo(Int32 setID) { JournalSetInfoEntity journalSetInfoEntity = null; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("SELECT TOP 1 SetID,JournalID,ApiSiteID,DBServerID,AddDate FROM dbo.JournalSetInfo WITH(NOLOCK)"); sqlCommandText.Append(" WHERE SetID=@SetID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@SetID", DbType.Int32, setID); using (IDataReader dr = db.ExecuteReader(cmd)) { journalSetInfoEntity = MakeJournalSetInfo(dr); } return(journalSetInfoEntity); }
public bool DeleteJournalSetInfo(JournalSetInfoEntity journalSetInfoEntity) { bool flag = false; StringBuilder sqlCommandText = new StringBuilder(); sqlCommandText.Append("DELETE FROM dbo.JournalSetInfo"); sqlCommandText.Append(" WHERE SetID=@SetID"); DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString()); db.AddInParameter(cmd, "@SetID", DbType.Int32, journalSetInfoEntity.SetID); try { db.ExecuteNonQuery(cmd); flag = true; } catch (SqlException sqlEx) { throw sqlEx; } return(flag); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="journalSetInfo">JournalSetInfoEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddJournalSetInfo(JournalSetInfoEntity journalSetInfo) { return(JournalSetInfoDataAccess.Instance.AddJournalSetInfo(journalSetInfo)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="journalSetInfo">JournalSetInfoEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteJournalSetInfo(JournalSetInfoEntity journalSetInfo) { return(JournalSetInfoDataAccess.Instance.DeleteJournalSetInfo(journalSetInfo)); }
/// <summary> /// 从存储媒介删除实体数据 /// </summary> /// <param name="journalSetInfo">JournalSetInfoEntity实体对象</param> /// <returns>true:删除成功 false:删除失败</returns> public bool DeleteJournalSetInfo(JournalSetInfoEntity journalSetInfo) { return(JournalSetInfoBusProvider.DeleteJournalSetInfo(journalSetInfo)); }
/// <summary> /// 更新存储媒介中的实体数据 /// </summary> /// <param name="journalSetInfo">JournalSetInfoEntity实体对象</param> /// <returns>true:更新成功 false:更新失败</returns> public bool UpdateJournalSetInfo(JournalSetInfoEntity journalSetInfo) { return(JournalSetInfoBusProvider.UpdateJournalSetInfo(journalSetInfo)); }
/// <summary> /// 将实体数据存入存储媒介(持久化一个对象) /// </summary> /// <param name="journalSetInfo">JournalSetInfoEntity实体对象</param> /// <returns>true:存储成功 false:存储失败</returns> public bool AddJournalSetInfo(JournalSetInfoEntity journalSetInfo) { return(JournalSetInfoBusProvider.AddJournalSetInfo(journalSetInfo)); }