/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(abc.Model.Model.SMSTemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update SMSTemplate set ");
strSql.Append("Title=SQL2012Title,");
strSql.Append("Subject=SQL2012Subject,");
strSql.Append("Content=SQL2012Content,");
strSql.Append("SmsType=SQL2012SmsType,");
strSql.Append("Enabled=SQL2012Enabled,");
strSql.Append("CreateTime=SQL2012CreateTime,");
strSql.Append("Note=SQL2012Note");
strSql.Append(" where SmsId=SQL2012SmsId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012Title", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Subject", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012SmsType", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Enabled", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime),
new SqlParameter("SQL2012Note", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012SmsId", SqlDbType.Int, 4)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Subject;
parameters[2].Value = model.Content;
parameters[3].Value = model.SmsType;
parameters[4].Value = model.Enabled;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.Note;
parameters[7].Value = model.SmsId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.SMSTemplate DataRowToModel(DataRow row)
{
abc.Model.Model.SMSTemplate model = new abc.Model.Model.SMSTemplate();
if (row != null)
{
if (row["SmsId"] != null && row["SmsId"].ToString() != "")
{
model.SmsId = int.Parse(row["SmsId"].ToString());
}
if (row["Title"] != null)
{
model.Title = row["Title"].ToString();
}
if (row["Subject"] != null)
{
model.Subject = row["Subject"].ToString();
}
if (row["Content"] != null)
{
model.Content = row["Content"].ToString();
}
if (row["SmsType"] != null)
{
model.SmsType = row["SmsType"].ToString();
}
if (row["Enabled"] != null && row["Enabled"].ToString() != "")
{
model.Enabled = int.Parse(row["Enabled"].ToString());
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
if (row["Note"] != null)
{
model.Note = row["Note"].ToString();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(abc.Model.Model.SMSTemplate model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into SMSTemplate(");
strSql.Append("Title,Subject,Content,SmsType,Enabled,CreateTime,Note)");
strSql.Append(" values (");
strSql.Append("SQL2012Title,SQL2012Subject,SQL2012Content,SQL2012SmsType,SQL2012Enabled,SQL2012CreateTime,SQL2012Note)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012Title", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Subject", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012SmsType", SqlDbType.VarChar, 255),
new SqlParameter("SQL2012Enabled", SqlDbType.Int, 4),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime),
new SqlParameter("SQL2012Note", SqlDbType.VarChar, 4000)
};
parameters[0].Value = model.Title;
parameters[1].Value = model.Subject;
parameters[2].Value = model.Content;
parameters[3].Value = model.SmsType;
parameters[4].Value = model.Enabled;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.Note;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.SMSTemplate GetModel(int SmsId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 SmsId,Title,Subject,Content,SmsType,Enabled,CreateTime,Note from SMSTemplate ");
strSql.Append(" where SmsId=SQL2012SmsId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012SmsId", SqlDbType.Int, 4)
};
parameters[0].Value = SmsId;
abc.Model.Model.SMSTemplate model = new abc.Model.Model.SMSTemplate();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
