/// <summary>
/// 获取桩最后一次充电记录信息
/// </summary>
/// <param name="context"></param>
/// <returns></returns>
private string getDJZMData(HttpContext context)
{
string ret = null;
var message = new JsonMessage <ChargePileDetailInfo>();
var chargPileBll = new ChargPileBll();
var id = context.Request.Params["zhuanid"];
if (string.IsNullOrEmpty(id))
{
return(ret);
}
var zhuanid = int.Parse(id);
try
{
var dt = chargPileBll.FindByChargePileDetailInfo(zhuanid);
var list = ConvertHelper <ChargePileDetailInfo> .ConvertToList(dt);
message.Rows = list;
message.Status = 1;
message.Msg = "返回成功";
message.JsExecuteMethod = "ajaxSuccess_setChargePileInfo";
ret = _jss.Serialize(message);
}
catch (Exception e)
{
Log.Error(e);
}
return(ret);
}
public static string QueryChargePileInfo(string chargpileid)
{
ChargPileBll chargPileBll = new ChargPileBll();
JsonMessage <ChargePileInfoParam> jsonMessage = new JsonMessage <ChargePileInfoParam>();
string ret = null;
if (string.IsNullOrEmpty(chargpileid))
{
return(null);
}
try
{
var dt = chargPileBll.QueryByParam(chargpileid);
var list = ConvertHelper <ChargePileInfoParam> .ConvertToList(dt);
jsonMessage.Rows = list;
jsonMessage.Msg = "返回成功";
jsonMessage.Status = 1;
}
catch (Exception)
{
jsonMessage.Msg = "返回失败";
jsonMessage.Status = 0;
throw;
}
ret = Jss.Serialize(jsonMessage);
return(ret);
}
/// <summary>
/// 获取充电桩
/// </summary>
/// <param name="context"></param>
private void GetChargPile(HttpContext context)
{
try
{
int page = 1, rows = 15, total = 0;
string tmp = context.Request["page"].ToString();
if (!string.IsNullOrEmpty(tmp))
{
page = int.Parse(tmp);
}
tmp = context.Request["rows"].ToString();
if (!string.IsNullOrEmpty(tmp))
{
rows = int.Parse(tmp);
}
decimal zhanbh = decimal.Parse(context.Request["zhanbh"].ToString());
ChargPileBll cpbll = new ChargPileBll();
List <ChargPile> personnelList = cpbll.GetChargPileList(zhanbh, page, rows, ref total);
PageObject <ChargPile> pageO = new PageObject <ChargPile>();
pageO.total = total;
pageO.rows = personnelList;
var str = jss.Serialize(pageO);
context.Response.Write(str);
}
catch (Exception e)
{
Log.Error(e);
}
}
/// <summary>
/// 获取桩厂家
/// </summary>
/// <param name="context"></param>
private void GetChangJia1(HttpContext context)
{
try
{
ChargPileBll cpbll = new ChargPileBll();
DataTable dt = cpbll.QueryChangJia();
var list = ConvertHelper <ChargPileTypes> .ConvertToList(dt);
var str = jss.Serialize(list);
context.Response.Write(str);
}
catch (Exception e)
{
Log.Error(e);
}
}
/// <summary>
/// 根据桩厂家获取桩型号
/// </summary>
/// <param name="context"></param>
private void GetXingHao1(HttpContext context)
{
try
{
ChargPileBll cpbll = new ChargPileBll();
string cj = context.Request["cj"].ToString();
DataTable dt = cpbll.QueryXHBYCJ(cj);
var list = ConvertHelper <ChargPileTypes> .ConvertToList(dt);
var str = jss.Serialize(list);
context.Response.Write(str);
}
catch (Exception e)
{
Log.Error(e);
}
}
/// <summary>
/// 获取桩厂家
/// </summary>
/// <param name="context"></param>
private void GetChangJia(HttpContext context)
{
try
{
ChargPileBll cpbll = new ChargPileBll();
DataTable dt = cpbll.QueryChangJia();
var list = ConvertHelper <ChargPileTypes> .ConvertToList(dt);
PageObject <ChargPileTypes> pageO = new PageObject <ChargPileTypes>();
pageO.total = list.Count;
pageO.rows = list;
var str = jss.Serialize(pageO);
context.Response.Write(str);
}
catch (Exception e)
{
Log.Error(e);
}
}
/// <summary>
/// 查询充电桩总数量
/// </summary>
/// <returns></returns>
public string FindByChargePileCount()
{
string ret = null;
var message = new JsonMessage <string>();
var chargpilebll = new ChargPileBll();
try
{
var count = chargpilebll.FindByChargePileCount();
message.Total = count;
message.Status = 1;
message.JsExecuteMethod = "ajaxsuccess_setChargePileCount";
ret = _jss.Serialize(message);
}
catch (Exception e)
{
Log.Error(e);
}
return(ret);
}
/// <summary>
/// 根据充电站获取分支箱
/// </summary>
/// <param name="context"></param>
private void GetBranch(HttpContext context)
{
try
{
string zhanbh = context.Request["zhanbh"].ToString();
ChargPileBll cpbll = new ChargPileBll();
DataTable dt = cpbll.QueryBranch(zhanbh);
var list = ConvertHelper <Branch> .ConvertToList(dt);
PageObject <Branch> pageO = new PageObject <Branch>();
pageO.total = list.Count;
pageO.rows = list;
var str = jss.Serialize(pageO);
context.Response.Write(str);
}
catch (Exception e)
{
Log.Error(e);
}
}
/// <summary>
/// 根据桩型号获取桩类型
/// </summary>
/// <param name="context"></param>
private void GetLeiXing(HttpContext context)
{
try
{
ChargPileBll cpbll = new ChargPileBll();
string xh = context.Request["xh"].ToString();
string cj = context.Request["cj"].ToString();
DataTable dt = cpbll.QueryLXBYXH(xh, cj);
var list = ConvertHelper <ChargPileTypes> .ConvertToList(dt);
PageObject <ChargPileTypes> pageO = new PageObject <ChargPileTypes>();
pageO.total = list.Count;
pageO.rows = list;
var str = jss.Serialize(pageO);
context.Response.Write(str);
}
catch (Exception e)
{
Log.Error(e);
}
}
public static string ChargePileCurrentTime(string chargpileid)
{
var message = new InvokeMessage <PointCfgItem>();
string ret;
int id;
if (!string.IsNullOrEmpty(chargpileid))
{
id = int.Parse(chargpileid);
}
else
{
message.Status = 2;
message.Msg = "数据为空！";
ret = Jss.Serialize(message);
return(ret);
}
var zhuanType = string.Empty;
var chargepile = new ChargPileBll();
var dt = chargepile.FindByChargePileType(id);
if (dt.Rows.Count <= 0)
{
}
else
{
zhuanType = dt.Rows[0]["piletypeid"].ToString();
}
var jsonSetting = RequestChargePileCurrentTimeSetting(chargpileid);
var c = new RpcClient {
RpcUrl = Url
};
var req = JsonConvert.DeserializeObject <JsonRequest>(jsonSetting);
try
{
Log.Debug("查询接口之前时间：" + DateTime.Now);
var resp = c.Invoke(req);
Log.Debug("查询接口之后时间：" + DateTime.Now);
var success = resp.Success;
var messages = resp.Message;
switch (success)
{
case true:
var so = JsonConvert.SerializeObject(resp, Formatting.Indented);
var json = JObject.Parse(so); //创建JSON对象
var listItem = JsonConvertToList(json);
Log.Debug("转换接口数据时间：" + DateTime.Now);
message.Current = GetCurrent(zhuanType, listItem); //获取电流的值和范围
Log.Debug("获取电流时间：" + DateTime.Now);
message.Voltage = GetVoltage(zhuanType, listItem); //获取电压表的值和范围
Log.Debug("获取电压时间：" + DateTime.Now);
var cfgList = IsHavePointCfgAndGatItemTable(id, listItem); //判断接口数据是否存在于PointCfg和GatItem里
Log.Debug("判断1时间：" + DateTime.Now);
var warnlist = IsHaveWarnRec(cfgList); //判断接口数据是否存在于WarnRec表里
Log.Debug("判断2时间：" + DateTime.Now);
message.Rows = warnlist;
message.Status = 3;
message.Msg = "返回成功";
ret = Jss.Serialize(message);
Log.Debug("返回时间：" + DateTime.Now);
return(ret);
case false:
message.Status = 0;
message.Msg = messages;
ret = Jss.Serialize(message);
return(ret);
}
}
catch (Exception)
{
}
message.Status = 0;
message.Msg = "返回失败";
ret = Jss.Serialize(message);
return(ret);
}
/// <summary>
/// 添加充电桩
/// </summary>
/// <param name="context"></param>
private void AddChargPile(HttpContext context)
{
try
{
ChargPileBll cpbll = new ChargPileBll();
int BOX_ID = int.Parse(context.Request["BOX_ID"].ToString());
string CHANGJIAO_BH = context.Request["CHANGJIAO_BH"].ToString();
string YUNXING_BH = context.Request["YUNXING_BH"].ToString();
DataTable dt = cpbll.QueryPileByYXBH(YUNXING_BH);
if (dt.Rows.Count > 0)
{
context.Response.Write("{\"success\":false,\"msg\":\"运行编号已存在！\"}");
return;
}
string CHANGJIA = context.Request["CHANGJIA"].ToString();
string ZHUANGXING_H = context.Request["ZHUANGXING_H"].ToString();
string ZHUANGLEI_X = context.Request["ZHUANGLEI_X"].ToString();
string ZHUANGTAI = context.Request["ZHUANGTAI"].ToString();
string sj = context.Request["TOUYOU_SJ"] ?? "";
DateTime TOUYOU_SJ = new DateTime();
if (sj.Length > 0)
{
TOUYOU_SJ = DateTime.Parse(sj);
}
ChargPile chargpile = new ChargPile();
chargpile.BOX_ID = BOX_ID;
chargpile.CHANGJIAO_BH = CHANGJIAO_BH;
chargpile.YUNXING_BH = YUNXING_BH;
chargpile.CHANGJIA = CHANGJIA;
chargpile.ZHUANGXING_H = ZHUANGXING_H;
chargpile.ZHUANGLEI_X = ZHUANGLEI_X;
chargpile.ZHUANGTAI = ZHUANGTAI;
chargpile.TOUYOU_SJ = TOUYOU_SJ;
cpbll.AddChargPile(chargpile);
decimal zhanbh = decimal.Parse(BOX_ID.ToString().Substring(0, 3));
//保存桩厂家和装类型到充电站表里
DataTable dtable = csbll.QueryTypes(zhanbh);
List <string> listcj = new List <string>();
List <string> listlx = new List <string>();
for (int i = 0; i < dtable.Rows.Count; i++)
{
if (listcj.Count <= 0)
{
listcj.Add(dtable.Rows[i]["CHANGJIA"].ToString());
}
else
{
for (int j = 0; j < listcj.Count; j++)
{
if (listcj[j] == dtable.Rows[i]["CHANGJIA"].ToString())
{
break;
}
if (j == listcj.Count - 1)
{
listcj.Add(dtable.Rows[i]["CHANGJIA"].ToString());
}
}
}
}
for (int i = 0; i < dtable.Rows.Count; i++)
{
if (listlx.Count <= 0)
{
listlx.Add(dtable.Rows[i]["ZHUANGLEI_X"].ToString());
}
else
{
for (int j = 0; j < listlx.Count; j++)
{
if (listlx[j] == dtable.Rows[i]["ZHUANGLEI_X"].ToString())
{
break;
}
if (j == listlx.Count - 1)
{
listlx.Add(dtable.Rows[i]["ZHUANGLEI_X"].ToString());
}
}
}
}
string cj = "";
string zlx = "";
for (int i = 0; i < listcj.Count; i++)
{
cj += listcj[i].ToString();
if (i < listcj.Count - 1)
{
cj += ",";
}
}
for (int i = 0; i < listlx.Count; i++)
{
zlx += listlx[i].ToString();
if (i < listlx.Count - 1)
{
zlx += ",";
}
}
ChargStation cstion = new ChargStation();
cstion.ZhuangLeiX = zlx;
cstion.ZhuangChangJ = cj;
cstion.ZhanBh = zhanbh;
csbll.SaveZhan(cstion);
//操作日志
string name = "";
if (null != context.Session[Constant.LoginUser])
{
name = (context.Session[Constant.LoginUser] as Employer ?? new Employer()).Name;
}
else
{
context.Response.Write("{\"success\":true,\"msg\":\"保存成功！\"}");
}
new OprLogBll().Add(new OprLog()
{
Operator = name,
OprSrc = "保存充电桩",
OperResult = "成功",
TargetDev = BOX_ID,
LogDate = DateTime.Now
});
context.Response.Write("{\"success\":true,\"msg\":\"保存成功！\"}");
}
catch (Exception e)
{
Log.Error(e);
context.Response.Write("{\"success\":false,\"msg\":\"保存失败！\"}");
}
}
/// <summary>
/// 根据桩id删除充电桩
/// </summary>
/// <param name="context"></param>
private void DelChargPile(HttpContext context)
{
try
{
string chargPileId = context.Request["pileid"].ToString();
ChargPileBll cpbll = new ChargPileBll();
cpbll.DelChargPile(chargPileId);
decimal zhanbh = decimal.Parse(chargPileId.ToString().Substring(0, 3));
//保存桩厂家和装类型到充电站表里
DataTable dtable = csbll.QueryTypes(zhanbh);
List <string> listcj = new List <string>();
List <string> listlx = new List <string>();
for (int i = 0; i < dtable.Rows.Count; i++)
{
if (listcj.Count <= 0)
{
listcj.Add(dtable.Rows[i]["CHANGJIA"].ToString());
}
else
{
for (int j = 0; j < listcj.Count; j++)
{
if (listcj[j] == dtable.Rows[i]["CHANGJIA"].ToString())
{
break;
}
if (j == listcj.Count - 1)
{
listcj.Add(dtable.Rows[i]["CHANGJIA"].ToString());
}
}
}
}
for (int i = 0; i < dtable.Rows.Count; i++)
{
if (listlx.Count <= 0)
{
listlx.Add(dtable.Rows[i]["ZHUANGLEI_X"].ToString());
}
else
{
for (int j = 0; j < listlx.Count; j++)
{
if (listlx[j] == dtable.Rows[i]["ZHUANGLEI_X"].ToString())
{
break;
}
if (j == listlx.Count - 1)
{
listlx.Add(dtable.Rows[i]["ZHUANGLEI_X"].ToString());
}
}
}
}
string cj = "";
string zlx = "";
for (int i = 0; i < listcj.Count; i++)
{
cj += listcj[i].ToString();
if (i < listcj.Count - 1)
{
cj += ",";
}
}
for (int i = 0; i < listlx.Count; i++)
{
zlx += listlx[i].ToString();
if (i < listlx.Count - 1)
{
zlx += ",";
}
}
ChargStation cstion = new ChargStation();
cstion.ZhuangLeiX = zlx;
cstion.ZhuangChangJ = cj;
cstion.ZhanBh = zhanbh;
csbll.SaveZhan(cstion);
//操作日志
string name = "";
if (null != context.Session[Constant.LoginUser])
{
name = (context.Session[Constant.LoginUser] as Employer ?? new Employer()).Name;
}
else
{
context.Response.Write("{\"success\":true,\"msg\":\"删除成功！\"}");
}
new OprLogBll().Add(new OprLog()
{
Operator = name,
OprSrc = "删除充电桩,桩id：" + chargPileId,
OperResult = "成功",
LogDate = DateTime.Now
});
context.Response.Write("{\"success\":true,\"msg\":\"删除成功！\"}");
}
catch (Exception e)
{
Log.Error(e);
context.Response.Write("{\"success\":false,\"msg\":\"删除失败！\"}");
}
}
