public void OnDeleteCommandExecute(object obj) { string role_id = ""; try { System.Data.DataRow dataRow = ((System.Data.DataRowView)_colView.CurrentItem).Row; role_id = dataRow["role_id"].ToString(); dataRow.Delete(); } catch { } try { DataTable dt = roleEventData.employee_role_event; //posParamData.pos_param; foreach (DataRow dr in dt.Rows) { if (string.Equals(dr["role_id"].ToString(), role_id)) { dr.Delete(); } } } catch { } }
private void get_gd_cc(DataSet v_ds_gdd, ref decimal v_count, DataRow v_data_row, ref int v_int_khong_nhap_duoc, DataRow v_dt_r) { DataRow v_dt_gdd = v_ds_gdd.Tables[0].Rows[0]; decimal v_id_gdd = CIPConvert.ToDecimal(v_dt_gdd["ID"].ToString()); US_GD_CHUNG_CHI v_us_gdcc = new US_GD_CHUNG_CHI(); v_us_gdcc.dcID_GD_DIEM = v_id_gdd; v_us_gdcc.strSO_CHUNG_CHI = v_data_row["SO_CHUNG_CHI"].ToString(); v_us_gdcc.datNGAY_CAP = (DateTime)v_data_row["NGAY_CAP"]; v_us_gdcc.datNGAY_BAT_DAU = (DateTime)v_data_row["NGAY_BAT_DAU"]; if (v_data_row["NGAY_KET_THUC"].ToString() == "") { v_us_gdcc.IsNGAY_KET_THUCNull(); } else { v_us_gdcc.datNGAY_KET_THUC = (DateTime)v_data_row["NGAY_KET_THUC"]; } v_us_gdcc.datNGAY_LAP = DateTime.Now.Date; v_us_gdcc.datNGAY_SUA = DateTime.Now.Date; v_us_gdcc.strDA_XOA = "N"; try { v_us_gdcc.Insert(); v_data_row.Delete(); v_count++; } catch (Exception) { MessageBox.Show("Chứng chỉ "+ v_us_gdcc.strSO_CHUNG_CHI+ " đã tồn tại. Vui lòng kiểm tra lại thông tin!"); v_int_khong_nhap_duoc++; } }
public void OnDeleteCommandExecute(object obj) { int deleteConfigNo = 0; try { System.Data.DataRow dataRow = ((System.Data.DataRowView)_colView.CurrentItem).Row; deleteConfigNo = int.Parse(dataRow["config_no"].ToString()); dataRow.Delete(); } catch { } try { DataTable dt = posParamData.pos_param; foreach (DataRow dr in dt.Rows) { if (int.Parse(dr["config_no"].ToString()) == deleteConfigNo) { dr.Delete(); } } } catch { } }
public static Boolean DeleteDrinkTypeRow(DataRow drinkTypeRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_rodzaju_napoju == (drinkTypeRow as HurtowniaNapojowDataSet.RodzajeNapojuRow).Identyfikator); if (productExists) { MessageBox.Show("Do wybranego rodzaju napoju '" + (drinkTypeRow as HurtowniaNapojowDataSet.RodzajeNapojuRow).NazwaRodzajuNapoju + "' są przypisane napoje producenta. Rodzaj napoju nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } drinkTypeRow.Delete(); return DrinkTypeTableAdapter.Update(drinkTypeRow) == 1; }
public static Boolean DeleteCustomerRow(DataRow customerRow) { var shoppingExists = DataBaseShoppingHelper.GetShoppingData().Any(shopping => shopping.id_klienta == (customerRow as HurtowniaNapojowDataSet.KlienciRow).Identyfikator); if (shoppingExists) { MessageBox.Show("Do wybranego klienta '" + (customerRow as HurtowniaNapojowDataSet.KlienciRow).NazwaKlienta + "' są przypisane zakupy klienta. Klient nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } customerRow.Delete(); return CustomerTableAdapter.Update(customerRow) == 1; }
public static Boolean DeletePiecePackageRow(DataRow piecePackageRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_opakowania_sztuki == (piecePackageRow as HurtowniaNapojowDataSet.OpakowaniaSztukiRow).Identyfikator); if (productExists) { HurtowniaNapojowDataSet.NazwyOpakowaniaSztukiRow tempPiecePackageName = DataBasePiecePackageNameHelper.GetPiecePackageNameByID((piecePackageRow as HurtowniaNapojowDataSet.OpakowaniaSztukiRow).id_rodzaju_opakowania_sztuki); MessageBox.Show("Do wybranego rodzaju opakowania sztuki '"+tempPiecePackageName.NazwaOpakowania+", "+ (piecePackageRow as HurtowniaNapojowDataSet.OpakowaniaSztukiRow).Pojemność + "' są przypisane napoje producenta. Rodzaj opakowania sztuki nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } piecePackageRow.Delete(); return PiecePackageTableAdapter.Update(piecePackageRow) == 1; }
public static Boolean DeleteBulkPackageRow(DataRow bulkPackageRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_opakowania_zbiorczego == (bulkPackageRow as HurtowniaNapojowDataSet.OpakowaniaZbiorczeRow).Identyfikator); if (productExists) { HurtowniaNapojowDataSet.NazwyOpakowaniaZbiorczegoRow tempBulkPackageName = DataBaseBulkPackageNameHelper.GetBulkPackageNameByID((bulkPackageRow as HurtowniaNapojowDataSet.OpakowaniaZbiorczeRow).id_rodzaju_opakowania_zbiorczego); MessageBox.Show("Do wybranego rodzaju opakowania zbiorczego '" + tempBulkPackageName.NazwaOpakowania + ", " + (bulkPackageRow as HurtowniaNapojowDataSet.OpakowaniaZbiorczeRow).Pojemność + "' są przypisane napoje producenta. Rodzaj opakowania zbiorczego nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } bulkPackageRow.Delete(); return BulkPackageTableAdapter.Update(bulkPackageRow) == 1; }
public static Boolean DeleteDrinkNameRow(DataRow drinkNameRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_nazwy_napoju == (drinkNameRow as HurtowniaNapojowDataSet.NazwyNapojuRow).Identyfikator); if (productExists) { MessageBox.Show("Do wybranej nazwy napoju '" + (drinkNameRow as HurtowniaNapojowDataSet.NazwyNapojuRow).NazwaNapoju + "' są przypisane napoje producenta. Nazwa napoju nie zostanie usunięta.", Globals.TITLE_ERROR); return false; } drinkNameRow.Delete(); var result = DrinkNameTableAdapter.Update(drinkNameRow) == 1; if (result) RefreshData(); return result; }
public static Boolean DeleteTasteRow(DataRow tasteRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_smaku == (tasteRow as HurtowniaNapojowDataSet.SmakiRow).Identyfikator); if (productExists) { MessageBox.Show("Do wybranego smaku '" + (tasteRow as HurtowniaNapojowDataSet.SmakiRow).NazwaSmaku + "' są przypisane napoje producenta. Smak nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } tasteRow.Delete(); var result = TasteTableAdapter.Update(tasteRow) == 1; if (result) RefreshData(); return result; }
public static Boolean DeleteProducerDrinkRow(DataRow producerDrinkRow) { var warehouseProductExists = DataBaseWarehouseDrinkHelper.GetWarehouseDrinkData().Any(product => product.id_napoju_producenta == (producerDrinkRow as HurtowniaNapojowDataSet.NapojeProducentaRow).Identyfikator); if (warehouseProductExists) { MessageBox.Show("Do wybranego napoju producenta są przypisane napoje hurtowni. Wybrany napój producenta nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } producerDrinkRow.Delete(); var result = ProducerDrinkTableAdapter.Update(producerDrinkRow) == 1; if (result) RefreshData(); return result; }
public static Boolean DeleteGasTypeRow(DataRow gasTypeRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_rodzaju_gazu == (gasTypeRow as HurtowniaNapojowDataSet.RodzajeGazuRow).Identyfikator); if (productExists) { MessageBox.Show("Do wybranego rodzaju gazu '" + (gasTypeRow as HurtowniaNapojowDataSet.RodzajeGazuRow).NazwaRodzaju + "' są przypisane napoje producenta. Rodzaj Gazu nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } gasTypeRow.Delete(); var result = GasTypeTableAdapter.Update(gasTypeRow) == 1; if (result) RefreshData(); return result; }
public static Boolean DeleteProducerRow(DataRow producerRow) { var productExists = DataBaseProducerDrinkHelper.GetProducerDrinkData().Any(product => product.id_procuenta == (producerRow as HurtowniaNapojowDataSet.ProducenciRow).Identyfikator); if (productExists) { MessageBox.Show("Do wybranego producenta '" + (producerRow as HurtowniaNapojowDataSet.ProducenciRow).NazwaProducenta + "' są przypisane napoje producenta. Wybrany Producent nie zostanie usunięty.", Globals.TITLE_ERROR); return false; } producerRow.Delete(); var result = ProducerTableAdapter.Update(producerRow) == 1; if (result) RefreshData(); return result; }
public static Boolean DeletePiecePackageNameRow(DataRow piecePackageNameRow) { var piecePackageExists = DataBasePiecePackageHelper.GetPiecePackageData().Any(piecePackage => piecePackage.id_rodzaju_opakowania_sztuki == (piecePackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaSztukiRow).Identyfikator); if (piecePackageExists) { MessageBox.Show("Do wybranej nazwy rodzaju opakowania sztuki '" + (piecePackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaSztukiRow).NazwaOpakowania + "' są przypisane opakowania sztuki. Nazwa rodzaju opakowania sztuki nie zostanie usunięta.", Globals.TITLE_ERROR); return false; } piecePackageNameRow.Delete(); var result = PiecePackageNameTableAdapter.Update(piecePackageNameRow) == 1; if (result) RefreshData(); return result; }
public static Boolean DeleteWarehouseDrinkRow(DataRow warehouseDrinkRow) { var warehouseProductExists = DataBaseProductHelper.GetProductsData().Any(product => product.id_napoju_hurtowni == (warehouseDrinkRow as HurtowniaNapojowDataSet.NapojeHurtowniRow).Identyfikator); if (warehouseProductExists) { MessageBox.Show("Do wybranego napoju z magazynu są przypisane produkty zakópów klienta. Wybrana pozycja magazynu nie zostanie usunięta.", Globals.TITLE_ERROR); return false; } warehouseDrinkRow.Delete(); var result = WarehouseDrinkTableAdapter.Update(warehouseDrinkRow) == 1; if (result) RefreshData(); return result; }
} // initStdField /// <summary> /// /// </summary> /// <param name="ctx">Current Ctx of an application</param> /// <param name="iWindowId">window number</param> /// <param name="dr">Datarow contating resultset</param> /// <returns></returns> public static GridFieldVO CreateParameter(Ctx t_ctx, int iWindowId, System.Data.DataRow dr) { GridFieldVO vo = new GridFieldVO(t_ctx, iWindowId, 0, 0, 0, false); vo.isProcess = true; vo.IsDisplayedf = true; vo.IsReadOnly = false; vo.IsUpdateable = true; try { vo.AD_Table_ID = 0; vo.AD_Column_ID = int.Parse(dr["AD_Process_Para_ID"].ToString()); vo.ColumnName = dr["COLUMNNAME"].ToString(); vo.Header = dr["Name"].ToString(); vo.name = dr["Name"].ToString(); vo.Description = dr["Description"].ToString(); vo.Help = dr["Help"].ToString(); vo.displayType = int.Parse(dr["AD_Reference_ID"].ToString()); vo.AD_Reference_ID = int.Parse(dr["AD_Reference_ID"].ToString()); vo.IsMandatoryUI = dr["IsMandatoryUI"].ToString() == "Y" ? true : false; vo.FieldLength = int.Parse(dr["FIELDLENGTH"].ToString()); vo.DisplayLength = vo.FieldLength; vo.DefaultValue = dr["DefaultValue"].ToString(); vo.DefaultValue2 = dr["DEFAULTVALUE2"].ToString(); vo.ValueMin = dr["VALUEMIN"].ToString(); vo.ValueMax = dr["VALUEMAX"].ToString(); vo.isRange = dr["ISRANGE"].ToString() == "Y"; vo.AD_Reference_Value_ID = int.Parse((dr["AD_REFERENCE_VALUE_ID"].ToString() == "") ? "0" : dr["AD_REFERENCE_VALUE_ID"].ToString()); vo.ValidationCode = dr["VALIDATIONCODE"].ToString(); vo.AD_InfoWindow_ID = Util.GetValueOfInt(dr["AD_INFOWINDOW_ID"]); vo.LoadRecursiveData = dr["LoadRecursiveData"].ToString() == "Y" ? true : false; vo.ShowChildOfSelected = dr["ShowChildOfSelected"].ToString() == "Y" ? true : false; //Check If parameter is marked encrypted or not. vo.IsEncryptedField = dr["IsEncrypted"].ToString() == "Y" ? true : false; dr.Delete(); } catch { } vo.InitFinish(); return(vo); }
public static Boolean DeleteBulkPackageNameRow(DataRow bulkPackageNameRow) { var bulkPackageExists = DataBaseBulkPackageHelper.GetBulkPackageData().Any(bulk => bulk.id_rodzaju_opakowania_zbiorczego == (bulkPackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaZbiorczegoRow).Identyfikator); if (bulkPackageExists) { MessageBox.Show("Do wybranej nazwy rodzaju opakowania zbiorczego '" + (bulkPackageNameRow as HurtowniaNapojowDataSet.NazwyOpakowaniaZbiorczegoRow).NazwaOpakowania + "' są przypisane opakowania zbiorcze. Nazwa opakowania zbiorczego nie zostanie usunięta.", Globals.TITLE_ERROR); return false; } try { bulkPackageNameRow.Delete(); var result = BulkPackageNameTableAdapter.Update(bulkPackageNameRow) == 1; if (result) RefreshData(); return result; } catch (OleDbException e) { MessageBox.Show(e.Message, Globals.TITLE_ERROR); return false; } }
internal void Push(CUQueue UQueue, DataRow dr) { int n; bool bNull; if (dr == null) throw new ArgumentNullException("Datarow object can't be null"); if (m_dts == null) throw new ArgumentNullException("DataTable header is not serialized yet"); if (m_dts.Length != dr.ItemArray.Length) throw new InvalidOperationException("The size of the input data type array does not match the size of data row"); byte b = 0; byte bOne = 1; m_qBit.SetSize(0); m_qTemp.SetSize(0); bool bDelete = (dr.RowState == DataRowState.Deleted); if (bDelete) dr.RejectChanges(); object[] data = dr.ItemArray; int nLen = m_dts.Length; for (n = 0; n < nLen; n++) { object myData = data[n]; bNull = (myData == null || myData.Equals(DBNull.Value)); if (bNull) { b += (byte)(bOne << (byte)(n % 8)); } if ((n % 8) == 7) { m_qBit.Save(b); b = 0; } if (bNull) continue; switch (m_dts[n]) { case tagDataTypeSupported.dtBoolean: m_qTemp.Save((bool)myData); break; case tagDataTypeSupported.dtByte: m_qTemp.Save((byte)myData); break; case tagDataTypeSupported.dtChar: m_qTemp.Save((char)myData); break; case tagDataTypeSupported.dtDateTime: m_qTemp.Save((DateTime)myData); break; case tagDataTypeSupported.dtDecimal: m_qTemp.Save((decimal)myData); break; case tagDataTypeSupported.dtDouble: m_qTemp.Save((double)myData); break; case tagDataTypeSupported.dtFloat: m_qTemp.Save((float)myData); break; case tagDataTypeSupported.dtGuid: m_qTemp.Save((Guid)myData); break; case tagDataTypeSupported.dtUInt16: m_qTemp.Save((ushort)myData); break; case tagDataTypeSupported.dtUInt32: m_qTemp.Save((uint)myData); break; case tagDataTypeSupported.dtUInt64: m_qTemp.Save((ulong)myData); break; case tagDataTypeSupported.dtInt16: m_qTemp.Save((short)myData); break; case tagDataTypeSupported.dtInt32: m_qTemp.Save((int)myData); break; case tagDataTypeSupported.dtInt64: m_qTemp.Save((long)myData); break; case tagDataTypeSupported.dtString: m_qTemp.Save((string)myData); break; case tagDataTypeSupported.dtValue: case tagDataTypeSupported.dtValues: case tagDataTypeSupported.dtChars: case tagDataTypeSupported.dtBytes: case tagDataTypeSupported.dtTimeSpan: m_qTemp.Save(myData, false, false); break; case tagDataTypeSupported.dtUDT: m_qTemp.Save(myData.ToString()); break; default: throw new InvalidOperationException("Unsupported data type for serialization"); } } if ((n % 8) != 0) m_qBit.Save(b); UQueue.Push(m_qBit.m_bytes, m_qBit.GetSize()); UQueue.Push(m_qTemp.m_bytes, m_qTemp.GetSize()); if (bDelete) dr.Delete(); UQueue.Save((byte)dr.RowState); UQueue.Save(dr.HasErrors); if (dr.HasErrors) UQueue.Save(dr.RowError); }
private bool UpdateRow(DataTable tbl, DataRow row, int nLastVer, DateTime dtLock, DateTime dtUnLock, bool bLock) { int val = 0; try { if (bLock) { row.BeginEdit(); row["fieldid"] = m_nFieldID; row["modtabID"] = m_nModTabID; row["tablename"] = m_strTableName; row["fieldname"] = m_strFieldName; row["lastversion"] = nLastVer; row["lockip"] = m_strIP; row["lockhostname"] = m_strHostName; row["lockusername"] = m_strHostName; if (dtLock == DateTime.MinValue) row["locktime"] = DBNull.Value; else row["locktime"] = dtLock; if (dtUnLock == DateTime.MinValue) row["unlocktime"] = DBNull.Value; else row["unlocktime"] = dtUnLock; row.EndEdit(); } else { row.Delete(); } SqlCommandBuilder cmdBuilder = m_cmdBuilder;// new SqlCommandBuilder(m_adp); m_adp.UpdateCommand = cmdBuilder.GetUpdateCommand(); val = m_adp.Update(tbl); tbl.AcceptChanges(); return val > 0; } catch (Exception ex) { tbl.RejectChanges(); throw ex; } }
public void DeleteFilterX(DataRow filterX) { string str = filterX["ID"].ToString(); string sql = "delete from " + this._tblfiltername + " where ID='" + str + "';\ndelete from " + this._tblFilterConditionName + " where Filter_Id='" + str + "';"; QueryHelper.ExecuteSqlScalar("SkyMap.Net.Criteria", sql); this.DeleteFilterXConditions(filterX); filterX.Delete(); }
internal void GetEntityFromDataRow(DataColumnCollection columnCollection, DataRow row, IOfflineEntity objectToConvert) { Type t = objectToConvert.GetType(); Dictionary<string, string> mappingInfo = _localToGlobalPropertyMapping[t]; bool isDeleted = false; if (row.RowState == DataRowState.Deleted) { isDeleted = true; row.RejectChanges(); } // Note: Call BeginEdit only after check for Deleted row state, // otherwise this call will crash. row.BeginEdit(); for (Int32 i = 0; i <= columnCollection.Count - 1; i++) { if (IsSyncSpecificColumn(columnCollection[i].ColumnName)) { continue; } //NOTE: the datarow column names must match exactly (including case) to the IOfflineEntity's property names object columnValue = row[columnCollection[i].ColumnName]; if (DBNull.Value != columnValue) { t.InvokeMember((mappingInfo.ContainsKey(columnCollection[i].ColumnName)) ? mappingInfo[columnCollection[i].ColumnName] : columnCollection[i].ColumnName, BindingFlags.SetProperty, null, objectToConvert, new[] {columnValue}); } } if (isDeleted) { row.Delete(); // Mark the IsTombstone field if the RowState was deleted. objectToConvert.ServiceMetadata.IsTombstone = true; } row.EndEdit(); }
private void deleteTicket(DataRow dr) { String tid = DrGetStr(dr, this.gxxfDataSet.Ticket.TicketIdColumn); dr.Delete(); ticketTableAdapter.Update(dr); DataRow[] rows = gxxfDataSet.TicketJacket.Select("TicketId = '" + tid + "'"); foreach (DataRow r in rows) { r.Delete(); ticketJacketTableAdapter.Update(r); } rows = gxxfDataSet.TicketTrousers.Select("TicketId = '" + tid + "'"); foreach (DataRow r in rows) { r.Delete(); ticketTrousersTableAdapter.Update(r); } }
protected void dgvDetReq_RowCommand(object sender, GridViewCommandEventArgs e) { try { tbldetalle = (DataTable)Session["CARRITO"]; switch (e.CommandName) { case "Eliminar": string codigo = e.CommandArgument.ToString(); dr = tbldetalle.Rows.Find(Convert.ToString(codigo)); dr.Delete(); tbldetalle.AcceptChanges(); CalcularTotal(); Session["CARRITO"] = tbldetalle; dgvDetReq.DataSource = tbldetalle; dgvDetReq.DataBind(); break; } } catch { } }
public void removeCategoria(DataRow catDel) { const string mensagem = "Tem certeza de que deseja excluir esta categoria?"; const string titulo = "Aviso"; var result = MessageBox.Show(mensagem, titulo, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { int id = int.Parse(listViewCategorias.SelectedItems[0].Tag.ToString()); SqlCommand comandoUpdate = new SqlCommand(); SqlCommand comandoAchaSemCategoria = new SqlCommand(); comandoUpdate.Connection = conexaoFinanceiro; comandoAchaSemCategoria.Connection = conexaoFinanceiro; comandoAchaSemCategoria.CommandText = ("Select ID_CATEGORIA From CATEGORIA where NOME = 'Sem Categoria'"); int idSemCategoria = (int)comandoAchaSemCategoria.ExecuteScalar(); comandoUpdate.CommandText = ("Update Movimento set id_categoria = " + idSemCategoria + " where id_categoria = " + id); comandoUpdate.ExecuteNonQuery(); catDel.Delete(); adaptadorCategoria.Update(dadosFinanceiro, "Categoria"); adaptadorMovimento.Update(dadosFinanceiro, "Movimento"); carregaMovimentos(); carregaCategorias(); } }
public void removeMovimento(DataRow movDel) { const string mensagem = "Tem certeza de que deseja excluir a movimentação?"; const string titulo = "Aviso"; var result = MessageBox.Show(mensagem, titulo, MessageBoxButtons.YesNo, MessageBoxIcon.Question); if (result == DialogResult.Yes) { movDel.Delete(); adaptadorMovimento.Update(dadosFinanceiro, "Movimento"); carregaMovimentos(); } }
public static IEnumerable<IEditorScript> GetScripts(IAsyncConnection conn, string type, string id , string relatedId = null, DataRow row = null) { if (!string.IsNullOrEmpty(id)) { ArasMetadataProvider metadata = null; ItemType itemType = null; if (conn != null) { metadata = ArasMetadataProvider.Cached(conn); itemType = metadata.ItemTypeByName(type); } if (metadata != null) { yield return new EditorScript() { Name = "View \"" + (itemType.Label ?? itemType.Name) + "\"", Action = "ApplyItem", Script = string.Format("<Item type='{0}' id='{1}' action='get' levels='1'></Item>", type, id), AutoRun = true, PreferredOutput = OutputType.Table }; if (!string.IsNullOrEmpty(relatedId) && itemType.Related != null) { yield return new EditorScript() { Name = "View \"" + (itemType.Related.Label ?? itemType.Related.Name) + "\"", Action = "ApplyItem", Script = string.Format("<Item type='{0}' id='{1}' action='get' levels='1'></Item>", itemType.Related.Name, relatedId), AutoRun = true, PreferredOutput = OutputType.Table }; } } yield return new EditorScript() { Name = "------" }; if (conn != null) { yield return ArasEditorProxy.ItemTypeAddScript(conn, itemType); } if (row == null) { yield return new EditorScript() { Name = "Edit", Action = "ApplyItem", Script = string.Format("<Item type='{0}' id='{1}' action='edit'></Item>", type, id) }; yield return new EditorScript() { Name = "Delete", Action = "ApplyItem", Script = string.Format("<Item type='{0}' id='{1}' action='delete'></Item>", type, id) }; } else { yield return new EditorScriptExecute() { Name = "Delete", Execute = () => row.Delete() }; } yield return new EditorScript() { Name = "------" }; if (metadata != null) { var actions = new EditorScript() { Name = "Actions" }; var serverActions = metadata.ServerItemActions(type) .OrderBy(l => l.Label ?? l.Value, StringComparer.CurrentCultureIgnoreCase) .ToArray(); foreach (var action in serverActions) { actions.Add(new EditorScript() { Name = (action.Label ?? action.Value), Action = "ApplyItem", Script = string.Format("<Item type='{0}' id='{1}' action='{2}'></Item>", type, id, action.Value), AutoRun = true }); } if (serverActions.Any()) yield return actions; var reports = new EditorScript() { Name = "Reports" }; var serverReports = metadata.ServerReports(type) .OrderBy(l => l.Label ?? l.Value, StringComparer.CurrentCultureIgnoreCase) .ToArray(); foreach (var report in serverReports) { reports.Add(new EditorScript() { Name = (report.Label ?? report.Value), Action = "ApplyItem", Script = @"<Item type='Method' action='Run Report'> <report_name>" + report.Value + @"</report_name> <AML> <Item type='" + itemType.Name + "' typeId='" + itemType.Id + "' id='" + id + @"' /> </AML> </Item>", AutoRun = true }); } if (serverReports.Any()) yield return reports; } yield return new EditorScriptExecute() { Name = "Copy ID", Execute = () => { if (string.IsNullOrEmpty(id)) { System.Windows.Clipboard.Clear(); } else { System.Windows.Clipboard.SetText(id); } } }; } }
//------------------------------------------------------------------------------------------- // Suppress an entry from the database //------------------------------------------------------------------------------------------- internal static void ManualDelete(DataRow row, bool removefromDb, bool deletefromStorage) { LogMyFilms.Info("Manual_Delete(): remove from DB = '" + removefromDb + "', delete from storage = '" + deletefromStorage + "'"); if (deletefromStorage) { var newItems = new ArrayList(); bool noResumeMovie = true; int movieIndex = 0; SearchAllFiles(row, true, ref noResumeMovie, ref newItems, ref movieIndex, false, ""); foreach (object t in from object t in newItems where File.Exists(t.ToString()) select t) { // for each entry test if it's a file, a directory or a dvd copy // no action for files on removible media or image files try { File.Delete(t.ToString()); LogMyFilms.Info("file deleted : " + t); } catch (Exception ex) { LogMyFilms.Info("unable to delete file : " + t); LogMyFilms.InfoException("Manual_Delete() - delete file exception: ", ex); } } } if (removefromDb) { string wdelTitle = row[MyFilms.conf.StrTitle1].ToString(); //AntMovieCatalog.MovieRow RowToDelete = row; //foreach (AntMovieCatalog.CustomFieldsRow customFieldsRow in RowToDelete.GetCustomFieldsRows()) //{ // customFieldsRow.Delete(); //} row.Delete(); LogMyFilms.Info("Database movie deleted : " + wdelTitle); Update_XML_database(); } }
//------------------------------------------------------------------------------------------- // Suppress an entry from the database //------------------------------------------------------------------------------------------- private static void SuppressEntry(DataRow row) { if (MyFilms.conf.StrSuppressAutomaticActionType == "2" || MyFilms.conf.StrSuppressAutomaticActionType == "4") { var newItems = new ArrayList(); bool noResumeMovie = true; int movieIndex = 0; SearchAllFiles(row, true, ref noResumeMovie, ref newItems, ref movieIndex, false, ""); foreach (object t in from object t in newItems where File.Exists(t.ToString()) select t) { try { File.Delete(t.ToString()); LogMyFilms.Info("file deleted : " + t); } catch { LogMyFilms.Info("unable to delete file : " + t); } } } if (MyFilms.conf.StrSuppressAutomaticActionType == "1" || MyFilms.conf.StrSuppressAutomaticActionType == "2") { string wdelTitle = row[MyFilms.conf.StrTitle1].ToString(); row.Delete(); MyFilms.conf.StrIndex = -1; LogMyFilms.Info("Database movie deleted : " + wdelTitle); } // Update_XML_database(); // already done on calling method ... }
/// <summary> /// Removes the specified DataRow from the collection. /// </summary> public void Remove (DataRow row) { if (IndexOf (row) < 0) throw new IndexOutOfRangeException ("The given datarow is not in the current DataRowCollection."); DataRowState state = row.RowState; if (state != DataRowState.Deleted && state != DataRowState.Detached) { row.Delete (); // if the row was in added state it will be in Detached state after the // delete operation, so we have to check it. if (row.RowState != DataRowState.Detached) row.AcceptChanges (); } }
public void RemoveRow(DataRow selectedRow) { selectedRow.Delete(); Update(selectedRow.GetType()); AcceptChanges(); }
private void DeleteTheWholeChain (DataTable AllSecureableUnits, DataRow ToDelete) { String ID = ToDelete ["ID"].ToString(); DataRow [] Children = AllSecureableUnits.Select ("ParentID = '" + ID + "'"); foreach (DataRow Child in Children) { DeleteTheWholeChain(AllSecureableUnits, Child); Child.Delete(); AllSecureableUnits.AcceptChanges(); } String DeleteStatement = "Delete SecureableUnits where ParentID = '" + ID + "'"; AltErlaaInfoDataAccess.RunSQLBatch (DeleteStatement); ToDelete.Delete(); AllSecureableUnits.AcceptChanges(); }
/// <summary> /// This method will try to locate the passed in DataRow's key values in the destination DataTable /// and if found will update its values with the new values passed. /// </summary> /// <param name="destinationTable">Table to make the merge in</param> /// <param name="rowToMatch">Row whose keys to match in destination table</param> /// <param name="rowvalues">Values to override</param> /// <param name="entityType">Entity type for the DataRow</param> internal void MergeChangeInToDataSet(DataTable destinationTable, DataRow rowToMatch, object[] rowvalues, Type entityType) { object[] primaryKeyColumns = new object[destinationTable.PrimaryKey.Length]; int index = 0; bool isRowToMatchDeleted = false; if (rowToMatch.RowState == DataRowState.Deleted) { isRowToMatchDeleted = true; rowToMatch.RejectChanges(); } // Find all PrimaryKey column indexes foreach (DataColumn pkColumn in destinationTable.PrimaryKey) { primaryKeyColumns[index++] = rowToMatch[pkColumn.ColumnName]; } // Find the row in DestinationTable DataRow rowToModify = destinationTable.Rows.Find(primaryKeyColumns); // Check for tombstones bool isRowDeleted = false; if (rowToModify.RowState == DataRowState.Deleted) { isRowDeleted = true; rowToModify.RejectChanges(); } // Suppress DataRow RowChanging events // Note: Call BeginEdit only after check for Deleted row state, // otherwise this call will crash. rowToModify.BeginEdit(); Debug.Assert(rowToModify != null); rowToModify.ItemArray = rowvalues; // Reset rowstates if (isRowDeleted) { rowToModify.Delete(); } if (isRowToMatchDeleted) { rowToMatch.Delete(); } rowToModify.EndEdit(); }
private static void DeleteRow(DataRow row) { try { row.Delete(); } catch (Exception ex) { string s = Error.GetErrorMessage(ex, false, false); MessageBox.Show(s, "Error", MessageBoxButtons.OK, MessageBoxIcon.Error); } }
private void get_id_gd_diem(US_DUNG_CHUNG v_us_dc, decimal v_id_ns, decimal v_id_gdlm, DataRow v_dt_r, ref int v_int_khong_nhap_duoc, DataRow v_data_row, ref decimal v_count) { DataSet v_ds = new DataSet(); v_ds.Tables.Add(new DataTable()); v_us_dc.FillDatasetWithQuery(v_ds, "SELECT * FROM GD_DIEM WHERE ID_NHAN_VIEN=" + v_id_ns.ToString() + " AND ID_LOP_MON=" + v_id_gdlm.ToString()); if (v_ds.Tables[0].Rows.Count == 0) { MessageBox.Show("Nhân viên này chưa có tên trong lớp môn này"); } v_dt_r = v_ds.Tables[0].Rows[0]; decimal v_id_gdd = CIPConvert.ToDecimal(v_dt_r["ID"].ToString()); US_GD_DIEM v_us_gdd = new US_GD_DIEM(v_id_gdd); if (v_us_gdd.dcDIEM_CHUYEN_CAN.ToString() == "") { v_us_gdd.IsDIEM_CHUYEN_CANNull(); } else { v_us_gdd.dcDIEM_CHUYEN_CAN = CIPConvert.ToDecimal(v_data_row["DIEM_CHUYEN_CAN"].ToString()); } if (v_us_gdd.dcDIEM_THI.ToString() == "") { v_us_gdd.IsDIEM_THINull(); } else { v_us_gdd.dcDIEM_THI = CIPConvert.ToDecimal(v_data_row["DIEM_KIEM_TRA"].ToString()); } if (v_us_gdd.dcDIEM_KIEM_TRA.ToString()=="") { v_us_gdd.IsDIEM_KIEM_TRANull(); } else { v_us_gdd.dcDIEM_KIEM_TRA = CIPConvert.ToDecimal(v_data_row["DIEM_THI"].ToString()); } v_us_gdd.strQUA_MON = v_data_row["KET_QUA"].ToString(); v_us_gdd.datNGAY_SUA = DateTime.Now.Date; v_us_gdd.strHOC_XONG_YN = "Y"; v_us_gdd.Update(); try { v_us_gdd.Update(); v_data_row.Delete(); v_count++; } catch (Exception) { MessageBox.Show("Lỗi!"); v_int_khong_nhap_duoc++; } }