/// <summary>
/// 获取要复估的押品列表
/// </summary>
/// <param name="id">文件ID</param>
/// <returns></returns>
public ResultData GetDataCollateral(string id)
{
MSSQLADODAL mssqlado = new MSSQLADODAL(Utility.DBFxtLoan);
string sql = string.Format("{0} [Status]=1 and UploadFileId={1}",
Utility.GetMSSQL_SQL(typeof(DataCollateral), Utility.loan_Data_Collateral), id);
List <DataCollateral> list = mssqlado.GetList <DataCollateral>(sql);
if (list.Count() > 0)
{
return(Utility.GetObjJson(1, "成功", list));
}
return(Utility.GetObjJson(0, ""));
}
/// <summary>
/// 获取任务列表
/// </summary>
/// <returns></returns>
public ResultData TaskList()
{
MSSQLADODAL mssqlado = new MSSQLADODAL(Utility.DBFxtLoan);
//获取状态为开始、暂停的任务
string sql = string.Format("{0} [Status]=0 or [Status]=2",
Utility.GetMSSQL_SQL(typeof(SysTask), Utility.loand_Sys_Task));
List <TaskToFile> list = mssqlado.GetList <TaskToFile>(sql);
foreach (var item in list)
{
MSSQLADODAL.SetConnection(Utility.DBFxtLoan);
//文件地址
SysUploadFile sysUploadFile = CAS.DataAccess.DA.BaseDA
.ExecuteToEntityByPrimaryKey <SysUploadFile>(item.UploadFileId);
item.FileUrl = sysUploadFile != null ? sysUploadFile.FilePath : "";
//银行所属项目名称
SysBankProject sysBankProject = CAS.DataAccess.DA.BaseDA
.ExecuteToEntityByPrimaryKey <SysBankProject>(item.BankProjectId);
item.BankProjectName = sysBankProject != null ? sysBankProject.ProjectName : "";
//任务所属用户名称
SysUser sysUser = CAS.DataAccess.DA.BaseDA
.ExecuteToEntityByPrimaryKey <SysUser>(item.UserId);
item.UserName = sysUser != null ? sysUser.TrueName : "";
//公司、银行、评估机构
SysCustomer sysCustomer = CAS.DataAccess.DA.BaseDA
.ExecuteToEntityByPrimaryKey <SysCustomer>(item.BankId);
item.BankName = sysCustomer != null ? sysCustomer.CustomerName : "";
}
if (list.Count > 0)
{
return(Utility.GetObjJson(1, "成功", list));
}
return(Utility.GetObjJson(0, ""));
}