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, DataItemEntity dataItemEntity)
{
dataItemBLL.SaveForm(keyValue, dataItemEntity);
return(Success("操作成功。"));
}
private bool IsDataItemUnique(DataItemEntity dataItem, long dataItemId)
{
return(dataItem == null ||
dataItem.DeleteMark == (int)DeleteStatus.Deleted ||
(dataItemId != 0 && dataItem.Id == dataItemId));
}
public ActionResult GetOccpuationalTreeJson(string Code, string keyword, int checkMode = 0, int mode = 0, string deptIds = "0")
{
DataItemBLL di = new DataItemBLL();
//先获取到字典项
DataItemEntity DataItems = di.GetEntityByCode(Code);
DataItemDetailBLL did = new DataItemDetailBLL();
//根据字典项获取值
List <DataItemDetailEntity> didList = did.GetList(DataItems.ItemId).OrderBy(t => t.ItemValue).ToList();
//didList = didList.Where(it => it.ParentId == "0").ToList();//这里主要是由于开发时缓存 多做了一遍筛选
var treeList = new List <TreeEntity>();
//获取所有父节点集合
List <DataItemDetailEntity> parentList = didList.Where(it => it.ItemValue.Length == 2).ToList();
//获取所有子节点节点集合
List <DataItemDetailEntity> SunList = didList.Where(it => it.ItemValue.Length > 2).ToList();
if (!string.IsNullOrEmpty(keyword))
{
SunList = SunList.Where(t => t.ItemName.Contains(keyword)).ToList();
}
//先绑定父级树
foreach (DataItemDetailEntity oe in parentList)
{
treeList.Add(new TreeEntity
{
id = oe.ItemValue,
text = oe.ItemName,
value = oe.ItemValue,
parentId = "0",
isexpand = true,
complete = true,
showcheck = false,
hasChildren = true,
Attribute = "Sort",
AttributeValue = "Parent",
AttributeA = "manager",
AttributeValueA = "" + "," + "" + ",1"
});
}
//再绑定子集树
foreach (DataItemDetailEntity item in SunList)
{
int chkState = 0;
string[] arrids = deptIds.Split(',');
if (arrids.Contains(item.ItemValue))
{
chkState = 1;
}
TreeEntity tree = new TreeEntity();
bool hasChildren = false;
tree.id = item.ItemValue;
tree.text = item.ItemName;
tree.value = item.ItemValue;
tree.isexpand = true;
tree.complete = true;
tree.checkstate = chkState;
tree.showcheck = checkMode == 0 ? false : true;
tree.hasChildren = hasChildren;
tree.parentId = item.ItemValue.Substring(0, 2);
tree.Attribute = "Sort";
tree.AttributeValue = "Sun";
tree.AttributeA = "manager";
tree.AttributeValueA = "" + "," + "" + "," + "2";
treeList.Add(tree);
}
return(Content(treeList.TreeToJson()));
}
public ActionResult SaveClassifyForm(string keyValue, DataItemEntity entity)
{
dataItemIBLL.SaveClassifyEntity(keyValue, entity);
return(Success("保存成功！"));
}
/// <summary>
/// 分类实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public DataItemEntity GetEntityByKey(string keyValue)
{
DataItemEntity res = o.BllSession.DataItemBll.FindEntity(keyValue);
return(res);
}
/// <summary>
/// 保存分类表单（新增、修改）
/// </summary>
/// <param name="keyValue">主键值</param>
/// <param name="dataItemEntity">分类实体</param>
/// <returns></returns>
public void SaveDataItem(string keyValue, DataItemEntity dataItemEntity)
{
_dataItemService.SaveDataItem(keyValue, dataItemEntity);
}
private void btnGetSqlRegex_Click(object sender, EventArgs e)
{
DataListRefreshDevEditorAdapter adapter = this.HostAdapter as DataListRefreshDevEditorAdapter;
this.txtSqlRegex.Text = String.Empty;
string dataEntityId = adapter.ParameterPanels.General.DataEntityId;
if (dataEntityId == String.Empty || dataEntityId == null)
{
return;
}
UIElementDataListEntity dataListEntity =
this.HostAdapter.HostFormEntity.Elements.GetFormElementById(
adapter.ParameterPanels.General.DataListId) as UIElementDataListEntity;
if (dataListEntity == null)
{
return;
}
string sqlRegex = String.Empty;
sqlRegex +=
@"SELECT Count(Id) FROM {Table};
SELECT {Field} FROM {Table} WHERE 1=1 {Where};
WITH tableOrder AS
(
SELECT Id,{Field},
ROW_NUMBER() OVER (order by Id) AS RowNumber
FROM {Table} WHERE 1=1 {Where}
)
SELECT *
FROM tableOrder
WHERE RowNumber BETWEEN @rowNumberStart AND @rowNumberEnd
ORDER BY Id;
";
DataEntity dataEntity = _dataEntityComponentService.GetDataEntity(dataEntityId);
string tableName = dataEntity.Code;
sqlRegex = sqlRegex.Replace("{Table}", "[" + tableName + "]");
foreach (UIElementDataListTextBoxColumnEntity column in dataListEntity.DataColumns)
{
sqlRegex = sqlRegex.Replace("{Field}", "[" + column.GetDataItemCode() + "],{Field}");
}
sqlRegex = sqlRegex.Replace(",{Field}", "");
if (adapter.ParameterPanels.Where.Wheres == null || adapter.ParameterPanels.Where.Wheres.Count == 0)
{
sqlRegex = sqlRegex.Replace("{Where}", String.Empty);
this.txtSqlRegex.SetContent(sqlRegex.Replace("WHERE 1=1", String.Empty));
return;
}
sqlRegex += Environment.NewLine;
string strWhere = String.Empty;
string dataItemName = String.Empty;
string valueName = String.Empty;
foreach (DataListRefreshEvent.WhereItem whereItem in adapter.ParameterPanels.Where.Wheres)
{
DataItemEntity item = dataEntity.Items.GetEntityById(whereItem.DataItem);
Debug.Assert(item != null, "没有找到指定的数据项实体");
dataItemName = item.Code;
if (whereItem.Source.ToString().Split('.')[0] == "FormElement")
{
valueName = "{FormElement." +
this.HostAdapter.HostFormEntity.FindFormElementById(whereItem.Source.ToString().Split('.')[1]).Code + "}";
}
else
{
valueName = "{System." +
((EnumSystemDataSource)Convert.ToInt32(whereItem.Source.ToString().Split('.')[1])).ToString() + "}";
}
strWhere += " AND " +
CommonOperater.CombineFieldAndValue(dataItemName, valueName, whereItem.MatchType);
}
sqlRegex = sqlRegex.Replace("{Where}", strWhere);
this.txtSqlRegex.SetContent(sqlRegex.Replace("1=1" + Environment.NewLine + Environment.NewLine + " AND ",
Environment.NewLine));
}
/// <summary>
/// 分类实体
/// </summary>
/// <param name="keyValue">主键值</param>
/// <returns></returns>
public DataItemEntity GetEntityByKey(string keyValue)
{
DataItemEntity res = this.BaseRepository().FindEntity <DataItemEntity>(keyValue);
return(res);
}
