private void gridList_ClickCell(object sender, ClickCellEventArgs e)
{
// gridList.ActiveRow.Cells["isFaild"].Value = 1;
if (gridList.ActiveRow.Cells["isFaild"].Value.ToString() == "1")
{
gridList.ActiveRow.Cells["isFaild"].Value = 0;
gridList.ActiveRow.Cells["isWaiting"].Value = 0;
gridList.ActiveRow.Cells["isAppointed"].Value = 0;
}
else
{
gridList.ActiveRow.Cells["isPassed"].Value = 0;
gridList.ActiveRow.Cells["isWaiting"].Value = 0;
gridList.ActiveRow.Cells["isAppointed"].Value = 0;
}
//gridList.ActiveRow.Cells["isPassed"].Value = 1;
if (gridList.ActiveRow.Cells["isAppointed"].Value.ToString() == "0")
{
//gridList.ActiveRow.Cells["isAppointed"].Value = 1;
gridList.ActiveRow.Cells["isPassed"].Value = 0;
gridList.ActiveRow.Cells["isFaild"].Value = 0;
gridList.ActiveRow.Cells["isWaiting"].Value = 0;
gridList.ActiveRow.Cells["dtJoin"].Value = DateTime.Today.ToString();
}
else
{
//gridList.ActiveRow.Cells["isPassed"].Value = 1;
}
}
private void UltraGridPodProizvodi_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key.Equals("SEL"))
{
e.Cell.Value = !bool.Parse(e.Cell.Value.ToString());
}
}
private void ugdPredlosciUcenici_ClickCell(object sender, ClickCellEventArgs e)
{
BusinessLogic.Predlosci Predlosci = new BusinessLogic.Predlosci();
if (ugdPredlosciUcenici.DisplayLayout.Bands.Count > 0)
{
if (ugdPredlosciUcenici.DisplayLayout.Bands[0].Columns.Count > 0)
{
ugdPredlosciZaduzeniCjenik.DataSource = Predlosci.NapuniStavkeCjenikZaUcenika((int)ugdPredlosciUcenici.ActiveRow.Cells["ID"].Value);
ugdPredlosciZaduzeniCjenik.DataBind();
ugdPredlosciZaduzeniCjenik.UpdateData();
if (ugdPredlosciZaduzeniCjenik.DisplayLayout.Bands.Count > 0)
{
if (ugdPredlosciZaduzeniCjenik.DisplayLayout.Bands[0].Columns.Count > 0)
{
ugdPredlosciZaduzeniCjenik.DisplayLayout.Bands["Cjenik"].Columns["IDCjenik"].Hidden = true;
ugdPredlosciZaduzeniCjenik.DisplayLayout.Bands["Cjenik_stavka"].Columns["ID"].Hidden = true;
ugdPredlosciZaduzeniCjenik.DisplayLayout.Bands["Cjenik_stavka"].Columns["CjenikID"].Hidden = true;
ugdPredlosciZaduzeniCjenik.Rows.ExpandAll(true);
}
}
}
}
}
private void ugBTS_ClickCell(object sender, ClickCellEventArgs e)
{
int var_auto_id;
string var_status;
int var_tran_id;
string var_from_loc;
string var_to_loc;
string var_from_proj;
string var_to_proj;
DateTime var_tran_date;
string var_part_no;
string var_tran_type;
string var_tran_source;
string var_tran_source_num;
string var_tran_source_line;
string var_serial_num;
int var_qty;
string var_reference;
string var_location;
int var_ponum;
int var_poline;
var_auto_id = 0;
var_ponum = 0;
var_poline = 0;
if (e.Cell.Column.Key == "Save")
{
if (e.Cell.Row.Cells["auto_id"].Value != "" && e.Cell.Row.Cells["auto_id"].Value != null)
{
var_auto_id = Convert.ToInt32(e.Cell.Row.Cells["auto_id"].Value);
}
var_status = e.Cell.Row.Cells["status"].Value.ToString();
var_tran_id = Convert.ToInt32(e.Cell.Row.Cells["tran_id"].Value.ToString());
var_from_loc = e.Cell.Row.Cells["from_loc"].Value.ToString();
var_to_loc = e.Cell.Row.Cells["to_loc"].Value.ToString();
var_from_proj = e.Cell.Row.Cells["from_proj"].Value.ToString();
var_to_proj = e.Cell.Row.Cells["to_proj"].Value.ToString();
var_tran_date = Convert.ToDateTime(e.Cell.Row.Cells["tran_date"].Value.ToString());
var_part_no = e.Cell.Row.Cells["part_no"].Value.ToString();
var_tran_type = e.Cell.Row.Cells["tran_type"].Value.ToString();
var_tran_source = e.Cell.Row.Cells["tran_source"].Value.ToString();
var_tran_source_num = e.Cell.Row.Cells["tran_source_num"].Value.ToString();
var_tran_source_line = e.Cell.Row.Cells["tran_source_line"].Value.ToString();
var_serial_num = e.Cell.Row.Cells["serial_num"].Value.ToString();
var_qty = Convert.ToInt32(e.Cell.Row.Cells["qty"].Value.ToString());
var_reference = e.Cell.Row.Cells["reference"].Value.ToString();
var_location = e.Cell.Row.Cells["location"].Value.ToString();
if (e.Cell.Row.Cells["ponum"].Value != "" && e.Cell.Row.Cells["ponum"].Value != null)
{
var_ponum = Convert.ToInt32(e.Cell.Row.Cells["ponum"].Value.ToString());
}
if (e.Cell.Row.Cells["poline"].Value != "" && e.Cell.Row.Cells["poline"].Value != null)
{
var_poline = Convert.ToInt32(e.Cell.Row.Cells["poline"].Value.ToString());
}
string sqlstr = "exec sp_updateBTS_WB '" + var_auto_id.ToString() + "','" + var_status + "','" + var_tran_id + "','" + var_from_loc + "','" + var_to_loc + "','" + var_from_proj + "','" + var_to_proj + "','" + var_tran_date + "','" + var_part_no + "','" + var_tran_type + "','" + var_tran_source + "','" + var_tran_source_num + "','" + var_tran_source_line + "','" + var_serial_num + "','" + var_qty + "','" + var_reference + "','" + var_location + "','" + var_ponum + "','" + var_poline + "'";
UpdateRow(sqlstr);
}
}
/// <summary>
/// Handles the ClickCell event of the gridInventory control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.ClickCellEventArgs"/> instance containing the event data.</param>
private void gridInventory_ClickCell(object sender, ClickCellEventArgs e)
{
// if the initial delivery grid view currently being shown, show the shipping invoice control when any cell is clicked.
if (this.currentGridData == UI.Delivery)
{
this.DisplayShippingInvoice((string)e.Cell.Row.Cells["DataKey"].Value);
return;
}
}
protected override void OnClickCell(ClickCellEventArgs e)
{
if ((ModifierKeys & Keys.Control) != 0)
{
_selectedRows.Add(e.Cell.Row);
RedrawSelectedRow(null, null);
}
base.OnClickCell(e);
}
private void ugEntity_ClickCell(object sender, ClickCellEventArgs e)
{
switch (e.Cell.Column.Key)
{
case "Select":
e.Cell.Value = !Convert.ToBoolean(e.Cell.Value);
break;
default: break;
}
}
private void ugvDatos_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key == "Envio")
{
string _Estatus = Convert.IsDBNull((sender as UltraGrid).Rows[e.Cell.Row.Index].Cells["Estatus"].Value) ? "" :
Convert.ToString((sender as UltraGrid).Rows[e.Cell.Row.Index].Cells["Estatus"].Value);
if (_Estatus != "EN PROCESO DE AUTORIZACION")
{
e.Cell.Value = false;
}
}
}
private void grdRegionOption_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Index == 6)
{
if (e.Cell.Row.Cells["OptionPN"].Value.ToString() != "")
{
DeleteRowDataBase(e.Cell.Row.Cells["OptionPN"].Value.ToString());
}
this.grdRegionOption.Rows[e.Cell.Row.Index].Delete();
}
}
private void uGridRawMaterial_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Row.Index < 0)
{
return;
}
if (biSave.Enabled)
{
MessageBox.Show(@"在编辑状态下，不允许选择！");
return;
}
SetPanelVlaue(e.Cell.Row.Cells["AutoID"].Value.ToString());
}
private void grdData_ClickCell(object sender, ClickCellEventArgs e)
{
if ((e.Cell.Column.Key == "Select"))
{
if ((e.Cell.Value.ToString() == "False"))
{
e.Cell.Value = true;
}
else
{
e.Cell.Value = false;
}
}
}
/// <summary>
/// Handles the ClickCell event of the BottomSnapshotOperationGrid control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.ClickCellEventArgs"/> instance containing the event data.</param>
private void BottomSnapshotOperationGrid_ClickCell(object sender, ClickCellEventArgs e)
{
if (this.BottomSnapshotOperationGrid.Rows.Count > 0)
{
if (BottomSnapshotOperationGrid.ActiveRow != null)
{
if (this.BottomSnapshotOperationGrid.ActiveRow.Index >= 0)
{
this.BottomSnapshotOperationGrid.Rows[this.BottomSnapshotOperationGrid.ActiveRow.Index].Selected = true;
this.BottomSnapshotOperationGrid.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.RowSelect;
}
}
}
}
/// <summary>
/// Grid单击单元格事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gdGrid_ClickCell(object sender, ClickCellEventArgs e)
{
var curActiveRow = gdGrid.Rows[e.Cell.Row.Index];
if (curActiveRow != null)
{
//当前领料明细
_curInventory = ListGridDS.FirstOrDefault(x => x.INV_Barcode == curActiveRow.Cells[SystemTableColumnEnums.PIS_Inventory.Code.INV_Barcode].Value.ToString());
}
//加载配件图片
LoadAutoPartsPicture(_curInventory);
//展开【配件图片】GroupBox
gbPicture.Expanded = true;
}
private void grdDataService_ClickCell(object sender, ClickCellEventArgs e)
{
if ((e.Cell.Column.Key == "Seleccion"))
{
if ((e.Cell.Value.ToString() == "False"))
{
e.Cell.Value = true;
//btnAgregarFacturacion.Enabled = true;
}
else
{
e.Cell.Value = false;
//btnAgregarFacturacion.Enabled = false;
}
}
}
private void ugdZaduzenje_ClickCell(object sender, ClickCellEventArgs e)
{
if (ugdZaduzenje.DisplayLayout.Bands.Count > 0)
{
if (ugdZaduzenje.DisplayLayout.Bands[0].Columns.Count > 0)
{
if (ugdZaduzenje.ActiveRow.Band.ToString() == "OdabraneOsobe")
{
lblOpcinaPrebivalista.Text = LoadNazivOpcine(ugdZaduzenje.ActiveRow.Cells["ID_Opcina"].Value.ToString());
lblOIB.Text = ugdZaduzenje.ActiveRow.Cells["OIB"].Value.ToString();
uneIznos.Value = ugdZaduzenje.ActiveRow.Cells["Iznos"].Value;
ucbNacinIsplate.Value = ugdZaduzenje.ActiveRow.Cells["ID_NacinIsplate"].Value;
NapuniPrikaz();
}
}
}
}
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key == "checked")
{
if (!Convert.ToBoolean(e.Cell.Value))
{
e.Cell.Value = "True";
}
else
{
e.Cell.Value = "FALSE";
}
if (ultraGrid1.Rows.Count > 0)
{
ultraGrid1.Rows[e.Cell.Row.Index].Cells[2].Activated = true;
}
}
}
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
//listaPets1
//object obj1 = this.ultraGrid1.ActiveRow.GetCellValue(1); //GetCellText();
string indexColumna = Convert.ToString(e.Cell.Column.Index);
int indexColumnaInt = e.Cell.Column.Index;
int indexRow = e.Cell.Row.Index;
UltraGridRow row = this.ultraGrid1.Rows[1];
UltraGridColumn column = this.ultraGrid1.DisplayLayout.Bands[0].Columns[1];
Infragistics.Win.UltraWinGrid.UltraGridColumn ugc = new Infragistics.Win.UltraWinGrid.UltraGridColumn("PetID");
#region getSetQue funcionan
//Obtiene valor de la celda selecionada convertiendolo en String
//object obj4 = ultraGrid1.Rows[indexRow].Cells[indexColumnaInt].Text;
//Obtiene valor de la celda selecionada en su tipoValor (cuidado fecha)
//object obj5 = ultraGrid1.Rows[indexRow].Cells[indexColumnaInt].Value;//.ToString(); //repasar
http: //help.infragistics.com/Help/Doc/WinForms/2012.1/CLR2.0/html/Infragistics2.Win.UltraWinGrid.v12.1~Infragistics.Win.UltraWinGrid.UltraGridRow~GetCellValue(UltraGridColumn).html
#endregion
object obj1 = ultraGrid1.Rows[indexRow].Cells[indexColumnaInt].Text;
object obj2 = ultraGrid1.Selected.Cells.GetItem(indexColumnaInt);
listaPets1 = (from p in db.PET select p).ToList();
PET[] arrayPet = listaPets1.ToArray();
//recoger todo el valor de fila
//PET pet = arrayPet[indexColumnaInt];
//int indexFila =
string msg = String.Format("Clicked on the cell at row index {0} and column index {1} obj1: {2} , obj1: {3}",
e.Cell.Row.Index, e.Cell.Column.Index, obj1, obj2);
lbDueño.Text = msg;
//MessageBox.Show(msg);
}
private void dgvDatos1_ClickCell(object sender, ClickCellEventArgs e)
{
try
{
if (e.Cell.Column.Key == "Elegido")
{
int fila = e.Cell.Row.Index;
for (int i = 0; i < dgvDatos1.Rows.Count; i++)
{
dgvDatos1.Rows[i].Cells["Elegido"].Value = false;
}
dgvDatos1.Rows[fila].Cells["Elegido"].Value = true;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message.ToString());
}
}
private void uG_DanhSach_ClickCell(object sender, ClickCellEventArgs e)
{
try
{
if (e.Cell.Column.Key != "TT")
{
return;
}
if (string.IsNullOrEmpty(e.Cell.Row.Cells["ID"].Text))
{
return;
}
if (bool.Parse(e.Cell.Row.Cells["TrangThai"].Text))
{
e.Cell.Value = "Ẩn";
e.Cell.Row.Cells["TrangThai"].Value = false;
var hs = new Kythi
{
ID = int.Parse(e.Cell.Row.Cells["ID"].Text),
TrangThai = false
};
UpdateData.UpdateTrangThaiKt(hs);
}
else
{
e.Cell.Value = "Hiển thị";
e.Cell.Row.Cells["TrangThai"].Value = true;
var hs = new Kythi
{
ID = int.Parse(e.Cell.Row.Cells["ID"].Text),
TrangThai = true
};
UpdateData.UpdateTrangThaiKt(hs);
}
Updatekythi(sender);
}
catch (Exception ex)
{
Log2File.LogExceptionToFile(ex);
}
}
private void grdData_ClickCell(object sender, ClickCellEventArgs e)
{
if ((e.Cell.Column.Key != "select"))
{
return;
}
var protocolId = grdData.Rows[e.Cell.Row.Index].Cells["v_ProtocolId"].Value;
var rowChange = _protocolsOld.Find(p => p.v_ProtocolId == protocolId);
if ((e.Cell.Value.ToString() == "False"))
{
e.Cell.Value = true;
rowChange.i_RecordStatus = (int)RecordStatus.Agregado;
}
else
{
e.Cell.Value = false;
rowChange.i_RecordStatus = (int)RecordStatus.EliminadoLogico;
}
}
private void gridFlowLists_ClickCell(object sender, ClickCellEventArgs e)
{
e.Cell.Row.Selected = true;
this.Refresh();
System.Threading.Thread.Sleep(250);
this.gridSamples.Visible = true;
this.gridFlowLists.Visible = false;
FlowTubeList ftl = e.Cell.Row.ListObject as FlowTubeList;
if (ProceedWithListLoad(ftl))
{
this.SetFlowTubeList(ftl);
SetCurrentSampleIndex(0);
CurrentStatus = Status.ManifestInProgress;
}
else
{
CurrentStatus = Status.PendingManifest;
SetBaselineMessage();
}
}
private void grdData_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key == "Select")
{
if (e.Cell.Value.ToString() == "False")
{
e.Cell.Value = true;
var rowIndex = e.Cell.Row.Index;
var total = decimal.Parse(grdData.Rows[rowIndex].Cells["Total"].Text);
txtTotalPagar.Text = (decimal.Parse(txtTotalPagar.Text) + total).ToString();
e.Cell.Activated = false;
}
else
{
e.Cell.Value = false;
var rowIndex = e.Cell.Row.Index;
var total = decimal.Parse(grdData.Rows[rowIndex].Cells["Total"].Text);
txtTotalPagar.Text = (decimal.Parse(txtTotalPagar.Text) - total).ToString();
e.Cell.Activated = false;
}
}
}
/// <summary>
/// Handles the ClickCell event of the SnapshotoperationTopGrid control.
/// </summary>
/// <param name="sender">The source of the event.</param>
/// <param name="e">The <see cref="Infragistics.Win.UltraWinGrid.ClickCellEventArgs"/> instance containing the event data.</param>
private void SnapshotoperationTopGrid_ClickCell(object sender, ClickCellEventArgs e)
{
if (this.SnapshotoperationTopGrid.Rows.Count > 0)
{
if (this.SnapshotoperationTopGrid.ActiveRow != null)
{
if (this.SnapshotoperationTopGrid.ActiveRow.Index >= 0)
{
this.SnapshotoperationTopGrid.Rows[this.SnapshotoperationTopGrid.ActiveRow.Index].Selected = true;
SnapshotoperationTopGrid.DisplayLayout.Override.CellClickAction = Infragistics.Win.UltraWinGrid.CellClickAction.RowSelect;
}
}
if (SnapshotoperationTopGrid.Selected.Rows.Count > 0)
{
UltraGridRow dr = this.SnapshotoperationTopGrid.Selected.Rows[0];
if (dr != null)
{
int index = dr.Index;
LOSnapshotId = Convert.ToInt32(dr.Cells["SnapshotID"].Value);
}
}
}
}
private void ugEntity_ClickCell(object sender, ClickCellEventArgs e)
{
switch (e.Cell.Column.Key)
{
case "Select":
e.Cell.Value = !Convert.ToBoolean(e.Cell.Value);
break;
default: break;
}
}
void gridClickCell(object sender, ClickCellEventArgs e)
{
_currentCell = e.Cell;
}
private void ugBTS_ClickCell(object sender, ClickCellEventArgs e)
{
int var_MTid = 0;
DateTime var_tranxDate;
string var_trxType = "";
string var_fromLoc = "";
string var_toLoc = "";
string var_fromProj = "";
string var_toProj = "";
string var_partNo = "";
int var_qty = 0;
string var_BBNUM = "";
string var_MTNO = "";
string var_shipMethod = "";
string var_comments = "";
string var_filename = "";
string var_Status = "";
string var_int_dep = "";
int var_MTLineNo = 0;
string var_requestor = "";
string var_shipTerms = "";
DateTime var_requestDate = new DateTime(1900, 1, 1);
string var_KanBan_PO_recv = "";
string var_app = "";
string var_KBBin = "";
string var_resent = "";
DateTime var_EDITranDate = new DateTime(1900, 1, 1);
DateTime var_EDITime = new DateTime(1900, 1, 1);
string var_EDITimeCode = "";
string var_EDIStatus = "";
DateTime var_EDICreateDate = new DateTime(1900, 1, 1);
string var_EDIDocument = "";
string var_EDIICN = "";
string var_currencyCode = "";
string var_Plant = "";
string sqlstr = "";
if (e.Cell.Column.Key == "Save")
{
if (e.Cell.Row.Cells["mtid"].Value != "" && e.Cell.Row.Cells["mtid"].Value != null)
{
var_MTid = Convert.ToInt32(e.Cell.Row.Cells["mtid"].Value);
}
var_Status = e.Cell.Row.Cells["status"].Value.ToString();
var_fromLoc = e.Cell.Row.Cells["fromLoc"].Value.ToString();
var_toLoc = e.Cell.Row.Cells["toLoc"].Value.ToString();
var_fromProj = e.Cell.Row.Cells["fromProj"].Value.ToString();
var_toProj = e.Cell.Row.Cells["toProj"].Value.ToString();
var_tranxDate = Convert.ToDateTime(e.Cell.Row.Cells["tranxDate"].Value.ToString());
var_partNo = e.Cell.Row.Cells["partNo"].Value.ToString();
var_trxType = e.Cell.Row.Cells["trxType"].Value.ToString();
var_BBNUM = e.Cell.Row.Cells["BBNUM"].Value.ToString();
var_comments = e.Cell.Row.Cells["comments"].Value.ToString();
var_int_dep = e.Cell.Row.Cells["int_dep"].Value.ToString();
var_requestor = e.Cell.Row.Cells["requestor"].Value.ToString();
var_shipTerms = e.Cell.Row.Cells["shipTerms"].Value.ToString();
try
{
var_requestDate = Convert.ToDateTime(e.Cell.Row.Cells["requestDate"].Value.ToString());
}
catch { }
var_KanBan_PO_recv = e.Cell.Row.Cells["KanBan_PO_recv"].Value.ToString();
var_app = e.Cell.Row.Cells["app"].Value.ToString();
var_KBBin = e.Cell.Row.Cells["KBBin"].Value.ToString();
var_resent = e.Cell.Row.Cells["resent"].Value.ToString();
try
{
var_EDITranDate = Convert.ToDateTime(e.Cell.Row.Cells["EDITranDate"].Value.ToString());
}
catch { }
try
{
var_EDITime = Convert.ToDateTime(e.Cell.Row.Cells["EDITime"].Value.ToString());
}
catch { }
var_EDITimeCode = e.Cell.Row.Cells["EDITimeCode"].Value.ToString();
var_EDIStatus = e.Cell.Row.Cells["EDIStatus"].Value.ToString();
try
{
var_EDICreateDate = Convert.ToDateTime(e.Cell.Row.Cells["EDICreateDate"].Value.ToString());
}
catch { }
var_EDIDocument = e.Cell.Row.Cells["EDIDocument"].Value.ToString();
var_EDITimeCode = e.Cell.Row.Cells["EDITimeCode"].Value.ToString();
var_EDIICN = e.Cell.Row.Cells["EDIICN#"].Value.ToString();
var_currencyCode = e.Cell.Row.Cells["currencyCode"].Value.ToString();
var_Plant = e.Cell.Row.Cells["Plant"].Value.ToString();
if (var_MTid == 0)
{
sqlstr = "insert into [IntegrationMTRequest] ([tranxDate] ,[trxType] ,[fromLoc] ,[toLoc] ,[fromProj] ,[toProj] ,[partNo] ,[qty] ,[BBNUM] ,[MTNO] ,[shipMethod] ,[comments] ,[Status] ,[int_dep] ,[MTLineNo] ,[requestor] ,[shipTerms] ,[requestDate] ,[KanBan_PO_recv] ,[app] ,[KBBin] ,[resent] ,[EDITranDate] ,[EDITime] ,[EDITimeCode] ,[EDIStatus] ,[EDICreateDate] ,[EDIDocument] ,[EDIICN#] ,[currencyCode] ,[Plant]) values ( '" + var_tranxDate + "','" + var_trxType + "','" + var_fromLoc + "','" + var_toLoc + "','" + var_fromProj + "','" + var_toProj + "','" + var_partNo + "','" + var_qty + "','" + var_BBNUM + "','" + var_MTNO + "','" + var_shipMethod + "','" + var_comments + "','" + var_Status + "','" + var_int_dep + "','" + var_MTLineNo + "','" + var_requestor + "','" + var_shipTerms + "','" + var_requestDate + "','" + var_KanBan_PO_recv + "','" + var_app + "','" + var_KBBin + "','" + var_resent + "','" + var_EDITranDate + "','" + var_EDITime + "','" + var_EDITimeCode + "','" + var_EDIStatus + "','" + var_EDICreateDate + "','" + var_EDIDocument + "','" + var_EDIICN + "','" + var_currencyCode + "','" + var_Plant + "')";
}
else
{
sqlstr = "update [IntegrationMTRequest] set status='" + var_Status + "' where [MTID]=" + var_MTid;
}
UpdateRow(sqlstr);
}
}
private void ultraGrid5_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key.ToUpper() != "FS_VOICENAME" || e.Cell.Value.ToString().Length == 0)
{
return;
}
this.Cursor = Cursors.WaitCursor;
if (m_iSelectedPound < 0)
{
MessageBox.Show("请先选择一个计量点！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Cursor = Cursors.Default;
return;
}
if (ultraGrid5.Rows.Count <= 0)
{
MessageBox.Show("还没有声音文件，请添加声音文件！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Cursor = Cursors.Default;
return;
}
int i = m_iSelectedPound;
//if (m_PoundRoomArray[i].VideoRecord == null)
//{
// MessageBox.Show("硬盘录像机未连接，不能发送语音！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
// return;
//}
if (i < 0 || m_PoundRoomArray == null || m_PoundRoomArray[i] == null)
{
this.Cursor = Cursors.Default;
return;
}
if (m_PoundRoomArray[i].Signed != true)//未接管的计量点
{
this.Cursor = Cursors.Default;
return;
}
if (m_PoundRoomArray[i].VIEDOIP == null || m_PoundRoomArray[i].VIEDOIP.Trim().Length == 0)//未接管的计量点
{
this.Cursor = Cursors.Default;
return;
}
if (m_PoundRoomArray[i].VideoRecord == null || m_PoundRoomArray[i].VideoHandle <= 0)
{
this.Cursor = Cursors.Default;
return;
}
if (m_PoundRoomArray[i].Talk == true && m_PoundRoomArray[i].TalkID > 0)
{
m_PoundRoomArray[i].VideoRecord.SDK_StopRealPlay(m_iSelectedPound);
m_PoundRoomArray[i].VideoRecord.SDK_StopTalk();
m_PoundRoomArray[i].TalkID = 0;
m_PoundRoomArray[i].Talk = false;
ultraToolbarsManager1.Toolbars[0].Tools["YYDJ"].SharedProps.Caption = "打开对讲";
}
FileInfo fi = new FileInfo(Constant.RunPath + "\\sound\\" + ultraGrid5.ActiveRow.Cells["FS_VOICENAME"].Value.ToString().Trim());
int waveTimeLen = Convert.ToInt32((fi.Length - 54) / 16 + 500);
if (m_PoundRoomArray[i].AUDIONUM > 0)
{
m_PoundRoomArray[i].AUDIONUM = 0;
int reVal = m_PoundRoomArray[i].VideoRecord.SDK_SendData(Constant.RunPath + "\\sound\\" + ultraGrid5.ActiveRow.Cells["FS_VOICENAME"].Value.ToString().Trim());
Thread.Sleep(waveTimeLen);
if (reVal <= 0 && m_PoundRoomArray[m_iSelectedPound].ISFIRSTSEND == false)
reBootVideo();
m_PoundRoomArray[m_iSelectedPound].ISFIRSTSEND = false;
m_PoundRoomArray[i].AUDIONUM = 1;
}
this.Cursor = Cursors.Default;
txtYKL.Focus();
}
private void ugBTS_ClickCell(object sender, ClickCellEventArgs e)
{
int var_auto_id;
string var_status;
int var_tran_id;
string var_from_loc;
string var_to_loc;
string var_from_proj;
string var_to_proj;
DateTime var_tran_date;
DateTime var_utc_date;
string var_part_no;
string var_tran_type;
string var_tran_source;
string var_tran_source_num;
string var_tran_source_line;
string var_serial_num;
int var_qty;
string var_reference;
string var_location;
string var_ponum;
int var_poline;
string var_EDIStatus;
var_auto_id = 0;
var_ponum = "";
var_poline = 0;
if (e.Cell.Column.Key == "Save")
{
if (e.Cell.Row.Cells["autoid"].Value.ToString() != "" && e.Cell.Row.Cells["autoid"].Value != null)
{
var_auto_id = Convert.ToInt32(e.Cell.Row.Cells["autoid"].Value);
}
var_status = "N";
var_tran_id = Convert.ToInt32(e.Cell.Row.Cells["tranid"].Value.ToString());
var_from_loc = e.Cell.Row.Cells["fromloc"].Value.ToString();
var_to_loc = e.Cell.Row.Cells["toloc"].Value.ToString();
var_from_proj = e.Cell.Row.Cells["fromproj"].Value.ToString();
var_to_proj = e.Cell.Row.Cells["toproj"].Value.ToString();
var_tran_date = Convert.ToDateTime(e.Cell.Row.Cells["trandate"].Value.ToString());
var_utc_date = Convert.ToDateTime(e.Cell.Row.Cells["utcdate"].Value.ToString());
var_part_no = e.Cell.Row.Cells["partno"].Value.ToString();
var_tran_type = "MATERIAL RECEIPT";
var_tran_source = "MT";
var_tran_source_num = e.Cell.Row.Cells["transourcenum"].Value.ToString();
var_tran_source_line = e.Cell.Row.Cells["transourceline"].Value.ToString();
var_serial_num = "";
var_qty = Convert.ToInt32(e.Cell.Row.Cells["qty"].Value.ToString());
var_reference = e.Cell.Row.Cells["Reference"].Value.ToString();
var_location = e.Cell.Row.Cells["Plant"].Value.ToString();
var_EDIStatus = e.Cell.Row.Cells["EDIStatus"].Value.ToString();
//if (e.Cell.Row.Cells["PoNum"].Value.ToString() != "" && e.Cell.Row.Cells["PoNum"].Value != null)
var_ponum = e.Cell.Row.Cells["PoNum"].Value.ToString();
if (e.Cell.Row.Cells["PoLine"].Value.ToString() != "" && e.Cell.Row.Cells["PoLine"].Value != null)
{
var_poline = Convert.ToInt32(e.Cell.Row.Cells["PoLine"].Value.ToString());
}
string sqlstr = "exec [sp_updateBTSForMR] '" + var_auto_id.ToString() + "','" + var_status + "','" + var_tran_id + "','" + var_from_loc + "','" + var_to_loc + "','" + var_from_proj + "','" + var_to_proj + "','" + var_tran_date + "','" + var_part_no + "','" + var_tran_type + "','" + var_tran_source + "','" + var_tran_source_num + "','" + var_tran_source_line + "','" + var_serial_num + "','" + var_qty + "','" + var_reference + "','" + var_location + "','0','0','" + var_EDIStatus + "','" + var_utc_date + "'";
UpdateRow(sqlstr);
}
}
private void ultraGrid4_ClickCell_1(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key.ToUpper() != "FS_VOICENAME" || e.Cell.Value.ToString().Length == 0)
{
return;
}
//this.Cursor = Cursors.WaitCursor;
if (m_iSelectedPound < 0)
{
MessageBox.Show("请先选择一个计量点！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Cursor = Cursors.Default;
return;
}
if (ultraGrid5.Rows.Count <= 0)
{
MessageBox.Show("还没有声音文件，请添加声音文件！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
this.Cursor = Cursors.Default;
return;
}
int i = m_iSelectedPound;
if (i < 0 || _measApp == null || _measApp.Dvr == null || string.IsNullOrEmpty(_measApp.Params.FS_VIEDOIP))
{
this.Cursor = Cursors.Default;
return;
}
//if (m_PoundRoomArray[i].Signed != true)//未接管的计量点
//{
// this.Cursor = Cursors.Default;
// return;
//}
if (_isTalk && _talkId > 0)
{
_measApp.Dvr.SDK_StopRealPlay(_measApp.VideoChannel[0]);
_measApp.Dvr.SDK_StopTalk();
_talkId = 0;
_isTalk = false;
ultraToolbarsManager1.Toolbars[0].Tools["YYDJ"].SharedProps.Caption = "打开对讲";
}
System.IO.FileInfo fi = new System.IO.FileInfo(Constant.RunPath + "\\rksound\\" + ultraGrid5.ActiveRow.Cells["FS_VOICENAME"].Value.ToString().Trim());
int waveTimeLen = Convert.ToInt32((fi.Length - 54) / 16 + 500);
_measApp.Dvr.SDK_SendData(Constant.RunPath + "\\rksound\\" + ultraGrid5.ActiveRow.Cells["FS_VOICENAME"].Value.ToString().Trim());
System.Threading.Thread.Sleep(waveTimeLen);
txtDDH.Focus();
}
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key == "checked")
{
if (!Convert.ToBoolean(e.Cell.Value))
{
e.Cell.Value = "True";
}
else
{
e.Cell.Value = "FALSE";
}
if (ultraGrid1.Rows.Count > 0)
{
ultraGrid1.Rows[e.Cell.Row.Index].Cells[2].Activated = true;
}
}
}
private void uDridSound_ClickCell(object sender, ClickCellEventArgs e)
{
if (uDridSound.ActiveRow.Index < 0) return;
//&&Ҫ��&&
this.Cursor = Cursors.WaitCursor;
if (isTalk == 1)
{
RecordClose(0);
}
int waveTimeLen = 2000;
FileInfo fi;
switch (uDridSound.ActiveRow.Index)
{
case 0:
m_PoundRoomArray[0].VideoRecord.SDK_SendData(m_szRunPath + "\\qcsound\\�������.wav");
fi = new FileInfo(m_szRunPath + " \\qcsound\\�������.wav");
waveTimeLen = Convert.ToInt32((fi.Length - 54) / 16 + 500);
break;
case 1:
m_PoundRoomArray[0].VideoRecord.SDK_SendData(m_szRunPath + "\\sound\\�����.wav");
fi = new FileInfo(m_szRunPath + " \\sound\\�����.wav");
waveTimeLen = Convert.ToInt32((fi.Length - 54) / 16 + 500);
break;
case 2:
m_PoundRoomArray[0].VideoRecord.SDK_SendData(m_szRunPath + "\\sound\\��ǰ��.wav");
fi = new FileInfo(m_szRunPath + " \\sound\\��ǰ��.wav");
waveTimeLen = Convert.ToInt32((fi.Length - 54) / 16 + 500);
break;
}
System.Threading.Thread.Sleep(waveTimeLen);
this.Cursor = Cursors.Default;
}
private void ugDistritos_ClickCell(object sender, ClickCellEventArgs e)
{
MostrarItem(e.Cell.Row);
}
private void listaAppello_ClickCell(object sender, ClickCellEventArgs e)
{
//if (e.Cell.Column.Key == "PresenteAssente")
//{
// setRiepilogoPresenti();
// if (e.Cell.Text.ToUpper() == "TRUE")
// e.Cell.Row.Cells["Delegato"].Activation = Activation.AllowEdit;
// else
// e.Cell.Row.Cells["Delegato"].Activation = Activation.NoEdit;
//}
}
private void ultraGrid2_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Column.Key == "FS_POINTNAME")
{
ultraGrid2.ActiveRow.Selected = true;
}
}
private void ugDistritos_ClickCell(object sender, ClickCellEventArgs e)
{
MostrarItem(e.Cell.Row);
}
/// <summary>
/// This only handles event clicks
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void grdMachine_ClickCell(object sender, ClickCellEventArgs e)
{
if(e.Cell.Column.Header.Caption.ToUpper() == "EVENTS")
{
// Load the proper transition, highlight it's matrix position, show transition info in left panel
var currentMode = StatusManager.CurrentState.Mode;
var currentState = StatusManager.CurrentState.State;
var currentEvent = e.Cell.Text;
var transition = DataHelper.GetTransition(currentEvent, currentState, currentMode);
if(transition.TransitionName == "Ignored")
{
MessageBox.Show("No associated transition - will be ignored!", "Event - " + currentEvent,
MessageBoxButtons.OK);
}
else // Setup this transition for processing
{
// Load Ordered Functions List
// Get params for first function
// Highlight 1st function
var firstFunction = SetUpTransitionToRun(transition, StatusManager.CurrentState, currentEvent);
btnTransition.Enabled = firstFunction != null;
if (btnTransition.Enabled)
{
var parameters = transition.EventParams();
EnterEventParams(parameters, transition);
if(chkRunImmediate.Checked)
{
TheMachine.ProcessEvent();
}
}
else
{
MessageBox.Show("No associated functions - will be ignored!", "Event - " + currentEvent,
MessageBoxButtons.OK);
}
}
}
}
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
SetData();
}
private void ultraGrid3_ClickCell(object sender, ClickCellEventArgs e)
{
this.txtQYR.Text = this.UserInfo.GetUserName();
this.txtQYSJ.Text = ultraGrid3.ActiveRow.Cells["fd_sampletime"].Text.Trim().ToString();//
this.txtConfirm.Text = ultraGrid3.ActiveRow.Cells["fs_sampleflag"].Text.Trim().ToString();
this.txtXHR.Text = this.UserInfo.GetUserName();
this.txtXHSJ.Text = ultraGrid3.ActiveRow.Cells["fd_unloadtime"].Text.Trim().ToString();
this.txtXHQR.Text = ultraGrid3.ActiveRow.Cells["fs_unloadflag"].Text.Trim().ToString();
this.txtweightno.Text = ultraGrid3.ActiveRow.Cells["fs_weightno"].Text.Trim().ToString();
this.txtKZR.Text = this.UserInfo.GetUserName();
this.txtYKL.Text = ultraGrid3.ActiveRow.Cells["fs_ykl"].Text.Trim().ToString();
this.txtYKBL.Text = ultraGrid3.ActiveRow.Cells["fs_ykbl"].Text.Trim().ToString();
this.txtCarEditNo.Text = ultraGrid3.ActiveRow.Cells["fs_carno"].Text.Trim().ToString();
this.txtKHJZ.Text = ultraGrid3.ActiveRow.Cells["fn_weight"].Text.Trim().ToString();
this.txtMemoXiehuo.Text = ultraGrid3.ActiveRow.Cells["fs_unloadmemo"].Text.Trim().ToString();
}
private void grdMultiquotaSchemes_ClickCell(object sender, ClickCellEventArgs e)
{
this.LoadSegmentsGrid();
}
private void ultraGrid1_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Row.Expanded)
{
e.Cell.Row.CollapseAll();
}
else
{
e.Cell.Row.ExpandAll();
}
}
private void ultraGridScrutiny_ClickCell(object sender, ClickCellEventArgs e)
{
try
{
if (e.Cell.Column.Key == "Docname")
{
if (_documentFacade == null)
{
_documentFacade = new DocumentFacade(this.DataProvider);
}
bool right = _documentFacade.GetDocDirRight(int.Parse(e.Cell.Row.Cells[1].Value.ToString()), ApplicationService.Current().UserCode, "QUERY");
Doc doc = _documentFacade.GetDOC(int.Parse(e.Cell.Row.Cells[0].Value.ToString())) as Doc;
if (right)
{
if (doc.Checkedstatus == "Y" && doc.Validstatus == "Y")
{
if (_facade == null)
{
_facade = new SystemSettingFacade(this.DataProvider);
}
object parameter = _facade.GetParameter("PUBLISHDOCDIRPATH", "PUBLISHDOCDIRPATHGROUP");
if (parameter != null)
{
//发布服务器目录路径
string filePath = ((Domain.BaseSetting.Parameter)parameter).ParameterAlias;
if (filePath.LastIndexOf('/') == filePath.Length - 1)
{
filePath = filePath.Substring(0, filePath.Length - 1);
}
#region//下载文件
if (e.Cell.Row.Cells[20].Value.ToString().Trim() != string.Empty)
{
//服务器文件名
string fileName = e.Cell.Row.Cells[20].Value.ToString();
System.Diagnostics.Process.Start(filePath + "/" + fileName + "?tmp=" + (new System.Random()).Next(1000000).ToString());
}
else
{
ApplicationRun.GetInfoForm().Add(new UserControl.Message(MessageType.Normal, "$Error_QueryFile_NotExist"));
}
#endregion
}
else
{
ApplicationRun.GetInfoForm().Add(new UserControl.Message(MessageType.Normal, "$Error_PublishDocDirPath_NotExist"));
}
}
else
{
ApplicationRun.GetInfoForm().Add(new UserControl.Message(MessageType.Normal, "$Error_FileIsNotCheckedOrValid"));
}
}
else
{
ApplicationRun.GetInfoForm().Add(new UserControl.Message(MessageType.Normal, "$Error_HaveNoRightToDownload"));
}
}
}
catch (Exception ex)
{
ApplicationRun.GetInfoForm().Add(new UserControl.Message(MessageType.Error, "$Error_QueryFile_Exception"));
}
}
private void uGridRawMaterial_ClickCell(object sender, ClickCellEventArgs e)
{
if (e.Cell.Row.Index < 0)
return;
if (biSave.Enabled)
{
MessageBox.Show(@"在编辑状态下，不允许选择！");
return;
}
SetPanelVlaue(e.Cell.Row.Cells["AutoID"].Value.ToString());
}
