private void SaveArea(string areaName, string areaCd)
{
int count;
string info = "";
bool flag = false;
//判断射频卡ID 是否重复
sql = "select count(*) from T_BASE_AREA where T_AREACD='" + areaCd + "'";
object obj = DBdb2.RunSingle(sql, out errMsg);
sql = "select count(*) from T_BASE_AREA where T_AREANAME='" + areaName + "'";
object obj1 = DBdb2.RunSingle(sql, out errMsg);
if (obj.ToString() == "0" && obj1.ToString() == "0")
{
sql = "select T_AREAID from T_BASE_AREA order by ID_KEY desc FETCH FIRST 1 ROWS ONLY";
obj = DBdb2.RunSingle(sql, out errMsg);
if (obj != null && obj.ToString() != "")
{
count = int.Parse(obj.ToString()) + 1;
}
else
{
count = 1;
}
sql = @"insert into T_BASE_AREA (T_AREAID,T_AREANAME,T_AREACD) values('"
+ count + "','"
+ areaName + "','"
+ areaCd + "')";
flag = DBdb2.RunNonQuery(sql, out errMsg);
if (errMsg == "")
{
info = "新增区域成功!";
}
else
{
info = "新增区域失败!";
}
}
else
{
info = "射频卡编码和区域名称已存在";
}
obj = new
{
msg = info
};
string result = JsonConvert.SerializeObject(obj);
Response.Write(result);
Response.End();
}
public bool updateBoiler(string unit)
{
this.init();
string errMsg = "";
bool flag = false;
//"T0_t_el主蒸汽温度(℃),"P0_t_el主蒸汽压力(MPa)",,'Trh_el再热温度(℃)','PLrh_el再热压损(%)','Pdp_el凝汽器压力(kPa)','Dgrjw_el过热减温水流量(t/h)','Dzrjw_el再热减温水流量(t/h)','Dpw_el锅炉连续排污流量(t/h)','DeltaT_gl_el凝汽器过冷度(℃)','Dtur_el小机用汽量(t/h)','O2_el排烟氧量(%)','Tpy_el排烟温度(℃)','Alpha_bs_el补水率(%)','Tfw_el给水温度(℃)','Eta_H_el高压缸效率(%)','Eta_M_el中压缸效率(%)','Theta_1_el#1高加上端差(℃)','Theta_2_el#2高加上端差(℃)','Theta_3_el#3高加上端差(℃)','Theta_5_el#5高加上端差(℃)','Theta_6_el#6高加上端差(℃)','Theta_7_el#7高加上端差(℃)','Theta_8_el#8高加上端差(℃)'
string[] str = new string[23] {
"T0_t_el_B", "P0_t_el_B", "Trh_el_B", "PLrh_el_B", "Pdp_el_B", "Dgrjw_el_B", "Dzrjw_el_B", "Dpw_el_B", "Del_BtaT_gl_el_B", "Dtur_el_B", "O2_el_B", "Tpy_el_B", "Alpha_bs_el_B", "Tfw_el_B", "Eta_H_el_B", "Eta_M_el_B", "Theta_1_el_B", "Theta_2_el_B", "Theta_3_el_B", "Theta_5_el_B", "Theta_6_el_B", "Theta_7_el_B", "Theta_8_el_B"
};
for (int i = 0; i < unit.Split(',')[1].Split('|').Length; i++)
{
string sql = "update T_BASE_CALCPARA set T_FORMULA ='" + unit.Split(',')[1].Split('|')[i] + "' where T_UNITID = '" + unit.Split(',')[0] + "' and T_PARAID ='" + str[i] + "'";
if (rlDBType == "SQL")
{
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
}
return(flag);
}
/// <summary>
/// 编辑点检项
/// </summary>
/// <param name="nodeKey"></param>
/// <param name="itemID"></param>
/// <param name="itemBw"></param>
/// <param name="itemDesc"></param>
/// <param name="itemContent"></param>
/// <param name="itemObserve"></param>
/// <param name="itemUnit"></param>
/// <param name="itemType"></param>
/// <param name="itemStatus"></param>
/// <param name="itemStatusQJ"></param>
/// <param name="itemUpper"></param>
/// <param name="itemLower"></param>
/// <param name="itemSpectrum"></param>
/// <param name="itemStartTime"></param>
/// <param name="itemPerValue"></param>
/// <param name="itemPerType"></param>
/// <returns></returns>
public bool EditItem(string idkey, string itemBw, string itemDesc, string itemContent, string itemObserve, string itemUnit, string itemType, string itemStatus, string itemStatusQJ, string itemUpper, string itemLower, string itemSpectrum, string itemStartTime, string itemPerValue, string itemPerType, out string errMsg)
{
object obj = null;
bool flag = false;
int count = 0;
//sql = "insert into T_BASE_ITEM ";
//sql += "(T_ITEMID,T_ITEMPOSITION,T_ITEMDESC,T_CONTENT,T_TYPE,I_STATUS,T_OBSERVE,T_UNIT,F_LOWER,F_UPPER,I_SPECTRUM,T_DEVICEID,T_STARTTIME,T_PERIODTYPE,T_PERIODVALUE,T_STATUS)";
//sql += " values ";
//sql += "('" + count + "','" + itemBw + "','" + itemDesc + "','" + itemContent + "','" + itemType + "'," + itemStatus + ",'" + itemObserve + "','" + itemUnit + "'," + double.Parse(itemLower) + "," + double.Parse(itemUpper) + "," + int.Parse(itemSpectrum) + ",'" + nodeKey + "','" + DateTime.Parse(itemStartTime).ToString("yyyy-MM-dd 0:00:00") + "'," + int.Parse(itemPerType) + "," + int.Parse(itemPerValue) + "," + int.Parse(itemStatusQJ) + ")";
sql += "update T_BASE_ITEM set ";
sql += "T_ITEMPOSITION='" + itemBw + "',T_ITEMDESC='" + itemDesc + "',T_CONTENT='" + itemContent + "',T_TYPE='" + itemType + "',I_STATUS=" + itemStatus + ",T_OBSERVE='" + itemObserve + "',";
sql += "T_UNIT='" + itemUnit + "',F_LOWER=" + double.Parse(itemLower) + ",F_UPPER= " + double.Parse(itemUpper) + ",I_SPECTRUM=" + int.Parse(itemSpectrum) + ",T_STARTTIME='" + DateTime.Parse(itemStartTime).ToString("yyyy-MM-dd 0:00:00") + "',";
sql += "T_PERIODTYPE=" + int.Parse(itemPerType) + ",T_PERIODVALUE=" + int.Parse(itemPerValue) + ",T_STATUS=" + int.Parse(itemStatusQJ) + " where id_key=" + idkey;
flag = DBdb2.RunNonQuery(sql, out errMsg);
if (flag != true)
{
errMsg = "编辑点检项失败!";
}
return(flag);
}
/// <summary>
/// 新建线路
/// </summary>
/// <param name="lID">线路ID</param>
/// <param name="lName">线路名称</param>
/// <param name="lType">线路类型</param>
/// <param name="lGw">线路岗位</param>
/// <param name="lPID">线路父ID</param>
public bool AddLineInfo(string lID, string lName, string lType, string lGw, string lPID, out string errMsg)
{
int count = 1;
object obj = null;
bool flag = false;
//判断线路ID是否已被加入
sql = "select * from T_BASE_ROUTE where T_ROUTEID='" + lID + "'";
DataRow drBaseRoute = DBdb2.RunDataRow(sql, out errMsg);
if (drBaseRoute != null)
{
errMsg = "此线路ID已被添加";
}
else
{
sql = "select count(*) from T_BASE_DEVICE";
obj = DBdb2.GetSingle(sql);
if (obj != null && obj.ToString() != "")
{
count = int.Parse(obj.ToString()) + 1;
}
sql = "insert into T_BASE_ROUTE (T_ROUTEID,T_ROUTENAME,T_ORGID,I_TYPE) values ('" + lID + "','" + lName + "','" + lGw + "'," + lType + ");";
sql += "insert into T_BASE_DEVICE (T_NODEID,T_NODEKEY,T_PARAENTID) values ('" + lID + "','" + count.ToString() + "','" + lPID + "')";
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
private void EditArea(string idkey, string areaName, string areaCd)
{
int count = 0;
string info = "";
sql = @"update T_BASE_AREA set T_AREACD='" + areaCd + "',T_AREANAME = '" + areaName + "' where ID_KEY = " + idkey;
bool falg = DBdb2.RunNonQuery(sql, out errMsg);
if (errMsg == "")
{
info = "区域修改成功!";
}
else
{
info = "区域修改失败!";
}
obj = new
{
count = count,
info = info
};
string result = JsonConvert.SerializeObject(obj);
Response.Write(result);
Response.End();
}
/// <summary>
/// 添加点检项
/// </summary>
/// <param name="nodeKey"></param>
/// <param name="itemID"></param>
/// <param name="itemBw"></param>
/// <param name="itemDesc"></param>
/// <param name="itemContent"></param>
/// <param name="itemObserve"></param>
/// <param name="itemUnit"></param>
/// <param name="itemType"></param>
/// <param name="itemStatus"></param>
/// <param name="itemStatusQJ"></param>
/// <param name="itemUpper"></param>
/// <param name="itemLower"></param>
/// <param name="itemSpectrum"></param>
/// <param name="itemStartTime"></param>
/// <param name="itemPerValue"></param>
/// <param name="itemPerType"></param>
/// <returns></returns>
public bool AddItem(string nodeKey, string itemBw, string itemDesc, string itemContent, string itemObserve, string itemUnit, string itemType, string itemStatus, string itemStatusQJ, string itemUpper, string itemLower, string itemSpectrum, string itemStartTime, string itemPerValue, string itemPerType, out string errMsg)
{
object obj = null;
bool flag = false;
int count = 0;
errMsg = "";
sql = "select T_ITEMID from T_BASE_ITEM where T_DEVICEID='" + nodeKey + "' order by ID_KEY DESC fetch first 1 rows only ";
obj = DBdb2.GetSingle(sql);
if (obj != null && obj.ToString() != "")
{
count = int.Parse(obj.ToString()) + 1;
}
else
{
count = 1;
}
sql = "insert into T_BASE_ITEM ";
sql += "(T_ITEMID,T_ITEMPOSITION,T_ITEMDESC,T_CONTENT,T_TYPE,I_STATUS,T_OBSERVE,T_UNIT,F_LOWER,F_UPPER,I_SPECTRUM,T_DEVICEID,T_STARTTIME,T_PERIODTYPE,T_PERIODVALUE,T_STATUS)";
sql += " values ";
sql += "('" + count + "','" + itemBw + "','" + itemDesc + "','" + itemContent + "','" + itemType + "'," + itemStatus + ",'" + itemObserve + "','" + itemUnit + "'," + double.Parse(itemLower) + "," + double.Parse(itemUpper) + "," + int.Parse(itemSpectrum) + ",'" + nodeKey + "','" + DateTime.Parse(itemStartTime).ToString("yyyy-MM-dd 0:00:00") + "'," + int.Parse(itemPerType) + "," + int.Parse(itemPerValue) + "," + int.Parse(itemStatusQJ) + ")";
flag = DBdb2.RunNonQuery(sql, out errMsg);
if (flag != true)
{
errMsg = "新建点检项失败!";
}
return(flag);
}
/// <summary>
/// 编辑人员信息
/// </summary>
/// <param name="oldId">原用户名称</param>
/// <param name="trueName">真实姓名</param>
/// <param name="id">新用户名称</param>
/// <param name="pwd">用户密码</param>
/// <param name="classID">班值编码</param>
/// <param name="path">图片文件(字节数组)</param>
/// <returns></returns>
public bool EditMemberInfo(string oldId, string trueName, string id, string pwd, string classID, byte[] img)
{
try
{
if (img != null)
{
OleDbConnection con = new OleDbConnection(DBdb2.SetConString());
con.Open();
if (oldId == id)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME=?,T_PASSWD=?,T_CLASSID=?,B_ATTACHMENT=? where T_USERID='" + oldId + "'";
OleDbCommand oledbcom = new OleDbCommand(sql, con);
oledbcom.Parameters.Add("?", trueName);
oledbcom.Parameters.Add("?", pwd);
oledbcom.Parameters.Add("?", classID);
oledbcom.Parameters.Add("?", img);
if (oledbcom.ExecuteNonQuery() > 0)
{
result = true;
}
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID=?,T_USERNAME=?,T_PASSWD=?,T_CLASSID=?,B_ATTACHMENT=? where T_USERID='" + oldId + "'";
OleDbCommand oledbcom = new OleDbCommand(sql, con);
oledbcom.Parameters.Add("?", id);
oledbcom.Parameters.Add("?", trueName);
oledbcom.Parameters.Add("?", pwd);
oledbcom.Parameters.Add("?", classID);
oledbcom.Parameters.Add("?", img);
result = DBdb2.RunNonQuery("update T_SYS_MEMBERRELATION set T_USERID='" + id + "' where T_USERID='" + oldId + "';", out errMsg);
if (oledbcom.ExecuteNonQuery() > 0 && result == true)
{
result = true;
}
}
con.Close();
}
else
{
if (oldId == id)
{
sql += "update T_SYS_MEMBERINFO set T_USERNAME='******',T_PASSWD='" + pwd + "',T_CLASSID='" + classID + "' where T_USERID='" + oldId + "';";
}
else
{
sql += "update T_SYS_MEMBERINFO set T_USERID='" + id + "',T_USERNAME='******',T_PASSWD='" + pwd + "',T_CLASSID='" + classID + "' where T_USERID='" + oldId + "';update T_SYS_MEMBERRELATION set T_USERID='" + id + "' where T_USERID='" + oldId + "';";
}
result = DBdb2.RunNonQuery(sql, out errMsg);
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
/// <summary>
/// 编辑线路
/// </summary>
/// <param name="lID"></param>
/// <param name="lName"></param>
/// <param name="lType"></param>
/// <param name="lGw"></param>
/// <param name="lPID"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public bool EditLineInfo(string lID, string lName, string lType, string lGw, string lPID, out string errMsg)
{
bool flag = false;
sql = "update t_base_route set T_ROUTENAME='" + lName + "',T_ORGID='" + lGw + "',i_type=" + lType + " where T_ROUTEID='" + lID + "'";
flag = DBdb2.RunNonQuery(sql, out errMsg);
return(flag);
}
/// <summary>
/// 新建线路
/// </summary>
/// <param name="lName">线路名称</param>
/// <param name="lType">线路类型</param>
/// <param name="lGw">线路岗位</param>
/// <param name="lPID">线路父ID</param>
public bool AddLineInfo(string lName, string lType, string lGw, string lPID, out string errMsg)
{
int count = 1;
object obj = null;
bool flag = false;
sql = "select * from T_BASE_ROUTE as b inner join T_INFO_ROUTE as i on b.T_ROUTEID=i.T_NODEID where i.T_NODEKEY='" + lPID + "'";
DataRow drIS = DBdb2.RunDataRow(sql, out errMsg);
if (drIS == null)
{
sql = "select * from T_BASE_ROUTE where T_ROUTENANME='" + lName + "'";
DataRow dr = DBdb2.RunDataRow(sql, out errMsg);
if (dr == null)
{
int countBase = 1;
sql = "select T_ROUTEID from T_BASE_ROUTE order by ID_KEY DESC fetch first 1 rows only ";// "select * from T_BASE_ROUTE where T_ROUTENAME='" + lName + "'";
obj = DBdb2.RunSingle(sql, out errMsg);
if (obj != null && obj.ToString() != "")
{
countBase = int.Parse(obj.ToString()) + 1;
}
sql = "select T_NODEKEY from T_INFO_ROUTE order by ID_KEY DESC fetch first 1 rows only ";
obj = DBdb2.GetSingle(sql);
if (obj != null && obj.ToString() != "")
{
count = int.Parse(obj.ToString()) + 1;
}
sql = "insert into T_BASE_ROUTE (T_ROUTEID,T_ROUTENAME,T_ORGID,I_TYPE) values ('" + countBase + "','" + lName + "','" + lGw + "'," + lType + ")";
string sql1 = "insert into T_INFO_ROUTE (T_NODEID,T_NODEKEY,T_PARAENTID,T_DESC) values ('" + countBase + "','" + count.ToString() + "','" + lPID + "','XL')";
flag = DBdb2.RunNonQuery(sql, out errMsg);
DBdb2.RunNonQuery(sql1, out errMsg);
}
else
{
errMsg = "此线路已被添加!";
}
}
else
{
errMsg = "线路下不允许在新建线路!";
}
return(flag);
}
/// <summary>
/// 新增设备状态
/// </summary>
/// <param name="devID"></param>
/// <param name="time"></param>
/// <param name="count"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public bool SaveStatus(string devID, string time, string count, out string errMsg)
{
errMsg = "";
bool flag = false;
sql = "insert into T_INFO_DEVICE (T_DEVICEID,T_TIME,I_STATUS) values ('" + devID + "','" + DateTime.Parse(time).ToString("yyyy-MM-dd 0:00:00") + "'," + count + ")";
flag = DBdb2.RunNonQuery(sql, out errMsg);
return(flag);
}
/// <summary>
/// 添加组织关系
/// </summary>
/// <param name="parentId">父类ID</param>
/// <param name="id">组织编码</param>
/// <param name="name">组织名称</param>
/// <returns></returns>
public bool AddOrganize(string parentId, string id, string name)
{
sql = "insert into T_SYS_ORGANIZE(T_ORGID,T_ORGDESC,T_PARENTID) values('" + id + "','" + name + "','" + parentId + "');";
try
{
result = DBdb2.RunNonQuery(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
/// <summary>
/// 分配职位
/// </summary>
/// <param name="parentId">职位ID</param>
/// <param name="membersId">人员ID</param>
/// <param name="state">岗位类型</param>
/// <returns></returns>
public bool AddMember(string parentId, string membersId, int state)
{
sql = "insert into T_SYS_MEMBERRELATION(T_USERID,T_ORGID,I_STATUS) values('" + membersId + "','" + parentId.Trim() + "'," + state + ");";
try
{
result = DBdb2.RunNonQuery(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
/// <summary>
/// 删除人员信息
/// </summary>
/// <param name="id">人员编码</param>
/// <returns></returns>
public bool RemoveMember(string id)
{
sql = "delete from T_SYS_MEMBERINFO where T_USERID in (" + id + ");delete from T_SYS_MEMBERRELATION where T_USERID in (" + id + ");";
try
{
result = DBdb2.RunNonQuery(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
/// <summary>
/// 删除组织关系
/// </summary>
/// <param name="id">组织编码</param>
/// <returns></returns>
public bool RemoveOrganize(string id)
{
sql = "delete from T_SYS_ORGANIZE where T_ORGID in (" + id + ")";
try
{
result = DBdb2.RunNonQuery(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
/// <summary>
/// 编辑组织关系
/// </summary>
/// <param name="oid">组织原编码</param>
/// <param name="id">组织新编码</param>
/// <param name="name">组织名称</param>
/// <returns></returns>
public bool EditOrganize(string oid, string id, string name)
{
sql = "update T_SYS_ORGANIZE set T_ORGID='" + id + "' , T_ORGDESC='" + name + "' where T_ORGID='" + oid + "'";
try
{
result = DBdb2.RunNonQuery(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
/// <summary>
/// 编辑设备状态信息
/// </summary>
/// <param name="nodeKey"></param>
/// <returns></returns>
public bool EditStatusByIDkey(string idkey, string time, string statusid, out string errMsg)
{
bool flag = false;
sql = "update T_INFO_DEVICE set T_time='" + DateTime.Parse(time).ToString("yyyy-MM-dd 00:00:00") + "', i_status=" + statusid + " where ID_KEY=" + idkey;
flag = DBdb2.RunNonQuery(sql, out errMsg);
if (flag == false)
{
errMsg = "修改数据出错!";
}
return(flag);
}
public bool Re_Name(string id)
{
bool flag = false;
string errMsg = "";
string sql = "update T_BASE_DATUNM_DATA set FILE_DESC ='" + id.Split(',')[1] + "' where ID_KEY=" + id.Split(',')[0];
if (rlDBType == "SQL")
{
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
public bool Edit_data(string para)
{
this.init();
bool flag = false;
string errMsg = "";
string sql = "update 超温考核记录表 set 事件描述='" + para.Split(',')[1] + "',原因分析='" + para.Split(',')[2] + "',处理建议='" + para.Split(',')[3] + "' where ID_KEY=" + para.Split(',')[0];
if (rlDBType == "SQL")
{
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
public bool De_lete(string id)
{
bool flag = false;
string errMsg = "";
string sql = "delete from T_BASE_DATUNM_DATA where ID_KEY=" + id;
if (rlDBType == "SQL")
{
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
public bool Save_data(string para)
{
this.init();
bool flag = false;
string errMsg = "";
string sql = "update 超温考核故障类型表 set 提示信息 = '" + para.Split(',')[2] + "',考核上限 =" + para.Split(',')[0] + ", 考核下限=" + para.Split(',')[1] + " where 故障类型ID='" + para.Split(',')[3] + "'";
if (rlDBType == "SQL")
{
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
public bool Delete_data(string para)
{
this.init();
bool flag = false;
string errMsg = "";
string sql = "delete from 超温考核故障映射表 where ID_KEY=" + para;
if (rlDBType == "SQL")
{
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
/// <summary>
/// 更新指定时间供电能耗月线信息。
/// </summary>
/// <returns></returns>
public bool UpdateMonthConsumeByTime(MonthConsumeInfo info, out string errMsg)
{
this.init();
errMsg = "";
bool flag = false;
string sql = "update T_INFO_MONTHCONSUME SET T_VALUE=" + info.values + " where T_YEAR='" + info.year + "' and T_MONTH='" + info.month + "'";
if (rlDBType == "SQL")
{
// sql = "select ID_KEY,班次名,起始时间,结束时间 from 班次时间表 order by ID_KEY";
//dt = DBsql.RunDataTable(sql, out errMsg);
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
private void DeleteArea(string idkey)
{
string id = "";
string info = "";
string[] str = null;
if (idkey.Contains(','))
{
str = idkey.Split(',');
}
else
{
str = new string[1];
str[0] = idkey;
}
for (int i = 0; i < str.Length; i++)
{
id = str[i].Replace("'", "");
sql = @"delete from T_BASE_AREA where ID_KEY = " + id;
bool falg = DBdb2.RunNonQuery(sql, out errMsg);
if (errMsg == "")
{
info = "删除成功!";
}
else
{
info = "删除失败!";
}
}
obj = new
{
msg = info
};
string result = JsonConvert.SerializeObject(obj);
Response.Write(result);
Response.End();
}
/// <summary>
/// 删除区域
/// </summary>
/// <param name="areaID"></param>
/// <param name="nodeKey"></param>
/// <param name="errMsg"></param>
/// <returns></returns>
public bool DelArea(string areaID, string nodeKey, out string errMsg)
{
bool flag = false;
//查询到此区域下的所有设备
sql = "SELECT * FROM T_INFO_ROUTE as r1 inner join T_INFO_ROUTE as r2 on r1.T_NODEKEY =r2.T_PARAENTID where r1.T_NODEKEY='" + nodeKey + "'";
DataTable dtDev = DBdb2.RunDataTable(sql, out errMsg);
if (dtDev != null && dtDev.Rows.Count > 0)
{
for (int i = 0; i < dtDev.Rows.Count; i++)
{
string DevNodeKey = dtDev.Rows[i]["T_NODEKEY1"].ToString();
//删除devNodekey 设备下所有点检项
sql = "delete from T_INFO_ROUTE where T_PARAENTID='" + DevNodeKey + "'";
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
}
else
{
flag = true;
}
//删除此区域下的所有设备
if (flag == true)
{
sql = "delete from T_INFO_ROUTE where T_PARAENTID ='" + nodeKey + "'";
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
//删除此区域
if (flag == true)
{
sql = "delete from T_INFO_ROUTE where T_NODEKEY='" + nodeKey + "'";
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
/// <summary>
/// 根据机组Id更新机组部分信息。
/// </summary>
/// <param name="unitId"></param>
/// <param name="professionalId"></param>
/// <param name="reasonId"></param>
/// <param name="eventDesc"></param>
/// <param name="reasonAnalyse"></param>
/// <param name="dealCondition"></param>
/// <returns></returns>
public bool UpdateUnit(string unitId, string professionalId, string reasonId, string eventDesc, string reasonAnalyse, string dealCondition, out string errMsg)
{
this.init();
errMsg = "";
bool flag = false;
//string sql1 = "select min(ID_KEY) as ID_KEY,UGROUP from WebUser group by UGROUP order by ID_KEY";
string sql = "update T_INFO_UNIT set T_FPROFEESIOID='" + professionalId + "',T_FREASONID='" + reasonId + "',T_EVENTDESC='" + eventDesc + "',T_REASONANALYSE='" + reasonAnalyse + "',T_DEALCONDITION='" + dealCondition + "' where ID_KEY=" + unitId + "";
if (rlDBType == "SQL")
{
// sql = "select ID_KEY,班次名,起始时间,结束时间 from 班次时间表 order by ID_KEY";
//dt = DBsql.RunDataTable(sql, out errMsg);
}
else
{
flag = DBdb2.RunNonQuery(sql, out errMsg);
}
return(flag);
}
//删除数据
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
if (GridView2.Rows.Count > 0)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('正在进行添加，禁止删除！')", true);
}
else if (GridView1.EditIndex != -1)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('正在进行编辑，禁止删除！')", true);
}
else
{
string sql = "";
sql = @"delete from T_BASE_AREA where ID_KEY = " + GridView1.DataKeys[e.RowIndex].Values[0];
bool falg = DBdb2.RunNonQuery(sql, out errMsg);
//num = GridView1.PageSize * GridView1.PageIndex;
GridView1_Bind();
}
}
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
string sql = "";
try
{
sql = @"update T_BASE_AREA set T_AREAID = '" + ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text
+ "',T_AREANAME = '" + ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[2].Controls[0]).Text
+ "' where ID_KEY = " + GridView1.DataKeys[e.RowIndex].Values[0];
bool falg = DBdb2.RunNonQuery(sql, out errMsg);
GridView1.EditIndex = -1;
//num = GridView1.PageSize * GridView1.PageIndex;
GridView1_Bind();
}
catch (Exception err)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('更新失败!')", true);
}
}
/// <summary>
/// 分配职位
/// </summary>
/// <param name="parentId">职位ID</param>
/// <param name="memberId">人员ID集合</param>
/// <returns></returns>
public bool AddMember(string parentId, string[] membersId)
{
sql = "delete from T_SYS_MEMBERRELATION where T_ORGID='" + parentId.Trim() + "';";
if (membersId != null)
{
for (int i = 0; i < membersId.Length; i++)
{
sql += "insert into T_SYS_MEMBERRELATION(T_USERID,T_ORGID,I_STATUS) values('" + membersId[i].Trim() + "','" + parentId.Trim() + "',1);";
}
}
try
{
result = DBdb2.RunNonQuery(sql, out errMsg);
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
protected void GridView2_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
string sql = "";
sql = @"insert into T_BASE_AREA (T_AREAID,T_AREANAME) values('"
+ ((TextBox)this.GridView2.Rows[0].FindControl("cdm")).Text + "','"
+ ((TextBox)this.GridView2.Rows[0].FindControl("jzm")).Text + "')";
bool falg = DBdb2.RunNonQuery(sql, out errMsg);
GridView2.EditIndex = -1;
//num = GridView1.PageSize * GridView1.PageIndex;
GridView1_Bind();
this.GridView2.DataBind();
}
catch (Exception err)
{
ScriptManager.RegisterStartupScript(this.Page, this.GetType(), "onekey", "alert('插入失败!')", true);
}
}
/// <summary>
/// 上传检测结果
/// </summary>
/// <param name="routeId">线路ID</param>
/// <param name="area">区域ID</param>
/// <param name="deviceId">设备ID</param>
/// <param name="itemId">点检项目ID</param>
/// <param name="sTime">开始时间</param>
/// <param name="eTime">结束时间</param>
/// <param name="cTime">检测时间</param>
/// <param name="uTime">上传时间</param>
/// <returns></returns>
public bool ChangeState(string[] routeId, string[] area, string[] deviceId, string[] itemId, string[] sTime, string[] eTime, string[] cTime, string[] uTime)
{
for (int i = 0; i < itemId.Length; i++)
{
if (Convert.ToDateTime(cTime[i]) >= Convert.ToDateTime(sTime[i]) && Convert.ToDateTime(cTime[i]) <= Convert.ToDateTime(eTime[i]))
{
sql += "update T_INFO_QUESTCOMPLETE set I_STATUS=1 where T_ROUTEID='" + routeId[i] + "' and T_AREAID='" + area[i] + "' and T_DEVICEID='" + deviceId[i] + "' and T_ITEMID='" + itemId[i] + "' and T_STARTTIME ='" + sTime[i] + "';";
}
}
try
{
if (DBdb2.RunNonQuery(sql, out errMsg))
{
result = true;
}
}
catch (Exception ex)
{
LogHelper.WriteLog(LogHelper.EnLogType.Run, "发生时间：" + DateTime.Now.ToString("yyyy-MM-dd H:mm:ss") + "/n错误信息：" + ex.Message);
}
return(result);
}
