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;
}
