public bool AddApiServerInfo(ApiServerInfoEntity apiServerInfoEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("@SiteName");
sqlCommandText.Append(", @SiteUrl");
sqlCommandText.Append(", @Status");
sqlCommandText.Append(", @Note");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.ApiServerInfo ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@SiteName", DbType.AnsiString, apiServerInfoEntity.SiteName);
db.AddInParameter(cmd, "@SiteUrl", DbType.AnsiString, apiServerInfoEntity.SiteUrl);
db.AddInParameter(cmd, "@Status", DbType.Byte, apiServerInfoEntity.Status);
db.AddInParameter(cmd, "@Note", DbType.AnsiString, apiServerInfoEntity.Note);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public bool UpdateApiServerInfo(ApiServerInfoEntity apiServerInfoEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" ApiServerID=@ApiServerID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" SiteName=@SiteName");
sqlCommandText.Append(", SiteUrl=@SiteUrl");
sqlCommandText.Append(", Status=@Status");
sqlCommandText.Append(", Note=@Note");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.ApiServerInfo SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@ApiServerID", DbType.Int32, apiServerInfoEntity.ApiServerID);
db.AddInParameter(cmd, "@SiteName", DbType.AnsiString, apiServerInfoEntity.SiteName);
db.AddInParameter(cmd, "@SiteUrl", DbType.AnsiString, apiServerInfoEntity.SiteUrl);
db.AddInParameter(cmd, "@Status", DbType.Byte, apiServerInfoEntity.Status);
db.AddInParameter(cmd, "@Note", DbType.AnsiString, apiServerInfoEntity.Note);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public List <ApiServerInfoEntity> MakeApiServerInfoList(DataTable dt)
{
List <ApiServerInfoEntity> list = new List <ApiServerInfoEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
ApiServerInfoEntity apiServerInfoEntity = MakeApiServerInfo(dt.Rows[i]);
list.Add(apiServerInfoEntity);
}
}
return(list);
}
public ApiServerInfoEntity MakeApiServerInfo(DataRow dr)
{
ApiServerInfoEntity apiServerInfoEntity = null;
if (dr != null)
{
apiServerInfoEntity = new ApiServerInfoEntity();
apiServerInfoEntity.ApiServerID = (Int32)dr["ApiServerID"];
apiServerInfoEntity.SiteName = (String)dr["SiteName"];
apiServerInfoEntity.SiteUrl = (String)dr["SiteUrl"];
apiServerInfoEntity.Status = (Byte)dr["Status"];
apiServerInfoEntity.Note = (String)dr["Note"];
apiServerInfoEntity.AddDate = (DateTime)dr["AddDate"];
}
return(apiServerInfoEntity);
}
public ApiServerInfoEntity GetApiServerInfo(Int32 apiServerID)
{
ApiServerInfoEntity apiServerInfoEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 ApiServerID,SiteName,SiteUrl,Status,Note,AddDate FROM dbo.ApiServerInfo WITH(NOLOCK)");
sqlCommandText.Append(" WHERE ApiServerID=@ApiServerID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@ApiServerID", DbType.Int32, apiServerID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
apiServerInfoEntity = MakeApiServerInfo(dr);
}
return(apiServerInfoEntity);
}
public List <ApiServerInfoEntity> MakeApiServerInfoList(IDataReader dr)
{
List <ApiServerInfoEntity> list = new List <ApiServerInfoEntity>();
while (dr.Read())
{
ApiServerInfoEntity apiServerInfoEntity = new ApiServerInfoEntity();
apiServerInfoEntity.ApiServerID = (Int32)dr["ApiServerID"];
apiServerInfoEntity.SiteName = (String)dr["SiteName"];
apiServerInfoEntity.SiteUrl = (String)dr["SiteUrl"];
apiServerInfoEntity.Status = (Byte)dr["Status"];
apiServerInfoEntity.Note = (String)dr["Note"];
apiServerInfoEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(apiServerInfoEntity);
}
dr.Close();
return(list);
}
public bool DeleteApiServerInfo(ApiServerInfoEntity apiServerInfoEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("DELETE FROM dbo.ApiServerInfo");
sqlCommandText.Append(" WHERE ApiServerID=@ApiServerID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@ApiServerID", DbType.Int32, apiServerInfoEntity.ApiServerID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="apiServerInfo">ApiServerInfoEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddApiServerInfo(ApiServerInfoEntity apiServerInfo)
{
return(ApiServerInfoDataAccess.Instance.AddApiServerInfo(apiServerInfo));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="apiServerInfo">ApiServerInfoEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteApiServerInfo(ApiServerInfoEntity apiServerInfo)
{
return(ApiServerInfoDataAccess.Instance.DeleteApiServerInfo(apiServerInfo));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="apiServerInfo">ApiServerInfoEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteApiServerInfo(ApiServerInfoEntity apiServerInfo)
{
return(ApiServerInfoBusProvider.DeleteApiServerInfo(apiServerInfo));
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="apiServerInfo">ApiServerInfoEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateApiServerInfo(ApiServerInfoEntity apiServerInfo)
{
return(ApiServerInfoBusProvider.UpdateApiServerInfo(apiServerInfo));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="apiServerInfo">ApiServerInfoEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddApiServerInfo(ApiServerInfoEntity apiServerInfo)
{
return(ApiServerInfoBusProvider.AddApiServerInfo(apiServerInfo));
}
