/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Model.FavoriteModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.FavoriteModel model = new NoName.NetShop.Model.FavoriteModel();
object ojb;
ojb = dataReader["UserId"];
if (ojb != null && ojb != DBNull.Value)
{
model.UserId = (int)ojb;
}
ojb = dataReader["FavoriteId"];
if (ojb != null && ojb != DBNull.Value)
{
model.FavoriteId = (int)ojb;
}
model.FavoriteUrl = dataReader["FavoriteUrl"].ToString();
model.FavoriteName = dataReader["FavoriteName"].ToString();
ojb = dataReader["InsertTime"];
if (ojb != null && ojb != DBNull.Value)
{
model.InsertTime = (DateTime)ojb;
}
ojb = dataReader["ContentId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ContentId = (int)ojb;
}
ojb = dataReader["ContentType"];
if (ojb != null && ojb != DBNull.Value)
{
model.ContentType = (int)ojb;
}
return(model);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr = "";
if (!PageValidate.IsNumber(txtUserId.Text))
{
strErr += "UserId不是数字！\\n";
}
if (!PageValidate.IsNumber(txtFavoriteId.Text))
{
strErr += "FavoriteId不是数字！\\n";
}
if (this.txtFavoriteUrl.Text == "")
{
strErr += "FavoriteUrl不能为空！\\n";
}
if (this.txtFavoriteName.Text == "")
{
strErr += "FavoriteName不能为空！\\n";
}
if (!PageValidate.IsDateTime(txtInsertTime.Text))
{
strErr += "InsertTime不是时间格式！\\n";
}
if (!PageValidate.IsNumber(txtContentId.Text))
{
strErr += "ContentId不是数字！\\n";
}
if (!PageValidate.IsNumber(txtContentType.Text))
{
strErr += "ContentType不是数字！\\n";
}
if (strErr != "")
{
MessageBox.Show(this, strErr);
return;
}
int UserId = int.Parse(this.txtUserId.Text);
int FavoriteId = int.Parse(this.txtFavoriteId.Text);
string FavoriteUrl = this.txtFavoriteUrl.Text;
string FavoriteName = this.txtFavoriteName.Text;
DateTime InsertTime = DateTime.Parse(this.txtInsertTime.Text);
int ContentId = int.Parse(this.txtContentId.Text);
int ContentType = int.Parse(this.txtContentType.Text);
NoName.NetShop.Model.FavoriteModel model = new NoName.NetShop.Model.FavoriteModel();
model.UserId = UserId;
model.FavoriteId = FavoriteId;
model.FavoriteUrl = FavoriteUrl;
model.FavoriteName = FavoriteName;
model.InsertTime = InsertTime;
model.ContentId = ContentId;
model.ContentType = ContentType;
NoName.NetShop.BLL.FavoriteModelBll bll = new NoName.NetShop.BLL.FavoriteModelBll();
bll.Update(model);
}
protected void btnAdd_Click(object sender, EventArgs e)
{
string strErr="";
if(!PageValidate.IsNumber(txtUserId.Text))
{
strErr+="UserId�������֣�\\n";
}
if(!PageValidate.IsNumber(txtFavoriteId.Text))
{
strErr+="FavoriteId�������֣�\\n";
}
if(this.txtFavoriteUrl.Text =="")
{
strErr+="FavoriteUrl����Ϊ�գ�\\n";
}
if(this.txtFavoriteName.Text =="")
{
strErr+="FavoriteName����Ϊ�գ�\\n";
}
if(!PageValidate.IsDateTime(txtInsertTime.Text))
{
strErr+="InsertTime����ʱ���ʽ��\\n";
}
if(!PageValidate.IsNumber(txtContentId.Text))
{
strErr+="ContentId�������֣�\\n";
}
if(!PageValidate.IsNumber(txtContentType.Text))
{
strErr+="ContentType�������֣�\\n";
}
if(strErr!="")
{
MessageBox.Show(this,strErr);
return;
}
int UserId=int.Parse(this.txtUserId.Text);
int FavoriteId=int.Parse(this.txtFavoriteId.Text);
string FavoriteUrl=this.txtFavoriteUrl.Text;
string FavoriteName=this.txtFavoriteName.Text;
DateTime InsertTime=DateTime.Parse(this.txtInsertTime.Text);
int ContentId=int.Parse(this.txtContentId.Text);
int ContentType=int.Parse(this.txtContentType.Text);
NoName.NetShop.Model.FavoriteModel model=new NoName.NetShop.Model.FavoriteModel();
model.UserId=UserId;
model.FavoriteId=FavoriteId;
model.FavoriteUrl=FavoriteUrl;
model.FavoriteName=FavoriteName;
model.InsertTime=InsertTime;
model.ContentId=ContentId;
model.ContentType=ContentType;
NoName.NetShop.BLL.FavoriteModelBll bll=new NoName.NetShop.BLL.FavoriteModelBll();
bll.Add(model);
}
private void ShowInfo()
{
NoName.NetShop.BLL.FavoriteModelBll bll = new NoName.NetShop.BLL.FavoriteModelBll();
NoName.NetShop.Model.FavoriteModel model = bll.GetModel();
this.txtUserId.Text = model.UserId.ToString();
this.txtFavoriteId.Text = model.FavoriteId.ToString();
this.txtFavoriteUrl.Text = model.FavoriteUrl;
this.txtFavoriteName.Text = model.FavoriteName;
this.txtInsertTime.Text = model.InsertTime.ToString();
this.txtContentId.Text = model.ContentId.ToString();
this.txtContentType.Text = model.ContentType.ToString();
}
/// <summary>
/// 更新一条数据
/// </summary>
public void Update(NoName.NetShop.Model.FavoriteModel model)
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_umFavorite_Update");
db.AddInParameter(dbCommand, "UserId", DbType.Int32, model.UserId);
db.AddInParameter(dbCommand, "FavoriteId", DbType.Int32, model.FavoriteId);
db.AddInParameter(dbCommand, "FavoriteUrl", DbType.AnsiString, model.FavoriteUrl);
db.AddInParameter(dbCommand, "FavoriteName", DbType.AnsiString, model.FavoriteName);
db.AddInParameter(dbCommand, "InsertTime", DbType.DateTime, model.InsertTime);
db.AddInParameter(dbCommand, "ContentId", DbType.Int32, model.ContentId);
db.AddInParameter(dbCommand, "ContentType", DbType.Byte, model.ContentType);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Model.FavoriteModel GetModel()
{
Database db = DatabaseFactory.CreateDatabase();
DbCommand dbCommand = db.GetStoredProcCommand("UP_umFavorite_GetModel");
NoName.NetShop.Model.FavoriteModel model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
/// <summary>
/// ����ʵ�������
/// </summary>
public NoName.NetShop.Model.FavoriteModel ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Model.FavoriteModel model=new NoName.NetShop.Model.FavoriteModel();
object ojb;
ojb = dataReader["UserId"];
if(ojb != null && ojb != DBNull.Value)
{
model.UserId=(int)ojb;
}
ojb = dataReader["FavoriteId"];
if(ojb != null && ojb != DBNull.Value)
{
model.FavoriteId=(int)ojb;
}
model.FavoriteUrl=dataReader["FavoriteUrl"].ToString();
model.FavoriteName=dataReader["FavoriteName"].ToString();
ojb = dataReader["InsertTime"];
if(ojb != null && ojb != DBNull.Value)
{
model.InsertTime=(DateTime)ojb;
}
ojb = dataReader["ContentId"];
if(ojb != null && ojb != DBNull.Value)
{
model.ContentId=(int)ojb;
}
ojb = dataReader["ContentType"];
if(ojb != null && ojb != DBNull.Value)
{
model.ContentType=(int)ojb;
}
return model;
}
