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);
}
