/// <summary>load/ refresh </summary>
private void refreshdata(object sender, EventArgs e, int rowIndex = -1)
{
CTDBEntities ct = new CTDBEntities();
cscEquipment.DataSource = ct.tbEquipment.ToList <tbEquipment>();
cscEquipment.DisplayMember = "e_nameA";
cscSpecimen.DataSource = FormLogin.LoadDataA("tbSpecimen");
cscSpecimen.DisplayMember = "Abstract";
cscRef.DataSource = FormLogin.LoadDataF("tbRef");
cscRef.DisplayMember = "cite";
cscRef.SelectedIndex = 3;
FormLogin.LoadData(dataGridView1, "tbScan", "scan_id|e_id|sp_id|Abstract|scan_para_FilesNumber|UserId");
if (dataGridView1.DataSource != null)
{
if (rowIndex > 0)
{
dataGridView1.FirstDisplayedScrollingRowIndex = rowIndex;
dataGridView1.Rows[rowIndex].Selected = true;
}
}
}
/// <summary>set value for combbox </summary>
/// <param name="cb"></param>
/// <param name="text"></param>
static public void LoadControl(ComboBox cb, string table, int id)
{
CTDBEntities ct = new CTDBEntities();
if (table == "tbEquipment")
{
cb.DataSource = ct.tbEquipment.ToList <tbEquipment>();
cb.DisplayMember = "e_nameA";
}
else if (table == "tbSpecimen")
{
cb.DataSource = FormLogin.LoadDataA("tbSpecimen");
cb.DisplayMember = "Abstract";
}
else if (table == "tbRef")
{
cb.DataSource = ct.tbRef.ToList <tbRef>();
cb.DisplayMember = "cite";
setControl(cb, id);
}
}
/// <summary>load/ refresh </summary>
private void refreshdata(object sender, EventArgs e)
{
dataGridView1.DataSource = null;
mitDelete.Enabled = false;
CTDBEntities ct = new CTDBEntities();
//clScan.DataSource = ct.tbScan.ToList<tbScan>();
clScan.DataSource = FormLogin.LoadDataA("tbScan");
clScan.DisplayMember = "Abstract";
CTHelper.setControlTag(clOpenStatus, 31, 30);
CTHelper.setControlTag(clFileType, 51, 55);
CTHelper.setControlTag(clCutMethod, 37, 35);
cscRef.DataSource = FormLogin.LoadDataF("tbRef");
cscRef.DisplayMember = "cite";
cscRef.SelectedIndex = 3;
//dataGridView1.DataSource = ct.tbSlice.ToList<tbSlice>();
//dataGridView1.DataSource = FormLogin.LoadDataA("tbSlice");
FormLogin.LoadData(dataGridView1, "tbSlice", "slice_id|scan_id|slice_para_PixelSize|slice_para_CutMethod|Abstract|date_in|open_status|slice_para_SliceNumber");
}
/// <summary>获得加权数据</summary>
/// <param name="table">table name</param>
/// <returns></returns>
static public void LoadData(DataGridView dg, string table, string showcol)
{
dg.DataSource = FormLogin.LoadDataA(table);
SetColumn(dg, showcol);
}
