/// <summary> /// 房貸執行 Krsik 前先刪除 /// </summary> /// <param name="data"></param> /// <returns></returns> public Tuple <string, List <EL_Data_Out> > deleteC07(Flow_Apply_Status data) { string resilt = string.Empty; List <EL_Data_Out> cacheC07 = new List <EL_Data_Out>(); using (IFRS9DBEntities db = new IFRS9DBEntities()) { var reportDate = data.Report_Date.ToString(C07reportDateFormate); var _Loan_1 = Product_Code.M.GetDescription(); cacheC07 = db.EL_Data_Out.AsNoTracking() .Where(x => x.Report_Date == reportDate && x.Version == 1 && x.Product_Code == _Loan_1 && x.PRJID == data.PRJID && x.FLOWID == data.FLOWID).ToList(); string sql = $@" delete EL_Data_Out where Report_Date = '{reportDate}' and Product_Code = '{_Loan_1}' and Version = 1 and PRJID = '{data.PRJID}' and FLOWID = '{data.FLOWID}' "; try { db.Database.ExecuteSqlCommand(sql); } catch (Exception ex) { resilt = ex.exceptionMessage(); } } return(new Tuple <string, List <EL_Data_Out> >(resilt, cacheC07)); }
public void saveD04(Flow_Apply_Status data) { using (IFRS9DBEntities db = new IFRS9DBEntities()) { db.Flow_Apply_Status.Add(data); try { db.SaveChanges(); } catch (Exception ex) { } } }
public async Task <JsonResult> KriskBondsComplete(string date, string version, string product, string productCode) { DateTime dt = DateTime.MinValue; int ver = 0; if (date.IsNullOrWhiteSpace() || version.IsNullOrWhiteSpace() || product.IsNullOrWhiteSpace() || !DateTime.TryParse(date, out dt) || !int.TryParse(version, out ver)) { return(Json(new KRiskFlowLoaderResult() { result = "1", message = Message_Type.parameter_Error.GetDescription() })); } var productInfo = KriskRepository.getProductInfo(productCode); var pc = string.Join(",", product.Split(',').Select(x => string.Format("'{0}'", x))); Flow_Apply_Status D04 = new Flow_Apply_Status(); D04.Report_Date = dt; D04.Run_Time_Start = DateTime.Now; D04.PRJID = productInfo.Item1; D04.FLOWID = productInfo.Item2; D04.Group_Product_Code = productCode; D04.Version = ver; D04.Flow_Result = "1"; string message = string.Empty; List <KRiskFlowLoaderParm> parms = new List <KRiskFlowLoaderParm>(); parms.Add(new KRiskFlowLoaderParm() { key = "v_uni_project_name", value = productInfo.Item1 }); parms.Add(new KRiskFlowLoaderParm() { key = "v_uni_flow_name", value = productInfo.Item2 }); parms.Add(new KRiskFlowLoaderParm() { key = "v_etl_product_code", value = pc }); parms.Add(new KRiskFlowLoaderParm() { key = "v_etl_report_date", value = string.Format("'{0}'", dt.ToString("yyyyMMdd")) }); parms.Add(new KRiskFlowLoaderParm() { key = "v_etl_version", value = version.Trim() }); HttpClient client = new HttpClient(); client.BaseAddress = new System.Uri(kriskUrl); client.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json")); client.Timeout = ts; try { HttpResponseMessage response = await client.PostAsJsonAsync(@"KRiskFlowLoader/KRiskFlowLoaderServlet", parms); if (response.IsSuccessStatusCode) { KRiskFlowLoaderResult data = JsonConvert.DeserializeObject <KRiskFlowLoaderResult>(await response.Content.ReadAsStringAsync()); if (data.result == "0") { D04.Flow_Result = "0"; message = "Success!"; KriskRepository.getBondC07CheckData(dt, ver); } else { if (data.message.IndexOf("唯一索引鍵值") > -1) { message = Message_Type.kriskError.GetDescription(null, "執行重複資料"); } else { message = data.message; } } } else { message = string.Format("Status Code : {0}", response.StatusCode); } } catch (Exception ex) { message = ex.exceptionMessage(); } SaveD04Action act = SaveD04; act.Invoke(D04); return(Json(new KRiskFlowLoaderResult() { result = D04.Flow_Result, message = message })); }
public void SaveD04(Flow_Apply_Status D04) { D04.Run_Time_End = DateTime.Now; KriskRepository.saveD04(D04); }