/// <summary>
/// 添加充电站全景图片
/// </summary>
/// <param name="bean"></param>
public void AddPilePicture(ChargStationFile bean)
{
Log.Debug("Add方法参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (bean.ZhanBh != null)
{
sql1.Append(" ZHAN_BH,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.ZhanBh);
}
if (!string.IsNullOrEmpty(bean.Id))
{
sql1.Append(" ID,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Id);
}
if (!string.IsNullOrEmpty(bean.Filename))
{
sql1.Append(" FILENAME,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Filename);
}
if (bean.Filecontext != null)
{
sql1.Append(" FILECONTEXT,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Filecontext);
}
if (bean.Filesize != null)
{
sql1.Append(" FILESIZE,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Filesize);
}
if (!string.IsNullOrEmpty(bean.Filemime))
{
sql1.Append(" FILEMIME,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.Filemime);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into dev_chargstationfile(" + sql1 + ") values(" + sql2 + ")";
Oop.Execute(sql, list.ToArray());
}
/// <summary>
/// 获取充电站全景图片
/// </summary>
/// <param name="context"></param>
public void GetChargStationFile(HttpContext context)
{
var chargstationfilebll = new ChargStationFileBll();
var cPictureMessage = new Message <Picture>();
var fileid = context.Request.Params["id"];
string ret = null;
if (string.IsNullOrEmpty(fileid))
{
cPictureMessage.Total = 0;
return;
}
var chargstationfile = new ChargStationFile
{
ZhanBh = int.Parse(fileid)
};
try
{
var dt = chargstationfilebll.FindBy(chargstationfile);
var list = ConvertHelper <Picture> .ConvertToList(dt);
foreach (var li in list)
{
var bytes = li.FileContext;
if (bytes == null)
{
continue;
}
var stream = new MemoryStream(bytes);
var img = Image.FromStream(stream);
string path = AppDomain.CurrentDomain.BaseDirectory;//获取文件的相对路径
string filePath = path + @"Scripts\pictureChargStation\SaveChargeStationFile\";
img.Save(filePath + li.Id + "." + li.FileMime);
var w = img.Width;
var h = img.Height;
li.Width = w;
li.Height = h;
li.FileContext = null;
}
cPictureMessage.Rows = list;
ret = Jss.Serialize(cPictureMessage);
}
catch (Exception e)
{
Log.Error(e);
}
context.Response.Write(ret);
}
/// <summary>
///
/// </summary>
/// <param name="bean"></param>
public void AddPilePicture(ChargStationFile bean)
{
_chargStationDal.AddPilePicture(bean);
}
protected void save_Click(object sender, EventArgs e)
{
string imgPath = MapPath("~/EditImages/" + guidString);
decimal stationid = zhanbh;
string zhanmc = d_ZhuanMc.Text.ToString();
bool b = csbll.QueryZhanIFExit(zhanmc);
DataTable dte = csbll.QueryZhanByZMC(zhanmc);
if (b == false && !decimal.Parse(dte.Rows[0]["ZHAN_BH"].ToString()).Equals(stationid))
{
Response.Write("<script>alert(\"充电场站名称已存在！\");</script>");
return;
}
string zhanjc = d_zhanjc.Text.ToString();
DataTable dt3 = csbll.QueryZhanByZJC(zhanjc);
if (dt3.Rows.Count > 0 && !decimal.Parse(dt3.Rows[0]["ZHAN_BH"].ToString()).Equals(stationid))
{
Response.Write("<script>alert(\"充电场站简称已存在！\");</script>");
return;
}
string xxdz = d_XiangXiDz.Text;
decimal jd = decimal.Parse(d_Longtude.Text.ToString());
decimal wd = decimal.Parse(d_Latitude.Text.ToString());
string yzdw = d_YeZhuDw.Text.ToString();
string lxr = d_LianXiR.Text.ToString();
string lxdh = d_LianXiDh.Text.ToString();
DateTime JianZhan_SJ = DateTime.Parse(Request.Form["d_JianZhan_SJ"].ToString());
DateTime tysj = DateTime.Parse(Request.Form["d_TouYun_Sj"].ToString());
ChargStation chargstation = new ChargStation();
chargstation.ZhuanMc = zhanmc;
chargstation.Zhan_Jc = zhanjc;
chargstation.XiangXiDz = xxdz;
chargstation.Longtude = jd;
chargstation.Latitude = wd;
chargstation.YeZhuDw = yzdw;
chargstation.LianXiDh = lxdh;
chargstation.LianXiR = lxr;
chargstation.JianZhan_Sj = JianZhan_SJ;
chargstation.TouYun_Sj = tysj;
chargstation.ZhanBh = stationid;
csbll.ModifyStation(chargstation);
//操作日志
string name = "";
if (null != Session[Constant.LoginUser])
{
name = (Session[Constant.LoginUser] as Employer ?? new Employer()).Name;
}
new OprLogBll().Add(new OprLog()
{
Operator = name,
OprSrc = "修改充电站，充电站id:" + zhanbh,
OperResult = "成功",
LogDate = DateTime.Now
});
//DataTable dte = csbll.QueryZhanIdByMC(zhanmc);
//zhanbh = dte.Rows[0]["zhanbh"].ToString();
//string json = "{\"ZHAN_BH\":" + stationid + ",\"ZHUAN_MC\":\"" + zhanmc
// + "\",\"YEZHU_DW\":\"" + yzdw + "\", \"LIANXI_R\":\"" + lxr + "\",\"LIANXI_DH\":\"" + lxdh
// + "\",\"ZHUANGLEI_X\":\"\",\"ZHUANGCHANG_J\":\"\",\"XIANGXI_DZ\":\"" + xxdz
// + "\",\"LONGTUDE\":\"" + jd + "\",\"LATITUDE\":\"" + wd
// + "\",\"CREATEDT\":\"" + CreateDT.ToString() + "\",\"UPDATEDT\":\"\"}";
//string ret = mapservice.UpdateCDZ(json);
//if (ret.ToLower() != "ok")
//{
// context.Response.Write("{\"success\":true,\"msg\":\"保存gis地图数据失败！\"}");
// return;
//}
if (ifonesave == "true")
{
if (Directory.Exists(imgPath))
{
byte[] fileBuffer = null;
decimal fileSize = 0;
ChargStationFile csfile = new ChargStationFile();
foreach (string flName in Directory.GetFiles(imgPath))
{
string strName = flName.Substring(flName.LastIndexOf("\\") + 1); //文件名
string tpid = Guid.NewGuid().ToString(); //图片id
string hz = strName.Substring(strName.LastIndexOf('.') + 1); //图片后缀
string strDataPath = imgPath + "\\" + strName; //数据库保存路径
fileBuffer = File.ReadAllBytes(strDataPath); //图片内容
fileSize = fileBuffer.Length; //图片大小
DataTable dt = csbll.QueryZhanByZMC(zhanmc);
if (dt.Rows.Count > 0)
{
csfile.ZhanBh = decimal.Parse(dt.Rows[0]["zhan_bh"].ToString());
}
csfile.Id = tpid;
csfile.Filename = strName;
csfile.Filecontext = fileBuffer;
csfile.Filesize = fileSize;
csfile.Filemime = hz;
csbll.AddPilePicture(csfile);
}
//删除解压文件夹
//Directory.Delete(imgPath, true);
ifonesave = "false";
ifexitdDirectory = false;
//string Id = (Session[Constant.LoginUser] as Employer ?? new Employer()).Id;
//Response.Redirect("/pages/ChargPileLedger/ChargStationEdit.htm?Id=" + Id );
}
}
//Response.Write("<script>alert(\"保存成功！\");</script>");
sign = "refresh";
}
protected void save_Click(object sender, EventArgs e)
{
string zhanid = Request["zhanbh"] ?? "";
if (zhanid.Length > 0)
{
string imgPath = MapPath("~/UpImages/" + guidString);
string zhanbh = "";
decimal stationid = decimal.Parse(zhanid.ToString());
ChargStationBll csbll = new ChargStationBll();
string zhanmc = ZhuanMc.Text.ToString();
bool b = csbll.QueryZhanIFExit(zhanmc);
DataTable dte = csbll.QueryZhanByZMC(zhanmc);
if (b == false && !decimal.Parse(dte.Rows[0]["ZHAN_BH"].ToString()).Equals(stationid))
{
Response.Write("<script>alert(\"充电场站名称已存在！\");</script>");
return;
}
string zjc = zhanjc.Text.ToString();
DataTable dt3 = csbll.QueryZhanByZJC(zjc);
if (dt3.Rows.Count > 0 && !decimal.Parse(dt3.Rows[0]["ZHAN_BH"].ToString()).Equals(stationid))
{
Response.Write("<script>alert(\"充电场站简称已存在！\");</script>");
return;
}
string xxdz = XiangXiDz.Text;
decimal jd = decimal.Parse(Longtude.Text.ToString());
decimal wd = decimal.Parse(Latitude.Text.ToString());
string yzdw = YeZhuDw.Text.ToString();
string lxr = LianXiR.Text.ToString();
string lxdh = LianXiDh.Text.ToString();
decimal boxsl = decimal.Parse(BoxCounts.Text.ToString());
DateTime jzsj = DateTime.Parse(JianZhan_SJ.Text.ToString());
DateTime tysj = DateTime.Parse(TouYun_Sj.Text.ToString());
ChargStation chargstation = new ChargStation();
chargstation.ZhuanMc = zhanmc;
chargstation.Zhan_Jc = zjc;
chargstation.XiangXiDz = xxdz;
chargstation.Longtude = jd;
chargstation.Latitude = wd;
chargstation.YeZhuDw = yzdw;
chargstation.LianXiDh = lxdh;
chargstation.LianXiR = lxr;
chargstation.BoxCounts = boxsl;
chargstation.JianZhan_Sj = jzsj;
chargstation.TouYun_Sj = tysj;
chargstation.ZhanBh = stationid;
csbll.ModifyStation(chargstation);
//操作日志
string name = "";
if (null != Session[Constant.LoginUser])
{
name = (Session[Constant.LoginUser] as Employer ?? new Employer()).Name;
}
new OprLogBll().Add(new OprLog()
{
Operator = name,
OprSrc = "添加充电场站",
OperResult = "成功",
LogDate = DateTime.Now
});
//DataTable dte = csbll.QueryZhanIdByMC(zhanmc);
//zhanbh = dte.Rows[0]["zhanbh"].ToString();
//string json = "{\"ZHAN_BH\":" + zhanbh + ",\"ZHUAN_MC\":\"" + zhanmc
// + "\",\"YEZHU_DW\":\"" + yzdw + "\", \"LIANXI_R\":\"" + lxr + "\",\"LIANXI_DH\":\"" + lxdh
// + "\",\"ZHUANGLEI_X\":\"\",\"ZHUANGCHANG_J\":\"\",\"XIANGXI_DZ\":\"" + xxdz
// + "\",\"LONGTUDE\":\"" + jd + "\",\"LATITUDE\":\"" + wd
// + "\",\"CREATEDT\":\"" + jzsj.ToString() + "\",\"UPDATEDT\":\"\"}";
//string ret = mapservice.UpdateCDZ(json);
//if (ret.ToLower() != "ok")
//{
// context.Response.Write("{\"success\":true,\"msg\":\"保存gis地图数据失败！\"}");
// return;
//}
csbll.DelStationFile(stationid);
byte[] fileBuffer = null;
decimal fileSize = 0;
ChargStationFile csfile = new ChargStationFile();
if (Directory.Exists(imgPath))
{
foreach (string flName in Directory.GetFiles(imgPath))
{
string strName = flName.Substring(flName.LastIndexOf("\\") + 1); //文件名
string tpid = Guid.NewGuid().ToString(); //图片id
string hz = strName.Substring(strName.LastIndexOf('.') + 1); //图片后缀
string strDataPath = imgPath + "\\" + strName; //数据库保存路径
fileBuffer = File.ReadAllBytes(strDataPath); //图片内容
fileSize = fileBuffer.Length; //图片大小
DataTable dt = csbll.QueryZhanByZMC(zhanmc);
if (dt.Rows.Count > 0)
{
csfile.ZhanBh = decimal.Parse(dt.Rows[0]["zhan_bh"].ToString());
}
csfile.Id = tpid;
csfile.Filename = strName;
csfile.Filecontext = fileBuffer;
csfile.Filesize = fileSize;
csfile.Filemime = hz;
csbll.AddPilePicture(csfile);
}
//删除解压文件夹
//Directory.Delete(imgPath, true);
}
//添加分支箱
//清除方法
DataTable dt2 = csbll.QueryBoxID(stationid);
string boxids = null;
if (dt2.Rows.Count > 0)
{
for (int i = 0; i < dt2.Rows.Count; i++)
{
boxids += dt2.Rows[i]["BRANCHNO"].ToString();
if (i < (dt2.Rows.Count - 1))
{
boxids += "_";
}
}
csbll.DelBranch(stationid);
csbll.DelPile(boxids);
}
Branch branch = new Branch();
DataTable dt1 = csbll.QueryZhanByZMC(zhanmc);
if (dt1.Rows.Count > 0)
{
branch.ZhuanBh = decimal.Parse(dt1.Rows[0]["zhan_bh"].ToString());
}
;
bool a = csbll.QueryBranch(branch.ZhuanBh);
for (int i = 0; i < boxsl; i++)
{
branch.Createdt = DateTime.Now;
if (a == false)
{
branch.BranchNo = branch.ZhuanBh * 100 + (i + 1);
}
else if (a == true)
{
DataTable dta = csbll.QueryBranchId(branch.ZhuanBh);
decimal branchid = decimal.Parse(dta.Rows[0]["BRANCHNO"].ToString());
branch.BranchNo = branchid + 1;
}
csbll.AddBranch(branch);
}
string Id = (Session[Constant.LoginUser] as Employer ?? new Employer()).Id;
decimal zhan_id = decimal.Parse(csbll.QueryZhanByZMC(zhanmc).Rows[0]["zhan_bh"].ToString());
Response.Redirect("/pages/ChargPileLedger/AddBranch.htm?bs=" + boxsl + "&Id=" + Id + "&gid=" + guidString + "&zhanbh=" + zhan_id);
}
else
{
string imgPath = MapPath("~/UpImages/" + guidString);
string zhanbh = "";
string zmc = ZhuanMc.Text.ToString();
bool b = csbll.QueryZhanIFExit(zmc);
if (b == false)
{
Response.Write("<script>alert(\"充电场站名称已存在！\")</script>");
return;
}
string zjc = zhanjc.Text.ToString();
DataTable dt2 = csbll.QueryZhanByZJC(zjc);
if (dt2.Rows.Count > 0)
{
Response.Write("<script>alert(\"充电场站简称已存在！\");</script>");
return;
}
string xxdz = XiangXiDz.Text;
decimal jd = decimal.Parse(Longtude.Text.ToString());
decimal wd = decimal.Parse(Latitude.Text.ToString());
string yzdw = YeZhuDw.Text.ToString();
string lxr = LianXiR.Text.ToString();
string lxdh = LianXiDh.Text.ToString();
decimal boxsl = decimal.Parse(BoxCounts.Text.ToString());
DateTime jzsj = DateTime.Parse(JianZhan_SJ.Text.ToString());;
DateTime tysj = DateTime.Parse(TouYun_Sj.Text.ToString());
ChargStation chargstation = new ChargStation();
chargstation.ZhuanMc = zmc;
chargstation.Zhan_Jc = zjc;
chargstation.XiangXiDz = xxdz;
chargstation.Longtude = jd;
chargstation.Latitude = wd;
chargstation.YeZhuDw = yzdw;
chargstation.LianXiDh = lxdh;
chargstation.LianXiR = lxr;
chargstation.BoxCounts = boxsl;
chargstation.JianZhan_Sj = jzsj;
chargstation.TouYun_Sj = tysj;
csbll.Add(chargstation);
//操作日志
string name = "";
if (null != Session[Constant.LoginUser])
{
name = (Session[Constant.LoginUser] as Employer ?? new Employer()).Name;
}
new OprLogBll().Add(new OprLog()
{
Operator = name,
OprSrc = "添加充电场站",
OperResult = "成功",
LogDate = DateTime.Now
});
//DataTable dte = csbll.QueryZhanIdByMC(zmc);
//zhanbh = dte.Rows[0]["zhanbh"].ToString();
//string json = "{\"ZHAN_BH\":" + zhanbh + ",\"ZHUAN_MC\":\"" + zmc
// + "\",\"YEZHU_DW\":\"" + yzdw + "\", \"LIANXI_R\":\"" + lxr + "\",\"LIANXI_DH\":\"" + lxdh
// + "\",\"ZHUANGLEI_X\":\"\",\"ZHUANGCHANG_J\":\"\",\"XIANGXI_DZ\":\"" + xxdz
// + "\",\"LONGTUDE\":\"" + jd + "\",\"LATITUDE\":\"" + wd
// + "\",\"CREATEDT\":\"" + jzsj.ToString() + "\",\"UPDATEDT\":\"\"}";
//string ret = mapservice.InsertIntoCDZ(json);
//if (ret.ToLower() != "ok")
//{
// context.Response.Write("{\"success\":true,\"msg\":\"保存gis地图数据失败！\"}");
// return;
//}
//如果存在guid文件夹，则执行图片保存
if (Directory.Exists(imgPath))
{
byte[] fileBuffer = null;
decimal fileSize = 0;
ChargStationFile csfile = new ChargStationFile();
foreach (string flName in Directory.GetFiles(imgPath))
{
string strName = flName.Substring(flName.LastIndexOf("\\") + 1); //文件名
string tpid = Guid.NewGuid().ToString(); //图片id
string hz = strName.Substring(strName.LastIndexOf('.') + 1); //图片后缀
string strDataPath = imgPath + "\\" + strName; //数据库保存路径
fileBuffer = File.ReadAllBytes(strDataPath); //图片内容
fileSize = fileBuffer.Length; //图片大小
DataTable dt = csbll.QueryZhanByZMC(zmc);
if (dt.Rows.Count > 0)
{
csfile.ZhanBh = decimal.Parse(dt.Rows[0]["zhan_bh"].ToString());
}
csfile.Id = tpid;
csfile.Filename = strName;
csfile.Filecontext = fileBuffer;
csfile.Filesize = fileSize;
csfile.Filemime = hz;
csbll.AddPilePicture(csfile);
}
}
//删除解压文件夹
//Directory.Delete(imgPath, true);
//添加分支箱
Branch branch = new Branch();
DataTable dt1 = csbll.QueryZhanByZMC(zmc);
if (dt1.Rows.Count > 0)
{
branch.ZhuanBh = decimal.Parse(dt1.Rows[0]["zhan_bh"].ToString());
}
;
bool a = csbll.QueryBranch(branch.ZhuanBh);
for (int i = 0; i < boxsl; i++)
{
branch.Createdt = DateTime.Now;
if (a == false)
{
branch.BranchNo = branch.ZhuanBh * 100 + (i + 1);
}
else if (a == true)
{
DataTable dta = csbll.QueryBranchId(branch.ZhuanBh);
decimal branchid = decimal.Parse(dta.Rows[0]["BRANCHNO"].ToString());
branch.BranchNo = branchid + 1;
}
csbll.AddBranch(branch);
}
string Id = (Session[Constant.LoginUser] as Employer ?? new Employer()).Id;
decimal zhan_id = decimal.Parse(csbll.QueryZhanByZMC(zmc).Rows[0]["zhan_bh"].ToString());
Response.Redirect("/pages/ChargPileLedger/AddBranch.htm?bs=" + boxsl + "&Id=" + Id + "&gid=" + guidString + "&zhanbh=" + zhan_id);
}
}
