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