public override DataTable Query(ChargPileTypes bean)
{
Log.Debug("Query方法参数为：" + bean.ToString());
var sql = new StringBuilder();
sql.Append("select * from dev_powerpiletypes where 1=1 ");
var list = new List <object>();
var i = -1;
if (!string.IsNullOrEmpty(bean.PARSERKEY))
{
sql.Append(" and PARSERKEY={" + ++i + "}");
list.Add(bean.PARSERKEY);
}
if (!string.IsNullOrEmpty(bean.CHANGJIA))
{
sql.Append(" and changjia={" + ++i + "}");
list.Add(bean.CHANGJIA);
}
if (!string.IsNullOrEmpty(bean.ZHUANGLEI_X))
{
sql.Append(" and zhuanglei_x={" + ++i + "}");
list.Add(bean.ZHUANGLEI_X);
}
if (!string.IsNullOrEmpty(bean.ZHUANGXING_H))
{
sql.Append(" and zhuangxing_h={" + ++i + "}");
list.Add(bean.ZHUANGXING_H);
}
Log.Debug("SQL:" + sql.ToString() + ",params:" + list.ToString());
return(Oop.GetDataTable(sql.ToString(), list.ToArray()));
}
/// <summary>
/// 修改告警信息
/// </summary>
/// <param name="bean"></param>
public void EditBy(WarnRec bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder("update oth_warnrec set");
var i = 0;
var dList = new List <object>();
if (bean.ProcessFlag != null)
{
sql.Append(" processflag={" + i++ + "},");
dList.Add(bean.ProcessFlag);
}
if (bean.ProcessDt != null)
{
sql.Append(" ProcessDt={" + i++ + "},");
dList.Add(bean.ProcessDt);
}
if (bean.ProcesseEp != null)
{
sql.Append(" processeep={" + i++ + "},");
dList.Add(bean.ProcesseEp);
}
sql.Append(" updatedt=sysdate where DATAITEMID={" + i++ + "} and TARGETDEV={" + i + "}");
dList.Add(bean.DataItemId);
dList.Add(bean.TargetDev);
Log.Debug("SQL:" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <summary>
/// 查询停电告警(针对告警服务页面中停电告警)
/// </summary>
/// <returns></returns>
public DataTable FindByPowerFailure3(string zhanbh)
{
Log.Debug("FindByPowerFailure方法没有参数");
var sql = new StringBuilder();
sql.Append("select * ");
sql.Append("from (select owr.id,owr.targetdev,owr.dataitemid, ");
sql.Append("(select dd.dtuname from dev_dtu dd where owr.targetdev=dd.dtuid) dtuname, ");
sql.Append("to_char(owr.occurdt,'yyyy-mm-dd hh24:mi:ss') occurdt,");
sql.Append("(select dcs.zhan_jc from dev_chargstation dcs ");
sql.Append("inner join dev_dtu dd on dcs.zhan_bh=dd.zhuan_bh ");
sql.Append("where dd.dtuid=owr.targetdev) zhanjc, ");
sql.Append("(select dcp.yunxing_bh from dev_chargpile dcp where dcp.dev_chargpile=owr.targetdev) yunxing_bh,");
sql.Append("owr.processflag ");
sql.Append("from oth_warnrec owr ");
sql.Append("where owr.dataitemid='PowerStopState' and owr.processflag='0' ");
if (!string.IsNullOrEmpty(zhanbh))
{
sql.Append("and owr.targetdev like '" + zhanbh + "%' ");
}
sql.Append("order by owr.occurdt desc)");
sql.Append("where rownum<=3");
return(Oop.GetDataTable(sql.ToString()));
}
/// <summary>
/// 获取dtu数据
/// </summary>
/// <param name="zhanbh"></param>
/// <param name="page"></param>
/// <param name="rows"></param>
/// <returns></returns>
public DataTable GetDTU(string zhanbh, int page, int rows)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select B.* from (select A.*,rownum rn from (select a.*,(select b.ZHAN_JC from dev_chargstation b ");
strSql.Append(" where a.ZHUAN_BH=b.ZHAN_BH) as ZHAN_MC, (select count(c.dev_chargpile) from dev_chargpile c where c.dtu_id = a.id) as PILECOUNTS ");
strSql.Append(" from dev_dtu a where 1=1 ");
var i = -1;
List <object> list = new List <object>();
if (!string.IsNullOrEmpty(zhanbh))
{
strSql.Append(" and a.ZHUAN_BH={" + ++i + "} ");
list.Add(zhanbh);
}
strSql.Append(" order by a.CREATEDT desc ");
strSql.Append(" ) A where rownum<='" + page + "'*'" + rows + "') B where rn>('" + page + "'-1)*'" + rows + "' ");
DataTable dt = new DataTable();
try
{
dt = Oop.GetDataTable(strSql.ToString(), list.ToArray());
}
catch (Exception e)
{
Log.Error("查询DTU失败！", e);
}
return(dt);
}
/// <summary>
/// 修改检修记录
/// </summary>
/// <param name="bean"></param>
public override void Modify(ChargPileJianXiuJL bean)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update dev_maintainrecord set ");
strSql.Append(" ZHUAN_ID={0},UPDATEDT={1},JIANXIU_LX={2},JIANXIU_JB={3},JIANXIU_SJ={4},JIANXIU_JL={5},JIANXIU_R={6} ");
strSql.Append(" where id={7} ");
object[] parameters = new object[] {
bean.Zhuan_Id,
bean.UpdateDt,
bean.JianXiu_Lx,
bean.JianXiu_Jb,
bean.JianXiu_Sj,
bean.JianXiu_Jl,
bean.JianXiu_R,
bean.Id
};
try
{
Oop.Execute(strSql.ToString(), parameters);
}
catch (Exception e)
{
Log.Error("修改充电桩检修记录失败！", e);
}
}
/// <summary>
/// 查询充电桩采集项数据
/// </summary>
/// <returns></returns>
public DataTable QueryChargPileCollection()
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select d.*,(select count(g.id) from gat_pointcfg g,gat_item m ");
strSql.Append(" where d.parserkey=g.piletypeid and g.gatitemid=m.itemno)as counts from dev_powerpiletypes d ");
return Oop.GetDataTable(strSql.ToString());
}
/// <summary>
/// 保存充电站
/// </summary>
/// <param name="bean"></param>
public void SaveZhan(ChargStation bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update dev_chargstation set");
var i = 0;
var dList = new List <object>();
if (bean.ZhuangChangJ != null)
{
sql.Append(" zhuangchang_j={" + i++ + "},");
dList.Add(bean.ZhuangChangJ);
}
if (bean.ZhuangLeiX != null)
{
sql.Append(" zhuanglei_x={" + i++ + "},");
dList.Add(bean.ZhuangLeiX);
}
if (sql.Length > 0)
{
sql = sql.Remove(sql.Length - 1, 1);
}
sql.Append(" where ZHAN_BH={" + i++ + "}");
dList.Add(bean.ZhanBh);
try
{
Oop.Execute(sql.ToString(), dList.ToArray());
}
catch (Exception e)
{
Log.Error("保存充电站失败！", e);
}
}
/// <summary>
/// 删除人员
/// </summary>
/// <param name="id"></param>
public void DelDepartment(string id)
{
Log.Debug("del方法参数：");
var sql = "delete from t_department where id='" + id + "' or parentdept='" + id + "'";
Oop.Execute(sql);
}
public void DelEmployee(string id)
{
Log.Debug("del方法接收的参数：");
var sql = "delete from t_employer where id='" + id + "'";
Oop.Execute(sql);
}
/// <summary>
/// 更新部门
/// </summary>
/// <param name="bean"></param>
public void UpdateDepartment(Department bean)
{
Log.Debug("更新部门");
var sql = "update t_department set name='" + bean.Name + "' where id='" + bean.Id + "'";
Oop.Execute(sql);
}
/// <summary>
/// 查询部门表
/// </summary>
/// <param name="bean">部门实体类</param>
/// <returns></returns>
public override DataTable Query(Department bean)
{
Log.Debug("Query方法参数：" + bean.ToString());
var sql = new StringBuilder();
sql.Append("select * from t_department where 1=1 ");
var list = new List <object>();
var i = -1;
if (!string.IsNullOrEmpty(bean.Id))
{
sql.Append(" and id={" + ++i + "}");
list.Add(bean.Id);
}
if (!string.IsNullOrEmpty(bean.Name))
{
sql.Append(" and name={" + ++i + "}");
list.Add(bean.Name);
}
if (!string.IsNullOrEmpty(bean.ParentDept))
{
sql.Append(" and ParentDept={" + ++i + "}");
list.Add(bean.ParentDept);
}
Log.Debug("SQL :" + sql + ",params:" + list.ToString());
return(Oop.GetDataTable(sql.ToString(), list.ToArray()));
}
private DataTable GetRecordPage(string sql, List <object> list, int page, int rows)
{
string strSql = @"
select B.* from
(
select A.*,rownum rn from
(
@sql
) A where rownum<='@page'*'@rows'
) B where rn>('@page'-1)*'@rows'
";
strSql = strSql.Replace("@page", page.ToString());
strSql = strSql.Replace("@rows", rows.ToString());
strSql = strSql.Replace("@sql", sql);
DataTable dt = new DataTable();
try
{
dt = Oop.GetDataTable(strSql.ToString(), list.ToArray());
}
catch (Exception e)
{
Log.Error("查询失败！", e);
}
return(dt);
}
public override void Del(ResMenu bean)
{
Log.Debug("del方法参数：");
var sql = "delete from sm_resmenu where ResId='" + bean.ResId + "'";
Oop.Execute(sql);
}
public override void Add(UseRoles bean)
{
Log.Debug("Add方法参数：" + bean.ToString());
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List <object>();
if (!string.IsNullOrEmpty(bean.RoleId))
{
sql1.Append(" RoleId,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.RoleId);
}
if (!string.IsNullOrEmpty(bean.LoginName))
{
sql1.Append(" LoginName,");
sql2.Append(" {" + i++ + "},");
list.Add(bean.LoginName);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into sm_useroles(" + sql1 + ") values(" + sql2 + ")";
Log.Debug("SQL :" + sql + ",params:" + list.ToString());
Oop.Execute(sql, list.ToArray());
}
/// <summary>
/// 根据桩id删除充电桩
/// </summary>
/// <param name="chargpile"></param>
public void EditChargPile(ChargPile chargpile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" update dev_chargpile set ");
strSql.Append(" BOX_ID={0},DTU_ID={1},PILETYPEID={2},ZONGXIAN_DZ={3},CHANGJIAO_BH={4},YUNXING_BH={5},TOUYOU_SJ={6},ZHUANGTAI={7},ZHICHAN_BH={8},YUNWEI_DW={9},DELETEFLAG={10},CREATEDT={11},UPDATEDT={12} ");
strSql.Append(" where dev_chargpile={13} ");
object[] parameters = new object[] {
chargpile.BOX_ID,
chargpile.DTU_ID,
chargpile.PILETYPEID,
chargpile.ZONGXIAN_DZ,
chargpile.CHANGJIAO_BH,
chargpile.YUNXING_BH,
chargpile.TOUYOU_SJ,
chargpile.ZHUANGTAI,
chargpile.ZHICHAN_BH,
chargpile.YUNWEI_DW,
chargpile.DELETEFLAG,
chargpile.CREATEDT,
chargpile.UPDATEDT,
chargpile.DEV_CHARGPILE
};
try
{
Oop.Execute(strSql.ToString(), parameters);
}
catch (Exception e)
{
Log.Error("修改充电桩失败！", e);
}
}
public override void Modify(Employer employer)
{
Log.Debug("更新人员");
var sql = "update t_employer set password='******' where WorkNum='" + employer.WorkNum + "'";
Oop.Execute(sql);
}
public DataTable QueryBySjlx(string sjlx, string xh, string sjx, int page, int rows, ref int count)
{
Log.Debug("QueryBySjlx方法参数为：sjlx:" + sjlx + ",page：" + page + ",rows:" + rows + ", ref count:" + count);
var sqlTable = new StringBuilder(@"select gp.*,
(select changjia from dev_powerpiletypes dpt where dpt.parserkey=gp.piletypeid) Zhuangcj,
(select zhuanglei_x from dev_powerpiletypes dpt where dpt.parserkey=gp.piletypeid) ZhuangLeiX,
(select itemname from gat_item t where t.itemno=gp.gatitemid) gatitemname from gat_pointcfg gp where 1=1 ");
var sqlCount = new StringBuilder("select count(*) from gat_pointcfg gp where 1=1 ");
var sqlWhere = new StringBuilder();
var list = new List <object>();
var i = -1;
if (!string.IsNullOrEmpty(sjlx))
{
sqlWhere.Append(" and exists (select 1 from gat_item gi where gi.itemno=gp.gatitemid and gi.datatype={" + ++i + "}) ");
list.Add(sjlx);
}
if (!string.IsNullOrEmpty(xh))
{
sqlWhere.Append(" and gp.piletypeid like {" + ++i + "} ");
list.Add("%" + xh + "%");
}
if (!string.IsNullOrEmpty(sjx))
{
sqlWhere.Append(" and exists (select 1 from gat_item gi where gi.itemno=gp.gatitemid and gi.itemname like {" + ++i + "}) ");
list.Add("%" + sjx + "%");
}
//DataTable dt = Oop.GetDataTableByPage(sqlTable.Append(sqlWhere).Append(" order by createdt desc").ToString(), (page - 1) * rows, rows, list.ToArray());
DataTable dt = Oop.GetDataTableByPage(sqlTable.Append(sqlWhere).Append(" order by Zhuangcj,ZhuangLeiX,gatitemname").ToString(), (page - 1) * rows, rows, list.ToArray());
count = int.Parse(Oop.GetScalar(sqlCount.Append(sqlWhere).ToString(), list.ToArray()).ToString());
return(dt);
}
public void ModifyEmail(Employer bean)
{
Log.Debug("ModifyById方法参数：" + bean.ToString());
string sql = "update t_employer set email={0} where id={1}";
Oop.Execute(sql, bean.Email, bean.Id);
}
/// <summary>
/// 添加配置项
/// </summary>
/// <param name="typeid"></param>
/// <param name="pzx"></param>
public void AddPZX(string typeid,string pzx)
{
var sql1 = new StringBuilder();
var sql2 = new StringBuilder();
var i = 0;
var list = new List<object>();
string id = Guid.NewGuid().ToString();
sql1.Append(" ID, ");
sql2.Append(" '"+id+"', ");
if (!string.IsNullOrEmpty(typeid))
{
sql1.Append(" PILETYPEID,");
sql2.Append(" {" + i++ + "},");
list.Add(typeid);
}
if (!string.IsNullOrEmpty(pzx))
{
sql1.Append(" GATITEMID,");
sql2.Append(" {" + i++ + "},");
list.Add(pzx);
}
if (sql1.Length > 0)
{
sql1 = sql1.Remove(sql1.Length - 1, 1);
sql2 = sql2.Remove(sql2.Length - 1, 1);
}
var sql = "insert into gat_pointcfg(" + sql1 + ",createdt) values(" + sql2 + ",sysdate)";
Oop.Execute(sql, list.ToArray());
}
public DataTable QueryEmp(Employer bean)
{
Log.Debug("QueryNode方法参数：" + bean.ToString());
var sql2 = "select t.*,(select name from t_department tt where t.deptid=tt.id) deptname from t_employer t where deptid='" + bean.DeptId + "'";
return(Oop.GetDataTable(sql2));
}
/// <summary>
/// 查询运行日志总数
/// </summary>
/// <param name="begintime"></param>
/// <param name="endtime"></param>
/// <returns></returns>
public DataTable GetWorkLogTotal(DateTime begintime, DateTime endtime)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select a.*,b.worknum from oth_oprlog a, t_employer b ");
strSql.Append(" where a.operator=b.name ");
var i = -1;
List <object> list = new List <object>();
if (begintime != new DateTime() && endtime != new DateTime())
{
strSql.Append(" and a.logdate between {" + ++i + "} and {" + ++i + "} ");
list.AddRange(new object[] { begintime, endtime.AddDays(1) });
}
strSql.Append(" order by a.logdate desc ");
DataTable dt = new DataTable();
try
{
dt = Oop.GetDataTable(strSql.ToString(), list.ToArray());
}
catch (Exception e)
{
Log.Error("查询运行日志失败！", e);
}
return(dt);
}
public override void Modify(WarnDetail bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update gat_warndetail set");
var i = 0;
var dList = new List <object>();
if (bean.IsSuccess != null)
{
sql.Append(" IsSuccess={" + i++ + "},");
dList.Add(bean.IsSuccess);
}
if (bean.ProcessFlag != null)
{
sql.Append(" ProcessFlag={" + i++ + "},");
dList.Add(bean.ProcessFlag);
}
if (bean.UpdateDT != null)
{
sql.Append(" UpdateDT={" + i++ + "}");
dList.Add(bean.UpdateDT);
}
sql.Append(" where Id={" + i++ + "}");
dList.Add(bean.Id);
Log.Debug("SQL :" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <summary>
/// 查询dtu总数
/// </summary>
/// <param name="zhanbh"></param>
/// <returns></returns>
public DataTable GetDTUTotal(string zhanbh)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" select a.*,(select b.ZHUAN_MC from dev_chargstation b where a.ZHUAN_BH=b.ZHAN_BH) as ZHAN_MC ");
strSql.Append(" from dev_dtu a where 1=1 ");
var i = -1;
List <object> list = new List <object>();
if (!string.IsNullOrEmpty(zhanbh))
{
strSql.Append(" and a.ZHUAN_BH={" + ++i + "} ");
list.Add(zhanbh);
}
strSql.Append(" order by a.CREATEDT desc ");
DataTable dt = new DataTable();
try
{
dt = Oop.GetDataTable(strSql.ToString(), list.ToArray());
}
catch (Exception e)
{
Log.Error("查询DTU失败！", e);
}
return(dt);
}
public override DataTable Query(MenuPower bean)
{
Log.Debug("Query方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("select * from t_menu_power where 1=1 ");
var list = new List <object>();
var i = -1;
if (!string.IsNullOrEmpty(bean.Id))
{
sql.Append(" and Id={" + ++i + "}");
list.Add(bean.Id);
}
if (!string.IsNullOrEmpty(bean.MenuId))
{
sql.Append(" and MenuId={" + ++i + "}");
list.Add(bean.MenuId);
}
if (!string.IsNullOrEmpty(bean.PowerId))
{
sql.Append(" and PowerId={" + ++i + "}");
list.Add(bean.PowerId);
}
Log.Debug("SQL :" + sql + ",params:" + list.ToString());
return(Oop.GetDataTable(sql.ToString(), list.ToArray()));
}
public override void Modify(WarnRec bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder("update oth_warnrec set");
var i = 0;
var dList = new List <object>();
if (bean.ProcessFlag != null)
{
sql.Append(" processflag={" + i++ + "},");
dList.Add(bean.ProcessFlag);
}
if (bean.ProcessDt != null)
{
sql.Append(" ProcessDt={" + i++ + "},");
dList.Add(bean.ProcessDt);
}
if (bean.ProcesseEp != null)
{
sql.Append(" processeep={" + i++ + "},");
dList.Add(bean.ProcesseEp);
}
sql.Append(" updatedt=sysdate where id={" + i++ + "}");
dList.Add(bean.Id);
Log.Debug("SQL:" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
public override void Modify(MenuPower bean)
{
Log.Debug("Modify方法参数：" + bean);
var sql = new StringBuilder();
sql.Append("update t_menu_power set");
var i = 0;
var dList = new List <object>();
if (string.IsNullOrEmpty(bean.MenuId))
{
sql.Append(" MenuId={" + i++ + "}");
dList.Add(bean.MenuId);
}
if (string.IsNullOrEmpty(bean.PowerId))
{
sql.Append(" PowerId={" + i++ + "}");
dList.Add(bean.PowerId);
}
sql.Append(" where Id={" + i + "}");
dList.Add(bean.Id);
Log.Debug("SQL :" + sql + ",params:" + dList.ToString());
Oop.Execute(sql.ToString(), dList.ToArray());
}
/// <summary>
/// 查询异常告警
/// </summary>
/// <returns></returns>
public DataTable FindByTelesignallingWarn(string zhanbh)
{
Log.Debug("FindByTelesignallingWarn方法没有参数");
var sql = new StringBuilder();
sql.Append("select * ");
sql.Append("from (select owr.id,owr.dataitemid,owr.processeep, ");
sql.Append("(select sc.codename from sys_code sc where sc.parentid='5077B15C-4F5E-49B2-9E32-E7C1E2F1E74D' and owr.logtype=sc.code) codename,");
sql.Append("to_char(owr.occurdt,'yyyy-mm-dd hh24:mi:ss') occurdt,");
sql.Append("(select dcs.zhan_jc from dev_chargstation dcs ");
sql.Append("inner join dev_branch db on db.zhuan_bh=dcs.zhan_bh ");
sql.Append("inner join dev_chargpile dcp on dcp.box_id=db.branchno ");
sql.Append("where dcp.dev_chargpile=owr.targetdev) zhanjc,");
sql.Append("(select dcp.yunxing_bh from dev_chargpile dcp where dcp.dev_chargpile=owr.targetdev) yunxing_bh,");
sql.Append("(select gi.Itemname from gat_item gi where gi.itemno=owr.dataitemid) itemname, ");
sql.Append("owr.logdesc,owr.processflag,owr.targetdev ");
sql.Append("from oth_warnrec owr ");
sql.Append("where owr.dataitemid!='CardExceptionState' and owr.dataitemid!='DTUStatus' and owr.dataitemid!='PowerStopState' ");
if (!string.IsNullOrEmpty(zhanbh))
{
sql.Append("and owr.targetdev like '" + zhanbh + "%' ");
}
sql.Append("order by owr.occurdt desc)");
sql.Append("where rownum<=10");
return(Oop.GetDataTable(sql.ToString()));
}
/// <summary>
/// 添加充电桩
/// </summary>
/// <param name="chargpile"></param>
public void AddChargPile(ChargPile chargpile)
{
StringBuilder strSql = new StringBuilder();
strSql.Append(" insert into dev_chargpile(DEV_CHARGPILE,BOX_ID,DTU_ID,PILETYPEID,ZONGXIAN_DZ,CHANGJIAO_BH,YUNXING_BH,TOUYOU_SJ,ZHUANGTAI,ZHICHAN_BH,YUNWEI_DW,DELETEFLAG,CREATEDT,UPDATEDT,POWERPILENAME) values ");
strSql.Append(" ({0},{1},{2},{3},{4},{5},{6},{7},{8},{9},{10},{11},{12},{13},{14})");
object[] parameters = new object[] {
chargpile.DEV_CHARGPILE,
chargpile.BOX_ID,
chargpile.DTU_ID,
chargpile.PILETYPEID,
chargpile.ZONGXIAN_DZ,
chargpile.CHANGJIAO_BH,
chargpile.YUNXING_BH,
chargpile.TOUYOU_SJ,
chargpile.ZHUANGTAI,
chargpile.ZHICHAN_BH,
chargpile.YUNWEI_DW,
chargpile.DELETEFLAG,
chargpile.CREATEDT,
chargpile.UPDATEDT,
chargpile.POWERPILENAME
};
try
{
Oop.Execute(strSql.ToString(), parameters);
}
catch (Exception e)
{
Log.Error("添加充电桩失败！", e);
}
}
public DataTable QuerySjxNotUse(string dataType, string pileTypeId)
{
const string sql = @"select * from gat_item t where t.datatype={0} and
not exists (select 1 from gat_pointcfg gp where gp.piletypeid={1} and gp.gatitemid=t.itemno)";
return(Oop.GetDataTable(sql, dataType, pileTypeId));
}
/// <summary>
/// 查询场站名称
/// </summary>
/// <returns></returns>
public DataTable FindByZhanMc()
{
Log.Debug("FindByZhanMc方法没有参数");
var sql = new StringBuilder();
sql.Append("select dcs.zhan_bh,dcs.zhan_jc from dev_chargstation dcs ");
return(Oop.GetDataTable(sql.ToString()));
}
