//添加
protected void btnAdd_Click(object sender, EventArgs e)
{
if (txtArchiveItemName.Text.Trim().Length == 0)
{
Javascript.GoHistory(-1, "请输入要上传的资料名称！", Page);
}
else
{
DalOperationAboutArchivesItems dal = new DalOperationAboutArchivesItems();
ArchivesItems model = new ArchivesItems();
model.archiveItemName = txtArchiveItemName.Text.Trim();
model.remark = txtRemark.Text.Trim();
model.teacherType = ddlTeacherType.SelectedValue;
model.termTag = ddlTermTags.SelectedValue;
try
{
dal.AddArchivesItems(model);//添加
Javascript.RefreshParentWindow("添加结课资料规则成功！", "/Administrator/ArchivesManage.aspx?fragment=2", Page);
}
catch (Exception ex)
{
MongoDBLog.LogRecord(ex);
Javascript.GoHistory(-1, "添加结课资料规则失败,请检查格式是否有误！", Page);
}
}
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int AddArchivesItems(ArchivesItems model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into usta_ArchivesItems(");
strSql.Append("archiveItemName,remark,teacherType,termTag)");
strSql.Append(" values (");
strSql.Append("@archiveItemName,@remark,@teacherType,@termTag);");
SqlParameter[] parameters = {
new SqlParameter("@archiveItemName", SqlDbType.NChar,50),
new SqlParameter("@remark", SqlDbType.NVarChar,200),
new SqlParameter("@teacherType", SqlDbType.NChar,10),
new SqlParameter("@termTag", SqlDbType.NVarChar,50)};
parameters[0].Value = model.archiveItemName;
parameters[1].Value = model.remark;
parameters[2].Value = model.teacherType;
parameters[3].Value = model.termTag;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
/// <summary>
///
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public int UpdateArchivesItemById(ArchivesItems model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("update usta_ArchivesItems set ");
strSql.Append("archiveItemName=@archiveItemName,");
strSql.Append("remark=@remark,");
strSql.Append("termTag=@termTag,");
strSql.Append("teacherType=@teacherType");
strSql.Append(" where archiveItemId=@archiveItemId");
SqlParameter[] parameters = {
new SqlParameter("@archiveItemName", SqlDbType.NChar,50),
new SqlParameter("@remark", SqlDbType.NVarChar,200),
new SqlParameter("@teacherType", SqlDbType.NChar,10),
new SqlParameter("@archiveItemId", SqlDbType.Int,4),
new SqlParameter("@termTag", SqlDbType.NVarChar,50)};
parameters[0].Value = model.archiveItemName;
parameters[1].Value = model.remark;
parameters[2].Value = model.teacherType;
parameters[3].Value = model.archiveItemId;
parameters[4].Value = model.termTag;
return SqlHelper.ExecuteNonQuery(conn, CommandType.Text, strSql.ToString(), parameters);
}
