public List<Maticsoft.Model.Poll.Topics> GetModelList(string strWhere) { DataSet set = this.dal.GetList(strWhere); List<Maticsoft.Model.Poll.Topics> list = new List<Maticsoft.Model.Poll.Topics>(); int count = set.Tables[0].Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Poll.Topics item = new Maticsoft.Model.Poll.Topics(); if (set.Tables[0].Rows[i]["ID"].ToString() != "") { item.ID = int.Parse(set.Tables[0].Rows[i]["ID"].ToString()); } item.Title = set.Tables[0].Rows[i]["Title"].ToString(); if (set.Tables[0].Rows[i]["Type"].ToString() != "") { item.Type = new int?(int.Parse(set.Tables[0].Rows[i]["Type"].ToString())); } if (set.Tables[0].Rows[i]["FormID"].ToString() != "") { item.FormID = new int?(int.Parse(set.Tables[0].Rows[i]["FormID"].ToString())); } if (set.Tables[0].Rows[i]["RowNum"].ToString() != "") { item.RowNum = int.Parse(set.Tables[0].Rows[i]["RowNum"].ToString()); } list.Add(item); } } return list; }
protected void btnAdd_Click(object sender, EventArgs e) { string text = this.txtTitle.Text; int num = int.Parse(this.radbtnType.SelectedValue); int num2 = int.Parse(this.lblFormID.Text); Maticsoft.Model.Poll.Topics model = new Maticsoft.Model.Poll.Topics { Title = text, Type = new int?(num), FormID = new int?(num2) }; Maticsoft.BLL.Poll.Topics topics2 = new Maticsoft.BLL.Poll.Topics(); if (topics2.Exists(num2, text)) { MessageBox.ShowFailTip(this, Poll.ErrorTopicExists); } else { if (topics2.Add(model) > 0) { MessageBox.ShowSuccessTip(this, Site.TooltipSaveOK); } else { MessageBox.ShowFailTip(this, Site.TooltipSaveError); } this.Session["strWhereTopics"] = " FormID= " + this.lblFormID.Text; this.gridView.OnBind(); } }
public Maticsoft.Model.Poll.Topics GetModel(int ID) { StringBuilder builder = new StringBuilder(); builder.Append("select top 1 ID,Title,Type,FormID from Poll_Topics "); builder.Append(" where ID=@ID "); SqlParameter[] cmdParms = new SqlParameter[] { new SqlParameter("@ID", SqlDbType.Int, 4) }; cmdParms[0].Value = ID; Maticsoft.Model.Poll.Topics topics = new Maticsoft.Model.Poll.Topics(); DataSet set = DbHelperSQL.Query(builder.ToString(), cmdParms); if (set.Tables[0].Rows.Count <= 0) { return null; } if (set.Tables[0].Rows[0]["ID"].ToString() != "") { topics.ID = int.Parse(set.Tables[0].Rows[0]["ID"].ToString()); } topics.Title = set.Tables[0].Rows[0]["Title"].ToString(); if (set.Tables[0].Rows[0]["Type"].ToString() != "") { topics.Type = new int?(int.Parse(set.Tables[0].Rows[0]["Type"].ToString())); } if (set.Tables[0].Rows[0]["FormID"].ToString() != "") { topics.FormID = new int?(int.Parse(set.Tables[0].Rows[0]["FormID"].ToString())); } return topics; }
public List<Maticsoft.Model.Poll.Topics> GetModelList(int Top, int formid) { Maticsoft.Model.Poll.Forms modelByCache = new Maticsoft.BLL.Poll.Forms().GetModelByCache(formid); if ((modelByCache == null) || !modelByCache.IsActive) { return null; } DataSet set = this.dal.GetList(Top, string.Format(" Type in (0,1) and FormID={0} ", formid), " ORDER BY ID ASC "); List<Maticsoft.Model.Poll.Topics> list = new List<Maticsoft.Model.Poll.Topics>(); int count = set.Tables[0].Rows.Count; if (count > 0) { for (int i = 0; i < count; i++) { Maticsoft.Model.Poll.Topics item = new Maticsoft.Model.Poll.Topics(); if (set.Tables[0].Rows[i]["ID"].ToString() != "") { item.ID = int.Parse(set.Tables[0].Rows[i]["ID"].ToString()); } item.Title = set.Tables[0].Rows[i]["Title"].ToString(); if (set.Tables[0].Rows[i]["Type"].ToString() != "") { item.Type = new int?(int.Parse(set.Tables[0].Rows[i]["Type"].ToString())); } if (set.Tables[0].Rows[i]["FormID"].ToString() != "") { item.FormID = new int?(int.Parse(set.Tables[0].Rows[i]["FormID"].ToString())); } list.Add(item); } } return list; }