private void TableModules_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e)
{
DocumentCache = null;
SheetsCache = null;
SelectionModule = null;
NeedSynchronous = false;
SelectionModuleID = GetSelectionModuleID();
if (Modules != null)
{
SelectionModule = Modules.Rows.Find(SelectionModuleID);
}
SetStatisticsTable();
}
private void Table_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e)
{
if (e.Range.RowCount == 1)
{
var row = Sheet.Rows[e.Range.Row];
var id = new Guid(row.Tag.ToString());
if (id == null)
{
return;
}
ShowLabel(id);
}
else
{
tb_process.Text = tb_reason.Text = lb_process.Text = lb_reason.Text = "";
}
}
private void Table_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e)
{
if (e.Range.Row > 0)
{
string ID = "";
var row = Sheet.Rows[e.Range.Row];
if (row == null)
{
return;
}
ID = row.Tag.ToString();
DataTable dt = CaiJiHelperClient.GetTestOverTimeByID(new Guid(ID));
if (dt != null && dt.Rows.Count > 0)
{
tb_reason.Text = (dt.Rows[0]["SGComment"] ?? "").ToString();
}
}
else
{
tb_reason.Text = "";
}
}
void FpSpread_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e)
{
if (ActiveElement != null)
{
panel1.Visible = (ActiveElement.Value is DataColumn);
//扩展属性
if (ActiveElement.ExpandOrientation.Orientation == ExpandOrientation.LeftToRight)
{
rButton_LeftToRight.Checked = true;
}
else if (ActiveElement.ExpandOrientation.Orientation == ExpandOrientation.TopToBottom)
{
rButton_TopToBottom.Checked = true;
}
else if (ActiveElement.ExpandOrientation.Orientation == ExpandOrientation.None)
{
rButton_None.Checked = true;
}
//数据列属性
if (ActiveElement.Value is DataColumn)
{
DataColumn data = ActiveElement.Value as DataColumn;
rButton_LeftToRight.Enabled = (data.DataSetting != DataSetting.Aggregation);
rButton_TopToBottom.Enabled = (data.DataSetting != DataSetting.Aggregation);
rButton_None.Enabled = (data.DataSetting != DataSetting.Aggregation);
if (data.DataSetting == DataSetting.List)
{
rButton_List.Checked = true;
}
else if (data.DataSetting == DataSetting.Group)
{
rButton_Group.Checked = true;
}
else if (data.DataSetting == DataSetting.Aggregation)
{
rButton_Aggregation.Checked = true;
cBoxAggregation.SelectedItem = data.FunctionInfo;
}
}
//左父格属性
if (ActiveElement.ExpandOrientation.isDefaultLeftParent)
{
LeftCoordControl.setValue(ValueSource.Default, "");
}
else
{
ValueSource source = (ActiveElement.ExpandOrientation.LeftParent == "" ? ValueSource.None : ValueSource.UseDefined);
Cell Cell = Report.ReportSheet.GetCellFromTag(null, ActiveElement.ExpandOrientation.LeftParent);
String cell = "";
if (Cell != null)
{
cell = Arabic_Numerals_Convert.Excel_Word_Numerals(Cell.Column.Index) + (Cell.Row.Index + 1).ToString();
}
LeftCoordControl.setValue(source, cell);
}
//上父格
if (ActiveElement.ExpandOrientation.isDefaultTopParent)
{
TopCoordControl.setValue(ValueSource.Default, "");
}
else
{
ValueSource source = (ActiveElement.ExpandOrientation.TopParent == "" ? ValueSource.None : ValueSource.UseDefined);
Cell Cell = Report.ReportSheet.GetCellFromTag(null, ActiveElement.ExpandOrientation.TopParent);
String cell = "";
if (Cell != null)
{
cell = Arabic_Numerals_Convert.Excel_Word_Numerals(Cell.Column.Index) + (Cell.Row.Index + 1).ToString();
}
TopCoordControl.setValue(source, cell);
}
}
}
private void Cells_SelectionChanged(object sender, FarPoint.Win.Spread.SelectionChangedEventArgs e)
{
}
