public static void CreateRootDir(string NetPath)
{
string MaxCreateDirPath = ConfigerHelper.GetAppConfig("MaxCreateDirPath");
try
{
int maxCreateDirPath = Convert.ToInt32(MaxCreateDirPath);
for (int i = 1; i < maxCreateDirPath; i++)
{
string url = NetPath + i.ToString();
filepath filepath = new filepath()
{
file_Path = url,
file_innerTxt = "",
file_Type_id = 10,
file_status_id = 0,
file_CreateTime = DateTime.Now,
file_parent_path = "0"
};
Tool.InsertfilePathByLinq(filepath);
}
}
catch (Exception)
{
MyMessageBox.Add("创建根目录时发生错误！");
}
}
//public void prepareOperation(IRenderExecutionContext context)
//{
// String _pt = sourcepath.toPath("", context.data);
// template = openBase.openFileToString(_pt, true, false);
//}
public PropertyCollectionDictionary collectOperationStart(IRenderExecutionContext context, IMetaContentNested composer, PropertyCollectionDictionary dict)
{
var level = composer.elementLevel;
if (level == sourceRender.levelOfNewFile)
{
string filename = dict[composer.path].getProperString("", templateFieldBasic.path_output);
string parentPath = composer.path;
if (composer.parent != null)
{
parentPath = composer.parent.path;
}
string folderPath = context.data.getProperString(parentPath, templateFieldBasic.path_folder, templateFieldBasic.document_path, templateFieldBasic.documentset_path);
// filename = context.directoryScope.FullName.add(filename, "\\");
filepath fp = new filepath(filename);
//String templateFilename = fp.filename.add(fp.extension, "."); //.toPathWithExtension("", format.getDefaultExtension());
string templateFilename = fp.toPathWithExtension("", format.getDefaultExtension());
// context.regFileOutput(templateFilename, folderPath, description);
// dict[composer.path].Add(templateFieldBasic.path_output, filename);
}
else
{
// dict[composer.path].Add(templateFieldBasic.path_file, "");
}
//throw new NotImplementedException();
return(dict);
}
public bool run(string attrName, filepath fileEntity)
{
bool success = false;
HtmlNodeCollection hnCollection;
HtmlNodeCollection titleCollection;
//获取目录地址
try
{
HtmlDocument htmlDocument = HtmlTool.LoadHtml(fileEntity.file_Path);
hnCollection = HtmlTool.GetNodeCollect(htmlDocument, HtmlModelTool.htmlModel.Match);
titleCollection = HtmlTool.GetNodeCollect(htmlDocument, "//head/title");
}
catch (Exception EX)
{
Console.WriteLine("线程 {0} 获取文件 {1} 时发生了错误，错误信息 {2} ，错误详情 {3} ", System.Threading.Thread.CurrentThread.ManagedThreadId, fileEntity.file_Path, EX.Message, EX.Data);
//InsertSql(fileType,URL);
return(success);
}
if (hnCollection == null)
{
//errorList.Add(URL);
Console.WriteLine("线程 {0} 获取文件 {1} 时发生了错误 ,未能加载网页！", System.Threading.Thread.CurrentThread.ManagedThreadId, fileEntity.file_Path);
//InsertSql(fileType, URL);
return(success);
}
// Console.WriteLine("线程 {0} 获取文件 {1} 正在操作，锁定中……", System.Threading.Thread.CurrentThread.ManagedThreadId, URL);
foreach (HtmlNode hn in hnCollection)
{
string path = hn.Attributes[attrName].Value;
string innerTxt = string.IsNullOrEmpty(hn.InnerHtml) ? !string.IsNullOrEmpty(hn.InnerText) ? hn.InnerText : (titleCollection != null ? "" : (titleCollection.Count > 0 ? titleCollection[0].InnerHtml : "")) : hn.InnerHtml;
if (!string.IsNullOrEmpty(path))
{
if (!dirPathEntity.Any(p => p.file_Path.Equals(path)))
// if (!dirPath.Contains(path))
{
dirPath.Add(path);
try
{
// InsertfilePath(path, innerTxt, fileType, 0, URL);
}
catch
{
return(success);
}
success = true;
}
//else if(!dirPathEntity.Any(p=>p.file_innerTxt))
// else
success = true;
//}
}
}
return(success);
}
public string javaSet([FromBody] filepath csv_file_path)
{
var count = data.Database.SqlQuery <int>(@"select exam_set_counts from Exam_List where exam_id=1").FirstOrDefault <int>();
if (count <= 2)
{
var free = data.Database.SqlQuery <string>(@"select top 1 table_name from Java_Sets where availability = 'yes'").FirstOrDefault <string>();
string tableName = free;
CSVtoSQL c = new CSVtoSQL();
DataTable csvData = FileReader.CSVtoSQL.GetDataTabletFromCSVFile(csv_file_path.csv_file_path);
Console.WriteLine("Rows count:" + csvData.Rows.Count);
c.InsertDataIntoSQLServerUsingSQLBulkCopy(csvData, tableName);
foreach (var column in csvData.Columns)
{
Console.WriteLine(column);
}
data.Database.ExecuteSqlCommand(@"update Java_Sets set availability = 'no' where table_name=@tablename", new SqlParameter("@tablename", free));
data.Database.ExecuteSqlCommand(@"update Exam_List set exam_set_counts = exam_set_counts + 1 where exam_id =1");
return("Added Successfully");
}
else
{
return("No More Set Can be Added");
}
}
public List <string> available([FromBody] filepath subject)
{
var free = subject.subject + "_Sets";
var avail = data.Database.SqlQuery <string>(@"select table_name from " + free + " where availability = 'no'").ToList();
return(avail);
}
public List <setTable> uploadSet([FromBody] filepath subject)
{
var free = subject.subject + "_Sets";
var avail = data.Database.SqlQuery <setTable>(@"select table_name, availability from " + free).ToList();
return(avail);
}
private void CreateDirAndDownLoad(filepath entity)
{
var path = entity.file_Path;
if (string.IsNullOrEmpty(path))
{
return;
}
var dirName = entity.file_innerTxt;
//List<string> dirPathNameList = _dirPathList.Where(item => item.file_Path == entity.file_parent_path).Select(item => item.file_innerTxt).Distinct( ).ToList();
//string dealString = (string.IsNullOrEmpty(dirName) ? (dirPathNameList.Count != 0 ? dirPathNameList[0].ToString( ) : (fileNames[fileNames.Length - 3] + @"\"
// + fileNames[fileNames.Length - 2])) : dirName);
//dealString = dealString.ToCharArray( ).Where(ch => !(@"\/*|:?*<> ".ToCharArray( ).Contains(ch))).Aggregate(string.Empty, ( f, ch ) => f + ch);
try
{
var fileNames = path.Split('/');
if (fileNames.Length == 0)
{
return;
}
var fileName = fileNames[fileNames.Length - 1];
var dealString = string.IsNullOrEmpty(dirName)
? fileNames[fileNames.Length - 3] + @"\"
+ fileNames[fileNames.Length - 2]
: dirName;
//处理目录中非法的字符
dealString =
dealString.ToCharArray()
.Where(ch => !@"\/*|:?*<> ".ToCharArray().Contains(ch))
.Aggregate(string.Empty, (f, ch) => f + ch);
var createDir =
(SaveFilePath.EndsWith(@"\") ? SaveFilePath : SaveFilePath + @"\")
+ dealString + @"\";
if (!Directory.Exists(createDir))
{
try
{
Directory.CreateDirectory(createDir);
}
catch
{
MyMessageBox.Add(string.Format("路径 {0} 存在错误！文件名 {1} ", createDir, fileName));
Console.WriteLine("路径 {0} 存在错误！文件名 {1} ", createDir, fileName);
}
}
fileName = createDir + fileName;
Tool.DownLoad(path, fileName);
// Console.WriteLine("线程 {0} 执行完了! 下载地址 {1} 本机地址 {2} ", Thread.CurrentThread.ManagedThreadId, path, fileName);
}
catch (Exception)
{
// Console.WriteLine(e.Data + "\n" + e.Message);
}
}
public string removeJava([FromBody] filepath set)
{
var free = "javaQuestion" + set.set;
data.Database.ExecuteSqlCommand(@"truncate table javaQuestion" + set.set);
data.Database.ExecuteSqlCommand(@"update Java_Sets set availability = 'yes' where table_name=@tablename", new SqlParameter("@tablename", free));
data.Database.ExecuteSqlCommand(@"update Exam_List set exam_set_counts = exam_set_counts - 1 where exam_id =1");
return("Deleted");
}
public void PostData()
{
filepath fp = new filepath();
fp.file_path = Application.persistentDataPath + "/ocrtext.txt";
string json = JsonUtility.ToJson(fp);
StartCoroutine(PostRequest("http://127.0.0.1:5000/list_add", json));
}
public List <questionR> level2([FromBody] filepath filepath)
{
var free = filepath.subject + "_Sets";
var avail = data.Database.SqlQuery <string>(@"select table_name from " + free + " where availability = 'no'").ToList();
var random = new Random();
int index = random.Next(avail.Count);
char[] questionSet = avail[index].ToArray();
filepath.set = questionSet[questionSet.Length - 1].ToString();
var all = data.Database.SqlQuery <questionR>(@"select top 20 sno,question,option1, option2, option3, option4, [correct option] as correct_option, difficulty from " + filepath.subject + "Question" + filepath.set + " where difficulty = 'medium' order by NEWID()").ToList();
return(all);
}
public void InsertfilePath(string path, string innerTxt, int fileType, int file_status_id, string URL)
{
filepath filepath = new filepath( )
{
file_Path = path,
file_innerTxt = innerTxt,
file_Type_id = fileType,
file_status_id = file_status_id,
file_CreateTime = DateTime.Now,
file_parent_path = URL
};
Tool.InsertfilePathByLinq(filepath);
// InfoDAL.InsertfilePath(path, innerTxt, fileType, file_status_id, URL);
}
public void FillMusicAndPath(List<string> PathOndevice)
{
using (var musik = new pcindexEntities())
{
var pathlist = (from p in musik.filepaths
select p.FilePath1
).ToList();
PathOndevice = listcompair(PathOndevice, pathlist);
if (PathOndevice.Count >= 1)
{
foreach (var onpath in PathOndevice)
{
var path = new filepath();
path.Device_UUIDDevice = _GUIDDevice;
path.UUIDPath = Guid.NewGuid().ToString();
path.FilePath1 = onpath;
musik.filepaths.Add(path);
musik.SaveChanges();
IFileIndexer indexer = new FolderAndFileReader();
indexer.SetIndexPath(onpath);
List<IMetadataReader> mdata = indexer.GetMetaData();
FillAAG(mdata);
fillMusicdata(mdata,path.UUIDPath);
}
}
}
//see if pathes is allready is assigned to ip
// if not add pathes
}
public static void InsertfilePathByLinq(filepath filepath)
{
new BaseDataQuery <filepath>().Add(filepath);
}
protected void setupForGeneratedItem(string __outputFilename)
{
outputpath = new filepath(__outputFilename);
}
protected void setupForTemplatedItem(string __sourcepath)
{
sourcepath = new filepath(__sourcepath);
}
/// <summary>
/// 将实体数据插入到filepath
/// </summary>
/// <param name="filepath"></param>
public static void InsertfilePathByLinq(filepath filepath)
{
InfoDal.InsertfilePathByLinq(filepath);
}
