// sau khi add xong thuc hien cham diem, cham den dau in diem den day!
private void ExportButton_Click(object sender, EventArgs e)
{
try
{
double maxPoint = 0;
foreach (var candidate in ListResults.ElementAt(0).ListCandidates)
{
maxPoint += candidate.Point;
}
ExcelUtils.ExportResultsExcel(ListResults, ListSubmissions, maxPoint,
ListResults.ElementAt(0).ListCandidates.Count);
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "Error");
}
}
/// <summary>
/// 导出元数据页
/// </summary>
/// <param name="workbook"></param>
/// <param name="sheetName"></param>
private void ExportMetadataSheet(IWorkbook workbook, string sheetName)
{
if (sheetMetadata == null)
{
return;
}
ISheet sheet = workbook.CreateSheet(sheetName);
ICell cell = sheet.CreateRow(0).CreateCell(0);
cell.SetCellType(CellType.String);
string xmlString = ExcelUtils.XmlSerialize <SheetMetadata>(sheetMetadata);
//wyf
//xmlString = PublicUtils.Base64(xmlString, true);
cell.SetCellValue(xmlString);
}
public void WriteAllLines(Dictionary <string, string> dic, string path)
{
//直接写入excel
var listTable = new ListTable()
{
Rows = dic.Select(p => new List <object>()
{
p.Key, p.Value
}).ToList(),
Columns = new List <string>()
{
"key", "value"
}
};
ExcelUtils.ExportToExcel(listTable.ToDataTable(), Path.ChangeExtension(path, ".xlsx"));
}
public void Init(DataTable dt)
{
if (dt == null || dt.Rows.Count == 0)
{
return;
}
DataCount = dt.Rows.Count;
ExcelUtils.UnLockSheet(this);
LoadData(dt);
SetFormula();
ResetFormat();
ExcelUtils.LockSheet(this);
}
/// <summary>
/// 多个DataTable保存在同一文件
/// </summary>
public void ToOneExcel()
{
var dts = CheckPath(getSelectExtension).AsParallel().SelectMany(file =>
{
Console.WriteLine(" is now : " + file);
return(import(file).Where(p => p != null).Select(p =>
{
p.TableName = Path.GetFileNameWithoutExtension(file);
return p;
}));
}).ToList();
if (dts.Count == 0)
{
return;
}
ExcelUtils.ExportToExcel(dts, InputPath);
}
public void ClearData()
{
try
{
ExcelUtils.UnLockSheet(this);
if (DataCount > 0)
{
Excel.Range rg;
rg = this.Range[string.Format(DATA_ROW, TITLE_ROW_COUNT + 1, TITLE_ROW_COUNT + DataCount)];
rg.Clear();
}
ExcelUtils.LockSheet(this);
}
catch (Exception ex)
{
LogHelper.WriteError("", ex);
}
}
public ActionResult LastReadable(int id)
{
var workbook = new XLWorkbook();
JourEvenement jour;
using (var ctx = new FestivArtsContext())
{
jour = ctx.JourEvenements.First(s => s.Id == id);
Planning p = ctx.Plannings.Include("Affectations.Benevole").OrderByDescending(s => s.Date).FirstOrDefault();
ExcelUtils.FillPlanning(workbook, ctx, jour, p, true);
}
var stream = new MemoryStream();
workbook.SaveAs(stream);
stream.Position = 0;
return(File(stream, "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet", "Planning" + jour.Nom + ".xlsx"));
}
public void Load(string filePath)
{
m_columnNames = new List <string>();
var table = ExcelUtils.ReadCsv(filePath);
for (int i = 0; i < table.Columns.Count; ++i)
{
m_columnNames.Add(table.Columns[i].ColumnName);
}
for (int i = 0; i < table.Rows.Count; ++i)
{
var record = new CollateralCsvRecord();
bool isValidRecord = true;
for (int j = 0; j < table.Columns.Count; ++j)
{
var columnName = m_columnNames[j];
var cellValue = table.Rows[i].ItemArray[j].ToString();
if (columnName.Equals("AssetId", StringComparison.CurrentCultureIgnoreCase))
{
if (string.IsNullOrEmpty(cellValue))
{
isValidRecord = false;
break;
}
record.AssetId = int.Parse(cellValue);
}
else
{
record.Items[columnName] = cellValue;
}
}
if (isValidRecord)
{
this.Add(record);
}
}
FilePath = filePath;
}
public void OnEnable()
{
assetPath = AssetDatabase.GetAssetPath(target);
if (assetPath.IsExcel())
{
var book = ExcelUtils.Open(assetPath);
var tmp = new BookStruct();
tmp.Name = assetPath;
tmp.Book = book;
foreach (var sheet in book.AllSheets())
{
var ss = new SheetStruct();
ss.Name = sheet.SheetName;
ss.Sheet = sheet;
tmp.Sheets.Add(ss);
}
mTarget = tmp;
}
}
/// <summary> 匯出報表 - EXCEL </summary>
/// <param name="data"></param>
/// <param name="exportFileName"></param>
/// <returns></returns>
private string ExportData(DataSet data, string exportFileName)
{
var fileName = string.Empty;
switch (reportSetting.ExportType)
{
default:
case ExportType.CSV:
fileName = string.Format("{0}_{1}.csv", exportFileName, DateTime.Now.ToString("yyyyMMddHHmmss"));
CsvUtils.export(data, reportSetting.ExportPH, fileName);
break;
case ExportType.EXCEL:
fileName = string.Format("{0}_{1}.xls", exportFileName, DateTime.Now.ToString("yyyyMMddHHmmss"));
ExcelUtils.export(data, reportSetting.ExportPH, fileName);
break;
}
return(fileName);
}
private StandardTableDataCM CreateStandardTableCMFromExcelFile(byte[] excelFile, string excelFileExtension)
{
var rowsDictionary = ExcelUtils.GetTabularData(excelFile, excelFileExtension, false);
if (rowsDictionary != null)
{
var rows = ExcelUtils.CreateTableCellPayloadObjects(rowsDictionary);
if (rows != null)
{
return(new StandardTableDataCM
{
FirstRowHeaders = false,
Table = rows
});
}
}
return(null);
}
private decimal GetVATRate(IExcelDataReader reader, SheetConfig config, decimal defaultVatRate)
{
if (!config.VatRates.Any())
{
return(defaultVatRate);
}
foreach (var rate in config.VatRates)
{
var index = ExcelUtils.ColumnToIndex(rate.Column);
var value = Utils.GetValue(reader, index).TrimWhiteSpace();
if (value.IgnoreCaseEquals(rate.Value))
{
return(rate.Rate);
}
}
return(defaultVatRate);
}
public async Task GetAllSortedMaxCurrRatiosTest()
{
try
{
DateTime startTime = DateTime.Now.AddHours(-1);
DateTime endTime = startTime.AddMinutes(1);
FaultSortEngine faultSortEngine = new FaultSortEngine();
faultSortEngine.GetLinesInfoFromDb();
List <Tuple <double, string, DateTime> > sortedMaxCurrRatios = await faultSortEngine.GetAllSortedMaxCurrRatios(faultSortEngine.WindowStartTime, faultSortEngine.WindowEndTime);
List <double> sortedMaxCurrRatioVals = sortedMaxCurrRatios.Select(ratioTuple => ratioTuple.Item1).ToList();
// dump the results to excel
string dateStr = DateTime.Now.ToString("yyyyMMddHHmmss");
ExcelUtils.DumpCurrRatioResultsToExcel(sortedMaxCurrRatios, $"E:\\sortedCurrRatios{dateStr}.xlsx");
}
catch (Exception e)
{
Assert.Fail(e.Message);
}
}
private void RunImport(string path, Encoding encode)
{
var dt = ExcelUtils.ReadDataFile(path, encode);
dtImport = dt;
foreach (DataRow item in dt.Rows)
{
if (item.ItemArray.Length > 2 && Regex.IsMatch(item[1].ToString(), "^[0-9]{1,5}$"))
{
item[1] = Utils.AutoAddZero(item[1].ToString());
}
}
dtImport.TableName = path.Substring(path.LastIndexOf('\\') + 1);
this.Dispatcher.Invoke(() =>
{
this.dgImportData.ItemsSource = dtImport.DefaultView;
txtMsg.AppendText(string.Format("已读取文件{0}，数据共{1}行.{2}", path, dt.Rows.Count, Environment.NewLine));
this.loading.HideLoading();
});
}
public HttpResponseMessage GetExcel(int moduleId, int tabId, string template, string fileName)
{
ModuleController mc = new ModuleController();
IEnumerable <IDataItem> dataList = new List <IDataItem>();
var module = new OpenContentModuleInfo(moduleId, tabId);
var manifest = module.Settings.Template.Manifest;
if (!OpenContentUtils.HasAllUsersViewPermissions(PortalSettings, module.ViewModule))
{
return(Request.CreateResponse(HttpStatusCode.Unauthorized));
}
bool useLucene = module.Settings.Template.Manifest.Index;
if (useLucene)
{
var indexConfig = OpenContentUtils.GetIndexConfig(module.Settings.Template);
QueryBuilder queryBuilder = new QueryBuilder(indexConfig);
queryBuilder.Build(module.Settings.Query, PortalSettings.UserMode != PortalSettings.Mode.Edit, UserInfo.UserID, DnnLanguageUtils.GetCurrentCultureCode(), UserInfo.Social.Roles);
IDataSource ds = DataSourceManager.GetDataSource(module.Settings.Manifest.DataSource);
var dsContext = OpenContentUtils.CreateDataContext(module, UserInfo.UserID);
var dsItems = ds.GetAll(dsContext, queryBuilder.Select);
dataList = dsItems.Items;
}
var mf = new ModelFactoryMultiple(dataList, null, module.Settings.TemplateDir.PhysicalFullDirectory, manifest, null, null, module, PortalSettings);
dynamic model = mf.GetModelAsDictionary(true);
var rssTemplate = new FileUri(module.Settings.TemplateDir, template + ".hbs");
string source = rssTemplate.FileExists ? FileUriUtils.ReadFileFromDisk(rssTemplate) : GenerateCsvTemplateFromModel(model, rssTemplate);
HandlebarsEngine hbEngine = new HandlebarsEngine();
string res = hbEngine.Execute(source, model);
var fileBytes = ExcelUtils.OutputFile(res);
return(ExcelUtils.CreateExcelResponseMessage(fileName, fileBytes));
}
public void CreateExcel()
{
string dllPath = AppDomain.CurrentDomain.SetupInformation.ApplicationBase;
string excelTemplatePath = dllPath.Replace("application\\", "Cofigure\\ShopDoc_Template-test.xlsx");
string path = part.FullPath;
path = System.IO.Path.GetDirectoryName(path) + "\\" + part.Name + ".xlsx";
IWorkbook workbook = ExcelUtils.CreateExeclFile(excelTemplatePath);
if (workbook == null)
{
return;
}
IFont font = workbook.CreateFont();
font.FontName = "微软雅黑";
font.FontHeightInPoints = 8;
ICellStyle style = ExcelUtils.SetCellStyle(workbook, font);
ICellStyle styleDate = ExcelUtils.SetCellStyle(workbook, font);
styleDate.DataFormat = 21;
ISheet sheet = workbook.GetSheetAt(0);
MoldInfo mold = this.info.GetMoldInfo();
if (this.info.IsWorkpiece())
{
SetMoldInfoToExcel(mold, sheet, style);
}
else
{
SetEleMoldInfoToExcel(mold, sheet, style);
}
SetUser(sheet, style);
SetRowData(sheet, style, styleDate);
FileStream fs = File.Create(path);
workbook.Write(fs);
fs.Close();
workbook.Close();
}
public void ClearFilter()
{
try
{
if (!this.AutoFilter.FilterMode || DataCount == 0)
{
return;
}
ExcelUtils.UnLockSheet(this);
for (int i = 1; i < columns.Length + 1; i++)
{
this.Range[string.Format(DATA_ROW, TITLE_ROW_COUNT + 1, TITLE_ROW_COUNT + DataCount)].AutoFilter(i, System.Type.Missing, Microsoft.Office.Interop.Excel.XlAutoFilterOperator.xlAnd, System.Type.Missing, true);
}
ExcelUtils.LockSheet(this);
}
catch (Exception ex)
{
LogHelper.WriteError("", ex);
}
}
private bool ReadToDataTable(string FileName, out DataTable dt, out string errMsg)
{
dt = null;
errMsg = null;
try
{
dt = CommonUtils.IsExcel(FileName) ? ExcelUtils.ReadExcel(FileName) : CommonUtils.ReadCSV(FileName);
FixTableData(dt);
dt.TableName = FileName;
return(true);
}
catch (NPOI.POIFS.FileSystem.NotOLE2FileException)
{
errMsg = "文件格式不正确，请尝试用Excel另存为后打开";
}
catch (Exception ex)
{
errMsg = ex.Message;
}
return(false);
}
public KvExcelTo(object obj) : base()
{
KvExcelTo(isCustomAction: (fullpath, list) =>
{
Dictionary <string, JsonData> dictionary = new Dictionary <string, JsonData>();
foreach (List <object> objects in list)
{
object id = objects[1];
string key = objects[2].ToString();
object value = objects[3];
string value_zh_cn = objects[4].ToString();
dictionary[id.ToString()] = value_zh_cn;
}
JsonData jsonData = JsonHelper.ToObject(File.ReadAllText(fullpath).Trim().Trim('\0'));
JsonHelper.RevertDictionaryToJson(jsonData, dictionary);
return(ExcelUtils.ExportToJson(jsonData));
}, isArray: (bool)obj
);
}
private void button6_Click(object sender, EventArgs e)
{
//通过excel数据生成insertSql语句
(new FrmExcel()).ShowDialog();
return;
string filePath = "";
#region choose import file
OpenFileDialog dialog = new OpenFileDialog();
dialog.Filter = "(Microsoft Excel 2013;Microsoft Excel 2007)|*.xlsx;*.xls";
DialogResult dialogResult = dialog.ShowDialog();
if (DialogResult.Cancel == dialogResult)
{
return;
}
else if (DialogResult.OK == dialogResult)
{
filePath = dialog.FileName;
}
#endregion
string result = "";
var sheetNames = ExcelUtils.GetXlsSheetnames(filePath, out result);
//DataSet ds = FileUtils.GetExcelDataSet(filePath);
//string tableName = ds.Tables[0].Rows[2 - 1][1 - 1].ToString(), insertColumnList = "";
//for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
//{
// insertColumnList += string.Format(ds.Tables[0].Rows[3 - 1][i].ToString() + ",");
//}
//insertColumnList = deleteLastDouhao(insertColumnList); //去除最后的,号
////insert inot tb() values
//StringBuilder sbSql = new StringBuilder();
//sbSql.AppendFormat(("insert into "));
//sbSql.AppendFormat(tableName);
//sbSql.AppendFormat(@"(");
//sbSql.AppendFormat(insertColumnList);
//sbSql.AppendFormat(@") values (");
//sbSql.AppendFormat(@");");
}
/// <summary>
/// 开始检查译文
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void click_BeginCheckFile(object sender, RoutedEventArgs e)
{
//1 首先要有译文
string filePath = tbFilePath.Text;
if (File.Exists(filePath))
{
//还没设置译文列位置
if (Argument.TargetColumn > 0 == false)
{
User_SetUp(sender, e);
}
//格式转换xls-->xlsx
if (filePath.EndsWith(".xls"))
{
filePath = ConvertWorkbook(filePath, Argument.OutPutDiretory);
}
try
{
//2 判断是否规范
if (ExcelUtils.IsTranslationFile(filePath))
{
//3 将参数交由后台线程去做主要的事情
backgroundWorker.RunWorkerAsync(new InputContainer(filePath));
btnHandle.IsEnabled = false;
btnOpenFile.IsEnabled = false;
}
}
catch (Exception)
{
OpenWindowsUtils.OpenMyMessageBox(false, "文件已被其它程序占用，请关闭占用该文件的程序",
"The file has been occupied by other programs.",
this);
}
}
else
{
OpenWindowsUtils.OpenMyMessageBox(false, "请您选择待检测的译文文件", "Please select the translation file", this);
}
}
/// <summary>
/// excel 转换为jtcy 对象
/// </summary>
/// <param name="path">Excel路径</param>
/// <returns></returns>
public static ObservableCollection <JTCY> GetExcelToHZS(string path)
{
ObservableCollection <JTCY> list = ExcelUtils.GetExcelToObjectToObservableCollection <JTCY>(path, XMLPath);
ObservableCollection <JTCY> hzs = GetJTCYSToHz(list);
//户主放在第一位
for (int b = 0; b < hzs.Count; b++)
{
JTCY hz = hzs[b];
if (Utils.IsStrNull(hz.GMSFHM))
{
hzs.RemoveAt(b);
b--;
continue;
}
IList <JTCY> jTCies = hz.JTCies;
for (int a = 1; a < jTCies.Count; a++)
{
JTCY jTCY = jTCies[a];
if (jTCY.YHZGX == "户主")
{
jTCies.RemoveAt(a);
jTCies.Insert(0, jTCY);
break;
}
}
for (int a = 2; a < jTCies.Count; a++)
{
JTCY jTCY = jTCies[a];
if (jTCY.YHZGX == "妻")
{
jTCies.RemoveAt(a);
jTCies.Insert(1, jTCY);
break;
}
}
}
return(hzs);
}
public void Load(string filePath)
{
Clear();
if (!File.Exists(filePath))
{
return;
}
var dt = ExcelUtils.ReadCsv(filePath);
for (int i = 0; i < dt.Rows.Count; ++i)
{
var row = dt.Rows[i];
if (row.ItemArray.Length < 3)
{
continue;
}
int assetId;
DateTime reductionDate;
double reductionAmount;
if (int.TryParse(row.ItemArray[0].ToString(), out assetId) &&
DateTime.TryParse(row.ItemArray[1].ToString(), out reductionDate) &&
double.TryParse(row.ItemArray[2].ToString(), out reductionAmount) &&
MathUtils.MoneyNE(reductionAmount, 0))
{
var record = new AmortizationScheduleRecord()
{
AssetId = assetId,
ReductionDate = reductionDate,
ReductionAmount = reductionAmount
};
Add(record);
}
}
m_filePath = filePath;
}
private void Button_Upload_Click(object sender, RoutedEventArgs e)
{
if (!ViewModel.Files.Any(f => f.IsSelected))
{
MessageBox.Show("Не выбран файл", "Внимание!");
return;
}
foreach (var file in ViewModel.Files.Where(f => f.IsSelected))
{
var hasError = false;
foreach (var person in ExcelUtils.LoadInputForm(file.Path))
{
var sql = $@"
EXECUTE pr_AddPerson
'{person.PassportSerial}'
,'{person.LastName}'
,'{person.FirstName}'
,'{person.Patronymic}'
,'{person.BirthDate}'
,'{person.BirthPlace}'
,'{person.PassportIssue}'
,'{person.PassportIssueDate}'
,'{person.PassportDivisionCode}'
,'{person.Address}'
,'{person.PhoneHome}'
,'{person.PhoneMobile}'
,{person.RecruitmentOfficeID}
,'{person.Codeword}'
,'{person.Comment}'
";
using (var sqlComm = new SqlCommandExecutor(sql))
if (!sqlComm.TryExecuteNonQuery(out _))
{
hasError = true;
}
}
file.IsImported = !hasError;
file.HasError = hasError;
}
}
public void Save(string filePath = null)
{
DataTable dtAmort = new DataTable();
dtAmort.Columns.Add("AssetId");
dtAmort.Columns.Add("ReductionDate");
dtAmort.Columns.Add("ReductionAmount");
var list = this.OrderBy(x => x.AssetId).ThenBy(x => x.ReductionDate);
foreach (var record in list)
{
dtAmort.Rows.Add(record.AssetId, record.ReductionDate.ToString("yyyy/MM/dd"), record.ReductionAmount.ToString("n2"));
}
if (string.IsNullOrEmpty(filePath))
{
filePath = m_filePath;
}
ExcelUtils.WriteCsv(dtAmort, filePath);
}
private void Button_Click_4(object sender, RoutedEventArgs e)
{
MessageBoxResult result = MessageBox.Show("请使用下载的模板进行导入!!!!\n是否下载模板(选否则直接选择文件导入)", "提示", MessageBoxButton.YesNo);
if (result == MessageBoxResult.Yes)
{
string localFilePath = "";
//string localFilePath, fileNameExt, newFileName, FilePath;
System.Windows.Forms.SaveFileDialog sfd = new System.Windows.Forms.SaveFileDialog();
//设置文件类型
sfd.Filter = "Excel表格（*.xls）|*.xls";
//设置默认文件类型显示顺序
sfd.FilterIndex = 1;
//保存对话框是否记忆上次打开的目录
sfd.RestoreDirectory = true;
//点了保存按钮进入
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
localFilePath = sfd.FileName.ToString(); //获得文件路径
ExcelUtils.downModel(localFilePath);
}
}
if (result == MessageBoxResult.No)
{
System.Windows.Forms.OpenFileDialog fileDialog = new System.Windows.Forms.OpenFileDialog();
fileDialog.Multiselect = true;
fileDialog.Title = "请选择文件";
fileDialog.Filter = "所有文件(*xls*)|*.xls*"; //设置要选择的文件的类型
if (fileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
string file = fileDialog.FileName;//返回文件的完整路径
ExcelUtils.import(file, departmentId);
refreashMember();
}
}
}
private VariablesInfo LoadFromFile(string filename)
{
var filepath = Path.Combine(m_dsFolder, filename);
DataTable dt = ExcelUtils.ReadCsv(filepath);
DateTime d;
List <VariablesCsvRecord> values = new List <VariablesCsvRecord>();
var columns = dt.Columns.Cast <DataColumn>().Select(o => o.ColumnName.Trim().ToLower())
.Select(o => DateTime.TryParse(o, out d) ? o : "")
.Where(o => !String.IsNullOrEmpty(o))
.ToList();
foreach (DataRow row in dt.Rows)
{
var name = row.Field <string>("Name");
var des = row.Field <string>("Description");
if (String.IsNullOrEmpty(name))
{
continue;
}
VariablesCsvRecord item = new VariablesCsvRecord()
{
Name = name,
Description = des
};
values.Add(item);
foreach (var col in columns)
{
var date = Convert.ToDateTime(col);
string value = row[col] == DBNull.Value ? "" : row[col].ToString();
if (!string.IsNullOrEmpty(value))
{
item.Items.Add(date, value);
}
}
}
return(new VariablesInfo {
Variables = values, Dates = columns.Select(o => Convert.ToDateTime(o)).ToList()
});
}
private static List <ReviewFields> ParceInputFile(MemoryStream input)
{
List <ReviewFields> rfs = new List <ReviewFields>();
SpreadsheetDocument ssd = SpreadsheetDocument.Open(input, true);
WorkbookPart workbookPart = ssd.WorkbookPart;
WorksheetPart worksheetPart = workbookPart.WorksheetParts.FirstOrDefault();
Sheets sheets = workbookPart.Workbook.Sheets;
Sheet sheet = sheets.GetFirstChild <Sheet>();
SheetData sheetData = worksheetPart.Worksheet.Descendants <SheetData>().FirstOrDefault();
SharedStringTablePart sharedStringPart = workbookPart.SharedStringTablePart;
foreach (var row in sheetData.Elements <Row>())
{
if (row.RowIndex == 1)
{
continue;
}
ReviewFields rf = new ReviewFields();
rf.Discipline = ExcelUtils.GetCellText(sharedStringPart, row, "A");
rf.Theme = ExcelUtils.GetCellText(sharedStringPart, row, "B");
rf.StudentName = ExcelUtils.GetCellText(sharedStringPart, row, "C");
rf.StudentGroup = ExcelUtils.GetCellText(sharedStringPart, row, "D");
rf.ChiefName = ExcelUtils.GetCellText(sharedStringPart, row, "E");
uint number;
if (UInt32.TryParse(ExcelUtils.GetCellText(sharedStringPart, row, "F"), out number))
{
rf.Evaluation = number;
}
else
{
rf.Evaluation = 0;
}
rf.EvaluatonsSet = GetRandomEvaluationsSet(rf.Evaluation);
rfs.Add(rf);
}
ssd.Close();
return(rfs);
}
public ICellStyle AppendStyleTaskStatus(ICellStyle style, Cell cell)
{
if (cell.IsEmpty)
{
return(AppendStyleDefaultBorder(style));
}
var cellValue = cell.GetCellValue();
if (cellValue == "完成" || cellValue == "错误")
{
return(ExcelUtils.GetFontColorStyle(m_workbook.GetIWorkbook(), ExcelFontColor.Green));
}
else if (cellValue == "进行中" || cellValue == "等待")
{
return(ExcelUtils.GetFontColorStyle(m_workbook.GetIWorkbook(), ExcelFontColor.Blue));
}
else if (cellValue == "逾期")
{
return(ExcelUtils.GetFontColorStyle(m_workbook.GetIWorkbook(), ExcelFontColor.Red));
}
return(style);
}
public IHttpActionResult Gather()
{
try
{
var request = Context.AuthenticatedRequest;
var siteId = request.GetQueryInt("siteId");
var ruleId = request.GetQueryInt("ruleId");
if (!request.IsAdminLoggin ||
!request.AdminPermissions.HasSitePermissions(siteId, Utils.PluginId))
{
return(Unauthorized());
}
var channelId = request.GetPostInt("channelId");
var guid = request.GetPostString("guid");
var gatherType = request.GetPostString("gatherType");
var fileName = request.GetPostString("fileName");
var urls = TranslateUtils.StringCollectionToStringList(request.GetPostString("urls"), '\n');
if (gatherType == "excel")
{
var filePath = Context.UtilsApi.GetTemporaryFilesPath(fileName);
urls = ExcelUtils.GetContentUrls(filePath);
}
var adminInfo = Context.AdminApi.GetAdminInfoByUserId(request.AdminId);
Main.GatherRuleRepository.GatherContents(adminInfo, siteId, ruleId, channelId, guid, urls);
return(Ok(new
{
Value = true
}));
}
catch (Exception ex)
{
return(InternalServerError(ex));
}
}
