/// <summary>
/// 修改常用短语信息类别
/// </summary>
/// <param name="model">常用短语信息类别实体</param>
/// <returns>返回1成功；其他失败</returns>
public int UpdateSmsPhraseType(MSmsPhraseType model)
{
if (model == null || model.TypeId <= 0)
{
return(0);
}
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseTypeUpdate);
_db.AddInParameter(dc, "ClassName", DbType.String, model.TypeName);
_db.AddInParameter(dc, "OperatorId", DbType.AnsiStringFixedLength, model.OperatorId);
_db.AddInParameter(dc, "Id", DbType.AnsiStringFixedLength, model.TypeId);
return(DbHelper.ExecuteSql(dc, _db) > 0 ? 1 : 0);
}
/// <summary>
/// 添加常用短语信息类别
/// </summary>
/// <param name="model">常用短语信息类别实体</param>
/// <returns>返回1成功；其他失败</returns>
public int AddSmsPhraseType(MSmsPhraseType model)
{
if (model == null || string.IsNullOrEmpty(model.CompanyId))
{
return(0);
}
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseTypeAdd);
_db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, model.CompanyId);
_db.AddInParameter(dc, "ClassName", DbType.String, model.TypeName);
_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="companyId">公司编号</param>
/// <returns>返回常用短语信息类别集合</returns>
public IList <MSmsPhraseType> GetSmsPhraseTypeList(string companyId)
{
IList <MSmsPhraseType> list = null;
if (string.IsNullOrEmpty(companyId))
{
return(list);
}
MSmsPhraseType model;
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseTypeSelect + " where CompanyId = @CompanyId ");
_db.AddInParameter(dc, "CompanyId", DbType.AnsiStringFixedLength, companyId);
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
list = new List <MSmsPhraseType>();
while (dr.Read())
{
model = new MSmsPhraseType();
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
model.TypeId = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ClassName")))
{
model.TypeName = dr.GetString(dr.GetOrdinal("ClassName"));
}
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"));
}
list.Add(model);
}
}
return(list);
}
/// <summary>
/// 获取常用短语信息类别
/// </summary>
/// <param name="typeId">常用短语信息类别编号</param>
/// <returns>返回常用短语信息类别实体</returns>
public MSmsPhraseType GetSmsPhraseType(int typeId)
{
MSmsPhraseType model = null;
if (typeId <= 0)
{
return(model);
}
DbCommand dc = _db.GetSqlStringCommand(SqlSmsPhraseTypeSelect + " where Id = @Id ");
_db.AddInParameter(dc, "Id", DbType.Int32, typeId);
using (IDataReader dr = DbHelper.ExecuteReader(dc, _db))
{
if (dr.Read())
{
model = new MSmsPhraseType();
if (!dr.IsDBNull(dr.GetOrdinal("Id")))
{
model.TypeId = dr.GetInt32(dr.GetOrdinal("Id"));
}
if (!dr.IsDBNull(dr.GetOrdinal("CompanyId")))
{
model.CompanyId = dr.GetString(dr.GetOrdinal("CompanyId"));
}
if (!dr.IsDBNull(dr.GetOrdinal("ClassName")))
{
model.TypeName = dr.GetString(dr.GetOrdinal("ClassName"));
}
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);
}
