public void ExpotToExcel(DataGridView dataGridView1,string SaveFilePath)
{
xlApp = new Excel.Application();
xlWorkBook = xlApp.Workbooks.Add(misValue);
xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
int i = 0;
int j = 0;
for (i = 0; i <= dataGridView1.RowCount - 1; i++)
{
for (j = 0; j <= dataGridView1.ColumnCount - 1; j++)
{
DataGridViewCell cell = dataGridView1[j, i];
xlWorkSheet.Cells[i + 1, j + 1] = cell.Value;
}
}
xlWorkBook.SaveAs(SaveFilePath, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
xlWorkBook.Close(true, misValue, misValue);
xlApp.Quit();
releaseObject(xlWorkSheet);
releaseObject(xlWorkBook);
releaseObject(xlApp);
MessageBox.Show("Your file is saved" + SaveFilePath);
}
/// <summary>
/// 打印信息的初始化
/// </summary>
/// <param datagrid="DataGridView">打印数据</param>
/// <param PageS="int">纸张大小</param>
/// <param lendscape="bool">是否横向打印</param>
public PrintClass(DataGridView datagrid, int PageS, bool lendscape)
{
this.datagrid = datagrid;//获取打印数据
this.PageSheet = PageS;//纸张大小
printdocument = new PrintDocument();//实例化PrintDocument类
pagesetupdialog = new PageSetupDialog();//实例化PageSetupDialog类
pagesetupdialog.Document = printdocument;//获取当前页的设置
printpreviewdialog = new PrintPreviewDialog();//实例化PrintPreviewDialog类
printpreviewdialog.Document = printdocument;//获取预览文档的信息
printpreviewdialog.FormBorderStyle = FormBorderStyle.Fixed3D;//设置窗体的边框样式
//横向打印的设置
if (PageSheet >= 0)
{
if (lendscape == true)
{
printdocument.DefaultPageSettings.Landscape = lendscape;//横向打印
}
else
{
printdocument.DefaultPageSettings.Landscape = lendscape;//纵向打印
}
}
pagesetupdialog.Document = printdocument;
printdocument.PrintPage += new PrintPageEventHandler(this.printdocument_printpage);//事件的重载
}
public BeneficioCadastro(
ButtonBase botaoSalvar,
ButtonBase botaoCancelar,
Form tela,
DataGridView beneficioGridView
)
{
this.Botao_Salvar = botaoSalvar;
this.Botao_Cancelar = botaoCancelar;
this.Tela = tela;
Beneficios = TiposBeneficio.ObterListaAssociada();
beneficioGridView.AutoGenerateColumns = false;
beneficioGridView.DataSource = Beneficios;
Botao_Salvar.Click += new EventHandler(Botao_Salvar_Click);
Botao_Cancelar.Click += new EventHandler(Botao_Cancelar_Click);
Beneficios.AddingNew += (sender, args) =>
{
if (beneficioGridView.Rows.Count == Beneficios.Count)
{
Beneficios.RemoveAt(Beneficios.Count - 1);
return;
}
};
AoCancelar += () =>
{
beneficioGridView.DataSource = Beneficios;
};
AoSalvar += () =>
{
TiposBeneficio.DispararAtualizacao();
};
}
public override string getMa(DataGridView grid)
{
DataGridViewRow row = grid.SelectedRows[0];
string MaMAU = row.Cells["MaMauVaChePhamMau"].Value.ToString();
return MaMAU;
//return base.getMaThuoc(grid);
}
public NewAssDlg(MainForm f, DataGridView dv)
{
InitializeComponent();
mf = f;
mf.recvEvent += new MainForm.RecvEventHandler(this.RecvDataEvent);
dataGridView1 = dv;
}
private void ExportarDataGridViewExcel(DataGridView grd)
{
SaveFileDialog fichero = new SaveFileDialog();
fichero.Filter = "Excel (*.xls)|*.xls";
if (fichero.ShowDialog() == DialogResult.OK)
{
Microsoft.Office.Interop.Excel.Application aplicacion;
Microsoft.Office.Interop.Excel.Workbook libros_trabajo;
Microsoft.Office.Interop.Excel.Worksheet hoja_trabajo;
aplicacion = new Microsoft.Office.Interop.Excel.Application();
libros_trabajo = aplicacion.Workbooks.Add();
hoja_trabajo =
(Microsoft.Office.Interop.Excel.Worksheet)libros_trabajo.Worksheets.get_Item(1);
//Recorremos el DataGridView rellenando la hoja de trabajo
for (int i = 0; i < grd.Rows.Count ; i++)
{
for (int j = 0; j < grd.Columns.Count; j++)
{
hoja_trabajo.Cells[i + 1, j + 1] = grd.Rows[i].Cells[j].Value.ToString();
}
}
libros_trabajo.SaveAs(fichero.FileName,
Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal);
libros_trabajo.Close(true);
aplicacion.Quit();
}
}
private double medie(DataGridView dgv)
{
int sum = 0;
for (int i = 0; i < dgv.Rows.Count; i++)
sum += Convert.ToInt32(dgv.Rows[i].Cells[1].Value);
return Math.Round((double)sum / (dgv.RowCount - 1),2);
}
/// <summary>
/// TuneList Constructor.
/// </summary>
/// <param name="appForm">Main application form</param>
/// <param name="dgv">DataGridView from main application form</param>
public TuneList(DDTuneTrackForm appForm, DataGridView dgv)
{
mAppForm = appForm;
mTuneListDGV = dgv;
InitializeDataGridView();
}
public FormulaireModif(int idServ,int pIdEtat,DataGridView pTableau)
{
idService = idServ;
idEtat = pIdEtat;
tableau = pTableau;
InitializeComponent();
}
protected override void Show(IDialogVisualizerService windowService, IVisualizerObjectProvider provider)
{
using (Form form1 = new Form())
{
form1.Text = "FormCollection Visualizer";
form1.StartPosition = FormStartPosition.WindowsDefaultLocation;
form1.SizeGripStyle = SizeGripStyle.Auto;
form1.ShowInTaskbar = false;
form1.ShowIcon = false;
DataTable dt;
using (Stream stream = provider.GetData())
{
BinaryFormatter bformatter = new BinaryFormatter();
dt = (DataTable)bformatter.Deserialize(stream);
stream.Close();
}
DataGridView gridView = new DataGridView();
gridView.Dock = DockStyle.Fill;
form1.Controls.Add(gridView);
gridView.DataSource = dt;
windowService.ShowDialog(form1);
}
}
/// ------------------------------------------------------------------------------------
public void InitializeGrid(DataGridView grid)
{
foreach (var col in Columns)
{
if (!grid.Columns.Contains(col.Id))
continue;
grid.Columns[col.Id].Visible = col.Visible;
if (col.Width >= 0)
grid.Columns[col.Id].Width = col.Width;
if (col.DisplayIndex < 0)
grid.Columns[col.Id].DisplayIndex = 0;
else if (col.DisplayIndex >= grid.ColumnCount)
grid.Columns[col.Id].DisplayIndex = grid.ColumnCount - 1;
else
grid.Columns[col.Id].DisplayIndex = col.DisplayIndex;
}
if (!string.IsNullOrEmpty(SortedColumn) && grid.Columns.Contains(SortedColumn))
grid.Sort(grid.Columns[SortedColumn], SortOrder == SortOrder.Descending ? ListSortDirection.Descending : ListSortDirection.Ascending);
// If the column header height or the former dpi settings are different,
// then auto. calculate the height of the column headings.
if (ColumnHeaderHeight <= 0 || DPI != m_currDpi)
grid.AutoResizeColumnHeadersHeight();
else
grid.ColumnHeadersHeight = ColumnHeaderHeight;
}
public static void listarMicros(DataGridView dgMicros, String patente, String patenteEstimada,
String modelo, String modeloEstimado, DateTimePicker dtpFechaAlta, String marca, String tipoServicio,
decimal numero, bool mostrarDeshabilitados, bool mostrarHabilitados)
{
try
{
using (SqlConnection conn = new SqlConnection(main.connString))
using (SqlCommand cmd = new SqlCommand("BONDIOLA.listarMicros", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
SQL_Library.agregarParametro(cmd, "@patente", patente);
SQL_Library.agregarParametro(cmd, "@patenteEstimada", patenteEstimada);
SQL_Library.agregarParametro(cmd, "@modelo", modelo);
SQL_Library.agregarParametro(cmd, "@modeloEstimado", modeloEstimado);
SQL_Library.agregarParametroFecha(cmd, dtpFechaAlta, "@fecha_alta");
SQL_Library.agregarParametro(cmd, "@marca", marca);
SQL_Library.agregarParametro(cmd, "@tipoServicio", tipoServicio);
SQL_Library.agregarParametro(cmd, "@numero", numero);
SQL_Library.agregarParametro(cmd, "@mostrarDeshabilitados", mostrarDeshabilitados);
SQL_Library.agregarParametro(cmd, "@mostrarHabilitados", mostrarHabilitados);
SQL_Library.agregarParametro(cmd, "@fechaActual", Properties.Settings.Default.Fecha);
SQL_Library.llenarDataGrid(dgMicros, conn, cmd);
}
}
catch (SqlException ex)
{
MessageBox.Show(ex.Message);
}
}
public OptionsManager(IBClient ibClient, DataGridView callGrid, DataGridView putGrid, DataGridView optionPositionsGrid)
{
this.ibClient = ibClient;
this.callGrid = callGrid;
this.putGrid = putGrid;
this.positionsGrid = optionPositionsGrid;
}
private void Init()
{
DataGridView dgv = new DataGridView()
{
Width = 700,
ReadOnly = true,
AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.AllCells,
};
dgv.DataSource = _level.GetTotalWeightVect().Transpose().ToDataTable();
//设置显示格式
dgv.CellFormatting += (sender, e) =>
{
//不处理新建行
if (e.RowIndex != dgv.NewRowIndex)
{
double d = double.Parse(e.Value.ToString());
e.Value = d.ToString("N3");
}
};
totalSortPanel.Controls.Add(dgv);
ciLabel.Text = string.Format("CI={0:f4}", _level.LevelCI);
riLabel.Text = string.Format("RI={0:f4}", _level.LevelRI);
crLabel.Text = string.Format("CR={0:f4}", _level.LevelCR);
}
void CreateEmptyGrid()
{
m_Grid = new DataGridView();
m_Grid.ReadOnly = true;
m_Grid.Parent = this;
m_Grid.Dock = DockStyle.Fill;
m_Table = new DataTable();
m_Grid.DataSource = m_Table;
//Add base item attributes
Type ItemType = typeof(GameplayItem);
Type ItemAttrType = typeof(ItemAttributes);
System.Reflection.FieldInfo[] ItemFields = ItemType.GetFields();
System.Reflection.FieldInfo[] ItemAttrFields = ItemAttrType.GetFields();
List<string> FieldNames = new List<string>();
foreach (System.Reflection.FieldInfo Info in ItemFields)
{
FieldNames.Add(Info.Name);
DataGridViewColumn Col = new DataGridViewColumn(CreateCellTemplate(Info));
Col.Name = Info.Name;
//m_Grid.Columns.Add(Col);
m_Table.Columns.Add(Info.Name, Info.FieldType);
}
foreach (System.Reflection.FieldInfo Info in ItemAttrFields)
{
FieldNames.Add(Info.Name);
DataGridViewColumn Col = new DataGridViewColumn(CreateCellTemplate(Info));
Col.Name = Info.Name;
//m_Grid.Columns.Add(Col);
m_Table.Columns.Add(Info.Name, Info.FieldType);
}
}
public void buildGui()
{
var topPanel = this.add_Panel();
Path = topPanel.insert_Above<TextBox>(20);
sourceCode = topPanel.add_SourceCodeEditor();
dataGridView = sourceCode.insert_Above<Panel>(100).add_DataGridView();
leftPanel = topPanel.insert_Left<Panel>(300);
Path.onEnter(loadFiles);
Path.onDrop(
(fileOrFolder)=>{
Path.set_Text(fileOrFolder);
loadFiles(fileOrFolder);
});
dataGridView.SelectionChanged+=
(sender,e) => {
if (dataGridView.SelectedRows.size() == 1)
{
var selectedRow = dataGridView.SelectedRows[0];
var filePath = selectedRow.Cells[0].Value.str();
var filename = selectedRow.Cells[1].Value.str();
var lineNumber = selectedRow.Cells[2].Value.str();
"opening up source code: {0}".info(filePath);
sourceCode.open(filePath.pathCombine(filename));
sourceCode.gotoLine(lineNumber.toInt() + 1);
dataGridView.focus();
}
};
}
public void ExportToExcel(DataGridView grid,string r_id,string time)
{
ApplicationClass Excel = new ApplicationClass();
XlReferenceStyle RefStyle = Excel.ReferenceStyle;
Excel.Visible = true;
Workbook wb = null;
String TemplatePath = System.Windows.Forms.Application.StartupPath + @"\Отчет"+r_id+".xlt";
try
{
wb = Excel.Workbooks.Add(TemplatePath); // !!!
}
catch (System.Exception ex)
{
throw new Exception("Не удалось загрузить шаблон для экспорта " + TemplatePath + "\n" + ex.Message);
}
Worksheet ws = wb.Worksheets.get_Item(1) as Worksheet;
ws.Cells[20, 3] = time;
for (int j = 0; j < grid.Columns.Count; ++j)
{
//(ws.Cells[1+20, j + 1+2] as Range).Value2 = grid.Columns[j].HeaderText;
for (int i = 0; i < grid.Rows.Count; ++i)
{
object Val = grid.Rows[i].Cells[j].Value;
if (Val != null)
(ws.Cells[i + 2+20, j + 1+2] as Range).Value2 = Val.ToString();
}
}
// ws.Columns.EntireColumn.AutoFit();
Excel.ReferenceStyle = RefStyle;
ReleaseExcel(Excel as Object);
}
public static void SaveTemporalGridData(ref object[] CurrentItems, DataGridView dgv)
{
int nFilledRows = dgv.Rows.Count - 1;
for (int i = 0; i < nFilledRows; i++)
{
for (int j = 0; j < CurrentItems.Length; j++)
{
if (CurrentItems[j] != null)
{
if (((MuDef.MUFile_Item)(CurrentItems[i])).Index == ushort.Parse(dgv.Rows[i].Cells[0].Value.ToString()))
{
/*
(MuDef.MUFile_Item)(CurrentItems[i]) = new MuDef.MUFile_Item()
{
};
* */
}
}
}
}
}
public ParamForm(BankLab parent, DataGridView dataTable)
{
InitializeComponent();
Parent = parent;
CurrentDataTable = dataTable;
ShowParametrForm(CurrentDataTable);
}
public DeleteOrEditTaskForm(TaskDataGridItem taskDataGridItem, DataGridView tdg)
{
InitializeComponent();
var nameList = from users in userData.QueryAll()
select users.USER_NAME;
foreach(string name in nameList)
{
AssignedToComboBox.Items.Add(name);
}
TaskIDLabel.Text = taskDataGridItem.TASK_ID.ToString();
AssignedByLabel.Text = taskDataGridItem.ASSIGNED_BY;
AssignedToComboBox.Text = taskDataGridItem.ASSIGNED_TO;
TaskTitleTextBox.Text = taskDataGridItem.TASK_TITLE;
DetailsTextBox.Text = taskDataGridItem.TASK_DETAILS;
IssueDatePicker.Value = taskDataGridItem.ISSUE_DATE;
DueDatePicker.Value = taskDataGridItem.DUE_DATE;
SendEmailCheckBox.Checked = taskDataGridItem.SEND_EMAIL;
taskItem = taskDataGridItem;
taskDataGridView = tdg;
}
public static void Initialize(DataGridView dataGridView)
{
if (dataGridView == null)
throw new ArgumentNullException("dataGridView");
m_DataGridView = dataGridView;
}
/// ------------------------------------------------------------------------------------
public void InitializeGrid(DataGridView grid)
{
foreach (var col in Columns)
{
if (!grid.Columns.Contains(col.Id))
continue;
grid.Columns[col.Id].Visible = col.Visible;
if (col.Width >= 0 &&
(grid.Columns[col.Id].AutoSizeMode == DataGridViewAutoSizeColumnMode.None ||
grid.Columns[col.Id].AutoSizeMode == DataGridViewAutoSizeColumnMode.NotSet))
{
grid.Columns[col.Id].Width = col.Width;
}
else if (col.FillWeight > 0 && grid.Columns[col.Id].AutoSizeMode == DataGridViewAutoSizeColumnMode.Fill)
{
grid.Columns[col.Id].FillWeight = col.FillWeight;
}
if (col.DisplayIndex < 0)
grid.Columns[col.Id].DisplayIndex = 0;
else if (col.DisplayIndex >= grid.ColumnCount)
grid.Columns[col.Id].DisplayIndex = grid.ColumnCount - 1;
else
grid.Columns[col.Id].DisplayIndex = col.DisplayIndex;
}
// If the column header height or the former dpi settings are different,
// then auto. calculate the height of the column headings.
if (ColumnHeaderHeight <= 0 || DPI != m_currDpi)
grid.AutoResizeColumnHeadersHeight();
else
grid.ColumnHeadersHeight = ColumnHeaderHeight;
}
public static void exportDataGridView(DataGridView dv, String fileName)
{
object missing = System.Reflection.Missing.Value;
Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();
app.Visible = false;
app.UserControl = false;
Workbooks workbooks = app.Workbooks;
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Sheets sheets = workbook.Worksheets;
_Worksheet worksheet = (_Worksheet)sheets.get_Item(1);
worksheet.Name = "Sheet1";
Boolean bl = dv.AllowUserToAddRows;
dv.AllowUserToAddRows = false;
for (int i = 0; i < dv.Columns.Count; i++)
{
worksheet.Cells[1, i + 1] = dv.Columns[i].HeaderText;
}
for (int i = 0; i < dv.Rows.Count; i++)
{
for (int j = 0; j < dv.Columns.Count; j++)
{
worksheet.Cells[i + 2, j + 1] = dv.Rows[i].Cells[j].Value;
}
}
dv.AllowUserToAddRows = bl;
app.DisplayAlerts = false;
app.AlertBeforeOverwriting = false;
workbook.Save();
workbook.SaveAs(fileName, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing);
app.Quit();
app = null;
}
public void hienthi(DataGridView data)
{
doc.Load(tentep);
data.Rows.Clear();
//Tạo nút gốc
XmlElement goc = doc.DocumentElement;
//Tạo đối tương ds chứa danh sách các nút
XmlNodeList ds = doc.SelectNodes("/congty/nhanvien");
int sd = 0;
data.ColumnCount = 5;
data.Rows.Add();//Hàm tự động add thêm dòng dữ liệu
//Dùng vòng foreach để duyệt và chèn dữ liệu
foreach (XmlNode node in ds) {
//Chọn các phần tử và gán biến cho chúng
XmlNode manv = node.SelectSingleNode("manv");
XmlNode hoten = node.SelectSingleNode("hoten");
XmlNode ngaysinh = node.SelectSingleNode("ngaysinh");
XmlNode gioitinh = node.SelectSingleNode("gioitinh");
XmlNode hsluong = node.SelectSingleNode("hsluong");
//ADD nó vào các cột và hàng tương ứng
data.Rows[sd].Cells[0].Value = manv.InnerText.ToString();
data.Rows[sd].Cells[1].Value = hoten.InnerText.ToString();
data.Rows[sd].Cells[2].Value = ngaysinh.InnerText.ToString();
data.Rows[sd].Cells[3].Value = gioitinh.InnerText.ToString();
data.Rows[sd].Cells[4].Value = hsluong.InnerText.ToString();
data.Rows.Add();
sd++;
}
}
private void PopulateDataGrid(DataGridView dgv)
{
FormHelper.PopulateDataGrid(dgv, gridTable);
dgv.Columns["Id"].Visible = false;
dgv.Columns["ProfileId"].Visible = false;
dgv.Columns["FullName"].Visible = false;
}
public DeleteOrEditUserForm(int userIDParam, DataGridView dataGridView)
{
InitializeComponent();
userID = userIDParam;
userDataGridView = dataGridView;
}
public void DegiskenSil(DataGridView dgv,String degiskenler)
{
if (degiskenler.LastIndexOf(',') == 0)
{
degiskenler = degiskenler.Substring(0, degiskenler.Length - 1);
}
string[] degisken_deger = degiskenler.Split(',');
for (int i = 0; i < degisken_deger.Length; i++)
{
try
{
if (degisken_deger[i].IndexOf('=') != -1)
{
String[] dv = degisken_deger[i].Split('=');
ht.Remove(dv[0]);
}
else
{
ht.Remove(degisken_deger[i]);
}
}
catch (Exception) { }
}
DegiskenYazdir(dgv);
}
public ResultTable(DataGridView dataView, string[] names) // constructor. Uses array of names for column/row header labels
{
m_dataView = dataView;
m_results = new Result[m_numberOfSequences, m_numberOfSequences];
for (int i = 0; i < m_numberOfSequences; ++i)
{
DataGridViewTextBoxColumn column = new DataGridViewTextBoxColumn();
column.HeaderText = "seq" + (i+1);
column.MaxInputLength = 8;
column.Width = 50;
DataGridViewCell cell = new DataGridViewTextBoxCell();
column.CellTemplate = cell;
m_dataView.Columns.Add(column);
}
for (int j = 0; j < m_numberOfSequences; ++j)
{
DataGridViewRow row = new DataGridViewRow(); // how can I remove the dumb current cell pointer that makes the header cells so big/obfuscates the header text?
row.HeaderCell.Value = "seq"+(j+1);
row.Height = 20;
for (int i = 0; i < m_numberOfSequences; ++i)
{
DataGridViewCell cell = new DataGridViewTextBoxCell();
row.Cells.Add(cell);
}
dataView.RowHeadersWidthSizeMode=DataGridViewRowHeadersWidthSizeMode.AutoSizeToAllHeaders;
m_dataView.Rows.Add(row);
}
dataView.CurrentCell = null;
}
public override void FormatearGrilla(DataGridView dgv)
{
base.FormatearGrilla(dgv);
this.dgvLactancia.Columns["FechaDesdeStr"].Visible = true;
this.dgvLactancia.Columns["FechaHastaStr"].Visible = true;
this.dgvLactancia.Columns["HoraInicio"].Visible = true;
this.dgvLactancia.Columns["LunesStr"].Visible = true;
this.dgvLactancia.Columns["MartesStr"].Visible = true;
this.dgvLactancia.Columns["MiercolesStr"].Visible = true;
this.dgvLactancia.Columns["JuevesStr"].Visible = true;
this.dgvLactancia.Columns["ViernesStr"].Visible = true;
this.dgvLactancia.Columns["SabadoStr"].Visible = true;
this.dgvLactancia.Columns["DomingoStr"].Visible = true;
this.dgvLactancia.Columns["FechaActualizacionStr"].Visible = true;
this.dgvLactancia.Columns["FechaDesdeStr"].HeaderText = "Fecha Desde";
this.dgvLactancia.Columns["FechaHastaStr"].HeaderText = "Fecha Hasta";
this.dgvLactancia.Columns["HoraInicio"].HeaderText = "Hora Inicio";
this.dgvLactancia.Columns["LunesStr"].HeaderText = "Lunes";
this.dgvLactancia.Columns["MartesStr"].HeaderText = "Martes";
this.dgvLactancia.Columns["MiercolesStr"].HeaderText = "Miercoles";
this.dgvLactancia.Columns["JuevesStr"].HeaderText = "Jueves";
this.dgvLactancia.Columns["ViernesStr"].HeaderText = "Viernes";
this.dgvLactancia.Columns["SabadoStr"].HeaderText = "Sabado";
this.dgvLactancia.Columns["DomingoStr"].HeaderText = "Domingo";
}
public void TestDataSet ()
{
// Binding to a DataSet doesn't work unless you specify DataMember
Form f = new Form ();
f.ShowInTaskbar = false;
DataSet ds = new DataSet ();
DataTable dt = ds.Tables.Add ("Muppets");
dt.Columns.Add ("ID");
dt.Columns.Add ("Name");
dt.Columns.Add ("Sex");
dt.Rows.Add (1, "Kermit", "Male");
dt.Rows.Add (2, "Miss Piggy", "Female");
dt.Rows.Add (3, "Gonzo", "Male");
DataGridView dgv = new DataGridView ();
dgv.DataSource = ds;
f.Controls.Add (dgv);
f.Show ();
Assert.AreEqual (0, dgv.Columns.Count, "A1");
Assert.AreEqual (0, dgv.Rows.Count, "A2");
dgv.DataMember = "Muppets";
Assert.AreEqual (3, dgv.Columns.Count, "A3");
Assert.AreEqual (4, dgv.Rows.Count, "A4");
f.Dispose ();
}
/// <summary>
/// 分类色带渲染
/// </summary>
/// <param name="classCount">分类数</param>
/// <param name="colorRamp">色带</param>
public void ClassifyColorRampRenderer(ILayer pLayerR, IColorRamp colorRamp, string classfield, System.Windows.Forms.DataGridView datagridview)
{
try
{
IRasterLayer pRasterLayer = pLayerR as IRasterLayer;
IRaster raster = pRasterLayer.Raster;
IRasterRenderer pRasterRenderer = new RasterClassifyColorRampRenderer() as IRasterRenderer;
pRasterRenderer.Raster = raster;
IRasterClassifyColorRampRenderer classifyRenderer = pRasterRenderer as IRasterClassifyColorRampRenderer;
int classcount = datagridview.RowCount;
classifyRenderer.ClassCount = classcount;
classifyRenderer.ClassField = classfield;
for (int i = 0; i < datagridview.RowCount; i++)
{
classifyRenderer.set_Break(i, double.Parse(datagridview.Rows[i].Cells[0].Value.ToString()));
}
pRasterRenderer.Update();
colorRamp.Size = 15;
bool pOk;
colorRamp.CreateRamp(out pOk);
//create symbol for the classes
IFillSymbol fillSymbol = new SimpleFillSymbol();
for (int i = 0; i < classifyRenderer.ClassCount - 1; i++)
{
fillSymbol.Color = colorRamp.get_Color(i);
classifyRenderer.set_Symbol(i, (ISymbol)fillSymbol);
classifyRenderer.set_Label(i, classifyRenderer.get_Break(i).ToString() + "—" + datagridview.Rows[i].Cells[1].Value.ToString());
}
pRasterLayer.Renderer = classifyRenderer as IRasterRenderer;
}
catch
{
}
}
public void DisableSelected(System.Windows.Forms.DataGridView dgv)
{
dgv.ClearSelection();
}
public static void FormatarEstoque(System.Windows.Forms.DataGridView dgv)
{
dgv.Columns["CodEstoque"].Visible = false;
dgv.Columns["Local"].Width = 200;
dgv.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;
}
public DataGridViewColumnCollection(DataGridView dataGridView)
{
InvalidateCachedColumnCounts();
InvalidateCachedColumnsWidths();
this.dataGridView = dataGridView;
}
public void LoadData()
{
this.tabControl.Controls.Clear();
listDataGridView.Clear();
DepartmentBLL departmentBLL = new DepartmentBLL();
List <DAL.Department> listDepartment = departmentBLL.ListDepartment();
for (int i = 0; i < listDepartment.Count; i++)
{
var t = new System.Windows.Forms.TabPage();
t.Name = listDepartment[i].Name;
t.Text = listDepartment[i].Name;
t.Location = new System.Drawing.Point(4, 22);
t.Padding = new System.Windows.Forms.Padding(3);
t.Size = new System.Drawing.Size(597, 257);
t.UseVisualStyleBackColor = true;
t.AutoScroll = true;
//add gridview
var dataGridView = new System.Windows.Forms.DataGridView();
var bindingSource = new System.Windows.Forms.BindingSource();
((System.ComponentModel.ISupportInitialize)(dataGridView)).BeginInit();
((System.ComponentModel.ISupportInitialize)(bindingSource)).BeginInit();
dataGridView.AutoGenerateColumns = false;
dataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dataGridView.DataSource = bindingSource;
dataGridView.Location = new System.Drawing.Point(0, 0);
dataGridView.Size = new System.Drawing.Size(567, 228);
var col1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
var col2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
var col3 = new System.Windows.Forms.DataGridViewTextBoxColumn();
col1.DataPropertyName = "ID";
col1.HeaderText = "ID";
col1.Width = 174;
col2.DataPropertyName = "Name";
col2.HeaderText = "Name";
col2.Width = 174;
col3.DataPropertyName = "Username";
col3.HeaderText = "Username";
col3.Width = 176;
dataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] { col1, col2, col3 });
//add list data gridview
listDataGridView.Add(dataGridView);
// add addbutton
Button button = new Button();
button.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
button.Location = new System.Drawing.Point(490, 7);
button.Size = new System.Drawing.Size(100, 20);
button.Tag = listDepartment[i];
button.Text = "Add emloyee";
button.Click += new EventHandler(this.btnAddEmloyee_Click);
t.Controls.Add(button);
// add button edit department
Button btEditDepartment = new Button();
btEditDepartment.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
btEditDepartment.Location = new System.Drawing.Point(490, 30);
btEditDepartment.Size = new System.Drawing.Size(100, 20);
btEditDepartment.Tag = listDepartment[i];
btEditDepartment.Text = "Edit Department";
btEditDepartment.Click += new EventHandler(this.btEditDepartment_Click);
t.Controls.Add(btEditDepartment);
// add button delete department
if (listDepartment[i].ID != 1 && listDepartment[i].ID != 2)
{
Button btDeleteDepartment = new Button();
btDeleteDepartment.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
btDeleteDepartment.Location = new System.Drawing.Point(480, 55);
btDeleteDepartment.Size = new System.Drawing.Size(120, 20);
btDeleteDepartment.Tag = listDepartment[i];
btDeleteDepartment.Text = "Delete Department";
btDeleteDepartment.Click += new EventHandler(this.btDeleteDepartment_Click);
t.Controls.Add(btDeleteDepartment);
}
//get emloyees for department
EmployeeBLL employeeBLL = new EmployeeBLL();
List <Employee> listEmployee = employeeBLL.ListEmployeeByDepartment(listDepartment[i]);
dataGridView.DataSource = listEmployee;
t.Controls.Add(dataGridView);
//var dmc = new DepartmentControl(listDepartment[i]);
//dmc.OnDelete += new DepartmentControl.OnDeleteHandler(this.departmentControl_OnDelete);
//int cols = (this.Width - minPadding) / (width + minPadding);
//int rows = (this.Height - minPadding) / (height + minPadding);
//dmc.Location = new System.Drawing.Point(minPadding + (width + minPadding) , minPadding + (height + minPadding) );
//dmc.Size = new System.Drawing.Size(width, height);
//t.Controls.Add(dmc);
this.tabControl.Controls.Add(t);
}
this.UpdateControlPosition();
}
/// <summary>
/// Export file excel from datagridview
/// </summary>
/// <param name="dgv"></param>
/// <param name="fileName"></param>
public void ExportFileFromDataGridView(System.Windows.Forms.DataGridView dgv, string fileName)
{
//set properties for SaveFileDilog
SaveFileDialog sfdSave = new SaveFileDialog();
sfdSave.Filter = "Excel file(*.xls)|*.xls";
sfdSave.Title = "Save to Excel file";
sfdSave.FileName = fileName;
//proccess save file excel
if (sfdSave.ShowDialog() == DialogResult.OK)
{
//create file infomation
FileInfo f = new FileInfo(sfdSave.FileName);
//delete if file exists
if (f.Exists == true)
{
f.Delete();
}
//Create excel file
ExcelCOM.Application exApp = new ExcelCOM.Application();
ExcelCOM.Workbook exBook = exApp.Workbooks.Add(ExcelCOM.XlWBATemplate.xlWBATWorksheet);
ExcelCOM.Worksheet exSheet = (ExcelCOM.Worksheet)exBook.Worksheets[1];
//ExcelCOM.Range chartRange;
exSheet.Name = fileName;
//get data from datagridview import into excel file
//exSheet.Cells.FormatConditions
//exSheet.get_Range("b2", "e3").Merge(false);
//chartRange = exSheet.get_Range("b2", "e9");
//chartRange.BorderAround(ExcelCOM.XlLineStyle.xlContinuous, ExcelCOM.XlBorderWeight.xlMedium, ExcelCOM.XlColorIndex.xlColorIndexAutomatic, ExcelCOM.XlColorIndex.xlColorIndexAutomatic);
//xlWorkBook.SaveAs("csharp.net-informations.xls", ExcelCOM.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, ExcelCOM.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue);
//import header
int col = 1;
for (int i = 1; i <= dgv.ColumnCount; i++)
{
exSheet.Cells[1, col] = dgv.Columns[i - 1].HeaderText;
col++;
//chartRange = exSheet.Cells[1, col];
//Font.Bold = true;
}
//import data
for (int i = 0; i < dgv.Rows.Count; i++)
{
col = 1;
for (int j = 1; j < dgv.ColumnCount; j++)
{
exSheet.Cells[i + 2, col + 1] = dgv.Rows[i].Cells[j].Value.ToString();
col++;
//chartRange.Cells.Formula
}
}
//(ExcelCOM.XlLineStyle.xlContinuous, ExcelCOM.XlBorderWeight.xlMedium, ExcelCOM.XlColorIndex.xlColorIndexAutomatic, ExcelCOM.XlColorIndex.xlColorIndexAutomatic);
//chartRange.BorderAround(ExcelCOM.XlLineStyle.xlContinuous, ExcelCOM.XlBorderWeight.xlMedium, ExcelCOM.XlColorIndex.xlColorIndexAutomatic, ExcelCOM.XlColorIndex.xlColorIndexAutomatic);
exApp.Visible = false;
//Save file excel into dictionary that you choose
exBook.SaveAs(sfdSave.FileName, ExcelCOM.XlFileFormat.xlWorkbookNormal,
null, null, false, false,
ExcelCOM.XlSaveAsAccessMode.xlExclusive,
false, false, false, false, false);
//close and release object
exBook.Close(false, false, false);
exApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(exBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(exApp);
CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CRM385"),
Common.clsLanguages.GetResource("CRM11"),
Common.Config.CUSTOM_MESSAGEBOX_ICON.Information,
Common.Config.CUSTOM_MESSAGEBOX_BUTTON.OK);
}
}
public void tb_EmpInfoFind(string strObject, int intFalg, Object DataObject)
{
int intCount = 0;
string strSecar = null;
try
{
switch (intFalg) //判断条件
{
case 1: //"员工姓名":
strSecar = "select * from tb_EmpInfo where EmpName like '%" + strObject + "%' and EmpFalg=0";
break;
case 2: //员工性别
strSecar = "select * from tb_EmpInfo where EmpSex = '" + strObject + "' and EmpFalg=0";
break;
case 3: //所属部门"
strSecar = "select * from tb_EmpInfo where EmpDept like '%" + strObject + "%' and EmpFalg=0";
break;
case 4: //"员工职位":
strSecar = "select * from tb_EmpInfo where EmpPost like '%" + strObject + "%' and EmpFalg=0";
break;
case 5:
strSecar = "select * from tb_EmpInfo where EmpFalg=0";
break;
}
_getSqlConnection getConnection = new _getSqlConnection();
conn = getConnection.GetCon();
cmd = new SqlCommand(strSecar, conn);
int ii = 0;
qlddr = cmd.ExecuteReader();
while (qlddr.Read())
{
ii++;
}
qlddr.Close();
System.Windows.Forms.DataGridView dv = (DataGridView)DataObject;
if (ii != 0)
{
int i = 0;
dv.RowCount = ii;
qlddr = cmd.ExecuteReader();
while (qlddr.Read())
{
dv[0, i].Value = qlddr[0].ToString();
dv[1, i].Value = qlddr[1].ToString();
dv[2, i].Value = qlddr[4].ToString();
dv[3, i].Value = qlddr[6].ToString();
dv[4, i].Value = qlddr[7].ToString();
dv[5, i].Value = qlddr[9].ToString();
i++;
}
qlddr.Close();
}
else
{
for (int i = 0; i < dv.RowCount; i++)
{
dv[0, i].Value = "";
dv[1, i].Value = "";
dv[2, i].Value = "";
dv[3, i].Value = "";
dv[4, i].Value = "";
dv[5, i].Value = "";
}
}
}
catch (Exception ee)
{
}
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(CATTester));
this.btnExit = new System.Windows.Forms.Button();
this.txtInput = new System.Windows.Forms.TextBoxTS();
this.txtResult = new System.Windows.Forms.TextBoxTS();
this.label1 = new System.Windows.Forms.LabelTS();
this.label2 = new System.Windows.Forms.LabelTS();
this.dataGrid1 = new System.Windows.Forms.DataGridView();
this.btnExecute = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).BeginInit();
this.SuspendLayout();
//
// btnExit
//
this.btnExit.Location = new System.Drawing.Point(440, 336);
this.btnExit.Name = "btnExit";
this.btnExit.Size = new System.Drawing.Size(75, 23);
this.btnExit.TabIndex = 2;
this.btnExit.Text = "Exit";
this.btnExit.Click += new System.EventHandler(this.btnExit_Click);
//
// txtInput
//
this.txtInput.Location = new System.Drawing.Point(120, 240);
this.txtInput.Name = "txtInput";
this.txtInput.Size = new System.Drawing.Size(168, 20);
this.txtInput.TabIndex = 0;
this.txtInput.KeyUp += new System.Windows.Forms.KeyEventHandler(this.txtInput_KeyUp);
//
// txtResult
//
this.txtResult.Location = new System.Drawing.Point(120, 280);
this.txtResult.Name = "txtResult";
this.txtResult.Size = new System.Drawing.Size(392, 20);
this.txtResult.TabIndex = 3;
//
// label1
//
this.label1.Image = null;
this.label1.Location = new System.Drawing.Point(16, 240);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(88, 23);
this.label1.TabIndex = 4;
this.label1.Text = "CAT Command";
this.label1.TextAlign = System.Drawing.ContentAlignment.BottomRight;
//
// label2
//
this.label2.Image = null;
this.label2.Location = new System.Drawing.Point(16, 280);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(88, 23);
this.label2.TabIndex = 5;
this.label2.Text = "CAT Response";
this.label2.TextAlign = System.Drawing.ContentAlignment.BottomRight;
//
// dataGrid1
//
this.dataGrid1.Location = new System.Drawing.Point(8, 0);
this.dataGrid1.Name = "dataGrid1";
this.dataGrid1.Size = new System.Drawing.Size(512, 224);
this.dataGrid1.TabIndex = 6;
//
// btnExecute
//
this.btnExecute.Location = new System.Drawing.Point(312, 240);
this.btnExecute.Name = "btnExecute";
this.btnExecute.Size = new System.Drawing.Size(75, 23);
this.btnExecute.TabIndex = 7;
this.btnExecute.Text = "Execute";
this.btnExecute.Click += new System.EventHandler(this.btnExecute_Click);
//
// CATTester
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.ClientSize = new System.Drawing.Size(536, 382);
this.Controls.Add(this.btnExecute);
this.Controls.Add(this.dataGrid1);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.txtResult);
this.Controls.Add(this.txtInput);
this.Controls.Add(this.btnExit);
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.Name = "CATTester";
this.Text = "CAT Command Tester";
((System.ComponentModel.ISupportInitialize)(this.dataGrid1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(QuestionSetEditor));
this.groupBox2 = new System.Windows.Forms.GroupBox();
this.questionSetsDataGrid = new System.Windows.Forms.DataGridView();
this.idDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.typeIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.subtypeIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.difficultyLevelIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.dataGridViewTextBoxColumn1 = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.pictureDataGridViewImageColumn = new System.Windows.Forms.DataGridViewImageColumn();
this.difficultyLevel = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.TypeId = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.SubtypeId = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.Idpas = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.setIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.questionOrderDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.questionZoneDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.questionIdDataGridViewTextBoxColumn = new System.Windows.Forms.DataGridViewTextBoxColumn();
this.buttonUp = new System.Windows.Forms.Button();
this.imageList = new System.Windows.Forms.ImageList(this.components);
this.addExistingButton = new System.Windows.Forms.Button();
this.addNewButton = new System.Windows.Forms.Button();
this.removeButton = new System.Windows.Forms.Button();
this.buttonDown = new System.Windows.Forms.Button();
this.groupBox1 = new System.Windows.Forms.GroupBox();
this.inZone3 = new System.Windows.Forms.Label();
this.inZone2 = new System.Windows.Forms.Label();
this.inZone1 = new System.Windows.Forms.Label();
this.label8 = new System.Windows.Forms.Label();
this.label6 = new System.Windows.Forms.Label();
this.label4 = new System.Windows.Forms.Label();
this.typeLable = new System.Windows.Forms.Label();
this.timeLable = new System.Windows.Forms.Label();
this.numberOfQuestionsLable = new System.Windows.Forms.Label();
this.label1 = new System.Windows.Forms.Label();
this.label5 = new System.Windows.Forms.Label();
this.label7 = new System.Windows.Forms.Label();
this.groupBox3 = new System.Windows.Forms.GroupBox();
this.descriptionTextBox = new System.Windows.Forms.TextBox();
this.nameTextBox = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
((System.ComponentModel.ISupportInitialize)(this.data)).BeginInit();
this.groupBox2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.questionSetsDataGrid)).BeginInit();
this.groupBox1.SuspendLayout();
this.groupBox3.SuspendLayout();
this.SuspendLayout();
//
// groupBox2
//
this.groupBox2.Controls.Add(this.questionSetsDataGrid);
this.groupBox2.Controls.Add(this.buttonUp);
this.groupBox2.Controls.Add(this.addExistingButton);
this.groupBox2.Controls.Add(this.addNewButton);
this.groupBox2.Controls.Add(this.removeButton);
this.groupBox2.Controls.Add(this.buttonDown);
this.groupBox2.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox2.Location = new System.Drawing.Point(3, 248);
this.groupBox2.Name = "groupBox2";
this.groupBox2.Size = new System.Drawing.Size(774, 381);
this.groupBox2.TabIndex = 9;
this.groupBox2.TabStop = false;
this.groupBox2.Text = "Questions";
//
// questionSetsDataGrid
//
this.questionSetsDataGrid.AllowUserToAddRows = false;
this.questionSetsDataGrid.AllowUserToDeleteRows = false;
this.questionSetsDataGrid.AllowUserToOrderColumns = true;
this.questionSetsDataGrid.AutoGenerateColumns = false;
this.questionSetsDataGrid.ColumnHeadersBorderStyle = System.Windows.Forms.DataGridViewHeaderBorderStyle.None;
this.questionSetsDataGrid.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.questionSetsDataGrid.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.idDataGridViewTextBoxColumn,
this.typeIdDataGridViewTextBoxColumn,
this.subtypeIdDataGridViewTextBoxColumn,
this.difficultyLevelIdDataGridViewTextBoxColumn,
this.dataGridViewTextBoxColumn1,
this.pictureDataGridViewImageColumn,
this.difficultyLevel,
this.TypeId,
this.SubtypeId,
this.Idpas,
this.setIdDataGridViewTextBoxColumn,
this.questionOrderDataGridViewTextBoxColumn,
this.questionZoneDataGridViewTextBoxColumn,
this.questionIdDataGridViewTextBoxColumn
});
this.questionSetsDataGrid.DataMember = "QuestionsEx";
this.questionSetsDataGrid.DataSource = this.data;
this.questionSetsDataGrid.Location = new System.Drawing.Point(5, 46);
this.questionSetsDataGrid.MultiSelect = false;
this.questionSetsDataGrid.Name = "questionSetsDataGrid";
this.questionSetsDataGrid.ReadOnly = true;
this.questionSetsDataGrid.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.questionSetsDataGrid.Size = new System.Drawing.Size(759, 329);
this.questionSetsDataGrid.TabIndex = 11;
this.questionSetsDataGrid.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.questionSetsDataGrid_CellDoubleClick);
this.questionSetsDataGrid.DataError += new System.Windows.Forms.DataGridViewDataErrorEventHandler(this.questionSetsDataGrid_DataError);
//
// idDataGridViewTextBoxColumn
//
this.idDataGridViewTextBoxColumn.DataPropertyName = "Id";
this.idDataGridViewTextBoxColumn.HeaderText = "Id";
this.idDataGridViewTextBoxColumn.Name = "idDataGridViewTextBoxColumn";
this.idDataGridViewTextBoxColumn.ReadOnly = true;
this.idDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
this.idDataGridViewTextBoxColumn.Visible = false;
//
// typeIdDataGridViewTextBoxColumn
//
this.typeIdDataGridViewTextBoxColumn.DataPropertyName = "TypeId";
this.typeIdDataGridViewTextBoxColumn.HeaderText = "TypeId";
this.typeIdDataGridViewTextBoxColumn.Name = "typeIdDataGridViewTextBoxColumn";
this.typeIdDataGridViewTextBoxColumn.ReadOnly = true;
this.typeIdDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
this.typeIdDataGridViewTextBoxColumn.Visible = false;
//
// subtypeIdDataGridViewTextBoxColumn
//
this.subtypeIdDataGridViewTextBoxColumn.DataPropertyName = "SubtypeId";
this.subtypeIdDataGridViewTextBoxColumn.HeaderText = "SubtypeId";
this.subtypeIdDataGridViewTextBoxColumn.Name = "subtypeIdDataGridViewTextBoxColumn";
this.subtypeIdDataGridViewTextBoxColumn.ReadOnly = true;
this.subtypeIdDataGridViewTextBoxColumn.Visible = false;
//
// difficultyLevelIdDataGridViewTextBoxColumn
//
this.difficultyLevelIdDataGridViewTextBoxColumn.DataPropertyName = "DifficultyLevelId";
this.difficultyLevelIdDataGridViewTextBoxColumn.HeaderText = "DifficultyLevelId";
this.difficultyLevelIdDataGridViewTextBoxColumn.Name = "difficultyLevelIdDataGridViewTextBoxColumn";
this.difficultyLevelIdDataGridViewTextBoxColumn.ReadOnly = true;
this.difficultyLevelIdDataGridViewTextBoxColumn.Visible = false;
//
// dataGridViewTextBoxColumn1
//
this.dataGridViewTextBoxColumn1.DataPropertyName = "Text";
this.dataGridViewTextBoxColumn1.HeaderText = "Text";
this.dataGridViewTextBoxColumn1.Name = "dataGridViewTextBoxColumn1";
this.dataGridViewTextBoxColumn1.ReadOnly = true;
this.dataGridViewTextBoxColumn1.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
//
// pictureDataGridViewImageColumn
//
this.pictureDataGridViewImageColumn.DataPropertyName = "Picture";
this.pictureDataGridViewImageColumn.HeaderText = "Picture";
this.pictureDataGridViewImageColumn.ImageLayout = System.Windows.Forms.DataGridViewImageCellLayout.Zoom;
this.pictureDataGridViewImageColumn.Name = "pictureDataGridViewImageColumn";
this.pictureDataGridViewImageColumn.ReadOnly = true;
//
// difficultyLevel
//
this.difficultyLevel.DataPropertyName = "DifficultyLevelId";
this.difficultyLevel.DataSource = this.data;
this.difficultyLevel.DisplayMember = "DifficultyLevel.Name";
this.difficultyLevel.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing;
this.difficultyLevel.HeaderText = "Difficulty level";
this.difficultyLevel.Name = "difficultyLevel";
this.difficultyLevel.ReadOnly = true;
this.difficultyLevel.ValueMember = "DifficultyLevel.Id";
//
// TypeId
//
this.TypeId.DataPropertyName = "TypeId";
this.TypeId.DataSource = this.data;
this.TypeId.DisplayMember = "QuestionTypes.Name";
this.TypeId.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing;
this.TypeId.HeaderText = "Type";
this.TypeId.Name = "TypeId";
this.TypeId.ReadOnly = true;
this.TypeId.ValueMember = "QuestionTypes.Id";
//
// SubtypeId
//
this.SubtypeId.DataPropertyName = "SubtypeId";
this.SubtypeId.DataSource = this.data;
this.SubtypeId.DisplayMember = "QuestionSubtypes.Name";
this.SubtypeId.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing;
this.SubtypeId.HeaderText = "Subtype";
this.SubtypeId.Name = "SubtypeId";
this.SubtypeId.ReadOnly = true;
this.SubtypeId.ValueMember = "QuestionSubtypes.Id";
this.SubtypeId.Width = 250;
//
// Idpas
//
this.Idpas.AutoComplete = false;
this.Idpas.DataPropertyName = "QuestionId";
this.Idpas.DataSource = this.data;
this.Idpas.DisplayMember = "PassagesToQuestionsEx.Text";
this.Idpas.DisplayStyle = System.Windows.Forms.DataGridViewComboBoxDisplayStyle.Nothing;
this.Idpas.HeaderText = "Passage";
this.Idpas.Name = "Idpas";
this.Idpas.ReadOnly = true;
this.Idpas.ValueMember = "PassagesToQuestionsEx.Id";
this.Idpas.Visible = false;
this.Idpas.Width = 200;
//
// setIdDataGridViewTextBoxColumn
//
this.setIdDataGridViewTextBoxColumn.DataPropertyName = "SetId";
this.setIdDataGridViewTextBoxColumn.HeaderText = "SetId";
this.setIdDataGridViewTextBoxColumn.Name = "setIdDataGridViewTextBoxColumn";
this.setIdDataGridViewTextBoxColumn.ReadOnly = true;
this.setIdDataGridViewTextBoxColumn.Visible = false;
//
// questionOrderDataGridViewTextBoxColumn
//
this.questionOrderDataGridViewTextBoxColumn.DataPropertyName = "QuestionOrder";
this.questionOrderDataGridViewTextBoxColumn.HeaderText = "QuestionOrder";
this.questionOrderDataGridViewTextBoxColumn.Name = "questionOrderDataGridViewTextBoxColumn";
this.questionOrderDataGridViewTextBoxColumn.ReadOnly = true;
this.questionOrderDataGridViewTextBoxColumn.Visible = false;
//
// questionZoneDataGridViewTextBoxColumn
//
this.questionZoneDataGridViewTextBoxColumn.DataPropertyName = "QuestionZone";
this.questionZoneDataGridViewTextBoxColumn.HeaderText = "QuestionZone";
this.questionZoneDataGridViewTextBoxColumn.Name = "questionZoneDataGridViewTextBoxColumn";
this.questionZoneDataGridViewTextBoxColumn.ReadOnly = true;
this.questionZoneDataGridViewTextBoxColumn.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
this.questionZoneDataGridViewTextBoxColumn.Visible = false;
//
// questionIdDataGridViewTextBoxColumn
//
this.questionIdDataGridViewTextBoxColumn.DataPropertyName = "QuestionId";
this.questionIdDataGridViewTextBoxColumn.HeaderText = "QuestionId";
this.questionIdDataGridViewTextBoxColumn.Name = "questionIdDataGridViewTextBoxColumn";
this.questionIdDataGridViewTextBoxColumn.ReadOnly = true;
this.questionIdDataGridViewTextBoxColumn.Visible = false;
//
// buttonUp
//
this.buttonUp.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.buttonUp.ImageIndex = 0;
this.buttonUp.ImageList = this.imageList;
this.buttonUp.Location = new System.Drawing.Point(8, 16);
this.buttonUp.Name = "buttonUp";
this.buttonUp.Size = new System.Drawing.Size(17, 24);
this.buttonUp.TabIndex = 10;
this.buttonUp.Click += new System.EventHandler(this.buttonUp_Click);
//
// imageList
//
this.imageList.ImageStream = ((System.Windows.Forms.ImageListStreamer)(resources.GetObject("imageList.ImageStream")));
this.imageList.TransparentColor = System.Drawing.Color.Fuchsia;
this.imageList.Images.SetKeyName(0, "");
this.imageList.Images.SetKeyName(1, "");
//
// addExistingButton
//
this.addExistingButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.addExistingButton.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.addExistingButton.ImageIndex = 1;
this.addExistingButton.Location = new System.Drawing.Point(488, 16);
this.addExistingButton.Name = "addExistingButton";
this.addExistingButton.Size = new System.Drawing.Size(88, 24);
this.addExistingButton.TabIndex = 7;
this.addExistingButton.Text = "Add &Existing...";
this.addExistingButton.Click += new System.EventHandler(this.addExistingButton_Click);
//
// addNewButton
//
this.addNewButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.addNewButton.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.addNewButton.ImageIndex = 0;
this.addNewButton.Location = new System.Drawing.Point(582, 16);
this.addNewButton.Name = "addNewButton";
this.addNewButton.Size = new System.Drawing.Size(88, 24);
this.addNewButton.TabIndex = 8;
this.addNewButton.Text = "Add &New...";
this.addNewButton.Click += new System.EventHandler(this.addNewButton_Click);
//
// removeButton
//
this.removeButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.removeButton.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.removeButton.ImageIndex = 2;
this.removeButton.Location = new System.Drawing.Point(676, 16);
this.removeButton.Name = "removeButton";
this.removeButton.Size = new System.Drawing.Size(88, 24);
this.removeButton.TabIndex = 9;
this.removeButton.Text = "&Remove";
this.removeButton.Click += new System.EventHandler(this.removeButton_Click);
//
// buttonDown
//
this.buttonDown.FlatStyle = System.Windows.Forms.FlatStyle.Popup;
this.buttonDown.ImageIndex = 1;
this.buttonDown.ImageList = this.imageList;
this.buttonDown.Location = new System.Drawing.Point(27, 16);
this.buttonDown.Name = "buttonDown";
this.buttonDown.Size = new System.Drawing.Size(17, 24);
this.buttonDown.TabIndex = 10;
this.buttonDown.Click += new System.EventHandler(this.buttonDown_Click);
//
// groupBox1
//
this.groupBox1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.groupBox1.Controls.Add(this.inZone3);
this.groupBox1.Controls.Add(this.inZone2);
this.groupBox1.Controls.Add(this.inZone1);
this.groupBox1.Controls.Add(this.label8);
this.groupBox1.Controls.Add(this.label6);
this.groupBox1.Controls.Add(this.label4);
this.groupBox1.Controls.Add(this.typeLable);
this.groupBox1.Controls.Add(this.timeLable);
this.groupBox1.Controls.Add(this.numberOfQuestionsLable);
this.groupBox1.Controls.Add(this.label1);
this.groupBox1.Controls.Add(this.label5);
this.groupBox1.Controls.Add(this.label7);
this.groupBox1.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox1.Location = new System.Drawing.Point(542, 5);
this.groupBox1.Name = "groupBox1";
this.groupBox1.Size = new System.Drawing.Size(237, 126);
this.groupBox1.TabIndex = 11;
this.groupBox1.TabStop = false;
this.groupBox1.Text = "Information";
//
// inZone3
//
this.inZone3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.inZone3.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.inZone3.Location = new System.Drawing.Point(147, 93);
this.inZone3.Name = "inZone3";
this.inZone3.Size = new System.Drawing.Size(80, 16);
this.inZone3.TabIndex = 22;
this.inZone3.Text = "999";
this.inZone3.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// inZone2
//
this.inZone2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.inZone2.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.inZone2.Location = new System.Drawing.Point(147, 78);
this.inZone2.Name = "inZone2";
this.inZone2.Size = new System.Drawing.Size(80, 16);
this.inZone2.TabIndex = 21;
this.inZone2.Text = "999";
this.inZone2.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// inZone1
//
this.inZone1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.inZone1.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.inZone1.Location = new System.Drawing.Point(147, 63);
this.inZone1.Name = "inZone1";
this.inZone1.Size = new System.Drawing.Size(80, 16);
this.inZone1.TabIndex = 20;
this.inZone1.Text = "999";
this.inZone1.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// label8
//
this.label8.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label8.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label8.Location = new System.Drawing.Point(11, 78);
this.label8.Name = "label8";
this.label8.Size = new System.Drawing.Size(104, 16);
this.label8.TabIndex = 19;
this.label8.Text = "Questions in zone 2";
//
// label6
//
this.label6.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label6.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label6.Location = new System.Drawing.Point(11, 94);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(104, 15);
this.label6.TabIndex = 18;
this.label6.Text = "Questions in zone 3";
//
// label4
//
this.label4.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label4.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label4.Location = new System.Drawing.Point(11, 62);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(104, 16);
this.label4.TabIndex = 17;
this.label4.Text = "Questions in zone 1";
//
// typeLable
//
this.typeLable.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.typeLable.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.typeLable.Location = new System.Drawing.Point(107, 16);
this.typeLable.Name = "typeLable";
this.typeLable.Size = new System.Drawing.Size(120, 16);
this.typeLable.TabIndex = 12;
this.typeLable.Text = "Reading Comprehension";
this.typeLable.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// timeLable
//
this.timeLable.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.timeLable.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.timeLable.Location = new System.Drawing.Point(147, 32);
this.timeLable.Name = "timeLable";
this.timeLable.Size = new System.Drawing.Size(80, 16);
this.timeLable.TabIndex = 16;
this.timeLable.Text = "Unlimited";
this.timeLable.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// numberOfQuestionsLable
//
this.numberOfQuestionsLable.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.numberOfQuestionsLable.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.numberOfQuestionsLable.Location = new System.Drawing.Point(147, 47);
this.numberOfQuestionsLable.Name = "numberOfQuestionsLable";
this.numberOfQuestionsLable.Size = new System.Drawing.Size(80, 16);
this.numberOfQuestionsLable.TabIndex = 15;
this.numberOfQuestionsLable.Text = "999";
this.numberOfQuestionsLable.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// label1
//
this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label1.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label1.Location = new System.Drawing.Point(11, 15);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(32, 16);
this.label1.TabIndex = 8;
this.label1.Text = "Type:";
this.label1.Click += new System.EventHandler(this.label1_Click);
//
// label5
//
this.label5.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label5.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label5.Location = new System.Drawing.Point(11, 30);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(80, 16);
this.label5.TabIndex = 9;
this.label5.Text = "Time Limit:";
//
// label7
//
this.label7.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label7.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label7.Location = new System.Drawing.Point(11, 46);
this.label7.Name = "label7";
this.label7.Size = new System.Drawing.Size(104, 16);
this.label7.TabIndex = 10;
this.label7.Text = "# of Questions:";
//
// groupBox3
//
this.groupBox3.Controls.Add(this.descriptionTextBox);
this.groupBox3.Controls.Add(this.nameTextBox);
this.groupBox3.Controls.Add(this.label2);
this.groupBox3.Controls.Add(this.label3);
this.groupBox3.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.groupBox3.Location = new System.Drawing.Point(3, 3);
this.groupBox3.Name = "groupBox3";
this.groupBox3.Size = new System.Drawing.Size(531, 239);
this.groupBox3.TabIndex = 12;
this.groupBox3.TabStop = false;
//
// descriptionTextBox
//
this.descriptionTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.data, "Tests.Description", true));
this.descriptionTextBox.Location = new System.Drawing.Point(5, 56);
this.descriptionTextBox.Multiline = true;
this.descriptionTextBox.Name = "descriptionTextBox";
this.descriptionTextBox.Size = new System.Drawing.Size(520, 177);
this.descriptionTextBox.TabIndex = 5;
//
// nameTextBox
//
this.nameTextBox.DataBindings.Add(new System.Windows.Forms.Binding("Text", this.data, "Tests.Name", true));
this.nameTextBox.Location = new System.Drawing.Point(42, 14);
this.nameTextBox.Name = "nameTextBox";
this.nameTextBox.Size = new System.Drawing.Size(483, 20);
this.nameTextBox.TabIndex = 2;
//
// label2
//
this.label2.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label2.Location = new System.Drawing.Point(6, 17);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(48, 17);
this.label2.TabIndex = 4;
this.label2.Text = "Name";
//
// label3
//
this.label3.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.label3.Location = new System.Drawing.Point(6, 37);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(64, 16);
this.label3.TabIndex = 3;
this.label3.Text = "Description";
//
// QuestionSetEditor
//
this.Controls.Add(this.groupBox3);
this.Controls.Add(this.groupBox1);
this.Controls.Add(this.groupBox2);
this.Name = "QuestionSetEditor";
this.Size = new System.Drawing.Size(782, 632);
this.Enter += new System.EventHandler(this.QuestionSetEditor_Enter);
this.Load += new System.EventHandler(this.QuestionSetEditor_Load);
((System.ComponentModel.ISupportInitialize)(this.data)).EndInit();
this.groupBox2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.questionSetsDataGrid)).EndInit();
this.groupBox1.ResumeLayout(false);
this.groupBox3.ResumeLayout(false);
this.groupBox3.PerformLayout();
this.ResumeLayout(false);
}
public void crearPantalla()
{
form = new Form();
form.SuspendLayout();
form.Size = new Size(851, 508);
form.Name = "Form1";
form.Text = "Form1";
form.Visible = true;
this.lbTituloEncuesta = new System.Windows.Forms.Label();
this.listaEncuestas = new System.Windows.Forms.DataGridView();
this.btnTrabajarEncuesta = new System.Windows.Forms.Button();
this.RBeditar = new System.Windows.Forms.RadioButton();
this.RBeliminar = new System.Windows.Forms.RadioButton();
this.btnAgregarEncuesta = new System.Windows.Forms.Button();
this.btnCerrarSession = new System.Windows.Forms.Button();
//
// lbTituloEncuesta
//
this.lbTituloEncuesta.Font = new System.Drawing.Font("Microsoft Sans Serif", 18F, System.Drawing.FontStyle.Bold);
this.lbTituloEncuesta.Location = new System.Drawing.Point(236, 18);
this.lbTituloEncuesta.Name = "lbTituloEncuesta";
this.lbTituloEncuesta.Size = new System.Drawing.Size(390, 36);
this.lbTituloEncuesta.TabIndex = 0;
this.lbTituloEncuesta.Text = "Selecciona una Encuestas";
//
// listaEncuestas
//
this.listaEncuestas.Location = new System.Drawing.Point(58, 151);
this.listaEncuestas.Name = "listaEncuestas";
this.listaEncuestas.RowHeadersWidth = 51;
this.listaEncuestas.RowTemplate.Height = 24;
this.listaEncuestas.Size = new System.Drawing.Size(464, 309);
this.listaEncuestas.TabIndex = 2;
listaEncuestas.CellClick += new DataGridViewCellEventHandler(DataGridView1_CellDoubleClick);
//
// btnTrabajarEncuesta
//
this.btnTrabajarEncuesta.Font = new System.Drawing.Font("Microsoft Sans Serif", 13.8F, System.Drawing.FontStyle.Bold);
this.btnTrabajarEncuesta.Location = new System.Drawing.Point(548, 292);
this.btnTrabajarEncuesta.Name = "btnTrabajarEncuesta";
this.btnTrabajarEncuesta.Size = new System.Drawing.Size(240, 78);
this.btnTrabajarEncuesta.TabIndex = 3;
this.btnTrabajarEncuesta.Text = "Trabajar en Encuesta";
this.btnTrabajarEncuesta.UseVisualStyleBackColor = true;
btnTrabajarEncuesta.Click += new EventHandler(TrabajarConEncuesta);
//
// RBeditar
//
this.RBeditar.Font = new System.Drawing.Font("Microsoft Sans Serif", 13.8F, System.Drawing.FontStyle.Bold);
this.RBeditar.Location = new System.Drawing.Point(566, 151);
this.RBeditar.Name = "RBeditar";
this.RBeditar.Size = new System.Drawing.Size(103, 33);
this.RBeditar.TabIndex = 4;
this.RBeditar.TabStop = true;
this.RBeditar.Text = "Editar";
this.RBeditar.UseVisualStyleBackColor = true;
//
// RBeliminar
//
this.RBeliminar.Font = new System.Drawing.Font("Microsoft Sans Serif", 13.8F, System.Drawing.FontStyle.Bold);
this.RBeliminar.Location = new System.Drawing.Point(566, 216);
this.RBeliminar.Name = "RBeliminar";
this.RBeliminar.Size = new System.Drawing.Size(130, 33);
this.RBeliminar.TabIndex = 5;
this.RBeliminar.TabStop = true;
this.RBeliminar.Text = "Eliminar";
this.RBeliminar.UseVisualStyleBackColor = true;
//
// btnAgregarEncuesta
//
this.btnAgregarEncuesta.Font = new System.Drawing.Font("Microsoft Sans Serif", 13.8F, System.Drawing.FontStyle.Bold);
this.btnAgregarEncuesta.Location = new System.Drawing.Point(160, 79);
this.btnAgregarEncuesta.Name = "btnAgregarEncuesta";
this.btnAgregarEncuesta.Size = new System.Drawing.Size(242, 51);
this.btnAgregarEncuesta.TabIndex = 6;
this.btnAgregarEncuesta.Text = "Agregar Encuesta";
this.btnAgregarEncuesta.UseVisualStyleBackColor = true;
btnAgregarEncuesta.Click += new EventHandler(CrearEncuesta);
//
// btnCerrarSession
//
this.btnCerrarSession.Font = new System.Drawing.Font("Microsoft Sans Serif", 13.8F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.btnCerrarSession.Location = new System.Drawing.Point(548, 389);
this.btnCerrarSession.Name = "btnCerrarSession";
this.btnCerrarSession.Size = new System.Drawing.Size(242, 71);
this.btnCerrarSession.TabIndex = 7;
this.btnCerrarSession.Text = "Cerrar Session";
this.btnCerrarSession.UseVisualStyleBackColor = true;
btnCerrarSession.Click += new EventHandler(CerrarSession);
//
// Form2
//
form.Controls.Add(btnAgregarEncuesta);
form.Controls.Add(RBeliminar);
form.Controls.Add(RBeditar);
form.Controls.Add(btnTrabajarEncuesta);
form.Controls.Add(listaEncuestas);
form.Controls.Add(lbTituloEncuesta);
form.Controls.Add(btnCerrarSession);
CargarEncuesta();
}
/// <summary>
/// Рекурсивно перевести элементы управления Windows-формы
/// </summary>
private static void TranslateWinControls(IList controls, WinForms.ToolTip toolTip,
Dictionary <string, ControlInfo> controlInfoDict)
{
if (controls == null)
{
return;
}
foreach (object elem in controls)
{
ControlInfo controlInfo;
if (elem is WinForms.Control)
{
// обработка обычного элемента управления
WinForms.Control control = (WinForms.Control)elem;
if (!string.IsNullOrEmpty(control.Name) /*например, поле ввода и кнопки NumericUpDown*/ &&
controlInfoDict.TryGetValue(control.Name, out controlInfo))
{
if (controlInfo.Text != null)
{
control.Text = controlInfo.Text;
}
if (controlInfo.ToolTip != null && toolTip != null)
{
toolTip.SetToolTip(control, controlInfo.ToolTip);
}
if (controlInfo.Items != null && elem is WinForms.ComboBox)
{
WinForms.ComboBox comboBox = (WinForms.ComboBox)elem;
int cnt = Math.Min(comboBox.Items.Count, controlInfo.Items.Count);
for (int i = 0; i < cnt; i++)
{
string itemText = controlInfo.Items[i];
if (itemText != null)
{
comboBox.Items[i] = itemText;
}
}
}
}
if (elem is WinForms.MenuStrip)
{
// запуск обработки элементов меню
WinForms.MenuStrip menuStrip = (WinForms.MenuStrip)elem;
TranslateWinControls(menuStrip.Items, toolTip, controlInfoDict);
}
else if (elem is WinForms.ToolStrip)
{
// запуск обработки элементов панели инструментов
WinForms.ToolStrip toolStrip = (WinForms.ToolStrip)elem;
TranslateWinControls(toolStrip.Items, toolTip, controlInfoDict);
}
else if (elem is WinForms.DataGridView)
{
// запуск обработки столбцов таблицы
WinForms.DataGridView dataGridView = (WinForms.DataGridView)elem;
TranslateWinControls(dataGridView.Columns, toolTip, controlInfoDict);
}
else if (elem is WinForms.ListView)
{
// запуск обработки столбцов списка
WinForms.ListView listView = (WinForms.ListView)elem;
TranslateWinControls(listView.Columns, toolTip, controlInfoDict);
}
// запуск обработки дочерних элементов
if (control.HasChildren)
{
TranslateWinControls(control.Controls, toolTip, controlInfoDict);
}
}
else if (elem is WinForms.ToolStripItem)
{
// обработка элемента меню или элемента панели инструментов
WinForms.ToolStripItem item = (WinForms.ToolStripItem)elem;
if (controlInfoDict.TryGetValue(item.Name, out controlInfo))
{
if (controlInfo.Text != null)
{
item.Text = controlInfo.Text;
}
if (controlInfo.ToolTip != null)
{
item.ToolTipText = controlInfo.ToolTip;
}
}
if (elem is WinForms.ToolStripMenuItem)
{
// запуск обработки элементов подменю
WinForms.ToolStripMenuItem menuItem = (WinForms.ToolStripMenuItem)elem;
if (menuItem.HasDropDownItems)
{
TranslateWinControls(menuItem.DropDownItems, toolTip, controlInfoDict);
}
}
}
else if (elem is WinForms.DataGridViewColumn)
{
// обработка столбца таблицы
WinForms.DataGridViewColumn column = (WinForms.DataGridViewColumn)elem;
if (controlInfoDict.TryGetValue(column.Name, out controlInfo) && controlInfo.Text != null)
{
column.HeaderText = controlInfo.Text;
}
}
else if (elem is WinForms.ColumnHeader)
{
// обработка столбца списка
WinForms.ColumnHeader columnHeader = (WinForms.ColumnHeader)elem;
if (controlInfoDict.TryGetValue(columnHeader.Name, out controlInfo) && controlInfo.Text != null)
{
columnHeader.Text = controlInfo.Text;
}
}
}
}
internal DataGridViewSelectedRowCollection(DataGridView dataGridView)
{
this.dataGridView = dataGridView;
}
internal void AddScope(DataGridView dataGridView, DataGridViewCellStyleScopes scope)
{
this.scope |= scope;
this.dataGridView = dataGridView;
}
public void Read(System.Windows.Forms.DataGridView dgvdb, System.Windows.Forms.DataGridView dgvsrc, System.Windows.Forms.DataGridView dgvdst)
{
XmlDocument XmlDb = DataGridToXml(dgvdb, "DbSet");
XmlDocument XmlSrc = DataGridToXml(dgvsrc, "Src");
XmlDocument XmlDst = DataGridToXml(dgvdst, "Dst");
xedbroot = XmlDb.DocumentElement;
xesrc = (XmlElement)XmlSrc.DocumentElement.FirstChild;
if (XmlDst != null)
{
xedst = (XmlElement)XmlDst.DocumentElement.FirstChild;
}
;
}
private void InitializeComponent()
{
components = new System.ComponentModel.Container();
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
_cellTemplateAlignRight = new DataGridViewCellStyle();
_cellTemplateAlignRight.Alignment = DataGridViewContentAlignment.MiddleRight;
_cellTemplateAlignCenter = new DataGridViewCellStyle();
_cellTemplateAlignCenter.Alignment = DataGridViewContentAlignment.MiddleCenter;
this._dataGridViewRefund = new DataGridView();
this.ColumnRfdAvatar = new DataGridViewImageColumn();
this.ColumnRfdAmount = new DataGridViewTextBoxColumn();
this.ColumnRfdUserGiver = new DataGridViewTextBoxColumn();
this.ColumnRfdUserReceiver = new DataGridViewTextBoxColumn();
this.ColumnRfdCurrency = new DataGridViewTextBoxColumn();
this.ColumnRfdCurrencyPict = new DataGridViewImageColumn();
this.ColumnRfdExchangeDone = new DataGridViewImageColumn();
this.ColumnRfdGift = new DataGridViewImageColumn();
this.ColumnRfdCanceled = new DataGridViewImageColumn();
this.ColumnRfdStatus = new DataGridViewTextBoxColumn();
this.ColumnRfdId = new DataGridViewTextBoxColumn();
//
// dataGridViewRefund
//
this._dataGridViewRefund.AllowUserToAddRows = false;
this._dataGridViewRefund.AllowUserToDeleteRows = false;
this._dataGridViewRefund.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this._dataGridViewRefund.ColumnHeadersVisible = true;
this._dataGridViewRefund.ScrollBars = ScrollBars.Both;
this._dataGridViewRefund.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.ColumnRfdId,
this.ColumnRfdAmount,
this.ColumnRfdCurrency,
this.ColumnRfdCurrencyPict,
this.ColumnRfdUserGiver,
this.ColumnRfdAvatar,
this.ColumnRfdUserReceiver,
this.ColumnRfdExchangeDone,
this.ColumnRfdGift,
this.ColumnRfdCanceled,
this.ColumnRfdStatus
});
this._dataGridViewRefund.Dock = System.Windows.Forms.DockStyle.Top;
this._dataGridViewRefund.Location = new System.Drawing.Point(0, 0);
this._dataGridViewRefund.MultiSelect = false;
this._dataGridViewRefund.Name = "dataGridViewRefund";
this._dataGridViewRefund.RowHeadersVisible = false;
this._dataGridViewRefund.AutoSize = false;
this._dataGridViewRefund.TabIndex = 0;
this._dataGridViewRefund.BackgroundColor = Color.FromArgb(255, 85, 85, 85);
this._dataGridViewRefund.ForeColor = Color.Silver;
this._dataGridViewRefund.DefaultCellStyle.BackColor = Color.FromArgb(255, 85, 85, 85);
this._dataGridViewRefund.CellBorderStyle = DataGridViewCellBorderStyle.SingleHorizontal;
this._dataGridViewRefund.DefaultCellStyle.SelectionBackColor = this._dataGridViewRefund.DefaultCellStyle.BackColor;
this._dataGridViewRefund.CellClick += _dataGridViewRefund_CellClick;
((System.ComponentModel.ISupportInitialize)(this._dataGridViewRefund)).BeginInit();
//
// ColumnRfdAvatar
//
this.ColumnRfdAvatar.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdAvatar.HeaderText = string.Empty;
this.ColumnRfdAvatar.Image = ((System.Drawing.Image)(ResourceIconSet16Default.user_gray));
this.ColumnRfdAvatar.Name = "ColumnRfdAvatar";
this.ColumnRfdAvatar.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.ColumnRfdAvatar.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.ColumnRfdAvatar.Width = 5;
//
// ColumnRfdId
//
this.ColumnRfdId.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdId.HeaderText = string.Empty;
this.ColumnRfdId.Name = "ColumnRfdId";
this.ColumnRfdId.Width = 5;
this.ColumnRfdId.Visible = false;
//
// ColumnRfdUserGiver
//
this.ColumnRfdUserGiver.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.ColumnRfdUserGiver.HeaderText = "Giver";
this.ColumnRfdUserGiver.Name = "ColumnRfdUserGiver";
this.ColumnRfdUserGiver.Width = 5;
//
// ColumnRfdUserReceiver
//
this.ColumnRfdUserReceiver.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.Fill;
this.ColumnRfdUserReceiver.HeaderText = "Receiver";
this.ColumnRfdUserReceiver.Name = "ColumnRfdUserReceiver";
this.ColumnRfdUserReceiver.Width = 5;
//
// ColumnRfdAmount
//
this.ColumnRfdAmount.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdAmount.HeaderText = "Amount";
this.ColumnRfdAmount.Name = "ColumnRfdAmount";
this.ColumnRfdAmount.Width = 5;
this.ColumnRfdAmount.DefaultCellStyle = _cellTemplateAlignRight;
//
// ColumnRfdCurrency
//
this.ColumnRfdCurrency.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdCurrency.HeaderText = string.Empty;
this.ColumnRfdCurrency.Name = "ColumnRfdCurrency";
this.ColumnRfdCurrency.Width = 5;
this.ColumnRfdCurrency.ToolTipText = "Used currency";
//
// ColumnRfdCurrencyPict
//
this.ColumnRfdCurrencyPict.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdCurrencyPict.HeaderText = string.Empty;
this.ColumnRfdCurrencyPict.Name = "ColumnRfdCurrencyPict";
this.ColumnRfdCurrencyPict.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.ColumnRfdCurrencyPict.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.ColumnRfdCurrencyPict.Width = 5;
//
// ColumnRfdStatus
//
this.ColumnRfdStatus.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdStatus.HeaderText = "Status";
this.ColumnRfdStatus.Name = "ColumnRfdStatus";
this.ColumnRfdStatus.Width = 5;
//
// ColumnRfdExchangeDone
//
this.ColumnRfdExchangeDone.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdExchangeDone.HeaderText = string.Empty;
this.ColumnRfdExchangeDone.Name = "ColumnRfdExchangeDone";
this.ColumnRfdExchangeDone.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.ColumnRfdExchangeDone.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.ColumnRfdExchangeDone.Width = 5;
//
// ColumnRfdGift
//
this.ColumnRfdGift.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdGift.HeaderText = string.Empty;
this.ColumnRfdGift.Name = "ColumnRfdGift";
this.ColumnRfdGift.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.ColumnRfdGift.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.ColumnRfdGift.Width = 5;
//
// ColumnRfdCanceled
//
this.ColumnRfdCanceled.AutoSizeMode = System.Windows.Forms.DataGridViewAutoSizeColumnMode.AllCellsExceptHeader;
this.ColumnRfdCanceled.HeaderText = string.Empty;
this.ColumnRfdCanceled.Name = "ColumnRfdCanceled";
this.ColumnRfdCanceled.Resizable = System.Windows.Forms.DataGridViewTriState.True;
this.ColumnRfdCanceled.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.Automatic;
this.ColumnRfdCanceled.Width = 5;
this.Controls.Add(_dataGridViewRefund);
((System.ComponentModel.ISupportInitialize)(this._dataGridViewRefund)).EndInit();
}
internal override void Initialize(List <GPXLoader.Cache> allgc, System.Windows.Forms.DataGridView grid)
{
grid.ColumnCount = 3;
grid.SelectionMode = DataGridViewSelectionMode.FullRowSelect;
var byOwner = allgc.GroupBy(c => c.Owner).OrderByDescending(g => g.Count());
//initialization for columns
var iCol = 0;
var col = grid.Columns[iCol++];
col.Name = "Owner";
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleLeft;
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleLeft;
col = grid.Columns[iCol++];
col.Name = "Count";
col.DataPropertyName = "count";
col = grid.Columns[iCol++];
col.Name = "Percent";
col.DataPropertyName = "percent";
col.SortMode = DataGridViewColumnSortMode.NotSortable;
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.MiddleCenter;
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
int totCache = allgc.Count;
int count = 0;
const int MAX = 500;
foreach (var o in byOwner)
{
var cacheList = o.ToList();
OwnerData od = new OwnerData()
{
Owner = o.First().Owner,
Count = o.Count()
};
od.Percent = string.Format("{0:#.##}%", 100.0 * (float)od.Count / (float)totCache);
var row = new DataGridViewRow();
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = od.Owner,
Tag = cacheList
});
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = od.Count,
Tag = cacheList
});
row.Cells.Add(new DataGridViewTextBoxCell()
{
Value = od.Percent,
Tag = cacheList
});
++count;
row.HeaderCell.Value = (count).ToString();
grid.Rows.Add(row);
if (count == MAX)
{
break;
}
}
}
/// <summary>
/// считываем из экселя в грид
/// </summary>
/// <param name="dataGridView1">куда считываем</param>
public void ReadFromExcell(System.Windows.Forms.DataGridView dataGridView1)
{
Microsoft.Office.Interop.Excel.Application ObjExcel;
Microsoft.Office.Interop.Excel.Workbook ObjWorkBook;
Microsoft.Office.Interop.Excel.Worksheet ObjWorkSheet;
//Диалоговое окно выбора файла с фильтром
OpenFileDialog openDialog = new OpenFileDialog();
openDialog.Filter = "Файл Excel|*.XLSX;*.XLS";
openDialog.ShowDialog();
try
{
//Приложение самого Excel
ObjExcel = new Microsoft.Office.Interop.Excel.Application();
//Книга.
ObjWorkBook = ObjExcel.Workbooks.Open(openDialog.FileName);
//Таблица.
ObjWorkSheet = ObjExcel.ActiveSheet as Microsoft.Office.Interop.Excel.Worksheet;
//Ячейка
//Microsoft.Office.Interop.Excel.Range rg = null;
bool flag = true; //флаг на добавление строчек row в стринггрид только один раз много штучек)
//Int32 row = 1;
dataGridView1.Rows.Clear();
List <double> arr = new List <double>();
var lastCell = ObjWorkSheet.Cells.SpecialCells(XlCellType.xlCellTypeLastCell); //1 ячейку
string[,] list = new string[lastCell.Column, lastCell.Row]; // все данные.
// массив значений с листа равен по размеру листу
countObj = lastCell.Column;
countAttrib = lastCell.Row;
for (int i = 0; i < lastCell.Column; i++) // цикл по всем колонкам
{
dataGridView1.Columns.Add(i.ToString(), ObjWorkSheet.Cells[1, i + 1].Text.ToString());
dataGridView1.Columns[i].Name = ObjWorkSheet.Cells[1, i + 1].Text.ToString(); //&&&&&&&??????
if (flag) //создаю строки.
{
dataGridView1.Rows.Add(lastCell.Row - 1);
flag = false;
}
for (int j = 0; j < lastCell.Row; j++) // по всем строкам /// 1
{
list[i, j] = ObjWorkSheet.Cells[j + 2, i + 1].Text.ToString(); //считываем текст в строку
dataGridView1.Rows[j].Cells[i].Value = list[i, j]; /// -1
}
}
for (int j = 0; j < countAttrib - 1; j++)
{
ArrayList attribs = new ArrayList();
for (int i = 0; i < countObj; i++)
{
attribs.Add(double.Parse(list[i, j]));
}
allObjects.Add(new MyObject(attribs)); // здесь наши объекты.
}
ObjWorkBook.Close(false, Type.Missing, Type.Missing); //закрыть не сохраняя
//Закрытие книгу Excel.
//Закрытие приложения Excel.
ObjExcel.Quit();
//Обнуляем созданые объекты
ObjWorkBook = null;
ObjWorkSheet = null;
ObjExcel = null;
//Вызываем сборщик мусора для их уничтожения и освобождения памяти
GC.Collect();
MessageBox.Show("Файл успешно считан!", "Считывания excel файла");
}
catch (Exception ex) { MessageBox.Show("Ошибка: " + ex.Message, "Ошибка при считывании excel файла"); }
}
private void InitializeComponent()
{
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle3 = new System.Windows.Forms.DataGridViewCellStyle();
System.Windows.Forms.DataGridViewCellStyle dataGridViewCellStyle4 = new System.Windows.Forms.DataGridViewCellStyle();
this._label = new System.Windows.Forms.Label();
this._addButton = new System.Windows.Forms.Button();
this._deleteButton = new System.Windows.Forms.Button();
this._dataGridView = new System.Windows.Forms.DataGridView();
this.Column1 = new System.Windows.Forms.DataGridViewComboBoxColumn();
this.Column2 = new System.Windows.Forms.DataGridViewTextBoxColumn();
((System.ComponentModel.ISupportInitialize)(this._dataGridView)).BeginInit();
this.SuspendLayout();
//
// _label
//
this._label.AutoSize = true;
this._label.Location = new System.Drawing.Point(0, 9);
this._label.Margin = new System.Windows.Forms.Padding(4, 0, 4, 0);
this._label.Name = "_label";
this._label.Size = new System.Drawing.Size(110, 13);
this._label.TabIndex = 0;
this._label.Text = "[Enter label text here]:";
//
// _addButton
//
this._addButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this._addButton.Cursor = System.Windows.Forms.Cursors.Hand;
this._addButton.FlatAppearance.BorderSize = 0;
this._addButton.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this._addButton.Font = new System.Drawing.Font("Microsoft Sans Serif", 12.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this._addButton.Location = new System.Drawing.Point(186, 7);
this._addButton.Margin = new System.Windows.Forms.Padding(4);
this._addButton.Name = "_addButton";
this._addButton.Size = new System.Drawing.Size(32, 28);
this._addButton.TabIndex = 1;
this._addButton.Text = "+";
this._addButton.UseVisualStyleBackColor = true;
this._addButton.Click += new System.EventHandler(this.AddButtonClick);
//
// _deleteButton
//
this._deleteButton.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this._deleteButton.Cursor = System.Windows.Forms.Cursors.Hand;
this._deleteButton.FlatAppearance.BorderSize = 0;
this._deleteButton.FlatStyle = System.Windows.Forms.FlatStyle.Flat;
this._deleteButton.Font = new System.Drawing.Font("Microsoft Sans Serif", 15.75F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this._deleteButton.Location = new System.Drawing.Point(218, 1);
this._deleteButton.Margin = new System.Windows.Forms.Padding(4);
this._deleteButton.Name = "_deleteButton";
this._deleteButton.Size = new System.Drawing.Size(30, 35);
this._deleteButton.TabIndex = 2;
this._deleteButton.Text = "-";
this._deleteButton.UseVisualStyleBackColor = true;
this._deleteButton.Click += new System.EventHandler(this.DeleteButtonClick);
//
// _dataGridView
//
this._dataGridView.AllowUserToAddRows = false;
this._dataGridView.AllowUserToDeleteRows = false;
this._dataGridView.AllowUserToResizeRows = false;
this._dataGridView.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this._dataGridView.AutoSizeColumnsMode = System.Windows.Forms.DataGridViewAutoSizeColumnsMode.Fill;
this._dataGridView.BackgroundColor = System.Drawing.SystemColors.ControlLight;
this._dataGridView.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this._dataGridView.ClipboardCopyMode = System.Windows.Forms.DataGridViewClipboardCopyMode.Disable;
dataGridViewCellStyle3.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle3.BackColor = System.Drawing.SystemColors.Control;
dataGridViewCellStyle3.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle3.ForeColor = System.Drawing.SystemColors.WindowText;
dataGridViewCellStyle3.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle3.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle3.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
this._dataGridView.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle3;
this._dataGridView.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this._dataGridView.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
this.Column1,
this.Column2
});
dataGridViewCellStyle4.Alignment = System.Windows.Forms.DataGridViewContentAlignment.MiddleLeft;
dataGridViewCellStyle4.BackColor = System.Drawing.SystemColors.Window;
dataGridViewCellStyle4.Font = new System.Drawing.Font("Microsoft Sans Serif", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
dataGridViewCellStyle4.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle4.SelectionBackColor = System.Drawing.SystemColors.Highlight;
dataGridViewCellStyle4.SelectionForeColor = System.Drawing.SystemColors.HighlightText;
dataGridViewCellStyle4.WrapMode = System.Windows.Forms.DataGridViewTriState.False;
this._dataGridView.DefaultCellStyle = dataGridViewCellStyle4;
this._dataGridView.EditMode = System.Windows.Forms.DataGridViewEditMode.EditOnEnter;
this._dataGridView.Location = new System.Drawing.Point(4, 40);
this._dataGridView.Margin = new System.Windows.Forms.Padding(4);
this._dataGridView.Name = "_dataGridView";
this._dataGridView.RowHeadersVisible = false;
this._dataGridView.RowTemplate.DefaultCellStyle.ForeColor = System.Drawing.Color.Black;
this._dataGridView.RowTemplate.Height = 20;
this._dataGridView.RowTemplate.Resizable = System.Windows.Forms.DataGridViewTriState.False;
this._dataGridView.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this._dataGridView.Size = new System.Drawing.Size(244, 137);
this._dataGridView.TabIndex = 3;
this._dataGridView.MouseLeave += new System.EventHandler(this._dataGridView_Leave);
//
// Column1
//
this.Column1.HeaderText = "Column1";
this.Column1.Items.AddRange(new object[] {
"Value1",
"Value2"
});
this.Column1.Name = "Column1";
//
// Column2
//
this.Column2.HeaderText = "Column2";
this.Column2.Name = "Column2";
//
// OptionsGrid
//
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Inherit;
this.BackColor = System.Drawing.Color.Transparent;
this.Controls.Add(this._dataGridView);
this.Controls.Add(this._deleteButton);
this.Controls.Add(this._addButton);
this.Controls.Add(this._label);
this.Margin = new System.Windows.Forms.Padding(4);
this.Name = "OptionsGrid";
this.Size = new System.Drawing.Size(251, 188);
((System.ComponentModel.ISupportInitialize)(this._dataGridView)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
protected internal virtual void PaintCells(Graphics graphics, Rectangle clipBounds, Rectangle rowBounds, int rowIndex, DataGridViewElementStates rowState, bool isFirstDisplayedRow, bool isLastVisibleRow, DataGridViewPaintParts paintParts)
{
List <DataGridViewColumn> sortedColumns = DataGridView.Columns.ColumnDisplayIndexSortedArrayList;
Rectangle bounds = rowBounds;
// If row headers are visible, adjust our starting point
if (DataGridView.RowHeadersVisible)
{
bounds.X += DataGridView.RowHeadersWidth;
bounds.Width -= DataGridView.RowHeadersWidth;
}
for (int i = DataGridView.first_col_index; i < sortedColumns.Count; i++)
{
DataGridViewColumn col = sortedColumns[i];
if (!col.Visible)
{
continue;
}
if (!col.Displayed)
{
break;
}
bounds.Width = col.Width;
DataGridViewCell cell = Cells[col.Index];
if ((paintParts & DataGridViewPaintParts.Background) == DataGridViewPaintParts.Background)
{
graphics.FillRectangle(Brushes.White, bounds);
}
DataGridViewCellStyle style;
if (cell.RowIndex == -1)
{
style = DefaultCellStyle;
}
else
{
style = cell.InheritedStyle;
}
object value;
object formattedValue;
string errorText;
DataGridViewElementStates cellState;
if (cell.RowIndex == -1)
{
// TODO: Look up value if databound.
value = null;
formattedValue = null;
errorText = null;
cellState = cell.State;
}
else
{
value = cell.Value;
formattedValue = cell.FormattedValue;
errorText = cell.ErrorText;
cellState = cell.InheritedState;
}
DataGridViewAdvancedBorderStyle intermediateBorderStyle = (DataGridViewAdvancedBorderStyle)((ICloneable)DataGridView.AdvancedCellBorderStyle).Clone();
DataGridViewAdvancedBorderStyle borderStyle = cell.AdjustCellBorderStyle(DataGridView.AdvancedCellBorderStyle, intermediateBorderStyle, true, true, cell.ColumnIndex == 0, cell.RowIndex == 0);
DataGridView.OnCellFormattingInternal(new DataGridViewCellFormattingEventArgs(cell.ColumnIndex, cell.RowIndex, value, cell.FormattedValueType, style));
cell.PaintWork(graphics, clipBounds, bounds, rowIndex, cellState, style, borderStyle, paintParts);
bounds.X += bounds.Width;
}
}
/// <summary>
/// Required method for Designer support; do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Form1));
this.label1 = new System.Windows.Forms.Label();
this.label2 = new System.Windows.Forms.Label();
this.label3 = new System.Windows.Forms.Label();
this.button1 = new System.Windows.Forms.Button();
this.button2 = new System.Windows.Forms.Button();
this.label4 = new System.Windows.Forms.Label();
this.tabBarSplitterControl1 = new Syncfusion.Windows.Forms.TabBarSplitterControl();
this.tabBarPage1 = new Syncfusion.Windows.Forms.TabBarPage();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.tabBarPage2 = new Syncfusion.Windows.Forms.TabBarPage();
this.dataGridView2 = new System.Windows.Forms.DataGridView();
this.pictureBox3 = new System.Windows.Forms.PictureBox();
this.panel2 = new System.Windows.Forms.Panel();
this.tabBarSplitterControl1.SuspendLayout();
this.tabBarPage1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.tabBarPage2.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).BeginInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox3)).BeginInit();
this.SuspendLayout();
//
// label1
//
this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.label1.BackColor = System.Drawing.Color.White;
this.label1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.label1.Location = new System.Drawing.Point(150, 596);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(238, 26);
this.label1.TabIndex = 3;
this.label1.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
//
// label2
//
this.label2.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label2.Location = new System.Drawing.Point(12, 106);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(368, 22);
this.label2.TabIndex = 6;
this.label2.Text = "Click on any formula cell to get the calculated result.";
//
// label3
//
this.label3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));
this.label3.AutoSize = true;
this.label3.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label3.Location = new System.Drawing.Point(30, 604);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(116, 13);
this.label3.TabIndex = 9;
this.label3.Text = "Computed Value:";
//
// button1
//
this.button1.FlatStyle = System.Windows.Forms.FlatStyle.System;
this.button1.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button1.Location = new System.Drawing.Point(15, 131);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(152, 23);
this.button1.TabIndex = 10;
this.button1.Text = "Import Data From Excel";
this.button1.UseVisualStyleBackColor = true;
this.button1.Click += new System.EventHandler(this.button1_Click);
//
// button2
//
this.button2.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.button2.Location = new System.Drawing.Point(187, 131);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(201, 23);
this.button2.TabIndex = 11;
this.button2.Text = "Open sample workbook in Excel";
this.button2.UseVisualStyleBackColor = true;
this.button2.Click += new System.EventHandler(this.button2_Click);
//
// label4
//
this.label4.AutoSize = true;
this.label4.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Bold, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.label4.Location = new System.Drawing.Point(15, 166);
this.label4.Name = "label4";
this.label4.Size = new System.Drawing.Size(243, 13);
this.label4.TabIndex = 12;
this.label4.Text = "View of Imported Excel Worksheets:";
//
// tabBarSplitterControl1
//
this.tabBarSplitterControl1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.tabBarSplitterControl1.BorderStyle = System.Windows.Forms.BorderStyle.FixedSingle;
this.tabBarSplitterControl1.Controls.Add(this.tabBarPage1);
this.tabBarSplitterControl1.Controls.Add(this.tabBarPage2);
this.tabBarSplitterControl1.EnabledColor = System.Drawing.SystemColors.WindowText;
this.tabBarSplitterControl1.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.tabBarSplitterControl1.Location = new System.Drawing.Point(18, 200);
this.tabBarSplitterControl1.Name = "tabBarSplitterControl1";
this.tabBarSplitterControl1.Office2007ScrollBars = true;
this.tabBarSplitterControl1.RelativeWidth = 24;
this.tabBarSplitterControl1.Size = new System.Drawing.Size(567, 386);
this.tabBarSplitterControl1.SplitBars = Syncfusion.Windows.Forms.DynamicSplitBars.None;
this.tabBarSplitterControl1.Style = Syncfusion.Windows.Forms.TabBarSplitterStyle.Office2007;
this.tabBarSplitterControl1.TabFolderDelta = 11;
this.tabBarSplitterControl1.TabIndex = 13;
this.tabBarSplitterControl1.Text = "tabBarSplitterControl1";
this.tabBarSplitterControl1.ThemesEnabled = true;
//
// tabBarPage1
//
this.tabBarPage1.Controls.Add(this.dataGridView1);
this.tabBarPage1.Location = new System.Drawing.Point(0, 0);
this.tabBarPage1.Name = "tabBarPage1";
this.tabBarPage1.SplitBars = Syncfusion.Windows.Forms.DynamicSplitBars.None;
this.tabBarPage1.TabBackColor = System.Drawing.SystemColors.Control;
this.tabBarPage1.Text = "Sheet1";
this.tabBarPage1.ThemesEnabled = true;
//
// dataGrid1
//
this.dataGridView1.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.dataGridView1.DataMember = "";
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.dataGridView1.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
this.dataGridView1.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
this.dataGridView1.GridColor = System.Drawing.Color.FromArgb(((int)(((byte)(215)))), ((int)(((byte)(218)))), ((int)(((byte)(229)))));
dataGridViewCellStyle1 = new DataGridViewCellStyle();
dataGridViewCellStyle1.BackColor = System.Drawing.Color.LightSteelBlue;
dataGridViewCellStyle1.ForeColor = System.Drawing.SystemColors.ControlText;
dataGridViewCellStyle1.Alignment = DataGridViewContentAlignment.TopLeft;
this.dataGridView1.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
this.dataGridView1.RowHeadersDefaultCellStyle = dataGridViewCellStyle1;
this.dataGridView1.Location = new System.Drawing.Point(0, 0);
this.dataGridView1.Name = "dataGrid1";
this.dataGridView1.RowTemplate.Height = 18;
this.dataGridView1.ReadOnly = true;
this.dataGridView1.Size = new System.Drawing.Size(17506, 8487);
this.dataGridView1.TabIndex = 8;
this.dataGridView1.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dataGrid1_MouseClick);
//
// tabBarPage2
//
this.tabBarPage2.Controls.Add(this.dataGridView2);
this.tabBarPage2.Location = new System.Drawing.Point(0, 0);
this.tabBarPage2.Name = "tabBarPage2";
this.tabBarPage2.SplitBars = ((Syncfusion.Windows.Forms.DynamicSplitBars)((Syncfusion.Windows.Forms.DynamicSplitBars.SplitRows | Syncfusion.Windows.Forms.DynamicSplitBars.SplitColumns)));
this.tabBarPage2.TabBackColor = System.Drawing.SystemColors.Control;
this.tabBarPage2.Text = "Sheet2";
this.tabBarPage2.ThemesEnabled = true;
//
// dataGrid2
//
this.dataGridView2.DataMember = "";
this.dataGridView2.AllowUserToAddRows = false;
this.dataGridView2.Font = new System.Drawing.Font("Verdana", 8.25F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.dataGridView2.ColumnHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
this.dataGridView2.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.None;
this.dataGridView2.GridColor = System.Drawing.Color.FromArgb(((int)(((byte)(215)))), ((int)(((byte)(218)))), ((int)(((byte)(229)))));
this.dataGridView2.ColumnHeadersDefaultCellStyle = dataGridViewCellStyle1;
this.dataGridView2.RowHeadersDefaultCellStyle = dataGridViewCellStyle1;
this.dataGridView2.Location = new System.Drawing.Point(0, 0);
this.dataGridView2.Name = "dataGrid2";
this.dataGridView2.RowTemplate.Height = 18;
this.dataGridView2.ReadOnly = true;
this.dataGridView2.Size = new System.Drawing.Size(575, 338);
this.dataGridView2.TabIndex = 4;
this.dataGridView2.MouseUp += new System.Windows.Forms.MouseEventHandler(this.dataGrid2_MouseClick);
//
// pictureBox3
//
this.pictureBox3.Anchor = ((System.Windows.Forms.AnchorStyles)((((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Bottom)
| System.Windows.Forms.AnchorStyles.Left)
| System.Windows.Forms.AnchorStyles.Right)));
this.pictureBox3.BackColor = System.Drawing.Color.Transparent;
this.pictureBox3.Image = ((System.Drawing.Image)(resources.GetObject("pictureBox3.Image")));
this.pictureBox3.Location = new System.Drawing.Point(0, 0);
this.pictureBox3.Name = "pictureBox3";
this.pictureBox3.Size = new System.Drawing.Size(639, 71);
this.pictureBox3.SizeMode = System.Windows.Forms.PictureBoxSizeMode.AutoSize;
this.pictureBox3.TabIndex = 17;
this.pictureBox3.TabStop = false;
//
// panel2
//
this.panel2.Location = new System.Drawing.Point(-3, 0);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(486, 71);
this.panel2.TabIndex = 22;
//
// Form1
//
this.AutoScaleBaseSize = new System.Drawing.Size(5, 13);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Inherit;
this.BackColor = System.Drawing.Color.White;
this.ClientSize = new System.Drawing.Size(603, 631);
this.Controls.Add(this.tabBarSplitterControl1);
this.Controls.Add(this.label4);
this.Controls.Add(this.button2);
this.Controls.Add(this.button1);
this.Controls.Add(this.label3);
this.Controls.Add(this.label2);
this.Controls.Add(this.label1);
this.Controls.Add(this.pictureBox3);
this.Controls.Add(this.panel2);
this.FormBorderStyle = System.Windows.Forms.FormBorderStyle.FixedSingle;
this.Icon = ((System.Drawing.Icon)(resources.GetObject("$this.Icon")));
this.MaximizeBox = false;
this.Name = "Form1";
this.Text = "Compute Specific Formula";
this.FormClosing += new System.Windows.Forms.FormClosingEventHandler(this.Form1_FormClosing);
this.tabBarSplitterControl1.ResumeLayout(false);
this.tabBarPage1.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.tabBarPage2.ResumeLayout(false);
((System.ComponentModel.ISupportInitialize)(this.dataGridView2)).EndInit();
((System.ComponentModel.ISupportInitialize)(this.pictureBox3)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
/// <summary>
/// Required method for Designer support - do not modify
/// the contents of this method with the code editor.
/// </summary>
private void InitializeComponent()
{
this.dgFilters = new System.Windows.Forms.DataGridView();
this.bDelete = new System.Windows.Forms.Button();
this.bUp = new System.Windows.Forms.Button();
this.bDown = new System.Windows.Forms.Button();
this.bValueExpr = new System.Windows.Forms.Button();
((System.ComponentModel.ISupportInitialize)(this.dgFilters)).BeginInit();
this.SuspendLayout();
//
// dgFilters
//
this.dgFilters.Location = new System.Drawing.Point(8, 8);
this.dgFilters.Name = "dgFilters";
this.dgFilters.Size = new System.Drawing.Size(376, 264);
this.dgFilters.TabIndex = 2;
//
// bDelete
//
this.bDelete.Location = new System.Drawing.Point(392, 40);
this.bDelete.Name = "bDelete";
this.bDelete.Size = new System.Drawing.Size(48, 23);
this.bDelete.TabIndex = 1;
this.bDelete.Text = "Delete";
this.bDelete.Click += new System.EventHandler(this.bDelete_Click);
//
// bUp
//
this.bUp.Location = new System.Drawing.Point(392, 71);
this.bUp.Name = "bUp";
this.bUp.Size = new System.Drawing.Size(48, 23);
this.bUp.TabIndex = 3;
this.bUp.Text = "Up";
this.bUp.Click += new System.EventHandler(this.bUp_Click);
//
// bDown
//
this.bDown.Location = new System.Drawing.Point(392, 102);
this.bDown.Name = "bDown";
this.bDown.Size = new System.Drawing.Size(48, 23);
this.bDown.TabIndex = 4;
this.bDown.Text = "Down";
this.bDown.Click += new System.EventHandler(this.bDown_Click);
//
// bValueExpr
//
this.bValueExpr.Font = new System.Drawing.Font("Arial", 8.25F, ((System.Drawing.FontStyle)((System.Drawing.FontStyle.Bold | System.Drawing.FontStyle.Italic))), System.Drawing.GraphicsUnit.Point, ((byte)(0)));
this.bValueExpr.Location = new System.Drawing.Point(392, 16);
this.bValueExpr.Name = "bValueExpr";
this.bValueExpr.Size = new System.Drawing.Size(22, 16);
this.bValueExpr.TabIndex = 5;
this.bValueExpr.Tag = "value";
this.bValueExpr.Text = "fx";
this.bValueExpr.TextAlign = System.Drawing.ContentAlignment.MiddleLeft;
this.bValueExpr.Click += new System.EventHandler(this.bValueExpr_Click);
//
// FiltersCtl
//
this.Controls.Add(this.bValueExpr);
this.Controls.Add(this.bDown);
this.Controls.Add(this.bUp);
this.Controls.Add(this.bDelete);
this.Controls.Add(this.dgFilters);
this.Name = "FiltersCtl";
this.Size = new System.Drawing.Size(488, 304);
((System.ComponentModel.ISupportInitialize)(this.dgFilters)).EndInit();
this.ResumeLayout(false);
}
public void ExportFileFromDataGridViewEmployee(System.Windows.Forms.DataGridView dgv, string fileName)
{
//set properties for SaveFileDilog
SaveFileDialog sfdSave = new SaveFileDialog();
sfdSave.Filter = "Excel file(*.xls)|*.xls";
sfdSave.Title = "Save to Excel file";
sfdSave.FileName = fileName;
//proccess save file excel
if (sfdSave.ShowDialog() == DialogResult.OK)
{
//create file infomation
FileInfo f = new FileInfo(sfdSave.FileName);
//delete if file exists
if (f.Exists == true)
{
f.Delete();
}
//Create excel file
ExcelCOM.Application exApp = new ExcelCOM.Application();
ExcelCOM.Workbook exBook = exApp.Workbooks.Add(ExcelCOM.XlWBATemplate.xlWBATWorksheet);
ExcelCOM.Worksheet exSheet = (ExcelCOM.Worksheet)exBook.Worksheets[1];
//ExcelCOM.Range chartRange;
exSheet.Name = fileName;
//list field will be exported
List <string> field = new List <string> {
"EmployeeCode", "EmployeeName", "UserName", "Gender", "BirthDate", "PhoneNumber", "Email", "Address", "EmployeeTypeName", "CountryName", "EmployeeTypeName2", "CountryName2", "EmployeeTypeName3", "CountryName3", "HourlyWages", "CreatedDate", "UpdatedDate", "Notes"
};
//import header
int col = 1;
for (int i = 0; i < field.Count; i++)
{
exSheet.Cells[1, col] = dgv.Columns[field[i]].HeaderText;
col++;
}
//import data
for (int i = 0; i < dgv.Rows.Count; i++)
{
col = 1;
for (int j = 0; j < field.Count; j++)
{
exSheet.Cells[i + 2, col] = dgv.Rows[i].Cells[field[j]].Value.ToString();
col++;
}
}
//(ExcelCOM.XlLineStyle.xlContinuous, ExcelCOM.XlBorderWeight.xlMedium, ExcelCOM.XlColorIndex.xlColorIndexAutomatic, ExcelCOM.XlColorIndex.xlColorIndexAutomatic);
//chartRange.BorderAround(ExcelCOM.XlLineStyle.xlContinuous, ExcelCOM.XlBorderWeight.xlMedium, ExcelCOM.XlColorIndex.xlColorIndexAutomatic, ExcelCOM.XlColorIndex.xlColorIndexAutomatic);
exApp.Visible = false;
//Save file excel into dictionary that you choose
exBook.SaveAs(sfdSave.FileName, ExcelCOM.XlFileFormat.xlWorkbookNormal,
null, null, false, false,
ExcelCOM.XlSaveAsAccessMode.xlExclusive,
false, false, false, false, false);
//close and release object
exBook.Close(false, false, false);
exApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(exBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(exApp);
CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CRM385"),
Common.clsLanguages.GetResource("CRM11"),
Common.Config.CUSTOM_MESSAGEBOX_ICON.Information,
Common.Config.CUSTOM_MESSAGEBOX_BUTTON.OK);
}
}
private void InitializeComponent()
{
this.components = new System.ComponentModel.Container();
System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(frmCarteles));
this.ToolTip1 = new System.Windows.Forms.ToolTip(this.components);
this.Cartel1 = new System.Windows.Forms.GroupBox();
this.txtCopias1 = new System.Windows.Forms.TextBox();
this.cmbRazonSocial1 = new System.Windows.Forms.ComboBox();
this._Lbl_30 = new System.Windows.Forms.Label();
this.lblCP1 = new System.Windows.Forms.Label();
this.lblProvincia1 = new System.Windows.Forms.Label();
this.lblLocalidad1 = new System.Windows.Forms.Label();
this.lblDireccion1 = new System.Windows.Forms.Label();
this._Lbl_13 = new System.Windows.Forms.Label();
this._Lbl_1 = new System.Windows.Forms.Label();
this._Lbl_2 = new System.Windows.Forms.Label();
this._Lbl_3 = new System.Windows.Forms.Label();
this._Lbl_0 = new System.Windows.Forms.Label();
this.Toolbar1 = new System.Windows.Forms.ToolStrip();
this.tlbNuevo = new System.Windows.Forms.ToolStripButton();
this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
this.tlbGuardar = new System.Windows.Forms.ToolStripButton();
this.toolStripSeparator2 = new System.Windows.Forms.ToolStripSeparator();
this.tbImprimir = new System.Windows.Forms.ToolStripButton();
this.toolStripSeparator3 = new System.Windows.Forms.ToolStripSeparator();
this.tlbAnual = new System.Windows.Forms.ToolStripButton();
this.toolStripSeparator4 = new System.Windows.Forms.ToolStripSeparator();
this.tlbEditar = new System.Windows.Forms.ToolStripButton();
this.toolStripSeparator5 = new System.Windows.Forms.ToolStripSeparator();
this.tlbCorreo = new System.Windows.Forms.ToolStripButton();
this.tlbCarteles = new System.Windows.Forms.ToolStripButton();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.Cartel1.SuspendLayout();
this.Toolbar1.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.SuspendLayout();
//
// Cartel1
//
this.Cartel1.BackColor = System.Drawing.SystemColors.Control;
this.Cartel1.Controls.Add(this.txtCopias1);
this.Cartel1.Controls.Add(this.cmbRazonSocial1);
this.Cartel1.Controls.Add(this._Lbl_30);
this.Cartel1.Controls.Add(this.lblCP1);
this.Cartel1.Controls.Add(this.lblProvincia1);
this.Cartel1.Controls.Add(this.lblLocalidad1);
this.Cartel1.Controls.Add(this.lblDireccion1);
this.Cartel1.Controls.Add(this._Lbl_13);
this.Cartel1.Controls.Add(this._Lbl_1);
this.Cartel1.Controls.Add(this._Lbl_2);
this.Cartel1.Controls.Add(this._Lbl_3);
this.Cartel1.Controls.Add(this._Lbl_0);
this.Cartel1.ForeColor = System.Drawing.SystemColors.ControlText;
this.Cartel1.Location = new System.Drawing.Point(0, 32);
this.Cartel1.Name = "Cartel1";
this.Cartel1.Padding = new System.Windows.Forms.Padding(0);
this.Cartel1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.Cartel1.Size = new System.Drawing.Size(353, 145);
this.Cartel1.TabIndex = 0;
this.Cartel1.TabStop = false;
this.Cartel1.Visible = false;
//
// txtCopias1
//
this.txtCopias1.AcceptsReturn = true;
this.txtCopias1.BackColor = System.Drawing.SystemColors.Window;
this.txtCopias1.Cursor = System.Windows.Forms.Cursors.IBeam;
this.txtCopias1.ForeColor = System.Drawing.SystemColors.WindowText;
this.txtCopias1.Location = new System.Drawing.Point(304, 48);
this.txtCopias1.MaxLength = 0;
this.txtCopias1.Name = "txtCopias1";
this.txtCopias1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.txtCopias1.Size = new System.Drawing.Size(25, 20);
this.txtCopias1.TabIndex = 4;
//
// cmbRazonSocial1
//
this.cmbRazonSocial1.BackColor = System.Drawing.SystemColors.Window;
this.cmbRazonSocial1.Cursor = System.Windows.Forms.Cursors.Default;
this.cmbRazonSocial1.ForeColor = System.Drawing.SystemColors.WindowText;
this.cmbRazonSocial1.Location = new System.Drawing.Point(8, 24);
this.cmbRazonSocial1.Name = "cmbRazonSocial1";
this.cmbRazonSocial1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.cmbRazonSocial1.Size = new System.Drawing.Size(329, 21);
this.cmbRazonSocial1.Sorted = true;
this.cmbRazonSocial1.TabIndex = 1;
//
// _Lbl_30
//
this._Lbl_30.AutoSize = true;
this._Lbl_30.BackColor = System.Drawing.SystemColors.Control;
this._Lbl_30.Cursor = System.Windows.Forms.Cursors.Default;
this._Lbl_30.ForeColor = System.Drawing.SystemColors.ControlText;
this._Lbl_30.Location = new System.Drawing.Point(168, 96);
this._Lbl_30.Name = "_Lbl_30";
this._Lbl_30.RightToLeft = System.Windows.Forms.RightToLeft.No;
this._Lbl_30.Size = new System.Drawing.Size(21, 13);
this._Lbl_30.TabIndex = 76;
this._Lbl_30.Text = "CP";
this._Lbl_30.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// lblCP1
//
this.lblCP1.BackColor = System.Drawing.SystemColors.Control;
this.lblCP1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.lblCP1.Cursor = System.Windows.Forms.Cursors.Default;
this.lblCP1.ForeColor = System.Drawing.SystemColors.ControlText;
this.lblCP1.Location = new System.Drawing.Point(168, 112);
this.lblCP1.Name = "lblCP1";
this.lblCP1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.lblCP1.Size = new System.Drawing.Size(65, 20);
this.lblCP1.TabIndex = 75;
//
// lblProvincia1
//
this.lblProvincia1.BackColor = System.Drawing.SystemColors.Control;
this.lblProvincia1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.lblProvincia1.Cursor = System.Windows.Forms.Cursors.Default;
this.lblProvincia1.ForeColor = System.Drawing.SystemColors.ControlText;
this.lblProvincia1.Location = new System.Drawing.Point(240, 112);
this.lblProvincia1.Name = "lblProvincia1";
this.lblProvincia1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.lblProvincia1.Size = new System.Drawing.Size(97, 20);
this.lblProvincia1.TabIndex = 5;
//
// lblLocalidad1
//
this.lblLocalidad1.BackColor = System.Drawing.SystemColors.Control;
this.lblLocalidad1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.lblLocalidad1.Cursor = System.Windows.Forms.Cursors.Default;
this.lblLocalidad1.ForeColor = System.Drawing.SystemColors.ControlText;
this.lblLocalidad1.Location = new System.Drawing.Point(8, 112);
this.lblLocalidad1.Name = "lblLocalidad1";
this.lblLocalidad1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.lblLocalidad1.Size = new System.Drawing.Size(153, 20);
this.lblLocalidad1.TabIndex = 7;
//
// lblDireccion1
//
this.lblDireccion1.BackColor = System.Drawing.SystemColors.Control;
this.lblDireccion1.BorderStyle = System.Windows.Forms.BorderStyle.Fixed3D;
this.lblDireccion1.Cursor = System.Windows.Forms.Cursors.Default;
this.lblDireccion1.ForeColor = System.Drawing.SystemColors.ControlText;
this.lblDireccion1.Location = new System.Drawing.Point(8, 72);
this.lblDireccion1.Name = "lblDireccion1";
this.lblDireccion1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.lblDireccion1.Size = new System.Drawing.Size(321, 20);
this.lblDireccion1.TabIndex = 6;
//
// _Lbl_13
//
this._Lbl_13.AutoSize = true;
this._Lbl_13.BackColor = System.Drawing.SystemColors.Control;
this._Lbl_13.Cursor = System.Windows.Forms.Cursors.Default;
this._Lbl_13.ForeColor = System.Drawing.SystemColors.ControlText;
this._Lbl_13.Location = new System.Drawing.Point(264, 48);
this._Lbl_13.Name = "_Lbl_13";
this._Lbl_13.RightToLeft = System.Windows.Forms.RightToLeft.No;
this._Lbl_13.Size = new System.Drawing.Size(39, 13);
this._Lbl_13.TabIndex = 11;
this._Lbl_13.Text = "Copias";
this._Lbl_13.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// _Lbl_1
//
this._Lbl_1.AutoSize = true;
this._Lbl_1.BackColor = System.Drawing.SystemColors.Control;
this._Lbl_1.Cursor = System.Windows.Forms.Cursors.Default;
this._Lbl_1.ForeColor = System.Drawing.SystemColors.ControlText;
this._Lbl_1.Location = new System.Drawing.Point(8, 56);
this._Lbl_1.Name = "_Lbl_1";
this._Lbl_1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this._Lbl_1.Size = new System.Drawing.Size(52, 13);
this._Lbl_1.TabIndex = 10;
this._Lbl_1.Text = "Direccion";
this._Lbl_1.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// _Lbl_2
//
this._Lbl_2.AutoSize = true;
this._Lbl_2.BackColor = System.Drawing.SystemColors.Control;
this._Lbl_2.Cursor = System.Windows.Forms.Cursors.Default;
this._Lbl_2.ForeColor = System.Drawing.SystemColors.ControlText;
this._Lbl_2.Location = new System.Drawing.Point(8, 96);
this._Lbl_2.Name = "_Lbl_2";
this._Lbl_2.RightToLeft = System.Windows.Forms.RightToLeft.No;
this._Lbl_2.Size = new System.Drawing.Size(53, 13);
this._Lbl_2.TabIndex = 9;
this._Lbl_2.Text = "Localidad";
this._Lbl_2.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// _Lbl_3
//
this._Lbl_3.AutoSize = true;
this._Lbl_3.BackColor = System.Drawing.SystemColors.Control;
this._Lbl_3.Cursor = System.Windows.Forms.Cursors.Default;
this._Lbl_3.ForeColor = System.Drawing.SystemColors.ControlText;
this._Lbl_3.Location = new System.Drawing.Point(240, 96);
this._Lbl_3.Name = "_Lbl_3";
this._Lbl_3.RightToLeft = System.Windows.Forms.RightToLeft.No;
this._Lbl_3.Size = new System.Drawing.Size(51, 13);
this._Lbl_3.TabIndex = 8;
this._Lbl_3.Text = "Provincia";
this._Lbl_3.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// _Lbl_0
//
this._Lbl_0.AutoSize = true;
this._Lbl_0.BackColor = System.Drawing.SystemColors.Control;
this._Lbl_0.Cursor = System.Windows.Forms.Cursors.Default;
this._Lbl_0.ForeColor = System.Drawing.SystemColors.ControlText;
this._Lbl_0.Location = new System.Drawing.Point(8, 8);
this._Lbl_0.Name = "_Lbl_0";
this._Lbl_0.RightToLeft = System.Windows.Forms.RightToLeft.No;
this._Lbl_0.Size = new System.Drawing.Size(70, 13);
this._Lbl_0.TabIndex = 2;
this._Lbl_0.Text = "Razon Social";
this._Lbl_0.TextAlign = System.Drawing.ContentAlignment.TopRight;
//
// Toolbar1
//
this.Toolbar1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
this.tlbNuevo,
this.toolStripSeparator1,
this.tlbGuardar,
this.toolStripSeparator2,
this.tbImprimir,
this.toolStripSeparator3,
this.tlbAnual,
this.toolStripSeparator4,
this.tlbEditar,
this.toolStripSeparator5,
this.tlbCorreo,
this.tlbCarteles
});
this.Toolbar1.Location = new System.Drawing.Point(0, 0);
this.Toolbar1.Name = "Toolbar1";
this.Toolbar1.Size = new System.Drawing.Size(1298, 29);
this.Toolbar1.TabIndex = 159;
//
// tlbNuevo
//
this.tlbNuevo.Image = ((System.Drawing.Image)(resources.GetObject("tlbNuevo.Image")));
this.tlbNuevo.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tlbNuevo.Name = "tlbNuevo";
this.tlbNuevo.Size = new System.Drawing.Size(26, 26);
this.tlbNuevo.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
this.tlbNuevo.ToolTipText = "Nuevo";
//
// toolStripSeparator1
//
this.toolStripSeparator1.Name = "toolStripSeparator1";
this.toolStripSeparator1.Size = new System.Drawing.Size(6, 29);
//
// tlbGuardar
//
this.tlbGuardar.Enabled = false;
this.tlbGuardar.Image = ((System.Drawing.Image)(resources.GetObject("tlbGuardar.Image")));
this.tlbGuardar.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tlbGuardar.Name = "tlbGuardar";
this.tlbGuardar.Size = new System.Drawing.Size(26, 26);
this.tlbGuardar.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
this.tlbGuardar.ToolTipText = "Guardar";
//
// toolStripSeparator2
//
this.toolStripSeparator2.Name = "toolStripSeparator2";
this.toolStripSeparator2.Size = new System.Drawing.Size(6, 29);
//
// tbImprimir
//
this.tbImprimir.Image = ((System.Drawing.Image)(resources.GetObject("tbImprimir.Image")));
this.tbImprimir.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tbImprimir.Name = "tbImprimir";
this.tbImprimir.Size = new System.Drawing.Size(26, 26);
this.tbImprimir.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
this.tbImprimir.ToolTipText = "Imprimir";
//
// toolStripSeparator3
//
this.toolStripSeparator3.Name = "toolStripSeparator3";
this.toolStripSeparator3.Size = new System.Drawing.Size(6, 29);
//
// tlbAnual
//
this.tlbAnual.Image = ((System.Drawing.Image)(resources.GetObject("tlbAnual.Image")));
this.tlbAnual.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tlbAnual.Name = "tlbAnual";
this.tlbAnual.Size = new System.Drawing.Size(26, 26);
this.tlbAnual.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
this.tlbAnual.ToolTipText = "Anular";
//
// toolStripSeparator4
//
this.toolStripSeparator4.Name = "toolStripSeparator4";
this.toolStripSeparator4.Size = new System.Drawing.Size(6, 29);
//
// tlbEditar
//
this.tlbEditar.Image = ((System.Drawing.Image)(resources.GetObject("tlbEditar.Image")));
this.tlbEditar.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tlbEditar.Name = "tlbEditar";
this.tlbEditar.Size = new System.Drawing.Size(26, 26);
this.tlbEditar.TextImageRelation = System.Windows.Forms.TextImageRelation.ImageAboveText;
this.tlbEditar.ToolTipText = "Editar";
//
// toolStripSeparator5
//
this.toolStripSeparator5.Name = "toolStripSeparator5";
this.toolStripSeparator5.Size = new System.Drawing.Size(6, 29);
//
// tlbCorreo
//
this.tlbCorreo.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.tlbCorreo.Image = ((System.Drawing.Image)(resources.GetObject("tlbCorreo.Image")));
this.tlbCorreo.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tlbCorreo.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tlbCorreo.Name = "tlbCorreo";
this.tlbCorreo.Size = new System.Drawing.Size(26, 26);
this.tlbCorreo.Text = "Correspondencia";
//
// tlbCarteles
//
this.tlbCarteles.DisplayStyle = System.Windows.Forms.ToolStripItemDisplayStyle.Image;
this.tlbCarteles.Image = ((System.Drawing.Image)(resources.GetObject("tlbCarteles.Image")));
this.tlbCarteles.ImageScaling = System.Windows.Forms.ToolStripItemImageScaling.None;
this.tlbCarteles.ImageTransparentColor = System.Drawing.Color.Magenta;
this.tlbCarteles.Name = "tlbCarteles";
this.tlbCarteles.Size = new System.Drawing.Size(26, 26);
this.tlbCarteles.Text = "Cartel";
//
// dataGridView1
//
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Location = new System.Drawing.Point(424, 40);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.Size = new System.Drawing.Size(786, 400);
this.dataGridView1.TabIndex = 160;
//
// frmCarteles
//
this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
this.BackColor = System.Drawing.SystemColors.Control;
this.ClientSize = new System.Drawing.Size(1298, 663);
this.Controls.Add(this.dataGridView1);
this.Controls.Add(this.Toolbar1);
this.Controls.Add(this.Cartel1);
this.Cursor = System.Windows.Forms.Cursors.Default;
this.Location = new System.Drawing.Point(4, 25);
this.Name = "frmCarteles";
this.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.Text = "Generador de Carteles";
this.Load += new System.EventHandler(this.FrmCartelesLoad);
this.Cartel1.ResumeLayout(false);
this.Cartel1.PerformLayout();
this.Toolbar1.ResumeLayout(false);
this.Toolbar1.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.ResumeLayout(false);
this.PerformLayout();
}
public static bool DataGridview2Sheet(System.Windows.Forms.DataGridView dataGridView1, string tableName)
{
NPOI.HSSF.UserModel.HSSFWorkbook wb = new NPOI.HSSF.UserModel.HSSFWorkbook();
NPOI.SS.UserModel.ISheet c = wb.CreateSheet(tableName);
List <DataGridViewColumn> ListColumns = new List <DataGridViewColumn>();
foreach (DataGridViewColumn i in dataGridView1.Columns)
{
if (i.Visible == true)
{
ListColumns.Add(i);
}
}
ListColumns = ListColumns.OrderBy(r => r.DisplayIndex).ToList();
if (dataGridView1.Rows.Count <= 0)
{
return(false);
}
foreach (DataGridViewColumn dc in ListColumns)
{
if (dc.Visible == false)
{
continue;
}
if (dc.ValueType == typeof(int) || dc.ValueType == typeof(decimal) || dc.ValueType == typeof(double))
{
c.SetColumnWidth(dc.Index, 10 * 256);
}
else
{
c.SetColumnWidth(dc.Index, 20 * 256);
}
}
#region 表头
NPOI.SS.UserModel.IRow RowHeader = c.CreateRow(0);
var FirstCell = RowHeader.CreateCell(0);
FirstCell.SetCellValue(BugsBox.Pharmacy.AppClient.Common.AppClientContext.Config.Store.Name + tableName);
NPOI.SS.UserModel.ICellStyle cellstyleHeader = wb.CreateCellStyle();
cellstyleHeader.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
cellstyleHeader.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
cellstyleHeader.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
cellstyleHeader.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
NPOI.SS.UserModel.IFont CellFontHeader = wb.CreateFont();
CellFontHeader.FontName = "微软雅黑";
CellFontHeader.FontHeightInPoints = 16;
cellstyleHeader.SetFont(CellFontHeader);
cellstyleHeader.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
FirstCell.CellStyle = cellstyleHeader;
c.AddMergedRegion(new NPOI.SS.Util.CellRangeAddress(0, 0, 0, ListColumns.Count - 1));
#endregion
#region 标题行 居中并且有框线
NPOI.SS.UserModel.ICellStyle CellStyleTitles = wb.CreateCellStyle();
CellStyleTitles.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleTitles.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleTitles.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleTitles.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleTitles.Alignment = NPOI.SS.UserModel.HorizontalAlignment.Center;
NPOI.SS.UserModel.IRow RowTitle = c.CreateRow(1);
int cindex = 0;
foreach (DataGridViewColumn hc in ListColumns)
{
if (!hc.Visible)
{
continue;
}
NPOI.SS.UserModel.ICell cell = RowTitle.CreateCell(cindex);
cindex++;
cell.CellStyle = CellStyleTitles;
if (!string.IsNullOrEmpty(hc.HeaderText))
{
cell.SetCellValue(hc.HeaderText);
}
}
#endregion
#region 列表 有框线,默认左对齐
NPOI.SS.UserModel.ICellStyle CellStyleLeftAlignmentCell = wb.CreateCellStyle();
CellStyleLeftAlignmentCell.BorderBottom = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleLeftAlignmentCell.BorderLeft = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleLeftAlignmentCell.BorderRight = NPOI.SS.UserModel.BorderStyle.Thin;
CellStyleLeftAlignmentCell.BorderTop = NPOI.SS.UserModel.BorderStyle.Thin;
foreach (DataGridViewRow i in dataGridView1.Rows)
{
NPOI.SS.UserModel.IRow row = c.CreateRow(i.Index + 2);
cindex = 0;
foreach (var u in ListColumns)
{
var col = dataGridView1.Rows[i.Index].Cells[u.Index];
if (!col.Visible)
{
continue;
}
NPOI.SS.UserModel.ICell xcell = row.CreateCell(cindex);
cindex++;
//设置居中对齐，如果是string则左对齐
if (col.ValueType == typeof(string) || col.ValueType == typeof(Guid))
{
xcell.CellStyle = CellStyleLeftAlignmentCell;//默认左对齐的风格
}
else
{
xcell.CellStyle = CellStyleTitles;//默认居中对齐的风格，与标题栏一致
}
if (col.Value == null)
{
continue;
}
if (col.ValueType == typeof(string))
{
xcell.SetCellValue(col.Value.ToString());
}
else if (col.ValueType == typeof(decimal?) || col.ValueType == typeof(int?) || col.ValueType == typeof(double?) || col.ValueType == typeof(decimal) || col.ValueType == typeof(int) || col.ValueType == typeof(double))
{
xcell.SetCellValue(double.Parse(col.Value.ToString()));
}
else
{
xcell.SetCellValue(col.Value.ToString());
}
}
}
#endregion
using (SaveFileDialog sfd = new SaveFileDialog())
{
sfd.Filter = "Excel电子表格|*.xls";
sfd.FileName = tableName + DateTime.Now.Ticks.ToString();
if (sfd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
try
{
using (System.IO.FileStream fs = System.IO.File.OpenWrite(sfd.FileName))
{
wb.Write(fs);
MessageBox.Show("导出成功！");
}
}
catch (System.IO.IOException ex)
{
MessageBox.Show("导出失败！\n" + ex.Message);
return(false);
}
}
}
return(true);
}
public static void FillExcel(System.Windows.Forms.DataGridView gridView, string FileName)
{
System.Reflection.Missing miss = System.Reflection.Missing.Value;
ApplicationClass excel = new ApplicationClass();
excel.Application.Workbooks.Add(true);;
excel.Visible = false;//若是true，则在导出的时候会显示EXcel界面。
if (excel == null)
{
MessageBox.Show("EXCEL无法启动！", "错误", MessageBoxButtons.OK, MessageBoxIcon.Error);
return;
}
Workbooks books = (Workbooks)excel.Workbooks;
Workbook book = (Workbook)(books.Add(miss));
Worksheet sheet = (Worksheet)book.ActiveSheet;
sheet.Name = "test";
float fl = 0;
//生成字段名称
for (int i = 0; i < gridView.ColumnCount; i++)
{
if (gridView.Columns[i].Visible == true && (gridView.Columns[i] is DataGridViewTextBoxColumn))
{
excel.Cells[1, i + 1] = gridView.Columns[i].HeaderText.ToString();
}
}
//填充数据
for (int i = 0; i < gridView.RowCount - 1; i++)
{
for (int j = 0; j < gridView.ColumnCount; j++)
{
if (gridView.Columns[j].Visible == true && (gridView.Columns[j] is DataGridViewTextBoxColumn))
{
if (gridView[j, i].Value == typeof(string))
{
excel.Cells[i + 2, j + 1] = "" + gridView[i, j].Value.ToString();
}
else
{
excel.Cells[i + 2, j + 1] = gridView[j, i].Value.ToString();
}
}
}
fl += 100 / float.Parse(gridView.RowCount.ToString());
if (fl > 1)
{
Excel.Block += 1;
fl = 0;
}
}
sheet.SaveAs(FileName, miss, miss, miss, miss, miss, XlSaveAsAccessMode.xlNoChange, miss, miss, miss);
book.Close(false, miss, miss);
books.Close();
excel.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(sheet);
System.Runtime.InteropServices.Marshal.ReleaseComObject(book);
System.Runtime.InteropServices.Marshal.ReleaseComObject(books);
System.Runtime.InteropServices.Marshal.ReleaseComObject(excel);
GC.Collect();
MessageBox.Show("数据已经成功导出到：" + FileName, "导出完成", MessageBoxButtons.OK, MessageBoxIcon.Information);
}
/// <summary>
/// Export file excel from datagridview - Created by Huynh Dung - ố ồ
/// </summary>
/// <param name="dgv"></param>
/// <param name="fileName"></param>
public void ExportFileFromDataGridView_Dung(System.Windows.Forms.DataGridView dgv, string fileName, string title)
{
//set properties for SaveFileDilog
SaveFileDialog sfdSave = new SaveFileDialog();
sfdSave.Filter = "Excel file(*.xls)|*.xls";
sfdSave.Title = "Save to Excel file";
sfdSave.FileName = fileName;
//proccess save file excel
if (sfdSave.ShowDialog() == DialogResult.OK)
{
//create file infomation
FileInfo f = new FileInfo(sfdSave.FileName);
//delete if file exists
if (f.Exists == true)
{
f.Delete();
}
//Create excel file
ExcelCOM.Application exApp = new ExcelCOM.Application();
ExcelCOM.Workbook exBook = exApp.Workbooks.Add(ExcelCOM.XlWBATemplate.xlWBATWorksheet);
ExcelCOM.Worksheet exSheet = (ExcelCOM.Worksheet)exBook.Worksheets[1];
//Microsoft.Office.Interop.Excel.Range excelCellrange;
ExcelCOM.Range excelCellrange;
exSheet.Name = fileName;
//import Caption
excelCellrange = exSheet.Range[exSheet.Cells[1, 1], exSheet.Cells[1, dgv.ColumnCount]];
exSheet.get_Range((object)exSheet.Cells[1, 1], (object)exSheet.Cells[1, dgv.ColumnCount]).Merge(false);
excelCellrange = exSheet.get_Range((object)exSheet.Cells[1, 1], (object)exSheet.Cells[1, dgv.ColumnCount]);
excelCellrange.FormulaR1C1 = title;
excelCellrange.HorizontalAlignment = 3;
excelCellrange.VerticalAlignment = 3;
excelCellrange = exSheet.Range[exSheet.Cells[2, 1], exSheet.Cells[dgv.RowCount + 2, dgv.ColumnCount]];
excelCellrange.NumberFormat = "@";
//import header
int col = 1;
for (int i = 1; i <= dgv.ColumnCount; i++)
{
exSheet.Cells[2, col] = dgv.Columns[i - 1].HeaderText;
col++;
//chartRange = exSheet.Cells[1, col];
//Font.Bold = true;
}
//import data
for (int i = 0; i < dgv.RowCount; i++)
{
col = 1;
for (int j = 0; j < dgv.ColumnCount; j++)
{
if (i != 0)
{
if ((dgv.Rows[i - 1].Cells[j].Value.ToString() == dgv.Rows[i].Cells[j].Value.ToString()) && (col == 1 || col == 2 || col == 3))
{
exSheet.get_Range((object)exSheet.Cells[i + 2, col], (object)exSheet.Cells[i + 3, col]).Merge(Type.Missing);
exSheet.Cells[i + 3, col] = dgv.Rows[i].Cells[j].Value.ToString();
}
else
{
exSheet.Cells[i + 3, col] = dgv.Rows[i].Cells[j].Value.ToString();
}
}
else
{
exSheet.Cells[i + 3, col] = dgv.Rows[i].Cells[j].Value.ToString();
}
col++;
//chartRange.Cells.Formula
}
}
//
// now we resize the columns
excelCellrange = exSheet.Range[exSheet.Cells[1, 1], exSheet.Cells[dgv.RowCount + 2, dgv.ColumnCount]];
excelCellrange.EntireColumn.AutoFit();
//excelCellrange.OutlineLevel = 2;
//excelCellrange.Group(Type.Missing, Type.Missing, Type.Missing, Type.Missing);
Microsoft.Office.Interop.Excel.Borders border = excelCellrange.Borders;
border.LineStyle = Microsoft.Office.Interop.Excel.XlLineStyle.xlContinuous;
border.Weight = 2d;
//excelCellrange = exSheet.Range[exSheet.Cells[1, 1], exSheet.Cells[1, dgv.ColumnCount]];
//FormattingExcelCells(excelCellrange, "#f5f5f5", System.Drawing.Color.DarkBlue, true);
//excelCellrange = exSheet.Range[exSheet.Cells[2, 1], exSheet.Cells[2, dgv.ColumnCount]];
//FormattingExcelCells(excelCellrange, "#0488a1", System.Drawing.Color.White, true);
exApp.Visible = false;
//
//exBook = ActiveWorkbook;
exBook.CheckCompatibility = false;
//Save file excel into dictionary that you choose
exBook.SaveAs(sfdSave.FileName, ExcelCOM.XlFileFormat.xlWorkbookNormal,
null, null, false, false,
ExcelCOM.XlSaveAsAccessMode.xlExclusive,
false, false, false, false, false);
//close and release object
exBook.Close(false, false, false);
exApp.Quit();
System.Runtime.InteropServices.Marshal.ReleaseComObject(exBook);
System.Runtime.InteropServices.Marshal.ReleaseComObject(exApp);
CustomMessageBox.MessageBox.ShowCustomMessageBox(Common.clsLanguages.GetResource("CRMFileExportSuccess"),
Common.clsLanguages.GetResource("CRMInformation"),
Common.Config.CUSTOM_MESSAGEBOX_ICON.Information,
Common.Config.CUSTOM_MESSAGEBOX_BUTTON.OK);
}
}
private void InitializeComponent()
{
this.pnlTop = new System.Windows.Forms.Panel();
this.lblMsg = new System.Windows.Forms.Label();
this.txtBarcode2 = new System.Windows.Forms.TextBox();
this.label5 = new System.Windows.Forms.Label();
this.panel3 = new System.Windows.Forms.Panel();
this.button3 = new System.Windows.Forms.Button();
this.button4 = new System.Windows.Forms.Button();
this.panel1 = new System.Windows.Forms.Panel();
this.button2 = new System.Windows.Forms.Button();
this.button1 = new System.Windows.Forms.Button();
this.txtBarcode1 = new System.Windows.Forms.TextBox();
this.label2 = new System.Windows.Forms.Label();
this.txtNaka = new System.Windows.Forms.TextBox();
this.label1 = new System.Windows.Forms.Label();
this.pnlFooter = new System.Windows.Forms.Panel();
this.txtBarcodeEdit2 = new System.Windows.Forms.TextBox();
this.label6 = new System.Windows.Forms.Label();
this.panel2 = new System.Windows.Forms.Panel();
this.btnRemove = new System.Windows.Forms.Button();
this.btnCancelEdit = new System.Windows.Forms.Button();
this.btnSaveEdit = new System.Windows.Forms.Button();
this.txtBarcodeEdit1 = new System.Windows.Forms.TextBox();
this.label3 = new System.Windows.Forms.Label();
this.pnlMain = new System.Windows.Forms.Panel();
this.dataGridView1 = new System.Windows.Forms.DataGridView();
this.txtSearch = new System.Windows.Forms.TextBox();
this.pnlTop.SuspendLayout();
this.panel3.SuspendLayout();
this.panel1.SuspendLayout();
this.pnlFooter.SuspendLayout();
this.panel2.SuspendLayout();
this.pnlMain.SuspendLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).BeginInit();
this.SuspendLayout();
//
// pnlTop
//
this.pnlTop.Controls.Add(this.lblMsg);
this.pnlTop.Controls.Add(this.txtBarcode2);
this.pnlTop.Controls.Add(this.label5);
this.pnlTop.Controls.Add(this.panel3);
this.pnlTop.Controls.Add(this.panel1);
this.pnlTop.Controls.Add(this.txtBarcode1);
this.pnlTop.Controls.Add(this.label2);
this.pnlTop.Controls.Add(this.txtNaka);
this.pnlTop.Controls.Add(this.label1);
this.pnlTop.Dock = System.Windows.Forms.DockStyle.Top;
this.pnlTop.Location = new System.Drawing.Point(0, 0);
this.pnlTop.Name = "pnlTop";
this.pnlTop.Size = new System.Drawing.Size(684, 133);
this.pnlTop.TabIndex = 0;
//
// lblMsg
//
this.lblMsg.BackColor = System.Drawing.Color.Salmon;
this.lblMsg.Dock = System.Windows.Forms.DockStyle.Bottom;
this.lblMsg.Location = new System.Drawing.Point(0, 113);
this.lblMsg.Name = "lblMsg";
this.lblMsg.Size = new System.Drawing.Size(684, 20);
this.lblMsg.TabIndex = 7;
this.lblMsg.Text = "پيغامها";
//
// txtBarcode2
//
this.txtBarcode2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.txtBarcode2.Location = new System.Drawing.Point(14, 41);
this.txtBarcode2.Name = "txtBarcode2";
this.txtBarcode2.Size = new System.Drawing.Size(245, 26);
this.txtBarcode2.TabIndex = 2;
this.txtBarcode2.Tag = "S";
this.txtBarcode2.TextChanged += new System.EventHandler(this.TxtBarcode1_TextChanged);
this.txtBarcode2.Enter += new System.EventHandler(this.TxtNaka_Enter);
this.txtBarcode2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.TxtBarcode2_KeyDown);
this.txtBarcode2.Leave += new System.EventHandler(this.TxtNaka_Leave);
//
// label5
//
this.label5.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label5.AutoSize = true;
this.label5.Location = new System.Drawing.Point(265, 42);
this.label5.Name = "label5";
this.label5.Size = new System.Drawing.Size(81, 20);
this.label5.TabIndex = 6;
this.label5.Text = "باركد2 (S) : ";
//
// panel3
//
this.panel3.Controls.Add(this.button3);
this.panel3.Controls.Add(this.button4);
this.panel3.Location = new System.Drawing.Point(12, 75);
this.panel3.Name = "panel3";
this.panel3.Size = new System.Drawing.Size(200, 29);
this.panel3.TabIndex = 4;
//
// button3
//
this.button3.BackColor = System.Drawing.Color.DarkGoldenrod;
this.button3.ForeColor = System.Drawing.Color.Snow;
this.button3.Location = new System.Drawing.Point(-1, 0);
this.button3.Name = "button3";
this.button3.Size = new System.Drawing.Size(105, 29);
this.button3.TabIndex = 3;
this.button3.Text = "ارسال به اكسل";
this.button3.UseVisualStyleBackColor = false;
this.button3.Click += new System.EventHandler(this.Excell_Click);
//
// button4
//
this.button4.BackColor = System.Drawing.Color.DarkSlateBlue;
this.button4.ForeColor = System.Drawing.SystemColors.ButtonFace;
this.button4.Location = new System.Drawing.Point(103, 0);
this.button4.Name = "button4";
this.button4.Size = new System.Drawing.Size(82, 29);
this.button4.TabIndex = 2;
this.button4.Text = "چاپ";
this.button4.UseVisualStyleBackColor = false;
this.button4.Click += new System.EventHandler(this.Print_Click);
//
// panel1
//
this.panel1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.panel1.Controls.Add(this.button2);
this.panel1.Controls.Add(this.button1);
this.panel1.Location = new System.Drawing.Point(484, 71);
this.panel1.Name = "panel1";
this.panel1.Size = new System.Drawing.Size(195, 33);
this.panel1.TabIndex = 3;
//
// button2
//
this.button2.BackColor = System.Drawing.Color.Crimson;
this.button2.ForeColor = System.Drawing.SystemColors.ButtonFace;
this.button2.Location = new System.Drawing.Point(17, 1);
this.button2.Name = "button2";
this.button2.Size = new System.Drawing.Size(82, 29);
this.button2.TabIndex = 1;
this.button2.Text = "انصراف";
this.button2.UseVisualStyleBackColor = false;
this.button2.Click += new System.EventHandler(this.Delete_Click);
//
// button1
//
this.button1.BackColor = System.Drawing.Color.LimeGreen;
this.button1.Location = new System.Drawing.Point(105, 1);
this.button1.Name = "button1";
this.button1.Size = new System.Drawing.Size(82, 29);
this.button1.TabIndex = 0;
this.button1.Text = "ثبت";
this.button1.UseVisualStyleBackColor = false;
this.button1.Click += new System.EventHandler(this.Save_Click);
//
// txtBarcode1
//
this.txtBarcode1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.txtBarcode1.Location = new System.Drawing.Point(349, 40);
this.txtBarcode1.Name = "txtBarcode1";
this.txtBarcode1.Size = new System.Drawing.Size(245, 26);
this.txtBarcode1.TabIndex = 1;
this.txtBarcode1.Tag = "P";
this.txtBarcode1.TextChanged += new System.EventHandler(this.TxtBarcode1_TextChanged);
this.txtBarcode1.Enter += new System.EventHandler(this.TxtNaka_Enter);
this.txtBarcode1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.TxtNaka_KeyDown);
this.txtBarcode1.Leave += new System.EventHandler(this.TxtNaka_Leave);
//
// label2
//
this.label2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label2.AutoSize = true;
this.label2.Location = new System.Drawing.Point(600, 41);
this.label2.Name = "label2";
this.label2.Size = new System.Drawing.Size(80, 20);
this.label2.TabIndex = 2;
this.label2.Text = "باركد1 (P) : ";
//
// txtNaka
//
this.txtNaka.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.txtNaka.Enabled = false;
this.txtNaka.Location = new System.Drawing.Point(349, 8);
this.txtNaka.Name = "txtNaka";
this.txtNaka.Size = new System.Drawing.Size(245, 26);
this.txtNaka.TabIndex = 0;
this.txtNaka.Enter += new System.EventHandler(this.TxtNaka_Enter);
this.txtNaka.KeyDown += new System.Windows.Forms.KeyEventHandler(this.TxtNaka_KeyDown);
this.txtNaka.Leave += new System.EventHandler(this.TxtNaka_Leave);
//
// label1
//
this.label1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label1.AutoSize = true;
this.label1.Location = new System.Drawing.Point(600, 9);
this.label1.Name = "label1";
this.label1.Size = new System.Drawing.Size(53, 20);
this.label1.TabIndex = 0;
this.label1.Text = "نام كالا :";
//
// pnlFooter
//
this.pnlFooter.Controls.Add(this.txtBarcodeEdit2);
this.pnlFooter.Controls.Add(this.label6);
this.pnlFooter.Controls.Add(this.panel2);
this.pnlFooter.Controls.Add(this.txtBarcodeEdit1);
this.pnlFooter.Controls.Add(this.label3);
this.pnlFooter.Dock = System.Windows.Forms.DockStyle.Bottom;
this.pnlFooter.Location = new System.Drawing.Point(0, 283);
this.pnlFooter.Name = "pnlFooter";
this.pnlFooter.Size = new System.Drawing.Size(684, 78);
this.pnlFooter.TabIndex = 1;
this.pnlFooter.Visible = false;
//
// txtBarcodeEdit2
//
this.txtBarcodeEdit2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.txtBarcodeEdit2.Location = new System.Drawing.Point(11, 7);
this.txtBarcodeEdit2.Name = "txtBarcodeEdit2";
this.txtBarcodeEdit2.Size = new System.Drawing.Size(245, 26);
this.txtBarcodeEdit2.TabIndex = 2;
this.txtBarcodeEdit2.Tag = "S";
this.txtBarcodeEdit2.TextChanged += new System.EventHandler(this.TxtBarcode1_TextChanged);
this.txtBarcodeEdit2.Enter += new System.EventHandler(this.TxtNaka_Enter);
this.txtBarcodeEdit2.KeyDown += new System.Windows.Forms.KeyEventHandler(this.TxtBarcodeEdit2_KeyDown);
this.txtBarcodeEdit2.Leave += new System.EventHandler(this.TxtNaka_Leave);
//
// label6
//
this.label6.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label6.AutoSize = true;
this.label6.Location = new System.Drawing.Point(262, 8);
this.label6.Name = "label6";
this.label6.Size = new System.Drawing.Size(81, 20);
this.label6.TabIndex = 10;
this.label6.Text = "باركد2 (S) : ";
//
// panel2
//
this.panel2.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.panel2.Controls.Add(this.btnRemove);
this.panel2.Controls.Add(this.btnCancelEdit);
this.panel2.Controls.Add(this.btnSaveEdit);
this.panel2.Location = new System.Drawing.Point(399, 37);
this.panel2.Name = "panel2";
this.panel2.Size = new System.Drawing.Size(277, 33);
this.panel2.TabIndex = 3;
//
// btnRemove
//
this.btnRemove.BackColor = System.Drawing.Color.Red;
this.btnRemove.ForeColor = System.Drawing.Color.Transparent;
this.btnRemove.Location = new System.Drawing.Point(97, 2);
this.btnRemove.Name = "btnRemove";
this.btnRemove.Size = new System.Drawing.Size(82, 29);
this.btnRemove.TabIndex = 3;
this.btnRemove.Text = "حذف";
this.btnRemove.UseVisualStyleBackColor = false;
this.btnRemove.Click += new System.EventHandler(this.BtnRemove_Click);
//
// btnCancelEdit
//
this.btnCancelEdit.BackColor = System.Drawing.Color.Crimson;
this.btnCancelEdit.ForeColor = System.Drawing.SystemColors.ButtonFace;
this.btnCancelEdit.Location = new System.Drawing.Point(17, 1);
this.btnCancelEdit.Name = "btnCancelEdit";
this.btnCancelEdit.Size = new System.Drawing.Size(82, 29);
this.btnCancelEdit.TabIndex = 1;
this.btnCancelEdit.Text = "انصراف";
this.btnCancelEdit.UseVisualStyleBackColor = false;
this.btnCancelEdit.Click += new System.EventHandler(this.CancelEdit_Click);
//
// btnSaveEdit
//
this.btnSaveEdit.BackColor = System.Drawing.Color.LimeGreen;
this.btnSaveEdit.Location = new System.Drawing.Point(190, 1);
this.btnSaveEdit.Name = "btnSaveEdit";
this.btnSaveEdit.Size = new System.Drawing.Size(82, 29);
this.btnSaveEdit.TabIndex = 0;
this.btnSaveEdit.Text = "ثبت";
this.btnSaveEdit.UseVisualStyleBackColor = false;
this.btnSaveEdit.Click += new System.EventHandler(this.BtnSaveEdit_Click);
//
// txtBarcodeEdit1
//
this.txtBarcodeEdit1.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.txtBarcodeEdit1.Location = new System.Drawing.Point(347, 6);
this.txtBarcodeEdit1.Name = "txtBarcodeEdit1";
this.txtBarcodeEdit1.Size = new System.Drawing.Size(245, 26);
this.txtBarcodeEdit1.TabIndex = 1;
this.txtBarcodeEdit1.Tag = "P";
this.txtBarcodeEdit1.TextChanged += new System.EventHandler(this.TxtBarcode1_TextChanged);
this.txtBarcodeEdit1.Enter += new System.EventHandler(this.TxtNaka_Enter);
this.txtBarcodeEdit1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.TxtNaka_KeyDown);
this.txtBarcodeEdit1.Leave += new System.EventHandler(this.TxtNaka_Leave);
//
// label3
//
this.label3.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));
this.label3.AutoSize = true;
this.label3.Location = new System.Drawing.Point(598, 7);
this.label3.Name = "label3";
this.label3.Size = new System.Drawing.Size(80, 20);
this.label3.TabIndex = 7;
this.label3.Text = "باركد1 (P) : ";
//
// pnlMain
//
this.pnlMain.Controls.Add(this.dataGridView1);
this.pnlMain.Controls.Add(this.txtSearch);
this.pnlMain.Dock = System.Windows.Forms.DockStyle.Fill;
this.pnlMain.Location = new System.Drawing.Point(0, 133);
this.pnlMain.Name = "pnlMain";
this.pnlMain.Size = new System.Drawing.Size(684, 150);
this.pnlMain.TabIndex = 2;
//
// dataGridView1
//
this.dataGridView1.AllowUserToAddRows = false;
this.dataGridView1.AllowUserToDeleteRows = false;
this.dataGridView1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
this.dataGridView1.Dock = System.Windows.Forms.DockStyle.Fill;
this.dataGridView1.Location = new System.Drawing.Point(0, 26);
this.dataGridView1.Name = "dataGridView1";
this.dataGridView1.ReadOnly = true;
this.dataGridView1.RightToLeft = System.Windows.Forms.RightToLeft.No;
this.dataGridView1.RowHeadersVisible = false;
this.dataGridView1.SelectionMode = System.Windows.Forms.DataGridViewSelectionMode.FullRowSelect;
this.dataGridView1.Size = new System.Drawing.Size(684, 124);
this.dataGridView1.TabIndex = 0;
this.dataGridView1.CellDoubleClick += new System.Windows.Forms.DataGridViewCellEventHandler(this.DataGridView1_CellDoubleClick);
this.dataGridView1.KeyDown += new System.Windows.Forms.KeyEventHandler(this.DataGridView1_KeyDown);
//
// txtSearch
//
this.txtSearch.Dock = System.Windows.Forms.DockStyle.Top;
this.txtSearch.Location = new System.Drawing.Point(0, 0);
this.txtSearch.Name = "txtSearch";
this.txtSearch.Size = new System.Drawing.Size(684, 26);
this.txtSearch.TabIndex = 1;
this.txtSearch.TextChanged += new System.EventHandler(this.Txtsearch_TextChanged);
this.txtSearch.Enter += new System.EventHandler(this.TxtNaka_Enter);
this.txtSearch.KeyDown += new System.Windows.Forms.KeyEventHandler(this.Txtsearch_KeyDown);
this.txtSearch.Leave += new System.EventHandler(this.TxtNaka_Leave);
//
// BarcodeDefinition
//
this.ClientSize = new System.Drawing.Size(684, 361);
this.Controls.Add(this.pnlMain);
this.Controls.Add(this.pnlFooter);
this.Controls.Add(this.pnlTop);
this.Font = new System.Drawing.Font("Microsoft Sans Serif", 12F, System.Drawing.FontStyle.Regular, System.Drawing.GraphicsUnit.Point, ((byte)(178)));
this.Name = "BarcodeDefinition";
this.RightToLeft = System.Windows.Forms.RightToLeft.Yes;
this.Text = "تعريف كالا";
this.pnlTop.ResumeLayout(false);
this.pnlTop.PerformLayout();
this.panel3.ResumeLayout(false);
this.panel1.ResumeLayout(false);
this.pnlFooter.ResumeLayout(false);
this.pnlFooter.PerformLayout();
this.panel2.ResumeLayout(false);
this.pnlMain.ResumeLayout(false);
this.pnlMain.PerformLayout();
((System.ComponentModel.ISupportInitialize)(this.dataGridView1)).EndInit();
this.ResumeLayout(false);
}
private void add_product()
{
TabPage newTabPage = new TabPage("Продукт");
Label label1 = new System.Windows.Forms.Label();
label1.AutoSize = true;
label1.Location = new System.Drawing.Point(10, 15);
label1.Text = "Наименование (код)";
ComboBox cb_nameProduct = new System.Windows.Forms.ComboBox();
cb_nameProduct.FormattingEnabled = true;
cb_nameProduct.Location = new System.Drawing.Point(10, 30);
cb_nameProduct.Name = "cb_nameProduct";
cb_nameProduct.Size = new System.Drawing.Size(150, 21);
cb_nameProduct.TabIndex = 1;
cb_nameProduct.SelectedIndexChanged += new System.EventHandler(this.cb_nameProduct_SelectedIndexChanged);
foreach (Product pr in products)
{
cb_nameProduct.Items.Add(pr.ToString());
}
Label label2 = new System.Windows.Forms.Label();
label2.AutoSize = true;
label2.Location = new System.Drawing.Point(180, 15);
label2.Text = "Количество";
TextBox tb_Count = new System.Windows.Forms.TextBox();
tb_Count.Location = new System.Drawing.Point(180, 30);
tb_Count.Name = "tb_Count";
tb_Count.Size = new System.Drawing.Size(80, 20);
tb_Count.TabIndex = 2;
tb_Count.KeyPress += new KeyPressEventHandler(integer_tb_validator);
tb_Count.TextChanged += new EventHandler(tb_count_textChanged);
Label label3 = new System.Windows.Forms.Label();
label3.AutoSize = true;
label3.Location = new System.Drawing.Point(280, 15);
label3.Text = "Цена продажи";
TextBox tb_Price = new System.Windows.Forms.TextBox();
tb_Price.Location = new System.Drawing.Point(280, 30);
tb_Price.Name = "tb_Price";
tb_Price.Size = new System.Drawing.Size(80, 20);
tb_Price.TabIndex = 3;
tb_Price.KeyPress += new KeyPressEventHandler(float_tb_validator);
tb_Price.TextChanged += new EventHandler(tb_priceProd_textChanged);
Label labelSPriceUnit = new System.Windows.Forms.Label();
labelSPriceUnit.AutoSize = true;
labelSPriceUnit.Location = new System.Drawing.Point(365, 30);
labelSPriceUnit.Text = "руб";
Label labelFact = new System.Windows.Forms.Label();
labelFact.AutoSize = true;
labelFact.Location = new System.Drawing.Point(10, 60);
labelFact.Text = "Факт. выпуск";
TextBox tb_Fact = new System.Windows.Forms.TextBox();
tb_Fact.Location = new System.Drawing.Point(10, 75);
tb_Fact.Name = "tb_Fact";
tb_Fact.Size = new System.Drawing.Size(80, 20);
tb_Fact.TabIndex = 3;
tb_Fact.KeyPress += new KeyPressEventHandler(integer_tb_validator);
Label labelMass = new System.Windows.Forms.Label();
labelMass.AutoSize = true;
labelMass.Location = new System.Drawing.Point(180, 60);
labelMass.Text = "Масса 1 шт";
TextBox tb_Mass = new System.Windows.Forms.TextBox();
tb_Mass.Location = new System.Drawing.Point(180, 75);
tb_Mass.Name = "tb_Mass";
//tb_Mass.ReadOnly = true;
tb_Mass.Size = new System.Drawing.Size(80, 20);
tb_Mass.TabStop = false;
tb_Mass.KeyPress += new KeyPressEventHandler(float_tb_validator);
//tb_Mass.Text = "100";
Label labelMassUnit = new System.Windows.Forms.Label();
labelMassUnit.AutoSize = true;
labelMassUnit.Location = new System.Drawing.Point(265, 75);
labelMassUnit.Text = "г.";
Label labelSum = new System.Windows.Forms.Label();
labelSum.AutoSize = true;
labelSum.Location = new System.Drawing.Point(280, 60);
labelSum.Text = "Сумма";
TextBox tb_Sum = new System.Windows.Forms.TextBox();
tb_Sum.Location = new System.Drawing.Point(280, 75);
tb_Sum.Name = "tb_Sum";
tb_Sum.ReadOnly = true;
tb_Sum.Size = new System.Drawing.Size(80, 20);
tb_Sum.TabStop = false;
Label labelSumUnit = new System.Windows.Forms.Label();
labelSumUnit.AutoSize = true;
labelSumUnit.Location = new System.Drawing.Point(365, 75);
labelSumUnit.Text = "руб";
Button btn_Close = new System.Windows.Forms.Button();
btn_Close.Location = new System.Drawing.Point(tabProducts.Width - 30, 0);
btn_Close.Name = "btn_CloseProduct";
btn_Close.Size = new System.Drawing.Size(20, 20);
btn_Close.TabStop = false;
btn_Close.Text = "X";
btn_Close.Click += new System.EventHandler(this.btn_CloseProduct_Click);
DataGridViewTextBoxColumn Col_Norma = new System.Windows.Forms.DataGridViewTextBoxColumn();
DataGridViewComboBoxColumn Col_unit = new System.Windows.Forms.DataGridViewComboBoxColumn();
DataGridViewTextBoxColumn Col_sum = new System.Windows.Forms.DataGridViewTextBoxColumn();
//
// Col_Norma
//
Col_Norma.HeaderText = "Норма";
Col_Norma.Name = "Col_Norma";
Col_Norma.Width = 215;
//
// Col_sum
//
Col_sum.HeaderText = "Всего";
Col_sum.Name = "Col_sum";
Col_sum.ReadOnly = true;
Col_sum.Resizable = System.Windows.Forms.DataGridViewTriState.True;
Col_sum.SortMode = System.Windows.Forms.DataGridViewColumnSortMode.NotSortable;
Col_sum.Width = 185;
DataGridView dgv_MaterialsPr_1 = new System.Windows.Forms.DataGridView();
dgv_MaterialsPr_1.Location = new Point(10, 121);
((System.ComponentModel.ISupportInitialize)(dgv_MaterialsPr_1)).BeginInit();
dgv_MaterialsPr_1.ColumnHeadersHeightSizeMode = System.Windows.Forms.DataGridViewColumnHeadersHeightSizeMode.AutoSize;
dgv_MaterialsPr_1.Columns.AddRange(new System.Windows.Forms.DataGridViewColumn[] {
Col_Norma,
Col_sum
});
dgv_MaterialsPr_1.Name = "dgv_MaterialsPr"; // + tabProducts.TabCount;
dgv_MaterialsPr_1.Size = new System.Drawing.Size(440, 384);
dgv_MaterialsPr_1.TabIndex = 125;
dgv_MaterialsPr_1.AllowUserToAddRows = false;
dgv_MaterialsPr_1.AllowUserToDeleteRows = false;
dgv_MaterialsPr_1.AllowUserToOrderColumns = false;
dgv_MaterialsPr_1.AllowUserToResizeColumns = false;
dgv_MaterialsPr_1.AllowUserToResizeRows = false;
dgv_MaterialsPr_1.RowHeadersVisible = false;
dgv_MaterialsPr_1.CellValueChanged += new System.Windows.Forms.DataGridViewCellEventHandler(this.dgv_MateialsPr_CellValueChanged);
//dgv_MaterialsPr_1.ColumnHeadersHeight = 40;
((System.ComponentModel.ISupportInitialize)(dgv_MaterialsPr_1)).EndInit();
newTabPage.Controls.Add(label1);
newTabPage.Controls.Add(cb_nameProduct);
newTabPage.Controls.Add(label2);
newTabPage.Controls.Add(label3);
newTabPage.Controls.Add(labelMass);
newTabPage.Controls.Add(tb_Mass);
newTabPage.Controls.Add(labelMassUnit);
newTabPage.Controls.Add(tb_Count);
newTabPage.Controls.Add(tb_Price);
newTabPage.Controls.Add(labelSPriceUnit);
newTabPage.Controls.Add(labelFact);
newTabPage.Controls.Add(tb_Fact);
newTabPage.Controls.Add(labelSum);
newTabPage.Controls.Add(tb_Sum);
newTabPage.Controls.Add(labelSumUnit);
newTabPage.Controls.Add(btn_Close);
newTabPage.Controls.Add(dgv_MaterialsPr_1);
newTabPage.ResumeLayout(false);
newTabPage.PerformLayout();
tabProducts.TabPages.Add(newTabPage);
tabProducts.SelectedTab = newTabPage;
//panelMaterials.VerticalScroll.Value = panelMaterials.VerticalScroll.Value;
for (int j = 0; j < countMaterials; j++)
{
copy_material(tabProducts.TabCount - 1, j);
}
}
/// <summary>
/// Поиск текста по гриду.
/// </summary>
/// <param name="DGSearch"></param>
/// <param name="DGResult"></param>
/// <param name="SearchText"></param>
/// <param name="FirstRow"></param>
/// <param name="CaseSensitivity"></param>
/// <param name="OnlySelectedColumns"></param>
/// <param name="OnlySelectedRows"></param>
/// <param name="OnlySelectedArea"></param>
/// <param name="SearchDirection"></param>
/// <param name="SearchPart"></param>
/// <param name="SelectedRows"></param>
/// <param name="SelectedColumns"></param>
/// <param name="FindCount"></param>
/// <returns></returns>
public static bool SerchTextSourceGrid(FBA.GridFBA DGSearch,
System.Windows.Forms.DataGridView DGResult,
string SearchText,
int FirstRow,
bool CaseSensitivity,
bool OnlySelectedColumns,
bool OnlySelectedRows,
bool OnlySelectedArea,
int SearchDirection,
int SearchPart,
int[] SelectedRows,
int[] SelectedColumns,
ref int FindCount)
{
//SearchPart = 1 - Exact match.
//SearchPart = 2 - Starts with text.
//SearchPart = 3 - Ends with text.
//SearchPart = 4 - Contain text.
//SearchDirection = 1 - All.
//SearchDirection = 2 - Down.
//SearchDirection = 3 - Up.
//SearchDirection = 0
if (SearchText.IsNullOrEmpty())
{
return(false);
}
//Чувствительность к регистру. Если true, то регистрозависимый поиск.
if (!CaseSensitivity)
{
SearchText = SearchText.ToLower();
}
//Если поиск Ends with text.
if (SearchPart == 3)
{
SearchText = SearchText.Reverse();
}
if (DGResult != null)
{
//Копируем структуру. Только названия полей.
DGResult.Columns.Add("Num", "Num");
for (int j = 0; j < DGSearch.Columns.Count; j++)
{
string ColumnName = DGSearch.Columns[j].PropertyName;
string ColumnHeader = DGSearch.Columns[j].PropertyName;
DGResult.Columns.Add(ColumnName, ColumnHeader);
}
}
string Value = "";
int CountFind = 0;
//Ищем по всему гриду или только вниз.
if ((SearchDirection == 1) || (SearchDirection == 2))
{
for (int iRow = FirstRow; iRow < DGSearch.Rows.Count; iRow++)
{
//Если поиск по выделенным строкам
if ((OnlySelectedArea) || (OnlySelectedRows))
{
if (!SelectedRows.Contains(iRow))
{
continue;
}
}
bool FindRow = false;
for (int iColumn = 0; iColumn < DGSearch.Columns.Count; iColumn++)
{
//Если поиск по выделенным колонкам
if ((OnlySelectedArea) || (OnlySelectedColumns))
{
if (!SelectedColumns.Contains(iColumn))
{
continue;
}
}
bool FindCell = false;
if (!CaseSensitivity)
{
Value = DGSearch.Value(iRow, iColumn).ToLower();
}
else
{
Value = DGSearch.Value(iRow, iColumn);
}
if ((SearchPart == 1) && (Value == SearchText))
{
FindCell = true;
}
if ((SearchPart == 2) && (Value.IndexOf(SearchText, StringComparison.CurrentCulture) == 0))
{
FindCell = true;
}
if ((SearchPart == 3) && (Value.Reverse().IndexOf(SearchText, StringComparison.CurrentCulture) == 0))
{
FindCell = true;
}
if ((SearchPart == 4) && (Value.IndexOf(SearchText, StringComparison.CurrentCulture) > -1))
{
FindCell = true;
}
if (!FindCell)
{
continue;
}
CountFind++;
if (CountFind == 1)
{
DGSearch.SelectColumnRowCell(iRow, iColumn, true); //В sysData.
}
FindRow = true;
FindCount++;
}
//Если нашли строку:
if (FindRow)
{
var rowstr = new string[DGSearch.Columns.Count + 1];
rowstr[0] = (iRow - 1).ToString();
for (int N = 0; N < DGSearch.Columns.Count; N++)
{
rowstr[N + 1] = DGSearch.Value(iRow, N);
}
if (DGResult != null)
{
DGResult.Rows.Add(rowstr);
}
//Если ищем только до первой найденной строки, то выходим. Direction Search = Down.
if (SearchDirection == 2)
{
return(true);
}
}
}
}
if (SearchDirection == 3)
{
for (int iRow = DGSearch.Rows.Count - 1; iRow >= 0; iRow--)
{
//Если поиск по выделенным строкам
if ((OnlySelectedArea) || (OnlySelectedRows))
{
if (!SelectedRows.Contains(iRow))
{
continue;
}
}
bool FindRow = false;
for (int iColumn = 0; iColumn < DGSearch.Columns.Count; iColumn++)
{
//Если поиск по выделенным колонкам
if ((OnlySelectedArea) || (OnlySelectedColumns))
{
if (!SelectedColumns.Contains(iColumn))
{
continue;
}
}
bool FindCell = false;
if (!CaseSensitivity)
{
Value = DGSearch.Value(iRow, iColumn).ToLower();
}
else
{
Value = DGSearch.Value(iRow, iColumn);
}
if ((SearchPart == 1) && (Value == SearchText))
{
FindCell = true;
}
if ((SearchPart == 2) && (Value.IndexOf(SearchText, StringComparison.CurrentCulture) == 0))
{
FindCell = true;
}
if ((SearchPart == 3) && (Value.Reverse().IndexOf(SearchText, StringComparison.CurrentCulture) == 0))
{
FindCell = true;
}
if ((SearchPart == 4) && (Value.IndexOf(SearchText, StringComparison.CurrentCulture) > -1))
{
FindCell = true;
}
if (!FindCell)
{
continue;
}
CountFind++;
if (CountFind == 1)
{
DGSearch.SelectColumnRowCell(iRow, iColumn, true); //В sysData.
}
FindRow = true;
FindCount++;
}
//Если нашли строку:
if (FindRow)
{
var rowstr = new string[DGSearch.Columns.Count + 1];
rowstr[0] = (iRow - 1).ToString();
for (int N = 0; N < DGSearch.Columns.Count; N++)
{
rowstr[N + 1] = DGSearch.Value(iRow, N);
}
DGResult.Rows.Add(rowstr);
//Если ищем только до первой найденной строки, то выходим. Direction Search = Up.
return(true);
}
}
}
return(FindCount > 0);
}
