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