/// <summary>
/// 添加留言提问
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddReception(YouthReception model)
{
StringBuilder str = new StringBuilder();
str.Append(" insert into reception ");
str.Append(" (reception_name,reception_sex,reception_homepage,reception_email,reception_qq,reception_title,reception_content,reception_time,is_reply,reception_type_id) ");
str.Append(" values ");
str.Append(" (@reception_name,@reception_sex,@reception_homepage,@reception_email,@reception_qq,@reception_title,@reception_content,@reception_time,@is_reply,@reception_type_id) ");
SqlParameter[] parameters =
{
new SqlParameter("@reception_name", SqlDbType.NVarChar, 25),
new SqlParameter("@reception_sex", SqlDbType.VarChar, 10),
new SqlParameter("@reception_homepage", SqlDbType.NVarChar, 50),
new SqlParameter("@reception_email", SqlDbType.NVarChar, 25),
new SqlParameter("@reception_qq", SqlDbType.NVarChar, 25),
new SqlParameter("@reception_title", SqlDbType.NVarChar, 50),
new SqlParameter("@reception_content", SqlDbType.NText),
new SqlParameter("@reception_time", SqlDbType.DateTime),
new SqlParameter("@is_reply", SqlDbType.VarChar, 10),
new SqlParameter("@reception_type_id", SqlDbType.Int, 8)
};
parameters[0].Value = model.Reception_name;
parameters[1].Value = model.Reception_sex;
parameters[2].Value = model.Reception_homepage;
parameters[3].Value = model.Reception_email;
parameters[4].Value = model.Reception_qq;
parameters[5].Value = model.Reception_title;
parameters[6].Value = model.Reception_content;
parameters[7].Value = model.Reception_time;
parameters[8].Value = model.Is_reply;
parameters[9].Value = model.Reception_type_id;
int rows = DbHelperSQL.ExecuteSql(str.ToString(), parameters);
return(rows);
}
/// <summary>
/// 添加留言提问
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool AddReception(YouthReception model)
{
int rows = dal.AddReception(model);
if (rows > 0)
{
return(true);
}
else
{
return(false);
}
}
protected void bindData()
{
int reception_id = Convert.ToInt32(ViewState["reception_id"].ToString());
model = bll.GetListById(reception_id);
lblsender.Text = model.Reception_name;
lbltitle.Text = model.Reception_title;
lblquestioncontent.Text = model.Reception_content;
YouthSecretary sec_model = huifu_bll.GetListById(reception_id);
if (sec_model != null)
{
txtanswercontent.Text = sec_model.Secretary_content;
}
}
/// <summary>
/// 根据id得到问题实体
/// </summary>
/// <param name="reception_id"></param>
/// <returns></returns>
public YouthReception GetListById(int reception_id)
{
YouthReception model = new YouthReception();
StringBuilder str = new StringBuilder();
str.Append(" select * from reception ");
str.Append(" where reception_id=" + reception_id);
DataSet ds = DbHelperSQL.Query(str.ToString());
if (ds.Tables[0].Rows.Count > 0)
{
DataRow row = ds.Tables[0].Rows[0];
if (row["reception_id"] != null)
{
model.Reception_id = Convert.ToInt32(row["reception_id"].ToString());
}
if (row["reception_name"] != null)
{
model.Reception_name = row["reception_name"].ToString();
}
if (row["reception_sex"] != null)
{
model.Reception_sex = row["reception_sex"].ToString();
}
if (row["reception_homepage"] != null)
{
model.Reception_homepage = row["reception_homepage"].ToString();
}
if (row["reception_email"] != null)
{
model.Reception_email = row["reception_email"].ToString();
}
if (row["reception_qq"] != null)
{
model.Reception_qq = row["reception_qq"].ToString();
}
if (row["reception_title"] != null)
{
model.Reception_title = row["reception_title"].ToString();
}
if (row["reception_content"] != null)
{
model.Reception_content = row["reception_content"].ToString();
}
if (row["reception_time"] != null)
{
model.Reception_time = DateTime.Parse(row["reception_time"].ToString());
}
if (row["is_reply"] != null)
{
model.Is_reply = row["is_reply"].ToString();
}
if (row["reception_type_id"] != null)
{
model.Reception_type_id = Convert.ToInt32(row["reception_type_id"].ToString());
}
return(model);
}
else
{
return(null);
}
}
