/// <summary>
/// 修改充电桩
/// </summary>
/// <param name="chargpile"></param>
public void EditChargPile(ChargPile chargpile)
{
decimal? boxid = chargpile.BOX_ID;
DataTable dt = cpd.QueryChargPileID(boxid);
bool b = QueryBoxid(boxid);
decimal? DEV_CHARGPILE = chargpile.DEV_CHARGPILE;
DataTable de = cpd.QueryBoxidByPileID(DEV_CHARGPILE);
decimal bid = decimal.Parse(de.Rows[0]["BOX_ID"].ToString());
if (bid != chargpile.BOX_ID)
{
if (b == false)
{
chargpile.DEV_CHARGPILE = boxid * 1000 + 1;
}
else if (b == true)
{
chargpile.DEV_CHARGPILE = decimal.Parse(dt.Rows[0]["DEV_CHARGPILE"].ToString()) + 1;
}
}
string zhuangxing_h = chargpile.ZHUANGXING_H;
DataTable dtable = cpd.QueryLXBYXH(zhuangxing_h, chargpile.CHANGJIA);
chargpile.PILETYPEID = dtable.Rows[0]["PARSERKEY"].ToString();
cpd.EditChargPile(chargpile);
}
/// <summary>
/// 添加充电桩
/// </summary>
/// <param name="bean"></param>
public void AddChargPile(ChargPile bean)
{
Log.Debug("Add方法参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (bean.DEV_CHARGPILE != null)
{
sql1.Append(" DEV_CHARGPILE,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.DEV_CHARGPILE);
}
if (bean.BOX_ID != null)
{
sql1.Append(" BOX_ID,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.BOX_ID);
}
if (!string.IsNullOrEmpty(bean.PILETYPEID))
{
sql1.Append(" PILETYPEID,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.PILETYPEID);
}
if (!string.IsNullOrEmpty(bean.ZHUANGTAI))
{
sql1.Append(" ZHUANGTAI,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.ZHUANGTAI);
}
if (bean.CREATEDT != null)
{
sql1.Append(" CREATEDT,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.CREATEDT);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into DEV_CHARGPILE(" + sql1 + ") values(" + sql2 + ")";
Oop.Execute(sql, list.ToArray());
}
/// <summary>
/// 保存充电桩
/// </summary>
/// <param name="bean"></param>
public void SavePile(ChargPile bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update dev_chargpile set");
var i = 0;
var dList = new List <object>();
if (!string.IsNullOrEmpty(bean.CHANGJIAO_BH))
{
sql.Append(" CHANGJIAO_BH={" + i++ + "},");
dList.Add(bean.CHANGJIAO_BH);
}
if (!string.IsNullOrEmpty(bean.YUNXING_BH))
{
sql.Append(" YUNXING_BH={" + i++ + "},");
dList.Add(bean.YUNXING_BH);
}
if (!string.IsNullOrEmpty(bean.PILETYPEID))
{
sql.Append(" PILETYPEID={" + i++ + "},");
dList.Add(bean.PILETYPEID);
}
if (!string.IsNullOrEmpty(bean.ZHUANGTAI))
{
sql.Append(" ZHUANGTAI={" + i++ + "},");
dList.Add(bean.ZHUANGTAI);
}
if (sql.Length > 0)
{
sql = sql.Remove(sql.Length - 1, 1);
}
sql.Append(" where DEV_CHARGPILE={" + i++ + "}");
dList.Add(bean.DEV_CHARGPILE);
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <summary>
/// 保存充电桩
/// </summary>
/// <param name="bean"></param>
public void SavePile(ChargPile bean)
{
_chargStationDal.SavePile(bean);
}
/// <summary>
///
/// </summary>
/// <param name="chargpile"></param>
public void EditPile(ChargPile chargpile)
{
_chargStationDal.EditPile(chargpile);
}
/// <summary>
/// 添加充电桩
/// </summary>
/// <param name="bean"></param>
public void AddChargPile(ChargPile bean)
{
_chargStationDal.AddChargPile(bean);
}
/// <summary>
/// 添加充电桩
/// </summary>
/// <param name="chargpile"></param>
public void AddPile(ChargPile bean)
{
Log.Debug("Add方法参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (bean.DEV_CHARGPILE != null)
{
sql1.Append(" DEV_CHARGPILE,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.DEV_CHARGPILE);
}
if (bean.BOX_ID != null)
{
sql1.Append(" BOX_ID,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.BOX_ID);
}
if (bean.ZONGXIAN_DZ != null)
{
sql1.Append(" ZONGXIAN_DZ,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.ZONGXIAN_DZ);
}
if (!string.IsNullOrEmpty(bean.DTU_ID))
{
sql1.Append(" DTU_ID,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.DTU_ID);
}
if (!string.IsNullOrEmpty(bean.PILETYPEID))
{
sql1.Append(" PILETYPEID,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.PILETYPEID);
}
if (!string.IsNullOrEmpty(bean.CHANGJIAO_BH))
{
sql1.Append(" CHANGJIAO_BH,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.CHANGJIAO_BH);
}
if (!string.IsNullOrEmpty(bean.YUNXING_BH))
{
sql1.Append(" YUNXING_BH,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.YUNXING_BH);
}
if (bean.TOUYOU_SJ != new DateTime())
{
sql1.Append(" TOUYOU_SJ,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.TOUYOU_SJ);
}
else
{
sql1.Append(" TOUYOU_SJ,");
sql2.Append(" null,");
}
if (!string.IsNullOrEmpty(bean.ZHUANGTAI))
{
sql1.Append(" ZHUANGTAI,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.ZHUANGTAI);
}
if (!string.IsNullOrEmpty(bean.ZHICHAN_BH))
{
sql1.Append(" ZHICHAN_BH,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.ZHICHAN_BH);
}
if (!string.IsNullOrEmpty(bean.YUNWEI_DW))
{
sql1.Append(" YUNWEI_DW,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.YUNWEI_DW);
}
if (!string.IsNullOrEmpty(bean.REMARK))
{
sql1.Append(" REMARK,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.REMARK);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into dev_chargpile(" + sql1 + ",CREATEDT) values(" + sql2 + ",sysdate)";
Oop.Execute(sql, list.ToArray());
}
/// <summary>
/// 修改充电桩
/// </summary>
/// <param name="bean"></param>
public void EditPile(ChargPile bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update dev_chargpile set");
var i = 0;
var dList = new List <object>();
if (!string.IsNullOrEmpty(bean.PILETYPEID))
{
sql.Append(" PILETYPEID={" + i++ + "},");
dList.Add(bean.PILETYPEID);
}
if (!string.IsNullOrEmpty(bean.POWERPILENAME))
{
sql.Append(" POWERPILENAME={" + i++ + "},");
dList.Add(bean.POWERPILENAME);
}
if (bean.ZONGXIAN_DZ != null)
{
sql.Append(" ZONGXIAN_DZ={" + i++ + "},");
dList.Add(bean.ZONGXIAN_DZ);
}
if (!string.IsNullOrEmpty(bean.CHANGJIAO_BH))
{
sql.Append(" CHANGJIAO_BH={" + i++ + "},");
dList.Add(bean.CHANGJIAO_BH);
}
if (!string.IsNullOrEmpty(bean.YUNXING_BH))
{
sql.Append(" YUNXING_BH={" + i++ + "},");
dList.Add(bean.YUNXING_BH);
}
if (!string.IsNullOrEmpty(bean.ZHUANGTAI))
{
sql.Append(" ZHUANGTAI={" + i++ + "},");
dList.Add(bean.ZHUANGTAI);
}
if (!string.IsNullOrEmpty(bean.REMARK))
{
sql.Append(" REMARK={" + i++ + "},");
dList.Add(bean.REMARK);
}
if (bean.TOUYOU_SJ != new DateTime())
{
sql.Append(" TOUYOU_SJ={" + i++ + "},");
dList.Add(bean.TOUYOU_SJ);
}
else
{
sql.Append(" TOUYOU_SJ=null,");
}
if (bean.UPDATEDT != null)
{
sql.Append(" UPDATEDT={" + i++ + "},");
dList.Add(bean.UPDATEDT);
}
if (sql.Length > 0)
{
sql = sql.Remove(sql.Length - 1, 1);
}
sql.Append(" where DEV_CHARGPILE={" + i++ + "}");
dList.Add(bean.DEV_CHARGPILE);
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <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\":\"保存失败！\"}");
}
}
