private void ObtenerPago(Janus.Windows.GridEX.GridEX grilla) { if (grilla.SelectedItems.Count > 0) { ItemCuentaCorriente icc = (ItemCuentaCorriente)grilla.GetRow().DataRow; icc.Pago = Math.Abs(icc.Saldo); grilla.Refetch(); } }
private void ObtenerPago(Janus.Windows.GridEX.GridEX grilla) { //if (grilla.CurrentColumn.Key.Equals("Saldo")) //{ DetalleCuentaCorriente dcc = (DetalleCuentaCorriente)grilla.GetRow().DataRow; dcc.Pago = Math.Abs(dcc.Saldo); grilla.Refetch(); //} }
private void gridVariablesUsuario_DoubleClick(object sender, EventArgs e) { if (gridVariablesUsuario.SelectedItems.Count > 0 && gridVariablesUsuario.SelectedItems[0].GetRow().RowType.Equals(Janus.Windows.GridEX.RowType.Record)) { VariableAuxiliar var = (VariableAuxiliar)gridVariablesUsuario.GetRow().DataRow; FrmInputType frmInputType = new FrmInputType(var.Descripcion, var, "Valor", var.DataType, typeof(mz.erp.businessrules.comprobantes.VariableAuxiliar)); frmInputType.ShowDialog(); gridVariablesUsuario.SetDataBinding(null, null); gridVariablesUsuario.SetDataBinding(_uiController.VariablesDeUsuario, null); } }
/* * private void gridEX1_CellUpdated(object sender, Janus.Windows.GridEX.ColumnActionEventArgs e) * { * gridEX1.Refresh(); * } */ private void gridEX1_SelectionChanged(object sender, EventArgs e) { bool ok = false; if (gridEX1.SelectedItems.Count > 0 && gridEX1.SelectedItems[0].RowType.Equals(Janus.Windows.GridEX.RowType.Record)) { gridEXValores.Refetch(); object selected = gridEX1.SelectedItems[0].GetRow().DataRow; ArrayList valores = _uiController.GetValores(selected); foreach (object valor in valores) { Janus.Windows.GridEX.GridEXRow row = gridEXValores.GetRow(valor); if (row != null) { Janus.Windows.GridEX.GridEXFormatStyle rowStyle = new Janus.Windows.GridEX.GridEXFormatStyle(); rowStyle.BackColor = System.Drawing.Color.Red; row.RowStyle = rowStyle; } } } }
/// <summary> /// Hedh ne file-in Excel te dhenat e grides pa ndonje kategorizim te vecante /// </summary> /// <param name="file"></param> /// <param name="grid"></param> /// <param name="fushat"></param> /// <param name="key"></param> /// <param name="llojet"></param> /// <param name="id"></param> public void ShkruajGride(string file, Janus.Windows.GridEX.GridEX grid, string[] fushat, string[] key, string[] llojet, string id) { try { connString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + excelPath + "\\" + file + @";Extended Properties=""Excel 8.0;HDR=YES"""; conn.ConnectionString = connString; conn.Open(); cmd.Connection = conn; for (int i = 0; i < grid.RowCount; i++) { bool total = false; if (grid.GetRow(i).Cells[id].Text == "") { //nqs eshte rresthi total ath shkruaje ne excel if (grid.TotalRow == Janus.Windows.GridEX.InheritableBoolean.True && i == grid.RowCount - 1) { total = true; } else { continue; } } string str = "INSERT INTO [" + file.Remove(file.Length - 4) + "$] ("; for (int j = 0; j < fushat.Length; j++) { str += fushat[j] + ","; } str = str.Remove(str.Length - 1); str += ") VALUES ( "; for (int j = 0; j < fushat.Length; j++) { if (grid.GetRow(i).Cells[id].Text == "" && total == true && j == 0) { str += "'TOTAL',"; continue; } else if (llojet[j] == "char(255)") { str += "'" + grid.GetRow(i).Cells[key[j]].Text.Replace("'", "`") + "',"; } else if (llojet[j] == "float") { if (grid.GetRow(i).Cells[key[j]].Value == null) { str += "0,"; } else { str += grid.GetRow(i).Cells[key[j]].Value.ToString() + ","; } } else { str += grid.GetRow(i).Cells[key[j]].Text + ","; } } str = str.Remove(str.Length - 1); str += ")"; cmd.CommandText = str; cmd.ExecuteNonQuery(); gabim = 0; } } catch (Exception ex) { MessageBox.Show("Ndodhi një gabim gjatë konvertimit në Excel!" + Environment.NewLine + "Nqs keni të hapur ndonjë skedar Excel me emër " + file + Environment.NewLine + "mbylleni dhe riprovoni të bëni konvertimin në Excel.", "Konvertimi në Excel", MessageBoxButtons.OK, MessageBoxIcon.Error); gabim = 1; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } }
//public void ShkruajGrideKategori(string file, Janus.Windows.GridEX.GridEX grid, // string[] fushat, string[] key, string[] llojet, string id, string colKategori) //{ // try // { // connString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + // @"Data Source=" + excelPath + "\\" + file + // @";Extended Properties=""Excel 8.0;HDR=YES"""; // conn.ConnectionString = connString; // conn.Open(); // cmd.Connection = conn; // for (int i = 0; i < grid.RowCount; i++) // { // string str = ""; // //nqs eshte rresht kategorizimi // if (grid.GetRow(i).Cells[id].Text == "") // { // if (colKategori == "TAVOLINA") // { // str = "INSERT INTO [" + file.Remove(file.Length - 4) + "$] ("; // if (grid.GetRow(i).GroupCaption != null) // str += fushat[0] + ") VALUES ('" + grid.GetRow(i).GroupCaption.Replace("'", "`") + "')"; // else // { // str += fushat[0] + ",Vlera) VALUES ('TOTAL', " + grid.GetRow(i).Cells["VLERA"].Value + ")"; // } // } // else //if (colKategori == "EMRI") // { // str = "INSERT INTO [" + file.Remove(file.Length - 4) + "$] ("; // if (grid.GetRow(i).GroupCaption != null) // str += fushat[0] + ") VALUES ('" + grid.GetRow(i).GroupCaption.Replace("'", "`") + "')"; // else // { // if (grid.Name == "gridBlerjet") // str += fushat[0] + ",Vlera_e_blerjes, Skonto, Blerja_në_total, Paguar, Detyrimi_ndaj_furnitorit) VALUES ('TOTAL' " // + ", " + grid.GetRow(i).Cells["VLERA"].Value + "," + grid.GetRow(i).Cells["SKONTO"].Value + "," + grid.GetRow(i).Cells["TOTAL"].Value + "," + grid.GetRow(i).Cells["PAGUAR"].Value + // ", " + grid.GetRow(i).Cells["DETYRIMI"].Value + ")"; // else if (grid.Name == "gridShitjet") // str += fushat[0] + ",Vlera_e_shitjes, Skonto, Shitja_në_total, Paguar, Detyrimi_i_klientit) VALUES ('TOTAL' " // + ", " + grid.GetRow(i).Cells["VLERA"].Value + "," + grid.GetRow(i).Cells["SKONTO"].Value + "," + grid.GetRow(i).Cells["TOTAL"].Value + "," + grid.GetRow(i).Cells["PAGUAR"].Value + // ", " + grid.GetRow(i).Cells["DETYRIMI"].Value + ")"; // } // } // } // //nqs eshte rresht element // else // { // str = "INSERT INTO [" + file.Remove(file.Length - 4) + "$] ("; // for (int j = 0; j < fushat.Length; j++) // str += fushat[j] + ","; // str = str.Remove(str.Length - 1); // str += ") VALUES ( "; // for (int j = 0; j < fushat.Length; j++) // { // if (llojet[j] == "char(255)") // str += "'" + grid.GetRow(i).Cells[key[j]].Text.Replace("'", "`") + "',"; // else if (llojet[j] == "float") // { // if (grid.GetRow(i).Cells[key[j]].Text != "") // str += grid.GetRow(i).Cells[key[j]].Value.ToString() + ","; // else // str += "0" + ","; // } // else // str += grid.GetRow(i).Cells[key[j]].Text + ","; // } // str = str.Remove(str.Length - 1); // str += ")"; // } // cmd.CommandText = str; // cmd.ExecuteNonQuery(); // gabim = 0; // } // } // catch (Exception ex) // { // MessageBox.Show("Ndodhi një gabim gjatë konvertimit në Excel!" // + Environment.NewLine + "Nqs keni të hapur ndonjë skedar Excel me emër " + file + // Environment.NewLine + "mbylleni dhe riprovoni të bëni konvertimin në Excel.", "Konvertimi në Excel", MessageBoxButtons.OK, MessageBoxIcon.Error); // gabim = 1; // } // finally // { // if (conn.State == System.Data.ConnectionState.Open) // conn.Close(); // } //} public void ShkruajGrideKategori(string file, Janus.Windows.GridEX.GridEX grid, string[] fushat, string[] key, string[] llojet, string id) { try { connString = @"Provider=Microsoft.Jet.OLEDB.4.0;" + @"Data Source=" + excelPath + "\\" + file + @";Extended Properties=""Excel 8.0;HDR=YES"""; conn.ConnectionString = connString; conn.Open(); cmd.Connection = conn; for (int i = 0; i < grid.RowCount; i++) { string str = ""; str = "INSERT INTO [" + file.Remove(file.Length - 4) + "$] ("; if (grid.GetRow(i).RowType == Janus.Windows.GridEX.RowType.GroupHeader) { str += grid.RootTable.Columns[id].Caption.Replace(" ", "_") + ")"; str += " VALUES ('" + grid.GetRow(i).Group.Column.Caption + ":" + grid.GetRow(i).GroupCaption + "')"; } else if (grid.GetRow(i).RowType == Janus.Windows.GridEX.RowType.TotalRow || grid.GetRow(i).RowType == Janus.Windows.GridEX.RowType.GroupFooter) { for (int j = 0; j < key.Length; j++) { //if (key[j] == colKategori) // continue; str += fushat[j] + ","; } str = str.Substring(0, str.Length - 1); str += ") VALUES ('TOTAL',"; for (int j = 0; j < key.Length; j++) { if (j == 0) { continue; } if (llojet[j] == "char(255)") { str += "'" + grid.GetRow(i).Cells[key[j]].Text.Replace("'", "`") + "',"; } else if (llojet[j] == "float") { if (grid.GetRow(i).Cells[key[j]].Value == null) { str += "null,"; } else { str += grid.GetRow(i).Cells[key[j]].Value.ToString() + ","; } } else { str += grid.GetRow(i).Cells[key[j]].Text + ","; } } str = str.Remove(str.Length - 1); str += ")"; } else { for (int j = 0; j < key.Length; j++) { //if (key[j] == colKategori) // continue; str += fushat[j] + ","; } str = str.Substring(0, str.Length - 1); str += ") VALUES ("; for (int j = 0; j < key.Length; j++) { //if (key[j] == colKategori) // continue; if (llojet[j] == "char(255)") { str += "'" + grid.GetRow(i).Cells[key[j]].Text.Replace("'", "`") + "',"; } else if (llojet[j] == "float") { str += grid.GetRow(i).Cells[key[j]].Value.ToString() + ","; } else { str += grid.GetRow(i).Cells[key[j]].Text + ","; } } str = str.Remove(str.Length - 1); str += ")"; } cmd.CommandText = str; cmd.ExecuteNonQuery(); } } catch (Exception ex) { MessageBox.Show("Ndodhi një gabim gjatë konvertimit në Excel!" + Environment.NewLine + "Nqs keni të hapur ndonjë skedar Excel me emër " + file + Environment.NewLine + "mbylleni dhe riprovoni të bëni konvertimin në Excel.", "Konvertimi në Excel", MessageBoxButtons.OK, MessageBoxIcon.Error); gabim = 1; } finally { if (conn.State == System.Data.ConnectionState.Open) { conn.Close(); } } }