public List<FileattachInfo> Save_Files(int iid, int belongto) { try { string strFiles = FB_txtFileurl.Value; if (CFunctions.IsNullOrEmpty(strFiles)) return null; List<FileattachInfo> list = new List<FileattachInfo>(); string[] arrFiles = strFiles.Split("]#[".Split('$'), StringSplitOptions.None); for (int i = 0; i < arrFiles.Length - 1; i++) { string[] everyFile = arrFiles[i].Split("][".Split('$'), StringSplitOptions.None); FileattachInfo fileinfo = new FileattachInfo(); fileinfo.Name = fileinfo.Path = everyFile[0]; fileinfo.Subject = everyFile[1]; fileinfo.Note = everyFile[2]; fileinfo.Url = everyFile[3]; fileinfo.Orderd = CFunctions.IsInteger(everyFile[4]) ? Convert.ToInt32(everyFile[4]) : 0; fileinfo.Id = CFunctions.IsInteger(everyFile[5]) ? Convert.ToInt32(everyFile[5]) : 0; fileinfo.Status = (int)CConstants.State.Status.Actived; fileinfo.Timeupdate = DateTime.Now; fileinfo.Iid = iid; fileinfo.Belongto = belongto; list.Add(fileinfo); } if (list.Count > 0) if (new CFileattach(CCommon.LANG).Save(list)) (new CGeneral(CCommon.LANG, belongto)).Updatenum(iid.ToString(), Queryparam.Sqlcolumn.Album, list.Count, CConstants.NUM_DIRECTLY); return list; } catch { return null; } }
private void setParameter(iSqlParameter[] parms, FileattachInfo info) { try { int i = -1; parms[++i].Value = CFunctions.SetDBString(info.Name); parms[++i].Value = CFunctions.SetDBString(info.Path); parms[++i].Value = CFunctions.SetDBString(info.Note); parms[++i].Value = CFunctions.SetDBString(info.Subject); parms[++i].Value = CFunctions.SetDBString(info.Url); parms[++i].Value = info.Sized; parms[++i].Value = info.Typed; parms[++i].Value = info.Orderd == 0 ? info.Id : info.Orderd; parms[++i].Value = info.Status; parms[++i].Value = info.Markas; parms[++i].Value = CFunctions.SetDBString(info.Iconex); parms[++i].Value = CFunctions.SetDBDatetime(info.Timeupdate); parms[++i].Value = CFunctions.SetDBString(info.Username); parms[++i].Value = info.Belongto; parms[++i].Value = info.Iid; parms[++i].Value = info.Id; return; } catch (Exception ex) { throw ex; } }
private bool Saveitem(iSqlTransaction trans, FileattachInfo info) { try { if (trans == null || info == null) return false; string SQL = string.Empty; if (info.Id == 0) { SQL = SQL_INSERT; info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else if (HELPER.isExist(trans, TABLENAME, info.Id)) { SQL = SQL_UPDATE; iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } else { SQL = SQL_INSERT; info.Id = (int)HELPER.getNewID(trans, TABLENAME); iSqlParameter[] parms = this.getParameter(SQL); this.setParameter(parms, info); HELPER.executeNonQuery(trans, iCommandType.Text, SQL, parms); } return true; } catch (Exception ex) { throw ex; } }
private FileattachInfo getDataReader(iSqlDataReader dar) { try { int i = -1; FileattachInfo info = new FileattachInfo(); info.Name = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Path = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Note = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Subject = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Url = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Sized = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); info.Typed = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Orderd = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Status = dar.IsDBNull(++i) ? (int)CConstants.State.Status.Waitactive : dar.GetInt32(i); info.Markas = dar.IsDBNull(++i) ? (int)CConstants.State.MarkAs.None : dar.GetInt32(i); info.Iconex = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Timeupdate = dar.IsDBNull(++i) ? new DateTime(0) : dar.GetDateTime(i); info.Username = dar.IsDBNull(++i) ? string.Empty : dar.GetString(i); info.Belongto = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Iid = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Id = dar.IsDBNull(++i) ? 0 : dar.GetInt32(i); info.Rownumber = dar.IsDBNull(++i) ? 0 : dar.GetInt64(i); return info; } catch (Exception ex) { throw ex; } }
public bool Save(FileattachInfo info) { try { using (iSqlConnection iConn = HELPER.getConnect(HELPER.SQL_SYSTEM)) { using (iSqlTransaction trans = iConn.BeginTransaction()) { try { this.Saveitem(trans, info); trans.Commit(); } catch (Exception ex) { trans.Rollback(); throw ex; } } iConn.Close(); } return true; } catch (Exception ex) { throw ex; } }
private List<FileattachInfo> Load_ListFolder(List<FileattachInfo> listin, string foldername, int folderlevel) { string pre_text = ""; for (int i = 0; i < folderlevel; i++) { pre_text += "----"; } List<FileattachInfo> list = null; string[] directories = Directory.GetDirectories(Server.MapPath(foldername)); foreach (string directory in directories) { FileattachInfo info = new FileattachInfo(); info.Name = directory.Substring(directory.LastIndexOf("\\") + 1); info.Path = foldername + "/" + info.Name; info.Iconex = pre_text + "<img src='../images/folder_close.gif' border='0' align='absmiddle' />"; info.Orderd = folderlevel + 1; if (list == null) list = new List<FileattachInfo>(); list.Add(info); List<FileattachInfo> listout = this.Load_ListFolder(list, foldername + "/" + info.Name, folderlevel + 1); if (listout != null) list.AddRange(listout); } return list; }
private List<FileattachInfo> Load_ListFiles(string path) { if (path == WEBSITE) return null; List<FileattachInfo> list = null; string[] files = Directory.GetFiles(Server.MapPath(path), "*.*", chkSearchOption.Checked ? SearchOption.AllDirectories : SearchOption.TopDirectoryOnly); foreach (string file in files) { if (file.IndexOf(txtKeyword.Text.Trim().ToLower()) == -1) continue; FileattachInfo info = new FileattachInfo(); FileInfo f = new FileInfo(file); info.Name = f.Name; info.Sized = f.Length; string filePath = file.Replace("\\", "/"); info.Path = "../../" + filePath.Substring(filePath.IndexOf("commup")); if (list == null) list = new List<FileattachInfo>(); list.Add(info); } return list; }
private void Bind_ListFolder() { if (!Directory.Exists(Server.MapPath("../../commup"))) return; List<FileattachInfo> list = new List<FileattachInfo>(); FileattachInfo info = new FileattachInfo(); info.Name = "commup"; info.Path = "../../commup"; info.Iconex = "----<img src='../images/folder_open.gif' border='0' align='absmiddle' />"; info.Orderd = 2; list.Add(info); string[] directories = Directory.GetDirectories(Server.MapPath("../../commup")); foreach (string directory in directories) { info = new FileattachInfo(); info.Name = directory.Substring(directory.LastIndexOf("\\") + 1); info.Path = "../../commup/" + info.Name; info.Iconex = "--------<img src='../images/folder_close.gif' border='0' align='absmiddle' />"; info.Orderd = 3; list.Add(info); List<FileattachInfo> listout = this.Load_ListFolder(list, "../../commup/" + info.Name, 3); if (listout != null) list.AddRange(listout); } (new GenericList<FileattachInfo>()).Bind_DataList(dtlListFolder, null, list, 0); pnlListFolder.Visible = list != null && list.Count > 0; }