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