protected void btnSave_Click(object sender, EventArgs e) { string strErr=""; if(!PageValidate.IsNumber(txtvirtualgoods_ID.Text)) { strErr+="虚拟物品ID格式错误!\\n"; } if(this.txtvirtualgoods_name.Text.Trim().Length==0) { strErr+="虚拟物品名称不能为空!\\n"; } if(!PageValidate.IsDecimal(txtvirtualgoods_price.Text)) { strErr+="虚拟物品价格格式错误!\\n"; } if(this.txtvirtualgoods_comment.Text.Trim().Length==0) { strErr+="虚拟物品说明不能为空!\\n"; } if(this.txtvirtualgoods_pic_url.Text.Trim().Length==0) { strErr+="虚拟物品图片不能为空!\\n"; } if(this.txtvirtualgoods_type.Text.Trim().Length==0) { strErr+="虚拟物品类别不能为空!\\n"; } if(this.txtvirtualgoods_fun.Text.Trim().Length==0) { strErr+="虚拟物品功能不能为空!\\n"; } if(strErr!="") { MessageBox.Show(this,strErr); return; } int virtualgoods_ID=int.Parse(this.txtvirtualgoods_ID.Text); string virtualgoods_name=this.txtvirtualgoods_name.Text; decimal virtualgoods_price=decimal.Parse(this.txtvirtualgoods_price.Text); string virtualgoods_comment=this.txtvirtualgoods_comment.Text; string virtualgoods_pic_url=this.txtvirtualgoods_pic_url.Text; string virtualgoods_type=this.txtvirtualgoods_type.Text; string virtualgoods_fun=this.txtvirtualgoods_fun.Text; la.Model.virtualgoods model=new la.Model.virtualgoods(); model.virtualgoods_ID=virtualgoods_ID; model.virtualgoods_name=virtualgoods_name; model.virtualgoods_price=virtualgoods_price; model.virtualgoods_comment=virtualgoods_comment; model.virtualgoods_pic_url=virtualgoods_pic_url; model.virtualgoods_type=virtualgoods_type; model.virtualgoods_fun=virtualgoods_fun; la.BLL.virtualgoods bll=new la.BLL.virtualgoods(); bll.Add(model); Maticsoft.Common.MessageBox.ShowAndRedirect(this,"保存成功!","add.aspx"); }
/// <summary> /// 得到一个对象实体 /// </summary> public la.Model.virtualgoods DataRowToModel(DataRow row) { la.Model.virtualgoods model=new la.Model.virtualgoods(); if (row != null) { if(row["virtualgoods_ID"]!=null && row["virtualgoods_ID"].ToString()!="") { model.virtualgoods_ID=int.Parse(row["virtualgoods_ID"].ToString()); } if(row["virtualgoods_name"]!=null) { model.virtualgoods_name=row["virtualgoods_name"].ToString(); } if(row["virtualgoods_price"]!=null && row["virtualgoods_price"].ToString()!="") { model.virtualgoods_price=decimal.Parse(row["virtualgoods_price"].ToString()); } if(row["virtualgoods_comment"]!=null) { model.virtualgoods_comment=row["virtualgoods_comment"].ToString(); } if(row["virtualgoods_pic_url"]!=null) { model.virtualgoods_pic_url=row["virtualgoods_pic_url"].ToString(); } if(row["virtualgoods_type"]!=null) { model.virtualgoods_type=row["virtualgoods_type"].ToString(); } if(row["virtualgoods_fun"]!=null) { model.virtualgoods_fun=row["virtualgoods_fun"].ToString(); } } return model; }
/// <summary> /// 得到一个对象实体 /// </summary> public la.Model.virtualgoods GetModel(int virtualgoods_ID) { StringBuilder strSql=new StringBuilder(); strSql.Append("select top 1 virtualgoods_ID,virtualgoods_name,virtualgoods_price,virtualgoods_comment,virtualgoods_pic_url,virtualgoods_type,virtualgoods_fun from virtualgoods "); strSql.Append(" where virtualgoods_ID=@virtualgoods_ID "); SqlParameter[] parameters = { new SqlParameter("@virtualgoods_ID", SqlDbType.Int,4) }; parameters[0].Value = virtualgoods_ID; la.Model.virtualgoods model=new la.Model.virtualgoods(); DataSet ds=DbHelperSQL.Query(strSql.ToString(),parameters); if(ds.Tables[0].Rows.Count>0) { return DataRowToModel(ds.Tables[0].Rows[0]); } else { return null; } }