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