/// <summary> /// �õ�һ������ʵ�� /// </summary> public LabMS.Model.Responsibility GetModel(int ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 ID,Resp_Lab,Resp_Name,Resp_Content,Intro,Summary from Responsibility "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int,4)}; parameters[0].Value = ID; LabMS.Model.Responsibility model=new LabMS.Model.Responsibility(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { if(ds.Tables[0].Rows[0]["ID"].ToString()!="") { model.ID=int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); } if(ds.Tables[0].Rows[0]["Resp_Lab"].ToString()!="") { model.Resp_Lab=int.Parse(ds.Tables[0].Rows[0]["Resp_Lab"].ToString()); } model.Resp_Name=ds.Tables[0].Rows[0]["Resp_Name"].ToString(); model.Resp_Content=ds.Tables[0].Rows[0]["Resp_Content"].ToString(); model.Intro=ds.Tables[0].Rows[0]["Intro"].ToString(); model.Summary=ds.Tables[0].Rows[0]["Summary"].ToString(); return model; } else { return null; } }
protected void Submit_OnClick(object sender, EventArgs e) { #region 验证 if (int.Parse(RespLabDDL.SelectedValue.Trim()) == 0) { LabMS.Common.JShelper.JSAlert(Page, "err", "实验室名称不能为空!"); return; } if (string.IsNullOrEmpty(RespName.Text.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "岗位职责名称不能为空!"); return; } if (string.IsNullOrEmpty(RespContent.Text.Trim())) { LabMS.Common.JShelper.JSAlert(Page, "err", "职责内容不能为空!"); return; } #endregion LabMS.Model.Responsibility responsibility = new LabMS.Model.Responsibility(); Responsibility responsibilityInfo = new Responsibility(); responsibility.Resp_Lab = int.Parse(RespLabDDL.SelectedValue.Trim()); responsibility.Resp_Name = RespName.Text.ToString().Trim(); responsibility.Resp_Content = RespContent.Text.ToString().Trim(); responsibilityInfo.Add(responsibility); LabMS.Common.JShelper.JSAlertAndRedirect(Page, "AddSuccess", "添加成功!", "AddResponsibility.aspx"); }