using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using Microsoft.SharePoint;
using yesinda.yesindakms.sharepoint;
public partial class usercontrol_ImageList : System.Web.UI.UserControl
... {
public string ReturnValue = String.Empty;
public string FolderPath = "111";
protected void Page_Load(object sender, EventArgs e)
...{
if (!IsPostBack)
...{
GetFolder();
BindGrid();
}
}
/// <summary>
/// 建立資料源
/// </summary>
/// <returns></returns>
ICollection CreateDataSource()
...{
DataTable dt = new DataTable(); //建立一個名為mytable的DataTable對象形
DataColumn dc = new DataColumn(); //建立一個列對象
dc.DataType = System.Type.GetType("System.Int32"); //指定該列的資料類型
dc.AutoIncrement = true; //該列為自動增漲列
dc.AutoIncrementSeed = 1; //初始值
dc.AutoIncrementStep = 2; //增量
dc.Caption = "id"; //設定列的标題
dc.ColumnName = "序号"; //設定 列集合對象中的列的名稱,datagrid中顯示該列名.
dc.Unique = true; //為此列建立唯一性約
dc.AllowDBNull = false; //不允許為空
dt.Columns.Add(dc); //将該列對象加入到表mytable的列集合中
//普通列
DataColumn dc1 = new DataColumn();
dc1.DataType = System.Type.GetType("System.String");
dc1.AllowDBNull = false;
dc1.Caption = "path";
dc1.ColumnName = "路徑";
dc1.DefaultValue = 25;
dt.Columns.Add(dc1);
DataColumn dc2 = new DataColumn();
dc2.DataType = System.Type.GetType("System.String");
dc2.AllowDBNull = false;
dc2.Caption = "path";
dc2.ColumnName = "完整路徑";
dc2.DefaultValue = 25;
dt.Columns.Add(dc2);
SPSite sps = yesinda.yesindakms.sharepoint.List.ListLib.findParamSite("/sites/TQOA/", this.Context);
sps.AllowUnsafeUpdates = true;
SPWeb spw = sps.OpenWeb();
spw.AllowUnsafeUpdates = true;
SPList list = spw.Lists["圖檔"];
SPFolder folder = list.RootFolder;
SPFolderCollection folder2 = list.RootFolder.SubFolders;
foreach (SPFolder folder3 in list.RootFolder.SubFolders)
...{
if (folder3.Name != "")
...{
if (folder3.Name == "111")
...{
foreach (SPFile file in folder3.Files)
...{
if (dt != null)
...{
DataRow dr = dt.NewRow();
dr[0] = file.Item.ID;
dr[1] = file.Name;
dr[2] = "http://" + sps.HostName + file.ServerRelativeUrl;
dt.Rows.Add(dr);
}
}
}
}
}
DataView dv = new DataView(dt);
return dv;
}
///擷取圖檔庫下的檔案夾
public void GetFolder()
...{
SPSite sps = yesinda.yesindakms.sharepoint.List.ListLib.findParamSite("/sites/TQOA/", this.Context);
sps.AllowUnsafeUpdates = true;
SPWeb spw = sps.OpenWeb();
spw.AllowUnsafeUpdates = true;
SPList list = spw.Lists["圖檔"];
SPFolder folder = list.RootFolder;
foreach (SPFolder folder3 in list.RootFolder.SubFolders)
...{
if (folder3.Name.IndexOf("_") != 0)
...{
this.ddlSelect.Items.Add(folder3.Name);
}
}
}
/// <summary>
/// 綁定GridView控件
/// </summary>
public void BindGrid()
...{
this.GridView1.DataKeyNames = new string[] ...{ "序号" };
this.GridView1.DataSource = CreateDataSource();
this.GridView1.DataBind();
this.ddlCurrentPage.Items.Clear();
for (int i = 1; i <= this.GridView1.PageCount; i++)
...{
this.ddlCurrentPage.Items.Add(i.ToString());
}
if (this.GridView1.PageIndex != 0)
...{
this.ddlCurrentPage.SelectedIndex = this.GridView1.PageIndex;
}
}
protected void btnUpImage_Click(object sender, EventArgs e)
...{
AddImage();
}
上傳圖檔#region 上傳圖檔
//儲存圖檔路徑
public static string ImageUrl = String.Empty;
/// <summary>
/// 上傳圖檔到圖檔庫
/// </summary>
public void AddImage()
...{
if (File1.Value != "")
...{
//上傳附件添加到文檔庫，并傳回ID，賦給model.Mattachment
string filename = File1.PostedFile.FileName.Substring(File1.PostedFile.FileName.LastIndexOf("/") + 1);
Stream filedataStream = File1.PostedFile.InputStream;
int dataLen = File1.PostedFile.ContentLength;
string fileType = File1.PostedFile.ContentType;
byte[] fileData = new byte[dataLen];
filedataStream.Read(fileData, 0, dataLen);
SPSite sps = yesinda.yesindakms.sharepoint.List.ListLib.findParamSite("/sites/TQOA/", this.Context);
sps.AllowUnsafeUpdates = true;
SPWeb spw = sps.OpenWeb();
spw.AllowUnsafeUpdates = true;
SPList list = spw.Lists["圖檔"];
SPFolder folder = list.RootFolder;
SPFolderCollection folder2 = list.RootFolder.SubFolders;
foreach (SPFolder folder3 in list.RootFolder.SubFolders)
...{
if (folder3.Name == "111")
...{
bool ex = false;
if (folder.Exists)
...{
try
...{
ex = folder3.Files[filename].Exists;
Response.Write("<script language="javascript">alert('已有相同名稱的檔案存在');</script>");
return;
}
catch
...{
folder3.Files.Add(filename, fileData, true);
ImageUrl = "http://" + sps.HostName + folder3.ServerRelativeUrl + "/" + filename;
}
}
}
}
Response.Write("<script>window.returnValue='" + ImageUrl + "';window.close();</script>");
}
}
#endregion
//全選
protected void CheckAll(object sender, EventArgs e)
...{
CheckBox cbx = (CheckBox)sender;
foreach (GridViewRow gvr in GridView1.Rows)
...{
CheckBox ch = (CheckBox)gvr.FindControl("ItemCheckBox");
ch.Checked = cbx.Checked;
}
}
/// <summary>
/// 将圖檔庫中的圖檔插入到文本中
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void btnOutPut_Click(object sender, EventArgs e)
...{
SPSite sps = yesinda.yesindakms.sharepoint.List.ListLib.findParamSite("/sites/TQOA/", this.Context);
sps.AllowUnsafeUpdates = true;
SPWeb spw = sps.OpenWeb();
spw.AllowUnsafeUpdates = true;
SPList list = spw.Lists["圖檔"];
string ReturnString = String.Empty;
foreach (GridViewRow gvr in this.GridView1.Rows)
...{
CheckBox ch = (CheckBox)gvr.FindControl("ItemCheckBox");
if (ch.Checked)
...{
SPListItem listcon = list.Items.GetItemById(Convert.ToInt32(GridView1.DataKeys[gvr.RowIndex].Value.ToString()));
ReturnString += sps.Url + "/" + listcon.Url;
}
}
Response.Write("<script>window.returnValue='" + ReturnString + "';window.close();</script>");
}
protected void radbtnUpload_SelectedIndexChanged(object sender, EventArgs e)
...{
if (this.radbtnUpload.SelectedIndex == 0)
...{
this.Panel1.Visible = true;
this.Panel2.Visible = false;
}
else
...{
this.Panel1.Visible = false;
this.Panel2.Visible = true;
}
}
protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
...{
e.Row.Cells[2].Attributes.Add("style", "display:none");
e.Row.Cells[1].Attributes.Add("style", "display:none");
//滑過GridView控件顯示不同顔色
if (e.Row.RowType == DataControlRowType.DataRow)
...{
e.Row.Attributes.Add("onmouseover", "c=this.style.backgroundColor;this.style.backgroundColor='#f0ffff';javascript:document.getElementById('imgshow').src='" + e.Row.Cells[2].Text + "';");
e.Row.Attributes.Add("onmouseout", "this.style.backgroundColor=c");
}
this.lblCurrentPage.Text = string.Format("目前第{0}頁/總共{1}頁", this.GridView1.PageIndex + 1, this.GridView1.PageCount);
}
protected void lnkbtnFrist_Click(object sender, EventArgs e)
...{
//顯示首頁
this.GridView1.PageIndex = 0;
BindGrid();
}
protected void lnkbtnPre_Click(object sender, EventArgs e)
...{
//顯示上一頁
if (this.GridView1.PageIndex > 0)
...{
this.GridView1.PageIndex = this.GridView1.PageIndex - 1;
BindGrid();
}
}
protected void lnkbtnNext_Click(object sender, EventArgs e)
...{
//顯示下一頁
if (this.GridView1.PageIndex < this.GridView1.PageCount)
...{
this.GridView1.PageIndex = this.GridView1.PageIndex + 1;
BindGrid();
}
}
protected void lnkbtnLast_Click(object sender, EventArgs e)
...{
//顯示最後一頁
this.GridView1.PageIndex = this.GridView1.PageCount;
BindGrid();
}
protected void ddlName_SelectedIndexChanged(object sender, EventArgs e)
...{
//選擇指定頁顯示
this.GridView1.PageIndex = this.ddlCurrentPage.SelectedIndex;
BindGrid();
}
protected void lnkSelect_Command(object sender, CommandEventArgs e)
...{
LinkButton lb = (LinkButton)sender;
DataControlFieldCell dcf = (DataControlFieldCell)lb.Parent;
GridViewRow gvr = (GridViewRow)dcf.Parent;
GridView1.SelectedIndex = gvr.RowIndex;
Response.Write("<script>window.returnValue='"+gvr.Cells[2].Text+"';window.close();</script>");
}
protected void ddlSelect_SelectedIndexChanged(object sender, EventArgs e)
...{
}
}