public static int deleteRecord(UpImage obj)
{
string strSQL = "delete from upImage where imageId='" + obj.imageId + "'";
int iRet = DBOper.execNonQueryBySQLText(strSQL);
return(iRet);
}
public static int updateRecord(UpImage obj)
{
string strSQL = "update upImage set savepath='" + obj.savepath + "',magazineId='" + obj.magazineId + "',sequence=" + obj.sequence + ",imageDesc='" + obj.imageDesc + "',uptime='" + obj.uptime + "',articleId='" + obj.articleId + "' where imageId='" + obj.imageId + "'";
int iRet = DBOper.execNonQueryBySQLText(strSQL);
return(iRet);
}
private void BindData(UpImage obj)
{
DataTable dt = UpImage.selectDataTable(obj);
GridView1.DataSource = dt;
GridView1.DataBind();
}
public static int insertRecord(UpImage obj)
{
string strSQL = "insert into upImage(imageId,savepath,magazineId,sequence,imageDesc,uptime,articleId) values('" + obj.imageId + "','" + obj.savepath + "','" + obj.magazineId + "'," + obj.sequence + ",'" + obj.imageDesc + "','" + obj.uptime + "','" + obj.articleId + "')";
int iRet = DBOper.execNonQueryBySQLText(strSQL);
return(iRet);
}
protected void Button1_Click(object sender, EventArgs e)
{
string upPath = "./image/" + DropDownList1.SelectedValue + "/"; //上传文件路径
//int upLength = 5; //上传文件大小
string upFileExtName = "|jpg|jpeg|";
HttpFileCollection _files = System.Web.HttpContext.Current.Request.Files;
string webFilePath = "";
for (int i = 0; i < _files.Count; i++)
{
string name = _files[i].FileName;
FileInfo fi = new FileInfo(name);
string oldfilename = fi.Name;
string scExtension = fi.Extension.ToLower();
string fileName = TextBox3.Text + fi.Extension; // 文件名称，当前时间（yyyyMMddhhmmssfff）
webFilePath = Server.MapPath(upPath) + fileName; // 服务器端文件路径
if (upFileExtName.IndexOf(scExtension.Replace(".", "")) == -1)
{
ClientScript.RegisterStartupScript(this.GetType(), "upfileOK", "alert('提示：文件类型不符" + scExtension + "');", true);
return;
}
//if ((fi.Length / (1024 * 1024)) > upLength)
//{
// ClientScript.RegisterStartupScript(this.GetType(), "upfileOK", "alert('大小超出 " + upLength + " M的限制，请处理后再上传！');", true);
// return;
//}
try
{
_files[i].SaveAs(webFilePath);
UpImage obj = new UpImage();
obj.imageId = DateTime.Now.ToString("yyyyMMddhhmmssfff");
obj.savepath = webFilePath;
obj.magazineId = DropDownList1.SelectedValue;
obj.sequence = System.Int32.Parse(TextBox3.Text);
obj.uptime = DateTime.Now;
string strsql = "select * from article where articleName='" + DropDownList2.SelectedValue + "' and magazineId='" + DropDownList1.SelectedValue + "'";
DataTable dt1 = DBOper.execQueryBySQLText(strsql);
obj.articleId = dt1.Rows[0]["articleId"].ToString();
obj.imageDesc = TextBox4.Text;
UpImage.insertRecord(obj);
ClientScript.RegisterStartupScript(this.GetType(), "upfileOK", "alert('提示：文件上传成功');", true);
}
catch (Exception ex)
{
ClientScript.RegisterStartupScript(this.GetType(), "upfileOK", "alert('提示：文件上传失败" + ex.Message + "');", true);
}
}
}
public static DataTable selectDataTable(UpImage obj)
{
string strSQL = "select * from upImage where 1=1 ";
if (obj.magazineId != "" && obj.magazineId != null)
{
strSQL = strSQL + "and magazineId='" + obj.magazineId + "'";
}
if (obj.articleId != "" && obj.articleId != null)
{
strSQL = strSQL + "and articleId='" + obj.articleId + "'";
}
DataTable dt = DBOper.execQueryBySQLText(strSQL);
return(dt);
}
private UpImage searchCon()
{
UpImage obj = new UpImage();
obj.magazineId = DropDownList1.SelectedValue;
if (DropDownList2.SelectedValue != "")
{
string strSQL = "select * from article where articleName='" + DropDownList2.SelectedValue + "'";
DataTable dt = DBOper.execQueryBySQLText(strSQL);
obj.articleId = dt.Rows[0]["articleId"].ToString();
}
else
{
obj.articleId = "";
}
return(obj);
}
public UpImage SaveImage(IFormFile file, ClaimsPrincipal user)
{
var userId = _userManager.GetUserId(user);
var rePath = _upImgPath + "/" + Guid.NewGuid().ToString("N") + Path.GetExtension(file.FileName);
var fileSavePath = GetSavePath(rePath);
var stream = new FileStream(fileSavePath, FileMode.CreateNew);
file.CopyTo(stream);
stream.Close();
UpImage upImage = new UpImage
{
Path = rePath,
UploadTime = DateTime.Now,
UserId = userId
};
_context.UpImage.Add(upImage);
_context.SaveChanges();
return(upImage);
}
public void PrepareSources(WhoIs w, Side s)
{
if (CurrentType == DecalType.Rock && w == WhoIs.Ground)
{
Vector3 v3 = new Vector3();
switch (s)
{
//x и -y указывают на ячейку Sand левый верхний угол
case Side.Down:
//rght h=hor t=top
v3.x = (float)x / 10;
v3.y = (float)-y / 10;
v3.z = 0;
DownImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
DownImage.name = x + "_" + y + "DecalDownImage_";
DownImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[29];
DownImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
case Side.Left:
//rgvl v=vert l=left
v3.x = (float)x / 10;
v3.y = (float)-y / 10;
v3.z = 0;
LeftImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
LeftImage.name = x + "_" + y + "DecalLeftImage_";
LeftImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[37];
LeftImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
case Side.Right:
//rgvr
v3.x = (float)x / 10 + 0.06f;
v3.y = (float)-y / 10;
v3.z = 0;
RightImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
RightImage.name = x + "_" + y + "DecalRightImage_";
RightImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[28];
RightImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
case Side.Up:
//rghd
v3.x = (float)x / 10;
v3.y = (float)-y / 10 - 0.07f;
v3.z = 0;
UpImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
UpImage.name = x + "_" + y + "DecalUpImage_";
UpImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[34];
UpImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
}
}
if (CurrentType == DecalType.Sand && w == WhoIs.Ground)
{
Vector3 v3 = new Vector3();
switch (s)
{
//x и -y указывают на ячейку Sand левый верхний угол
case Side.Down:
//gght h=hor t=top
v3.x = (float)x / 10;
v3.y = (float)-y / 10;
v3.z = 0;
DownImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
DownImage.name = x + "_" + y + "DecalDownImage_";
DownImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[36];
DownImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
case Side.Left:
//ggvl v=vert l=left
v3.x = (float)x / 10;
v3.y = (float)-y / 10;
v3.z = 0;
LeftImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
LeftImage.name = x + "_" + y + "DecalLeftImage_";
LeftImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[35];
LeftImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
case Side.Right:
//ggvr
v3.x = (float)x / 10 + 0.06f;
v3.y = (float)-y / 10;
v3.z = 0;
RightImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
RightImage.name = x + "_" + y + "DecalRightImage_";
RightImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[25];
RightImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
case Side.Up:
//gghd
v3.x = (float)x / 10;
v3.y = (float)-y / 10 - 0.07f;
v3.z = 0;
UpImage = (GameObject)MonoBehaviour.Instantiate(prefab, v3, Quaternion.identity);
UpImage.name = x + "_" + y + "DecalUpImage_";
UpImage.GetComponent <SpriteRenderer>().sprite = StaticSpriteCache.sprites[26];
UpImage.GetComponent <SpriteRenderer>().sortingOrder = 1;
break;
}
}
//switch (CurrentType)
//{
// case DecalType.Rock & w == WhoIs.Bomb:
// switch (s)
// {
// case Side.Down:
// DownImage.Source = ResCache.Brick(18, 4);
// break;
// case Side.Left:
// LeftImage.Source = ResCache.Brick(18, 5);
// break;
// case Side.Right:
// RightImage.Source = ResCache.Brick(18, 6);
// break;
// case Side.Up:
// UpImage.Source = ResCache.Brick(18, 3);
// break;
// }
// break;
// //SetUpImagesRockBlack()
// case DecalType.Sand && w == WhoIs.Bomb:
// switch (s)
// {
// case Side.Down:
// DownImage.Source = ResCache.Brick(18, 2);
// break;
// case Side.Left:
// LeftImage.Source = ResCache.Brick(17, 10);
// break;
// case Side.Right:
// RightImage.Source = ResCache.Brick(18, 1);
// break;
// case Side.Up:
// UpImage.Source = ResCache.Brick(17, 9);
// break;
// }
// break;
// //SetUpImagesSandBlack()
// case DecalType.Rock & w == WhoIs.Ground:
// switch (s)
// {
// case Side.Down:
// DownImage.Source = ResCache.Brick(17, 5);
// break;
// case Side.Left:
// LeftImage.Source = ResCache.Brick(17, 6);
// break;
// case Side.Right:
// RightImage.Source = ResCache.Brick(17, 7);
// break;
// case Side.Up:
// UpImage.Source = ResCache.Brick(17, 4);
// break;
// }
// break;
// //SetUpImagesRock()
// case DecalType.Sand & w == WhoIs.Ground:
// switch (s)
// {
// case Side.Down:
// DownImage.Source = ResCache.Brick(17, 3);
// break;
// case Side.Left:
// LeftImage.Source = ResCache.Brick(17, 1);
// break;
// case Side.Right:
// RightImage.Source = ResCache.Brick(17, 2);
// break;
// case Side.Up:
// UpImage.Source = ResCache.Brick(17, 0);
// break;
// }
// break;
// //SetUpImagesSand()
//}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
if (UpImage.HasFile)
{
FileInfo file = new FileInfo(UpImage.PostedFile.FileName);
if (file.Extension.ToLower() != ".bmp" && file.Extension.ToLower() != ".jpg" && file.Extension.ToLower() != ".jpeg" && file.Extension.ToLower() != ".png" && file.Extension.ToLower() != ".gif")
{
Response.Write("<script>alert('上传的图片格式应为bmp/jpg/jpeg/png/gif格式');history.back(-1);</script>");
return;
}
string filename = UpImage.PostedFile.FileName;
filename = System.IO.Path.GetFileName(filename);
//改文件名
int index = filename.LastIndexOf(".");
string lastName = filename.Substring(index, filename.Length - index);//获得文件后缀类型
//新文件名称,以时间年月日时分秒作为文件名
string newname = "BBSSubject" + DateTime.Now.ToString("yyyyMMddhhmmss") + lastName;
double size = UpImage.PostedFile.ContentLength;
if (size >= 1024000)
{
Response.Write("<script>alert('添加失败！（图片容量请不要超过1MB）')</script>");
return;
}
// 客户端文件路径 ,取得图片的文件名
string webFilePath = Server.MapPath("/NewsImages/" + newname);
if (!File.Exists(webFilePath))
{
UpImage.SaveAs(webFilePath); // 使用 SaveAs 方法保存文件
System.Drawing.Image image = System.Drawing.Image.FromFile(webFilePath);
float a = image.Width / image.Height;
if (a > 5)
{
image.Dispose();
File.Delete(webFilePath);
Response.Write("<script>alert('高宽比例不合适');</script>");
return;
}
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(image, 80, 80);
string path = Server.MapPath("/IndexImages/" + newname);
if (!File.Exists(path))
{
bmp.Save(path);
}
image.Dispose();
bmp.Dispose();
File.Delete(webFilePath);
}
else
{
Response.Write("<script>alert('上传失败，请重试！')</script>");
return;
}
string title = Server.HtmlEncode(txtModuleName.Text.Trim());
string describe = Server.HtmlEncode(Describe.Text.Trim());
string sqlstr = "insert into tb_Module "
+ "(ModuleName,ModuleDate,ModuleImage,ModuleDescribe)"
+ "values('" + title + "','" + DateTime.Now.ToString() + "','" + newname + "','" + describe + "')";
if (sqlBind.DataCom(sqlstr))
{
Response.Write("<script lanuage=javascript>alert('添加成功');location='ManageMudole.aspx'</script>");
}
}
}
//修改模块信息
protected void btnModify_Click(object sender, EventArgs e)
{
if (UpImage.PostedFile.ContentLength == 0)
{
string sqlstr = "update tb_Module set ModuleName='"
+ txtModTitle.Text + "',ModuleDescribe='"
+ Describe.Text + "' where ModuleID='" + Request["ModuleID"].ToString() + "'";
if (sqlBind.DataCom(sqlstr))
{
Response.Write("<script>alert('修改成功');window.location.href='ManageMudole.aspx';</script>");
}
else
{
Response.Write("<script>alert('修改失败');history.back();</script>");
}
}
else
{
FileInfo file1 = new FileInfo(UpImage.PostedFile.FileName);
if (file1.Extension != ".bmp" && file1.Extension != ".jpg" && file1.Extension != ".jpeg" && file1.Extension != ".png" && file1.Extension != ".gif")
{
Response.Write("<script>alert('上传的图片格式应为bmp/jpg/jpeg/png/gif格式');history.back(-1);</script>");
return;
}
double size = UpImage.PostedFile.ContentLength;
if (size >= 1024000)
{
Response.Write("<script>alert('添加失败！（图片容量请不要超过1MB）')</script>");
return;
}
string name = this.Image1.ImageUrl.Substring(14); //原来图片的URL
string webFilePath = Server.MapPath("~/NewsImages/" + name); //用来删除原有的图片
string indexpath = Server.MapPath(this.Image1.ImageUrl);
string filename = UpImage.PostedFile.FileName;
filename = System.IO.Path.GetFileName(filename);
//改文件名
int index = filename.LastIndexOf(".");
string lastName = filename.Substring(index, filename.Length - index);//获得文件后缀类型
//新文件名称,以时间年月日时分秒作为文件名
string newname = "BBSSubject" + DateTime.Now.ToString("yyyyMMddhhmmss") + lastName;
string newpath = Server.MapPath("~/NewsImages/" + newname);//用来保存新上传的图片
string newindexpath = Server.MapPath("~/IndexImages/" + newname);
System.IO.FileInfo file = new System.IO.FileInfo(webFilePath);
System.IO.FileInfo indexfile = new System.IO.FileInfo(indexpath);
if (file.Exists)
{
file.Delete();//删除
}
if (indexfile.Exists)
{
indexfile.Delete();//删除
}
if (!File.Exists(newpath))
{
UpImage.SaveAs(newpath);// 使用 SaveAs 方法保存文件
System.Drawing.Image image = System.Drawing.Image.FromFile(newpath);
float a = image.Width / image.Height;
if (a > 5)
{
image.Dispose();
File.Delete(newpath);
Response.Write("<script>alert('高宽比例不合适');</script>");
return;
}
System.Drawing.Bitmap bmp = new System.Drawing.Bitmap(image, 80, 80);
if (!File.Exists(newindexpath))
{
bmp.Save(newindexpath);
}
image.Dispose();
bmp.Dispose();
File.Delete(newpath);
}
string title = Server.HtmlEncode(txtModTitle.Text.Trim());
string describe = Server.HtmlEncode(Describe.Text.Trim());
string sqlstr = "update tb_Module set ModuleName='"
+ title + "',ModuleDescribe='"
+ describe + "',ModuleImage='"
+ newname + "' where ModuleID='" + Request["ModuleID"].ToString() + "'";
if (sqlBind.DataCom(sqlstr))
{
Response.Write("<script>alert('修改成功');window.location.href='ManageMudole.aspx';</script>");
}
else
{
Response.Write("<script>alert('修改失败');history.back();</script>");
}
}
}
