private static void AddNodeDataToDataTable(System.Data.DataTable dt, System.Data.DataTable datasource, DataRow node, List<string> listColID, ref int i, int j) { DataRow newRow = dt.NewRow(); DataRow[] dv = datasource.Select("ParentID='" + node["ID"] + "'"); foreach (string colID in listColID) { //分类名,第二层及以后在前面加空格 if (colID == "Title" && dv.Length>0) { newRow[colID] = " " + node[colID]; } else if (colID == "ParentID" && dv.Length>0) { newRow[colID] = j; } else { newRow[colID] = node[colID]; } } ////根分类结束后加空行 //if (node.ParentNode == null && dt.Rows.Count > 0) //{ // dt.Rows.Add(new object[] { }); //} dt.Rows.Add(newRow); j = i; i--; dv = datasource.Select("ID='" + node["ParentID"] + "'"); foreach (DataRow nd in dv) { AddNodeDataToDataTable(dt,datasource, nd, listColID, ref i, j); // i++; } }
static public bool CopyDt(System.Data.DataTable dtFrom, System.Data.DataTable dtTo, List<IntStr> lstIS ) { foreach ( DataRow drFrom in dtFrom.Rows ) { DataRow drTo = dtTo.NewRow(); bool bValid = false; foreach ( IntStr IS in lstIS ) { if ( !String.IsNullOrEmpty( IS.strVal.Trim() ) && !String.IsNullOrEmpty(drFrom[ IS.nNo ].ToString().Trim() ) ) { drTo[IS.strVal] = drFrom[IS.nNo]; bValid = true; } } if ( bValid ) dtTo.Rows.Add(drTo); } return true; }
//将内存中数据表格插入到Excel指定工作表的指定位置 为在使用模板时控制格式时使用一 public void ReadTable(System.Data.DataTable dt, string ws, int startX, int startY) { int i=0; while(true) { string DataValue = ((Range)GetSheet(ws).Cells[startX + i, 4]).Text.ToString(); if (DataValue == "") //如果电位值为空,则退出循环 break; DataRow row = dt.NewRow(); for (int j = 0; j <= dt.Columns.Count - 1; j++) { row[j] = ((Range)GetSheet(ws).Cells[startX + i, j + startY]).Text.ToString(); //GetSheet(ws).Cells[startX + i, j + startY] = dt.Rows[i][j].ToString(); } dt.Rows.Add(row); i++; } }
System.Data.DataRow CreateRow(String Text, String Value, System.Data.DataTable dt) { // Create a DataRow using the DataTable defined in the // CreateDataSource method. System.Data.DataRow dr = dt.NewRow(); // This DataRow contains the ColorTextField and ColorValueField // fields, as defined in the CreateDataSource method. Set the // fields with the appropriate value. Remember that column 0 // is defined as ColorTextField, and column 1 is defined as // ColorValueField. dr[0] = Text; dr[1] = Value; return dr; }
/// <summary> /// 분개 라인정보를 생성합니다. /// </summary> /// <param name="dt_JELines"></param> /// <param name="U_SHORTNM">ShortName</param> /// <param name="U_ACCTCD">AccountCode</param> /// <param name="U_PRCCD">ProfitCode</param> /// <param name="U_LINEMEMO">LineMemo</param> /// <param name="U_INAMT"></param> /// <param name="U_OUTAMT"></param> private void SetJournalEntries_Line(ref System.Data.DataTable dt_JELines, string U_GLACTCD, string U_SHORTNM, string U_ACCTCD, string U_PRCCD, string JEOKYO, string U_LINEMEMO, double U_INAMT, double U_OUTAMT) { string edtACCTCD = oForm.DataSources.UserDataSources.Item("edtACCTCD").Value;//출금계좌계정 string U_OCRCD1 = U_PRCCD; string U_OCRCD2 = string.Empty; string U_OCRCD3 = string.Empty; string U_OCRCD4 = string.Empty; string U_OCRCD5 = string.Empty; try { System.Data.DataRow dr_JELine = null; if (U_INAMT >0) { //차변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = U_GLACTCD; dr_JELine["ShortName"] = U_GLACTCD; dr_JELine["Debit"] = U_INAMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dr_JELine["LineMemo"] = JEOKYO; dt_JELines.Rows.Add(dr_JELine); //대변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = U_ACCTCD; dr_JELine["ShortName"] = U_SHORTNM; dr_JELine["Credit"] = U_INAMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dr_JELine["LineMemo"] = U_LINEMEMO; dt_JELines.Rows.Add(dr_JELine); } if (U_OUTAMT>0) { //대변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = U_GLACTCD; dr_JELine["ShortName"] = U_GLACTCD; dr_JELine["Credit"] = U_OUTAMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dr_JELine["LineMemo"] = JEOKYO; dt_JELines.Rows.Add(dr_JELine); //차변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = U_ACCTCD; dr_JELine["ShortName"] = U_SHORTNM; dr_JELine["Debit"] = U_OUTAMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dr_JELine["LineMemo"] = U_LINEMEMO; dt_JELines.Rows.Add(dr_JELine); } } catch (Exception) { throw; } }
protected void GenerateRow(System.Data.DataTable dt, List<string> s) { DataRow dtrow = dt.NewRow(); // Create New Row dtrow["Ref"] = s[0]; //Bind Data to Columns dtrow["Part"] = s[1]; dtrow["Description"] = s[2]; dtrow["Qty"] = s[3]; dtrow["AdditionalDetails"] = s[4]; dt.Rows.Add(dtrow); _table = dt; gvDetails.DataSource = dt; gvDetails.DataBind(); HttpContext.Current.Session["name"] = dt; }
// Name: LoadAirport - populate a dataset with retrieved data // // Description: // Perform a call to a row producing procedure to populate a data // set with results from the database. // // Inputs: // direction Sets the parameters according to direction. // area // airportDataSet // // Outputs: // airpotDataSet // // Returns: // None. // // History: // 02-Oct-2006 ([email protected]) // Created. // 13-Oct-2006 ([email protected]) // Add start row to the result set. public void LoadAirport(int direction, String area, System.Data.DataTable airportTable) { DataRow dataRow; IngresParameter country = new Ingres.Client.IngresParameter( "ap_ccode", IngresType.NChar); IngresParameter region = new Ingres.Client.IngresParameter( "ap_place", IngresType.NVarChar); region.Value = area; airportTable.Clear(); dataRow = airportTable.NewRow(); dataRow["ap_iatacode"] = rm.GetString("StartAirportCode"); ; airportTable.Rows.InsertAt(dataRow, 0); try { ingresDataAdapter3.SelectCommand.Connection.Open(); ingresDataAdapter3.SelectCommand.Prepare(); ingresDataAdapter3.SelectCommand.Parameters.Clear(); switch (direction) { case DEPART: country.Value = departing.country; departing.region = region.Value.ToString(); break; case ARRIVE: country.Value = arriving.country; arriving.region = region.Value.ToString(); break; } ingresDataAdapter3.SelectCommand.Parameters.Add(country); ingresDataAdapter3.SelectCommand.Parameters.Add(region); ingresDataAdapter3.Fill(airportTable); } finally { if (ingresDataAdapter3 != null && ingresDataAdapter3.SelectCommand != null && ingresDataAdapter3.SelectCommand.Connection != null) ingresDataAdapter3.SelectCommand.Connection.Close(); } }
private void AddNodeDataToDataTable(System.Data.DataTable dt, System.Data.DataTable datasource, DataRow node, List<string> listColID, bool bRemove) { DataRow newRow = dt.NewRow(); DataRow[] dv = datasource.Select("ID='" + node["ParentID"] + "'"); foreach (string colID in listColID) { //分类名,第二层及以后在前面加空格 if (colID == "Title" && dv.Length > 0) { newRow[colID] = " " + node[colID]; } else { newRow[colID] = node[colID]; } } if (bRemove) { if (newRow["Col1"].ToString() != "1" && newRow["BuildEd"].ToString() != "total") dt.Rows.Add(newRow); } else dt.Rows.Add(newRow); dv = datasource.Select("ParentID='" + node["ID"] + "'"); foreach (DataRow nd in dv) { AddNodeDataToDataTable(dt, datasource, nd, listColID, bRemove); } }
private static void PintarArbolPadre(CategoriaDTO obj, List<CategoriaDTO> lstCatMontos, EmpresaDTO objEmpresa, System.Data.DataTable dt) { System.Data.DataRow row = dt.NewRow(); row["Nivel"] = obj.Nivel; row["Partida de Presupuesto"] = obj.Nombre; Decimal pMonto = lstCatMontos.SingleOrDefault(x => x.IdCategoria == obj.IdCategoria).Presupuesto.GetValueOrDefault(); row["MONTO SIN IGV"] = pMonto.ToString("N2", CultureInfo.InvariantCulture); row["PRESUPUESTO SIN IGV"] = obj.Presupuesto.GetValueOrDefault().ToString("N2", CultureInfo.InvariantCulture); Decimal porcentaje = obj.Presupuesto.GetValueOrDefault() != 0 ? pMonto / obj.Presupuesto.GetValueOrDefault() : 0; row["EJECUCION DEL PRESUPUESTO"] = Math.Abs(porcentaje).ToString("P2", CultureInfo.InvariantCulture); dt.Rows.Add(row); foreach (var hijo in obj.Hijos) { PintarArbolPadre(hijo, lstCatMontos, objEmpresa, dt); } }
/// <summary> /// 파일 업로드용 DataTable에 자료 입력 /// </summary> /// <param name="LayOutDataTable"></param> /// <param name="targetDataTable"></param> /// <param name="upRowText"></param> /// <param name="dataType"></param> public void SetDataTable(System.Data.DataTable LayOutDataTable, ref System.Data.DataTable targetDataTable, string upRowText, string dataType) { if (LayOutDataTable != null) { System.Data.DataRow[] foundRows = LayOutDataTable.Select(string.Format("U_RMK1 = '{0}'", dataType)); string columnName = string.Empty; int start = -1; int len = -1; DataRow tempdr = targetDataTable.NewRow(); foreach (DataRow dr in foundRows) { columnName = dr["U_CD"].ToString(); start = int.Parse(dr["U_RMK2"].ToString()); len = int.Parse(dr["U_RMK4"].ToString()); if (upRowText.Trim().Length < start) break; //tempdr[columnName] = upRowText.Substring(start - 1, len).Trim(); tempdr[columnName] = SO_COMMON_HRD.GetWordByByte(upRowText, start - 1, len).Trim(); } targetDataTable.Rows.Add(tempdr); } }
public string ReadToDataTable(System.Data.DataTable dtExcel, string colPrefix, int startRow, string indicatorColName, string endText) { try { Dictionary<string, string> names = GetNamedRanges(); for (int row = startRow; ; row++) { string colText = GetCellValue(row, indicatorColName); if (colText == endText) break; DataRow dr = dtExcel.NewRow(); foreach (DataColumn dc in dtExcel.Columns) { string fldName = colPrefix + dc.ColumnName; fldName = fldName.ToLower(); if (names.ContainsKey(fldName)) { object v = GetCellValue(row, fldName); if (v == null || v.ToString() == "") { dr[dc.ColumnName] = DBNull.Value; } else { dr[dc.ColumnName] = GetCellValue(row, fldName); } } } dtExcel.Rows.Add(dr); } } catch (Exception ex) { return ex.Message; } return ""; }
public string ReadToDataTable(ref System.Data.DataTable dtWrksht, string wrkshtName, int maxRow, int maxCol) { try { if (!FindWorksheet(wrkshtName)) throw new Exception("Unable to find the worksheet '" + wrkshtName + "'."); if (maxRow == 0) maxRow = int.MaxValue; if (maxCol == 0) maxCol = int.MaxValue; for (int row = 1; row <= maxRow; row++) { DataRow drNew = dtWrksht.NewRow(); for (int col = 1; col <= maxCol; col++) { drNew[col - 1] = GetCellVal(row, col); } dtWrksht.Rows.Add(drNew); } } catch (Exception ex) { return ("Unable to read the Excel worksheet '" + wrkshtName + "' into a DataTable.\n\n" + ex.Message); } return ""; }
private void setgisxml(ref System.Data.DataTable dt,IGroupLayer pGroupLayer) { ICompositeLayer comLayer = pGroupLayer as ICompositeLayer; System.Data.DataRow dr; for (int i = 0; i < comLayer.Count; i++) { ILayer player = comLayer.get_Layer(i); if (player is IGroupLayer) { dr = dt.NewRow(); dr[0] = "layer"; dr[1] = player.Name; dr[2] = player.Visible.ToString(); dt.Rows.Add(dr); setgisxml(ref dt, player as IGroupLayer); } else { dr = dt.NewRow(); dr[0] = "layer"; dr[1] = player.Name; dr[2] = player.Visible.ToString(); dt.Rows.Add(dr); } } }
private static void AddRow(System.Data.DataTable DisplayedTable, String TheFirstColumn, string TheSecondColumn) { System.Data.DataRow NewRow; NewRow = DisplayedTable.NewRow(); NewRow["Параметр"] = TheFirstColumn; NewRow["Значение"] = TheSecondColumn; DisplayedTable.Rows.Add(NewRow); NewRow.Delete(); }
/// <summary> /// 从 XmlNode(树) 加载表 /// </summary> /// <param name="dt">表</param> /// <param name="Columns">需要的列名列表</param> /// <param name="xn">XmlNode</param> public static void LoadTreeXmlNode(System.Data.DataTable dt, string[] Columns, XmlNode xn) { System.Data.DataRow dr = dt.NewRow(); foreach (string ColName in Columns) { if (xn.Attributes[ColName] != null) { dr[ColName] = xn.Attributes[ColName].Value; } } dt.Rows.Add(dr); foreach (XmlNode xnc in xn.ChildNodes) { LoadTreeXmlNode(dt, Columns, xnc); } }
/// <summary> /// Add a column of values to the specified data table /// </summary> /// <param name="table">The table to add values to</param> /// <param name="columnName">The name of the column</param> /// <param name="values">The values to add to the table.</param> static public void AddColumnOfObjects(System.Data.DataTable table, string columnName, IEnumerable values) { // Make sure the table has the specified column if (!table.Columns.Contains(columnName)) { table.Columns.Add(columnName, values.GetType().GetElementType()); } if (values != null) { int row = 0; foreach (object value in values) { // Make sure we have enough rows. if (table.Rows.Count <= row) { table.Rows.Add(table.NewRow()); } // Determine if this value should be put into the table. // If the value is a double.NaN then don't put into table. // All other values do get inserted. bool insertValue = true; if (value is double && (double.IsNaN((double) value) || (double) value == MathUtilities.MissingValue)) { insertValue = false; } // Set the cell value in table. if (insertValue) { table.Rows[row][columnName] = value; } row++; } } }
/// <summary> /// 전표행의 라인정보 DataTable에 를 생성합니다. /// </summary> /// <param name="dt_JELines"></param> /// <param name="U_OCRCD1"></param> /// <param name="AccountCode"></param> /// <param name="ShortName"></param> /// <param name="Debit"></param> /// <param name="Credit"></param> /// <returns></returns> private static System.Data.DataRow SetJournalEntries_Line(ref System.Data.DataTable dt_JELines, string U_OCRCD1, string AccountCode, string ShortName, double Debit, double Credit) { System.Data.DataRow dr_JELine = null; //차변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = AccountCode; dr_JELine["ShortName"] = ShortName; dr_JELine["Debit"] = Debit; dr_JELine["Credit"] = Credit; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; return dr_JELine; }
private static void PintarAreas(AreaDTO obj, Decimal SumaTotal, System.Data.DataTable dt) { System.Data.DataRow row1 = dt.NewRow(); row1[0] = obj.Nombre; row1["Monto con IGV"] = obj.SumaClientes.ToString("N2", CultureInfo.InvariantCulture); row1["Monto sin IGV"] = obj.SumaClientes_SinIGV.ToString("N2", CultureInfo.InvariantCulture); Decimal porcentaje = SumaTotal == 0 ? 0 : obj.SumaClientes / SumaTotal; row1["Porcentaje"] = porcentaje.ToString("P2", CultureInfo.InvariantCulture); dt.Rows.Add(row1); foreach (var item in obj.lstClientes) { if (item.Monto != 0) { System.Data.DataRow row2 = dt.NewRow(); row2[1] = item.Nombre; row2["Monto con IGV"] = item.Monto.ToString("N2", CultureInfo.InvariantCulture); row2["Monto sin IGV"] = item.MontoSinIGV.ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row2); } } }
private void SetJournalEntries_Line(ref System.Data.DataTable dt_JELines,ref System.Data.DataTable dt_KIS_SD0050T_HRD, string U_ITMGRPCD, double U_AMT, double U_VAT, string U_VATCD) { string U_PUBLICA = dt_KIS_SD0050T_HRD.Rows[0]["U_PUBLICA"].ToString().Trim();//간행물 string U_OCRCD1 = dt_KIS_SD0050T_HRD.Rows[0]["U_PRCCD"].ToString().Trim();//코스트센터 : 매출부서 string U_OCRCD2 = string.Empty; string U_OCRCD3 = string.Empty; string U_OCRCD4 = string.Empty; string U_OCRCD5 = string.Empty; string U_CARDCD = dt_KIS_SD0050T_HRD.Rows[0]["U_CARDCD"].ToString().Trim();//매출처 try { //계정정의 SD_COMMON_HRD.GLAccountInfo2 oGLAccountInfo2 = SD_COMMON_HRD.GetGLAccountInfo2(U_PUBLICA); //string DebPayAcct = FN.GetRecordsetValue(string.Format("SELECT DebPayAcct FROM [OCRD] WHERE CardCode = '{0}'", U_CARDCD));//관리계정:차변(회계탭>채권계정)예) 외상매출금 string DebPayAcct = oGLAccountInfo2.U_AC03;//2014.05.08 간행물별로 채권계정으로 변경. string VATAccount = FN.GetRecordsetValue(string.Format("SELECT Account FROM [OVTG] WHERE Code = '{0}'", U_VATCD));//부가세 계정코드 가져오기 if (string.IsNullOrEmpty(oGLAccountInfo2.U_AC01)) { throw new Exception(string.Format("광고관리에 대한 GL계정이 정의되지 않았습니다. [{0}][매출계정]", U_PUBLICA)); } if (string.IsNullOrEmpty(DebPayAcct)) { throw new Exception(string.Format("광고관리에 대한 GL계정이 정의되지 않았습니다. [{0}][매출처 채권 계정]", U_PUBLICA)); } if (string.IsNullOrEmpty(VATAccount)) { throw new Exception(string.Format("부가세 코드에 대한 계정이 정의되지 않았습니다.. [{0}][부가세 계정]", U_VATCD)); } System.Data.DataRow dr_JELine = null; //차변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = oGLAccountInfo2.U_AC01; dr_JELine["ShortName"] = oGLAccountInfo2.U_AC01; dr_JELine["Credit"] = U_AMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dt_JELines.Rows.Add(dr_JELine); //차변:부가세 if (U_VATCD != "") { dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = VATAccount; dr_JELine["ShortName"] = VATAccount; dr_JELine["Credit"] = U_VAT; dr_JELine["TaxGroup"] = U_VATCD; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; #region 부가세 행 사용자정의 필드 if (FN.GetUserFieldValidation("JDT1", "CARDCD")) { dr_JELine["U_CARDCD"] = U_CARDCD; } if (FN.GetUserFieldValidation("JDT1", "CARDNM")) { dr_JELine["U_CARDNM"] = FN.GetRecordsetValue(string.Format("select CardName from ocrd where CardCode = '{0}'", U_CARDCD)); } if (FN.GetUserFieldValidation("JDT1", "SAUPNO")) { dr_JELine["U_SAUPNO"] = FN.GetRecordsetValue(string.Format("SELECT (CASE WHEN A.U_RRNYN = 'Y' THEN A.U_RRN ELSE A.VATRegNum END) AS SAUPNO FROM OCRD AS A WHERE A.CARDCODE = '{0}'", U_CARDCD)); } if (FN.GetUserFieldValidation("JDT1", "SUPAMT")) { dr_JELine["U_SUPAMT"] = U_AMT; } if (FN.GetUserFieldValidation("JDT1", "VAT")) { dr_JELine["U_VAT"] = U_VAT; } #endregion dt_JELines.Rows.Add(dr_JELine); } //대변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = DebPayAcct; dr_JELine["ShortName"] = U_CARDCD; dr_JELine["Debit"] = U_AMT + U_VAT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dt_JELines.Rows.Add(dr_JELine); } catch (Exception) { throw; } }
private static void PintarAreasIE(AreaDTO obj, System.Data.DataTable dt) { DataRow row1 = dt.NewRow(); row1[0] = obj.Nombre.ToUpper(); dt.Rows.Add(row1); DataRow row2 = dt.NewRow(); row2[1] = "VENTAS"; row2[2] = obj.Ingresos.ToString("N2", CultureInfo.InvariantCulture); row2[3] = obj.Ingresos_SinIGV.ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row2); DataRow row3 = dt.NewRow(); row3[1] = "GASTOS"; row3[2] = obj.Egresos.ToString("N2", CultureInfo.InvariantCulture); row3[3] = obj.Egresos_SinIGV.ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row3); DataRow row4 = dt.NewRow(); row4[0] = "NETO"; row4[2] = (obj.Ingresos + obj.Egresos).ToString("N2", CultureInfo.InvariantCulture); row4[3] = (obj.Ingresos_SinIGV + obj.Egresos_SinIGV).ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row4); }
private System.Data.DataTable BuildTableRows(Google.Apis.Analytics.v3.Data.GaData gaData, System.Data.DataTable table) { foreach (var ls in gaData.Rows) { System.Data.DataRow row = table.NewRow(); for(int i = 0; i < ls.Count(); i++) { row[i] = ls[i]; } table.Rows.Add(row); } return table; }
private static void PintarGestionPorMesIE(LiquidezDTO obj, System.Data.DataTable dt) { DataRow row1 = dt.NewRow(); row1[0] = obj.nombreMes; dt.Rows.Add(row1); DataRow row2 = dt.NewRow(); row2[1] = "VENTAS"; row2[2] = obj.Ingreso.ToString("N2", CultureInfo.InvariantCulture); row2[3] = obj.Ingreso_SinIGV.ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row2); DataRow row3 = dt.NewRow(); row3[1] = "GASTOS"; row3[2] = obj.Egreso.ToString("N2", CultureInfo.InvariantCulture); row3[3] = obj.Egreso_SinIGV.ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row3); DataRow row4 = dt.NewRow(); row4[1] = "NETO"; row4[2] = (obj.Ingreso + obj.Egreso).ToString("N2", CultureInfo.InvariantCulture); row4[3] = (obj.Ingreso_SinIGV + obj.Egreso_SinIGV).ToString("N2", CultureInfo.InvariantCulture); dt.Rows.Add(row4); }
private static void UpdateHpRow(System.Data.DataRow row, string symbol, ISimulateStrategy[,] strategys, System.Data.DataTable dtDest, bool updateUnComplete) { DateTime date = (DateTime)row["Date"]; if (date.DayOfWeek == DayOfWeek.Saturday || date.DayOfWeek == DayOfWeek.Sunday) return; long time = WekaUtils.GetTimeFromDate(date); //if (alreadyHps.ContainsKey(time)) // return; System.Console.WriteLine(string.Format("Now updatehp of {0}, {1}", date.ToString(Parameters.DateTimeFormat), symbol)); sbyte?[, ,] hps; long?[, ,] hpTimes; var hpRow = DbHelper.Instance.ExecuteDataRow(string.Format("SELECT * FROM {0}_HP WHERE TIME = {1}", symbol, time)); if (hpRow != null) { hps = HpData.DeserializeHp((byte[])hpRow["hp"]); hpTimes = HpData.DeserializeHpTimes((byte[])hpRow["hp_date"]); } else { hps = new sbyte?[Parameters.AllDealTypes.Length, TestParameters.CandidateParameter4Db.BatchTps.Length, TestParameters.CandidateParameter4Db.BatchSls.Length]; hpTimes = new long?[Parameters.AllDealTypes.Length, TestParameters.CandidateParameter4Db.BatchTps.Length, TestParameters.CandidateParameter4Db.BatchSls.Length]; for (int k = 0; k < Parameters.AllDealTypes.Length; ++k) { for (int i = 0; i < TestParameters.CandidateParameter4Db.BatchTps.Length; ++i) { for (int j = 0; j < TestParameters.CandidateParameter4Db.BatchSls.Length; ++j) { hps[k, i, j] = null; hpTimes[k, i, j] = null; } } } } bool[] isComplete = new bool[Parameters.AllDealTypes.Length]; for (int k = 0; k < Parameters.AllDealTypes.Length; ++k) { char dealType = Parameters.AllDealTypes[k]; isComplete[k] = true; for (int i = 0; i < TestParameters.CandidateParameter4Db.BatchTps.Length; ++i) { if (!isComplete[k]) break; for (int j = 0; j < TestParameters.CandidateParameter4Db.BatchSls.Length; ++j) { if (!isComplete[k]) break; if (hps[k, i, j].HasValue && hps[k, i, j] != -1) continue; ISimulateStrategy strategy = strategys[i, j]; DateTime? closeDate; bool? hp; if (dealType == 'B') hp = strategy.DoBuy(date, (double)row["Close"], out closeDate); else if (dealType == 'S') hp = strategy.DoSell(date, (double)row["Close"], out closeDate); else throw new ArgumentException("Invalid dealtype of " + dealType); if (hp.HasValue) { if (hp.Value) { // tp for (int jj = j; jj < TestParameters.CandidateParameter4Db.BatchSls.Length; ++jj) { hps[k, i, jj] = 1; hpTimes[k, i, jj] = WekaUtils.GetTimeFromDate(closeDate.Value); } } else { for (int ii = i; ii < TestParameters.CandidateParameter4Db.BatchTps.Length; ++ii) { hps[k, ii, j] = 0; hpTimes[k, ii, j] = WekaUtils.GetTimeFromDate(closeDate.Value); } } } else { isComplete[k] = false; //if (dealType == 'B') // hp = strategy.DoBuy(date, (double)row["Close"], out closeDate); //else if (dealType == 'S') // hp = strategy.DoSell(date, (double)row["Close"], out closeDate); //if (!updateUnComplete) //{ // lock (dtDest) // { // DbHelper.Instance.BulkCopy(dtDest, string.Format("{0}_HP", symbol)); // dtDest.Rows.Clear(); // throw new AssertException("hp should not be null"); // } //} } } } } if (hpRow != null) { System.Data.SqlClient.SqlCommand updateCmd = new SqlCommand(string.Format("UPDATE [{0}_HP] SET [hp] = @hp,[hp_date] = @hp_date,[IsComplete] = @IsComplete WHERE [Time] = @Time", symbol)); updateCmd.Parameters.AddWithValue("@hp", HpData.SerializeHp(hps)); updateCmd.Parameters.AddWithValue("@hp_date", HpData.SerializeHpTimes(hpTimes)); updateCmd.Parameters.AddWithValue("@IsComplete", WekaUtils.AndAll(isComplete)); updateCmd.Parameters.AddWithValue("@Time", time); Feng.Data.DbHelper.Instance.ExecuteNonQuery(updateCmd); } else { lock (dtDest) { if (!updateUnComplete && (!isComplete[0] || !isComplete[1])) return; System.Data.DataRow row2 = dtDest.NewRow(); row2["Time"] = row["Time"]; row2["hp"] = HpData.SerializeHp(hps); row2["hp_date"] = HpData.SerializeHpTimes(hpTimes); row2["IsComplete"] = WekaUtils.AndAll(isComplete); dtDest.Rows.Add(row2); if (dtDest.Rows.Count >= 100) { DbHelper.Instance.BulkCopy(dtDest, string.Format("{0}_HP", symbol)); dtDest.Rows.Clear(); } } } }
/// <summary> /// 분개 행을 처리하기 위한 DataTable값을 정의합니다. /// </summary> /// <param name="dt_JELines">분개 행 데이터 테이블</param> /// <param name="U_PUBLICA">간행물</param> /// <param name="U_PRCCD_Line">코스트센터:행</param> /// <param name="U_AMTBP">대행사 금액</param> /// <param name="U_VAT">대행사 부가세</param> /// <param name="U_VATCD">대행사 세금코드</param> private void SetJournalEntries_Line(ref System.Data.DataTable dt_JELines, string U_PUBLICA,string U_PRCCD_Line, double U_AMTBP, double U_VAT, string U_VATCD) { SAPbouiCOM.DBDataSource oKIS_SD0070T_HRD = oForm.DataSources.DBDataSources.Item("@KIS_SD0070T_HRD"); string U_PRCCD = oKIS_SD0070T_HRD.GetValue("U_PRCCD", 0).Trim();//코스트센터 : 담당부서(매입); string U_OCRCD1 = U_PRCCD_Line; string U_OCRCD2 = string.Empty; string U_OCRCD3 = string.Empty; string U_OCRCD4 = string.Empty; string U_OCRCD5 = string.Empty; string U_BPCD = oKIS_SD0070T_HRD.GetValue("U_BPCD", 0).Trim(); ;//대행사 string U_ACCTCD = oKIS_SD0070T_HRD.GetValue("U_ACCTCD", 0).Trim(); ;////관리계정:차변(회계탭>채권계정) try { //계정정의 SD_COMMON_HRD.GLAccountInfo2 oGLAccountInfo2 = SD_COMMON_HRD.GetGLAccountInfo2(U_PUBLICA); //string DebPayAcct = FN.GetRecordsetValue(string.Format("SELECT DebPayAcct FROM [OCRD] WHERE CardCode = '{0}'", U_BPCD));//관리계정:차변(회계탭>채권계정)예) 외상매입금 string VATAccount = FN.GetRecordsetValue(string.Format("SELECT Account FROM [OVTG] WHERE Code = '{0}'", U_VATCD));//부가세 계정코드 가져오기 if (oGLAccountInfo2.U_AC02 == "") { throw new Exception(string.Format("광고관리에 대한 대행수수료계정이 정의되지 않았습니다. [{0}][대행수수료계정]", U_PUBLICA)); } System.Data.DataRow dr_JELine = null; //차변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = oGLAccountInfo2.U_AC02; dr_JELine["ShortName"] = oGLAccountInfo2.U_AC02; dr_JELine["Debit"] = U_AMTBP; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dt_JELines.Rows.Add(dr_JELine); //차변:부가세 //2014-07-29 허향행 부가세는 문서(헤더)의 코스트센터로 처리합니다. if (U_VATCD != "") { dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = VATAccount; dr_JELine["ShortName"] = VATAccount; dr_JELine["Debit"] = U_VAT; dr_JELine["TaxGroup"] = U_VATCD; dr_JELine["CostingCode"] = U_PRCCD;// U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; #region 부가세 행 사용자정의 필드 if (FN.GetUserFieldValidation("JDT1", "CARDCD")) { dr_JELine["U_CARDCD"] = U_BPCD; } if (FN.GetUserFieldValidation("JDT1", "CARDNM")) { dr_JELine["U_CARDNM"] = FN.GetRecordsetValue(string.Format("select CardName from ocrd where CardCode = '{0}'", U_BPCD)); } if (FN.GetUserFieldValidation("JDT1", "SAUPNO")) { dr_JELine["U_SAUPNO"] = FN.GetRecordsetValue(string.Format("SELECT (CASE WHEN A.U_RRNYN = 'Y' THEN A.U_RRN ELSE A.VATRegNum END) AS SAUPNO FROM OCRD AS A WHERE A.CARDCODE = '{0}'", U_BPCD)); } if (FN.GetUserFieldValidation("JDT1", "SUPAMT")) { dr_JELine["U_SUPAMT"] = U_AMTBP; } if (FN.GetUserFieldValidation("JDT1", "VAT")) { dr_JELine["U_VAT"] = U_VAT; } #endregion dt_JELines.Rows.Add(dr_JELine); } //대변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = U_ACCTCD; dr_JELine["ShortName"] = U_BPCD; dr_JELine["Credit"] = U_AMTBP + U_VAT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dt_JELines.Rows.Add(dr_JELine); } catch (Exception) { throw; } }
// Creates an Table instance and adds its children. public static Table GenerateTable(Document doc, System.Data.DataTable datetable) { Table table = new Table(); // PageSize pagesize = doc.Body.Descendants<PageSize>().First(); PageMargin pagemargin = doc.Body.Descendants<PageMargin>().First(); // var AvailableSumWidth = (int)(pagesize.Width - pagemargin.Right - pagemargin.Left); TableBorders tborder = new Func<TableBorders>(delegate() { TableBorders tableBorders1 = new TableBorders(); TopBorder topBorder1 = new TopBorder() { Val = BorderValues.Single, Color = "auto", Size = (UInt32Value)4U, Space = (UInt32Value)0U }; LeftBorder leftBorder1 = new LeftBorder() { Val = BorderValues.Single, Color = "auto", Size = (UInt32Value)4U, Space = (UInt32Value)0U }; BottomBorder bottomBorder1 = new BottomBorder() { Val = BorderValues.Single, Color = "auto", Size = (UInt32Value)4U, Space = (UInt32Value)0U }; RightBorder rightBorder1 = new RightBorder() { Val = BorderValues.Single, Color = "auto", Size = (UInt32Value)4U, Space = (UInt32Value)0U }; InsideHorizontalBorder insideHorizontalBorder1 = new InsideHorizontalBorder() { Val = BorderValues.Single, Color = "auto", Size = (UInt32Value)4U, Space = (UInt32Value)0U }; InsideVerticalBorder insideVerticalBorder1 = new InsideVerticalBorder() { Val = BorderValues.Single, Color = "auto", Size = (UInt32Value)4U, Space = (UInt32Value)0U }; tableBorders1.Append(topBorder1); tableBorders1.Append(leftBorder1); tableBorders1.Append(bottomBorder1); tableBorders1.Append(rightBorder1); tableBorders1.Append(insideHorizontalBorder1); tableBorders1.Append(insideVerticalBorder1); return tableBorders1; })(); table.AppendChild<TableProperties>(new TableProperties( new TableStyle() { Val = "a7" }, tborder, new TableWidth() { Width = "0", Type = TableWidthUnitValues.Auto }, new TableLook() { Val = "04A0", FirstRow = true, LastRow = false, FirstColumn = true, LastColumn = false, NoHorizontalBand = false, NoVerticalBand = true } )); int sumColumn = datetable.Columns.Count; int averwidth = AvailableSumWidth / sumColumn; Double set_colSumW = 0; int remainSumW = 0; foreach (System.Data.DataColumn item in datetable.Columns) { Object col_w = item.ExtendedProperties["width"]; if (col_w != null) { set_colSumW += Convert.ToDouble(col_w); remainSumW += averwidth; } } foreach (System.Data.DataColumn item in datetable.Columns) { Object col_w = item.ExtendedProperties["width"]; if (col_w != null) item.ExtendedProperties.Add("WordWidth", Math.Floor((remainSumW * Convert.ToDouble(col_w) / set_colSumW))); else item.ExtendedProperties.Add("WordWidth", averwidth); } for (int i = 0; i < sumColumn; i++) { int col_w = Convert.ToInt32(datetable.Columns[i].ExtendedProperties["WordWidth"]); table.AppendChild<GridColumn>(new GridColumn() { Width = col_w.ToString() }); } List<System.Data.DataRow> lstCol = new List<System.Data.DataRow>(); System.Data.DataRow dr = datetable.NewRow(); List<object> lstObj = new List<object>(); foreach (System.Data.DataColumn item in datetable.Columns) { lstObj.Add(item.ColumnName); } dr.ItemArray = lstObj.ToArray(); datetable.Rows.InsertAt(dr, 0); foreach (System.Data.DataRow item in datetable.Rows) { TableRow tableRow = new TableRow() { RsidTableRowAddition = "00D24D12", RsidTableRowProperties = "00D24D12" }; for (int i = 0; i < sumColumn; i++) { int col_w = Convert.ToInt32(datetable.Columns[i].ExtendedProperties["WordWidth"]); string cellValue = item[i].ToString(); TableCell tableCell1 = new TableCell(); TableCellProperties tableCellProperties1 = new TableCellProperties(); TableCellWidth tableCellWidth1 = new TableCellWidth() { Width = col_w.ToString(), Type = TableWidthUnitValues.Dxa }; tableCellProperties1.Append(tableCellWidth1); Paragraph paragraph1 = new Paragraph() { RsidParagraphAddition = "00D24D12", RsidParagraphProperties = "003246FB", RsidRunAdditionDefault = "00D24D12" }; Run run1 = new Run(); RunProperties runProperties1 = new RunProperties(); RunFonts runFonts1 = new RunFonts() { Hint = FontTypeHintValues.EastAsia }; runProperties1.Append(runFonts1); Text text1 = new Text(); text1.Text = cellValue; run1.Append(runProperties1); run1.Append(text1); BookmarkStart bookmarkStart1 = new BookmarkStart(); BookmarkEnd bookmarkEnd1 = new BookmarkEnd(); paragraph1.Append(run1); paragraph1.Append(bookmarkStart1); paragraph1.Append(bookmarkEnd1); tableCell1.Append(tableCellProperties1); tableCell1.Append(paragraph1); tableRow.Append(tableCell1); } table.Append(tableRow); } return table; }
public bool WriteExcelDateDatabase(ref System.Data.DataTable dt) { bool IsSuccess = false; Excel.Application exapp = new Excel.Application(); ; //'定义excel应用程序 Excel.Workbook exbook = null;// '定义工作簿 Excel.Worksheet exsheet2 = null;// 数据工作簿 Excel.Worksheet exsheet1 = null;//指导工作 System.Array w_ArrayData = null;//需要导出的数组 int w_ExcelMaxRow = 0;//excel最大行 int w_ExcelMaxCol = 0;//excel最大列 ////区域信息 //Object oBooks = exapp.Workbooks; //System.Globalization.CultureInfo ci = new System.Globalization.CultureInfo("ja-JP"); //oBooks.GetType().InvokeMember("Add", System.Reflection.BindingFlags.InvokeMethod, null, oBooks, null, ci); try { exapp.Visible = false; exapp.UserControl = true; //打开excel exbook = exapp.Workbooks.Open(FileName, Missing, Missing, Missing, Missing, Missing, Missing , Missing, Missing, Missing, Missing, Missing, Missing, Missing, Missing); //从excel中获取sheet数据 foreach (Excel.Worksheet item in exbook.Worksheets) { if (item.Name == Sheet2Name) { if (exsheet2 == null) exsheet2 = item; } //else if (item.Name == Sheet1Name) //{ // if (exsheet1 == null) // exsheet1 = item; //} //if (exsheet1 != null && exsheet2 != null) // break; if (exsheet2 != null) break; } //读取使用的最大的行数/列 w_ExcelMaxRow = exsheet2.UsedRange.Rows.Count; w_ExcelMaxCol = exsheet2.UsedRange.Columns.Count; w_ArrayData = (System.Array)exsheet2.get_Range(exsheet2.Cells[StartRowIndex, 1], exsheet2.Cells[w_ExcelMaxRow, w_ExcelMaxCol]).Value2; //for (int i = 0; i < w_ArrayData.Length; i++) //{ // string tt = w_ArrayData.GetValue(0, 2); //} DataRow dr; for (int i = 0; i < w_ExcelMaxRow - StartRowIndex + 1; i++) { dr = dt.NewRow(); for (int j = 0; j < dt.Columns.Count; j++) { dr[j] = w_ArrayData.GetValue(i + 1, j + 1); } dt.Rows.Add(dr); } dt.AcceptChanges(); //退出excel exbook.Close(false, Missing, Missing); IsSuccess = true; } catch (Exception ex) { throw ex; } finally { exbook = null; exapp.Quit(); exapp = null; GC.Collect(); } return IsSuccess; }
/// <summary> /// copies the economies data from a "EDStation"-object to "tbStationEconomy"-table /// </summary> /// <param name="StationObject"></param> /// <param name="EconomyRow"></param> /// <param name=""></param> private void CopyEDStationEconomiesToDataRows(EDStation StationObject, System.Data.DataTable EconomyTable) { try { // get all existing economies from the database (memory list) List<DataRow> Existing = EconomyTable.Select("station_id = " + StationObject.Id).ToList(); foreach (String Economy in StationObject.Economies) { // get the current new economy id Int32 EconomyID = (Int32)DBConvert.From(BaseTableNameToID("economy", Economy)); // and check, if it is already existing var Found = from DataRow relevantEconomy in Existing where relevantEconomy.Field<Int32>("economy_id") == EconomyID select relevantEconomy; // if it's not existing, insert it if(Found.Count() == 0) { DataRow newRow = EconomyTable.NewRow(); newRow["station_id"] = StationObject.Id; newRow["economy_id"] = EconomyID; EconomyTable.Rows.Add(newRow); } else { Existing.Remove(Found.First()); } } // remove all old, not more existing data foreach (DataRow RemovedRow in Existing) EconomyTable.Rows.Remove(RemovedRow); } catch (Exception ex) { throw new Exception("Error while copying station economy data", ex); } }
private void SetJournalEntries_Line_TR00411(ref System.Data.DataTable dt_JELines, string U_CARDCD, string U_ACCTCD, double U_AMT) { string edtACCTCD = oForm.DataSources.UserDataSources.Item("edtACCTCD").Value;//출금계좌계정 string edtPRCCD = oForm.DataSources.UserDataSources.Item("edtPRCCD").Value;//코스트센터 string U_OCRCD1 = edtPRCCD; string U_OCRCD2 = string.Empty; string U_OCRCD3 = string.Empty; string U_OCRCD4 = string.Empty; string U_OCRCD5 = string.Empty; try { System.Data.DataRow dr_JELine = null; //차변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = U_ACCTCD; dr_JELine["ShortName"] = U_ACCTCD; dr_JELine["Debit"] = U_AMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dt_JELines.Rows.Add(dr_JELine); //대변 dr_JELine = dt_JELines.NewRow(); dr_JELine["AccountCode"] = edtACCTCD; dr_JELine["ShortName"] = edtACCTCD; dr_JELine["Credit"] = U_AMT; dr_JELine["CostingCode"] = U_OCRCD1; //dr_JELine["CostingCode2"] = U_OCRCD2; //dr_JELine["CostingCode3"] = U_OCRCD3; //dr_JELine["CostingCode4"] = U_OCRCD4; //dr_JELine["CostingCode5"] = U_OCRCD5; dt_JELines.Rows.Add(dr_JELine); } catch (Exception) { throw; } }
private System.Data.DataTable BuildTableRows(Google.Apis.Analytics.v3.Data.GaData gaData, System.Data.DataTable table) { if (gaData.Rows == null) return table; foreach (var ls in gaData.Rows) { System.Data.DataRow row = table.NewRow(); for(int i = 0; i < ls.Count(); i++) { if (table.Columns[i].DataType == typeof(DateTime)) { row[i] = DateTime.ParseExact(ls[i], "yyyyMMdd", CultureInfo.InvariantCulture); } else { row[i] = ls[i]; } } table.Rows.Add(row); } return table; }
/// <summary> /// Build a DataTable for the form's datagrid from the /// existing TableMappings. /// </summary> /// <param name="dt">2-column DataTable to hold the names.</param> /// <param name="mapList">TableMapping collection usually /// from the DataAdapter.</param> /// <returns></returns> private bool BuildMapFromExistingMap( System.Data.DataTable dt, DataTableMappingCollection mapList) { DataTableMapping map = mapList[0]; string sourceTable = map.SourceTable; string datasetTable= map.DataSetTable; comboBoxSourceTable.Text = sourceTable; textBoxDatasetTable.Text = datasetTable; // copy the column mappings to the 2-column DataTable // that will be the DataSource for the datagrid foreach (DataColumnMapping colMap in map.ColumnMappings) { System.Data.DataRow datarow = dt.NewRow(); datarow[ TableMappings.SOURCE_COLUMNS ] = colMap.SourceColumn; datarow[ TableMappings.DATASET_COLUMNS ] = colMap.DataSetColumn; dt.Rows.Add( datarow ); } return true; }