/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(abc.Model.Model.AnswerNotification model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update AnswerNotification set ");
strSql.Append("TeacherId=SQL2012TeacherId,");
strSql.Append("Content=SQL2012Content,");
strSql.Append("OrderBy=SQL2012OrderBy,");
strSql.Append("IsSend=SQL2012IsSend,");
strSql.Append("SendDate=SQL2012SendDate,");
strSql.Append("CreateTime=SQL2012CreateTime");
strSql.Append(" where NotifyId=SQL2012NotifyId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012TeacherId", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012OrderBy", SqlDbType.Int, 4),
new SqlParameter("SQL2012IsSend", SqlDbType.Int, 4),
new SqlParameter("SQL2012SendDate", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime),
new SqlParameter("SQL2012NotifyId", SqlDbType.Int, 4),
new SqlParameter("SQL2012AskId", SqlDbType.Int, 4),
new SqlParameter("SQL2012MemberId", SqlDbType.Int, 4)
};
parameters[0].Value = model.TeacherId;
parameters[1].Value = model.Content;
parameters[2].Value = model.OrderBy;
parameters[3].Value = model.IsSend;
parameters[4].Value = model.SendDate;
parameters[5].Value = model.CreateTime;
parameters[6].Value = model.NotifyId;
parameters[7].Value = model.AskId;
parameters[8].Value = model.MemberId;
int rows = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.AnswerNotification DataRowToModel(DataRow row)
{
abc.Model.Model.AnswerNotification model = new abc.Model.Model.AnswerNotification();
if (row != null)
{
if (row["NotifyId"] != null && row["NotifyId"].ToString() != "")
{
model.NotifyId = int.Parse(row["NotifyId"].ToString());
}
if (row["AskId"] != null && row["AskId"].ToString() != "")
{
model.AskId = int.Parse(row["AskId"].ToString());
}
if (row["MemberId"] != null && row["MemberId"].ToString() != "")
{
model.MemberId = int.Parse(row["MemberId"].ToString());
}
if (row["TeacherId"] != null)
{
model.TeacherId = row["TeacherId"].ToString();
}
if (row["Content"] != null)
{
model.Content = row["Content"].ToString();
}
if (row["OrderBy"] != null && row["OrderBy"].ToString() != "")
{
model.OrderBy = int.Parse(row["OrderBy"].ToString());
}
if (row["IsSend"] != null && row["IsSend"].ToString() != "")
{
model.IsSend = int.Parse(row["IsSend"].ToString());
}
if (row["SendDate"] != null)
{
model.SendDate = row["SendDate"].ToString();
}
if (row["CreateTime"] != null && row["CreateTime"].ToString() != "")
{
model.CreateTime = DateTime.Parse(row["CreateTime"].ToString());
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(abc.Model.Model.AnswerNotification model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into AnswerNotification(");
strSql.Append("AskId,MemberId,TeacherId,Content,OrderBy,IsSend,SendDate,CreateTime)");
strSql.Append(" values (");
strSql.Append("SQL2012AskId,SQL2012MemberId,SQL2012TeacherId,SQL2012Content,SQL2012OrderBy,SQL2012IsSend,SQL2012SendDate,SQL2012CreateTime)");
strSql.Append(";select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012AskId", SqlDbType.Int, 4),
new SqlParameter("SQL2012MemberId", SqlDbType.Int, 4),
new SqlParameter("SQL2012TeacherId", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012Content", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012OrderBy", SqlDbType.Int, 4),
new SqlParameter("SQL2012IsSend", SqlDbType.Int, 4),
new SqlParameter("SQL2012SendDate", SqlDbType.VarChar, 4000),
new SqlParameter("SQL2012CreateTime", SqlDbType.DateTime)
};
parameters[0].Value = model.AskId;
parameters[1].Value = model.MemberId;
parameters[2].Value = model.TeacherId;
parameters[3].Value = model.Content;
parameters[4].Value = model.OrderBy;
parameters[5].Value = model.IsSend;
parameters[6].Value = model.SendDate;
parameters[7].Value = model.CreateTime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
if (obj == null)
{
return(0);
}
else
{
return(Convert.ToInt32(obj));
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public abc.Model.Model.AnswerNotification GetModel(int NotifyId)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 NotifyId,AskId,MemberId,TeacherId,Content,OrderBy,IsSend,SendDate,CreateTime from AnswerNotification ");
strSql.Append(" where NotifyId=SQL2012NotifyId");
SqlParameter[] parameters =
{
new SqlParameter("SQL2012NotifyId", SqlDbType.Int, 4)
};
parameters[0].Value = NotifyId;
abc.Model.Model.AnswerNotification model = new abc.Model.Model.AnswerNotification();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
