/// <summary> /// 获取用户的基础信息 author:liwu 2017-12-21 /// </summary> /// <returns></returns> public ActionResult GetUserBaseInfo(RequestData data) { FieldModel where = null; string userName = data.Get("userName"); string userID = data.Get("userID"); if (string.IsNullOrEmpty(userName) && string.IsNullOrEmpty(userID)) { //默认当前登录用户 userName = CurrentUser.UserName; } if (!string.IsNullOrEmpty(userName)) { where &= BASUSER.USERNAME == userName; } if (!string.IsNullOrEmpty(userID)) { where &= BASUSER.ID == userID; } var sql = SqlModel.SelectAll() .From(DB.BASUSER).OrderByAsc(BASUSER.ID).Where(BASUSER.ISDEL == "0") .Where(where); var list = sql.ExecToDynamicList(); if (list != null && list.Count > 0) { list[0]["PASSWORD"] = string.Empty; return(Json(list[0])); } return(Json(new { })); }
/// <summary> /// 污染物超标 /// </summary> /// <param name="data"></param> /// <returns></returns> private DataTable GetExcessivePollutSource(RequestData data, DataTable dataTable) { FieldModel where = null; if (data.Get("CompanyID") != "-1") { where &= T_MID_ALERT.COMPANYID == data.Get("CompanyID"); } else { where &= T_MID_ALERT.PKID == data.Get("PKID"); } where &= T_MID_ALERT.TYPE == 0; SqlModel model = SqlModel.SelectAll("A".Field("TITLE").As("CODE_TEXT"), "B".Field("TITLE").As("CODE_TEXT2"), "C".Field("NAME").As("PK_NAME")).From(DB.T_MID_ALERT) .LeftJoin(DB.BASDIC.As("A")).On(T_MID_ALERT.ITEMCODE == "A".Field("CODE")) .LeftJoin(DB.BASDIC.As("B")).On(T_MID_ALERT.SUBITEMCODE == "B".Field("CODE")) .LeftJoin(DB.T_BASE_COMPANY_PK.As("C")).On(T_MID_ALERT.PKID == "C".Field("ID")) .Where(where); List <dynamic> query = model.ExecToDynamicList(); // List<T_MID_ALERTModel> lis = SerializerHelper.Deserialize<List<T_MID_ALERTModel>>(SerializerHelper.Serialize(query)); DataRow dr = null; query.ForEach(d => { dr = dataTable.NewRow(); dr["PK_NAME"] = d["PK_NAME"]; dr["STAIN_TEXT"] = d["CODE_TEXT"] + "(" + d["CODE_TEXT2"] + ")"; dr["VALUE"] = d["VALUE"] == System.DBNull.Value ? 0: d["VALUE"]; dr["LIMIT"] = d["LIMIT"]; dr["STATE"] = d["STATE"] == 0 ? "未处理" : "处理"; dr["STARTTIME"] = d["STARTTIME"]; dr["ENDTIME"] = d["ENDTIME"]; dataTable.Rows.Add(dr); }); return(dataTable); }
protected override SqlModel GetSqlModel(RequestData data) { FieldModel where = BASLOG.LOGCONTENT.Like(data.Get("LogContent")); string logType = data.Get("LogType").Trim(); string opBegDate = data.Get("opBegDate").Trim(); string opEndDate = data.Get("opEndDate").Trim(); if (logType != "") { where &= BASLOG.LOGTYPECODE == logType; } if (opBegDate != "") { where &= BASLOG.OPERATETIME.ToCharDate() >= opBegDate; } if (opEndDate != "") { where &= BASLOG.OPERATETIME.ToCharDate() <= opEndDate + base.LastTime; } return(SqlModel.SelectAll(BASDIC.TITLE.As("LogTypeName"), BASUSER.TRUENAME.As("OperateUserName")) .From(DB.BASLOG) .LeftJoin(DB.BASDIC).On(BASDIC.CODE == BASLOG.LOGTYPECODE) .LeftJoin(DB.BASUSER).On(BASUSER.ID == BASLOG.OPERATEUSERID) .Where(where)); }
protected override SqlModel GetSqlModel(RequestData data) { FieldModel where = null; string areaCode = data.Get("AreaCode"); if (string.IsNullOrEmpty(areaCode) == false && areaCode.ToInt32() > 0 && areaCode != CurrentUser.SysAreaCode) { where = BASUSER.AREACODE == areaCode; } List <dynamic> filterRuleslist = Newtonsoft.Json.JsonConvert.DeserializeObject <List <dynamic> >(data.Get("filterRules")); if (filterRuleslist != null) { foreach (var item in filterRuleslist) { this.SetWhere(item, BASUSER.ID.Name, BASUSER.ID, ref where); this.SetWhere(item, BASUSER.USERNAME.Name, BASUSER.USERNAME, ref where); this.SetWhere(item, BASUSER.TRUENAME.Name, BASUSER.TRUENAME, ref where); this.SetWhere(item, BASORG.ORGNAME.Name, BASORG.ORGNAME, ref where); this.SetWhere(item, "UserTypeName", BASDIC.TITLE, ref where); this.SetWhere(item, BASUSER.REMARK.Name, BASUSER.REMARK, ref where); } } return(SqlModel.SelectAll(BASDIC.TITLE.As("UserTypeName"), T_SYS_AREA.AREA_TEXT.As("AREATEXT"), BASORG.ORGNAME) .From(DB.BASUSER) .LeftJoin(DB.BASORG).On(BASUSER.ORGID == BASORG.ID) //.LeftJoin(DB.T_COMPANY_INFO).On(BASUSER.TSNO == T_COMPANY_INFO.TSNO) .LeftJoin(DB.BASDIC).On(BASDIC.CODE == BASUSER.USERTYPEID & BASDIC.TYPECODE == ConstStrings.PowerType) .LeftJoin(DB.T_SYS_AREA).On(T_SYS_AREA.AREA_CODE == BASUSER.AREACODE) .Where(where).OrderByAsc(BASUSER.ID)); }
protected override SqlModel GetSqlModel(RequestData data) { FieldModel where = null; where &= T_BASE_COMPANY.ISDEL == "0"; string CompanyName = data.Get("CompanyName"); if (!string.IsNullOrEmpty(CompanyName)) { where &= T_BASE_COMPANY.NAME.Like(CompanyName); } //string UTYPE = data.Get("UTYPESEA"); //if (string.IsNullOrEmpty(UTYPE) == false) // where &= T_BAS_ANNOUNCEMENT_MANAGE.UTYPE == UTYPE; //if (string.IsNullOrEmpty(data.Get("sDate")) == false && string.IsNullOrEmpty(data.Get("eDate")) == false) //{ // string sDate = data.Get("sDate") + " 00:00:00"; // string eDate = data.Get("eDate") + " 23:59:59"; // where &= T_BAS_ANNOUNCEMENT_MANAGE.RELEASETIME.BetweenAnd(DateTime.Parse(sDate), DateTime.Parse(eDate)); //} SqlModel sql = SqlModel.SelectAll() .From(DB.T_BASE_COMPANY) //.LeftJoin(DB.BASDIC.As("d1")).On("d1".Field(BASDIC.CODE) == T_BAS_ANNOUNCEMENT_MANAGE.UTYPE & "d1".Field(BASDIC.TYPECODE) == "ANN_TYPE") //.LeftJoin(DB.BASUSER.As("d2")).On("d2".Field(BASUSER.USERNAME) == T_BAS_ANNOUNCEMENT_MANAGE.PUBLISHER) .Where(where).OrderByDesc(T_BASE_COMPANY.ID); return(sql); }
public ActionResult GetZLDeviceData(string id) { string page = Request["page"].Trim(); string rows = Request["rows"].Trim(); FieldModel where = T_BASE_COMPANY_ZL.ISDEL == "0"; if (!string.IsNullOrEmpty(id)) { id = id.Trim(); where &= T_BASE_COMPANY_ZL.COMPANYID == id; } else { where &= T_BASE_COMPANY_ZL.COMPANYID == "0"; } SqlModel sql = SqlModel.SelectAll(T_BASE_COMPANY_ZL.NAME.As("PKNAME") ) .From(DB.T_BASE_COMPANY_ZL) .LeftJoin(DB.T_BASE_COMPANY_PK).On(T_BASE_COMPANY_ZL.PKID == T_BASE_COMPANY_PK.ID) //.LeftJoin(DB.BASDIC.As("ISHB")).On(T_BASE_COMPANY_CONTACT.ISHB == "ISHB".Field("CODE") & "ISHB".Field("TYPECODE") == "TrueOrFalse") .Where(where) .OrderByDesc(T_BASE_COMPANY_ZL.CREATETIME); PagedDataTable dtResult = sql.ExecToPagedTable(Convert.ToInt32(page), Convert.ToInt32(rows), new OrderByModel() { OrderType = OrderType.Desc, FieldModel = T_BASE_COMPANY_ZL.CREATETIME }); return(Content(JsonConvert.SerializeObject(new { total = dtResult.TotalCount, rows = dtResult.Data }), "application/json", Encoding.UTF8)); }
// // GET: /ThePeakManager/LevelList/ protected override SqlModel GetSqlModel(RequestData data) { FieldModel where = null; List <dynamic> filterRuleslist = Newtonsoft.Json.JsonConvert.DeserializeObject <List <dynamic> >(data.Get("filterRules")); if (filterRuleslist != null) { foreach (var item in filterRuleslist) { this.SetWhere <T_THEPEAK_LEVEL_LIST_INFO>(item, new T_THEPEAK_LEVEL_LIST_INFO(), ref where); } } var sql = SqlModel.SelectAll( BASUSER.TRUENAME , "d1".Field(BASDIC.TITLE).As("PEAK_LEVEL_TEXT") , "d2".Field(BASDIC.TITLE).As("WAR_TYPE_TEXT") ) .From(DB.T_THEPEAK_LEVEL_LIST_INFO) .LeftJoin(DB.BASUSER).On(BASUSER.USERNAME == T_THEPEAK_LEVEL_LIST_INFO.ADD_USER) .LeftJoin(DB.BASDIC.As("d1")).On("d1".Field(BASDIC.CODE) == T_THEPEAK_LEVEL_LIST_INFO.PEAK_LEVEL & "d1".Field(BASDIC.TYPECODE) == ConstStrings.LevelType) .LeftJoin(DB.BASDIC.As("d2")).On("d2".Field(BASDIC.CODE) == T_THEPEAK_LEVEL_LIST_INFO.WAR_TYPE & "d2".Field(BASDIC.TYPECODE) == ConstStrings.EarlyWarning) .Where(where) ; return(sql); }
public ActionResult GetTXInfoInfoByID(RequestData data) { string rowID = string.Empty; var msg = new { success = false, data = "查询失败" }; if (!string.IsNullOrEmpty(data.Get("rowID"))) { rowID = data.Get("rowID").Trim(); } else { return(Json(msg)); } var dt = SqlModel.SelectAll(T_BASE_COMPANY_PK.TYPE.As("PKTYPE")) .From(DB.T_BASE_COMPANY_PK_TX) .InnerJoin(DB.T_BASE_COMPANY_PK).On(T_BASE_COMPANY_PK.ID == T_BASE_COMPANY_PK_TX.PKID) .Where(T_BASE_COMPANY_PK_TX.ID == rowID) .ExecToDataTable(); if (dt != null && dt.Rows.Count > 0) { msg = new { success = true, data = dt.ToJson() }; } return(Json(msg)); }
protected override SqlModel GetSqlModel(RequestData data) { string typeId = data.Get("typeId"); if (string.IsNullOrEmpty(typeId) == true) { typeId = "0"; } FieldModel where = BASDIC.TYPEID == typeId; List <dynamic> filterRuleslist = Newtonsoft.Json.JsonConvert.DeserializeObject <List <dynamic> >(data.Get("filterRules")); if (filterRuleslist != null) { foreach (var item in filterRuleslist) { this.SetWhere(item, BASDIC.ID.Name, BASDIC.ID, ref where); this.SetWhere(item, BASDIC.TITLE.Name, BASDIC.TITLE, ref where); this.SetWhere(item, BASDIC.CODE.Name, BASDIC.CODE, ref where); this.SetWhere(item, BASDIC.SORTNO.Name, BASDIC.SORTNO, ref where); this.SetWhere(item, BASDIC.STATUS.Name, BASDIC.STATUS, ref where); this.SetWhere(item, BASDIC.REMARK.Name, BASDIC.REMARK, ref where); } } SqlModel model = SqlModel.SelectAll().From(DB.BASDIC) .Where(where) .OrderByAsc(BASDIC.SORTNO); return(model); }
// // GET: /Bas/SmsTemplate/ protected override SqlModel GetSqlModel(RequestData data) { FieldModel where = null; string TEMPNAME = data.Get("NAME").Trim(); string SMSTEMPTYPE = data.Get("TEMPTYPE").Trim(); //string SMSBASTYPE = data.Get("BASTYPE").Trim(); string opBegDate = data.Get("opBegDate").Trim(); string opEndDate = data.Get("opEndDate").Trim(); if (TEMPNAME != "") { where &= SMSTEMPLATE.TEMPNAME.Like(TEMPNAME); } if (SMSTEMPTYPE != "") { where &= SMSTEMPLATE.SMSTEMPTYPE == SMSTEMPTYPE; } //if (SMSBASTYPE != "") //{ // where &= SMSTEMPLATE.SMSBASTYPE == SMSBASTYPE; //} SqlModel SqlModel = SqlModel.SelectAll(BASDIC.TITLE.As("SMSTEMPTYPE_TEXT"), "D1".Field("TITLE").As("SMSBASTYPE_TEXT"), "T1".Field("TRUENAME").As("CREATENAMEREAL")) .From(DB.SMSTEMPLATE) .LeftJoin(DB.BASDIC).On(SMSTEMPLATE.SMSTEMPTYPE == BASDIC.CODE & BASDIC.TYPECODE == "SMSTEMPTYPE") .LeftJoin(DB.BASDIC.As("D1")).On(SMSTEMPLATE.SMSBASTYPE == "D1".Field("CODE") & "D1".Field("TYPECODE") == "SMSBASTYPE") .LeftJoin(DB.BASUSER.As("T1")).On(SMSTEMPLATE.CREATEUSER == "T1".Field("USERNAME")) .Where(where).OrderByDesc(SMSTEMPLATE.CREATETIME); return(SqlModel); }
public ActionResult GetButtonTable(RequestData data) { List <dynamic> list = SqlModel.SelectAll().From(DB.BASBUTTON) .OrderByAsc(BASBUTTON.SORTNO).ExecToDynamicList(); return(Json(list)); }
/// <summary> /// 文件信息保存 /// </summary> /// <param name="context"></param> /// <returns></returns> private void FileInfoSavle(HttpContext context) { string fileInfoListStr = context.Request.Form["FileInfoList"]; string sorceID = context.Request.Form["SOURCE_ID"]; string sorceType = context.Request.Form["SOURCE_TYPE"]; string sorceField = context.Request.Form["SOURCE_FIELD"]; List <T_SYS_ATTACHModel> modelList = SerializerHelper.Deserialize <List <T_SYS_ATTACHModel> >(fileInfoListStr); var sql = SqlModel.SelectAll().From(DB.T_SYS_ATTACH).Where(T_SYS_ATTACH.SOURCE_ID == sorceID & T_SYS_ATTACH.SOURCE_TYPE == sorceType & T_SYS_ATTACH.SOURCE_FIELD == sorceField); var existAttachList = sql.ExecToDynamicList(); List <string> keepFileIDList = new List <string>();//保留的文件信息ID modelList.ForEach(model => { bool isKeep = existAttachList.Exists(c => StringHelper.DynamicToString(c["ID"]) == StringHelper.DynamicToString(model.ID)); if (isKeep) { keepFileIDList.Add(model.ID.ToString()); } else { model.SOURCE_ID = sorceID; model.SOURCE_TYPE = sorceType; model.SOURCE_FIELD = sorceField; model.Insert(); } }); //删除过时的文件信息 T_SYS_ATTACHModel deleteModel = new T_SYS_ATTACHModel(); existAttachList.ForEach(attach => { if (!keepFileIDList.Contains(StringHelper.DynamicToString(attach["ID"]))) { deleteModel.Delete(T_SYS_ATTACH.ID == attach["ID"]); } }); }
/// <summary> /// 治理设施停运 /// </summary> /// <param name="data"></param> /// <returns></returns> private DataTable GetControlFacilitiesSource(RequestData data, DataTable dataTable) { FieldModel where = null; if (data.Get("CompanyID") != "-1") { where &= T_MID_ALERT.COMPANYID == data.Get("CompanyID"); } else { where &= T_MID_ALERT.PKID == data.Get("PKID"); } where &= T_MID_ALERT.TYPE == 3; List <dynamic> query = SqlModel.SelectAll("A".Field("TITLE").As("CODE_TEXT"), "B".Field("TITLE").As("CODE_TEXT2"), "C".Field("NAME").As("PK_NAME")).From(DB.T_MID_ALERT) .LeftJoin(DB.BASDIC.As("A")).On(T_MID_ALERT.ITEMCODE == "A".Field("CODE")) .LeftJoin(DB.BASDIC.As("B")).On(T_MID_ALERT.SUBITEMCODE == "B".Field("CODE")) .LeftJoin(DB.T_BASE_COMPANY_PK.As("C")).On(T_MID_ALERT.PKID == "C".Field("ID") | T_MID_ALERT.COMPANYID == "C".Field("COMPANYID")) .Where(where) .ExecToDynamicList(); // List<T_MID_ALERTModel> lis = SerializerHelper.Deserialize<List<T_MID_ALERTModel>>(SerializerHelper.Serialize(query)); DataRow dr = null; query.ForEach(d => { dr = dataTable.NewRow(); dr["PK_NAME"] = d["PK_NAME"]; // dr["STAIN_TEXT"] = d["PK_NAME"] ; dr["STATE"] = d["STATE"] == 0 ? "未处理" : "处理"; dr["STARTTIME"] = d["STARTTIME"]; dr["ENDTIME"] = d["ENDTIME"]; dr["LENTIME"] = new TimeSpan(Convert.ToDateTime(d["STARTTIME"]) - Convert.ToDateTime(d["ENDTIME"])).TotalMinutes; dataTable.Rows.Add(dr); }); return(dataTable); }
public ActionResult GetDataType(RequestData data) { dynamic row = SqlModel.SelectAll().From(DB.BASDICTYPE) .Where(BASDICTYPE.ID == data.Get("id")).ExecToDynamic(); return(Json(row)); }
/// <summary> /// 获取区域的企业 /// </summary> /// <param name="areaCode"></param> /// <returns></returns> private static List <dynamic> GetCompanyInfo(string areaCode) { SqlModel sql = SqlModel.SelectAll() .From(DB.T_BASE_COMPANY) .Where(T_BASE_COMPANY.AREA.In(StringHelper.SqlInCondition(areaCode))); return(sql.ExecToDynamicList()); }
protected override SqlModel GetSqlModel(RequestData data) { SqlModel model = SqlModel.SelectAll(BASNAV.PARENTID.As("\"_parentId\"")) .From(DB.BASNAV) .OrderByAsc(BASNAV.SORTNO); return(model); }
protected override bool DoEdit(RequestData data) { bool result = true; try { decimal levelID = decimal.Parse(data.Get("id")); T_THEPEAK_LEVEL_LIST_INFOModel model = new T_THEPEAK_LEVEL_LIST_INFOModel(); this.GetModelValue(model, data); result = model.Update(T_THEPEAK_LEVEL_LIST_INFO.ID == levelID); var configSql = SqlModel.SelectAll().From(DB.T_THEPEAK_LEVEL_CONFIG).Where(T_THEPEAK_LEVEL_CONFIG.PEAK_LEVE_ID == levelID); var configList = configSql.ExecToDynamicList(); List <T_THEPEAK_LEVEL_CONFIGModel> listExit = data.Get("extraData").Deserialize <List <T_THEPEAK_LEVEL_CONFIGModel> >(); T_THEPEAK_LEVEL_CONFIGModel configModel = new T_THEPEAK_LEVEL_CONFIGModel(); List <decimal> configDelList = new List <decimal>(); //信息保存 if (listExit != null && listExit.Count > 0) { foreach (var item in listExit) { bool exit = configList.FindIndex(c => StringHelper.DynamicToString(c["ID"]) == StringHelper.DynamicToString(item.ID)) > -1 ? true : false; if (item.IS_STOP != 1 && item.LIMIT_CONFIG != 1) { continue; //没用的配置信息,删除处理 } //添加 if (!exit) { item.PEAK_LEVE_ID = levelID; item.Insert(); } //更新 else { item.Update(T_THEPEAK_LEVEL_CONFIG.ID == item.ID); } configDelList.Add(item.ID); } //删除子表 foreach (var delKey in configList) { if (!configDelList.Contains(decimal.Parse(delKey["ID"].ToString()))) { configModel.Delete(T_THEPEAK_LEVEL_CONFIG.ID == decimal.Parse(delKey["ID"].ToString())); } } } FileUploadHandle.FileMessageSave(data, levelID.ToString()); } catch (Exception ex) { result = false; base.AddLog(null, LogType.InsertOperate, "【编辑错峰等级配置】 " + ex.Message + ex.StackTrace); } return(result); }
/// <summary> /// 获取警告次数 /// </summary> /// <param name="type"></param> /// <returns></returns> private int GetWarnTimes(string type) { FieldModel where = null; where &= T_MID_ALERT.TYPE == type; return(SqlModel.SelectAll() .From(DB.T_MID_ALERT) .Where(where) .ExecToDynamicList().Count); }
public ActionResult GetLevelConfigData(RequestData data) { SqlModel sql = SqlModel.SelectAll( "d1".Field("TITLE").As("PEAK_LEVEL_TEXT") , "d2".Field("TITLE").As("WAR_TYPE_TEXT")) .From(DB.T_THEPEAK_LEVEL_LIST_INFO) // .LeftJoin(DB.T_SYS_AREA).On(T_BASE_COMPANY.AREA== T_SYS_AREA.AREA_CODE) .LeftJoin(DB.BASDIC.As("d1")).On(T_THEPEAK_LEVEL_LIST_INFO.PEAK_LEVEL == "d1".Field("CODE") & "d1".Field("TYPECODE") == ConstStrings.LevelType) .LeftJoin(DB.BASDIC.As("d2")).On(T_THEPEAK_LEVEL_LIST_INFO.WAR_TYPE == "d2".Field("CODE") & "d2".Field("TYPECODE") == ConstStrings.WarType); return(base.PagedJson(sql, data)); }
private string GetNavJson(int userId) { object ret = SqlModel.Select(BASUSER.ISADMIN).From(DB.BASUSER).Where(BASUSER.ID == userId).ExecuteScalar(); bool isAdmin = ret != null && ret.ToBoolean(); DataTable navTab = SqlModel.SelectAll().From(DB.BASNAV) .Where(BASNAV.ISVISIBLE == 1).ExecToDataTable(); DataTable urTab = SqlModel.Select(BASUSERROLE.ROLEID).From(DB.BASUSERROLE).Where(BASUSERROLE.USERID == userId).ExecToDataTable(); string roleIdStr = urTab.Join((r, i) => (i > 0 ? "," : "") + r[BASUSERROLE.ROLEID.Name]); DataTable rTable = base.GetRightTable(roleIdStr, userId); JArray list = this.GetNavList(isAdmin, navTab, rTable, 0); return(list.ToString()); }
protected override bool DoAdd(RequestData data) { DataRowModel rmodel = SqlModel.SelectAll().From(DB.BASDICTYPE).Where(BASDICTYPE.ID == data.Get("TypeId")).ExecToRowModel(); BASDICModel model = new BASDICModel(); model.TITLE = data.Get("Title"); model.CODE = data.Get("Code"); model.TYPEID = data.Get("TypeId").ToInt32(); model.TYPECODE = rmodel[BASDICTYPE.CODE] == null ? "" : rmodel[BASDICTYPE.CODE].ToString(); model.SORTNO = data.Get("SortNo").ToInt32(); model.STATUS = data.Get("Status").ToInt32(); model.REMARK = data.Get("Remark"); return(model.Insert()); }
/// <summary> /// 获取排口下的监控设备 /// </summary> /// <param name="data"></param> /// <returns></returns> private List <dynamic> GetMonitor(RequestData data) { FieldModel where = null; if (data.Get("CompanyID") != "-1") { where &= T_BASE_COMPANY_MONITOR.COMPANYID == data.Get("CompanyID"); } else { where &= T_BASE_COMPANY_MONITOR.PKID == data.Get("PKID"); } return(SqlModel.SelectAll() .From(DB.T_BASE_COMPANY_MONITOR) .Where(where) .ExecToDynamicList()); }
/// <summary> /// 获取需要巡查的企业 /// </summary> /// <returns></returns> private dynamic GetXunCha(int peakId) { FieldModel where = null; where &= T_THEPEAK_ENT_SUB_LIST.THEPEAKID == peakId; where &= T_THEPEAK_ENT_SUB_LIST.IS_PATROL == 1; SqlModel sql = SqlModel.SelectAll( T_SYS_AREA.AREA_TEXT.As("AREA_TEXT") , "d1".Field("TITLE").As("INDUSTRY_TYPE_TEXT") // , "d2".Field("TITLE").As("POLLUTION_TYPE_TEXT") // , "d3".Field(T_BAS_AIR_MONITOR.MONITOR_ITEM_NAME).As("POLLUTION_ITEM_TEXT") // , "d4".Field("TITLE").As("COMPANY_STATE_TEXT") , T_THEPEAK_ENT_SUB_LIST.ID.As("ENTSUBID") , T_THEPEAK_LEVEL_LIST_INFO.ID.As("LEVEL_ID") , T_THEPEAK_ENT_SUB_LIST.ENT_PEAK_TYPE , T_THEPEAK_ENT_SUB_LIST.THEPEAKID , T_THEPEAK_ENT_SUB_LIST.IS_SELECT , T_THEPEAK_MAIN_LIST_INFO.PEAK_THEME , T_THEPEAK_MAIN_LIST_INFO.START_TIME , T_THEPEAK_MAIN_LIST_INFO.END_TIME , T_THEPEAK_MAIN_LIST_INFO.PEAK_DESC , T_BASE_COMPANY.AREA , T_BASE_COMPANY.ID.As("COMPANY_ID") , "d6".Field("TITLE").As("PEAK_LEVEL_TEXT") //, "d7".Field(BASUSER.TRUENAME).As("TOWN_SUPERVISOR_TEXT") // , "d8".Field(BASUSER.TRUENAME).As("INDUSTRY_SUPERVISOR_TEXT") , "d9".Field(BASUSER.TRUENAME).As("SUPERVISOR_TEXT") ) .From(DB.T_BASE_COMPANY) .LeftJoin(DB.T_SYS_AREA).On(T_BASE_COMPANY.AREA == T_SYS_AREA.AREA_CODE) .LeftJoin(DB.BASDIC.As("d1")).On(T_BASE_COMPANY.BASTYPE == "d1".Field("CODE") & "d1".Field("TYPECODE") == ConstStrings.IndustryType) // .LeftJoin(DB.BASDIC.As("d2")).On(T_BASE_COMPANY.typ.POLLUTION_TYPE == "d2".Field("CODE") & "d2".Field("TYPECODE") == ConstStrings.PollutionType) //.LeftJoin(DB.T_BAS_AIR_MONITOR.As("d3")).On(T_BASE_COMPANY.POLLUTION_ITEM == "d3".Field(T_BAS_AIR_MONITOR.MONITOR_ITEM_CODE)) //.LeftJoin(DB.BASDIC.As("d4")).On(T_BASE_COMPANY.COMPANY_STATE == "d4".Field("CODE") & "d4".Field("TYPECODE") == ConstStrings.Company_State) //.LeftJoin(DB.BASDIC.As("d5")).On(T_BASE_COMPANY.FUEL_TYPE == "d5".Field("CODE") & "d5".Field("TYPECODE") == ConstStrings.FuelType) .LeftJoin(DB.T_THEPEAK_LEVEL_CONFIG).On(T_THEPEAK_LEVEL_CONFIG.COMPANY_ID == T_BASE_COMPANY.ID) .LeftJoin(DB.T_THEPEAK_LEVEL_LIST_INFO).On(T_THEPEAK_LEVEL_LIST_INFO.ID == T_THEPEAK_LEVEL_CONFIG.PEAK_LEVE_ID) .LeftJoin(DB.T_THEPEAK_ENT_SUB_LIST).On(T_THEPEAK_ENT_SUB_LIST.COMPANY_ID == T_BASE_COMPANY.ID & T_THEPEAK_LEVEL_LIST_INFO.ID == T_THEPEAK_ENT_SUB_LIST.LEVEL_ID)//& T_THEPEAK_ENT_SUB_LIST.GUID == entGuid .LeftJoin(DB.T_THEPEAK_MAIN_LIST_INFO).On(T_THEPEAK_MAIN_LIST_INFO.ID == T_THEPEAK_ENT_SUB_LIST.THEPEAKID) .LeftJoin(DB.BASDIC.As("d6")).On(T_THEPEAK_LEVEL_LIST_INFO.PEAK_LEVEL == "d6".Field("CODE") & "d6".Field("TYPECODE") == ConstStrings.LevelType & T_THEPEAK_LEVEL_LIST_INFO.ID == T_THEPEAK_ENT_SUB_LIST.LEVEL_ID) // .LeftJoin(DB.BASUSER.As("d7")).On(T_BASE_COMPANY.SUPERVISOR == "d7".Field(BASUSER.USERNAME)) // .LeftJoin(DB.BASUSER.As("d8")).On(T_BASE_COMPANY.INDUSTRY_SUPERVISOR == "d8".Field(BASUSER.USERNAME)) .LeftJoin(DB.BASUSER.As("d9")).On(T_BASE_COMPANY.SUPERVISOR == "d9".Field(BASUSER.USERNAME)) .Where(where); return(sql.ExecToDynamicList()); }
/// <summary> /// 获取自动生成编号[默认后面4位自增流水,可重载] /// </summary> /// <param name="tran"></param> /// <param name="prefix">标识符</param> /// <param name="format">格式</param> /// <param name="custom">自定义数据</param> /// <returns></returns> protected string GetFormNo(string prefix, string format, string custom) { try { DateTime now = DateTime.Now; string curDateYMD = now.ToString(format); int curSNValue = 0; DataRowModel r = SqlModel.SelectAll().From(DB.BASFORMNO) .Where(BASFORMNO.PREFIX == prefix & BASFORMNO.RULEVALUE == curDateYMD).ExecToRowModel(); //如果没有数据,则先添加一条初始数据 if (r == null || r.Count == 0) { curSNValue = 1; BASFORMNOModel fnModel = new BASFORMNOModel(); fnModel.PREFIX = prefix; fnModel.RULENAME = format;// "yyyyMMdd"; fnModel.RULEVALUE = now.ToString(fnModel.RULENAME); fnModel.SNBIT = 4; fnModel.SNVALUE = curSNValue; //fnModel.TSNO = tsno; fnModel.Insert(); //fnModel.Inserting(tran); } else { curSNValue = r[BASFORMNO.SNVALUE].ToInt32() + 1; BASFORMNOModel fModel = new BASFORMNOModel(); fModel.SNVALUE = curSNValue; fModel.Update(BASFORMNO.ID == r[BASFORMNO.ID].ToInt32()); //fModel.Updating(tran, BASFORMNO.ID == r[BASFORMNO.ID].ToInt32()); } string billNumber = string.Format("{0}{1}{2}" , curDateYMD , custom , curSNValue.ToString().PadLeft(4, '0')); return(billNumber); } catch (Exception ex) { throw ex; } }
public static void FileMessageSave(RequestData data, string sorceID) { string attachStr = string.Format("[{0}]", data.Get("attach")); var list = SerializerHelper.Deserialize <List <List <T_SYS_ATTACHModel> > >(attachStr); List <T_SYS_ATTACHModel> attachList = new List <T_SYS_ATTACHModel>(); foreach (var childList in list) { attachList.AddRange(childList); } string sourceMsg = string.Format("[{0}]", data.Get("source"));//只有SOURCE_TYPE、SOURCE_FIELD var sourceList = SerializerHelper.Deserialize <List <T_SYS_ATTACHModel> >(sourceMsg); foreach (T_SYS_ATTACHModel source in sourceList) { var oneSource = attachList.Where(item => item.SOURCE_TYPE == source.SOURCE_TYPE && item.SOURCE_FIELD == source.SOURCE_FIELD); string sorceType = source.SOURCE_TYPE; string sorceField = source.SOURCE_FIELD; List <T_SYS_ATTACHModel> modelList = oneSource != null?oneSource.ToList() : new List <T_SYS_ATTACHModel>(); var sql = SqlModel.SelectAll().From(DB.T_SYS_ATTACH).Where(T_SYS_ATTACH.SOURCE_ID == sorceID & T_SYS_ATTACH.SOURCE_TYPE == sorceType & T_SYS_ATTACH.SOURCE_FIELD == sorceField); var existAttachList = sql.ExecToDynamicList(); List <string> keepFileIDList = new List <string>();//保留的文件信息ID modelList.ForEach(model => { bool isKeep = existAttachList.Exists(c => StringHelper.DynamicToString(c["ID"]) == StringHelper.DynamicToString(model.ID)); if (isKeep) { keepFileIDList.Add(model.ID.ToString()); } else { model.SOURCE_ID = sorceID; model.Insert(); } }); //删除过时的文件信息 T_SYS_ATTACHModel deleteModel = new T_SYS_ATTACHModel(); existAttachList.ForEach(attach => { if (!keepFileIDList.Contains(StringHelper.DynamicToString(attach["ID"]))) { deleteModel.Delete(T_SYS_ATTACH.ID == attach["ID"]); } }); } }
/// <summary> /// 获取排口下的治理设施 /// </summary> /// <param name="data"></param> /// <returns></returns> private List <dynamic> GetGovernance(RequestData data) { // string pkId = queryPkId;// data.Get("PKID"); FieldModel where = null; if (data.Get("CompanyID") != "-1") { where &= T_BASE_COMPANY_ZL.COMPANYID == data.Get("CompanyID"); } else { where &= T_BASE_COMPANY_ZL.PKID == data.Get("PKID"); } return(SqlModel.SelectAll() .From(DB.T_BASE_COMPANY_ZL) .Where(where) .ExecToDynamicList()); }
public ActionResult GetLastAlertByPK(string pkid) { DateTime stime = DateTime.Now.AddDays(-7); DateTime etime = DateTime.Now; FieldModel where = T_MID_ALERT.STARTTIME.BetweenAnd(stime, etime); where &= T_MID_ALERT.PKID == pkid; var model = SqlModel.SelectAll() .From(DB.T_MID_ALERT) .Where(where) .OrderByDesc(T_MID_ALERT.STARTTIME); var resultObj = model.ExecToDynamic(); return(Json(resultObj)); }
public ActionResult Login(RequestData data) { LangHelper.Name = "zhcn"; if (string.IsNullOrEmpty(data.Get("lang")) == false) { LangHelper.Name = data.Get("lang"); } LangHelper.Instance.Read(base.Request, true); base.Response.ContentType = "text/plain"; var userName = data.Get("username"); var password = data.Get("password"); var validateCode = data.Get("validateCode"); var saveCookieDays = data.GetInt("savedays"); var msg = new { success = false, message = "用户名不存在!" }; SqlModel model = SqlModel.SelectAll().From(DB.BASUSER).Where(BASUSER.USERNAME == userName); DataRowModel uModel = model.ExecToRowModel(); if (uModel != null) { if (uModel[BASUSER.ISDISABLED].ToInt32() == 1) { bool flag = CurrentUser.Login(userName, password); if (flag == true) { msg = new { success = true, message = "登录成功!" }; DataInitor.Log = new LogData(); base.AddLog(LogType.UserLogin, "用户登录成功"); } else { msg = new { success = false, message = "用户名或密码输入错误!" }; } } else { msg = new { success = false, message = "用户已经被禁用,请联系管理员!" }; } } return(Json(msg)); }
protected override SqlModel GetSqlModel(RequestData data) { FieldModel where = null; string peakType = data.Get("PEAK_TYPE").Trim(); string peakTheme = data.Get("PEAK_THEME").Trim(); string downTimeStart = data.Get("DOWN_TIME_STRAT").Trim(); string downTimeEnd = data.Get("DOWN_TIME_END").Trim(); if (!string.IsNullOrEmpty(peakType)) { where &= T_THEPEAK_MAIN_LIST_INFO.PEAK_TYPE == peakType; } if (!string.IsNullOrEmpty(peakTheme)) { where &= T_THEPEAK_MAIN_LIST_INFO.PEAK_THEME.Like(peakTheme); } if (!string.IsNullOrEmpty(downTimeStart)) { where &= T_THEPEAK_MAIN_LIST_INFO.DOWN_TIME >= DateTime.Parse(downTimeStart); } if (!string.IsNullOrEmpty(downTimeEnd)) { where &= T_THEPEAK_MAIN_LIST_INFO.DOWN_TIME <= DateTime.Parse(downTimeEnd); } where &= T_THEPEAK_MAIN_LIST_INFO.PLAN_TYPE == 0; where &= T_THEPEAK_MAIN_LIST_INFO.IS_CLOSE == 0; var sql = SqlModel.SelectAll( "d1".Field(BASDIC.TITLE).As("PEAK_LEVEL_TEXT") , "d2".Field(BASDIC.TITLE).As("WAR_TYPE_TEXT") , "d3".Field(BASDIC.TITLE).As("PEAK_TYPE_TEXT") , T_THEPEAK_LEVEL_LIST_INFO.ID.As("LEVEL_ID") ).From(DB.T_THEPEAK_MAIN_LIST_INFO) .LeftJoin(DB.T_THEPEAK_LEVEL_LIST_INFO).On(T_THEPEAK_LEVEL_LIST_INFO.PEAK_LEVEL == T_THEPEAK_MAIN_LIST_INFO.PEAK_LEVEL) .LeftJoin(DB.BASDIC.As("d1")).On("d1".Field(BASDIC.CODE) == T_THEPEAK_MAIN_LIST_INFO.PEAK_LEVEL & "d1".Field(BASDIC.TYPECODE) == ConstStrings.LevelType) .LeftJoin(DB.BASDIC.As("d2")).On("d2".Field(BASDIC.CODE) == T_THEPEAK_MAIN_LIST_INFO.WAR_TYPE & "d2".Field(BASDIC.TYPECODE) == ConstStrings.EarlyWarning) .LeftJoin(DB.BASDIC.As("d3")).On("d3".Field(BASDIC.CODE) == T_THEPEAK_MAIN_LIST_INFO.PEAK_TYPE & "d3".Field(BASDIC.TYPECODE) == ConstStrings.EmergencyType) .Where(where) ; return(sql); }
public static bool Login(string userName, string password) { if (string.IsNullOrEmpty(userName) || string.IsNullOrEmpty(password)) { return(false); } DataTable udt = SqlModel.SelectAll(T_SYS_AREA.AREA_TEXT.As("AREATEXT"), T_SYS_AREA.LICENSE_PLATE_PREFIX.As("PLATEPREFIX")).From(DB.BASUSER) .LeftJoin(DB.T_SYS_AREA).On(BASUSER.AREACODE == T_SYS_AREA.AREA_CODE) .Where(BASUSER.USERNAME == userName).ExecToDataTable(); if (udt == null || udt.Rows.Count <= 0) { return(false); } string pwd = StringHelper.MD5String(password); if (udt.Rows[0]["PASSWORD"].ToString().Equals(pwd, StringComparison.OrdinalIgnoreCase)) { CurrentUser.Id = udt.Rows[0]["ID"].ToInt32(); CurrentUser.UserName = udt.Rows[0]["USERNAME"].ToString(); CurrentUser.UserTrueName = udt.Rows[0]["TRUENAME"].ToString(); CurrentUser.ConfigJson = udt.Rows[0]["CONFIGJSON"].ToString(); CurrentUser.Orgid = udt.Rows[0]["ORGID"].ToString(); CurrentUser.UserTypeID = udt.Rows[0]["USERTYPEID"].ToString(); CurrentUser.AreaCode = udt.Rows[0]["AREACODE"].ToString(); try { CurrentUser.SysAreaCode = SqlModel.Select(BASDIC.CODE).From(DB.BASDIC).Where(BASDIC.TITLE == "SysAreaCode").ExecuteScalar().ToString(); } catch (Exception) { } udt.Columns.Remove(udt.Columns["PASSWORD"]);//移除密码不显示在界面缓存中 CurrentUser.UserJson = JsonConvert.SerializeObject(udt.Rows[0].ToDynamic()); return(true); } return(false); }