public string getExport() { StringBuilder stringBuilder = new StringBuilder(); dt_expert dtExpert = new dt_expert(); DataSet dt = dtExpert.GetListTop(10, ""); DataTable dtImg = new DataTable(); HyFileatt hyFileatt = new HyFileatt(); if (dt.Tables[0].Rows.Count > 0) { for (int i = 0; i < dt.Tables[0].Rows.Count; i++) { dtImg = hyFileatt.Getdocsfm(dt.Tables[0].Rows[i]["ID"].ToString()); stringBuilder.Append("<li><a target=\"_blank\" href=\"showExportMain.aspx?docid=" + dt.Tables[0].Rows[i]["ID"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\">"); if (dtImg.Rows.Count > 0) { stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">"); } else { stringBuilder.Append("<img src=\"Images/Img.jpg\">"); } dtImg.Clear(); stringBuilder.Append("</a></li>"); } } return stringBuilder.ToString(); }
protected void btn_save_Click(object sender, EventArgs e) { dt_expert dt_expert = new dt_expert(); dt_expert.ID = this.txtDocid.Value; dt_expert.dt_type = this.txtdt_type.Value; dt_expert.dt_name = this.txtdt_name.Text; dt_expert.dt_email = this.txtdt_email.Text; dt_expert.dt_phone = this.txtdt_phone.Text; dt_expert.dt_address = this.txtdt_address.Text; dt_expert.dt_summary = this.txtdt_summary.Value; dt_expert.field = ""; if (this.txtop.Value == "add") { dt_expert.Add(); } else if (this.txtop.Value == "modify") { dt_expert.ID = this.txtDocid.Value; dt_expert.Update(); } //写日志 HyCommon HyCommon = new HyCommon(); HyCommon.WriteLog("修改", "修改文章记录[id:" + this.txtDocid.Value + "]", Session["uid"].ToString(), Session["uname"].ToString()); //提示并跳转 ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>success();</script>"); }
protected void Page_Load(object sender, EventArgs e) { StringBuilder stringBuilder = new StringBuilder(); dt_expert dtExpert = new dt_expert(); DataSet dt = dtExpert.GetList(""); DataTable dtImg = new DataTable(); HyFileatt hyFileatt = new HyFileatt(); //控制数据条数 int s = 0; if (dt.Tables[0].Rows.Count > 0) { //分行 int n = 0; if ((dt.Tables[0].Rows.Count) % 4 == 0) { n = (dt.Tables[0].Rows.Count) / (4); } else { n = ((dt.Tables[0].Rows.Count) / (4)) + 1; } //构造列 for (int i = 0; i < n; ++i) { stringBuilder.Append("<ul>"); //控制循环条件 int m = 0; if ((dt.Tables[0].Rows.Count - (i * 4)) > 4) { m = 4; } else { m = dt.Tables[0].Rows.Count - (i * 4); } for (int j = 0; j < m; j++) { dtImg = hyFileatt.Getdocsfm(dt.Tables[0].Rows[s]["ID"].ToString()); stringBuilder.Append("<li><a href=\"showExportMain.aspx?docid=" + dt.Tables[0].Rows[s]["ID"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\">"); if (dtImg.Rows.Count > 0) { stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">"); } else { stringBuilder.Append("<img src=\"Images/Img.jpg\">"); } dtImg.Clear(); stringBuilder.Append("<dt align=\"center\" >" + dt.Tables[0].Rows[s]["dt_name"].ToString() + "</dt></a></li>"); s++; } stringBuilder.Append("</ul>"); } } this.lb_show.Text = stringBuilder.ToString(); }
//批量删除 protected void btndelinfo_Click(object sender, EventArgs e) { HyCommon HyCommon = new HyCommon(); dt_expert dt_expert = new dt_expert(); String[] v_uids = this.txtuids.Value.Split(','); for (int i = 0; i < v_uids.Length; i++) { dt_expert.ID = v_uids[i]; dt_expert.Delete(); } string pageUrl = HyCommon.CombUrlTxt("exportList.aspx", "page={0}&rnd={1}", "" + this.txtPage.Text + "", "" + System.Guid.NewGuid().ToString() + ""); ClientScript.RegisterStartupScript(ClientScript.GetType(), "myscript", "<script>tip('数据已经被成功删除!','" + pageUrl + "');</script>"); }
protected void Page_Load(object sender, EventArgs e) { if (this.Request.QueryString["docid"] != null) { strDocid = this.Request.QueryString["docid"].ToString(); } StringBuilder stringBuilder = new StringBuilder(); dt_expert dtExpert = new dt_expert(); dtExpert.ID = strDocid; DataSet dt = dtExpert.GetListById(); DataTable dtImg = new DataTable(); HyFileatt hyFileatt = new HyFileatt(); dtImg = hyFileatt.Getdocsfm(strDocid); stringBuilder.Append("<div class=\"exp_Bottom\">"); if (dt.Tables[0].Rows.Count > 0 && dtImg.Rows.Count > 0) { stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">"); stringBuilder.Append("<span>" + dt.Tables[0].Rows[0]["dt_name"].ToString() + "</span><p>"); stringBuilder.Append(dt.Tables[0].Rows[0]["dt_summary"].ToString()); } stringBuilder.Append("</p></div>"); this.lb_show.Text = stringBuilder.ToString(); }
protected void Page_Load(object sender, EventArgs e) { if (this.Request.QueryString["page"] != null) { try { pageNo = Convert.ToInt32(this.Request.QueryString["page"].ToString()); } catch { pageNo = 1; } } StringBuilder stringBuilder = new StringBuilder(); dt_expert dtExpert = new dt_expert(); DataSet dt = dtExpert.GetListPage(pageNo, pageSize, ""); DataSet dtDataSet = dtExpert.GetList(""); totalPage = dtDataSet.Tables[0].Rows.Count / pageSize; if (dtDataSet.Tables[0].Rows.Count % pageSize > 0) { totalPage++; } this.lb_page.Text = HyCommon.page("\"#Pagle\"", pageNo.ToString(), pageSize.ToString(), totalPage.ToString(), ""); DataTable dtImg = new DataTable(); HyFileatt hyFileatt = new HyFileatt(); //控制数据条数 int s = 0; if (dt.Tables[0].Rows.Count > 0) { //分行 int n = 0; if ((dt.Tables[0].Rows.Count) % 4 == 0) { n = (dt.Tables[0].Rows.Count) / (4); } else { n = ((dt.Tables[0].Rows.Count) / (4)) + 1; } //构造列 for (int i = 0; i < n; ++i) { stringBuilder.Append("<ul>"); //控制循环条件 int m = 0; if ((dt.Tables[0].Rows.Count - (i * 4)) > 4) { m = 4; } else { m = dt.Tables[0].Rows.Count - (i * 4); } for (int j = 0; j < m; j++) { dtImg = hyFileatt.Getdocsfm(dt.Tables[0].Rows[s]["ID"].ToString()); stringBuilder.Append("<li><a href=\"showExportMain.aspx?docid=" + dt.Tables[0].Rows[s]["ID"].ToString() + "&rend=" + System.Guid.NewGuid().ToString() + "\">"); if (dtImg.Rows.Count > 0) { stringBuilder.Append("<img src=\"" + dtImg.Rows[0]["hy_filepath"].ToString() + "\">"); } else { stringBuilder.Append("<img src=\"Images/Img.jpg\">"); } dtImg.Clear(); stringBuilder.Append("<dt align=\"center\" >" + dt.Tables[0].Rows[s]["dt_name"].ToString() + "</dt></a></li>"); s++; } stringBuilder.Append("</ul>"); } } this.lb_show.Text = stringBuilder.ToString(); }
// 数据绑定 private void RptBind() { HyCommon HyCommon = new HyCommon(); //获取当前页数 if (this.Request.QueryString["page"] != null) { this.page = int.Parse(HyCommon.Filter(this.Request.QueryString["page"].ToString())); } this.txtPageNum.Text = this.pageSize.ToString(); dt_expert dtExpert = new dt_expert(); string strWhere = ""; if (this.txtNmae.Text.Trim() != "") { strWhere += " and dt_name like '%" + this.txtNmae.Text.Trim() + "%'"; } //获取数据 DataSet dt = dtExpert.GetDataPage(this.pageSize, this.page, strWhere); //获取数据条数 this.totalCount = dtExpert.GetList(strWhere).Tables[0].Rows.Count; this.lblcount.Text = totalCount.ToString(); rptList.DataSource = dt; rptList.DataBind(); //地址传递数据 string pageUrl = HyCommon.CombUrlTxt(ls_url, "page={0}&rnd={1}&txtNmae={2}", "__id__", System.Guid.NewGuid().ToString(), this.txtNmae.Text); PageContent.InnerHtml = HyCommon.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void dataShow() { //旧文档 将数据显示出来 if (this.txtop.Value == "modify") { dt_expert dtExpert = new dt_expert(); dtExpert.ID = this.txtDocid.Value; DataSet dataSet = dtExpert.GetListById(); if (dataSet.Tables[0].Rows.Count > 0) { this.txtdt_type.Value = dataSet.Tables[0].Rows[0]["dt_type"].ToString(); this.txtdt_name.Text = dataSet.Tables[0].Rows[0]["dt_name"].ToString(); this.txtdt_email.Text = dataSet.Tables[0].Rows[0]["dt_email"].ToString(); this.txtdt_phone.Text = dataSet.Tables[0].Rows[0]["dt_phone"].ToString(); this.txtdt_address.Text = dataSet.Tables[0].Rows[0]["dt_address"].ToString(); this.txtdt_summary.Value = dataSet.Tables[0].Rows[0]["dt_summary"].ToString(); } } }