/// <summary> /// 基于导入执行导出 /// </summary> public void Execute(ExcelGlobalDTO <TEntity> excelGlobalDTO) { excelGlobalDTO.PerformanceMonitoring.Start("=========【导出】Excel处理======"); //Excel处理 ExcelHandle(excelGlobalDTO); //删除行 DeleteRow <TEntity> deleteRow = new DeleteRow <TEntity>(); deleteRow.DeleteRows(excelGlobalDTO); excelGlobalDTO.PerformanceMonitoring.Stop(); //如果路径文件为空则不存储 if (string.IsNullOrEmpty(excelGlobalDTO.FilePath) == true) { return; } //写入内容 using (FileStream fs = new FileStream(excelGlobalDTO.FilePath, FileMode.Create)) { excelGlobalDTO.Workbook.Write(fs); fs.Dispose(); fs.Close(); } }
private void deleteRow() { try { MainWindowGuiData.IsBusy = true; var localSubItems = new SubtitleItems(); foreach (var item in subtitleItemsDataInternal) { localSubItems.Add(item); } DeleteRow.DeleteWholeRow( localSubItems, MainWindowGuiData.SelectedItem, MainWindowGuiData.OpenedFilePath ); subtitleItemsDataInternal = localSubItems; } catch (Exception ex) { ExceptionLogger.LogExceptionToFile(ex); LogWindow.AddMessage(LogType.Error, ex.Message); } finally { MainWindowGuiData.IsBusy = false; } }
public Response DeleteItemFromDB(DeleteRow delRowObj) { try { string tableName = delRowObj.TableName.ToString(); string schemaType = delRowObj.Type != null?delRowObj.Type.ToString() : string.Empty; var schema = GetTableSchema(tableName, schemaType); var delItemList = delRowObj.Data;//.Where(obj => obj.FormType == "DELETE").Select(s => s.Data).ToList(); var identityColumn = schema.Where(s => s.IsIdentity == true).FirstOrDefault(); Dictionary <string, string> result; if (identityColumn != null && delItemList.Count > 0) { using (SqlConnection con = new SqlConnection(this._connectionString)) { SqlCommand cmd = new SqlCommand(); con.Open(); cmd.Connection = con; List <string> testt = new List <string>(); foreach (var item in delItemList) { result = JsonConvert.DeserializeObject <Dictionary <string, string> >(item.ToString()); testt.Add(result.Where(s => s.Key == identityColumn.ColumnName).Select(d => d.Value).FirstOrDefault()); } string ids = string.Join(", ", testt.Select(id => id)); cmd.CommandText = string.Format("DELETE FROM {0} WHERE {1} IN ({2})", delRowObj.TableName, identityColumn.ColumnName, ids); cmd.ExecuteNonQuery(); } } else { return(new Response() { IsResponseSuccess = true, Message = "FAILED" }); } return(new Response() { IsResponseSuccess = true, Message = "SUCCESS" }); } catch (Exception ex) { return(new Response() { IsResponseSuccess = false, Message = ex.Message.ToString() }); } }
/// <summary> /// Adds all functionality to a <see cref="DataGridView"/>, so that it can be edited directly. /// </summary> /// <param name="dataGridView"><see cref="DataGridView"/></param> /// <param name="catchCurrentRowState"></param> /// <param name="rowValidated"></param> /// <param name="deleteRow"></param> public static void AddDataGridViewEditingHandlers(DataGridView dataGridView, CatchCurrentRowState catchCurrentRowState, RowValidated rowValidated, DeleteRow deleteRow) { dataGridView.CellStateChanged += (sender, e) => { catchCurrentRowState(sender, e); }; dataGridView.RowValidated += (sender, e) => { rowValidated(sender, e); }; dataGridView.KeyUp += (sender, e) => { deleteRow(sender, e); }; }
public Response DeleteItemFromDB(DeleteRow delRowObj) { return(_dynamicData.DeleteItemFromDB(delRowObj)); }