/// <summary>
/// 获取常用短语信息
/// </summary>
/// <param name="phraseId">常用短语编号</param>
/// <returns>返回常用短语信息</returns>
public MSmsPhrase GetSmsPhrase(int phraseId)
{
MSmsPhrase model = null;
if (phraseId <= 0)
{
return(model);
}
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseSelect + " where Id = @Id ");
_db.AddInParameter(dc, "Id", DbType.Int32, phraseId);
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
if (dr.Read())
{
model = new MSmsPhrase {
SmsPhraseType = new MSmsPhraseTypeBase()
};
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
model.PhraseId = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TypeId")))
{
model.SmsPhraseType.TypeId = dr.GetInt32(dr.GetOrdinal("TypeId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Content")))
{
model.Content = dr.GetString(dr.GetOrdinal("Content"));
}
if (!dr.IsDBNull(dr.GetOrdinal("OperatorId")))
{
model.OperatorId = dr.GetString(dr.GetOrdinal("OperatorId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("IssueTime")))
{
model.IssueTime = dr.GetDateTime(dr.GetOrdinal("IssueTime"));
}
}
}
return(model);
}
/// <summary>
/// 修改短信常用短语
/// </summary>
/// <param name="model">常用短语实体</param>
/// <returns>返回1成功；其他失败</returns>
public int UpdateSmsPhrase(MSmsPhrase model)
{
if (model == null || model.SmsPhraseType == null || model.PhraseId <= 0)
{
return(0);
}
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseUpdate);
_db.AddInParameter(dc, "TypeId", DbType.Int32, model.SmsPhraseType.TypeId);
_db.AddInParameter(dc, "Content", DbType.String, model.Content);
_db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId);
_db.AddInParameter(dc, "Id", DbType.Int32, model.PhraseId);
return(DbHelper.ExecuteSql(dc, _db) > 0 ? 1 : 0);
}
/// <summary>
/// 添加短信常用短语
/// </summary>
/// <param name="model">常用短语实体</param>
/// <returns>返回1成功；其他失败</returns>
public int AddSmsPhrase(MSmsPhrase model)
{
if (model == null || model.SmsPhraseType == null)
{
return(0);
}
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseAdd);
_db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId);
_db.AddInParameter(dc, "TypeId", DbType.Int32, model.SmsPhraseType.TypeId);
_db.AddInParameter(dc, "Content", DbType.String, model.Content);
_db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId);
_db.AddInParameter(dc, "IssueTime", DbType.DateTime, DateTime.Now);
return(DbHelper.ExecuteSql(dc, _db) > 0 ? 1 : 0);
}
/// <summary>
/// 获取短信常用短语列表
/// </summary>
/// <param name="pageSize">每页记录数</param>
/// <param name="pageIndex">当前页数</param>
/// <param name="recordCount">总记录数</param>
/// <param name="companyId">公司编号</param>
/// <param name="model">查询实体</param>
/// <returns>返回常用短语信息集合</returns>
public IList <MSmsPhrase> GetSmsPhraseList(int pageSize, int pageIndex, ref int recordCount, string companyId
, MQuerySmsPhrase model)
{
IList <MSmsPhrase> list = null;
if (string.IsNullOrEmpty(companyId))
{
return(list);
}
MSmsPhrase tmpModel;
#region Sql拼接
string fields = " [Id],[CompanyId],[TypeId],[Content],(select ClassName from tbl_SmsPhraseType where tbl_SmsPhraseType.Id = tbl_SmsPhrase.TypeId) as TypeName ";
string tableName = "tbl_SmsPhrase";
string orderByString = " [IssueTime] asc ";
string identityColumnName = " Id ";
var strWhere = new StringBuilder();
strWhere.AppendFormat(" CompanyId = '{0}' ", companyId);
if (model != null)
{
if (!string.IsNullOrEmpty(model.KeyWord.Trim()))
{
strWhere.AppendFormat(" and Content like '%{0}%' ", model.KeyWord.Trim());
}
if (model.SmsPhraseType != null && model.SmsPhraseType.TypeId > 0)
{
strWhere.AppendFormat(" and TypeId = {0} ", model.SmsPhraseType.TypeId);
}
}
#endregion
using (IDataReader dr = DbHelper.ExecuteReader(_db, pageSize, pageIndex, ref recordCount, tableName
, identityColumnName, fields, strWhere.ToString(), orderByString))
{
list = new List <MSmsPhrase>();
while (dr.Read())
{
tmpModel = new MSmsPhrase {
SmsPhraseType = new MSmsPhraseTypeBase()
};
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
tmpModel.PhraseId = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
tmpModel.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TypeId")))
{
tmpModel.SmsPhraseType.TypeId = dr.GetInt32(dr.GetOrdinal("TypeId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("Content")))
{
tmpModel.Content = dr.GetString(dr.GetOrdinal("Content"));
}
if (!dr.IsDBNull(dr.GetOrdinal("TypeName")))
{
tmpModel.SmsPhraseType.TypeName = dr.GetString(dr.GetOrdinal("TypeName"));
}
list.Add(tmpModel);
}
}
return(list);
}