/// <summary>
/// 设置风险预控规则
/// </summary>
/// <returns></returns>
public ActionResult SetRole()
{
var bll = new DataItemDetailBLL();
DataItemDetailEntity entity = bll.GetEntity("szfxykgz");
return(View(entity));
}
public ActionResult SaveDetailForm(string keyValue, string itemCode, DataItemDetailEntity entity)
{
var data = dataItemIBLL.GetClassifyEntityByCode(itemCode);
entity.F_ItemId = data.F_ItemId;
dataItemIBLL.SaveDetailEntity(keyValue, entity);
return(Success("保存成功！"));
}
/// <summary>
/// 保存表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="entity">实体对象</param>
/// <returns></returns>
public void SaveForm(string keyValue, DataItemDetailEntity entity)
{
try
{
service.SaveForm(keyValue, entity);
}
catch (Exception)
{
throw;
}
}
public object GetPatrolProjectList([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
//获取用户Id
string userId = dy.userid;
OperatorProvider.AppUserId = userId; //设置当前用户
Operator curUser = OperatorProvider.Provider.Current();
if (null == curUser)
{
return(new { code = -1, count = 0, info = "请求失败,请登录!" });
}
//获取页数和条数
int page = Convert.ToInt32(dy.data.pageNum), rows = Convert.ToInt32(dy.data.pageSize);
Pagination pagination = new Pagination();
pagination.p_kid = "ID";
pagination.p_fields = "CreateDate,MeasureName,MeasureResultOne,MeasureResultTwo,OrderNumber";
pagination.p_tablename = " bis_highprojectset";
pagination.conditionJson = "1=1 ";
pagination.page = page; //页数
pagination.rows = rows; //行数
pagination.sidx = "createdate"; //排序字段
pagination.sord = "desc"; //排序方式
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
if (!user.IsSystem)
{
pagination.conditionJson += " and createuserorgcode='" + user.OrganizeCode + "'";
}
string ehsDepartCode = "";
//当前用户
//Operator curUser = OperatorProvider.Provider.Current();
//获取日常巡查ID
DataItemDetailEntity entity = dataitemdetailbll.GetListByItemCodeEntity("EverydayPatrol");
if (entity != null)
{
ehsDepartCode = entity.ItemValue;
}
//string Code = dy.data.Code;
JObject queryJson = new JObject();
queryJson.Add(new JProperty("code", ehsDepartCode));
DataTable dt = highprojectsetbll.GetPageDataTable(pagination, queryJson.ToString());
return(new { code = 0, info = "获取数据成功", count = pagination.records, data = dt });
}
catch (Exception ex)
{
return(new { code = -1, info = ex.Message, count = 0 });
}
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
try
{
service.SaveForm(keyValue, dataItemDetailEntity);
CacheFactory.Cache().RemoveCache(cacheKey);
}
catch (Exception)
{
throw;
}
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveDataItemDetail(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
dataItemDetailEntity.Modify(keyValue);
o.BllSession.DataItemDetailBll.Update(dataItemDetailEntity);
}
else
{
dataItemDetailEntity.Create();
o.BllSession.DataItemDetailBll.Insert(dataItemDetailEntity);
}
}
/// <summary>
/// 数据字典查找Value
/// </summary>
/// <param name="dataItemList">数据字典数据</param>
/// <param name="itemName">项目名</param>
/// <param name="colName">列名</param>
/// <returns></returns>
private string FindDataItemValue(List <DataItemDetailEntity> dataItemList, string itemName, string colName)
{
DataItemDetailEntity dataItem = dataItemList.Find(t => t.F_ItemName == itemName);
if (dataItem != null)
{
return(dataItem.F_ItemValue);
}
else
{
throw (new Exception("【" + colName + "】数据字典找不到对应值"));
}
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
try
{
dataItemDetailEntity.SimpleSpelling = Str.PinYin(dataItemDetailEntity.ItemName);
service.SaveForm(keyValue, dataItemDetailEntity);
CacheFactory.Cache().RemoveCache(cacheKey);
}
catch (Exception)
{
throw;
}
}
public ActionResult SaveRole(DataItemDetailEntity entity)
{
try
{
var bll = new DataItemDetailBLL();
bll.SaveOrUpdateRole("szfxykgz", entity);
return(Success("操作成功"));
}
catch (Exception ex)
{
return(Error("操作失败：" + ex.Message));
}
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveDataItemDetail(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
dataItemDetailEntity.Modify(keyValue);
int res = this.BaseRepository().Update <DataItemDetailEntity>(dataItemDetailEntity);
}
else
{
dataItemDetailEntity.Create();
int res = this.BaseRepository().Insert <DataItemDetailEntity>(dataItemDetailEntity);
}
}
public ActionResult SaveWarningForm()
{
string keyValue = Request.Form["keyValue"].ToString();
string s1 = Request.Form["s1"].ToString();
string s2 = Request.Form["s2"].ToString();
string s3 = Request.Form["s3"].ToString();
string s4 = Request.Form["s4"].ToString();
string description = s4 + "|" + s3 + "|" + s2 + "|" + s1;
DataItemDetailEntity entity = dataitemdetailbll.GetEntity(keyValue);
entity.ItemValue = description;
dataitemdetailbll.SaveForm(keyValue, entity);
return(Success("保存成功!"));
}
/// <summary>
/// 根据字典详细信息ID获取字典实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public DataItemDetailEntity GetDataItemEntityById(string id)
{
if (!string.IsNullOrEmpty(id))
{
DataItemDetailEntity entity = CacheFactory.Cache().GetCache <DataItemDetailEntity>("__" + id + "__");
if (entity == null)
{
entity = busines.GetEntityById(id);
CacheFactory.Cache().WriteCache(entity, "__" + id + "__");
}
return(entity);
}
return(default(DataItemDetailEntity));
}
public ActionResult GetStatus()
{
List <DataItemDetailEntity> ddlist = new List <DataItemDetailEntity>();
DataItemDetailEntity d1 = new DataItemDetailEntity();
d1.ItemName = "正常";
d1.ItemValue = "0";
DataItemDetailEntity d2 = new DataItemDetailEntity();
d2.ItemName = "异常";
d2.ItemValue = "1";
ddlist.Add(d1);
ddlist.Add(d2);
return(Content(ddlist.ToJson()));
}
public ActionResult GetWlType()
{
List <DataItemDetailEntity> ddlist = new List <DataItemDetailEntity>();
DataItemDetailEntity d1 = new DataItemDetailEntity();
d1.ItemName = "提货";
d1.ItemValue = "提货";
DataItemDetailEntity d2 = new DataItemDetailEntity();
d2.ItemName = "转运";
d2.ItemValue = "转运";
ddlist.Add(d1);
ddlist.Add(d2);
return(Content(ddlist.ToJson()));
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveForm(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
if (!string.IsNullOrEmpty(keyValue))
{
dataItemDetailEntity.Modify(keyValue);
Base_DataItemDetail detail = Base_DataItemDetail.SingleOrDefault("where ItemDetailId=@0", keyValue);
detail = EntityConvertTools.CopyToModel <DataItemDetailEntity, Base_DataItemDetail>(dataItemDetailEntity, detail);
detail.ItemDetailId = keyValue;
detail.Update();
}
else
{
dataItemDetailEntity.Create();
Base_DataItemDetail detail = EntityConvertTools.CopyToModel <DataItemDetailEntity, Base_DataItemDetail>(dataItemDetailEntity, null);
detail.Insert();
}
}
public JsonResult SaveSetting(DataItemDetailEntity model)
{
var success = true;
var message = "保存成功";
try
{
var setting = new DataItemDetailBLL().GetDetail("人身风险预控", "人身风险预控关联工作任务状态");
var bll = new DataItemDetailBLL();
setting.ItemValue = model.ItemValue;
bll.SaveForm(setting.ItemDetailId, setting);
}
catch (Exception ex)
{
success = false;
message = ex.Message;
}
return(Json(new AjaxResult {
type = success ? ResultType.success : ResultType.error, message = HttpUtility.JavaScriptStringEncode(message)
}));
}
public ActionResult Form()
{
//ViewBag.ItemDetailValue = "";
////获取日常巡查ID
//DataItemDetailEntity entity = dataitemdetailbll.GetListByItemCodeEntity("EverydayPatrol");
//if (entity != null)
// ViewBag.ItemDetailValue = entity.ItemValue;
ViewBag.ItemDetailValue1 = ""; //日检
ViewBag.ItemDetailValue2 = ""; //周检
ViewBag.ItemDetailValue3 = ""; //月检
ViewBag.ItemDetailValue4 = ""; //其他
//获取日常巡查ID
DataItemDetailEntity entity1 = dataitemdetailbll.GetListByItemCodeEntity("RJ");
if (entity1 != null)
{
ViewBag.ItemDetailValue1 = entity1.ItemValue;
}
DataItemDetailEntity entity2 = dataitemdetailbll.GetListByItemCodeEntity("ZJ");
if (entity2 != null)
{
ViewBag.ItemDetailValue2 = entity2.ItemValue;
}
DataItemDetailEntity entity3 = dataitemdetailbll.GetListByItemCodeEntity("YJ");
if (entity3 != null)
{
ViewBag.ItemDetailValue3 = entity3.ItemValue;
}
DataItemDetailEntity entity4 = dataitemdetailbll.GetListByItemCodeEntity("QT");
if (entity4 != null)
{
ViewBag.ItemDetailValue4 = entity4.ItemValue;
}
return(View());
}
public string ImportDataItem()
{
int error = 0;
string message = "请选择格式正确的文件再导入!";
string falseMessage = "";
int count = HttpContext.Request.Files.Count;
if (count > 0)
{
HttpPostedFileBase file = HttpContext.Request.Files[0];
if (string.IsNullOrEmpty(file.FileName))
{
return(message);
}
if (!(file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xls") || file.FileName.Substring(file.FileName.IndexOf('.')).Contains("xlsx")))
{
return(message);
}
string fileName = DateTime.Now.ToString("yyyyMMddHHmmss") + System.IO.Path.GetExtension(file.FileName);
file.SaveAs(Server.MapPath("~/Resource/temp/" + fileName));
DataTable dt = ExcelHelper.ExcelImport(Server.MapPath("~/Resource/temp/" + fileName));
int order = 1;
//先获取字典
DataItemBLL di = new DataItemBLL();
DataItemEntity Resk = di.GetEntityByCode("Risk");
DataItemDetailBLL detabll = new DataItemDetailBLL();
string[] names = { "粉尘", "化学因素", "物理因素", "放射性因素", "生物因素", "其他因素" };
string[] namevalues = { "01", "02", "03", "04", "05", "06" };
string value = "";
int index = 1;
string fname = file.FileName.Substring(0, file.FileName.IndexOf('.'));
for (int i = 0; i < names.Length; i++)
{
if (fname == names[i])
{
value = namevalues[i];
}
}
if (value != "")
{
DataItemDetailEntity dide = new DataItemDetailEntity();
dide.ItemId = Resk.ItemId;
dide.ItemValue = value;
dide.ItemName = fname;
dide.SortCode = index;
dide.ParentId = "0";
try
{
detabll.SaveForm("", dide);
}
catch (Exception)
{
error++;
}
foreach (DataRow dr in dt.Rows)
{
DataItemDetailEntity did = new DataItemDetailEntity();
did.ItemId = Resk.ItemId;
if (index < 10)
{
did.ItemValue = value + "00" + index;
}
else if (index < 100)
{
did.ItemValue = value + "0" + index;
}
else
{
did.ItemValue = value + index;
}
did.ItemName = dr[0].ToString();
did.SortCode = index;
did.ParentId = "0";
index++;
try
{
detabll.SaveForm("", did);
}
catch (Exception)
{
error++;
}
}
}
count = dt.Rows.Count - 1;
message = "共有" + count + "条记录,成功导入" + (count - error) + "条，失败" + error + "条";
message += "</br>" + falseMessage;
}
return(message);
}
public ActionResult SaveForm(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
dataItemDetailBLL.SaveForm(keyValue, dataItemDetailEntity);
return(Success("操作成功。"));
}
public ActionResult SaveForm(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
dataItemDetailEntity.SimpleSpelling = PinYinHelper.GetPinYinSimple(dataItemDetailEntity.ItemName);
dataItemDetailBLL.SaveDataItemDetail(keyValue, dataItemDetailEntity);
return(Success("操作成功。"));
}
public HttpResponseMessage GetTrendChartNewsList(TrendChart arg)
{
BaseJson <List <TrendChart_Preview> > resultMsg = new BaseJson <List <TrendChart_Preview> > {
Status = (int)JsonObjectStatus.Error, Message = "服务器未知错误。", Data = null
};
Logger(typeof(TrendChartController), arg.TryToJson(), "查询走势图链接-GetTrendChartNewsList", () =>
{
if (!string.IsNullOrEmpty(arg.Category))
{
List <TrendChart_Preview> res = Cache.Factory.CacheFactory.Cache().GetCache <List <TrendChart_Preview> >("__" + arg.Category + "__");
if (res == null)
{
res = new List <TrendChart_Preview>();
//如果传入为 GPC 的话，就默认返回高频彩11选5相关数据
List <DataItemModel> data = dataItemCache.GetDataItemList(arg.Category.Equals("GPC") ? "GPC11X5" : arg.Category).OrderBy(n => n.SortCode).ToList();
string[] ids = data.Select(d => d.ItemDetailId).ToArray();
//获取该分类下符合要求的数据
List <TrendChartEntity> trendChartEntities = TrendChartBll.GetPageList(n => n.IsDelete == false && n.IsStick == true && ids.Contains(n.CategoryId)).OrderBy(n => n.SortCode).ToList();
if (trendChartEntities.Count > 0)
{
//组装父级相关属性
TrendChart_Preview previewItem = new TrendChart_Preview
{
TrendChartType = arg.Category,
ItemName = dataItemCache.GetDataItemEntityByCode(arg.Category).ItemName
};
//根据分类ID进行分组
IEnumerable <IGrouping <string, TrendChartEntity> > group = trendChartEntities.GroupBy(t => t.CategoryId);
List <TempTrendChartPreviewItem> temp = new List <TempTrendChartPreviewItem>();
foreach (IGrouping <string, TrendChartEntity> chartEntities in group)
{
//分类ID
string key = chartEntities.Key;
//获取分类信息
DataItemDetailEntity dataItemEntity = dataItemCache.GetDataItemEntityById(key);
List <TrendChartPreviewItem> trendChartPreviewItems = new List <TrendChartPreviewItem>();
//组装项目相关属性
TempTrendChartPreviewItem item = new TempTrendChartPreviewItem
{
TrendChartChildType = dataItemEntity.ItemValue,
TrendChartChildName = dataItemEntity.ItemName
};
//组装具体信息
foreach (TrendChartEntity entity in chartEntities)
{
TrendChartPreviewItem p = new TrendChartPreviewItem
{
Title = entity.Title,
TrendChartUrl = entity.TrendChartUrl
};
trendChartPreviewItems.Add(p);
}
item.TrendChartPreviewItem = trendChartPreviewItems;
temp.Add(item);
}
previewItem.TrendChartPreviewItems = temp;
res.Add(previewItem);
}
Cache.Factory.CacheFactory.Cache().WriteCache <List <TrendChart_Preview> >(res, "__" + arg.Category + "__");
}
resultMsg = new BaseJson <List <TrendChart_Preview> >
{
Status = (int)JsonObjectStatus.Success,
Data = res,
Message = JsonObjectStatus.Success.GetEnumText(),
BackUrl = null
};
}
else
{
resultMsg = new BaseJson <List <TrendChart_Preview> >
{
Status = (int)JsonObjectStatus.Fail,
Data = null,
Message = JsonObjectStatus.Fail.GetEnumText() + "，请求参数Category为空。",
BackUrl = null
};
}
}, e =>
{
resultMsg = new BaseJson <List <TrendChart_Preview> >
{
Status = (int)JsonObjectStatus.Exception,
Data = null,
Message = JsonObjectStatus.Exception.GetEnumText() + "，异常信息：" + e.Message,
BackUrl = null
};
});
return(resultMsg.TryToJson().ToHttpResponseMessage());
}
/// <summary>
/// 根据分类ID获取实体对象
/// </summary>
/// <param name="id">ID</param>
/// <returns></returns>
public DataItemDetailEntity GetEntityById(string id)
{
DataItemDetailEntity old = service.GetEntityById(id);
return(old);
}
/// <summary>
/// 保存人身风险预控规则
/// </summary>
/// <param name="roleId"></param>
/// <param name="entity"></param>
public void SaveOrUpdateRole(string roleId, DataItemDetailEntity entity)
{
service.SaveOrUpdateRole(roleId, entity);
}
/// <summary>
/// 明细实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public DataItemDetailEntity GetDataItemDetailEntity(string keyValue)
{
DataItemDetailEntity res = o.BllSession.DataItemDetailBll.FindEntity(keyValue);
return(res);
}
/// <summary>
/// 明细实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public DataItemDetailEntity GetDataItemDetailEntity(string keyValue)
{
DataItemDetailEntity res = this.BaseRepository().FindEntity <DataItemDetailEntity>(keyValue);
return(res);
}
/// <summary>
/// 保存明细表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemDetailEntity">明细实体</param>
/// <returns></returns>
public void SaveDataItemDetail(string keyValue, DataItemDetailEntity dataItemDetailEntity)
{
_dataItemDetailService.SaveDataItemDetail(keyValue, dataItemDetailEntity);
}
