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);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public NoName.NetShop.Vote.Model.VoteItem ReaderBind(IDataReader dataReader)
{
NoName.NetShop.Vote.Model.VoteItem model = new NoName.NetShop.Vote.Model.VoteItem();
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;
}
ojb = dataReader["ItemId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ItemId = (int)ojb;
}
model.ItemContent = dataReader["ItemContent"].ToString();
ojb = dataReader["VoteCount"];
if (ojb != null && ojb != DBNull.Value)
{
model.VoteCount = (int)ojb;
}
return(model);
}
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.VoteItem model)
{
if (model.ItemId == 0)
{
model.ItemId = NoName.NetShop.Common.CommDataHelper.GetNewSerialNum(AppType.Other);
}
Database db = CommDataAccess.DbWriter;
DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteItem_Save");
db.AddInParameter(dbCommand, "ItemGroupId", DbType.Int32, model.ItemGroupId);
db.AddInParameter(dbCommand, "VoteId", DbType.Int32, model.VoteId);
db.AddInParameter(dbCommand, "ItemId", DbType.Int32, model.ItemId);
db.AddInParameter(dbCommand, "ItemContent", DbType.AnsiString, model.ItemContent);
db.ExecuteNonQuery(dbCommand);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public NoName.NetShop.Vote.Model.VoteItem GetModel(int ItemId)
{
Database db = CommDataAccess.DbReader;
DbCommand dbCommand = db.GetStoredProcCommand("UP_voVoteItem_GetModel");
db.AddInParameter(dbCommand, "ItemId", DbType.Int32, ItemId);
NoName.NetShop.Vote.Model.VoteItem model = null;
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
if (dataReader.Read())
{
model = ReaderBind(dataReader);
}
}
return(model);
}
