public Communication(DataRow DAFIFrow, DataColumnCollection DAFIFheader)
{
Name = DAFIFrow.ItemArray[DAFIFheader.IndexOf("COMM_NAME")].ToString().Trim();
Type = DAFIFrow.ItemArray[DAFIFheader.IndexOf("COMM_TYPE")].ToString().Trim();
Frequency_Pri = DAFIFrow.ItemArray[DAFIFheader.IndexOf("FREQ_1")].ToString().Trim();
Frequency_Sec = DAFIFrow.ItemArray[DAFIFheader.IndexOf("FREQ_2")].ToString().Trim();
}
/// <summary>
/// Builds the column name to index map.
/// </summary>
/// <param name="dlCols">The dl cols.</param>
/// <param name="dtCols">The dt cols.</param>
/// <param name="defs">Defs to use</param>
/// <returns></returns>
// ReSharper disable ParameterTypeCanBeEnumerable.Local
private IDictionary <int, string> BuildColumnNameToIndexMap(IEnumerable <Dev2Column> dlCols, DataColumnCollection dtCols, IList <IDev2Definition> defs)
// ReSharper restore ParameterTypeCanBeEnumerable.Local
{
Dictionary <int, string> result = new Dictionary <int, string>();
foreach (var dlC in dlCols)
{
var idx = dtCols.IndexOf(dlC.ColumnName);
if (idx != -1)
{
result.Add(idx, dlC.ColumnName);
}
}
if (result.Count == 0 && defs != null)
{
// use positional adjustment
foreach (var def in defs)
{
var idx = dtCols.IndexOf(def.Name);
if (idx != -1)
{
result.Add(idx, def.Name);
}
}
}
return(result);
}
public AuthorModel GetAuthorModelBy(DataRow dataRow, DataColumnCollection columns)
{
return(new AuthorModel
{
Id = Convert.ToInt32(dataRow[columns.IndexOf("Id")]),
FullName = Convert.ToString(dataRow[columns.IndexOf("FullName")])
});
}
public UserModel GetUserModelBy(DataRow dataRow, DataColumnCollection columns)
{
return(new UserModel
{
Id = Convert.ToInt32(dataRow[columns.IndexOf("Id")]),
Email = Convert.ToString(dataRow[columns.IndexOf("Email")])
});
}
public BookModel GetBookModelBy(DataRow dataRow, DataColumnCollection columns)
{
return(new BookModel
{
Id = Convert.ToInt32(dataRow[columns.IndexOf("Id")]),
Title = Convert.ToString(dataRow[columns.IndexOf("Title")]),
Quantity = Convert.ToInt32(dataRow[columns.IndexOf("Quantity")]),
Authors = null //new List<AuthorModel>()
});
}
private void grdData_GridRowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
FormatRowDisplay(ref row);
if (DCC.Contains("DeploymentContract_ID"))
{
row.Attributes.Add("deploymentcontract_id", row.Cells[DCC.IndexOf("DeploymentContract_ID")].Text);
}
}
public int CountSubordinates(string name, DataTable table)
{
int countWorkerDivision = 0;
int countWorkerGroup = 0;
int countSubbordinates;
string filter = string.Format("FullName='{0}'", name);
DataRow[] row = table.Select(filter);
bool supervisor = row[0].Field <Boolean>("Supervisor");
string name_unit = row[0].Field <String>("Name_Unit");
string name_subunit = row[0].Field <String>("Name_SubUnit");
DataColumnCollection columns = table.Columns;
if (!supervisor)
{
countSubbordinates = 0;
}
else
{
string filter_2 = string.Format("Name_Unit='{0}'", name_unit);
DataRow[] row1 = table.Select(filter_2);
// Eсловие начальника отдела (Saleman).
if (supervisor && String.IsNullOrEmpty(name_subunit))
{
foreach (DataRow line in row1)
{
if (line[columns.IndexOf("Name_Unit")].ToString() == name_unit)
{
countWorkerDivision = countWorkerDivision + 1;
}
}
countSubbordinates = countWorkerDivision - 1;
}
// Условие начальника группы (Manager).
else
{
foreach (DataRow line in row1)
{
if (line[columns.IndexOf("Name_Unit")].ToString() == name_unit && line[columns.IndexOf("Name_SubUnit")].ToString() == name_subunit)
{
countWorkerGroup = countWorkerGroup + 1;
}
}
countSubbordinates = countWorkerGroup - 1;
}
}
return(countSubbordinates);
}
object RowToDataPoint(DataColumnCollection columns, DataRow row)
{
try
{
var rowX = row[columns.IndexOf(Columns["X"])];
var rowY = row[columns.IndexOf(Columns["Y"])];
var x = rowX as double? ?? double.Parse(rowX.ToString());
var y = rowY as double? ?? double.Parse(rowY.ToString());
return(new DataPoint(x, y));
}
catch
{
return(null);
}
}
private void grdData_GridHeaderRowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
FormatHeaderRowDisplay(ref row);
if (this.CanEdit)
{
if (DCC.Contains("X"))
{
row.Cells[DCC.IndexOf("X")].Style["text-align"] = "center";
row.Cells[DCC.IndexOf("X")].Controls.Add(CreateImage());
}
}
}
/// <summary>
/// DataRow 转成 模型
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dr"></param>
/// <returns></returns>
public static T ToModel <T>(this DataRow dr) where T : class, new()
{
T ob = new T();
if (dr != null)
{
Type vType = typeof(T);
//创建一个属性的列表
PropertyInfo[] prlist = vType.GetProperties();
DataColumnCollection vDataCoulumns = dr.Table.Columns;
try
{
foreach (PropertyInfo vProInfo in prlist)
{
if (vDataCoulumns.IndexOf(vProInfo.Name) >= 0 && dr[vProInfo.Name] != DBNull.Value)
{
vProInfo.SetValue(ob, dr[vProInfo.Name], null);
}
}
}
catch (Exception ex)
{
}
}
return(ob);
}
public static void AddColumnAfter(this DataColumnCollection columnCollection, string afterWhichColumn, DataColumn column)
{
var columnIndex = columnCollection.IndexOf(afterWhichColumn);
columnCollection.Add(column);
columnCollection[column.ColumnName].SetOrdinal(columnIndex + 1);
}
public static void AddToRow(DataRow row, object v)
{
TypeView view = new TypeView(v);
DataColumnCollection columns = row.Table.Columns;
foreach (NamedValue value in view.Values)
{
string sName = value.Name; if (sName == "")
{
sName = "value";
}
int iCol = columns.IndexOf(sName);
if (iCol == -1)
{
Type type = typeof(string);
if (value.Value != null)
{
Type type2 = value.Value.GetType();
if (type2 == typeof(Bitmap))
{
type = type2;
}
}
DataColumn col = columns.Add(sName, type);
iCol = col.Ordinal;
}
row[iCol] = value.Value;
}
}
/// <summary>
/// Builds the column name to index map.
/// </summary>
/// <param name="dtCols">The dt cols.</param>
/// <param name="defs">Defs to use</param>
/// <returns></returns>
// ReSharper disable ParameterTypeCanBeEnumerable.Local
private IDictionary <int, string> BuildColumnNameToIndexMap(DataColumnCollection dtCols, IList <IDev2Definition> defs)
// ReSharper restore ParameterTypeCanBeEnumerable.Local
{
Dictionary <int, string> result = new Dictionary <int, string>();
if (result.Count == 0 && defs != null)
{
// use positional adjustment
foreach (var def in defs)
{
var idx = dtCols.IndexOf(def.Name);
if (idx != -1)
{
if (def.IsRecordSet && DataListUtil.IsValueRecordsetWithFields(def.RawValue))
{
result.Add(idx, DataListUtil.ExtractFieldNameFromValue(def.RawValue));
}
else
{
result.Add(idx, def.Value);
}
}
}
}
return(result);
}
// <Snippet1>
private void GetIndex(DataTable table)
{
DataColumnCollection columns = table.Columns;
if(columns.Contains("City"))
{
Console.WriteLine(columns.IndexOf("City"));
}
}
public ImportDataColumn ItemByName(string columnName)
{
if (!_columns.Contains(columnName))
{
return(null);
}
return((ImportDataColumn)_columns[_columns.IndexOf(columnName)]);
}
private void formatColumnDisplay(ref GridViewRow row)
{
for (int i = 0; i < row.Cells.Count; i++)
{
row.Cells[i].Style["text-align"] = "left";
row.Cells[i].Style["padding-left"] = "5px";
}
row.Cells[DCC.IndexOf("Count")].Style["width"] = "60px";
}
[EditorBrowsableAttribute(EditorBrowsableState.Advanced)] // MDAC 69508
static public DataColumn GetDataColumnBySchemaAction(string sourceColumn, string dataSetColumn, DataTable dataTable, Type dataType, MissingSchemaAction schemaAction)
{
if (null == dataTable)
{
throw ADP.ArgumentNull("dataTable");
}
if (ADP.IsEmpty(dataSetColumn))
{
#if DEBUG
if (AdapterSwitches.DataSchema.TraceWarning)
{
Debug.WriteLine("explicit filtering of SourceColumn \"" + sourceColumn + "\"");
}
#endif
return(null);
}
DataColumnCollection columns = dataTable.Columns;
Debug.Assert(null != columns, "GetDataColumnBySchemaAction: unexpected null DataColumnCollection");
int index = columns.IndexOf(dataSetColumn);
if ((0 <= index) && (index < columns.Count))
{
DataColumn dataColumn = columns[index];
Debug.Assert(null != dataColumn, "GetDataColumnBySchemaAction: unexpected null dataColumn");
if (!ADP.IsEmpty(dataColumn.Expression))
{
#if DEBUG
if (AdapterSwitches.DataSchema.TraceError)
{
Debug.WriteLine("schema mismatch on DataColumn \"" + dataSetColumn + "\" which is a computed column");
}
#endif
throw ADP.ColumnSchemaExpression(sourceColumn, dataSetColumn);
}
if ((null == dataType) || (dataType.IsArray == dataColumn.DataType.IsArray))
{
#if DEBUG
if (AdapterSwitches.DataSchema.TraceInfo)
{
Debug.WriteLine("schema match on DataColumn \"" + dataSetColumn + "\"");
}
#endif
return(dataColumn);
}
#if DEBUG
if (AdapterSwitches.DataSchema.TraceWarning)
{
Debug.WriteLine("schema mismatch on DataColumn \"" + dataSetColumn + "\" " + dataType.Name + " != " + dataColumn.DataType.Name);
}
#endif
throw ADP.ColumnSchemaMismatch(sourceColumn, dataType, dataColumn);
}
return(CreateDataColumnBySchemaAction(sourceColumn, dataSetColumn, dataTable, dataType, schemaAction));
}
private DataColumn CachedDataColumn(ColumnEnum column, ColumnEnum column2)
{
DataColumn dataColumn = _columnCache[(int)column];
if (null == dataColumn)
{
int index = _columns.IndexOf(s_DBCOLUMN_NAME[(int)column]);
if ((-1 == index) && (column != column2))
{
index = _columns.IndexOf(s_DBCOLUMN_NAME[(int)column2]);
}
if (-1 != index)
{
dataColumn = _columns[index];
_columnCache[(int)column] = dataColumn;
}
}
return(dataColumn);
}
/// <summary>
/// Returns column index for the given column name.
/// </summary>
/// <param name="columnName">Column Name</param>
/// <returns>Column index (zero based index, or -1 if not found con columns list)</returns>
public int GetColumnIndex(string columnName)
{
int columnIndex = -1;
if (Columns != null)
{
columnIndex = Columns.IndexOf(Columns [columnName]);
}
return(columnIndex);
}
public SqlMappingInfo(PropertyInfo prop, DataColumnCollection columns) : this(prop)
{
if (SourceColumn == MappingHelpers.DO_NOT_MAP || !columns.Contains(SourceColumn))
{
SetValue = null;
return;
}
SetValue = CreateSetter(prop);
ColumnNumber = columns.IndexOf(SourceColumn);
}
private void grdData_GridRowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
FormatRowDisplay(ref row);
if (DCC.Contains("WTS_SYSTEM_RESOURCE_ID"))
{
row.Attributes.Add("systemresource_id", row.Cells[DCC.IndexOf("WTS_SYSTEM_RESOURCE_ID")].Text);
if (this.CanEdit)
{
if (DCC.Contains("Allocation %"))
{
row.Cells[DCC.IndexOf("Allocation %")].Style["text-align"] = "center";
row.Cells[DCC.IndexOf("Allocation %")].Controls.Add(CreateTextBox(row.Cells[DCC.IndexOf("WTS_SYSTEM_RESOURCE_ID")].Text, "Allocation %", row.Cells[DCC.IndexOf("Allocation %")].Text, true));
}
}
}
}
private DataColumn CachedDataColumn(ColumnEnum column)
{
if (null == columnCache[(int)column])
{
int index = columns.IndexOf(DBCOLUMN_NAME[(int)column]);
if (-1 != index)
{
columnCache[(int)column] = columns[index];
}
}
return(columnCache[(int)column]);
}
/// <summary>
/// 将DataSet转成Model
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="dataSet"></param>
/// <returns></returns>
public static List <T> DataSetToModel <T>(DataSet dataSet) where T : class, new()
{
List <T> oblist = new List <T>(); //创建返回的集合
if ((dataSet == null) || (dataSet.Tables.Count <= 0))
{
return(oblist);
}
PropertyInfo[] prlist = (typeof(T)).GetProperties(); //创建一个属性的列表
DataColumnCollection vDataCoulumns = dataSet.Tables[0].Columns;
foreach (DataRow dr in dataSet.Tables[0].Rows)
{
T ob = new T();
try
{
foreach (PropertyInfo vProInfo in prlist)
{
if (vDataCoulumns.IndexOf(vProInfo.Name) >= 0 && dr[vProInfo.Name] != DBNull.Value)
{
if (vProInfo.PropertyType.ToString().IndexOf("System.Nullable", StringComparison.Ordinal) > -1)
{
string types =
vProInfo.PropertyType.ToString()
.Substring(
vProInfo.PropertyType.ToString().IndexOf("[", StringComparison.Ordinal) + 1);
types = types.Substring(0, types.Length - 1);
Type typeinfo = Type.GetType(types);
if (typeinfo != null)
{
vProInfo.SetValue(ob, Convert.ChangeType(dr[vProInfo.Name], typeinfo), null);
}
}
else
{
vProInfo.SetValue(ob, Convert.ChangeType(dr[vProInfo.Name], vProInfo.PropertyType), null); //类型转换
}
}
}
oblist.Add(ob);
}
catch (Exception ex)
{
Console.WriteLine("Error:DataSetToModel ,错误为：" + ex.Message);
}
}
return(oblist);
}
private static int IndexOfColumn(this DataColumnCollection cols, string columnName)
{
int index = cols.IndexOf(columnName);
if (index < 0)
{
throw new ArgumentException(string.Format("DataTable不包含列名：{0}。", columnName));
}
else
{
return(index);
}
}
void gridConcern_GridRowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
formatColumnDisplay(ref row);
var todayString = DateTime.Now.ToString("M/d/yyyy");
DateTime todayDate = DateTime.Parse(todayString);
for (int i = 0; i < row.Cells.Count; i++)
{
if (i == DCC.IndexOf("Longest # of Days Awaiting Closure"))
{
var dateString = row.Cells[DCC.IndexOf("Longest # of Days Awaiting Closure")].Text;
DateTime deployDate = DateTime.Parse(dateString);
string longestDays = ((todayDate - deployDate).TotalDays).ToString();
var test = longestDays.IndexOf(".");
longestDays = longestDays.Substring(0, longestDays.IndexOf("."));
row.Cells[DCC.IndexOf("Longest # of Days Awaiting Closure")].Text = longestDays;
}
}
}
public NavigationAid(DataRow DAFIFrow, DataColumnCollection DAFIFheader, string type)
{
Ident = DAFIFrow.ItemArray[DAFIFheader.IndexOf("NAV_IDENT")].ToString().Trim();
Name = DAFIFrow.ItemArray[DAFIFheader.IndexOf("NAME")].ToString().Trim();
Frequency = DAFIFrow.ItemArray[DAFIFheader.IndexOf("FREQ")].ToString().Trim();
Channel = DAFIFrow.ItemArray[DAFIFheader.IndexOf("CHAN")].ToString().Trim();
double lat = Convert.ToDouble(DAFIFrow.ItemArray[DAFIFheader.IndexOf("WGS_DLAT")].ToString().Trim());
double lon = Convert.ToDouble(DAFIFrow.ItemArray[DAFIFheader.IndexOf("WGS_DLONG")].ToString().Trim());
double elev = 0;
try { elev = Convert.ToDouble(DAFIFrow.ItemArray[DAFIFheader.IndexOf("ELEV")].ToString().Trim()) * .3048; } catch { }
Position = new GlobalPosition(new GlobalCoordinates(new Angle(lat), new Angle(lon)), elev);
if (type == "NAV")
{
Type = navaidType(DAFIFrow.ItemArray[DAFIFheader.IndexOf("TYPE")].ToString().Trim());
}
if (type == "ILS")
{
string compType = DAFIFrow.ItemArray[DAFIFheader.IndexOf("COMP_TYPE")].ToString().Trim();
if (compType == "Z")
{
Type = "LOC";
}
if (compType == "G")
{
Type = "GLIDE";
}
if (compType == "D")
{
Type = "DME";
}
if (compType == "O" && Frequency != "75000M")
{
Type = "NDB";
}
Runway = DAFIFrow.ItemArray[DAFIFheader.IndexOf("RWY_IDENT")].ToString().Trim();
}
}
void gridUsers_GridRowDataBound(object sender, GridViewRowEventArgs e)
{
ColumnData.SetupGridBody(e.Row);
GridViewRow row = e.Row;
formatColumnDisplay(ref row);
row.Attributes.Add("userId", row.Cells[DCC["WTS_RESOURCEID"].Ordinal].Text.Trim());
if (e.Row.Cells[DCC["Archive"].Ordinal].HasControls())
{
CheckBox vCheckBox = (CheckBox)e.Row.Cells[DCC["Archive"].Ordinal].Controls[0];
row.Attributes.Add("archived", vCheckBox.Checked.ToString());
if (vCheckBox.Checked)
{
row.CssClass += " gridArchivedRow";
row.Font.Italic = true;
if (!ShowArchived)
{
row.Style["display"] = "none";
}
}
else
{
row.CssClass = row.CssClass.Replace("gridArchivedRow", "");
row.Font.Italic = false;
}
}
else
{
row.Attributes.Add("Archived", false.ToString());
}
for (int i = 0; i < row.Cells.Count; i++)
{
row.Cells[i].VerticalAlign = VerticalAlign.Top;
}
if (string.IsNullOrWhiteSpace(row.Cells[DCC["Notes"].Ordinal].Text.Replace(" ", "")))
{
row.Cells[DCC["Notes"].Ordinal].Text = " ";
}
row.Cells[DCC["ORGANIZATION"].Ordinal].Text = row.Cells[DCC["ORGANIZATION"].Ordinal].Text.Replace('_', ' ');
if (CanEdit || CanView)
{
row.Cells[DCC.IndexOf("UserName")].Controls.Add(createEditLink(row.Cells[DCC["WTS_RESOURCEID"].Ordinal].Text, row.Cells[DCC.IndexOf("UserName")].Text));
}
formatRoles(ref row);
formatEmail(ref row);
}
private void grdData_GridRowDataBound(object sender, GridViewRowEventArgs e)
{
GridViewRow row = e.Row;
FormatRowDisplay(ref row);
if (this.Type != "AOR Alert" && DCC.Contains("AOR #"))
{
row.Cells[DCC.IndexOf("AOR #")].Style["text-align"] = "center";
if (this.CanViewAOR)
{
row.Cells[DCC.IndexOf("AOR #")].Controls.Add(CreateLink("Alert", row.Cells[DCC.IndexOf("AOR #")].Text));
}
}
}
// Вычисление надбавки менеджера за подчиненных.
public double BonusManagerSubbordinates(string name, DataTable table)
{
double bonus_s = 0;
string filter = string.Format("FullName='{0}'", name);
DataRow[] row = table.Select(filter);
bool supervisor = row[0].Field <Boolean>("Supervisor");
string name_unit = row[0].Field <String>("Name_Unit");
string name_subunit = row[0].Field <String>("Name_SubUnit");
DataColumnCollection columns = table.Columns;
string filter_2 = string.Format("Name_Unit='{0}'", name_unit);
DataRow[] row1 = table.Select(filter_2);
foreach (DataRow line in row1)
{
if (line[columns.IndexOf("Supervisor")].ToString() != "True" && line[columns.IndexOf("Name_Unit")].ToString() == name_unit && line[columns.IndexOf("Name_SubUnit")].ToString() == name_subunit)
{
bonus_s = bonus_s + BaseSalary(line[columns.IndexOf("FullName")].ToString(), table) + BonusExperience(line[columns.IndexOf("FullName")].ToString(), table);
}
;
}
return(bonus_s);
}
/// <summary>
/// 比较两个字段集合是否名称,数据类型一致
/// </summary>
/// <param name= "dcA "> </param>
/// <param name= "dcB "> </param>
/// <returns> </returns>
private bool CompareColumn(DataColumnCollection dcA, DataColumnCollection dcB)
{
if (dcA.Count != dcB.Count)
{
return(false);
}
foreach (DataColumn dc in dcA)
{
//找相同字段名称
if (dcB.IndexOf(dc.ColumnName) > -1)
{
//测试数据类型
if (dc.DataType != dcB[dcB.IndexOf(dc.ColumnName)].DataType)
{
return(false);
}
}
else
{
return(false);
}
}
return(true);
}
