示例#1
0
文件: ExamineInfo.cs 项目: aj-hc/SY
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public RuRo.Model.ExamineInfo DataRowToModel(DataRow row)
 {
     RuRo.Model.ExamineInfo model=new RuRo.Model.ExamineInfo();
     if (row != null)
     {
         if(row["id"]!=null && row["id"].ToString()!="")
         {
             model.id=int.Parse(row["id"].ToString());
         }
         if(row["ExamineRequestID"]!=null && row["ExamineRequestID"].ToString()!="")
         {
             model.ExamineRequestID=int.Parse(row["ExamineRequestID"].ToString());
         }
         if(row["ItemSetNo"]!=null)
         {
             model.ItemSetNo=row["ItemSetNo"].ToString();
         }
         if(row["Description"]!=null)
         {
             model.Description=row["Description"].ToString();
         }
         if(row["ItemSetID"]!=null && row["ItemSetID"].ToString()!="")
         {
             model.ItemSetID=int.Parse(row["ItemSetID"].ToString());
         }
     }
     return model;
 }
示例#2
0
        public void btnSave_Click(object sender, EventArgs e)
        {
            string strErr="";
            if(!PageValidate.IsNumber(txtExamineRequestID.Text))
            {
                strErr+="ExamineRequestID格式错误!\\n";
            }
            if(this.txtItemSetNo.Text.Trim().Length==0)
            {
                strErr+="ItemSetNo不能为空!\\n";
            }
            if(this.txtDescription.Text.Trim().Length==0)
            {
                strErr+="Description不能为空!\\n";
            }
            if(!PageValidate.IsNumber(txtItemSetID.Text))
            {
                strErr+="ItemSetID格式错误!\\n";
            }

            if(strErr!="")
            {
                MessageBox.Show(this,strErr);
                return;
            }
            int id=int.Parse(this.lblid.Text);
            int ExamineRequestID=int.Parse(this.txtExamineRequestID.Text);
            string ItemSetNo=this.txtItemSetNo.Text;
            string Description=this.txtDescription.Text;
            int ItemSetID=int.Parse(this.txtItemSetID.Text);

            RuRo.Model.ExamineInfo model=new RuRo.Model.ExamineInfo();
            model.id=id;
            model.ExamineRequestID=ExamineRequestID;
            model.ItemSetNo=ItemSetNo;
            model.Description=Description;
            model.ItemSetID=ItemSetID;

            RuRo.BLL.ExamineInfo bll=new RuRo.BLL.ExamineInfo();
            bll.Update(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","list.aspx");
        }
示例#3
0
文件: ExamineInfo.cs 项目: aj-hc/SY
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public RuRo.Model.ExamineInfo GetModel(int id)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 id,ExamineRequestID,ItemSetNo,Description,ItemSetID from ExamineInfo ");
            strSql.Append(" where id=@id");
            SqlParameter[] parameters = {
                    new SqlParameter("@id", SqlDbType.Int,4)
            };
            parameters[0].Value = id;

            RuRo.Model.ExamineInfo model=new RuRo.Model.ExamineInfo();
            DataSet ds=DbHelperSQL_SY.QuerySY(strSql.ToString(),parameters);
            if(ds.Tables[0].Rows.Count>0)
            {
                return DataRowToModel(ds.Tables[0].Rows[0]);
            }
            else
            {
                return null;
            }
        }