public atriumDB.EFileDataTable Load()
{
this.sqlDa.SelectCommand = sqlSelectAll;
atriumDB.EFileDataTable dt = new atriumDB.EFileDataTable();
Fill(dt);
return(dt);
}
public atriumDB.EFileDataTable LoadFileRoots()
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[EFileSelectFileRoots]";
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
atriumDB.EFileDataTable dt = new atriumDB.EFileDataTable();
Fill(dt);
return dt;
}
public atriumDB.EFileDataTable LoadByParentFileId(int FileId, int OfficeId)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[EFileSelectByParentFileId]";
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ParentFileId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@ParentFileId"].Value = FileId;
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@OfficeId", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@OfficeId"].Value = OfficeId;
atriumDB.EFileDataTable dt = new atriumDB.EFileDataTable();
Fill(dt);
return dt;
}
//public atriumDB.EFileDataTable LoadByThread(string ConvIndexBase)
//{
// this.sqlDa.SelectCommand = sqlSelect;
// this.sqlSelect.Parameters.Clear();
// this.sqlSelect.CommandText = "[FileFindByThread]";
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@ConvIndexBase", System.Data.SqlDbType.NVarChar, 44, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
// if (ConvIndexBase.Length > 44)
// ConvIndexBase = ConvIndexBase.Substring(0, 44);
// this.sqlSelect.Parameters["@ConvIndexBase"].Value = ConvIndexBase;
// atriumDB.EFileDataTable dt = new atriumDB.EFileDataTable();
// Fill(dt);
// return dt;
//}
public atriumDB.EFileDataTable LoadByPath(string path)
{
this.sqlDa.SelectCommand = sqlSelect;
this.sqlSelect.Parameters.Clear();
this.sqlSelect.CommandText = "[EFileSelectByPath]";
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@RETURN_VALUE", System.Data.SqlDbType.Int, 4, System.Data.ParameterDirection.ReturnValue, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters.Add(new System.Data.SqlClient.SqlParameter("@path", System.Data.SqlDbType.NVarChar, 255, System.Data.ParameterDirection.Input, false, ((System.Byte)(10)), ((System.Byte)(0)), "", System.Data.DataRowVersion.Current, null));
this.sqlSelect.Parameters["@path"].Value = path;
atriumDB.EFileDataTable dt = new atriumDB.EFileDataTable();
Fill(dt);
return dt;
}
