/*
* 粘贴相册，同时复制旗下的图片
*/
public void copyFromDControlId(int fromDControlId, int toDControlId)
{
List <TurnPictureImagesDto> list = getByDControlId(fromDControlId);
foreach (TurnPictureImages dto in list)
{
TurnPictureImages turnPictureImages = new TurnPictureImages();
turnPictureImages.dControlId = toDControlId;
turnPictureImages.storageImageId = dto.storageImageId;
turnPictureImages.isLink = dto.isLink;
insert(turnPictureImages);
}
}
public TurnPictureImages get(int id)
{
String sql = "select * from turnPictureImages where id=@id";
SQLiteParameter[] parameters =
{
new SQLiteParameter("@id", DbType.Int32, 4)
};
parameters[0].Value = id;
DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters);
TurnPictureImages entity = DataToEntity <TurnPictureImages> .FillModel(dt.Rows[0]);
return(entity);
}
/*
* 添加图片列表
*
* @param dControlId 控件编号
*
* @param storageImageIds 图片列表
*
*/
public Int32 insert(List <TurnPictureImagesDto> list)
{
int rows = 0;
foreach (TurnPictureImagesDto dto in list)
{
TurnPictureImages turnPictureImages = new TurnPictureImages();
turnPictureImages.dControlId = dto.dControlId;
turnPictureImages.storageImageId = dto.storageImageId;
turnPictureImages.isLink = dto.isLink;
insert(turnPictureImages);
rows = rows + 1;
}
return(rows);
}
//1、插入图片
public TurnPictureImages insert(TurnPictureImages entity)
{
String sql = "insert into turnPictureImages(dControlId,storageImageId,isLink) values(@dControlId,@storageImageId,@isLink);select last_insert_rowid();";
SQLiteParameter[] parameters =
{
new SQLiteParameter("@dControlId", DbType.Int32, 4),
new SQLiteParameter("@storageImageId", DbType.Int32, 4),
new SQLiteParameter("@isLink", DbType.Int32, 4)
};
parameters[0].Value = entity.dControlId;
parameters[1].Value = entity.storageImageId;
parameters[2].Value = entity.isLink;
DataTable dt = Common.SQLiteHelper.ExecuteQuery(sql, parameters);
int id = DataType.ToInt32(dt.Rows[0]["last_insert_rowid()"].ToString());
entity.id = id;
return(entity);
}
public int update(TurnPictureImages entity)
{
string sql = "update turnPictureImages set dControlId=@dControlId,storageImageId=@storageImageId,isLink=@isLink"
+ " where id=@id";
SQLiteParameter[] parameters =
{
new SQLiteParameter("@dControlId", DbType.Int32, 4),
new SQLiteParameter("@storageImageId", DbType.Int32, 4),
new SQLiteParameter("@isLink", DbType.Int32, 4),
new SQLiteParameter("@id", DbType.Int32, 4)
};
parameters[0].Value = entity.dControlId;
parameters[1].Value = entity.storageImageId;
parameters[2].Value = entity.isLink;
parameters[3].Value = entity.id;
int result = Common.SQLiteHelper.ExecuteNonQuery(sql, parameters);
return(result);
}
/*
* 点击打开上传图片
*/
private void openDialogClick(object sender, RoutedEventArgs e)
{
Button btn = (Button)sender;
Canvas imgCanvas = (Canvas)VisualTreeHelper.GetParent(btn);
int idx = imgList.Children.IndexOf(imgCanvas);
object tag = imgCanvas.Tag;
System.Windows.Forms.OpenFileDialog ofld = new System.Windows.Forms.OpenFileDialog();
ofld.Filter = "图片|*.jpg;*.jpeg;*.png;*.gif;*.bmp";
ofld.Multiselect = true;
if (ofld.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
int i = 0;
string[] fileNames = ofld.FileNames;
foreach (string filename in fileNames)
{
if (filename != "" || filename != null)
{
i = i + 1;
System.Drawing.Image sourceImage = System.Drawing.Image.FromFile(filename);
String url = uploadImage(btn, filename);
StorageImage storageImage = storageImageBll.insert(filename, url, sourceImage.Width, sourceImage.Height, 1);
//1.如果i>1，则直接在其后插入新的
if (i > 1)
{
TurnPictureImagesDto dto = new TurnPictureImagesDto();
dto.storageImageId = storageImage.id;
dto.dControlId = currDControl.id;
dto.url = storageImage.url;
TurnPictureImages turnPictureImages = turnPictureImagesBll.insert(dto);
dto.id = turnPictureImages.id;
Canvas canvas = initOneImage(dto);
imgList.Children.Insert(idx, canvas);
idx = idx + 1;
continue;
}
//2.如果Tag==null，则在其前面插入新的，
if (tag == null)
{
TurnPictureImagesDto dto = new TurnPictureImagesDto();
dto.storageImageId = storageImage.id;
dto.dControlId = currDControl.id;
dto.url = storageImage.url;
TurnPictureImages turnPictureImages = turnPictureImagesBll.insert(dto);
dto.id = turnPictureImages.id;
Canvas canvas = initOneImage(dto);
imgList.Children.Insert(idx, canvas);
idx = idx + 1;
}
//3.直接tag!=null,则更新当前图片
else
{
TurnPictureImagesDto dto = (TurnPictureImagesDto)tag;
dto.storageImageId = storageImage.id;
dto.dControlId = currDControl.id;
dto.url = storageImage.url;
imgCanvas.Tag = dto;
turnPictureImagesBll.update(dto);
btn.Background = new ImageBrush
{
ImageSource = FileUtil.readImage2(AppDomain.CurrentDomain.BaseDirectory + url, currDControl.width)
,
Stretch = Stretch.Uniform
};
}
}
}
}
}
private void Submit_Button_Click(object sender, RoutedEventArgs e)
{
/*
* 获取不同屏幕下 linkToPageId,showInWhichCFrame的值
*
* 如果数据库中有数据行则更新，没有则插入
*/
bool isLink = false;
foreach (FrameworkElement ele in mainGrid.Children)
{
if (ele is TabControl == false)
{
continue;
}
TabControl tabControl = (TabControl)ele;
foreach (TabItem tabItem in tabControl.Items)
{
int screenCfgId = Convert.ToInt32(tabItem.Tag);
int linkToPageIdVal = 0;
int showInWhichCFrameVal = 0;
bool isTransparentDialogVal = false;
bool isDialogLinkVal = false;
Grid grid = (Grid)tabItem.Content;
foreach (FrameworkElement fe in grid.Children)
{
if (fe.Name == "linkToPageId" + screenCfgId)
{
ComboBox comboBoxLinkToPageId = (ComboBox)fe;
ComboBoxItem item = (ComboBoxItem)comboBoxLinkToPageId.SelectedItem;
if (item != null)
{
linkToPageIdVal = (int)item.Tag;
}
}
if (fe.Name == "showInWhichCFrame" + screenCfgId)
{
ComboBox comboBoxShowInWhichCFrame = (ComboBox)fe;
ComboBoxItem item = (ComboBoxItem)comboBoxShowInWhichCFrame.SelectedItem;
if (item != null)
{
showInWhichCFrameVal = (int)item.Tag;
}
}
if (fe.Name == "isTransparentDialog" + screenCfgId)
{
CheckBox checkBoxIsTransparentDialog = (CheckBox)fe;
isTransparentDialogVal = (Boolean)checkBoxIsTransparentDialog.IsChecked;
}
if (fe.Name == "isDialogLink" + screenCfgId)
{
CheckBox checkBoxIsDialogLink = (CheckBox)fe;
isDialogLinkVal = (Boolean)checkBoxIsDialogLink.IsChecked;
}
}
if (linkToPageIdVal > 0)
{
isLink = true;
}
DControlEvent dControlEvent = dControlEventBll.getByTurnPictureImagesIdScreenCfgId(dto.id, screenCfgId);
if (dControlEvent != null)
{
dControlEvent.linkToPageId = linkToPageIdVal;
dControlEvent.showInWhichCFrame = showInWhichCFrameVal;
dControlEvent.isDialogLink = isDialogLinkVal;
dControlEvent.isTransparentDialog = isTransparentDialogVal;
dControlEventBll.update(dControlEvent);
}
else
{
dControlEvent = new DControlEvent();
dControlEvent.turnPictureImagesId = dto.id;
dControlEvent.screenCfgId = screenCfgId;
dControlEvent.linkToPageId = linkToPageIdVal;
dControlEvent.showInWhichCFrame = showInWhichCFrameVal;
dControlEvent.isDialogLink = isDialogLinkVal;
dControlEvent.isTransparentDialog = isTransparentDialogVal;
dControlEventBll.insert(dControlEvent);
}
}
}
//更新到数据库
TurnPictureImages turnPictureImages = turnPictureImagesBll.get(dto.id);
turnPictureImages.isLink = isLink;
turnPictureImagesBll.update(turnPictureImages);
//更新到上一个页面
dto.isLink = isLink;
Canvas imgCanvas = (Canvas)VisualTreeHelper.GetParent(linkBtn);
imgCanvas.Tag = dto;
//更新是否有链接的标志
if (isLink)
{
linkBtn.Background = new ImageBrush
{
ImageSource = FileUtil.readImage(AppDomain.CurrentDomain.BaseDirectory + "/myfile/sysimg/ico-image-link-active.png")
,
Stretch = Stretch.Uniform
};
}
else
{
linkBtn.Background = new ImageBrush
{
ImageSource = FileUtil.readImage(AppDomain.CurrentDomain.BaseDirectory + "/myfile/sysimg/ico-image-link.png")
,
Stretch = Stretch.Uniform
};
}
Close();
}
public TurnPictureImages update(TurnPictureImages turnPictureImages)
{
int rows = turnPictureImagesDal.update(turnPictureImages);
return(turnPictureImages);
}
/*
* 插入一个
*
*/
public TurnPictureImages insert(TurnPictureImages turnPictureImages)
{
return(turnPictureImagesDal.insert(turnPictureImages));;
}
