public void CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
if (!AllowChangeOrder())
{
return;
}
string reference = e.Cell.GetReferenceA1();
var oldCustomerId = order.CustomerId;
string shiftedRange = CellsHelper.GetActualCellRange(reference, actualOrderItems.Any() ? -actualOrderItems.Count : 0);
if (OrderPropertiesHelper.Setters.ContainsKey(shiftedRange))
{
OrderPropertiesHelper.Setters[shiftedRange].Invoke(order, e.Cell.Value, source);
if (CellsHelper.HasDependentCells(shiftedRange))
{
if (order.CustomerId != oldCustomerId)
{
UpdateCustomerStores();
}
CellsHelper.UpdateDependentCells(Invoice, order, source);
UpdateTotalValues();
}
}
if (IsOrderItemsRegionModified(e.Cell))
{
UpdateOrderItem(e.Cell);
}
}
void spreadsheetControl_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
if ((e.ColumnIndex == 4) && ((e.RowIndex >= 3) && (e.RowIndex <= 8)))
{
spreadsheetControl.BeginUpdate();
generator.Generate();
spreadsheetControl.EndUpdate();
}
}
private void spreadsheetControl1_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
IWorkbook workbook2 = spreadsheetControl1.Document;
Worksheet sheet2_0 = workbook2.Worksheets[0];
if (sheet2_0.Cells[2, 0].Value.ToString() == null || sheet2_0.Cells[2, 0].Value.ToString() == "")
{
CoFAS_DevExpressManager.ShowInformationMessage("엑셀 시트를 불러와주시기 바랍니다.");
return;
}
int click_col = 0;
int click_row = 0;
click_col = spreadsheetControl1.ActiveWorksheet[spreadsheetControl1.ActiveCell.GetReferenceA1()].RightColumnIndex;
click_row = spreadsheetControl1.ActiveWorksheet[spreadsheetControl1.ActiveCell.GetReferenceA1()].TopRowIndex;
if (click_col == 2 && click_row < 178)
{
lock (this)
{
showMsg method = delegate
{
string str = sheet2_0.Cells[click_row, click_col].Value.ToString();
sheet2_0.Cells[click_row, click_col].SetValue(str);
// sheet2_0.
bool check;
check = str.Contains(sheet2_0.Cells[click_row, 0].Value.ToString());
if (check)
{
sheet2_0.Cells[click_row, click_col + 1].SetValue("Y");
sheet2_0.Cells[click_row, click_col + 1].Font.Color = Color.White;
sheet2_0.Cells[click_row, click_col + 1].Fill.BackgroundColor = Color.Green;
}
else
{
sheet2_0.Cells[click_row, click_col + 1].SetValue("N");
sheet2_0.Cells[click_row, click_col + 1].Font.Color = Color.White;
sheet2_0.Cells[click_row, click_col + 1].Fill.BackgroundColor = Color.Red;
}
//sheet2_0.SelectedCell = sheet2_0.Cells[click_row + 1, click_col];
};
this.BeginInvoke(method);
}
}
else
{
CoFAS_DevExpressManager.ShowInformationMessage("해당하는 Barcode에 마우스를 클릭해주시기 바랍니다.");
return;
}
}
private void spreadsheetControl1_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
Worksheet sheet = spreadsheetControl1.Document.Worksheets[0];
if (e.SheetName == sheet.Name && e.RowIndex == 3 && e.ColumnIndex == 2)
{
sheet.Columns[2].AutoFit();
sheet.Columns[4].AutoFit();
}
}
private void spreadsheetControl_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
ExcelEventArg arg = new ExcelEventArg()
{
};
Range range = GetSelectedRange();
Cell active = getActiveCell();
object value = getValueAt(active.Row, active.Column, getActiveSheetName());
if (value is float || value is double || value is int)
{
bool availableDigitNumber = validateNumberDigit(value);
if (!availableDigitNumber)
{
var sheet = this.spreadsheetControl.Document.Worksheets[getActiveSheetName()];
sheet.Cells[active.Row - 1, active.Column - 1].Value = e.OldValue;
Kernel.Util.MessageDisplayer.DisplayError("Number Digit", "Number of digit is over !");
return;
}
}
//Range previousRange = rangePreviousValue;
//IsSameRange = previousRange == range;
if (range == null || (rangePreviousValue != null && rangePreviousValue.Name.Equals(range.Name)))
{
return;
}
if (range.CellCount > 1)
{
arg.Range = range;
}
else
{
arg.Range = rangePreviousValue;
}
if (arg.Range == null)
{
arg.Range = range;
}
if (arg.Sheet == null)
{
arg.Sheet = arg.Range.Sheet;
}
if (ThrowEvent && Edited != null)
{
Edited(arg);
rangePreviousValue = range;
}
}
private void spreadsheetControl1_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
for (int i = 1; i <= parentnode.Nodes.Count; i++)
{
Register up = new Register();
up.Patient_id = worksheet.GetCellValue(0, i).ToString();
up.Patient_Name = worksheet.GetCellValue(1, i).ToString();;
up.Patient_Sex = worksheet.GetCellValue(2, i).ToString();
up.Number = worksheet.GetCellValue(3, i).ToString();
up.Id_Number = worksheet.GetCellValue(4, i).ToString();
up.Date_Of_Birth = worksheet.GetCellValue(5, i).ToString();
Updatedata(up);
}
MessageBox.Show("修改成功");
}
private void Spreadsheet_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
if (e.Worksheet.Index == 0 && e.RowIndex == 7)
{
return;
}
else if (e.Worksheet.Index == 1 && e.RowIndex == 8)
{
return;
}
else if (e.Worksheet.Index == 2 && e.OldValue.ToString() != "——" && e.ColumnIndex > 1 && e.ColumnIndex < 6 && e.RowIndex > 7 && e.RowIndex < 31)
{
return;
}
e.Cell.Value = e.OldValue;
}
private void spreadsheetcontrol_CellValueChanged(object sender, DevExpress.XtraSpreadsheet.SpreadsheetCellEventArgs e)
{
}
