/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(MsgTextModel model)
{
bool reValue = true;
int reCount = 0;
StringBuilder strSql = new StringBuilder();
strSql.Append("update DBMSG.dbo.MsgText set ");
strSql.Append(" MsgClassId = @MsgClassId , ");
strSql.Append(" MsgTitle = @MsgTitle , ");
strSql.Append(" MsgContent = @MsgContent , ");
strSql.Append(" MsgType = @MsgType , ");
strSql.Append(" CreateTime = @CreateTime , ");
strSql.Append(" EndTime = @EndTime , ");
strSql.Append(" Extra = @Extra , ");
strSql.Append(" SiteId = @SiteId , ");
strSql.Append(" ZoneId = @ZoneId ");
strSql.Append(" where MsgTextId=@MsgTextId ");
SqlParameter[] parameters =
{
new SqlParameter("@MsgTextId", SqlDbType.Decimal, 9),
new SqlParameter("@MsgClassId", SqlDbType.Int, 4),
new SqlParameter("@MsgTitle", SqlDbType.VarChar, 200),
new SqlParameter("@MsgContent", SqlDbType.VarChar, -1),
new SqlParameter("@MsgType", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Extra", SqlDbType.VarChar, -1),
new SqlParameter("@SiteId", SqlDbType.Decimal, 9),
new SqlParameter("@ZoneId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.MsgTextId;
parameters[1].Value = model.MsgClassId;
parameters[2].Value = model.MsgTitle;
parameters[3].Value = model.MsgContent;
parameters[4].Value = model.MsgType;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.EndTime;
parameters[7].Value = model.Extra;
parameters[8].Value = model.SiteId;
parameters[9].Value = model.ZoneId; try
{//异常处理
reCount = this.helper.ExecSqlReInt(strSql.ToString(), parameters);
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
if (reCount <= 0)
{
reValue = false;
}
return(reValue);
}
/// <summary>
/// 增加一条数据
/// </summary>
public bool Add(MsgTextModel model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into DBMSG.dbo.MsgText (");
strSql.Append("MsgClassId,MsgTitle,MsgContent,MsgType,CreateTime,EndTime,Extra,SiteId,ZoneId");
strSql.Append(") values (");
strSql.Append("@MsgClassId,@MsgTitle,@MsgContent,@MsgType,@CreateTime,@EndTime,@Extra,@SiteId,@ZoneId");
strSql.Append(") ");
strSql.Append(";");
SqlParameter[] parameters =
{
new SqlParameter("@MsgClassId", SqlDbType.Int, 4),
new SqlParameter("@MsgTitle", SqlDbType.VarChar, 200),
new SqlParameter("@MsgContent", SqlDbType.VarChar, -1),
new SqlParameter("@MsgType", SqlDbType.VarChar, 50),
new SqlParameter("@CreateTime", SqlDbType.DateTime),
new SqlParameter("@EndTime", SqlDbType.DateTime),
new SqlParameter("@Extra", SqlDbType.VarChar, -1),
new SqlParameter("@SiteId", SqlDbType.Decimal, 9),
new SqlParameter("@ZoneId", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.MsgClassId;
parameters[1].Value = model.MsgTitle;
parameters[2].Value = model.MsgContent;
parameters[3].Value = model.MsgType;
parameters[4].Value = model.CreateTime;
parameters[5].Value = model.EndTime;
parameters[6].Value = model.Extra;
parameters[7].Value = model.SiteId;
parameters[8].Value = model.ZoneId;
bool result = false;
try
{
model.MsgTextId = decimal.Parse(helper.ExecuteNonQueryBackId(strSql.ToString(), "MsgTextId", parameters));
result = true;
}
catch (Exception ex)
{
this.helper.Close();
throw ex;
}
finally
{
}
return(result);
}
