Boolean ImportFile(string strFilePath1) { string _yrmo = ddlYrmo.SelectedItem.Text; bool importStat = false; ImportDAL iObj = new ImportDAL(); try { DataSet ds = new DataSet(); ImportExcelReport tObj = new ImportExcelReport(); ds = tObj.importHTH(strFilePath1, _yrmo); parseDataSet pObj = new parseDataSet(); pObj.parseHTH(ds, _yrmo); counter = iObj.insertHTHHeadcounts(_yrmo); importStat = true; int _counter = iObj.getImportCount("HTH", _yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "Headcount", "International HTH Report Import", _yrmo, _counter); } catch (Exception ex) { iObj.Rollback("HTH", _yrmo); throw ex; } finally { File.Delete(strFilePath1); FileUpload1.FilePost.InputStream.Flush(); FileUpload1.FilePost.InputStream.Close(); FileUpload1.FilePost.InputStream.Dispose(); } return(importStat); }
public int ImportCrew(object dataTable, string shipNumber) { ImportDAL crewImportDAL = new ImportDAL(); //crewImportDAL.ImportCrew(dataTable, shipNumber); return(crewImportDAL.ImportTemporaryCrew(dataTable, shipNumber)); }
/// <summary> /// 从房产库查询数据构建BDC插入实例 /// </summary> /// <param name="slbh"></param> /// <returns></returns> private static List <DOC_BINFILE> GetDoc_Binfile(string slbh, string fcslbh) { List <VolEleArcDtl> veads = ImportDAL.GetVolEleArcDtl(fcslbh); List <DOC_BINFILE> list = new List <DOC_BINFILE>(); //if(null!=Res_list && Res_list.Count>0) //{ // foreach (Result res in Res_list) // { Thread.Sleep(200); foreach (VolEleArcDtl v in veads) { v.imgName = v.imgName.Replace(@"\\192.168.134.245\", "").Replace(@"\\192.168.100.202\", "").Replace(@"K:\", "").Replace(@"\\192.168.100.202 \", ""); v.imgName = v.imgName.Replace("\\", "/"); VolEleArc vea = GetVolEleArc(v.VolEleArc_ID); DOC_BINFILE doc_binfile = new DOC_BINFILE(); doc_binfile.BINID = GetCID(slbh, vea.EleArcName); if (doc_binfile.BINID != "") { doc_binfile.FTPATH = v.imgName; doc_binfile.FILEID = Guid.NewGuid().ToString(); doc_binfile.FILENAME = vea.EleArcName; doc_binfile.EXTNAME = GetExtName(v.imgName); doc_binfile.ISCOMPRESSED = "否"; doc_binfile.ISENCRYPTED = "否"; list.Add(doc_binfile); } } // } //} return(list); }
Boolean ImportFile(string strFilePath1) { string _yrmo = ddlYrmo.SelectedItem.Text; bool importStat = false; ImportDAL iObj = new ImportDAL(); try { DataSet ds = new DataSet(); ImportExcelReport tObj = new ImportExcelReport(); ds = tObj.importDFNORF(strFilePath1); parseDataSet pObj = new parseDataSet(); counter = pObj.parseDFnoRF(ds, _yrmo); importStat = true; Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Claims Reconciliation", "RFDF", "DFnoRF Report Import", _yrmo, counter); } catch (Exception ex) { iObj.Rollback("DF", _yrmo); throw ex; } finally { File.Delete(strFilePath1); } return(importStat); }
private static void ImportQS(string base64Str, string sLBH, string userName) { string path = sLBH + "_完税凭证.jpg"; string cid = GetCID(sLBH, "完税凭证", "文件夹", userName); DOC_BINFILE doc_binfile = new DOC_BINFILE(); string binid = GetCID(sLBH, "完税凭证", "文件", userName, cid);//att.CID; doc_binfile.BINID = binid; doc_binfile.FTPATH = path; doc_binfile.FILEID = Guid.NewGuid().ToString(); doc_binfile.FILENAME = "完税凭证"; doc_binfile.EXTNAME = "jpg";//GetExtName(v.imgName); doc_binfile.ISCOMPRESSED = "否"; doc_binfile.ISENCRYPTED = "否"; QSPicUploadToFtp(sLBH, base64Str, doc_binfile); if (ImportDAL.ExistDoc_binfile(doc_binfile)) { ImportDAL.UpDateDoc_binfile(doc_binfile); } else { ImportDAL.InsertDoc_binfile(doc_binfile); } }
public static BDCFilterResult ImportFromFC(string slbh, string userName) { BDCFilterResult res = new BDCFilterResult(); int count = 0; FC_REWRITE_TAG tag = new FC_REWRITE_TAG(); string FCslbh = GetRealSLBH(slbh); //string slbh = row[0].ToString(); try { if (CanImport(FCslbh)) { ImportFCDA(slbh, FCslbh, userName, ref count); tag.FILECOUNT = count.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = slbh; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "1"; tag.MESSAGE = "成功"; res.ConfirmType = 0; res.IsSuccess = true;; res.Message = tag.MESSAGE; } else { res.ConfirmType = 0; res.IsSuccess = false; res.Message = "图像尚未扫描入库!"; } } catch (Exception ex) { res.ConfirmType = 0; res.IsSuccess = false; res.Message = ex.Message; tag.FILECOUNT = count.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = slbh; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "0"; tag.MESSAGE = "失败!" + ex.Message; } finally { if (null != tag && null != tag.ID) { ImportDAL.InsertLog(tag); } } //IsSuccess = true; return(res); }
Boolean ImportFile(string strFilePath1) { string _yrmo = ddlYrmo.SelectedItem.Text; bool importStat = false; ImportDAL iObj = new ImportDAL(); try { DataSet ds = new DataSet(); ImportExcelReport tObj = new ImportExcelReport(); ds = tObj.importMCNM(strFilePath1, _yrmo); parseDataSet pObj = new parseDataSet(); _counter = pObj.parseMCNM(ds, _yrmo); importStat = true; Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "Headcount", "Retiree Medicare/Non-Medicare Report Import", _yrmo, _counter); } catch (Exception ex) { iObj.Rollback("RET_NM", _yrmo); throw ex; } finally { File.Delete(strFilePath1); } return(importStat); }
Boolean ImportFile(string strFilePath1) { string _yrmo = ddlYrmo.SelectedItem.Text; bool importStat = false; ImportDAL iObj = new ImportDAL(); try { DataSet ds = new DataSet(); ImportExcelReport tObj = new ImportExcelReport(); ds = tObj.importAnthemBill(strFilePath1); parseDataSet pObj = new parseDataSet(); pObj.parseAnthem(ds, _yrmo); counter = iObj.insertAnthemHeadcounts(_yrmo); importStat = true; int _counter = iObj.getImportCount("ANTH", _yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "billing_details", "Anthem Bill Import", _yrmo, _counter); } catch (Exception ex) { File.Delete(strFilePath1); iObj.Rollback("ANTH", _yrmo); throw ex; } finally { File.Delete(strFilePath1); } return(importStat); }
protected bool importfile(string filepath) { bool status = false; string yrmo = ddlYrmo.Text; ImportText grImport = new ImportText(); try { grImport.ParseGRS(filepath); grImport.importGRSRecords(yrmo); status = true; ImportDAL iobj = new ImportDAL(); int _cnt = iobj.getImportCount("GRS", yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "HeadCounts", "GRS Report Import", yrmo, _cnt); } catch (Exception e) { ImportDAL iObj = new ImportDAL(); iObj.Rollback("GRS", yrmo); throw e; } finally { ImportTextDAL storeData = new ImportTextDAL(); storeData.deleteStage("GRS"); File.Delete(filepath); } return(status); }
public Import GetById(int id) { Import ticket = ImportDAL.GetById(id); calculate(ticket); return(ticket); }
protected bool importfile(string strFilePath1) { bool status = false; string yrmo = ddlYrmo.Text; //ImportText adpImport = new ImportText(); try { //adpImport.ParseADP(strFilePath1); ImportCobra.importADPDetail(yrmo, strFilePath1); status = true; ImportDAL iobj = new ImportDAL(); int _cnt = iobj.getImportCount("ADP", yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Billing Reconciliation", "ADP_Details", "ADP Cobra Import", yrmo, _cnt); } catch (Exception e) { ImportDAL iObj = new ImportDAL(); iObj.Rollback("ADP", yrmo); throw e; } finally { File.Delete(strFilePath1); } return(status); }
internal static BDCFilterResult ImportQSPic(string base64Str, string sLBH, string userName) { BDCFilterResult res = new BDCFilterResult(); int count = 0; FC_REWRITE_TAG tag = new FC_REWRITE_TAG(); //string slbh = row[0].ToString(); try { if (CanImportPic(sLBH)) { ImportQS(base64Str, sLBH, userName); tag.FILECOUNT = count.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = sLBH; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "1"; tag.MESSAGE = "成功"; res.ConfirmType = 0; res.IsSuccess = true;; res.Message = tag.MESSAGE; } else { res.ConfirmType = 0; res.IsSuccess = false; res.Message = "无完税信息!"; } } catch (Exception ex) { res.ConfirmType = 0; res.IsSuccess = false; res.Message = ex.Message; tag.FILECOUNT = count.ToString(); //tag.FILENAME =doc_bin[0].BINID tag.ID = Guid.NewGuid().ToString(); tag.SLBH = sLBH; tag.PUSHDATE = DateTime.Now; tag.ISSUCCESS = "0"; tag.MESSAGE = "失败!" + ex.Message; } finally { if (null != tag && null != tag.ID) { ImportDAL.InsertLog(tag); } } //IsSuccess = true; return(res); }
public List <Import> GetAll(int productId) { List <Import> list = ImportDAL.GetAll(productId); foreach (Import ticket in list) { calculate(ticket); } return(list); }
protected void ddlYrmoList() { ImportDAL iobj = new ImportDAL(); string prevYRMO; for (int i = 0; i < 6; i++) { prevYRMO = iobj.getPrevYRMO(i); ddlYrmo.Items.Add(prevYRMO); } ddlYrmo.Items.Add("New Yrmo"); }
protected void btn_import_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text; if (Page.IsValid) { string strFilePath1 = ""; lbl_error.Text = ""; if (FileUpload1.GotFile) { try { string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName); if (fn.Contains(yrmo)) { strFilePath1 = Server.MapPath("~/uploads/") + fn; if (File.Exists(strFilePath1)) { File.Delete(strFilePath1); } FileUpload1.FilePost.SaveAs(strFilePath1); if (ImportFile(strFilePath1)) { MultiView1.SetActiveView(view_result); lbl_result.Text = "Imported successfully for year-month (YRMO): " + yrmo; //auditImport(tbx_YRMO.Text.ToString(), "imp", counter); } } else { lbl_error.Text = "The Year Month (YRMO) of the selected file does not match the selected YRMO"; } } catch (Exception ex) { ImportDAL iObj = new ImportDAL(); iObj.Rollback("RET_NM", yrmo); lbl_error.Text = "Error in importing file.<br />" + ex.Message; } finally { if (File.Exists(strFilePath1)) { File.Delete(strFilePath1); } FileUpload1.FilePost.InputStream.Flush(); FileUpload1.FilePost.InputStream.Close(); FileUpload1.FilePost.InputStream.Dispose(); } } } }
protected void ddlYrmoList() { ImportDAL iobj = new ImportDAL(); string prevYRMO, filterexp; for (int i = 0; i < 6; i++) { prevYRMO = iobj.getPrevYRMO(i); ddlYrmo.Items.Add(prevYRMO); } ddlYrmo.Items.Add("New Yrmo"); filterexp = "yrmo='" + ddlYrmo.SelectedItem.Text + "'"; SqlDataSourceAdj.FilterExpression = filterexp; }
private static string GetCID(string slbh, string fileName) { string cid = ImportDAL.GetCID(slbh); if (cid == "") { WFM_ATTACHLST att = new WFM_ATTACHLST(); att.CID = Guid.NewGuid().ToString(); att.CNAME = fileName; att.PID = ImportDAL.GetCID(slbh); att.PNODE = slbh; cid = ImportDAL.InserAttachlst(att); } return(cid); }
protected void btn_reimport_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; try { ImportDAL iObj = new ImportDAL(); iObj.Rollback("ANTH_RX", yrmo); MultiView1.SetActiveView(view_main); } catch (Exception ex) { lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message; } }
protected void btn_reimport_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text; lbl_error.Text = ""; try { ImportDAL iObj = new ImportDAL(); iObj.Rollback("HTH", yrmo); ReconDAL.pastReconcileDelete(yrmo, "INTL"); MultiView1.SetActiveView(view_main); } catch (Exception ex) { lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message; } }
protected void btn_reimport_Click(object sender, EventArgs e) { string yrmo = ddlYrmo.SelectedItem.Text.ToString(); lbl_error.Text = ""; try { ClaimsRecon dObj = new ClaimsRecon(); dObj.DeleteNCAReconData(yrmo); dObj.deleteForced(yrmo, "DFRF"); ImportDAL iObj = new ImportDAL(); iObj.Rollback("DF", yrmo); MultiView1.SetActiveView(view_main); } catch (Exception ex) { lbl_error1.Text = "Error in re-importing file.<br />" + ex.Message; } }
public string ImportCrewList(DataTable dt, ref string FailureMessage, ref int FailureCount, ref int SuccessCount) { string s = ""; ImportDAL importDal = new ImportDAL(); DataTable dtBL = new DataTable(); foreach (DataRow dr in dt.Rows) { string sr = dr[1].ToString(); string st = sr.Replace("\\", ""); } s = importDal.ImportCrewList(dt, ref FailureMessage, ref FailureCount, ref SuccessCount); return(s); }
protected void btn_import_Click(object sender, EventArgs e) { if (Page.IsValid) { string strFilePath1 = ""; lbl_error.Text = ""; if (FileUpload1.GotFile) { try { string fn = System.IO.Path.GetFileName(FileUpload1.FilePost.FileName); strFilePath1 = Server.MapPath("~/uploads/") + fn; if (File.Exists(strFilePath1)) { File.Delete(strFilePath1); } FileUpload1.FilePost.SaveAs(strFilePath1); if (ImportFile(strFilePath1)) { MultiView1.SetActiveView(view_result); lbl_result.Text = "Imported successfully for year-month (YRMO): " + ddlYrmo.SelectedItem.Text; } } catch (Exception ex) { ImportDAL iObj = new ImportDAL(); iObj.Rollback("DF", ddlYrmo.SelectedItem.Text); lbl_error.Text = "Error in importing file.<br />" + ex.Message; } finally { if (File.Exists(strFilePath1)) { File.Delete(strFilePath1); } FileUpload1.FilePost.InputStream.Flush(); FileUpload1.FilePost.InputStream.Close(); FileUpload1.FilePost.InputStream.Dispose(); } } } }
DataSet ExecuteStoredProc(string spName, string yrmo, string plancode, string source) { SqlDataAdapter da = new SqlDataAdapter(); DataSet ds = new DataSet(); ds.Clear(); ImportDAL iobj = new ImportDAL(); command = new SqlCommand(spName, connect); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@yrmo", SqlDbType.VarChar).Value = yrmo; command.Parameters.Add("@plancode", SqlDbType.VarChar).Value = plancode; if (source.Equals("ADJ") || source.Equals("COBDET")) { command.Parameters.Add("@prevyrmo", SqlDbType.VarChar).Value = iobj.getPrevYRMO(yrmo); } da.SelectCommand = command; da.Fill(ds); command.Dispose(); return(ds); }
protected bool importfile(string filepath) { string yrmo = ddlYrmo.SelectedItem.Text.ToString(); bool status = false; ImportText boaImport = new ImportText(); try { boaImport.parseBOA(filepath); status = true; ImportDAL iobj = new ImportDAL(); int _cnt = iobj.getImportCount("BOA", yrmo); Session["taskId"] = Convert.ToInt32(Session["taskId"]) + 1; Audit.auditUserTaskI(Session.SessionID, Session["mid"].ToString(), Session["taskId"].ToString(), "ANTHEM", "Anthem Claims Reconciliation", "BOAStatement", "BOA Statement Import", yrmo, _cnt); } catch (Exception e) { status = false; throw e; } return(status); }
private static string GetCID(string slbh, string fileName, string fileType, string user, string pid) { string cid = ImportDAL.GetCID(slbh, fileName, fileType); if (cid == "") { WFM_ATTACHLST att = new WFM_ATTACHLST(); att.CID = Guid.NewGuid().ToString(); att.CNAME = fileName; if (fileType == "文件夹") { att.PID = ImportDAL.GetCID(slbh); } else { att.PID = pid; } att.PNODE = slbh; cid = ImportDAL.InserAttachlst(att, fileType, user); } return(cid); }
Boolean ImportFile(string strFilePath1) { string _yrmo = ddlYrmo.SelectedItem.Text; bool importStat = false; ImportDAL iObj = new ImportDAL(); try { DataSet ds = new DataSet(); ImportExcelReport tObj = new ImportExcelReport(); ds = tObj.importRXClaims(strFilePath1); parseDataSet pObj = new parseDataSet(); counter = pObj.parseRXClaims(ds, _yrmo); importStat = true; } catch (Exception ex) { File.Delete(strFilePath1); iObj.Rollback("ANTH_RX", _yrmo); throw ex; } return(importStat); }
/// <summary> /// 从房产库查询数据构建BDC插入实例 /// </summary> /// <param name="slbh"></param> /// <returns></returns> private static List <DOC_BINFILE> GetDoc_Binfile(string slbh) { //string[] args = new string[1]; //args[0] = "China"; //object result= WebServiceHelper.InvokeWebService(WebSrvUrl, WebSrvMethon, args); //List<Result> Res_list = (List<Result>)result; List <VolEleArcDtl> veads = ImportDAL.GetVolEleArcDtl(slbh); List <DOC_BINFILE> list = new List <DOC_BINFILE>(); //if(null!=Res_list && Res_list.Count>0) //{ // foreach (Result res in Res_list) // { foreach (VolEleArcDtl v in veads) { v.imgName = v.imgName.Replace(@"\\192.168.100.202 \", "").Replace(@"K:\", ""); VolEleArc vea = GetVolEleArc(v.VolEleArc_ID); DOC_BINFILE doc_binfile = new DOC_BINFILE(); doc_binfile.BINID = GetCID(slbh, vea.EleArcName); if (doc_binfile.BINID != "") { doc_binfile.FTPATH = v.imgName; doc_binfile.FILEID = Guid.NewGuid().ToString(); doc_binfile.FILENAME = vea.EleArcName; doc_binfile.EXTNAME = "JPG"; doc_binfile.ISCOMPRESSED = "否"; doc_binfile.ISENCRYPTED = "否"; list.Add(doc_binfile); } } // } //} return(list); }
public int Create(Import ticket) { return(ImportDAL.Create(ticket)); }
private static VolEleArc GetVolEleArc(Guid?vid) { return(ImportDAL.GetVolEleArc(vid)); }
/// <summary> /// 判断是否需要导入 /// </summary> /// <param name="p"></param> /// <returns></returns> private static bool CanImport(string p) { return(ImportDAL.CanImport(p)); }