Beispiel #1
0
 /// <summary>
 /// 得到一个对象实体
 /// </summary>
 public RuRo.Model.FP_UserFields DataRowToModel(DataRow row)
 {
     RuRo.Model.FP_UserFields model=new RuRo.Model.FP_UserFields();
     if (row != null)
     {
         if(row["userFieldId"]!=null && row["userFieldId"].ToString()!="")
         {
             model.userFieldId=int.Parse(row["userFieldId"].ToString());
         }
         if(row["id"]!=null && row["id"].ToString()!="")
         {
             model.id=int.Parse(row["id"].ToString());
         }
         if(row["obj_id"]!=null && row["obj_id"].ToString()!="")
         {
             model.obj_id=int.Parse(row["obj_id"].ToString());
         }
         if(row["display_name"]!=null)
         {
             model.display_name=row["display_name"].ToString();
         }
         if(row["name"]!=null)
         {
             model.name=row["name"].ToString();
         }
         if(row["type"]!=null)
         {
             model.type=row["type"].ToString();
         }
         if(row["values"]!=null)
         {
             model.values=row["values"].ToString();
         }
         if(row["show"]!=null)
         {
             model.show=row["show"].ToString();
         }
         if(row["created_at"]!=null)
         {
             model.created_at=row["created_at"].ToString();
         }
         if(row["updated_at"]!=null)
         {
             model.updated_at=row["updated_at"].ToString();
         }
         if(row["inuse"]!=null)
         {
             model.inuse=row["inuse"].ToString();
         }
     }
     return model;
 }
Beispiel #2
0
        protected void btnSave_Click(object sender, EventArgs e)
        {
            string strErr="";
            if(!PageValidate.IsNumber(txtid.Text))
            {
                strErr+="id格式错误!\\n";
            }
            if(!PageValidate.IsNumber(txtobj_id.Text))
            {
                strErr+="obj_id格式错误!\\n";
            }
            if(this.txtdisplay_name.Text.Trim().Length==0)
            {
                strErr+="display_name不能为空!\\n";
            }
            if(this.txtname.Text.Trim().Length==0)
            {
                strErr+="name不能为空!\\n";
            }
            if(this.txttype.Text.Trim().Length==0)
            {
                strErr+="type不能为空!\\n";
            }
            if(this.txtvalues.Text.Trim().Length==0)
            {
                strErr+="values不能为空!\\n";
            }
            if(this.txtshow.Text.Trim().Length==0)
            {
                strErr+="show不能为空!\\n";
            }
            if(this.txtcreated_at.Text.Trim().Length==0)
            {
                strErr+="created_at不能为空!\\n";
            }
            if(this.txtupdated_at.Text.Trim().Length==0)
            {
                strErr+="updated_at不能为空!\\n";
            }
            if(this.txtinuse.Text.Trim().Length==0)
            {
                strErr+="inuse不能为空!\\n";
            }

            if(strErr!="")
            {
                MessageBox.Show(this,strErr);
                return;
            }
            int id=int.Parse(this.txtid.Text);
            int obj_id=int.Parse(this.txtobj_id.Text);
            string display_name=this.txtdisplay_name.Text;
            string name=this.txtname.Text;
            string type=this.txttype.Text;
            string values=this.txtvalues.Text;
            string show=this.txtshow.Text;
            string created_at=this.txtcreated_at.Text;
            string updated_at=this.txtupdated_at.Text;
            string inuse=this.txtinuse.Text;

            RuRo.Model.FP_UserFields model=new RuRo.Model.FP_UserFields();
            model.id=id;
            model.obj_id=obj_id;
            model.display_name=display_name;
            model.name=name;
            model.type=type;
            model.values=values;
            model.show=show;
            model.created_at=created_at;
            model.updated_at=updated_at;
            model.inuse=inuse;

            RuRo.BLL.FP_UserFields bll=new RuRo.BLL.FP_UserFields();
            bll.Add(model);
            Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx");
        }
Beispiel #3
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public RuRo.Model.FP_UserFields GetModel(int userFieldId)
        {
            StringBuilder strSql=new StringBuilder();
            strSql.Append("select  top 1 userFieldId,id,obj_id,display_name,name,type,values,show,created_at,updated_at,inuse from FP_UserFields ");
            strSql.Append(" where userFieldId=@userFieldId");
            SqlParameter[] parameters = {
                    new SqlParameter("@userFieldId", SqlDbType.Int,4)
            };
            parameters[0].Value = userFieldId;

            RuRo.Model.FP_UserFields model=new RuRo.Model.FP_UserFields();
            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;
            }
        }