private void dgvPapildSummas_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == dgcPSDate1.Index || e.ColumnIndex == dgcPSDate2.Index)
{
Utils.DGVParseDateCell(e);
}
}
private void StdDataGridViewBase_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
DataGridView senderGrid = (DataGridView)sender;
if (senderGrid.Columns[e.ColumnIndex] is StdDataGridViewByteArrayColumn)
{
if (e.Value != null)
{
string[] splitResult = e.Value.ToString().Split('-');
byte[] byteArray = new byte[splitResult.Length];
for (int i = 0; i < splitResult.Length; i++)
{
byteArray[i] = Convert.ToByte(splitResult[i], 16);
}
e.Value = byteArray;
e.ParsingApplied = true;
}
else
{
e.ParsingApplied = false;
}
}
}
/// <summary>
/// парсим
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dataGridViewCalibrationTable_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (Type.GetTypeCode(e.Value.GetType()) == TypeCode.String)
{
try
{
ushort nValue = ushort.Parse(e.Value.ToString());
ushort last = ushort.Parse(dataGridViewCalibrationTable[e.ColumnIndex, e.RowIndex - 1].Value.ToString());
ushort next = ushort.Parse(dataGridViewCalibrationTable[e.ColumnIndex, e.RowIndex + 1].Value.ToString());
if (nValue > last && nValue < next)
{
e.ParsingApplied = true;
newValue = e.Value;
needCorrect = true;
}
else
{
MessageBox.Show(this, "Данное число не корректно",
"Сообщение", MessageBoxButtons.OK, MessageBoxIcon.Information);
newValue = oldValue;
}
}
catch (Exception)
{
MessageBox.Show("Введенное значение не является допустимым числом");
}
}
}
/// <summary>
/// 数据明细表的数据填充处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvList_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
string columnName = ((DataGridView)sender).Columns[e.ColumnIndex].Name;
if (e.Value == null || e.Value.ToString() == "")
{
return;
}
if (columnName.EndsWith("Price"))
{
try
{
e.Value = decimal.Round(Convert.ToDecimal(e.Value), 1).ToString("0.00");
e.ParsingApplied = true;
}
catch
{
}
}
if (columnName == "BlockId")
{
try
{
var tmp = blockList.Where(p => p.BlockId == e.Value.ToString()).FirstOrDefault();
if (tmp == null)
{
e.Value = "";
dgvList["BlockName", e.RowIndex].Value = "";
e.ParsingApplied = true;
}
else
{
blockPriceList = bsList.DataSource as List <BlockPrice>;
dgvList["BlockName", e.RowIndex].Value = tmp.BlockName;
SetPrice();
e.ParsingApplied = true;
foreach (var row in blockPriceList)
{
// 判断是否已经设置了这个区域的票价
if (row.BlockId != null && row.BlockId.Trim() == e.Value.ToString())
{
MessageBox.Show("列表中已存在相同的区域！", "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Error);
e.Value = "";
dgvList["BlockName", e.RowIndex].Value = "";
e.ParsingApplied = true;
break;
}
}
}
}
catch
{
}
}
}
private void dataGridView_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
var schemaColumn = document.SchemaColumns[e.ColumnIndex];
if (schemaColumn != null)
{
if (schemaColumn.DataType == TwoDASchema.DataType.HexInteger && e.Value is string)
{
string s = (string)e.Value;
int value;
if (s.StartsWith("0x", StringComparison.Ordinal))
{
e.ParsingApplied = int.TryParse(s.Substring(2), NumberStyles.HexNumber, CultureInfo.InvariantCulture, out value);
}
else
{
e.ParsingApplied = int.TryParse(s, NumberStyles.Integer, CultureInfo.InvariantCulture, out value);
}
if (e.ParsingApplied)
{
e.Value = value;
}
}
}
}
//</snippet1>
//<snippet2>
// Handling CellParsing allows one to accept user input, then map it to a different
// internal representation.
private void dataGridView1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (this.dataGridView1.Columns[e.ColumnIndex].Name == "Release Date")
{
if (e != null)
{
if (e.Value != null)
{
try
{
// Map what the user typed into UTC.
e.Value = DateTime.Parse(e.Value.ToString()).ToUniversalTime();
// Set the ParsingApplied property to
// Show the event is handled.
e.ParsingApplied = true;
}
catch (FormatException)
{
// Set to false in case another CellParsing handler
// wants to try to parse this DataGridViewCellParsingEventArgs instance.
e.ParsingApplied = false;
}
}
}
}
}
private void dgvDep_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == dgcDepUsedDT1.Index || e.ColumnIndex == dgcDepUsedDT2.Index)
{
Utils.DGVParseDateCell(e);
}
}
private void rtGrid_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
try
{
var source = e.Value.ToString().Trim();
source =
source.Replace(",", CultureInfo.InvariantCulture.NumberFormat.NumberDecimalSeparator).Replace(".",
CultureInfo
.
InvariantCulture
.
NumberFormat
.
NumberDecimalSeparator);
float value;
if (float.TryParse(source, NumberStyles.Float, CultureInfo.InvariantCulture, out value))
{
value = Math.Max(Math.Min(table.Max, value), table.Min);
table.SetFloatValue(e.ColumnIndex, e.RowIndex, value);
}
else
{
value = table.GetFloatValue(e.ColumnIndex, e.RowIndex);
}
e.Value = value;
e.ParsingApplied = true;
}
catch
{ }
}
protected override void OnCellParsing(DataGridViewCellParsingEventArgs e)
{
base.OnCellParsing(e);
String nowText = e.Value as String;// this.CurrentCell.Value.ToString();
CellTextChangedEventArgs args = new CellTextChangedEventArgs(BeforeText, nowText, Now.Col, Now.Row, this.Rows[Now.Row], this.Rows[Now.Row].Cells[Now.Col] as DataGridViewTextBoxCell);
if (_isEditActivated)
{
if (BeforeText.Equals(nowText) == false)
{
if (E_TextChanged != null)
{
E_TextChanged(this, args);
}
if (args.IsCancel)
{
if (EditingControl != null)
{
this.EditingControl.Text = BeforeText;
}
Cell(Now).Value = BeforeText;
}
}
if (E_TextEditFinished != null)
{
E_TextEditFinished(this, args);
}
_isEditActivated = false;
}
}
private void dataGridView1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == 1)
{
int temp = 0;
if (Int32.TryParse((string)e.Value, out temp))
{
MessageBox.Show("Ошибка: Вы ввели некоректные данные.");
e.Value = "";
}
}
if (e.ColumnIndex == 2)
{
int temp = 0;
if (Int32.TryParse((string)e.Value, out temp))
{
MessageBox.Show("Ошибка: Вы ввели некоректные данные.");
e.Value = "";
}
}
if (e.ColumnIndex == 5)
{
int temp = 0;
if (Int32.TryParse((string)e.Value, out temp))
{
MessageBox.Show("Ошибка: Вы ввели некоректные данные.");
e.Value = "";
}
}
}
private void dataGridView2_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (this.dataGridView2.Columns[e.ColumnIndex].Name == "InsHashedPwd")
{
if (e != null)
{
if (e.Value != null)
{
try
{
// Map what the user typed into UTC.
byte[] bytes = SHA256.Create().ComputeHash(Encoding.UTF8.GetBytes(e.Value.ToString()));
string hashedPwd = BitConverter.ToString(bytes).Replace("-", "");
e.Value = hashedPwd;
e.ParsingApplied = true;
}
catch (FormatException)
{
// Set to false in case another CellParsing handler
// wants to try to parse this DataGridViewCellParsingEventArgs instance.
e.ParsingApplied = false;
}
}
//bindingSource.ResetCurrentItem();
//bindingSource.ResetBindings(false);
Trace.WriteLine("BeforeChanged");
}
}
}
private void DgvParams_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex != 2)
{
return;
}
DataGridViewRow row = dgvParams.Rows[e.RowIndex];
var param = (MTD.Param)row.DataBoundItem;
if (param.Type == MTD.ParamType.Int2)
{
TryParseInts((string)e.Value, 2, out int[] ints);
e.Value = ints;
e.ParsingApplied = true;
}
else if (param.Type == MTD.ParamType.Float2)
{
TryParseFloats((string)e.Value, 2, out float[] floats);
e.Value = floats;
e.ParsingApplied = true;
}
else if (param.Type == MTD.ParamType.Float3)
{
TryParseFloats((string)e.Value, 3, out float[] floats);
e.Value = floats;
e.ParsingApplied = true;
}
else if (param.Type == MTD.ParamType.Float4)
{
TryParseFloats((string)e.Value, 4, out float[] floats);
e.Value = floats;
e.ParsingApplied = true;
}
}
private void dgvSvetki_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == dgcDT.Index)
{
Utils.DGVParseDateCell(e);
}
}
private void gridView_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
string value = e.Value.ToString();
if (string.IsNullOrWhiteSpace(value))
{
return;
}
value = value.Trim();
switch (e.ColumnIndex)
{
case COLUMN_SEQUENCE:
{
e.Value = Transition.StripChargeIndicators(value, TransitionGroup.MIN_PRECURSOR_CHARGE, TransitionGroup.MAX_PRECURSOR_CHARGE);
Items[e.RowIndex].Charge = Transition.GetChargeFromIndicator(value, TransitionGroup.MIN_PRECURSOR_CHARGE, TransitionGroup.MAX_PRECURSOR_CHARGE).GetValueOrDefault(1);
e.ParsingApplied = true;
}
break;
case COLUMN_PRODUCT_ION:
{
e.Value = NormalizeProductIon(Transition.StripChargeIndicators(value, Transition.MIN_PRODUCT_CHARGE, Transition.MAX_PRODUCT_CHARGE));
Items[e.RowIndex].ProductCharge = Transition.GetChargeFromIndicator(value, Transition.MIN_PRODUCT_CHARGE, Transition.MAX_PRODUCT_CHARGE).GetValueOrDefault(1);
e.ParsingApplied = true;
}
break;
}
}
/// <summary>
/// 自动保存 用户离开单元格时
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgv1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
try
{
//int i = dgv_title.CurrentCell.ColumnIndex;
string colname = dgv1.Columns[dgv1.CurrentCell.ColumnIndex].Name;
if (colname.Equals("col_phone") || colname.Equals("col_orderid") || colname.Equals("col_wuliu") || colname.Equals("col_vpn") || colname.Equals("col_address") || colname.Equals("col_remark"))
{
shuadan_records og = (shuadan_records)dgv1.CurrentRow.DataBoundItem;
if (og != null)
{
string phone = dgv1["col_phone", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["col_phone", e.RowIndex].EditedFormattedValue.ToString();
string wuliu = dgv1["col_wuliu", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["col_wuliu", e.RowIndex].EditedFormattedValue.ToString();
string address = dgv1["col_address", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["col_address", e.RowIndex].EditedFormattedValue.ToString();
og.sdaddress = address;
og.sdphone = phone;
og.sdwuliu = wuliu;
//BLL2.shuadan_recordsManager.Update(og);
}
}
}
catch (Exception ex)
{
Debug.WriteLine("修改信息失败 " + ex.Message);
}
}
/// <summary>
/// Valida si los valores en la celda son númericos
/// </summary>
private void dgvBolsas_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == clmCantidad.Index)
{
this.validarFormatoNumericoCelda(e);
}
}
public static bool DGVParseDateCell(DataGridViewCellParsingEventArgs e)
{
if (e.Value == null || e.Value == DBNull.Value)
{
return(false);
}
if (!(e.Value is string))
{
return(false);
}
string s = (string)e.Value;
if (string.IsNullOrEmpty(s))
{
return(false);
}
DateTime dt;
if (!Utils.StringToDate(s, out dt))
{
return(false);
}
e.Value = dt;
e.ParsingApplied = true;
return(true);
}
private void dgvDocs0_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == dgcDate.Index)
{
if (e.Value == null || e.Value == DBNull.Value)
{
return;
}
if (!(e.Value is string))
{
return;
}
string s = (string)e.Value;
if (string.IsNullOrEmpty(s))
{
return;
}
DateTime dt;
if (Utils.StringToDate(s, out dt))
{
e.Value = dt;
e.ParsingApplied = true;
return;
}
}
}
private void dgvFields_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == 0)
{
marcarCampo(e.RowIndex, e.ColumnIndex);
}
}
private void dataGridView1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
int curColidx = dataGridView1.CurrentCellAddress.X; // Індекс стовпця поточної клітинки
int curRowidx = dataGridView1.CurrentCellAddress.Y; // Індекс рядка поточної клітинки
string curColName0 = dataGridView1.Columns[0].Name; // Назва стовпця ключового поля
string curColName = dataGridView1.Columns[curColidx].Name; // Назва поточного стовпця
h.curVal0 = dataGridView1[0, curRowidx].Value.ToString(); // Значення клітинки ключового поля поточного рядка
string newCurCellVal = e.Value.ToString(); // Нове значення поточної клітинки
if (curColName == "NAME" || curColName == "VID" || curColName == "TYPE")
{
newCurCellVal = "'" + newCurCellVal + "'"; // Якщо поле текстове, беремо в лапки
}
string sqlStr = "UPDATE Karcinologia_1 SET " + curColName + " = " + newCurCellVal +
" WHERE " + curColName0 + " = " + h.curVal0;
using (MySqlConnection con = new MySqlConnection(h.ConStr))
{
MySqlCommand cmd = new MySqlCommand(sqlStr, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
}
private void gridView_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
string value = e.Value.ToString();
if (string.IsNullOrWhiteSpace(value))
{
return;
}
value = value.Trim();
switch (e.ColumnIndex)
{
case COLUMN_SEQUENCE:
{
var seqCharge = new SequenceAndCharge(value);
e.Value = seqCharge.ModifiedSequence;
Items[e.RowIndex].Adduct = seqCharge.Charge;
e.ParsingApplied = true;
}
break;
case COLUMN_PRODUCT_ION:
{
var fragCharge = new FragmentAndCharge(value);
e.Value = fragCharge.FragmentIon;
Items[e.RowIndex].ProductAdduct = fragCharge.Adduct;
e.ParsingApplied = true;
}
break;
}
}
private void dgv_type_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
try
{
string colname = dgv_type.Columns[dgv_type.CurrentCell.ColumnIndex].Name;
if (colname.Equals("col_account") || colname.Equals("col_pwd") || colname.Equals("col_phone") || colname.Equals("col_remark"))
{
shuadan_account hs = (shuadan_account)dgv_type.CurrentRow.DataBoundItem;
if (hs != null)
{
string col_account = dgv_type["col_account", e.RowIndex].EditedFormattedValue == null ? "" : dgv_type["col_account", e.RowIndex].EditedFormattedValue.ToString();
string col_pwd = dgv_type["col_pwd", e.RowIndex].EditedFormattedValue == null ? "" : dgv_type["col_pwd", e.RowIndex].EditedFormattedValue.ToString();
string col_phone = dgv_type["col_phone", e.RowIndex].EditedFormattedValue == null ? "" : dgv_type["col_phone", e.RowIndex].EditedFormattedValue.ToString();
string col_remark = dgv_type["col_remark", e.RowIndex].EditedFormattedValue == null ? "" : dgv_type["col_remark", e.RowIndex].EditedFormattedValue.ToString();
hs.sdaccount = col_account;
hs.sdapwd = col_pwd;
hs.sdaphone = col_phone;
hs.sdaremark = col_remark;
BLL.shuadan_accountManager.Update(hs);
}
}
}
catch (Exception ex)
{
ex.ToLog();
}
}
private void dgvDetail_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == 2)
{
if (dgvDetail.Rows[e.RowIndex].Tag != null)
{
Project proj = (Project)dgvDetail.Rows[e.RowIndex].Tag;
KryptonDataGridViewComboBoxCell comboboxCell = (KryptonDataGridViewComboBoxCell)dgvDetail.Rows[e.RowIndex].Cells[e.ColumnIndex];
if (comboboxCell.EditedFormattedValue != null)
{
string key = comboboxCell.EditedFormattedValue.ToString();
if (PersonDict.ContainsKey(key))
{
Person personObj = PersonDict[key];
Unit unitObj = ConnectionManager.Context.table("Unit").where ("ID='" + proj.UnitID + "'").select("*").getItem <Unit>(new Unit());
if (unitObj != null)
{
dgvDetail[3, e.RowIndex].Value = personObj.Sex;
dgvDetail[4, e.RowIndex].Value = personObj.Birthday;
dgvDetail[5, e.RowIndex].Value = personObj.Job;
dgvDetail[6, e.RowIndex].Value = personObj.MobilePhone;
dgvDetail[7, e.RowIndex].Value = unitObj.UnitName + "," + unitObj.Address;
}
}
}
}
}
}
/// <summary>
/// 自动保存 用户离开单元格时
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Dgv_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
try
{
//int i = dgv_title.CurrentCell.ColumnIndex;
//string colname = dgv1.Columns[dgv1.CurrentCell.ColumnIndex].Name;
//if (colname.Equals("btname") || colname.Equals("btcontent"))
//{
// basic_task bt = (basic_task)dgv1.CurrentRow.DataBoundItem;
// if (bt != null)
// {
// string btname = dgv1["btname", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["btname", e.RowIndex].EditedFormattedValue.ToString();
// string btcontent = dgv1["btcontent", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["btcontent", e.RowIndex].EditedFormattedValue.ToString();
// bt.btname = btname;
// bt.btcontent = btcontent;
// BLL.basic_taskManager.Update(bt);
// }
//}
}
catch (Exception ex)
{
ex.ToShow();
//Debug.WriteLine("修改信息失败 " + ex.Message);
}
}
private void dgvBrand_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
try
{
if (e != null && e.Value != null)
{
try
{
// default parsing fails to convert string to sqlstring
// assist it here.
e.Value = new SqlString(e.Value.ToString());
e.ParsingApplied = true;
}
catch (FormatException)
{
// Set to false in case another CellParsing handler
// wants to try to parse this DataGridViewCellParsingEventArgs instance.
e.ParsingApplied = false;
}
}
}
catch (Exception ex)
{
Utility.GetInstance().HandleException(this, ex, e);
}
}
private void dgvPersons_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.ColumnIndex == dgcUsedDt1.Index || e.ColumnIndex == dgcUsedDt1.Index)
{
Utils.DGVParseDateCell(e);
}
}
/// <summary>
/// 自动保存 用户离开单元格时
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgv1_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
try
{
string colname = dgv1.Columns[dgv1.CurrentCell.ColumnIndex].Name;
if (colname.Equals("col_title") || colname.Equals("col_sort") || colname.Equals("col_context"))
{
huashu hs = (huashu)dgv1.CurrentRow.DataBoundItem;
if (hs != null)
{
string htitle = dgv1["col_title", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["col_title", e.RowIndex].EditedFormattedValue.ToString();
string hcontext = dgv1["col_context", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["col_context", e.RowIndex].EditedFormattedValue.ToString();
string hsort = dgv1["col_sort", e.RowIndex].EditedFormattedValue == null ? "" : dgv1["col_sort", e.RowIndex].EditedFormattedValue.ToString();
hs.htitle = htitle;
hs.hsort = hsort.ToInt();
hs.hcontext = hcontext;
BLL.huashuManager.Update(hs);
//dgv_type.ToClearChecked();
}
}
}
catch (Exception ex)
{
ex.ToLog();
}
}
private void dataGridView_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (!string.IsNullOrEmpty(e.Value.ToString()))
{
data.ChangeData(e.Value.ToString(), e.RowIndex, e.ColumnIndex);
}
}
protected override void OnCellParsing(DataGridViewCellParsingEventArgs e)
{
if (e != null && e.Value != null)
{
if ((this.Columns[e.ColumnIndex].DefaultCellStyle.Tag?.ToString().IndexOf('X') ?? -1) == 0)
{
string value = e.Value.ToString();
if (value.StartsWith("0x"))
{
value = value.Substring(2);
}
long l = 0; ulong u = 0;
if (long.TryParse(value, NumberStyles.HexNumber, null, out l))
{
e.Value = Convert.ChangeType(l, e.DesiredType);
e.ParsingApplied = true;
}
else if (ulong.TryParse(value, NumberStyles.HexNumber, null, out u))
{
e.Value = Convert.ChangeType(u, e.DesiredType);
e.ParsingApplied = true;
}
}
}
else
{
base.OnCellParsing(e);
}
}
/// <summary>
/// 数据明细表的数据填充处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void dgvList_CellParsing(object sender, DataGridViewCellParsingEventArgs e)
{
if (e.Value == null)
{
return;
}
string columnName = ((DataGridView)sender).Columns[e.ColumnIndex].Name;
if (columnName == "StartTime")
{
SetPrice();
}
if (columnName.EndsWith("Price"))
{
try
{
e.Value = decimal.Round(Convert.ToDecimal(e.Value), 1).ToString("0.00");
e.ParsingApplied = true;
}
catch
{
}
}
}
