private void IniData()
{
tvMain.Nodes.Clear();
TreeNode trNo = new TreeNode("内部文件");
trNo.ImageUrl = "~/Image/Folder.ico";
trNo.Target = "0";
tb_FolderService folderSer = new tb_FolderService();
List <tb_Folder> allFolder = folderSer.GetListArray("");
tb_AttachmentService ATTSer = new tb_AttachmentService();
List <tb_Attachment> atts = ATTSer.GetListArray_TV("");
for (int i = 0; i < atts.Count; i++)
{
tb_Folder fole = new tb_Folder();
fole.Type = "file";
fole.ParentId = Convert.ToInt32(atts[i].Folder_Id);
fole.Folder_NAME = atts[i].MainName + "(" + atts[i].createTime + ")";
fole.AttId1 = atts[i].id.ToString();
fole.Folder_ID = -1;
allFolder.Add(fole);
}
showFolder(allFolder, trNo);
tvMain.Nodes.Add(trNo);
tvMain.CollapseAll();
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(tb_Folder model)
{
StringBuilder strSql = new StringBuilder();
StringBuilder strSql1 = new StringBuilder();
StringBuilder strSql2 = new StringBuilder();
if (model.Folder_NAME != null)
{
strSql1.Append("Folder_NAME,");
strSql2.Append("'" + model.Folder_NAME + "',");
}
if (model.State != null)
{
strSql1.Append("State,");
strSql2.Append("" + (model.State ? 1 : 0) + ",");
}
if (model.ParentId != null)
{
strSql1.Append("ParentId,");
strSql2.Append("" + model.ParentId + ",");
}
strSql.Append("insert into tb_Folder(");
strSql.Append(strSql1.ToString().Remove(strSql1.Length - 1));
strSql.Append(")");
strSql.Append(" values (");
strSql.Append(strSql2.ToString().Remove(strSql2.Length - 1));
strSql.Append(")");
strSql.Append(";select @@IDENTITY");
int result;
object obj = DBHelp.ExeScalar(strSql.ToString());
if (!int.TryParse(obj.ToString(), out result))
{
return(0);
}
return(result);
}
/// <summary>
/// 对象实体绑定数据
/// </summary>
public tb_Folder ReaderBind(IDataReader dataReader)
{
tb_Folder model = new tb_Folder();
object ojb;
ojb = dataReader["Folder_ID"];
if (ojb != null && ojb != DBNull.Value)
{
model.Folder_ID = (int)ojb;
}
model.Folder_NAME = dataReader["Folder_NAME"].ToString();
ojb = dataReader["State"];
if (ojb != null && ojb != DBNull.Value)
{
model.State = (bool)ojb;
}
ojb = dataReader["ParentId"];
if (ojb != null && ojb != DBNull.Value)
{
model.ParentId = (int)ojb;
}
return(model);
}
protected void btnSave_Click(object sender, EventArgs e)
{
if (lblPareId.Text.ToString() == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "a", string.Format("alert('请选择一个上级文件夹节点！');"), true);
return;
}
if (txtFolder.Text.Trim() == "")
{
ScriptManager.RegisterStartupScript(UpdatePanel1, this.GetType(), "a", string.Format("alert('请填写文件夹名称！');"), true);
return;
}
tb_Folder folder = new tb_Folder();
folder.Folder_NAME = txtFolder.Text;
folder.ParentId = Convert.ToInt32(lblPareId.Text);
tb_FolderService folderSer = new tb_FolderService();
if (ViewState["state"].ToString() == "add")
{
folderSer.Add(folder);
txtFolder.Text = "";
txtFolder.Focus();
}
if (ViewState["state"].ToString() == "update")
{
folder.Folder_ID = Convert.ToInt32(ViewState["folder_Id"]);
folderSer.Update(folder);
}
IniData();
}
