public Image GetImage(string fieldName) { if (GetString(fieldName) != "") { return(DemirSatisLib.ByteArrayToImage(dataSet.Tables[0].Rows[serviceIndex][fieldName] as byte[])); } return(null); }
public string GetDoubleStr(string fieldName) { if (resultSet[serviceIndex].Keys.Contains(fieldName)) { return(DemirSatisLib.AfterDigits(resultSet[serviceIndex][fieldName].Replace('.', ','), ',', 2)); } return(""); }
private void StokOlustur() { progressBar.Properties.Maximum = grdStok.Rows.Count; if (progressForm != null) { progressForm.setPerProgMax(grdStok.Rows.Count); } List <string> grupList = new List <string>(); foreach (DataGridViewRow row in grdStok.Rows) { int sira = 1; string stokKodu = row.Cells["grdStokKodu"].Value.ToString(); if (stokKodu.Contains("(")) { try { sira = Convert.ToInt32(stokKodu.BetweenChars('(', ')')); } catch (Exception ex) { } } //if (!grupList.Contains(row.Cells["grdStokGrubu"].Value.ToString())) //{ // grupList.Add(row.Cells["grdStokGrubu"].Value.ToString()); // insertGrupSQL = "INSERT INTO TBLSTOKGRUP(GRUP_KODU, GRUP_TANIMI) " + // "VALUES('" + row.Cells["grdStokGrubu"].Value.ToString() + "', '" + row.Cells["grdStokGrubu"].Value.ToString() + "')\n"; //} insertStokSQL = "INSERT INTO TBLSTOK(STOK_KODU, STOK_ADI, DEMIR_STR_2, SIRA) " + "VALUES('" + row.Cells["grdStokKodu"].Value.ToString() + "', '" + row.Cells["grdStokAdi"].Value.ToString() + "', '" + row.Cells["grdPath"].Value.ToString() + "', " + sira + ")\n"; insertStokResimSQL = "INSERT INTO TBLSTOKRESIM(STOK_KODU, IMAGE_DATA) " + "VALUES('" + row.Cells["grdStokKodu"].Value.ToString() + "', " + "0x" + DemirSatisLib.ByteArrayToString(DemirSatisLib.ImageToByteArray(Image.FromFile(tbFilePath.Text + "\\" + row.Cells["grdPath"].Value.ToString() + "\\" + row.Cells["grdResimTamAd"].Value.ToString()))) + ")"; //if (insertGrupSQL != "") //{ // InsertGrup(insertGrupSQL); //} if (insertStokSQL != "") { if (InsertStok(insertStokSQL) == "0") { InsertStokResim(insertStokResimSQL); } } progressBar.Position++; Thread.Sleep(10); } progressBar.Position = 0; btnOlustur.Enabled = true; tbFilePath.Text = ""; grdStok.Rows.Clear(); MessageBox.Show("Kayıtlar Eklendi", "Bilgi", MessageBoxButtons.OK, MessageBoxIcon.Information); }