/// <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);
}
