public void SaveImages()
{
if (imagesChanged && tableName != "" && tableFieldName != "" && tableFieldControl != null && tableFieldControl.GetDataStr() != "")
{
ArsSQLQry qryImageDel = new ArsSQLQry();
qryImageDel.SQLText = "SELECT REC_ID FROM [TBLRESIM] WHERE /*WS*/TABLE_NAME = '" + tableName + "' " +
"AND TABLE_FIELD_NAME = '" + tableFieldName + "' " +
"AND TABLE_FIELD_VALUE = '" + TableFieldControl.GetDataStr() + "'/*WE*/";
qryImageDel.Open();
if (qryImageDel.Found())
{
qryImageDel.Mode = EnmQryMode.Delete;
qryImageDel.Exec();
}
if (imageSlider.Images.Count > 0)
{
for (int i = 0; i < imageSlider.Images.Count; i++)
{
ArsSQLQry qryImageIns = new ArsSQLQry();
qryImageIns.SQLText = "SELECT * FROM [TBLRESIM] WHERE /*WS*/1=2/*WE*/";
qryImageIns.Open();
qryImageIns.Mode = EnmQryMode.Insert;
qryImageIns.SetString("TABLE_NAME", tableName);
qryImageIns.SetString("TABLE_FIELD_NAME", tableFieldName);
qryImageIns.SetString("TABLE_FIELD_VALUE", tableFieldControl.GetDataStr());
qryImageIns.SetInt("SIRA", i);
qryImageIns.SetImage("IMAGE_DATA", imageSlider.Images[i]);
qryImageIns.Exec();
}
}
}
}
public void LoadImages()
{
ClearImages();
if (tableName != "" && tableFieldName != "" && tableFieldControl != null && tableFieldControl.GetDataStr() != "")
{
ArsSQLQry qryImage = new ArsSQLQry();
qryImage.SQLText = "SELECT IMAGE_DATA, SIRA FROM [TBLRESIM] WHERE /*WS*/TABLE_NAME = '" + tableName + "' " +
"AND TABLE_FIELD_NAME = '" + tableFieldName + "' " +
"AND TABLE_FIELD_VALUE = '" + TableFieldControl.GetDataStr() + "'/*WE*/ " +
"ORDER BY SIRA";
qryImage.Open();
if (qryImage.Found())
{
for (int i = 0; i < qryImage.DataCount(); i++)
{
AddImage(qryImage.GetImage("IMAGE_DATA"));
qryImage.Next();
}
if (imageSlider.Images.Count > 0)
{
imageSlider.SetCurrentImageIndex(0);
lblImageIndex.Text = "1/" + imageSlider.Images.Count;
}
}
}
}
