public bool AddDBServerInfo(DBServerInfoEntity dBServerInfoEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("@ServerIP");
sqlCommandText.Append(", @Port");
sqlCommandText.Append(", @Account");
sqlCommandText.Append(", @Pwd");
sqlCommandText.Append(", @Note");
sqlCommandText.Append(", @Status");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.DBServerInfo ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@ServerIP", DbType.AnsiString, dBServerInfoEntity.ServerIP);
db.AddInParameter(cmd, "@Port", DbType.Int32, dBServerInfoEntity.Port);
db.AddInParameter(cmd, "@Account", DbType.AnsiString, dBServerInfoEntity.Account);
db.AddInParameter(cmd, "@Pwd", DbType.AnsiString, dBServerInfoEntity.Pwd);
db.AddInParameter(cmd, "@Note", DbType.AnsiString, dBServerInfoEntity.Note);
db.AddInParameter(cmd, "@Status", DbType.Byte, dBServerInfoEntity.Status);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public List <DBServerInfoEntity> MakeDBServerInfoList(DataTable dt)
{
List <DBServerInfoEntity> list = new List <DBServerInfoEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
DBServerInfoEntity dBServerInfoEntity = MakeDBServerInfo(dt.Rows[i]);
list.Add(dBServerInfoEntity);
}
}
return(list);
}
public DBServerInfoEntity GetDBServerInfo(Int32 dBServerID)
{
DBServerInfoEntity dBServerInfoEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 DBServerID,ServerIP,Port,Account,Pwd,Note,Status,AddDate FROM dbo.DBServerInfo WITH(NOLOCK)");
sqlCommandText.Append(" WHERE DBServerID=@DBServerID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@DBServerID", DbType.Int32, dBServerID);
using (IDataReader dr = db.ExecuteReader(cmd))
{
dBServerInfoEntity = MakeDBServerInfo(dr);
}
return(dBServerInfoEntity);
}
public DBServerInfoEntity MakeDBServerInfo(DataRow dr)
{
DBServerInfoEntity dBServerInfoEntity = null;
if (dr != null)
{
dBServerInfoEntity = new DBServerInfoEntity();
dBServerInfoEntity.DBServerID = (Int32)dr["DBServerID"];
dBServerInfoEntity.ServerIP = (String)dr["ServerIP"];
dBServerInfoEntity.Port = (Int32)dr["Port"];
dBServerInfoEntity.Account = (String)dr["Account"];
dBServerInfoEntity.Pwd = (String)dr["Pwd"];
dBServerInfoEntity.Note = (String)dr["Note"];
dBServerInfoEntity.Status = (Byte)dr["Status"];
dBServerInfoEntity.AddDate = (DateTime)dr["AddDate"];
}
return(dBServerInfoEntity);
}
public List <DBServerInfoEntity> MakeDBServerInfoList(IDataReader dr)
{
List <DBServerInfoEntity> list = new List <DBServerInfoEntity>();
while (dr.Read())
{
DBServerInfoEntity dBServerInfoEntity = new DBServerInfoEntity();
dBServerInfoEntity.DBServerID = (Int32)dr["DBServerID"];
dBServerInfoEntity.ServerIP = (String)dr["ServerIP"];
dBServerInfoEntity.Port = (Int32)dr["Port"];
dBServerInfoEntity.Account = (String)dr["Account"];
dBServerInfoEntity.Pwd = (String)dr["Pwd"];
dBServerInfoEntity.Note = (String)dr["Note"];
dBServerInfoEntity.Status = (Byte)dr["Status"];
dBServerInfoEntity.AddDate = (DateTime)dr["AddDate"];
list.Add(dBServerInfoEntity);
}
dr.Close();
return(list);
}
public bool UpdateDBServerInfo(DBServerInfoEntity dBServerInfoEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" DBServerID=@DBServerID");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" ServerIP=@ServerIP");
sqlCommandText.Append(", Port=@Port");
sqlCommandText.Append(", Account=@Account");
sqlCommandText.Append(", Pwd=@Pwd");
sqlCommandText.Append(", Note=@Note");
sqlCommandText.Append(", Status=@Status");
sqlCommandText.Append(", AddDate=@AddDate");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.DBServerInfo SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@DBServerID", DbType.Int32, dBServerInfoEntity.DBServerID);
db.AddInParameter(cmd, "@ServerIP", DbType.AnsiString, dBServerInfoEntity.ServerIP);
db.AddInParameter(cmd, "@Port", DbType.Int32, dBServerInfoEntity.Port);
db.AddInParameter(cmd, "@Account", DbType.AnsiString, dBServerInfoEntity.Account);
db.AddInParameter(cmd, "@Pwd", DbType.AnsiString, dBServerInfoEntity.Pwd);
db.AddInParameter(cmd, "@Note", DbType.AnsiString, dBServerInfoEntity.Note);
db.AddInParameter(cmd, "@Status", DbType.Byte, dBServerInfoEntity.Status);
db.AddInParameter(cmd, "@AddDate", DbType.DateTime, dBServerInfoEntity.AddDate);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public bool DeleteDBServerInfo(DBServerInfoEntity dBServerInfoEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("DELETE FROM dbo.DBServerInfo");
sqlCommandText.Append(" WHERE DBServerID=@DBServerID");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@DBServerID", DbType.Int32, dBServerInfoEntity.DBServerID);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="dBServerInfo">DBServerInfoEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteDBServerInfo(DBServerInfoEntity dBServerInfo)
{
return(DBServerInfoBusProvider.DeleteDBServerInfo(dBServerInfo));
}
/// <summary>
/// 更新存储媒介中的实体数据
/// </summary>
/// <param name="dBServerInfo">DBServerInfoEntity实体对象</param>
/// <returns>true:更新成功 false：更新失败</returns>
public bool UpdateDBServerInfo(DBServerInfoEntity dBServerInfo)
{
return(DBServerInfoBusProvider.UpdateDBServerInfo(dBServerInfo));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="dBServerInfo">DBServerInfoEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddDBServerInfo(DBServerInfoEntity dBServerInfo)
{
return(DBServerInfoBusProvider.AddDBServerInfo(dBServerInfo));
}
/// <summary>
/// 将实体数据存入存储媒介（持久化一个对象）
/// </summary>
/// <param name="dBServerInfo">DBServerInfoEntity实体对象</param>
/// <returns>true:存储成功 false：存储失败</returns>
public bool AddDBServerInfo(DBServerInfoEntity dBServerInfo)
{
return(DBServerInfoDataAccess.Instance.AddDBServerInfo(dBServerInfo));
}
/// <summary>
/// 从存储媒介删除实体数据
/// </summary>
/// <param name="dBServerInfo">DBServerInfoEntity实体对象</param>
/// <returns>true:删除成功 false：删除失败</returns>
public bool DeleteDBServerInfo(DBServerInfoEntity dBServerInfo)
{
return(DBServerInfoDataAccess.Instance.DeleteDBServerInfo(dBServerInfo));
}
