Exemple #1
0
        /// <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");
        }