我要实现的是:
1,上传一张楼层平面图.
2,在楼层平面图上,如何用鼠标画出一个房间的热点,然后跳出输入当前房间信息的输入框.
3,输入房间信息并提交.
4,最后的效果就是用户访问楼层图片时,点击房间的热点链接,显示房间信息.请问要实现上面的效果要如何做????????????
1,上传一张楼层平面图.
2,在楼层平面图上,如何用鼠标画出一个房间的热点,然后跳出输入当前房间信息的输入框.
3,输入房间信息并提交.
4,最后的效果就是用户访问楼层图片时,点击房间的热点链接,显示房间信息.请问要实现上面的效果要如何做????????????
太困难了。
估计要用插件
跳出输入当前房间信息的输入框,你可以用asp.net ajax controltoolkit中的 modalpopup控件
{
//判断上传的文件类型是否合法
string strFileType = System.IO.Path.GetExtension(FileUpload1.FileName).ToString().ToLower();
if (strFileType == ".xls" || strFileType == ".xlsx")
{
//重命名Excel并保存到服务器
//Random rd = new Random(1);
//string filename = DateTime.Now.Date.ToString("yyyyMMdd") + DateTime.Now.ToLongTimeString().Replace(":", "") + rd.Next(9999).ToString() + ".xls";
//string FilePath = Server.MapPath("file/") + filename;
//FileUpload1.PostedFile.SaveAs(FilePath);
//获取数据源并进行绑定
string mystring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" + Path.GetFullPath(FileUpload1.PostedFile.FileName) + ";Extended Properties=Excel 8.0";
//string mystring = "Provider = Microsoft.Jet.OLEDB.4.0;Data Source =" + Server.MapPath("file") + "/" + filename + ";Extended Properties=Excel 8.0";
OleDbConnection cnnxls = new OleDbConnection(mystring);
OleDbDataAdapter dataAd = new OleDbDataAdapter("select * from [Sheet1$]", cnnxls);
DataSet dataSet = new DataSet();
dataAd.Fill(dataSet);
//判断Excel中是否有数据
if (dataSet.Tables[0].Rows.Count > 0)
{
string sql = "";
string conn = "Provider=SQLOLEDB;" + System.Configuration.ConfigurationManager.ConnectionStrings["conn"].ConnectionString;
OleDbConnection _Conn = new OleDbConnection(conn);
_Conn.Open();
OleDbCommand _Cmd = null;
int num = 0;
for (int i = 0; i < dataSet.Tables[0].Rows.Count; i++)
{
sql = " insert into TD_PARTS_INFO(PI_ID,PD_ID,PI_ORDER,PI_IMG_NO,PI_NAME,PI_SINGLE,PI_REMARK) values("+"'"
+Guid.NewGuid().ToString()+"'"+ ",'101',"
+ "'" +dataSet.Tables[0].Rows[i].ItemArray[0].ToString() + "',"
+ "'" +dataSet.Tables[0].Rows[i].ItemArray[1].ToString() + "',"
+ "'" +dataSet.Tables[0].Rows[i].ItemArray[2].ToString() + "',"
+ Convert.ToInt32(dataSet.Tables[0].Rows[i].ItemArray[3]) + ","
+ "'"+dataSet.Tables[0].Rows[i].ItemArray[4].ToString() + "') ";
try
{
_Cmd = new OleDbCommand(sql, _Conn);
_Cmd.ExecuteNonQuery();
num = num + 1;
}
catch (Exception ex)
{
ex.Message.ToString();
}
}
if (num != 0)
{
Label1.Text = "数据成功导入" + num.ToString() + " 条!";
//GridView1.DataSource = new ().SelectAll();
//GridView1.DataBind();
this.GridView1.DataSource=BLL.TD_PARTS_INFOManager.SelectALL();
this.GridView1.DataBind();
dataAd.Dispose();
_Conn.Close();
_Conn.Dispose();
}
else
{
Label1.Text = "数据导入失败!";
}
}
}
else
{
Label1.Text = "文件类型不符,请重新上传";
}
}以前实现的代码 你可以借鉴借鉴