/// <summary> /// 图片缩小 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPicSmaller_Click(object sender, EventArgs e) { try { if (picSample.Image == null) { return; } if (saveStandImage == null) { saveStandImage = picSample.Image; } decimal zoonNum = saveZoomNum * 0.1m + 1m; if (zoonNum <= 0) { return; } else { saveZoomNum--; } picSample.Image = UCTemplatePic.ZoomImage(saveStandImage, zoonNum); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 图片放大 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnPicBigger_Click(object sender, EventArgs e) { try { if (picSample.Image == null) { return; } if (saveStandImage == null) { saveStandImage = picSample.Image; } if (saveZoomNum < 30)//最多放大4倍,限制下,防止溢出 { saveZoomNum++; } picSample.Image = UCTemplatePic.ZoomImage(saveStandImage, saveZoomNum * 0.1m + 1m); } catch (Exception E) { this.ShowMessage(E.Message); } }
/// <summary> /// 修改图片 /// </summary> void UpdateImage() { if (UCInputMainType == 1)//数据库交互模式 { string sql = ""; switch (UCInputDBSaveType) { case 1: //存储在同一张表内 sql = "UPDATE " + UCDBTableName + " SET " + UCDBPicFieldName + "=@" + UCDBPicFieldName; if (UCDBSmallPicFieldName != string.Empty) { sql += "," + UCDBSmallPicFieldName + "=@" + UCDBSmallPicFieldName; } if (UCDBRemarkFieldName != string.Empty) { sql += "," + UCDBRemarkFieldName; sql += "=" + SysString.ToDBString(txtRemark.Text.Trim()); } if (UCDBMainIDFieldName != string.Empty) { sql += "," + UCDBMainIDFieldName + "=" + UCDataID; } if (UCDBStyleNoFieldName != string.Empty) { sql += "," + UCDBStyleNoFieldName + "=" + SysString.ToDBString(UCDataStyleNo); } sql += " WHERE ID=" + UCDataID; break; case 2: //存储在独立的数据表内 sql = "UPDATE " + UCDBTableName + " SET " + UCDBPicFieldName + "=@" + UCDBPicFieldName; if (UCDBSmallPicFieldName != string.Empty) { sql += "," + UCDBSmallPicFieldName + "=@" + UCDBSmallPicFieldName; } if (UCDBRemarkFieldName != string.Empty) { sql += "," + UCDBRemarkFieldName; sql += "=" + SysString.ToDBString(txtRemark.Text.Trim()); } if (UCDBMainIDFieldName != string.Empty) { sql += "," + UCDBMainIDFieldName + "=" + UCDataID; } if (UCDBStyleNoFieldName != string.Empty) { sql += "," + UCDBStyleNoFieldName + "=" + SysString.ToDBString(UCDataStyleNo); } sql += " WHERE ID=" + saveIDs[saveImageIndex]; break; } int len = 1; if (UCDBSmallPicFieldName != string.Empty) { len = 2; } object[,] obja = new object[2, len]; obja[0, 0] = "@" + UCDBPicFieldName; obja[1, 0] = UCTemplatePic.ImageToByte(UCTemplatePic.ZoomImage(picShow.Image, UCUIPicWidth, UCUIPicHeight)); if (UCDBSmallPicFieldName != string.Empty) { obja[0, 1] = "@" + UCDBSmallPicFieldName; obja[1, 1] = UCTemplatePic.ImageToByte(UCTemplatePic.ZoomImage(picShow.Image, UCUISmallPicWidth, UCUISmallPicHeight)); } PicExecuteNonQuery(sql, obja); //SysUtils.ExecuteNonQuery } else if (UCInputMainType == 2) //仅是图片交互模式 { //代码待补充 if (m_UCDataLstImage.Count > 0) { if (m_UCDataLstImage.Count > saveImageIndex) { m_UCDataLstImage[saveImageIndex] = UCTemplatePic.ZoomImage(picShow.Image, UCUIPicWidth, UCUIPicHeight); } if (m_UCDataLstSmallImage.Count > saveImageIndex) { m_UCDataLstSmallImage[saveImageIndex] = UCTemplatePic.ZoomImage(picShow.Image, UCUISmallPicWidth, UCUISmallPicHeight); } } else { InsertImage(); } } }
/// <summary> /// 插入图片 /// </summary> /// <returns>返回ID</returns> int InsertImage() { int outI = 0; if (UCInputMainType == 1)//数据库交互模式 { string sql = ""; switch (UCInputDBSaveType) { case 1: //存储在同一张表内,依旧使用Update方法 sql = "UPDATE " + UCDBTableName + " SET " + UCDBPicFieldName + "=@" + UCDBPicFieldName; if (UCDBSmallPicFieldName != string.Empty) { sql += "," + UCDBSmallPicFieldName + "=@" + UCDBSmallPicFieldName; } if (UCDBRemarkFieldName != string.Empty) { sql += "," + UCDBRemarkFieldName; sql += "=" + SysString.ToDBString(txtRemark.Text.Trim()); } if (UCDBMainIDFieldName != string.Empty) { sql += "," + UCDBMainIDFieldName + "=" + UCDataID; } if (UCDBStyleNoFieldName != string.Empty) { sql += "," + UCDBStyleNoFieldName + "=" + SysString.ToDBString(UCDataStyleNo); } sql += " WHERE ID=" + UCDataID; outI = UCDataID; break; case 2: //存储在独立的数据表内 sql = "SELECT MAX(ID) ID FROM " + UCDBTableName; DataTable dt = PicFill(sql); if (dt.Rows.Count != 0) { outI = SysConvert.ToInt32(dt.Rows[0]["ID"]) + 1; } sql = "INSERT INTO " + UCDBTableName + " (ID," + UCDBPicFieldName; if (UCDBSmallPicFieldName != "") { sql += "," + UCDBSmallPicFieldName; } if (UCDBRemarkFieldName != string.Empty) { sql += "," + UCDBRemarkFieldName; } sql += "," + UCDBMainIDFieldName; if (UCDBStyleNoFieldName != string.Empty) { sql += "," + UCDBStyleNoFieldName; } sql += ") VALUES("; sql += outI.ToString() + ","; //ID sql += @"@" + UCDBPicFieldName; if (UCDBSmallPicFieldName != "") { sql += "," + @"@" + UCDBSmallPicFieldName; } if (UCDBRemarkFieldName != string.Empty) { sql += "," + SysString.ToDBString(txtRemark.Text.Trim()); } sql += "," + SysString.ToDBString(UCDataID.ToString()); if (UCDBStyleNoFieldName != string.Empty) { sql += "," + SysString.ToDBString(UCDataStyleNo); } sql += ")"; break; } int len = 1; if (UCDBSmallPicFieldName != string.Empty) { len = 2; } object[,] obja = new object[2, len]; obja[0, 0] = "@" + UCDBPicFieldName; obja[1, 0] = UCTemplatePic.ImageToByte(UCTemplatePic.ZoomImage(picShow.Image, UCUIPicWidth, UCUIPicHeight)); if (UCDBSmallPicFieldName != string.Empty) { obja[0, 1] = "@" + UCDBSmallPicFieldName; obja[1, 1] = UCTemplatePic.ImageToByte(UCTemplatePic.ZoomImage(picShow.Image, UCUISmallPicWidth, UCUISmallPicHeight)); } PicExecuteNonQuery(sql, obja); //SysUtils.ExecuteNonQuery } else if (UCInputMainType == 2) //仅是图片交互模式 { //代码待补充 m_UCDataLstImage.Add(UCTemplatePic.ZoomImage(picShow.Image, UCUIPicWidth, UCUIPicHeight)); m_UCDataLstSmallImage.Add(UCTemplatePic.ZoomImage(picShow.Image, UCUISmallPicWidth, UCUISmallPicHeight)); } return(outI); }