public bool UpdateDict(NoticeContentEntity dictEntity)
{
bool flag = false;
StringBuilder whereCommandText = new StringBuilder();
whereCommandText.Append(" DicKey=@DicKey");
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" Content=@Content");
sqlCommandText.Append(", UpdateTime=getdate()");
DbCommand cmd = db.GetSqlStringCommand(String.Format("UPDATE dbo.NoticeContent SET {0} WHERE {1}", sqlCommandText.ToString(), whereCommandText.ToString()));
db.AddInParameter(cmd, "@DicKey", DbType.Int64, dictEntity.DicKey);
db.AddInParameter(cmd, "@Content", DbType.AnsiString, dictEntity.Content);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public bool AddDict(NoticeContentEntity dictEntity)
{
bool flag = false;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append(" @DicID");
sqlCommandText.Append(", @DicKey");
sqlCommandText.Append(", @Content");
sqlCommandText.Append(", @AddTime");
sqlCommandText.Append(", @UpdateTime");
DbCommand cmd = db.GetSqlStringCommand(String.Format("INSERT INTO dbo.NoticeContent ({0}) VALUES ({1})", sqlCommandText.ToString().Replace("@", ""), sqlCommandText.ToString()));
db.AddInParameter(cmd, "@DicID", DbType.Int64, dictEntity.DicID);
db.AddInParameter(cmd, "@DicKey", DbType.String, dictEntity.DicKey);
db.AddInParameter(cmd, "@Content", DbType.AnsiString, dictEntity.Content);
db.AddInParameter(cmd, "@AddTime", DbType.DateTime, dictEntity.AddTime);
db.AddInParameter(cmd, "@UpdateTime", DbType.DateTime, dictEntity.UpdateTime);
try
{
db.ExecuteNonQuery(cmd);
flag = true;
}
catch (SqlException sqlEx)
{
throw sqlEx;
}
return(flag);
}
public List <NoticeContentEntity> MakeDictList(DataTable dt)
{
List <NoticeContentEntity> list = new List <NoticeContentEntity>();
if (dt != null)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
NoticeContentEntity dictEntity = MakeDict(dt.Rows[i]);
list.Add(dictEntity);
}
}
return(list);
}
public NoticeContentEntity MakeDict(DataRow dr)
{
NoticeContentEntity dictEntity = null;
if (dr != null)
{
dictEntity = new NoticeContentEntity();
dictEntity.DicID = Convert.ToInt32(dr["DicID"]);
dictEntity.DicKey = (string)dr["DicKey"];
dictEntity.Content = Convert.ToString(dr["Content"]);
dictEntity.AddTime = (DateTime)dr["AddTime"];
dictEntity.UpdateTime = (DateTime)dr["UpdateTime"];
}
return(dictEntity);
}
public List <NoticeContentEntity> MakeDictList(IDataReader dr)
{
List <NoticeContentEntity> list = new List <NoticeContentEntity>();
while (dr.Read())
{
NoticeContentEntity dictEntity = new NoticeContentEntity();
dictEntity.DicID = Convert.ToInt32(dr["DicID"]);
dictEntity.DicKey = (string)dr["DicKey"];
dictEntity.Content = Convert.ToString(dr["Content"]);
dictEntity.AddTime = (DateTime)dr["AddTime"];
dictEntity.UpdateTime = (DateTime)dr["UpdateTime"];
list.Add(dictEntity);
}
dr.Close();
return(list);
}
public NoticeContentEntity GetNoticeContent(string dicKey)
{
NoticeContentEntity dictEntity = null;
StringBuilder sqlCommandText = new StringBuilder();
sqlCommandText.Append("SELECT TOP 1 DicID,DicKey,Content,AddTime,UpdateTime FROM dbo.NoticeContent WITH(NOLOCK)");
sqlCommandText.Append(" WHERE DicKey=@DicKey");
DbCommand cmd = db.GetSqlStringCommand(sqlCommandText.ToString());
db.AddInParameter(cmd, "@DicKey", DbType.String, dicKey);
using (IDataReader dr = db.ExecuteReader(cmd))
{
dictEntity = MakeDict(dr);
}
return(dictEntity);
}
public bool UpdateDict(NoticeContentEntity dictEntity)
{
return(NoticeContentBusProvider.UpdateDict(dictEntity));
}
public bool AddDict(NoticeContentEntity dictEntity)
{
return(NoticeContentBusProvider.AddDict(dictEntity));
}
public bool UpdateDict(NoticeContentEntity dictEntity)
{
return(NoticeContentDataAccess.Instance.UpdateDict(dictEntity));
}
