/// <summary>
/// 获取模板信息
/// </summary>
/// <param name="id">模板编号</param>
/// <returns></returns>
public EyouSoft.Model.CompanyStructure.MNotepadServiceInfo GetInfo(int id)
{
EyouSoft.Model.CompanyStructure.MNotepadServiceInfo info = null;
DbCommand cmd = this._db.GetSqlStringCommand(SQL_SELECT_GetInfo);
this._db.AddInParameter(cmd, "Id", DbType.Int32, id);
using (IDataReader rdr = DbHelper.ExecuteReader(cmd, this._db))
{
if (rdr.Read())
{
info = new EyouSoft.Model.CompanyStructure.MNotepadServiceInfo()
{
CompanyId = rdr.GetInt32(rdr.GetOrdinal("CompanyId")),
CreateTime = rdr.GetDateTime(rdr.GetOrdinal("CreateTime")),
Id = id,
OperatorId = rdr.GetInt32(rdr.GetOrdinal("OperatorId")),
Text = rdr["Text"].ToString(),
Type = (EyouSoft.Model.EnumType.CompanyStructure.NotepadServiceType)rdr.GetByte(rdr.GetOrdinal("Type"))
};
}
}
return(info);
}
/// <summary>
/// 更新模板信息
/// </summary>
/// <param name="info">EyouSoft.Model.CompanyStructure.MNotepadServiceInfo</param>
/// <returns></returns>
public bool UpdateNotepad(EyouSoft.Model.CompanyStructure.MNotepadServiceInfo info)
{
if (info.Id < 1)
{
return(false);
}
return(dal.UpdateNotepad(info));
}
/// <summary>
/// 更新模板信息
/// </summary>
/// <param name="info">EyouSoft.Model.CompanyStructure.MNotepadServiceInfo</param>
/// <returns></returns>
public bool UpdateNotepad(EyouSoft.Model.CompanyStructure.MNotepadServiceInfo info)
{
DbCommand cmd = this._db.GetSqlStringCommand(SLQ_UPDATE_UpdateNotepad);
this._db.AddInParameter(cmd, "Text", DbType.String, info.Text);
this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, info.OperatorId);
this._db.AddInParameter(cmd, "Id", DbType.Int32, info.Id);
return(DbHelper.ExecuteSql(cmd, this._db) == 1 ? true : false);
}
/// <summary>
/// 写入模板信息
/// </summary>
/// <param name="info">EyouSoft.Model.CompanyStructure.MNotepadServiceInfo</param>
/// <returns></returns>
public bool InsertNotepad(EyouSoft.Model.CompanyStructure.MNotepadServiceInfo info)
{
DbCommand cmd = this._db.GetSqlStringCommand(SQL_INSERT_InsertNotepad);
this._db.AddInParameter(cmd, "CompanyId", DbType.Int32, info.CompanyId);
this._db.AddInParameter(cmd, "Type", DbType.Byte, info.Type);
this._db.AddInParameter(cmd, "Text", DbType.String, info.Text);
this._db.AddInParameter(cmd, "OperatorId", DbType.Int32, info.OperatorId);
return(DbHelper.ExecuteSql(cmd, this._db) == 1 ? true : false);
}
/// <summary>
/// 写入模板信息
/// </summary>
/// <param name="info">EyouSoft.Model.CompanyStructure.MNotepadServiceInfo</param>
/// <returns></returns>
public bool InsertNotepad(EyouSoft.Model.CompanyStructure.MNotepadServiceInfo info)
{
return(dal.InsertNotepad(info));
}
