You can not select more than 25 topics
Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
73 lines
2.1 KiB
73 lines
2.1 KiB
namespace CounsellorBL.Helper
|
|
{
|
|
using System.Collections.Generic;
|
|
using OT.COM.ArsenalDB;
|
|
using SoldierData.EnterprizeV4;
|
|
using static CounsellorBL.Common.EntityBaseExtension;
|
|
|
|
public class DownloadHelper : DBService
|
|
{
|
|
public override string MainTable => null;
|
|
|
|
public static string GetFilePaths( out List<tb_sys_uploadlog> o_lRes)
|
|
{
|
|
string sMsg = null;
|
|
List<tb_sys_uploadlog> ulRes = null;
|
|
|
|
do
|
|
{
|
|
|
|
tb_sys_uploadlog ulDisplay = new tb_sys_uploadlog();
|
|
ulDisplay.SetFullDirtyEx(EColumnFilter.ES_NO_SYSTEMCOLUMN);
|
|
|
|
Command cSelect = Command.SetupSelectCmd(ulDisplay);
|
|
ArsenalInterface ai = ArsenalDBMgr.GetInst(cSelect, null);
|
|
|
|
List<tb_sys_uploadlog> lRes = ai.RunQueryList<tb_sys_uploadlog>(cSelect);
|
|
|
|
if (!cSelect.IsSuccess)
|
|
{
|
|
sMsg = cSelect.LastErrorCode;
|
|
break;
|
|
}
|
|
ulRes = lRes;
|
|
}
|
|
while (false);
|
|
|
|
|
|
o_lRes = ulRes;
|
|
return sMsg;
|
|
}
|
|
|
|
public static string GetFilePathByID(string i_sFileUID, out tb_sys_uploadlog o_ulRes)
|
|
{
|
|
string sMsg = null;
|
|
tb_sys_uploadlog ulRes = null;
|
|
|
|
do
|
|
{
|
|
|
|
tb_sys_uploadlog ulDisplay = new tb_sys_uploadlog();
|
|
ulDisplay.SetFullDirtyEx(EColumnFilter.ES_NO_SYSTEMCOLUMN);
|
|
tb_sys_uploadlog ulCond = new tb_sys_uploadlog() { uid = i_sFileUID };
|
|
|
|
Command cSelect = Command.SetupSelectCmd(typeof(tb_sys_uploadlog), ulDisplay, ulCond);
|
|
ArsenalInterface ai = ArsenalDBMgr.GetInst(cSelect, null);
|
|
|
|
List<tb_sys_uploadlog> lRes = ai.RunQueryList<tb_sys_uploadlog>(cSelect);
|
|
|
|
if (!cSelect.IsSuccess)
|
|
{
|
|
sMsg = cSelect.LastErrorCode;
|
|
break;
|
|
}
|
|
ulRes = lRes[0];
|
|
}
|
|
while (false);
|
|
|
|
|
|
o_ulRes = ulRes;
|
|
return sMsg;
|
|
}
|
|
}
|
|
}
|