public ActionResult DeleteOrderInfo(string orderid) { string result = "OK"; try { //删除文件 List <t_cm_files> list = fm.FileList("order", orderid); string id = "", filepath = ""; if (list.Count > 0) { foreach (t_cm_files file in list) { id = id + file.ID + ","; //删除文件 filepath = Server.MapPath(file.FilePath); DirectoryUtil.DeleteFile(filepath); } id = id.TrimEnd(','); //删除资料表信息 fm.DeleteFile(id); } //删除工单 string strsql = "delete from t_PM_Order where OrderID in (" + orderid + ")"; int docount = bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("工单管理", CurrentUser.UserName, "删除工单信息[" + orderid + "]");//log } catch (Exception ex) { result = "删除失败!"; } return(Content(result)); }
//保存测点对照表 public ActionResult SavePointmapdts(t_cm_pointmapdts model) { string result = "OK"; //新增 try { List <t_cm_pointmapdts> list = bll.t_cm_pointmapdts.Where(p => p.tagid == model.tagid).ToList(); if (list.Count > 0)//修改 { string strsql = "update t_cm_pointmapdts set dname='" + model.dname + "',channelsinfoid=" + model.channelsinfoid + ",cname='" + model.cname + "',zonename='" + model.zonename + "',zoneno=" + model.zoneno + " where tagid=" + model.tagid; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "修改光纤分区对照[测点ID:" + model.tagid + "]"); } else { bll.t_cm_pointmapdts.AddObject(model); bll.SaveChanges(); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "新增光纤分区对照[定位点ID:" + model.tagid + "]"); } } catch (Exception ex) { result = ex.ToString(); } return(Content(result)); }
public ActionResult MonthBoll(int?Month, int PID, int DID, int CID) { if (Month != null) { for (int j = 1; j < 31; j++) { string sSql = "exec proc_ee_insertrandom '2017-" + Month + "-" + j + " 00:00:00','t_EE_PowerQualityMonthly','" + PID + "','" + DID + "','" + CID + "'"; bll.ExecuteStoreCommand(sSql); } } return(Content("OK")); }
//操作数据库门禁开关; public ActionResult changeDoorStatus(int doorId) { try { string strJson = ""; string pdrlist = HomeController.GetPID(CurrentUser.UNITList); //string pdrlist = CurrentUser.PDRList; if (pdrlist == null) { return(Content("")); } List <t_CM_Door> listDoors = bll.ExecuteStoreQuery <t_CM_Door>("SELECT * FROM t_CM_Door WHERE DoorId=" + doorId).ToList(); if (listDoors != null && listDoors.Count > 0) { int goToStatus = listDoors[0].DoorStatus == 0?1:0; bll.ExecuteStoreCommand("UPDATE t_CM_Door SET GoToStatus=" + goToStatus + " WHERE DoorId=" + doorId); strJson = "{\"resultCode\": 0,\"doorId\": " + doorId + ",\"DoorStatus\": " + bll.ExecuteStoreQuery <t_CM_Door>("SELECT * FROM t_CM_Door WHERE DoorId=" + doorId).ToList()[0].DoorStatus + "}"; } return(Content(strJson)); } catch { return(Content("{\"resultCode\": 1,\"doorId\": " + doorId + ",\"DoorStatus\": 0}")); } }
//保存测点对照表 public ActionResult SavePointmapdts(t_cm_pointmapdts model) { string result = "OK", strsql = ""; //新增 try { List <t_cm_pointmapdts> list2 = bll.t_cm_pointmapdts.Where(p => p.devicesinfoid == model.devicesinfoid && p.channelsinfoid == model.channelsinfoid && p.zoneno == model.zoneno && p.parentid == 0).ToList(); if (list2.Count == 0 || list2[0].tagid == model.tagid)//判断纤分区已分配是否已经分配 { List <t_cm_pointmapdts> list = bll.t_cm_pointmapdts.Where(p => p.tagid == model.tagid).ToList(); if (list.Count > 0)//修改 { strsql = " select beginIndex id,endIndex text from t_dts_bi_channelzone where zoneno=" + model.zoneno + " and channelsinfoid=" + model.channelsinfoid + " and devicesinfoid=" + model.devicesinfoid; List <DDLValue> listzone = SQLtoDataSet.GetMySqlList(strsql); int startPt = 0, endPt = 0; if (listzone.Count > 0) { startPt = listzone[0].id; endPt = Convert.ToInt32(listzone[0].text); } strsql = "update t_cm_pointmapdts set startPt=" + startPt + ",endPt=" + endPt + ",devicesinfoid=" + model.devicesinfoid + ", dname='" + model.dname + "',channelsinfoid=" + model.channelsinfoid + ",cname='" + model.cname + "',zonename='" + model.zonename + "',zoneno=" + model.zoneno + " where tagid=" + model.tagid; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "修改光纤分区对照[测点ID:" + model.tagid + "]"); } else { strsql = "insert into t_cm_pointmapdts values(" + model.pid + "," + model.did + "," + model.tagid + "," + model.devicesinfoid + ",'" + model.dname + "'," + model.channelsinfoid + ",'" + model.cname + "'," + model.zoneno + ",'" + model.zonename + "')"; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("光纤分区对照管理", CurrentUser.UserName, "新增光纤分区对照[定位点ID:" + model.tagid + "]"); } } else { result = "该光纤分区已分配,请从新分配!"; } } catch (Exception ex) { result = strsql; } return(Content(result)); }
//[Login] public ActionResult Upload(HttpPostedFileBase fileData, string folder, int pid, int channelid, string channelname, string positionName, string maxtemp, string mintemp, int iNewnCCDW, int iNewnIRW, int iNewnIRH) { if (fileData != null) { try { ControllerContext.HttpContext.Request.ContentEncoding = Encoding.GetEncoding("UTF-8"); ControllerContext.HttpContext.Response.ContentEncoding = Encoding.GetEncoding("UTF-8"); ControllerContext.HttpContext.Response.Charset = "UTF-8"; // 文件上传后的保存路径 string url = "~/UploadFiles/" + folder + "/" + DateTime.Now.ToString("yyyyMM") + "/"; string filePath = Server.MapPath(url); DirectoryUtil.CreateDirectory(filePath); string fileName = Path.GetFileName(fileData.FileName); //原始文件名称 string fileExtension = Path.GetExtension(fileName); //文件扩展名 //string saveName = Guid.NewGuid().ToString() + fileExtension; //保存文件名称 string saveName = DateTime.Now.Ticks + fileExtension; fileData.SaveAs(filePath + saveName); byte[] FileData = ReadFileBytes(fileData); double fileSize = FileData.Length; double fileSizeKB = fileSize / 1024; fileSizeKB = Math.Round(fileSizeKB, 2); string fSize = fileSizeKB + "KB"; string fullurl = url + saveName; string imgpath = "", reportpath = "", filetype = "doc"; if (fileExtension.Contains("doc")) { reportpath = fullurl; imgpath = ""; filetype = "doc"; } else { reportpath = ""; imgpath = fullurl; filetype = "image"; } string strsql = "INSERT INTO t_SM_InfraredPic(PID,ChannelID,ChannelName,PositionName,ImgPath,ImgNameOld,FileSize,MaxTemp,MinTemp,ReportPath,CommitTime,NewnCCDW,NewnIRW,NewnIRH)VALUES(" + pid + "," + channelid + ",'" + channelname + "','" + positionName + "','" + imgpath + "','" + fileName + "','" + fSize + "'," + maxtemp + "," + mintemp + ",'" + reportpath + "',getdate()," + iNewnCCDW + "," + iNewnIRW + "," + iNewnIRH + ");"; strsql = strsql + "INSERT INTO t_cm_files([FileName],FilePath,FileType,FileSize,FileExtension,Modules,Fk_ID,FSource,MaxTemp,MinTemp,Remark,CommitUser,CommitTime)VALUES('" + fileName + "','" + fullurl + "','" + filetype + "','" + fSize + "','" + fileExtension + "','shuangshi',0,'pc'," + maxtemp + "," + mintemp + ",'双视上传','双视桌面版',getdate());"; bll.ExecuteStoreCommand(strsql, null); return(Content("success")); } catch (Exception ex) { //return Content(ex.ToString()); return(Content("false"));; } } else { return(Content("false")); } }
//确认所有配电房的报警 public ActionResult DelAllPAlarm() { try { string PDRList = HomeController.GetPID(CurrentUser.UNITList); // string PDRList = CurrentUser.PDRList; if (!PDRList.Equals("")) { string sSql = "update [t_AlarmTable_en] set AlarmState = 0,AlarmConfirm='已确认',UserName='******',ConfirmDate='" + DateTime.Now.ToString("yyyy-MM-dd HH:mm") + "' where PID in (" + PDRList + ") and AlarmConfirm='未确认' and AlarmState>0"; bll.ExecuteStoreCommand(sSql); return(Content("报警已全部确认!")); } else { return(Content("没有权限,报警未确认!")); } } catch (Exception ex) { string error = ex.ToString(); return(Content("报警确认失败!")); } }
public ActionResult DeleteSupplierInfo(string supplierid) { string result = "OK"; try { string strsql = "delete from t_CM_SupplierInfo where supplierid in (" + supplierid + ")"; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("供应商管理", CurrentUser.UserName, "删除供应商信息[" + supplierid + "]"); } catch (Exception ex) { result = "删除失败!"; } return(Content(result)); }
public ActionResult DeleteSparePartInfo(string sparepartid) { string result = "OK"; try { string strsql = "delete from t_CM_SparePartInfo where SparePartID in (" + sparepartid + ")"; bll.ExecuteStoreCommand(strsql, null); Common.InsertLog("备件管理", CurrentUser.UserName, "删除备件信息[" + sparepartid + "]"); } catch (Exception ex) { result = "删除失败!"; } return(Content(result)); }
private void sendAlarm(IDAO.Models.t_AlarmTable_en alarm) { int pid = (int)alarm.PID; //List<t_CM_UserInfo> userList = bll.ExecuteStoreQuery<t_CM_UserInfo>("SELECT * FROM t_CM_UserInfo WHERE (PDRList LIKE '" + pid + ",%' OR PDRList = '%," + pid + "' OR PDRList LIKE '%," + pid + ",%' OR PDRList = '" + pid + "')").ToList(); IList <IDAO.Models.t_CM_Unit> unitlist = UnitDAL.getInstance().GetUnitListByPID(pid); if (unitlist.Count() > 0) { string uids = string.Empty; foreach (var item in unitlist) { uids += item.UnitID + ","; } if (!string.IsNullOrEmpty(uids)) { uids = uids.Substring(0, uids.Length - 1); IList <IDAO.Models.t_CM_UserInfo> userList = UserInfoDAL.getInstance().GetUsersByUnits(uids); if (userList == null || userList.Count <= 0) { return; } for (int i = 0; i < userList.Count; i++) { if (userList[i].OpenAlarmMsg == 1) { //根据手机号查询该报警是否发过短信; List <t_Alarm_SMS> sendedList = bll.ExecuteStoreQuery <t_Alarm_SMS>("SELECT * FROM t_Alarm_SMS WHERE mobilephone='" + userList[i].Mobilephone + "' AND alarmId=" + alarm.AlarmID).ToList(); if (sendedList == null || sendedList.Count <= 0) { UtilsSms.smsAlarm(userList[i].Mobilephone, alarm); //INSERT INTO t_Alarm_SMS (alarmTime,alarmId,sendTime,mobilephone) VALUES ('2018-03-20 16:53:11',1522,'2018-03-20 16:53:11','15210091230') string insert = "INSERT INTO t_Alarm_SMS (alarmTime,alarmId,sendTime,mobilephone) VALUES ('" + alarm.AlarmDateTime + "'," + alarm.AlarmID + ",'" + DateTime.Now.ToString() + "','" + userList[i].Mobilephone + "')"; bll.ExecuteStoreCommand(insert); } } } } } //Debug.WriteLine(DateTime.Now.ToString() + ",alarm.PID=" + alarm.PID);//c#打印输出信息 }
public static string doImport2003(DataSet tDS, int Mode) { StringBuilder Result = new StringBuilder(); string TagIDs = ""; int errorCount = 0; try { pdermsWebEntities bll = new pdermsWebEntities(); //检验excel表格中的数据是否符合格式 //检查列数是否与数据库一致 if (tDS.Tables[0].Columns.Count == 42) { for (int i = 0; i < tDS.Tables[0].Rows.Count; i++) { string MDate = tDS.Tables[0].Rows[i][1].ToString(); string Val = tDS.Tables[0].Rows[i][2].ToString(); for (int j = 0; j < tDS.Tables[0].Columns.Count; j++) { //检查TagID if (tDS.Tables[0].Rows[i][0].ToString() == "") { Result.Append("错误:第" + i + "列,缺少TagID。<br>"); errorCount++; } else { TagIDs += tDS.Tables[0].Rows[i][0].ToString() + ","; } //检查DID if (tDS.Tables[0].Rows[i][2].ToString() == "") { Result.Append("错误:第" + i + "列,缺少DID。<br>"); errorCount++; } //检查实时库索引 if (tDS.Tables[0].Rows[i][14].ToString() == "") { Result.Append("错误:第" + i + "列,缺少实时库索引。<br>"); errorCount++; } //检查PID if (tDS.Tables[0].Rows[i][15].ToString() == "") { Result.Append("错误:第" + i + "列,缺少PID。<br>"); errorCount++; } } } } else { Result.Append("错误:列数错误。\r"); errorCount++; } string pointSQL = "SELECT * FROM t_CM_PointsInfo WHERE TagID in (" + TagIDs.TrimEnd(',') + ")"; List <t_CM_PointsInfo> list = bll.ExecuteStoreQuery <t_CM_PointsInfo>(pointSQL).ToList(); if (list.Count > 0) { //覆盖模式下删除重复数据 if (Mode > 0) { list.ForEach(i => { bll.AttachTo("t_CM_PointsInfo", i); bll.t_CM_PointsInfo.DeleteObject(i); }); bll.SaveChanges(); } else { foreach (t_CM_PointsInfo p in list) { Result.Append("错误:数据库中已经存在 TagID = " + p.TagID + "的行。<br>"); errorCount++; } } } StringBuilder strSQL = new StringBuilder(); if (errorCount < 1) { //关闭标识 strSQL.Append("set IDENTITY_INSERT t_CM_PointsInfo ON "); //插入数据库 for (int i = 0; i < tDS.Tables[0].Rows.Count; i++) { strSQL.Append("insert into t_CM_PointsInfo (TagID,TagName,DID,DataTypeID,Position,MPID,UseState,PIOID,ABCID,Remarks,数据类型,设备点名,中文描述,站内点号,实时库索引,PID,通信地址,例外报告死区,工程下限,工程上限,码值下限,码值上限,远动数据类型,报警下限1,报警上限1,报警定义,置0说明,置1说明,单位,分组,最大间隔时间,小信号切除值,报警下限2,报警上限2,报警下限3,报警上限3,报警死区,报警级别,报警方式,速率报警限制,初始值,传感器SN编码) "); strSQL.Append("values (" + "" + tDS.Tables[0].Rows[i][0] + "," + "'" + tDS.Tables[0].Rows[i][1] + "'," + "" + tDS.Tables[0].Rows[i][2] + "," + "" + tDS.Tables[0].Rows[i][3] + "," + "'" + tDS.Tables[0].Rows[i][4] + "'," + "" + tDS.Tables[0].Rows[i][5] + "," + "" + tDS.Tables[0].Rows[i][6] + "," + "" + tDS.Tables[0].Rows[i][7] + "," + "" + tDS.Tables[0].Rows[i][8] + "," + "'" + tDS.Tables[0].Rows[i][9] + "'," + "'" + tDS.Tables[0].Rows[i][10] + "'," + "'" + tDS.Tables[0].Rows[i][11] + "'," + "'" + tDS.Tables[0].Rows[i][12] + "'," + "'" + tDS.Tables[0].Rows[i][13] + "'," + "" + tDS.Tables[0].Rows[i][14] + "," + "" + tDS.Tables[0].Rows[i][15] + "," + "" + tDS.Tables[0].Rows[i][16] + "," + "" + tDS.Tables[0].Rows[i][17] + "," + "" + tDS.Tables[0].Rows[i][18] + "," + "" + tDS.Tables[0].Rows[i][19] + "," + "" + tDS.Tables[0].Rows[i][20] + "," + "" + tDS.Tables[0].Rows[i][21] + "," + "'" + tDS.Tables[0].Rows[i][22] + "'," + "" + tDS.Tables[0].Rows[i][23] + "," + "" + tDS.Tables[0].Rows[i][24] + "," + "" + tDS.Tables[0].Rows[i][25] + "," + "'" + tDS.Tables[0].Rows[i][26] + "'," + "'" + tDS.Tables[0].Rows[i][27] + "'," + "'" + tDS.Tables[0].Rows[i][28] + "'," + "" + tDS.Tables[0].Rows[i][29] + "," + "" + tDS.Tables[0].Rows[i][30] + "," + "" + tDS.Tables[0].Rows[i][31] + "," + "" + tDS.Tables[0].Rows[i][32] + "," + "" + tDS.Tables[0].Rows[i][33] + "," + "" + tDS.Tables[0].Rows[i][34] + "," + "" + tDS.Tables[0].Rows[i][35] + "," + "" + tDS.Tables[0].Rows[i][36] + "," + "" + tDS.Tables[0].Rows[i][37] + "," + "" + tDS.Tables[0].Rows[i][38] + "," + "" + tDS.Tables[0].Rows[i][39] + "," + "" + tDS.Tables[0].Rows[i][40] + "," + "'" + tDS.Tables[0].Rows[i][41] + "')"); } strSQL.Append("set IDENTITY_INSERT t_CM_PointsInfo OFF"); bll.ExecuteStoreCommand(strSQL.ToString()); Result.Append("OK"); } return(Result.ToString()); } catch (Exception e) { string a = e.ToString(); return(a); } }
/// <summary> /// 删除文件 /// </summary> /// <param name="id">文件主键列表</param> public void DeleteFile(string id) { string strsql = "delete from t_cm_files where ID in (" + id + ")"; int docount = bll.ExecuteStoreCommand(strsql, null); }