/// <summary> /// 得到一个对象实体 /// </summary> public la.Model.album DataRowToModel(DataRow row) { la.Model.album model=new la.Model.album(); if (row != null) { if(row["album_id"]!=null && row["album_id"].ToString()!="") { model.album_id=int.Parse(row["album_id"].ToString()); } if(row["user_telphone"]!=null) { model.user_telphone=row["user_telphone"].ToString(); } if(row["album_time"]!=null && row["album_time"].ToString()!="") { model.album_time=DateTime.Parse(row["album_time"].ToString()); } if(row["album_comment"]!=null) { model.album_comment=row["album_comment"].ToString(); } if(row["album_isvalid"]!=null && row["album_isvalid"].ToString()!="") { if((row["album_isvalid"].ToString()=="1")||(row["album_isvalid"].ToString().ToLower()=="true")) { model.album_isvalid=true; } else { model.album_isvalid=false; } } if(row["album_isprivate"]!=null && row["album_isprivate"].ToString()!="") { if((row["album_isprivate"].ToString()=="1")||(row["album_isprivate"].ToString().ToLower()=="true")) { model.album_isprivate=true; } else { model.album_isprivate=false; } } } return model; }
protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtalbum_id.Text)) { strErr+="相册_id格式错误!\\n"; } if(this.txtuser_telphone.Text.Trim().Length==0) { strErr+="用户Phone不能为空!\\n"; } if(!PageValidate.IsDateTime(txtalbum_time.Text)) { strErr+="相册上传时间格式错误!\\n"; } if(this.txtalbum_comment.Text.Trim().Length==0) { strErr+="相册说明不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int album_id=int.Parse(this.txtalbum_id.Text); string user_telphone=this.txtuser_telphone.Text; DateTime album_time=DateTime.Parse(this.txtalbum_time.Text); string album_comment=this.txtalbum_comment.Text; bool album_isvalid=this.chkalbum_isvalid.Checked; bool album_isprivate=this.chkalbum_isprivate.Checked; la.Model.album model=new la.Model.album(); model.album_id=album_id; model.user_telphone=user_telphone; model.album_time=album_time; model.album_comment=album_comment; model.album_isvalid=album_isvalid; model.album_isprivate=album_isprivate; la.BLL.album bll=new la.BLL.album(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public la.Model.album GetModel(int album_id,string user_telphone) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 album_id,user_telphone,album_time,album_comment,album_isvalid,album_isprivate from album "); strSql.Append(" where album_id=@album_id and user_telphone=@user_telphone "); SqlParameter[] parameters = { new SqlParameter("@album_id", SqlDbType.Int,4), new SqlParameter("@user_telphone", SqlDbType.VarChar,20) }; parameters[0].Value = album_id; parameters[1].Value = user_telphone; la.Model.album model=new la.Model.album(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }