/// <summary>
/// 加载RawDataFrm窗体
/// </summary>
/// <param name="rawDataFrm"></param>
/// <param name="ird"></param>
/// <param name="filePath"></param>
public int LoadList(RawDataFrm rawDataFrm, ImportingRawDataBLL ird, string filePath, object objList, out string name)
{
List <SortedTargetsParas> listSbp = new List <SortedTargetsParas>();
List <RawData> rawDataList = new List <RawData>();
List <TargetEntity> targetEntityList = new List <TargetEntity>();
DataGridViewColumnEditor dgvCE = new DataGridViewColumnEditor();
name = "";
int flag = 0;
if (objList as List <TargetEntity> != null)
{
rawDataFrm.rawDataGridView.AutoGenerateColumns = true;
targetEntityList = ird.ReadTgtfromExcel(filePath);
if (targetEntityList != null)
//if(targetEntityList.Count !=0)
{
rawDataFrm.rawDataGridView.Name = "dgvTarget";
rawDataFrm.rawDataGridView.DataSource = targetEntityList;
dgvCE.ColumHeaderEdit(rawDataFrm.rawDataGridView, rawDataFrm.rawDataGridView.Name);
name = "目标区_";
flag = 1;
}
else
{
flag = 0;
}
}
return(flag);
}
/// <summary>
/// 定义的查询方法，以供窗体间委托调用
/// </summary>
/// <param name="sql"></param>
/// <param name="dgvName"></param>
private void ViewQuery(string sql, string dgvName)
{
RawDataBLL rawDataBLL = new RawDataBLL();
this.dgv_DbQuery.AutoGenerateColumns = true;
DataGridViewColumnEditor dgvCE = new DataGridViewColumnEditor();
this.dgv_DbQuery.Name = dgvName; // "dgvView";
this.dgv_DbQuery.ReadOnly = true;
if (dgvName == "dgvView")
{
this.dgv_DbQuery.ReadOnly = true;
//将List数据转变成DataTable类型
dt = DataSourceToDataTable.GetListToDataTable <AverageValuesTargetEntity>
(rawDataBLL.GetAvg_List(sql));
//this.dgv_DbQuery.DataSource = rawDataBLL.GetAvg_List(sql);
this.dgv_DbQuery.DataSource = dt;
}
if (dgvName == "dgvTarget")
{
this.dgv_DbQuery.ReadOnly = false;
dt = DataSourceToDataTable.GetListToDataTable <TargetEntity>(rawDataBLL.GetList(sql));
this.dgv_DbQuery.DataSource = dt;// rawDataBLL.GetList(sql);
}
dgvCE.ColumHeaderEdit(this.dgv_DbQuery, this.dgv_DbQuery.Name);
}
/// <summary>
/// 重载TabPageCreate方法，实现对GradingFrm窗体创建Page的功能
/// </summary>
/// <param name="pageText"></param>
/// <param name="rawdataFrm"></param>
private void TabPageCreate(string pageText, GradingFrm gradingFrm)
{
DataGridViewColumnEditor dgvCE = new DataGridViewColumnEditor();
List <AverageValuesTargetEntity> listAV_Te = new List <AverageValuesTargetEntity>();
List <AverageValuesBlockEntity> listAV_Blk = new List <AverageValuesBlockEntity>();
List <AverageValuesBasinEntity> listAV_Bsn = new List <AverageValuesBasinEntity>();
workAreaTabPageController.SelectedTabPage = workAreaTabPageController.TabPages.Add(pageText);
workAreaTabPageController.SelectedTabPage.Controls.Add(gradingFrm);
workAreaTabPageController.TabPages.Add(workAreaTabPageController.SelectedTabPage);
//设置窗体的宽度和新建Page的宽度相等
gradingFrm.Width = workAreaTabPageController.SelectedTabPage.Width; //Width;
//设置窗体的高度和新建Page的高度相等
gradingFrm.Height = workAreaTabPageController.SelectedTabPage.Height;
//gradingFrm.dgvView_Target.AutoGenerateColumns = true;
gradingFrm.dgvView_Target.DataSource = listAV_Te;
gradingFrm.dgvView_Block.DataSource = listAV_Blk;
gradingFrm.dgvView_Basin.DataSource = listAV_Bsn;
dgvCE.ColumHeaderEdit(gradingFrm.dgvView_Target, "dgvView");
dgvCE.ColumHeaderEdit(gradingFrm.dgvView_Block, "dgvView_Block");
dgvCE.ColumHeaderEdit(gradingFrm.dgvView_Basin, "dgvView_Basin");
//设置rawDataGridView的dock属性，使其填充窗体
gradingFrm.Dock = DockStyle.Fill;
}
/// <summary>
/// 重载LoadList方法
/// </summary>
/// <param name="rawDataFrm"></param>
/// <param name="sql"></param>
private void LoadList(DbDataQueryFrm dbDataQueryFrm)
{
RawDataBLL rawDataBLL = new RawDataBLL();
dbDataQueryFrm.dgv_DbQuery.AutoGenerateColumns = true;
DataGridViewColumnEditor dgvCE = new DataGridViewColumnEditor();
dbDataQueryFrm.dgv_DbQuery.Name = "dgvTarget";
dbDataQueryFrm.dgv_DbQuery.DataSource = rawDataBLL.GetList();
dgvCE.ColumHeaderEdit(dbDataQueryFrm.dgv_DbQuery, dbDataQueryFrm.dgv_DbQuery.Name);
}
/// <summary>
/// 重载LoadList方法
/// </summary>
/// <param name="rawDataFrm"></param>
private void LoadList(RawDataFrm rawDataFrm)
{
RawDataBLL rawDataBLL = new RawDataBLL();
rawDataFrm.rawDataGridView.AutoGenerateColumns = true;
DataGridViewColumnEditor dgvCE = new DataGridViewColumnEditor();
rawDataFrm.rawDataGridView.Name = "dgvTarget";
rawDataFrm.rawDataGridView.DataSource = rawDataBLL.GetList();
dgvCE.ColumHeaderEdit(rawDataFrm.rawDataGridView, rawDataFrm.rawDataGridView.Name);
}
//private void tlStripBtn_Refresh_Click(object sender, EventArgs e)
//{
// dgv_DbQuery.DataSource = dt;
// dgv_DbQuery.Refresh();
//}
//int sn;
private void tlStripBtn_BlankRowAdd_Click(object sender, EventArgs e)
{
dgv_DbQuery.AllowUserToAddRows = false;
dgv_DbQuery.ReadOnly = false;
////DataTable dt = DataSourceToDataTable.GetListToDataTable(new List<TargetEntity>());
////dgv_DbQuery.DataSource = dt;
////DataGridViewColumnEditor dgvce = new DataGridViewColumnEditor();
////dgvce.ColumHeaderEdit(dgv_DbQuery, "dgvTarget");
////dt = (DataTable)this.dgv_DbQuery.DataSource;
////DataRow dR = dt.NewRow();
////dt.Rows.Add(dR);
////dgv_DbQuery.Refresh();
DataRow dR = null;
if (dgv_DbQuery.DataSource == null)
{
//sn = 0;
//System.Diagnostics.Stopwatch watch = new System.Diagnostics.Stopwatch();
//watch.Start();
DataTable dt = DataSourceToDataTable.GetListToDataTable(new List <TargetEntity>());
//watch.Stop();
//TimeSpan ts = watch.Elapsed;
dgv_DbQuery.DataSource = dt;
DataGridViewColumnEditor dgvce = new DataGridViewColumnEditor();
//watch.Start();
dgvce.ColumHeaderEdit(dgv_DbQuery, "dgvTarget");
//watch.Stop();
//ts = watch.Elapsed;
//rowIndex = dgv_DbQuery.NewRowIndex;
//dgv_DbQuery.Rows[rowIndex].Cells[0].Value = (++sn).ToString();
dt = (DataTable)this.dgv_DbQuery.DataSource;
//DataRow dR = dt.NewRow();
dR = dt.NewRow();
dt.Rows.Add(dR);
dgv_DbQuery.Refresh();
}
else
{
dt = (DataTable)this.dgv_DbQuery.DataSource;
//DataRow dR = dt.NewRow();
dR = dt.NewRow();
// int rowscount = dt.Rows.Count;
//dR.Rows.InsertAt(row, rowscount);
dt.Rows.Add(dR);
dgv_DbQuery.Refresh();
}
}
private void TOPSISDecisionMatrixFrm_Load(object sender, EventArgs e)
{
DataGridViewColumnEditor dgvce = new DataGridViewColumnEditor();
dgvce.ColumHeaderEdit(this.dgv_DecisionMatrix, strDgvName);
if (strDgvName.Contains("dgvBlk_TDM"))
{
this.Text += "_ _有利区";
}
if (strDgvName.Contains("dgvBsn_TDM"))
{
this.Text += "_ _远景区";
}
if (strDgvName.Contains("dgvTgt_TDM"))
{
this.Text += "_ _核心区";
}
}
private void ResultSortedByTopsisFrm_Load(object sender, EventArgs e)
{
DataGridViewColumnEditor dgvce = new DataGridViewColumnEditor();
dgvce.ColumHeaderEdit(dgv_SortedByTopsis, "dgv_SortedByTopsis");
if (strName.Contains("dgvBlk_TDM"))
{
this.Text += "_ _有利区";
}
if (strName.Contains("dgvBsn_TDM"))
{
this.Text += "_ _远景区";
}
if (strName.Contains("dgvTgt_TDM"))
{
this.Text += "_ _核心区";
}
//dgv_SortedByTopsis.DataSource = DataSourceToDataTable.GetListToDataTable(lst_ISTE);
}
