public ProcessMsg ExportTraySumPartCSV(List <string> trayIds, string filename, List <string> fieldNames) { ProcessMsg msg = new ProcessMsg() { result = false }; try { List <TrayPackView> tpv = TrayPackViewHelper.GetTPVByTrayIdsGropSumPartNr(trayIds); // List<TrayPackView> ts = tpv.ToList(); List <string> updateTrayIds = new List <string>(); CSVDataSet ds = new CSVDataSet(); foreach (TrayPackView v in tpv) { CSVDataRecord r = new CSVDataRecord(); List <string> values = ClassUtil.GetModelValues(fieldNames, v); if (values != null) { foreach (string value in values) { r.Add(value); } } //r.Add(v.partNr); //r.Add(v.capa.ToString()); if (TrayPackStatusHelper.CanAddPrefix(v.tstatus)) { r.Add(v.TsStatusCN); } ds.Add(r); if (TrayPackStatusHelper.CanUpdateToExported(v.tstatus)) { updateTrayIds.Add(v.trayId); } } CSVUtil.GenCSVFile(ds, filename); if (updateTrayIds.Count > 0) { TraysHelper.UpdateTraysStatus(updateTrayIds, TrayStatus.Exported); } msg.result = true; msg.AddMessage(ReturnCode.OK, "成功导出CSV文件"); } catch (Exception e) { msg.AddMessage(ReturnCode.Error, e.Message); } return(msg); }
public ProcessMsg ExportTraySumPartCSV(List<string> trayIds, string filename, List<string> fieldNames) { ProcessMsg msg = new ProcessMsg() { result = false }; try { List<TrayPackView> tpv = TrayPackViewHelper.GetTPVByTrayIdsGropSumPartNr(trayIds); // List<TrayPackView> ts = tpv.ToList(); List<string> updateTrayIds = new List<string>(); CSVDataSet ds = new CSVDataSet(); foreach (TrayPackView v in tpv) { CSVDataRecord r = new CSVDataRecord(); List<string> values = ClassUtil.GetModelValues(fieldNames, v); if (values != null) foreach (string value in values) r.Add(value); //r.Add(v.partNr); //r.Add(v.capa.ToString()); if (TrayPackStatusHelper.CanAddPrefix(v.tstatus)) r.Add(v.TsStatusCN); ds.Add(r); if (TrayPackStatusHelper.CanUpdateToExported(v.tstatus)) updateTrayIds.Add(v.trayId); } CSVUtil.GenCSVFile(ds, filename); if (updateTrayIds.Count > 0) TraysHelper.UpdateTraysStatus(updateTrayIds, TrayStatus.Exported); msg.result = true; msg.AddMessage(ReturnCode.OK, "成功导出CSV文件"); } catch (Exception e) { msg.AddMessage(ReturnCode.Error, e.Message); } return msg; }
public int import_contacts(string filename) { var dialer_configuration = new DialerConfigurationManager(Application.ICSession); var data = new CSVDataSet(filename); var fields = data.Fields; var columns = configuration.GetColumns(); var mapping = new Dictionary <DBColumn, DBColumn>(); foreach (var field in fields) { var column = fields.First(item => string.Compare(item.Name, field.Name) == 0); if (column != null) { mapping.Add(field, column); } } if (mapping.Keys.Count <= 0) { throw new ArgumentException(string.Format("No mapping available between Contact List {0} and CSV filename {1}", DisplayName, filename), filename); } return(configuration.BulkImport(dialer_configuration.GetHttpRequestKey(configuration.ConfigurationId), data, mapping)); }
static void Main(string[] args) { string payer = "Providence Health Plan"; string policyStartDt = "4/1/2019"; string policyEndDt = "6/1/2019"; //string path = @"C:\Users\Pradeep\Downloads\tabula-PHP_prior_authorization_code_list_short (2).csv"; string path = @"D:\Cennest\tabula-PHP_prior_authorization_code_list_new.csv"; string indexColumn = "Code"; int headerSpan = 2; var csvSet = new CSVDataSet <Dictionary <string, string> >(path, ',', headerSpan: headerSpan); var rows = csvSet.ToList(); Dictionary <int, SafeObject <string, string> > processedRows = new Dictionary <int, SafeObject <string, string> >(); int counter = 0; foreach (var row in rows) { if (row[indexColumn].ToString().Length > 0) { counter++; } if (processedRows.ContainsKey(counter) == false) { processedRows[counter] = SafeObject <string, string> .Create(); } SafeObject <string, string> line = processedRows[counter]; foreach (var key in row.Keys) { string value = row[key]; if (value.StartsWith("\"") && value.EndsWith("\"")) { value = value.Replace("\"", ""); } line[key] += value.Trim(); } } var providencePriorAuthSet = new PriorAuthorizationList(); providencePriorAuthSet.PayerName = payer; providencePriorAuthSet.BillingPolicyDocumentStartDate = policyStartDt; providencePriorAuthSet.BillingPolicyDocumentEndDate = policyEndDt; foreach (SafeObject <string, string> csvRow in processedRows.Values) { CPT cpt = new CPT(); cpt.Code = csvRow["Code"]; cpt.AuthorizationEffectiveDate = csvRow["Prior AuthorizationEffective Date"]; cpt.AuthorizationTerminationDate = csvRow["Prior AuthorizationTermination Date"]; cpt.PlanNames = csvRow["Combined PA List"]; providencePriorAuthSet.CPTList.Add(cpt); } string xml = ToXML(providencePriorAuthSet); string exportfile = Path.ChangeExtension(path, ".xml"); using (var writer = new FileWriter(exportfile, false)) { writer.WriteText(xml, false); } }
public int import_contacts(string filename) { var dialer_configuration = new DialerConfigurationManager(Application.ICSession); var data = new CSVDataSet(filename); var fields = data.Fields; var columns = configuration.GetColumns(); var mapping = new Dictionary<DBColumn, DBColumn>(); foreach(var field in fields) { var column = fields.First(item => string.Compare(item.Name, field.Name) == 0); if (column != null) { mapping.Add(field, column); } } if (mapping.Keys.Count <= 0) throw new ArgumentException(string.Format("No mapping available between Contact List {0} and CSV filename {1}", DisplayName, filename), filename); return configuration.BulkImport(dialer_configuration.GetHttpRequestKey(configuration.ConfigurationId), data, mapping); }