/// <summary>
/// Used to skip DashboardItemClick processing if the Expand/Collapse button is pressed
/// </summary>
void OnPivotGridControlMouseDown(object sender, MouseEventArgs e)
{
PivotGridControl pivot = sender as PivotGridControl;
PivotGridHitInfo hi = pivot.CalcHitInfo(e.Location);
skipFiltering = (hi.ValueInfo != null && hi.ValueInfo.ValueHitTest == PivotGridValueHitTest.ExpandButton);
}
private void targetPivot_MouseMove(object sender, MouseEventArgs e)
{
if (!onDrag)
{
if (e.Button == System.Windows.Forms.MouseButtons.Left)
{
PivotGridHitInfo hi = targetPivot.CalcHitInfo(e.Location);
if (hi.HitTest == PivotGridHitTest.Value)
{
if ((AllowDragRow && hi.ValueInfo.Field.Area == PivotArea.RowArea) || (AllowDragColumn && hi.ValueInfo.Field.Area == PivotArea.ColumnArea))
{
dragInfo = hi;
onDrag = true;
targetPivot.FindForm().Cursor = Cursors.Hand;
}
}
}
}
else
{
DragDropEffects allowedEffect = GetDragEffect(e.Location);
if (allowedEffect == DragDropEffects.None)
{
targetPivot.FindForm().Cursor = Cursors.No;
}
else
{
targetPivot.FindForm().Cursor = Cursors.Hand;
}
}
}
private void pvgSICCleaned_MouseMove(object sender, MouseEventArgs e)
{
PivotGridControl Pivot = sender as PivotGridControl;
PivotGridHitInfo hInfo = Pivot.CalcHitInfo(e.Location);
if (hInfo == null || hInfo.CellInfo == null)
{
return;
}
if (hInfo.CellInfo.RowIndex <= Pivot.Cells.RowCount)
{
try
{
TheSelectedShiftNo = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_ShiftNo).ToString();
TheSelectedWorkplace = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_WP).ToString();
TheSelectedName = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_Name).ToString();
TheSelectedType = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_Type).ToString();
TheSelectedActivity = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_Activity).ToString();
TheSelectedDate = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_CalendarDate).ToString();
TheSelectedProblemCode = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(colc_TheValue).ToString();
}
catch (NullReferenceException ex)
{
}
}
}
private void pivotGridControl1_MouseMove(object sender, MouseEventArgs e)
{
mousePos = Point.Empty;
PivotGridHitInfo info = pivotGridControl1.CalcHitInfo(e.Location);
if (info.HitTest == PivotGridHitTest.Value)
{
mousePos = e.Location;
BaseViewInfo newVI = info.ValueInfo.Data.ViewInfo.GetViewInfoAtPoint(e.Location);
if (!object.ReferenceEquals(newVI, viewInfo))
{
pivotGridControl1.Invalidate(newVI.PaintBounds);
if (viewInfo != null)
{
pivotGridControl1.Invalidate(viewInfo.PaintBounds);
}
viewInfo = newVI;
}
}
else
{
if (viewInfo != null)
{
pivotGridControl1.Invalidate(viewInfo.PaintBounds);
}
viewInfo = null;
}
}
private void pivotGridControl1_MouseClick(object sender, MouseEventArgs e)
{
PivotGridHitInfo hi = pivotGridControl1.CalcHitInfo(e.Location);
if (hi.HitTest == PivotGridHitTest.Value && hi.ValueInfo.IsColumn)
{
ApplySortByValue(hi.ValueInfo);
}
}
private void pivotGridControl1_MouseClick(object sender, MouseEventArgs e)
{
PivotGridHitInfo hitInfo = pivotGridControl1.CalcHitInfo(e.Location);
if (hitInfo.HitTest == PivotGridHitTest.Value && hitInfo.ValueInfo != null)
{
dataGridView1.DataSource = hitInfo.ValueInfo.CreateDrillDownDataSource();
}
}
private void pivotGridControl1_MouseClick(object sender, MouseEventArgs e)
{
PivotGridHitInfo hInfo = pivotGridControl1.CalcHitInfo(e.Location);
if (hInfo.HitTest == PivotGridHitTest.Value)
{
HandleValueMouseClick(hInfo.ValueInfo);
}
}
private void pivotGridControl1_MouseDown(object sender, MouseEventArgs e)
{
PivotGridHitInfo hi = pivotGridControl1.CalcHitInfo(e.Location);
if (hi.HitTest == PivotGridHitTest.HeadersArea && hi.HeaderField != null && hi.HeadersAreaInfo.HeaderHitTest == PivotGridHeaderHitTest.Filter && hi.HeaderField.Area != PivotArea.DataArea)
{
(e as DXMouseEventArgs).Handled = true;
customFieldFilterControl1.Field = hi.HeaderField;
popupControlContainer1.ShowPopup((sender as PivotGridControl).PointToScreen(e.Location));
}
}
private void GuardaPosicaoCursor(PivotGridHitInfo info)
{
try
{
this.pvtGrdVisualizacoes.ContextMenuStrip = null;
if (info != null && info.CellInfo != null)
{
this.pvtGrdVisualizacoes.ContextMenuStrip = this.ctxtMnStrpVisao;
this.ctxtMnStrpVisao.Tag = info.CellInfo.DataField;
}
}
catch (Exception)
{
}
}
private void OnGridViewDragObjectDrop(object sender, DragObjectDropEventArgs e)
{
Point location = MousePosition;
if (!(e.DragObject is GridColumn))
{
return;
}
PivotGridHitInfo hitInfo = pivot.CalcHitInfo(pivot.PointToClient(location));
if (null == hitInfo.HeadersAreaInfo)
{
return;
}
pivot.Fields.Add(((GridColumn)e.DragObject).FieldName, hitInfo.HeadersAreaInfo.Area);
}
private void showToolTipForParameterNameField(PivotGridHitInfo hi, ToolTipControllerGetActiveObjectInfoEventArgs e)
{
var field = hi.ValueInfo.Field;
if (field != _pivotGrid.ParameterField)
{
return;
}
var ds = hi.ValueInfo.CreateDrillDownDataSource();
var parameterDisplayName = ds.StringValue(PKSimConstants.PKAnalysis.ParameterDisplayName);
var description = ds.StringValue(PKSimConstants.PKAnalysis.Description);
var warning = ds.StringValue(PKSimConstants.PKAnalysis.Warning);
var superToolTip = _toolTipCreator.ToolTipForPKAnalysis(parameterDisplayName, description, warning);
e.Info = _toolTipCreator.ToolTipControlInfoFor(parameterDisplayName, superToolTip);
}
private void pivotGridControl1_MouseMove(object sender, MouseEventArgs e)
{
PivotGridControl pivot = (PivotGridControl)sender;
PivotGridHitInfo hitInfo = pivot.CalcHitInfo(e.Location);
if (hitInfo.HitTest != PivotGridHitTest.HeadersArea)
{
return;
}
if (hitInfo.HeaderField != null && hitInfo.HeaderField.Area == PivotArea.DataArea && hitInfo.HeaderField.Options.AllowRunTimeSummaryChange)
{
PropertyInfo pInfo = typeof(PivotGridHeadersAreaHitInfo).GetProperty("HeadersViewInfo", BindingFlags.Instance | BindingFlags.NonPublic);
PivotHeadersViewInfoBase headersViewInfo = pInfo.GetValue(hitInfo.HeadersAreaInfo, null) as PivotHeadersViewInfoBase;
PivotHeaderViewInfo headerViewInfo = headersViewInfo[GetFieldItem(pivot, hitInfo.HeaderField)] as PivotHeaderViewInfo;
MethodInfo mInfo = typeof(PivotHeaderViewInfo).GetMethod("ShowSummariesMenu", BindingFlags.NonPublic | BindingFlags.Instance);
mInfo.Invoke(headerViewInfo, new object[] { });
}
}
private void toolTipController1_GetActiveObjectInfo(object sender, DevExpress.Utils.ToolTipControllerGetActiveObjectInfoEventArgs e)
{
if (e.SelectedControl != pivotGridControl1)
{
return;
}
PivotGridHitInfo hitInfo = pivotGridControl1.CalcHitInfo(e.ControlMousePosition);
if (hitInfo.CellInfo != null)
{
PivotGridStyleFormatCondition condition = GetStyleFormatByValue(hitInfo.CellInfo.Item, pivotGridControl1);
if (condition != null)
{
object o = hitInfo.CellInfo.DataField.ToString() + hitInfo.CellInfo.ColumnIndex + hitInfo.CellInfo.RowIndex;
string toolTipString = Convert.ToString(condition.Tag);
e.Info = new ToolTipControlInfo(o, toolTipString);
}
}
}
DragDropEffects GetDragEffect(Point point)
{
PivotGridHitInfo hi = targetPivot.CalcHitInfo(point);
PivotArea dragArea = dragInfo.ValueInfo.Field.Area;
if (hi.HitTest != PivotGridHitTest.Value || hi.ValueInfo.Field == null || hi.ValueInfo.Field.Area != dragArea)
{
TargetInfo = null;
return(DragDropEffects.None);
}
if ((dragArea == PivotArea.ColumnArea && !AllowDragColumn) || (dragArea == PivotArea.RowArea && !AllowDragRow))
{
TargetInfo = null;
return(DragDropEffects.None);
}
//for the same group
if (IsSameGroup(dragInfo.ValueInfo, hi.ValueInfo))
{
if (dragInfo.ValueInfo.Field != hi.ValueInfo.Field || dragInfo.ValueInfo.Value.Equals(hi.ValueInfo.Value))
{
TargetInfo = null;
return(DragDropEffects.None);
}
else
{
TargetInfo = hi;
return(DragDropEffects.Move);
}
}
else //for different groups
{
if ((dragArea == PivotArea.RowArea && AllowChangeRowGroup) || (dragArea == PivotArea.ColumnArea && AllowChangeColumnGroup))
{
TargetInfo = hi;
return(DragDropEffects.Move);
}
else
{
TargetInfo = null;
return(DragDropEffects.None);
}
}
}
/// <summary>
/// Used to get underlying data and display the DetailData dialog
/// </summary>
void DashboardItemClick(object sender, DashboardItemMouseActionEventArgs e)
{
if (IsDetailsEnabled(e.DashboardItemName))
{
PivotGridControl pivot = dashboardDesigner.GetUnderlyingControl(e.DashboardItemName) as PivotGridControl;
PivotGridHitInfo hi = pivot.CalcHitInfo(pivot.PointToClient(Cursor.Position));
bool doNotShowDataForThisArea =
(hi.HitTest == PivotGridHitTest.Value && hi.ValueInfo.ValueHitTest == PivotGridValueHitTest.ExpandButton) ||
(hi.HitTest == PivotGridHitTest.None);
if (!doNotShowDataForThisArea)
{
using (DetailData detailForm = new DetailData(e.GetUnderlyingData()))
{
detailForm.ShowDialog();
}
}
}
}
private void pvgSICCapture_MouseMove(object sender, MouseEventArgs e)
{
PivotGridControl Pivot = sender as PivotGridControl;
PivotGridHitInfo hInfo = Pivot.CalcHitInfo(e.Location);
if (hInfo == null || hInfo.CellInfo == null)
{
return;
}
if (hInfo.CellInfo.RowIndex <= Pivot.Cells.RowCount)
{
try
{
TheSelectedShiftNo = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(col_ShiftNo).ToString();
TheSelectedSICKey = Pivot.Cells.GetCellInfo(hInfo.CellInfo.ColumnIndex, hInfo.CellInfo.RowIndex).GetFieldValue(col_SICKey).ToString();
}
catch (NullReferenceException ex)
{
}
}
}
private void pvgSICCapture_MouseUp(object sender, MouseEventArgs e)
{
PivotGridControl Pivot = sender as PivotGridControl;
PivotGridHitInfo hInfo = Pivot.CalcHitInfo(e.Location);
if (hInfo == null || hInfo.CellInfo == null)
{
return;
}
if (hInfo.CellInfo.ColumnIndex >= 0)
{
if (e.Button == MouseButtons.Right)
{
if (Pivot.GetFieldValue(col_CalendarDate, hInfo.CellInfo.RowIndex).ToString() != "")
{
popupRow.ShowPopup(MousePosition);
}
}
}
}
private void targetPivot_MouseUp(object sender, MouseEventArgs e)
{
if (onDrag)
{
if (GetDragEffect(e.Location) == DragDropEffects.Move)
{
PivotGridHitInfo hi = targetPivot.CalcHitInfo(e.Location);
if (hi.ValueInfo.Field == dragInfo.ValueInfo.Field)
{
(dragInfo.ValueInfo.Field.Tag as IList).Remove(dragInfo.ValueInfo.Value);
(dragInfo.ValueInfo.Field.Tag as IList).Insert((dragInfo.ValueInfo.Field.Tag as IList).IndexOf(hi.ValueInfo.Value), dragInfo.ValueInfo.Value);
//updateMemos();
}
if ((dragInfo.ValueInfo.Field.Area == PivotArea.RowArea && AllowChangeRowGroup) || (dragInfo.ValueInfo.Field.Area == PivotArea.ColumnArea && AllowChangeColumnGroup))
{
PivotDrillDownDataSource ds = null;
for (int i = 0; i < dragInfo.ValueInfo.Field.AreaIndex && i <= hi.ValueInfo.Field.AreaIndex; i++)
{
object targetFieldValue = hi.ValueInfo.GetFieldValue(targetPivot.GetFieldByArea(dragInfo.ValueInfo.Field.Area, i), hi.ValueInfo.MinIndex);
object dragFieldValue = dragInfo.ValueInfo.GetFieldValue(targetPivot.GetFieldByArea(dragInfo.ValueInfo.Field.Area, i), dragInfo.ValueInfo.MinIndex);
if (targetFieldValue != dragFieldValue)
{
if (ds == null)
{
ds = dragInfo.ValueInfo.CreateDrillDownDataSource();
}
foreach (PivotDrillDownDataRow row in ds)
{
ds.SetValue(row.Index, targetPivot.GetFieldByArea(dragInfo.ValueInfo.Field.Area, i), targetFieldValue);
}
}
}
}
targetPivot.RefreshData();
}
onDrag = false;
targetPivot.FindForm().Cursor = Cursors.Default;
}
}
private void showToolTipForParameterValueField(PivotGridHitInfo hi, ToolTipControllerGetActiveObjectInfoEventArgs e)
{
var field = hi.CellInfo.DataField;
if (field != _pivotGrid.ValueField)
{
return;
}
var ds = hi.CellInfo.CreateDrillDownDataSource();
var warning = ds.StringValue(PKSimConstants.PKAnalysis.Warning);
if (string.IsNullOrEmpty(warning))
{
return;
}
var parameterDisplayName = ds.StringValue(PKSimConstants.PKAnalysis.ParameterDisplayName);
var superToolTip = _toolTipCreator.WarningToolTip(warning);
e.Info = _toolTipCreator.ToolTipControlInfoFor(parameterDisplayName, superToolTip);
}
private void PivotGridControl_MouseClick(object sender, MouseEventArgs e)
{
PivotGridControl pivot = sender as PivotGridControl;
PivotGridHitInfo info = pivot.CalcHitInfo(e.Location);
if (info.HitTest != PivotGridHitTest.Value)
{
return;
}
if (info.ValueInfo.Value == null)
{
return;
}
int fieldIdx = info.ValueInfo.Field.Index;
int maxIdx = info.ValueInfo.MaxIndex;
string fieldname = info.ValueInfo.Field.ToString();
string fieldvalue = info.ValueInfo.Value.ToString();
BindingList <ResultItem> chartResult = pivot.DataSource as BindingList <ResultItem>;
string lineID = string.Empty;
string designID = string.Empty;
string prodID = string.Empty;
string procID = string.Empty;
string stepID = string.Empty;
/* 차트 도입부 */
if (fieldname == "LINE_ID")
{
chartResult = chartResult.Where(x => x.LineID == fieldvalue).ToBindingList();
}
else if (fieldname == "DESIGN_ID")
{
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx) != null)
{
lineID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx).ToString();
}
BindingList <ResultItem> list = new BindingList <ResultItem>();
foreach (var item in chartResult)
{
if (string.IsNullOrEmpty(lineID) == false && item.LineID != lineID)
{
continue;
}
if (item.DesignID != fieldvalue)
{
continue;
}
list.Add(item);
}
chartResult = list;
}
else if (fieldname == "PRODUCT_ID")
{
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx) != null)
{
lineID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx) != null)
{
designID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx).ToString();
}
BindingList <ResultItem> list = new BindingList <ResultItem>();
foreach (var item in chartResult)
{
if (string.IsNullOrEmpty(lineID) == false && item.LineID != lineID)
{
continue;
}
if (string.IsNullOrEmpty(designID) == false && item.DesignID != designID)
{
continue;
}
if (item.ProductID != fieldvalue)
{
continue;
}
list.Add(item);
}
chartResult = list;
}
else if (fieldname == "PROCESS_ID")
{
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 3], maxIdx) != null)
{
lineID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 3], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx) != null)
{
designID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx) != null)
{
prodID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx).ToString();
}
BindingList <ResultItem> list = new BindingList <ResultItem>();
foreach (var item in chartResult)
{
if (string.IsNullOrEmpty(lineID) == false && item.LineID != lineID)
{
continue;
}
if (string.IsNullOrEmpty(designID) == false && item.DesignID != designID)
{
continue;
}
if (string.IsNullOrEmpty(prodID) == false && item.ProductID != prodID)
{
continue;
}
if (item.ProcessID != fieldvalue)
{
continue;
}
list.Add(item);
}
chartResult = list;
}
else if (fieldname == "STEP_ID")
{
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 4], maxIdx) != null)
{
lineID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 4], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 3], maxIdx) != null)
{
designID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 3], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx) != null)
{
prodID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx) != null)
{
procID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx).ToString();
}
BindingList <ResultItem> list = new BindingList <ResultItem>();
foreach (var item in chartResult)
{
if (string.IsNullOrEmpty(lineID) == false && item.LineID != lineID)
{
continue;
}
if (string.IsNullOrEmpty(designID) == false && item.DesignID != designID)
{
continue;
}
if (string.IsNullOrEmpty(prodID) == false && item.ProductID != prodID)
{
continue;
}
if (string.IsNullOrEmpty(procID) == false && item.ProcessID != procID)
{
continue;
}
if (item.StepID != fieldvalue)
{
continue;
}
list.Add(item);
}
chartResult = list;
}
else if (fieldname == "SEQUENCE")
{
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 5], maxIdx) != null)
{
lineID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 5], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 4], maxIdx) != null)
{
designID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 4], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 3], maxIdx) != null)
{
prodID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 3], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx) != null)
{
procID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 2], maxIdx).ToString();
}
if (pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx) != null)
{
stepID = pivot.GetFieldValue(info.ValueInfo.Data.Fields[fieldIdx - 1], maxIdx).ToString();
}
BindingList <ResultItem> list = new BindingList <ResultItem>();
foreach (var item in chartResult)
{
if (string.IsNullOrEmpty(lineID) == false && item.LineID != lineID)
{
continue;
}
if (string.IsNullOrEmpty(designID) == false && item.DesignID != designID)
{
continue;
}
if (string.IsNullOrEmpty(prodID) == false && item.ProductID != prodID)
{
continue;
}
if (string.IsNullOrEmpty(procID) == false && item.ProcessID != procID)
{
continue;
}
if (string.IsNullOrEmpty(stepID) == false && item.StepID != stepID)
{
continue;
}
if (item.Sequence != Convert.ToDecimal(fieldvalue))
{
continue;
}
list.Add(item);
}
chartResult = list;
}
DataTable chartTable = new DataTable();
chartTable.Columns.Add("PRODUCT_ID", typeof(string));
chartTable.Columns.Add("DATE", typeof(string));
chartTable.Columns.Add("MOVE", typeof(int));
chartTable.Columns.Add("TARGET", typeof(int));
chartTable.PrimaryKey = new DataColumn[]
{
chartTable.Columns["PRODUCT_ID"], chartTable.Columns["DATE"]
};
List <string> SelProds = new List <string>();
foreach (var row in chartResult)
{
DataRow eRow = chartTable.Rows.Find(new object[] { row.ProductID, row.Date });
if (eRow != null)
{
eRow["MOVE"] = Convert.ToInt32(eRow["MOVE"]) + row.PlanQty;
eRow["TARGET"] = Convert.ToInt32(eRow["TARGET"]) + row.TargetQty;
}
else
{
DataRow drow = chartTable.NewRow();
drow["PRODUCT_ID"] = row.ProductID;
drow["DATE"] = row.Date;
drow["MOVE"] = row.PlanQty;
drow["TARGET"] = row.TargetQty;
chartTable.Rows.Add(drow);
}
if (SelProds.Contains(row.ProductID) == false)
{
SelProds.Add(row.ProductID);
}
}
DrawChart(chartTable, SelProds);
}
private void pivotGridControl1_CellClick(object sender, PivotCellEventArgs e)
{
//Employee_24_7_Production_user_id = userid.ToString();
SplashScreenManager.ShowForm(this, typeof(Ordermanagement_01.Masters.WaitForm1), true, true, false);
try
{
PivotGridHitInfo hi = pivotGridControl1.CalcHitInfo(pivotGridControl1.PointToClient(MousePosition));
if (hi.HitTest == PivotGridHitTest.Cell)
{
string V_Data = "";
string Column_Name = "";
string Row_Value_Type = ""; string Column_Value_Type = "";
string User_Name = ""; string Branch_Name = "";
string V_UserName = ""; string V_Date = "";
string V_BranchName = "";
Row_Value_Type = hi.CellInfo.RowValueType.ToString();
Column_Value_Type = hi.CellInfo.ColumnValueType.ToString();
// MessageBox.Show("Row_value_Type"+Row_Value_Type + " Column_Value_Type:" + Column_Value_Type);
Column_Name = hi.CellInfo.DataField.FieldName.ToString();
//Row_Name = hi.CellInfo.RowField.FieldName.ToString();
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.ColumnArea))
{
if (Column_Name == "No_Of_Errors")
{
V_Data = e.GetFieldValue(pivotGridField2).ToString();
}
if (Column_Name == "No_of_Completed_orders")
{
V_Data = e.GetFieldValue(pivotGridField3).ToString();
}
if (Column_Name == "Accuracy")
{
V_Data = e.GetFieldValue(pivotGridField4).ToString();
}
}
int month_id = 0; int year_id = 0;
object obj = lookUpEdit_Accuracy_Month.EditValue;
string month_name = lookUpEdit_Accuracy_Month.Text;
if (obj.ToString() != "0")
{
month_id = (int)obj;
}
object obj_year = lookUpEdit_Accuracy_Year.EditValue;
string year = lookUpEdit_Accuracy_Year.Text;
if (obj_year.ToString() != "0")
{
year_id = (int)obj_year;
}
// get First and last day of the Month and Year
first = new DateTime(year_id, month_id, 1);
last = first.AddMonths(1).AddSeconds(-1);
string Fromdate = first.ToString();
string Todate = last.ToString();
//foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
//{
// V_UserName = e.GetFieldValue(pivotGridField5).ToString();
// User_Name = V_UserName;
//}
//foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.ColumnArea))
//{
// V_Date = e.GetFieldValue(pivotGridField1).ToString();
// //Production_Date = V_Date;
//}
//foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
//{
// V_BranchName = e.GetFieldValue(pivotGridField12).ToString();
// Branch_Name = V_BranchName;
//}
if (V_Data != "" && V_Data != "0")
{
if (Row_Value_Type == "Value" && Column_Value_Type == "Value")// This is for Non Summary Click Event
{
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.ColumnArea))
{
V_Date = e.GetFieldValue(pivotGridField1).ToString();
}
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
{
V_UserName = e.GetFieldValue(pivotGridField5).ToString();
User_Name = V_UserName;
}
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
{
V_BranchName = e.GetFieldValue(pivotGridField12).ToString();
Branch_Name = V_BranchName;
}
//if (V_Data != "" && V_Data != "0")
//{
Hashtable ht_get_grid = new Hashtable();
System.Data.DataTable dt_get_grid = new System.Data.DataTable();
ht_get_grid.Clear();
dt_get_grid.Clear();
ht_get_grid.Add("@Trans", "GET_USER_ID");
ht_get_grid.Add("@Emp_Name", User_Name);
dt_get_grid = dataaccess.ExecuteSP("Sp_Daily_Status_Top_Efficiency_Calculation", ht_get_grid);
//
Hashtable ht_insert = new Hashtable();
System.Data.DataTable dt_insert = new System.Data.DataTable();
//ht_insert.Clear();
//dt_insert.Clear();
ht_insert.Add("@Trans", "INSERT_INTO_TEMP_USER_NEW_USER_WISE");
ht_insert.Add("@User_Id", dt_get_grid.Rows[0]["User_id"].ToString());
ht_insert.Add("@Production_Date", V_Date.ToString());
dt_insert = dataaccess.ExecuteSP("Sp_Employee_Production_Score_Board", ht_insert);
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard
= new Ordermanagement_01.Reports.Accuracy_Detail_Section(int.Parse(dt_get_grid.Rows[0]["User_id"].ToString()), User_Role_Id, V_Date.ToString(), int.Parse(dt_get_grid.Rows[0]["Branch_ID"].ToString()), "", "");
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
//2
else if (Row_Value_Type == "Value" && Column_Value_Type == "Total")// this is For Column Grand Total // this is for Single user & All Date
{
//if (V_Data != "" && V_Data != "0")
//{
Hashtable ht_get_grid = new Hashtable();
System.Data.DataTable dt_get_grid = new System.Data.DataTable();
ht_get_grid.Clear();
dt_get_grid.Clear();
ht_get_grid.Add("@Trans", "GET_USER_ID");
ht_get_grid.Add("@Emp_Name", User_Name);
// ht_get_grid.Add("@Branch_Name", Branch_Name);
dt_get_grid = dataaccess.ExecuteSP("Sp_Daily_Status_Top_Efficiency_Calculation", ht_get_grid);
//Hashtable htinsert = new Hashtable();
//System.Data.DataTable dtinsert = new System.Data.DataTable();
//htinsert.Add("@Trans", "INSERT_INTO_TEMP_USER");
//htinsert.Add("@Production_Date", V_Date.ToString());
//htinsert.Add("@User_Id", int.Parse(dt_get_grid.Rows[0]["User_id"].ToString()));
//dtinsert = dataaccess.ExecuteSP("Sp_Employee_Production_Score_Board", htinsert);
//Hashtable htinsert = new Hashtable();
//System.Data.DataTable dtinsert = new System.Data.DataTable();
//htinsert.Add("@Trans", "INSERT_INTO_TEMP_USER_1");
//htinsert.Add("@From_Date", Fromdate.ToString());
//htinsert.Add("@To_Date", Todate.ToString());
//dtinsert = dataaccess.ExecuteSP("Sp_Employee_Production_Score_Board", htinsert);
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard
= new Ordermanagement_01.Reports.Accuracy_Detail_Section(int.Parse(dt_get_grid.Rows[0]["User_id"].ToString()), User_Role_Id, V_Date.ToString(), int.Parse(dt_get_grid.Rows[0]["Branch_ID"].ToString()), "", "");
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
//3
else if (Row_Value_Type == "Value" && Column_Value_Type == "GrandTotal")// this is For Column Grand Total // this is for Single user & All Date
{
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
{
V_UserName = e.GetFieldValue(pivotGridField5).ToString();
User_Name = V_UserName;
}
//if (V_Data != "" && V_Data != "0")
//{
Hashtable ht_get_grid = new Hashtable();
System.Data.DataTable dt_get_grid = new System.Data.DataTable();
ht_get_grid.Clear();
dt_get_grid.Clear();
ht_get_grid.Add("@Trans", "GET_USER_ID");
ht_get_grid.Add("@Emp_Name", User_Name);
// ht_get_grid.Add("@Branch_Name", Branch_Name);
dt_get_grid = dataaccess.ExecuteSP("Sp_Daily_Status_Top_Efficiency_Calculation", ht_get_grid);
//Hashtable htinsert = new Hashtable();
//System.Data.DataTable dtinsert = new System.Data.DataTable();
//htinsert.Add("@Trans", "INSERT_INTO_TEMP_USER");
//htinsert.Add("@Production_Date", V_Date.ToString());
//htinsert.Add("@User_Id", int.Parse(dt_get_grid.Rows[0]["User_id"].ToString()));
//dtinsert = dataaccess.ExecuteSP("Sp_Employee_Production_Score_Board", htinsert);
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard
= new Ordermanagement_01.Reports.Accuracy_Detail_Section(int.Parse(dt_get_grid.Rows[0]["User_id"].ToString()), User_Role_Id, V_Date.ToString(), int.Parse(dt_get_grid.Rows[0]["Branch_ID"].ToString()), Fromdate, Todate);
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
//4
else if (Row_Value_Type == "Total" && Column_Value_Type == "Value")// this is For Row Total // this is for Single user & All Date
{
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.ColumnArea))
{
V_Date = e.GetFieldValue(pivotGridField1).ToString().Trim();
}
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
{
string val2 = e.GetFieldValue(pivotGridField12).ToString();
Branch_Name = val2;
}
//if (V_Data != "" && V_Data != "0")
//{
Hashtable ht_get_grid = new Hashtable();
System.Data.DataTable dt_get_grid = new System.Data.DataTable();
ht_get_grid.Clear();
dt_get_grid.Clear();
ht_get_grid.Add("@Trans", "GET_BRANCH_ID");
ht_get_grid.Add("@Branch_Name", Branch_Name);
dt_get_grid = dataaccess.ExecuteSP("Sp_Daily_Status_Top_Efficiency_Calculation", ht_get_grid);
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard = new Ordermanagement_01.Reports.Accuracy_Detail_Section(0, User_Role_Id, V_Date.ToString(), int.Parse(dt_get_grid.Rows[0]["Branch_ID"].ToString()), "", "");
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
//5
else if (Row_Value_Type == "GrandTotal" && Column_Value_Type == "Value")// this is For row Grand Total // this is for Single date & All Date
{
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.ColumnArea))
{
V_Date = e.GetFieldValue(pivotGridField1).ToString().Trim();
}
//if (V_Data != "" && V_Data != "0")
//{
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard = new Ordermanagement_01.Reports.Accuracy_Detail_Section(0, User_Role_Id, V_Date.ToString(), 0, "", "");
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
//6
else if (Row_Value_Type == "Total" && Column_Value_Type == "GrandTotal")// this is For Row Total // this is for Single user & All Date
{
foreach (var field in pivotGridControl1.GetFieldsByArea(PivotArea.RowArea))
{
string val2 = e.GetFieldValue(pivotGridField12).ToString();
Branch_Name = val2;
}
//if (V_Data != "" && V_Data != "0")
//{
Hashtable ht_get_grid = new Hashtable();
System.Data.DataTable dt_get_grid = new System.Data.DataTable();
ht_get_grid.Clear();
dt_get_grid.Clear();
ht_get_grid.Add("@Trans", "GET_BRANCH_ID");
ht_get_grid.Add("@Branch_Name", Branch_Name);
dt_get_grid = dataaccess.ExecuteSP("Sp_Daily_Status_Top_Efficiency_Calculation", ht_get_grid);
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard = new Ordermanagement_01.Reports.Accuracy_Detail_Section(0, User_Role_Id, V_Date.ToString(), int.Parse(dt_get_grid.Rows[0]["Branch_ID"].ToString()), Fromdate, Todate);
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
//7
else if (Row_Value_Type == "GrandTotal" && Column_Value_Type == "GrandTotal")// this is For Row Total // this is for Single user & All Date
{
//if (V_Data != "" && V_Data != "0")
//{
Ordermanagement_01.Reports.Accuracy_Detail_Section TargeDashboard = new Ordermanagement_01.Reports.Accuracy_Detail_Section(0, User_Role_Id, "", 0, Fromdate, Todate);
TargeDashboard.Show();
//}
//else
//{
// SplashScreenManager.CloseForm(false);
//}
}
}
else
{
SplashScreenManager.CloseForm(false);
}
}
else
{
SplashScreenManager.CloseForm(false);
MessageBox.Show("Error Occured Please Check With Administrator");
}
}
catch (Exception ex)
{
//Close Wait Form
SplashScreenManager.CloseForm(false);
MessageBox.Show("Error Occured Please Check With Administrator");
}
finally
{
//Close Wait Form
SplashScreenManager.CloseForm(false);
}
}
