/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mess_Model model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update COM_MESSAGE set ");
if (model.MESSAGE_NAME != null)
{
strSql.Append("MESSAGE_NAME='" + model.MESSAGE_NAME + "',");
}
else
{
strSql.Append("MESSAGE_NAME= null ,");
}
if (model.MESSAGE_EMAIL != null)
{
strSql.Append("MESSAGE_EMAIL='" + model.MESSAGE_EMAIL + "',");
}
else
{
strSql.Append("MESSAGE_EMAIL= null ,");
}
if (model.MESSAGE_PHONE != null)
{
strSql.Append("MESSAGE_PHONE='" + model.MESSAGE_PHONE + "',");
}
else
{
strSql.Append("MESSAGE_PHONE= null ,");
}
if (model.MESSAGE_CONTENT != null)
{
strSql.Append("MESSAGE_CONTENT='" + model.MESSAGE_CONTENT + "',");
}
else
{
strSql.Append("MESSAGE_CONTENT= null ,");
}
if (model.CREATE_TIME != null)
{
strSql.Append("CREATE_TIME='" + model.CREATE_TIME + "',");
}
else
{
strSql.Append("CREATE_TIME= null ,");
}
int n = strSql.ToString().LastIndexOf(",");
strSql.Remove(n, 1);
strSql.Append(" where MESSAGE_ID=" + model.MESSAGE_ID + "");
int rowsAffected = DbHelperSQL.ExecuteSql(strSql.ToString());
if (rowsAffected > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Mess_Model model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.MESSAGE_NAME != null)
{
strSql1.Append("MESSAGE_NAME,");
strSql2.Append("'" + model.MESSAGE_NAME + "',");
}
if (model.MESSAGE_EMAIL != null)
{
strSql1.Append("MESSAGE_EMAIL,");
strSql2.Append("'" + model.MESSAGE_EMAIL + "',");
}
if (model.MESSAGE_PHONE != null)
{
strSql1.Append("MESSAGE_PHONE,");
strSql2.Append("'" + model.MESSAGE_PHONE + "',");
}
if (model.MESSAGE_CONTENT != null)
{
strSql1.Append("MESSAGE_CONTENT,");
strSql2.Append("'" + model.MESSAGE_CONTENT + "',");
}
if (model.CREATE_TIME != null)
{
strSql1.Append("CREATE_TIME,");
strSql2.Append("'" + model.CREATE_TIME + "',");
}
strSql.Append("insert into COM_MESSAGE(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
object obj = DbHelperSQL.GetSingle(strSql.ToString());
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Mess_Model model)
{
return(dal.Update(model));
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Mess_Model model)
{
return(dal.Add(model));
}
