//新增修改文件项目 public ActionResult AddEditProjects(SysBankProject data, int delvalid = 1) { JObject _obj = new JObject(); data.CreateDate = DateTime.Now; data.CustomerId = Public.LoginInfo.CustomerId; data.Valid = delvalid; data.UserId = Public.LoginInfo.Id; _obj.Add("data", Utils.Serialize(data)); using (FxtAPIClient client = new FxtAPIClient()) { result = client.Entrance(Utils.CommonKey, Utils.GetWcfCode(Utils.CommonKey), "C", _AddEditProjects, Utils.Serialize(_obj)); return(Json(result)); } }
/// <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, "")); }