protected void btnSave_Click(object sender, EventArgs e) { NoName.NetShop.Vote.BLL.VoteItemGroup gbll = new NoName.NetShop.Vote.BLL.VoteItemGroup(); NoName.NetShop.Vote.BLL.VoteItem ibll = new NoName.NetShop.Vote.BLL.VoteItem(); NoName.NetShop.Vote.Model.VoteItemGroup gmodel = gbll.GetModel(int.Parse(this.lblGroupId.Text)); if (gmodel == null) { gmodel = new NoName.NetShop.Vote.Model.VoteItemGroup(); gmodel.ItemGroupId = 0; gmodel.VoteId = int.Parse(lblVoteId.Text); } gmodel.Subject = txtSubject.Text.Trim(); gmodel.Content = txtContent.Text.Trim(); gbll.Save(gmodel); foreach (GridViewRow row in gvItems.Rows) { int itemId = int.Parse(gvItems.DataKeys[row.RowIndex].Values["ItemId"].ToString()); NoName.NetShop.Vote.Model.VoteItem imodel = ibll.GetModel(itemId); imodel.ItemContent = (row.FindControl("txtContent") as TextBox).Text.Trim(); ibll.Save(imodel); } Response.Redirect("ShowVoteInfo.aspx?voteId=" + gmodel.VoteId); }
protected void btnAdd_Click(object sender, EventArgs e) { NoName.NetShop.Vote.BLL.VoteItemGroup gbll = new NoName.NetShop.Vote.BLL.VoteItemGroup(); NoName.NetShop.Vote.BLL.VoteItem ibll = new NoName.NetShop.Vote.BLL.VoteItem(); NoName.NetShop.Vote.Model.VoteItemGroup gmodel = gbll.GetModel(int.Parse(lblGroupId.Text)); if (gmodel == null) { gmodel = new NoName.NetShop.Vote.Model.VoteItemGroup(); gmodel.ItemGroupId = 0; gmodel.VoteId = int.Parse(lblVoteId.Text); gmodel.Subject = txtSubject.Text.Trim(); gmodel.Content = txtContent.Text.Trim(); gbll.Save(gmodel); lblVoteId.Text = gmodel.VoteId.ToString(); lblGroupId.Text = gmodel.ItemGroupId.ToString(); } NoName.NetShop.Vote.Model.VoteItem imodel = new NoName.NetShop.Vote.Model.VoteItem(); imodel.ItemContent = String.Empty; imodel.ItemGroupId = gmodel.ItemGroupId; imodel.VoteId = gmodel.VoteId; imodel.ItemId = 0; ibll.Save(imodel); List <NoName.NetShop.Vote.Model.VoteItem> list = ibll.GetItemsOfGroup(int.Parse(lblGroupId.Text)); this.gvItems.DataSource = list; this.gvItems.DataBind(); }
/// <summary> /// 增加一条数据 /// </summary> public void Save(NoName.NetShop.Vote.Model.VoteItemGroup model) { if (model.ItemGroupId == 0) { model.ItemGroupId = NoName.NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Other); } Database db = CommDataAccess.DbWriter; DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteItemGroup_Save"); db.AddInParameter(dbCommand, "ItemGroupId", DbType.Int32, model.ItemGroupId); db.AddInParameter(dbCommand, "VoteId", DbType.Int32, model.VoteId); db.AddInParameter(dbCommand, "Subject", DbType.AnsiString, model.Subject); db.AddInParameter(dbCommand, "Content", DbType.AnsiString, model.Content); db.ExecuteNonQuery(dbCommand); }
/// <summary> /// 得到一个对象实体 /// </summary> public NoName.NetShop.Vote.Model.VoteItemGroup GetModel(int ItemGroupId) { Database db = CommDataAccess.DbReader; DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteItemGroup_GetModel"); db.AddInParameter(dbCommand, "ItemGroupId", DbType.Int32, ItemGroupId); NoName.NetShop.Vote.Model.VoteItemGroup model = null; using (IDataReader dataReader = db.ExecuteReader(dbCommand)) { if (dataReader.Read()) { model = ReaderBind(dataReader); } } return(model); }
/// <summary> /// 对象实体绑定数据 /// </summary> public NoName.NetShop.Vote.Model.VoteItemGroup ReaderBind(IDataReader dataReader) { NoName.NetShop.Vote.Model.VoteItemGroup model = new NoName.NetShop.Vote.Model.VoteItemGroup(); object ojb; ojb = dataReader["ItemGroupId"]; if (ojb != null && ojb != DBNull.Value) { model.ItemGroupId = (int)ojb; } ojb = dataReader["VoteId"]; if (ojb != null && ojb != DBNull.Value) { model.VoteId = (int)ojb; } model.Subject = dataReader["Subject"].ToString(); model.Content = dataReader["Content"].ToString(); return(model); }
private void ShowVoteGroupInfo(int groupId, int voteId) { NoName.NetShop.Vote.BLL.VoteItemGroup gbll = new NoName.NetShop.Vote.BLL.VoteItemGroup(); NoName.NetShop.Vote.BLL.VoteItem ibll = new NoName.NetShop.Vote.BLL.VoteItem(); NoName.NetShop.Vote.Model.VoteItemGroup gmodel = gbll.GetModel(groupId); if (gmodel != null) { this.txtContent.Text = gmodel.Content; this.txtSubject.Text = gmodel.Subject; this.lblGroupId.Text = gmodel.ItemGroupId.ToString(); this.lblVoteId.Text = gmodel.VoteId.ToString(); this.gvItems.DataSource = ibll.GetItemsOfGroup(groupId); this.gvItems.DataKeyNames = new string[] { "ItemId" }; this.gvItems.DataBind(); } else { this.lblVoteId.Text = voteId.ToString(); this.lblGroupId.Text = "0"; } }
/// <summary> /// ����ʵ������� /// </summary> public NoName.NetShop.Vote.Model.VoteItemGroup ReaderBind(IDataReader dataReader) { NoName.NetShop.Vote.Model.VoteItemGroup model=new NoName.NetShop.Vote.Model.VoteItemGroup(); object ojb; ojb = dataReader["ItemGroupId"]; if(ojb != null && ojb != DBNull.Value) { model.ItemGroupId=(int)ojb; } ojb = dataReader["VoteId"]; if(ojb != null && ojb != DBNull.Value) { model.VoteId=(int)ojb; } model.Subject=dataReader["Subject"].ToString(); model.Content=dataReader["Content"].ToString(); return model; }