//添加 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); }