public static IEnumerable <System.Data.DataColumn> AsEnumerable(this System.Data.DataColumnCollection datacolumns)
{
foreach (System.Data.DataColumn col in datacolumns)
{
yield return(col);
}
}
} //isTemplateRule(Rule r, System.Data.DataTable dataTable)
public Rule createRuleFromTemplateRow(Rule baseRule, System.Data.DataColumnCollection columns, System.Data.DataRow row, int index)
{
Rule newRule = new Rule();
newRule.Id = baseRule.Id + "_" + index;
newRule.Name = this.replaceTemplateData(baseRule.Name, columns, row);
foreach (Input i in baseRule.Inputs)
{
Input newInput = new Input();
newInput.Id = i.Id + "_" + index;
newInput.Text = this.replaceTemplateData(i.Text, columns, row);
newInput.Condition = this.replaceTemplateData(i.Condition, columns, row);
newRule.Inputs.Add(newInput);
}
foreach (Output o in baseRule.Outputs)
{
Output newOutput = new Output();
newOutput.Id = o.Id + "_" + index;
newOutput.Text = this.replaceTemplateData(o.Text, columns, row);
newOutput.Cmd = this.replaceTemplateData(o.Cmd, columns, row);
newOutput.Condition = this.replaceTemplateData(o.Condition, columns, row);
newRule.Outputs.Add(newOutput);
}
foreach (Rule child in baseRule.Children)
{
newRule.Children.Add(this.createRuleFromTemplateRow(child, columns, row, index));
}
newRule.VirtualParents = baseRule.VirtualParents;
return(newRule);
} //createRuleFromTemplateRow(Rule baseRow, DataRow row, int index)
} //createRuleFromTemplateRow(Rule baseRow, DataRow row, int index)
private string replaceTemplateData(string text, System.Data.DataColumnCollection columns, System.Data.DataRow row)
{
foreach (System.Data.DataColumn col in columns)
{
int start = text.ToLower().IndexOf("#" + col.ColumnName);
while (start != -1)
{
int end = start + col.ColumnName.Length + 1;
if (end < text.Length)
{
text = text.Substring(0, start) + row[col.ColumnName] + text.Substring(end);
}
else
{
text = text.Substring(0, start) + row[col.ColumnName];
}
if (start + 1 < text.Length)
{
start = text.ToLower().IndexOf("#" + col.ColumnName, start + 1);
}
else
{
start = -1;
}
}
}
return(text);
} //replaceTemplateData(string text, DataRow row)
/// <summary>
///
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dr"></param>
/// <param name="dcc"></param>
/// <param name="split"></param>
/// <returns></returns>
public static T GetModel <T>(this System.Data.DataRow @dr, System.Data.DataColumnCollection dcc, string split) where T : new()
{
T _newT = new T();
Type tt = _newT.GetType();
foreach (System.Data.DataColumn dc in dcc)
{
if (dr.IsNull(dc))
{
continue;
}
object value = dr[dc];
PropertyInfo pi = tt.GetProperty(String.IsNullOrEmpty(split) ? dc.ColumnName : dc.ColumnName.Replace(split, ""), BindingFlags.IgnoreCase | BindingFlags.Public | BindingFlags.Instance);
if (null == pi)
{
continue;
}
if (pi.PropertyType.IsEnum)
{
pi.SetValue(_newT, Enum.Parse(pi.PropertyType, string.Format("{0}", value)), null);
}
else
{
pi.SetValue(_newT, Convert.ChangeType(value, pi.PropertyType, null), null);
}
}
return(_newT);
}
public void Execute(string query, out Object data)
{
//execute the query and return data from it
//i.e. like a select query
SqlCommand cmd = new SqlCommand(query, _conn);
SqlDataReader rdr = cmd.ExecuteReader();
//tbd....check that rows aren't empty first
//get the column list
System.Data.DataColumnCollection cols = rdr.GetSchemaTable().Columns;
System.Data.DataTable dt = new System.Data.DataTable();
for (int i = 0; i < cols.Count; i++)
{
dt.Columns.Add(cols[i]);
}
dt.AcceptChanges();
//read the data
while (rdr.Read())
{
//who knows if this works i'm experimenting for now...
object[] values = null;
rdr.GetValues(values);
dt.Rows.Add(values);
dt.AcceptChanges();
}
rdr.Close();
data = dt;
}
/// <summary>
/// 设置导出单元列
/// </summary>
/// <param name="excelHeaderArray">DataTable列名集合</param>
/// <param name="sheet">需要设置的工作表对象</param>
public void AddTitleColum(System.Data.DataColumnCollection excelHeaderArray, Worksheet sheet)
{
for (int i = 0; i < excelHeaderArray.Count; i++)
{
sheet.Cells[0, i].Value = excelHeaderArray[i].ColumnName;
sheet.Cells[0, i].SetStyle(TitleStyle);
}
}
/// <summary>
/// Concatena los nombres de las columnas de una tabla
/// </summary>
/// <param name="listaColumnas">Lista de columnas</param>
/// <param name="separadorColumnas">Separador entre datos</param>
/// <returns>Texto concatenado</returns>
/// <creador>Jonathan Contreras</creador>
/// <fecha_creacion>23-04-2010</fecha_creacion>
private String ConcatenarLineaTxt(System.Data.DataColumnCollection listaColumnas, String separadorColumnas)
{
StringBuilder strbTexto = new StringBuilder();
for (int intIndice = 0; intIndice < listaColumnas.Count; intIndice++)
{
strbTexto.Append(ConcatenarTexto(listaColumnas[intIndice].ColumnName, separadorColumnas));
}
return(strbTexto.ToString());
}
public void FillObject(System.Data.DataRow dataRow, System.Data.DataColumnCollection columns)
{
base.FillObject(dataRow, columns);
if (dataRow["FK_DataGroup"] != DBNull.Value)
{
this.DataGroup = new DataGroup();
this.DataGroup.ID = new Guid(dataRow["FK_DataGroup"].ToString());
}
this.IsLoaded = true;
}
public void FillObject(System.Data.DataRow dataRow, System.Data.DataColumnCollection columns)
{
base.FillObject(dataRow, columns);
if (dataRow["FK_DataItem"] != DBNull.Value)
{
this.DataItem = new DataItem();
this.DataItem.ID = HJORM.DataConverter.ToGuid(dataRow["FK_DataItem"]);
}
this.IsLoaded = true;
}
public Sorters(System.Data.DataColumnCollection columns)
{
// I am choosing to start by sort columns in table order, all ascending.
// You may want to do otherwise.
this._sorters = new Sorter[columns.Count];
for (int n = 0; n < columns.Count; n++)
{
this._sorters[n] = new Sorter(columns[n].ColumnName, true);
}
}
public static object GetObject(System.Data.DataRow row, System.Data.DataColumnCollection colums, object obj, string entityName)
{
for (var i = 0; i < colums.Count; i++)
{
PropertyInfo p = obj.GetType().GetProperty(colums[i].ColumnName.ToString());
string propValue = row[colums[i].ColumnName.ToString()].ToString();
switch (p.PropertyType.Name.ToLower())
{
case "string": p.SetValue(obj, propValue, null); break;
case "nullable`1":
if (string.IsNullOrEmpty(propValue))
{
p.SetValue(obj, null, null);
break;
}
if (p.PropertyType.FullName.ToLower().Contains("system.int32"))
{
p.SetValue(obj, int.Parse(propValue), null);
}
if (p.PropertyType.FullName.ToLower().Contains("system.boolean"))
{
propValue = propValue.Trim() == "30" ? "true" : "false"; //zjc.2016.5.31 //在新增的时候值为1报错。只能录入TRUE，在修改时。TRUE值又报错。所以在新增时遇到1改为true
p.SetValue(obj, bool.Parse(propValue), null);
}
if (p.PropertyType.FullName.ToLower().Contains("system.decimal"))
{
p.SetValue(obj, decimal.Parse(propValue), null);
}
if (p.PropertyType.FullName.ToLower().Contains("system.guid"))
{
///TODO:firefox中replace(/'/g, "")未能执行成功，临时代码依靠c#解决
p.SetValue(obj, Guid.Parse(propValue.Replace("'", "")), null);
}
if (p.PropertyType.FullName.ToLower().Contains("system.datetime"))
{
p.SetValue(obj, DateTime.Parse(propValue), null);
}
break;
case "int32": p.SetValue(obj, string.IsNullOrEmpty(propValue) ? 0 : int.Parse(propValue), null); break;
case "bool": propValue = propValue.Trim() == "30" ? "true" : "false"; p.SetValue(obj, bool.Parse(propValue), null); break;
case "guid": p.SetValue(obj, string.IsNullOrEmpty(propValue) ? Guid.Empty : Guid.Parse(propValue.Replace("'", "")), null); break;
case "datetime": p.SetValue(obj, string.IsNullOrEmpty(propValue) ? DateTime.Parse("1900-01-01") : DateTime.Parse(propValue), null); break;
}
}
if (SYSHandler.ValidateFields(obj, entityName) == false)
{
throw new Exception();
}
return(obj);
}
internal string BuildViewQuery(System.Data.DataColumnCollection dataColumnCollection)
{
List <string> columns = new List <string>();
foreach (System.Data.DataColumn column in dataColumnCollection)
{
columns.Add(column.ColumnName);
}
return(BuildViewQuery(columns));
}
public static List <DBFFieldDescriptor> MakeDbfFields(System.Data.DataColumnCollection columns)
{
List <DBFFieldDescriptor> result = new List <DBFFieldDescriptor>();
foreach (System.Data.DataColumn item in columns)
{
result.Add(new DBFFieldDescriptor(item.ColumnName, 'C', 255, 0));
}
return(result);
}
/// <summary>
/// Loads the data from the source. Can be an excel address or a range.
/// </summary>
/// <param name="source"></param>
/// <param name="hasHeaders"></param>
/// <returns><see cref="Table"/></returns>
public Table From(object source, bool hasHeaders = true) {
try {
IRange range = ExcelExt.GetRange(source);
if (range.Count == 1)
range = range.CurrentRegion;
var values = (object[,])range.Value2 ?? new object[1, 1];
int clen = values.GetLength(1);
int rlen = values.GetLength(0);
_table = new System.Data.DataTable();
_columns = _table.Columns;
int irow = hasHeaders ? 2 : 1;
for (var icol = 0; icol++ < clen; ) {
Type coltype = GetColumnType(values, irow, icol);
object colvalue = hasHeaders ?
values[1, icol]
: (icol + 1);
string colname = colvalue == null ?
string.Empty
: colvalue.ToString();
_columns.Add(new System.Data.DataColumn(colname, coltype));
}
_rowsall = _table.Rows;
for (int r = hasHeaders ? 1 : 0; r++ < rlen; ) {
System.Data.DataRow row = _table.NewRow();
for (var c = 0; c < clen; c++)
row[c] = values[r, c + 1];
_rowsall.Add(row);
}
_hasheaders = hasHeaders;
_cells = (ICells)range;
return this;
} catch (SeleniumException) {
throw;
} catch (Exception ex) {
throw new SeleniumException(ex);
}
}
public void FillObject(System.Data.DataRow dataRow, System.Data.DataColumnCollection columns)
{
base.FillObject(dataRow);
if (dataRow["FK_Group"] != DBNull.Value)
{
this.DataGroup = new DataGroup();
this.DataGroup.ID = HJORM.DataConverter.ToGuid(dataRow["FK_Group"]);
}
if (dataRow["FK_Item"] != DBNull.Value)
{
this.DataItem = new DataItem();
this.DataItem.ID = HJORM.DataConverter.ToGuid(dataRow["FK_Item"]);
}
this.Type = dataRow["Type"].ToString();
this.Language = dataRow["Language"].ToString();
this.Url = dataRow["Url"].ToString();
this.IsLoaded = true;
}
private static SharpMap.Data.FeatureDataTable VehicleDataTable()
{
var dt = new SharpMap.Data.FeatureDataTable {
TableName = "VilniusTransportData"
};
System.Data.DataColumnCollection dcc = dt.Columns;
dcc.AddRange(new[]
{
new System.Data.DataColumn("Id", typeof(int)),
//new System.Data.DataColumn("Lat", typeof(double)),
//new System.Data.DataColumn("Lng", typeof(double)),
new System.Data.DataColumn("Line", typeof(string)),
new System.Data.DataColumn("LastStop", typeof(string)),
new System.Data.DataColumn("TrackType", typeof(string)),
new System.Data.DataColumn("AreaName", typeof(string)),
new System.Data.DataColumn("StreetName", typeof(string)),
new System.Data.DataColumn("Time", typeof(string)),
new System.Data.DataColumn("Bearing", typeof(double))
});
return(dt);
}
public void FillObject(System.Data.DataRow dataRow, System.Data.DataColumnCollection columns)
{
base.FillObject(dataRow);
//if (dataRow["FK_DataCollection"] != DBNull.Value)
//{
// this.DataCollection = new DataCollection();
// this.DataCollection.ID = new Guid(dataRow["FK_DataCollection"].ToString());
//}
if (dataRow["FK_DataField"] != DBNull.Value)
{
this.DataField = new DataField();
this.DataField.ID = new Guid(dataRow["FK_DataField"].ToString());
}
this.NL = dataRow["NL"].ToString();
this.EN = dataRow["EN"].ToString();
this.DE = dataRow["DE"].ToString();
this.FR = dataRow["FR"].ToString();
this.SP = dataRow["SP"].ToString();
this.IT = dataRow["IT"].ToString();
this.PL = dataRow["PL"].ToString();
this.IsLoaded = true;
}
/// <summary>
/// Carga en los controles la informacion de un registro.
/// </summary>
/// <param name="row">
/// Row con la información a cargar
/// </param>
/// <returns>El valor que se obtiene despues de ejecutar el metodo</returns>
public override bool Cargar(System.Data.DataRow row)
{
bool resultado = false;
try
{
System.Data.DataColumnCollection columns = row.Table.Columns;
if (columns.Contains("IdFacturaProducto"))
{
Id = Convert.ToInt64(row["IdFacturaProducto"]);
}
if (columns.Contains("IdFactura"))
{
FacturaId = Convert.ToInt64(row["IdFactura"]);
}
if (columns.Contains("IdProducto"))
{
ProductoId = Convert.ToInt64(row["IdProducto"]);
}
if (columns.Contains("Cantidad"))
{
Cantidad = Convert.ToDouble(row["Cantidad"]);
}
if (columns.Contains("total"))
{
Total = Convert.ToDouble(row["total"]);
}
if (columns.Contains("Precio"))
{
Precio = Convert.ToDouble(row["Precio"]);
}
if (columns.Contains("UnidadMedida"))
{
UnidadMedida = Convert.ToString(row["UnidadMedida"]);
}
if (columns.Contains("Descripcion"))
{
Descripcion = Convert.ToString(row["Descripcion"]);
}
if (columns.Contains("IVA"))
{
IVAPorcentaje = Convert.ToDouble(row["IVA"]);
}
if (columns.Contains("IEPS"))
{
IEPsPorcentaje = Convert.ToDouble(row["IEPS"]);
}
if (columns.Contains("IVAImporte"))
{
IVA = Convert.ToDouble(row["IVAImporte"]);
}
if (columns.Contains("IEPSImporte"))
{
IEPS = Convert.ToDouble(row["IEPSImporte"]);
}
resultado = true;
}
catch (Exception ex)
{
Log.Logger.Error(ex, ex.Message);
resultado = false;
}
return(resultado);
}
public void FillObject(System.Data.DataRow dataRow, System.Data.DataColumnCollection columns)
{
base.FillObject(dataRow);
this.Title = dataRow["Title"].ToString();
this.LanguageCode = dataRow["LanguageCode"].ToString();
if (dataRow["FK_DataCollection"] != DBNull.Value)
{
this.DataCollection = new DataCollection();
this.DataCollection.ID = new Guid(dataRow["FK_DataCollection"].ToString());
}
if (columns.Contains("MetaDescription"))
{
this.MetaDescription = dataRow["MetaDescription"].ToString();
}
if (columns.Contains("MetaKeywords"))
{
this.MetaKeywords = dataRow["MetaKeywords"].ToString();
}
if (columns.Contains("Text1"))
{
this.Text1 = dataRow["Text1"].ToString();
}
if (columns.Contains("Text2"))
{
this.Text2 = dataRow["Text2"].ToString();
}
if (columns.Contains("Text3"))
{
this.Text3 = dataRow["Text3"].ToString();
}
if (columns.Contains("Text4"))
{
this.Text4 = dataRow["Text4"].ToString();
}
if (columns.Contains("Text5"))
{
this.Text5 = dataRow["Text5"].ToString();
}
if (columns.Contains("Text6"))
{
this.Text6 = dataRow["Text6"].ToString();
}
if (columns.Contains("Text7"))
{
this.Text7 = dataRow["Text7"].ToString();
}
if (columns.Contains("Text8"))
{
this.Text8 = dataRow["Text8"].ToString();
}
if (columns.Contains("Text9"))
{
this.Text9 = dataRow["Text9"].ToString();
}
if (columns.Contains("Text10"))
{
this.Text10 = dataRow["Text10"].ToString();
}
if (columns.Contains("Text11"))
{
this.Text11 = dataRow["Text11"].ToString();
}
if (columns.Contains("Text12"))
{
this.Text12 = dataRow["Text12"].ToString();
}
if (columns.Contains("Text13"))
{
this.Text13 = dataRow["Text13"].ToString();
}
if (columns.Contains("Text14"))
{
this.Text14 = dataRow["Text14"].ToString();
}
if (columns.Contains("Text15"))
{
this.Text15 = dataRow["Text15"].ToString();
}
if (columns.Contains("Text16"))
{
this.Text16 = dataRow["Text16"].ToString();
}
if (columns.Contains("Text17"))
{
this.Text17 = dataRow["Text17"].ToString();
}
if (columns.Contains("Text18"))
{
this.Text18 = dataRow["Text18"].ToString();
}
if (columns.Contains("Text19"))
{
this.Text19 = dataRow["Text19"].ToString();
}
if (columns.Contains("Text20"))
{
this.Text20 = dataRow["Text20"].ToString();
}
if (columns.Contains("Text21"))
{
this.Text21 = dataRow["Text21"].ToString();
}
if (columns.Contains("Text22"))
{
this.Text22 = dataRow["Text22"].ToString();
}
if (columns.Contains("Text23"))
{
this.Text23 = dataRow["Text23"].ToString();
}
if (columns.Contains("Text24"))
{
this.Text24 = dataRow["Text24"].ToString();
}
if (columns.Contains("Text25"))
{
this.Text25 = dataRow["Text25"].ToString();
}
if (columns.Contains("Text26"))
{
this.Text26 = dataRow["Text26"].ToString();
}
if (columns.Contains("Text27"))
{
this.Text27 = dataRow["Text27"].ToString();
}
if (columns.Contains("Text28"))
{
this.Text28 = dataRow["Text28"].ToString();
}
if (columns.Contains("Text29"))
{
this.Text29 = dataRow["Text29"].ToString();
}
if (columns.Contains("Text30"))
{
this.Text30 = dataRow["Text30"].ToString();
}
if (columns.Contains("LongText1"))
{
this.LongText1 = dataRow["LongText1"].ToString();
}
if (columns.Contains("LongText2"))
{
this.LongText2 = dataRow["LongText2"].ToString();
}
if (columns.Contains("LongText3"))
{
this.LongText3 = dataRow["LongText3"].ToString();
}
if (columns.Contains("LongText4"))
{
this.LongText4 = dataRow["LongText4"].ToString();
}
if (columns.Contains("LongText5"))
{
this.LongText5 = dataRow["LongText5"].ToString();
}
if (columns.Contains("Html1"))
{
this.Html1 = dataRow["Html1"].ToString();
}
if (columns.Contains("Html2"))
{
this.Html2 = dataRow["Html2"].ToString();
}
if (columns.Contains("Html3"))
{
this.Html3 = dataRow["Html3"].ToString();
}
if (columns.Contains("Html4"))
{
this.Html4 = dataRow["Html4"].ToString();
}
if (columns.Contains("Html5"))
{
this.Html5 = dataRow["Html5"].ToString();
}
if (columns.Contains("Image1"))
{
this.Image1 = dataRow["Image1"].ToString();
}
if (columns.Contains("Image2"))
{
this.Image2 = dataRow["Image2"].ToString();
}
if (columns.Contains("Image3"))
{
this.Image3 = dataRow["Image3"].ToString();
}
if (columns.Contains("Image4"))
{
this.Image4 = dataRow["Image4"].ToString();
}
if (columns.Contains("Image5"))
{
this.Image5 = dataRow["Image5"].ToString();
}
if (columns.Contains("File1"))
{
this.File1 = dataRow["File1"].ToString();
}
if (columns.Contains("File2"))
{
this.File2 = dataRow["File2"].ToString();
}
if (columns.Contains("File3"))
{
this.File3 = dataRow["File3"].ToString();
}
if (columns.Contains("File4"))
{
this.File4 = dataRow["File4"].ToString();
}
if (columns.Contains("File5"))
{
this.File5 = dataRow["File5"].ToString();
}
}
/// <summary>
/// Generate the INSERT statement
/// </summary>
/// <param name="tablename"></param>
/// <param name="columns"></param>
/// <param name="dataRow"></param>
/// <returns></returns>
public string CreateInsertStatement(string tablename, System.Data.DataColumnCollection columns, System.Data.DataRow dataRow)
{
throw new Exception("The method or operation is not implemented.");
}
private bool SerializeDataTableData(System.Data.DataTable table)
{
var rows = table.Rows;
int count = rows.Count;
if (count == 0)
{
return(true);
}
System.Data.DataColumnCollection cols = table.Columns;
var columnType = new List <Tuple <string, ValueMemberInfo, int> >();
int columnCount = 0;
foreach (System.Data.DataColumn column in cols)
{
var valueMember = new ValueMemberInfo(column.DataType);
var columnName = BuildPropertyName(column.ColumnName, _options.TextCase, true);
columnType.Add(new Tuple <string, ValueMemberInfo, int>(columnName, valueMember, column.Ordinal));
columnCount++;
}
var tableName = table.TableName;
if (tableName.IsNullOrWhiteSpace())
{
tableName = "_empty_";
}
bool rowseparator = false;
_jsonWriter.WritePropertyName(tableName, true);
_jsonWriter.WriteStartArray();
try
{
for (var i = 0; i < count; i++)
{
System.Data.DataRow row = rows[i];
if (rowseparator)
{
_jsonWriter.WriteComma();
}
else
{
rowseparator = true;
}
_jsonWriter.WriteStartObject();
try
{
for (var c = 0; c < columnCount; c++)
{
var column = columnType[c];
//build column name
_jsonWriter.WritePropertyNameFast(column.Item1);
//build column data
var value = row[column.Item3];
if (value == null || value == DBNull.Value)
{
_jsonWriter.WriteNull();
}
else if (!WriteObjectValue(value, column.Item2))
{
return(false);
}
}
}
finally
{
_jsonWriter.WriteEndObject();
}
}
}
finally
{
_jsonWriter.WriteEndArray();
}
return(true);
}
string IDataImport.CreateInsertStatement(string tablename, System.Data.DataColumnCollection columns, System.Data.DataRow dataRow)
{
return(CreateInsertStatement(tablename, columns, dataRow));
}
internal void ValidateCollection(System.Data.SqlServerCe.SqlCeUpdatableRecord rec, System.Data.DataColumnCollection dataColumnCollection)
{
// If no user defined mappings
if (this.Count == 0)
{
}
}
public static IEnumerable <System.Data.DataColumn> AsEnumerable(this System.Data.DataColumnCollection source)
{
TypeCheckEnumerable(source, (s) => s.AsEnumerable(), (s) => s[0]);
return(source.Cast <System.Data.DataColumn>());
}
/// <summary>
/// Carga en los controles la informacion de un registro.
/// </summary>
/// <param name="row">
/// Row con la información a cargar
/// </param>
/// <returns>El valor que se obtiene despues de ejecutar el metodo</returns>
public override bool Cargar(System.Data.DataRow row)
{
bool resultado = true;
try
{
System.Data.DataColumnCollection columns = row.Table.Columns;
if (columns.Contains("IdFacturaCFDI"))
{
FacturaCFDIId = Convert.ToInt64(row["IdFacturaCFDI"]);
}
if (columns.Contains("IdFactura"))
{
FacturaId = Convert.ToInt64(row["IdFactura"]);
}
if (columns.Contains("UUID"))
{
Folio_Fiscal = Convert.ToString(row["UUID"]);
}
if (columns.Contains("PDFPath"))
{
RutaPdf = Convert.ToString(row["PDFPath"]);
}
if (columns.Contains("XMLPath"))
{
RutaXml = Convert.ToString(row["XMLPath"]);
}
if (columns.Contains("XMLString"))
{
XML = Convert.ToString(row["XMLString"]);
}
if (columns.Contains("PDFString"))
{
PDF = Convert.ToString(row["PDFString"]);
}
if (columns.Contains("ClienteId"))
{
ClienteId = Convert.ToInt64(row["ClienteId"]);
}
if (columns.Contains("ClienteNombrefiscal"))
{
ClienteNombreFiscal = Convert.ToString(row["ClienteNombrefiscal"]);
}
if (columns.Contains("ClienteCalle"))
{
ClienteCalle = Convert.ToString(row["ClienteCalle"]);
}
if (columns.Contains("ClienteNumeroExterior"))
{
ClienteNumeroExterior = Convert.ToString(row["ClienteNumeroExterior"]);
}
if (columns.Contains("ClienteNumeroInterior"))
{
ClienteNumeroInterior = Convert.ToString(row["ClienteNumeroInterior"]);
}
if (columns.Contains("ClienteColonia"))
{
ClienteColonia = Convert.ToString(row["ClienteColonia"]);
}
if (columns.Contains("ClienteCodigoPostal"))
{
ClienteCodigoPostal = Convert.ToString(row["ClienteCodigoPostal"]);
}
if (columns.Contains("ClienteCiudad"))
{
ClienteCiudad = Convert.ToString(row["ClienteCiudad"]);
}
if (columns.Contains("ClienteRFC"))
{
ClienteRFC = Convert.ToString(row["ClienteRFC"]);
}
if (columns.Contains("Email"))
{
Email = Convert.ToString(row["Email"]);
}
if (columns.Contains("Total"))
{
Total = Convert.ToDouble(row["Total"]);
}
if (columns.Contains("SubTotal"))
{
SubTotal = Convert.ToDouble(row["SubTotal"]);
}
if (columns.Contains("IVA"))
{
IvaPorcentaje = Convert.ToDouble(row["IVA"]);
}
if (columns.Contains("IEPS"))
{
IepsPorcentaje = Convert.ToDouble(row["IEPS"]);
}
if (columns.Contains("IVAImporte"))
{
IvaImporte = Convert.ToDouble(row["IVAImporte"]);
}
if (columns.Contains("IEPSImporte"))
{
IepsImporte = Convert.ToDouble(row["IEPSImporte"]);
}
if (columns.Contains("FechaTimbrado"))
{
Fecha_Timbrado = Convert.ToDateTime(row["FechaTimbrado"]);
}
}
catch (Exception ex)
{
Log.Logger.Error(ex, ex.Message);
resultado = false;
}
return(resultado);
}
public void FillObject(System.Data.DataRow dataRow, System.Data.DataColumnCollection columns)
{
base.FillObject(dataRow);
if (columns.Contains("OrderNumber"))
{
this.OrderNumber = DataConverter.ToInt32(dataRow["OrderNumber"]);
}
if (columns.Contains("Title"))
{
this.Title = dataRow["Title"].ToString();
}
if (columns.Contains("CompletePath"))
{
this.CompletePath = dataRow["CompletePath"].ToString();
}
if (columns.Contains("FK_DataCollection") && dataRow["FK_DataCollection"] != DBNull.Value)
{
this.DataCollection = new DataCollection();
this.DataCollection.ID = DataConverter.ToGuid(dataRow["FK_DataCollection"]);
}
if (columns.Contains("FK_Parent_Group") && dataRow["FK_Parent_Group"] != DBNull.Value)
{
this.ParentGroup = new DataGroup();
this.ParentGroup.ID = DataConverter.ToGuid(dataRow["FK_Parent_Group"]);
}
if (columns.Contains("MetaDescription"))
{
this.MetaDescription = dataRow["MetaDescription"].ToString();
}
if (columns.Contains("MetaKeywords"))
{
this.MetaKeywords = dataRow["MetaKeywords"].ToString();
}
if (columns.Contains("Text1"))
{
this.Text1 = dataRow["Text1"].ToString();
}
if (columns.Contains("Text2"))
{
this.Text2 = dataRow["Text2"].ToString();
}
if (columns.Contains("Text3"))
{
this.Text3 = dataRow["Text3"].ToString();
}
if (columns.Contains("Text4"))
{
this.Text4 = dataRow["Text4"].ToString();
}
if (columns.Contains("Text5"))
{
this.Text5 = dataRow["Text5"].ToString();
}
if (columns.Contains("Text6"))
{
this.Text6 = dataRow["Text6"].ToString();
}
if (columns.Contains("Text7"))
{
this.Text7 = dataRow["Text7"].ToString();
}
if (columns.Contains("Text8"))
{
this.Text8 = dataRow["Text8"].ToString();
}
if (columns.Contains("Text9"))
{
this.Text9 = dataRow["Text9"].ToString();
}
if (columns.Contains("Text10"))
{
this.Text10 = dataRow["Text10"].ToString();
}
if (columns.Contains("Text11"))
{
this.Text11 = dataRow["Text11"].ToString();
}
if (columns.Contains("Text12"))
{
this.Text12 = dataRow["Text12"].ToString();
}
if (columns.Contains("Text13"))
{
this.Text13 = dataRow["Text13"].ToString();
}
if (columns.Contains("Text14"))
{
this.Text14 = dataRow["Text14"].ToString();
}
if (columns.Contains("Text15"))
{
this.Text15 = dataRow["Text15"].ToString();
}
if (columns.Contains("Text16"))
{
this.Text16 = dataRow["Text16"].ToString();
}
if (columns.Contains("Text17"))
{
this.Text17 = dataRow["Text17"].ToString();
}
if (columns.Contains("Text18"))
{
this.Text18 = dataRow["Text18"].ToString();
}
if (columns.Contains("Text19"))
{
this.Text19 = dataRow["Text19"].ToString();
}
if (columns.Contains("Text20"))
{
this.Text20 = dataRow["Text20"].ToString();
}
if (columns.Contains("Text21"))
{
this.Text21 = dataRow["Text21"].ToString();
}
if (columns.Contains("Text22"))
{
this.Text22 = dataRow["Text22"].ToString();
}
if (columns.Contains("Text23"))
{
this.Text23 = dataRow["Text23"].ToString();
}
if (columns.Contains("Text24"))
{
this.Text24 = dataRow["Text24"].ToString();
}
if (columns.Contains("Text25"))
{
this.Text25 = dataRow["Text25"].ToString();
}
if (columns.Contains("Text26"))
{
this.Text26 = dataRow["Text26"].ToString();
}
if (columns.Contains("Text27"))
{
this.Text27 = dataRow["Text27"].ToString();
}
if (columns.Contains("Text28"))
{
this.Text28 = dataRow["Text28"].ToString();
}
if (columns.Contains("Text29"))
{
this.Text29 = dataRow["Text29"].ToString();
}
if (columns.Contains("Text30"))
{
this.Text30 = dataRow["Text30"].ToString();
}
if (columns.Contains("LongText1"))
{
this.LongText1 = dataRow["LongText1"].ToString();
}
if (columns.Contains("LongText2"))
{
this.LongText2 = dataRow["LongText2"].ToString();
}
if (columns.Contains("LongText3"))
{
this.LongText3 = dataRow["LongText3"].ToString();
}
if (columns.Contains("LongText4"))
{
this.LongText4 = dataRow["LongText4"].ToString();
}
if (columns.Contains("LongText5"))
{
this.LongText5 = dataRow["LongText5"].ToString();
}
if (columns.Contains("Html1"))
{
this.Html1 = dataRow["Html1"].ToString();
}
if (columns.Contains("Html2"))
{
this.Html2 = dataRow["Html2"].ToString();
}
if (columns.Contains("Html3"))
{
this.Html3 = dataRow["Html3"].ToString();
}
if (columns.Contains("Html4"))
{
this.Html4 = dataRow["Html4"].ToString();
}
if (columns.Contains("Html5"))
{
this.Html5 = dataRow["Html5"].ToString();
}
if (columns.Contains("Image1"))
{
this.Image1 = dataRow["Image1"].ToString();
}
if (columns.Contains("Image2"))
{
this.Image2 = dataRow["Image2"].ToString();
}
if (columns.Contains("Image3"))
{
this.Image3 = dataRow["Image3"].ToString();
}
if (columns.Contains("Image4"))
{
this.Image4 = dataRow["Image4"].ToString();
}
if (columns.Contains("Image5"))
{
this.Image5 = dataRow["Image5"].ToString();
}
if (columns.Contains("File1"))
{
this.File1 = dataRow["File1"].ToString();
}
if (columns.Contains("File2"))
{
this.File2 = dataRow["File2"].ToString();
}
if (columns.Contains("File3"))
{
this.File3 = dataRow["File3"].ToString();
}
if (columns.Contains("File4"))
{
this.File4 = dataRow["File4"].ToString();
}
if (columns.Contains("File5"))
{
this.File5 = dataRow["File5"].ToString();
}
if (columns.Contains("YesNo1"))
{
this.YesNo1 = DataConverter.ToBoolean(dataRow["YesNo1"]);
}
if (columns.Contains("YesNo2"))
{
this.YesNo2 = DataConverter.ToBoolean(dataRow["YesNo2"]);
}
if (columns.Contains("YesNo3"))
{
this.YesNo3 = DataConverter.ToBoolean(dataRow["YesNo3"]);
}
if (columns.Contains("YesNo4"))
{
this.YesNo4 = DataConverter.ToBoolean(dataRow["YesNo4"]);
}
if (columns.Contains("YesNo5"))
{
this.YesNo5 = DataConverter.ToBoolean(dataRow["YesNo5"]);
}
if (columns.Contains("Numeric1"))
{
this.Numeric1 = DataConverter.ToInt32(dataRow["Numeric1"]);
}
if (columns.Contains("Numeric2"))
{
this.Numeric2 = DataConverter.ToInt32(dataRow["Numeric2"]);
}
if (columns.Contains("Numeric3"))
{
this.Numeric3 = DataConverter.ToInt32(dataRow["Numeric3"]);
}
if (columns.Contains("Numeric4"))
{
this.Numeric4 = DataConverter.ToInt32(dataRow["Numeric4"]);
}
if (columns.Contains("Numeric5"))
{
this.Numeric5 = DataConverter.ToInt32(dataRow["Numeric5"]);
}
if (columns.Contains("Currency1"))
{
this.Currency1 = DataConverter.ToDouble(dataRow["Currency1"]);
}
if (columns.Contains("Currency2"))
{
this.Currency2 = DataConverter.ToDouble(dataRow["Currency2"]);
}
if (columns.Contains("Currency3"))
{
this.Currency3 = DataConverter.ToDouble(dataRow["Currency3"]);
}
if (columns.Contains("Currency4"))
{
this.Currency4 = DataConverter.ToDouble(dataRow["Currency4"]);
}
if (columns.Contains("Currency5"))
{
this.Currency5 = DataConverter.ToDouble(dataRow["Currency5"]);
}
if (columns.Contains("DateTime1"))
{
this.DateTime1 = DataConverter.ToDateTime(dataRow["DateTime1"]);
}
if (columns.Contains("DateTime2"))
{
this.DateTime2 = DataConverter.ToDateTime(dataRow["DateTime2"]);
}
if (columns.Contains("DateTime3"))
{
this.DateTime3 = DataConverter.ToDateTime(dataRow["DateTime3"]);
}
if (columns.Contains("DateTime4"))
{
this.DateTime4 = DataConverter.ToDateTime(dataRow["DateTime4"]);
}
if (columns.Contains("DateTime5"))
{
this.DateTime5 = DataConverter.ToDateTime(dataRow["DateTime5"]);
}
if (columns.Contains("FK_1") && dataRow["FK_1"] != DBNull.Value)
{
this.LookupValue1 = new DataLookupValue();
this.LookupValue1.ID = new Guid(dataRow["FK_1"].ToString());
}
if (columns.Contains("FK_2") && dataRow["FK_2"] != DBNull.Value)
{
this.LookupValue2 = new DataLookupValue();
this.LookupValue2.ID = new Guid(dataRow["FK_2"].ToString());
}
if (columns.Contains("FK_3") && dataRow["FK_3"] != DBNull.Value)
{
this.LookupValue3 = new DataLookupValue();
this.LookupValue3.ID = new Guid(dataRow["FK_3"].ToString());
}
if (columns.Contains("FK_4") && dataRow["FK_4"] != DBNull.Value)
{
this.LookupValue4 = new DataLookupValue();
this.LookupValue4.ID = new Guid(dataRow["FK_4"].ToString());
}
if (columns.Contains("FK_5") && dataRow["FK_5"] != DBNull.Value)
{
this.LookupValue5 = new DataLookupValue();
this.LookupValue5.ID = new Guid(dataRow["FK_5"].ToString());
}
if (columns.Contains("FK_6") && dataRow["FK_6"] != DBNull.Value)
{
this.LookupValue6 = new DataLookupValue();
this.LookupValue6.ID = new Guid(dataRow["FK_6"].ToString());
}
if (columns.Contains("FK_7") && dataRow["FK_7"] != DBNull.Value)
{
this.LookupValue7 = new DataLookupValue();
this.LookupValue7.ID = new Guid(dataRow["FK_7"].ToString());
}
if (columns.Contains("FK_8") && dataRow["FK_8"] != DBNull.Value)
{
this.LookupValue8 = new DataLookupValue();
this.LookupValue8.ID = new Guid(dataRow["FK_8"].ToString());
}
if (columns.Contains("FK_9") && dataRow["FK_9"] != DBNull.Value)
{
this.LookupValue9 = new DataLookupValue();
this.LookupValue9.ID = new Guid(dataRow["FK_9"].ToString());
}
if (columns.Contains("FK_10") && dataRow["FK_10"] != DBNull.Value)
{
this.LookupValue10 = new DataLookupValue();
this.LookupValue10.ID = new Guid(dataRow["FK_10"].ToString());
}
this.IsLoaded = true;
}
/// <summary>
/// Loads the data from the source. Can be an excel address or a range.
/// </summary>
/// <param name="source"></param>
/// <param name="hasHeaders"></param>
/// <returns><see cref="Table"/></returns>
public Table From(object source, bool hasHeaders = true)
{
try {
IRange range = ExcelExt.GetRange(source);
if (range.Count == 1)
{
IListObject listObject = range.ListObject;
if (listObject != null)
{
IExcel excel = range.Application;
range = excel[listObject.HeaderRowRange, listObject.DataBodyRange];
}
else
{
range = range.CurrentRegion;
}
}
var values = (object[, ])range.Value2 ?? new object[1, 1];
int clen = values.GetLength(1);
int rlen = values.GetLength(0);
_table = new System.Data.DataTable();
_columns = _table.Columns;
int irow = hasHeaders ? 2 : 1;
for (var icol = 0; icol++ < clen;)
{
Type coltype = GetColumnType(values, irow, icol);
object colvalue = hasHeaders ?
values[1, icol]
: (icol + 1);
string colname = colvalue == null ?
string.Empty
: colvalue.ToString();
_columns.Add(new System.Data.DataColumn(colname, coltype));
}
_rowsall = _table.Rows;
for (int r = hasHeaders ? 1 : 0; r++ < rlen;)
{
System.Data.DataRow row = _table.NewRow();
for (var c = 0; c < clen; c++)
{
row[c] = values[r, c + 1];
}
_rowsall.Add(row);
}
_hasheaders = hasHeaders;
_cells = (ICells)range;
return(this);
} catch (SeleniumException) {
throw;
} catch (Exception ex) {
throw new SeleniumException(ex);
}
}