protected void bDeleteD_Click(object sender, ImageClickEventArgs e) { lock (Database.lockObjectDB) { int id = Convert.ToInt32(gvPurchDogs.DataKeys[gvPurchDogs.SelectedIndex].Values["id"]); if (!CheckProducts(id)) { return; } DelProducts(id); SqlCommand sqCom = new SqlCommand(); object obj = null; sqCom.CommandText = "delete from Products_PurchDogs where id_dog=@id"; sqCom.Parameters.Add("@id", SqlDbType.Int).Value = id; Database.ExecuteNonQuery(sqCom, null); sqCom.CommandText = "select number_dog from PurchDogs where id=@id"; res = Database.ExecuteScalar(sqCom, ref obj, null); sqCom.CommandText = "delete from PurchDogs where id=@id"; Database.ExecuteNonQuery(sqCom, null); Database.Log(sc.UserGuid(User.Identity.Name), String.Format("Удален договор на закупку {0}", (obj == null) ? "" : (string)obj), null); Refr(0, false); lbInform.Text = ""; } }
protected void bDeleteCard_Click(object sender, ImageClickEventArgs e) { lock (Database.lockObjectDB) { string pan = ""; CheckBox cb; SqlCommand comm = new SqlCommand(); CheckBox cbA = (CheckBox)gvCard.HeaderRow.FindControl("cbSelectAll"); if (cbA.Checked) { string str = lbSearch.Text.Trim(); if (str.Length > 0) { str += " and " + branchSearch; } else { str += " where " + branchSearch; } str += " and (id_stat=1 or id_stat=2)"; comm.CommandText = "delete from Cards " + str; Database.ExecuteNonQuery(comm, null); } else { comm.Parameters.Add("@id", SqlDbType.Int); foreach (GridViewRow gvr in gvCard.Rows) { cb = (CheckBox)gvr.FindControl("cbSelect"); if (cb.Checked && (int)gvCard.DataKeys[gvr.RowIndex].Values["id_stat"] == 1) { comm.Parameters["@id"].Value = (int)gvCard.DataKeys[gvr.RowIndex].Values["id"]; pan = gvCard.DataKeys[gvr.RowIndex].Values["pan"].ToString(); comm.CommandText = "delete from Cards where id=@id"; Database.ExecuteNonQuery(comm, null); Database.Log(sc.UserGuid(User.Identity.Name), String.Format("Удалена карта {0} в статусе обработка", pan), null); } } } Refr(false); } }