public virtual string SelectByWhere(string cols, string where,
string orderBy, int pageSize, int pageIndex, bool bReturnSum)
{
var sqlTemplate = "select {0} from {1} where 1=1 {2} {3} limit {4},{5}";
var whereStr = string.IsNullOrEmpty(where) ? "" : where; //需要加入遗产地的默认条件
var orderByStr = string.IsNullOrEmpty(orderBy) ? "" : " order by " + orderBy;
pageIndex = pageIndex <= 0 ? 1 : pageIndex;
var limit = (pageIndex - 1) * pageSize;
var sql = string.Format(sqlTemplate, string.IsNullOrEmpty(cols) ? "*" :
cols, TableName, whereStr, orderByStr, limit, pageSize);
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
DataTable datatable = context.getDataTableResult(sql);
if (!bReturnSum)
{
return(JsonHelper.SerializeObject(ToolResult.Success(datatable)));
}
var sqlSum = $"select count(*) from {GetModelName(TableName)} where 1=1 {whereStr} {orderByStr}";
int count = 0;
int.TryParse(context.executeScalar(sqlSum).ToString(), out count);
return(JsonHelper.SerializeObject(ToolResult.Success(new { data = datatable, sum = count })));
}
public string GetFuncTree(string funID, string userID)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql =
$@"select distinct b.NAME,b.ID,b.PID,ARGS from PRIVS_ROLE_FUNCPRIVS a
left join PRIVS_FUNCPRIVS b on a.PRIVSID = b.id where a.roleID in
( select ifnull(RoleID,'-1') from PRIVS_USER_ROLE where UserID='{userID}') and ID is not null order by b.INDEXOFORDER";
var dt = dbContext.getDataTableResult(sql);
if (dt == null || dt.Rows.Count == 0)
{
return(JsonHelper.SerializeObject(dt));
}
var entList = dt.ToEntList <FuncTree>();
var el = entList.Where(e => e.ID == funID).ToList();
foreach (var item in el)
{
GetFunC(entList, item);
}
return(JsonHelper.SerializeObject(el));
}
public string GetUserList(string keywords, int page, int num)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = @"
select a.*,c.Name as POSITIONNAME,b.ROLENAME as LEADERName,d.NAME as DEPARTMENTName from PRIVS_USER a
left join PRIVS_DEPARTMENT d on a.DEPARTMENTID=d.id
left join PRIVS_LEADER b on a.ID=b.USERID
left join PRIVS_POSITION c on a.POSITIONID=c.ID where 1=1 ";
var sqlstringbuilder = new StringBuilder(sql);
if (!string.IsNullOrEmpty(keywords))
{
sqlstringbuilder.AppendFormat(" and( a.REALNAME like '%{0}%' or a.NAME like '%{0}%' or b.ROLENAME like '%{0}%' or d.NAME like '%{0}%' and c.Name LIKE '%{0}%')", keywords);
}
sqlstringbuilder.AppendFormat(" order by CJSJ desc");
var busness = new CommonBaseBusiness();
var pageModel = busness.Select(sqlstringbuilder.ToString(), (page - 1) * num, num);
return(JsonHelper.SerializeObject(pageModel));
}
public string GetFunByUserID(string userID)
{
var sql =
$@"select distinct b.NAME,b.ID,b.PID,ARGS from PRIVS_ROLE_FUNCPRIVS a
left join PRIVS_FUNCPRIVS b on a.PRIVSID = b.id where a.roleID in
( select ifnull(RoleID,'-1') from PRIVS_USER_ROLE where UserID='{userID}') and ID is not null order by b.INDEXOFORDER";
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "数据库连接错误!")));
}
var dt = context.getDataTableResult(sql);
if (dt == null || dt.Rows.Count == 0)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "用户不存在!")));
}
var entList = dt.ToEntList <FuncTree>();
var el = entList.Where(e => string.IsNullOrEmpty(e.PID)).ToList();
foreach (var item in el)
{
GetFunC(entList, item);
}
return(JsonHelper.SerializeObject(ToolResult.Success(el)));
}
public VisionTask(VisionTaskInfo info)
{
#region MyRegion
result = new ToolResult();
ToolsDic = new Dictionary <string, ITool>();
ToolList = new List <ITool>();
ToolResultDic = new Dictionary <string, ToolResult>();
InputRegion = new HRegion();
InputRegion.GenEmptyRegion();
InputImage = new HImage();
InputImage.GenEmptyObj();
#endregion
this.Info = info;
TaskName = info.TaskName;
//显示界面布局
foreach (var item in Info.TaskToolsInfo)
{
object[] paras = new object[] { item };
ITool tool = CreatingHelper <ITool> .CreateInstance(@".//VisionTools/" + item.GetToolNameSpace() + ".dll", item.GetToolNameSpace(), item.GetToolClassName(), paras);
if (tool != null)
{
ToolsDic.Add(tool.TaskName, tool);
ToolList.Add(tool);
}
}
}
private string CommonLogion(string userName, string pwd, string code = "")
{
if (!string.IsNullOrEmpty(code) && code != SessionHelper.GetCheckCode())
{
return(JsonHelper.SerializeObject(new ResultModel(false, "短信验证码错误!")));
}
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "数据库连接错误!")));
}
var sql = @"
select a.*,c.Name as POSITIONNAME,b.ROLENAME as LEADERName,d.NAME as DEPARTMENTName from PRIVS_USER a
left join PRIVS_DEPARTMENT d on a.DEPARTMENTID=d.id
left join PRIVS_LEADER b on a.ID=b.USERID
left join PRIVS_POSITION c on a.POSITIONID=c.ID where a.Name='{1}' and Password='******'"; //a.NAMEPassword='******'
//防注入代码记得放开
var dt = context.getDataTableResult(string.Format(sql, DESHelper.EncodePassword(pwd), userName)); // DESHelper.EncodePassword(userName),
if (dt == null || dt.Rows.Count == 0)
{
var dtUser = context.getDataTableResult(
$"select * from PRIVS_USER where NAME='{userName}'");
var strMsgUser = dtUser != null && dtUser.Rows.Count > 0 ? "密码错误!" : "用户名错误!";
return(JsonHelper.SerializeObject(new ResultModel(false, strMsgUser)));
}
return(JsonHelper.SerializeObject(ToolResult.Success(dt)));
}
private void ExecuteBtn_Click(object sender, EventArgs e)
{
if (currentImage != null)
{
this.Tool.SetImage(currentImage);
}
ToolResult result = Tool.GetResult();
//显示结果
}
private void GetLineResultBtn_Click(object sender, EventArgs e)
{
ToolResult result = Tool.GetResult();
//显示结果
if (Info.IsShowResult)
{
}
}
public string VerifyBaseData(string jsonStr, string funId, string heritageId)
{
//判断传过来的json是否为空
if (string.IsNullOrEmpty(jsonStr) || jsonStr.Length < 10)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("传输字符串为空，不能对接!")));
}
//funid 找不到 返回错
return("");
}
public VisionTask()
{
ToolsDic = new Dictionary <string, ITool>();
result = new ToolResult();
ToolList = new List <ITool>();
ToolResultDic = new Dictionary <string, ToolResult>();
InputRegion = new HRegion();
InputRegion.GenEmptyRegion();
InputImage = new HImage();
InputImage.GenEmptyObj();
}
public string RelationRole2Fun(string roleid, string funArrStr)
{
var listSql = new List <string>();
var dataTemplateSql = "INSERT INTO PRIVS_ROLE_FUNCPRIVS(ROLEID,PRIVSID) values ('{0}','{1}') ";
var dataArr = funArrStr.Split(',');
listSql.AddRange(dataArr.Select(item => string.Format(dataTemplateSql, roleid, item)));
var dbContext = DBHelperPool.Instance.GetDbHelper();
var bIsSuccess = dbContext.executeTransactionSQLList(listSql);
return(ToolResult.SuccessJson(bIsSuccess ? "保存角色功能权限成功" : "保存角色功能失败"));
}
public string CheckLoginName(string name)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = $@"SELECT * from PRIVS_USER where NAME= '{name}'";
var bIsSuccess = (dbContext.getDataTableResult(sql) ?? new DataTable()).Rows.Count > 0;
return(JsonHelper.SerializeObject(new ResultModel(bIsSuccess, bIsSuccess ? "用户名已经存在！":"可以正常使用！")));
}
public virtual string GetDetailByMainID(string mainId)
{
string sql = $"select * from {TableName} where id='{mainId}'";
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var datatable = context.getDataTableResult(sql);
return(JsonHelper.SerializeObject(ToolResult.Success(datatable)));
}
public string GetPositionByDepartment(string departmentId)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = $"select * from PRIVS_POSITION where DepartmentID='{departmentId}'";
var dt = dbContext.getDataTableResult(sql);
return(JsonHelper.SerializeObject(dt));
}
public string GetRoleInfo(string id)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = $"select * from PRIVS_ROLE where ID = '{id}'";
var dt = dbContext.getDataTableResult(sql);
return(JsonHelper.SerializeObject(dt));
}
public virtual string GetDetailByMainID(string mainId, string cols, string keyField = "id")
{
string sql =
$"select {(string.IsNullOrEmpty(cols) ? "*" : cols)} from {TableName} where {keyField}='{mainId}'";
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var datatable = context.getDataTableResult(sql);
return(JsonHelper.SerializeObject(ToolResult.Success(datatable)));
}
public string LockUser(string id, string isLook)
{
var ids = id.Replace(",", "','");
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = $@"update PRIVS_USER set ISLOCKED='{isLook}' where id in ('{ids}')";
var bIsSuccess = dbContext.execute(sql) >= 0;
return(JsonHelper.SerializeObject(new ResultModel(bIsSuccess, bIsSuccess ? "操作成功！" : "操作失败！")));
}
public string GetFuncInfo(string id)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var funlistFunclist = new List <FuncTree>();
var sql = $"select * from PRIVS_FUNCPRIVS where id='{id}'";
var dt = dbContext.getDataTableResult(sql);
return(JsonHelper.SerializeObject(dt));
}
public virtual string ReceiveData()
{
var funModel = FindFunModel(HeritageId, FunId);
if (funModel == null)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "找不到该功能对应的配置信息")));
}
//通过xml配置的表名 找到类的路径 反射成 list类 对象
var cListType = MethodHelper.GetTypeList(GetModelName(funModel.TableName)); //GCHeritagePlatform.Services.PublicMornitor.Model.HPF_RCXC_RCXCYCJL;
var entList = JsonHelper.DeserializeJsonToObject(BusinessJsonStr, cListType) as IList; //遗产地发过来的字符串（json格式）的项与我们在model中建的功能类的属性是一一对应的,这里进行赋值
var listSqlStr = new List <string>(); //组织SQL 统一插入
var listYSJID = new List <string>(); //遗产地数据ID 验证对接
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
foreach (var item in entList)//因为要将接收过来的数据写到总平台数据库中,所以需要添加ID,以及进行遗产地数据ID进行检查,防止重复插入
{
var nameToValue = item.GetNameToValueDic();
if (nameToValue.ContainsKey("GLYCBTID"))
{
nameToValue["GLYCBTID"] = HeritageId;
}
if (nameToValue.ContainsKey("ID"))
{
nameToValue["ID"] = Guid.NewGuid();
}
else
{
nameToValue.Add("ID", Guid.NewGuid());
}
var yscid = nameToValue["YCDSJID"].ToString() + "";
if (!string.IsNullOrEmpty(yscid))
{
listYSJID.Add(yscid);//防止重复对接
}
listSqlStr.Add(context.insertByParamsReturnSQL(GetModelName(funModel.TableName), nameToValue));
}
if (!CheckIsDock(listSqlStr, listYSJID, funModel.TableName, context))
{
return(JsonHelper.SerializeObject(new ResultModel(false, "已经存在对接的数据")));
}
return(GetExeListSQL(context, listSqlStr));
}
public string GetRoleEx(string id)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = $"select * from PRIVS_ROLE where ID = '{id}'";
var dt = dbContext.getDataTableResult(sql);
DataTable dtFUN = dbContext.getDataTableResult($@"select a.*,b.NAME from PRIVS_ROLE_FUNCPRIVS a
left join PRIVS_FUNCPRIVS b on a.PRIVSID=b.ID where a.ROLEID='{id}'");
return(JsonHelper.SerializeObject(new { Role = dt, Fun = dtFUN }));
}
public string GetDepartmentInfo(string id)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql =
$@"select b.Name as PARENTName,a.* from PRIVS_DEPARTMENT a
left join PRIVS_DEPARTMENT b on a.PARENTID=b.ID where a.ID = '{id}'";
DataTable dt = dbContext.getDataTableResult(sql);
return(JsonHelper.SerializeObject(dt));
}
public virtual string ReceiveFile(byte[] fileInfo, string fileNmae, string businessFunID, string heritageId)
{
//遗产地 + 大类+ 功能 +文件
//var ftpUserID = System.Configuration.ConfigurationManager.AppSettings["ftpUser"];
//var ftpPassword = System.Configuration.ConfigurationManager.AppSettings["ftpPassword"];
SystemLogger.getLogger().Info(DateTime.Now + "访问bug");
var ftpAddress = System.Configuration.ConfigurationManager.AppSettings["Address"];
var rPath = "";
var filePath = CommonBusiness.GetFileTempPath(businessFunID, heritageId, ftpAddress, out rPath);
var fileNewGuid = Guid.NewGuid().ToString();
var filePathAll = Path.Combine(filePath, fileNewGuid + "." + fileNmae.GetExtensioName());
if (!System.IO.Directory.Exists(filePath))
{
SystemLogger.getLogger().Info(DateTime.Now + "创建目录");
System.IO.Directory.CreateDirectory(filePath);
}
FileStream fstream = File.Create(filePathAll, fileInfo.Length);
fstream.Write(fileInfo, 0, fileInfo.Length); //
SystemLogger.getLogger().Info(DateTime.Now + "创建目录正常");
try
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = @"INSERT INTO `HPF_TEMP_FILE` (`ID`,`WJMC`,`WJLX`,`WJLJ`) VALUES ('{0}','{1}','{2}','{3}')";
SystemLogger.getLogger().Info(DateTime.Now + "访问bug1");
var iResult = dbContext.execute(string.Format(sql, fileNewGuid, fileNmae, fileNmae.GetExtensioName(), rPath + fileNewGuid + "." + fileNmae.GetExtensioName()));
SystemLogger.getLogger().Info(DateTime.Now + "访问bug2");
SystemLogger.getLogger().Info("返回结果：" + iResult);
return(iResult > 0 ? fileNewGuid : "");
}
catch (Exception ex)
{
var strErr = string.Format("遗产地对接文件类数据错误，参数：{0}#{1}#{2}，具体错误：{3}", fileNmae, businessFunID, heritageId, ex.Message);
SystemLogger.getLogger().Error(strErr);
}
finally
{
fstream.Close();
}
SystemLogger.getLogger().Info(DateTime.Now + "访问bug4");
return(fileNewGuid);
}
public string GetUserPZ(string userID)
{
try
{
var o = SessionHelper.GetUser();
if (o.ID != userID)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "用户没有登录！")));
}
return(JsonHelper.SerializeObject(ToolResult.Success(o)));
}
catch (Exception ex)
{
return(JsonHelper.SerializeObject(new ResultModel(false, ex.Message)));
}
}
public string GetDepartmentTree()
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = "select ID,NAME,PARENTID as PID from PRIVS_DEPARTMENT";
var dt = dbContext.getDataTableResult(sql);
var entList = dt.ToEntList <FuncTree>();
var el = entList.Where(e => e.PID == null).ToList();
foreach (var item in el)
{
GetFunC(entList, item);
}
return(JsonHelper.SerializeObject(el));
}
public string GetUser(string id)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = $@"
select a.*,c.Name as POSITIONNAME,b.ROLENAME as LEADERName,d.NAME as DEPARTMENTName from PRIVS_USER a
left join PRIVS_DEPARTMENT d on a.DEPARTMENTID=d.id
left join PRIVS_LEADER b on a.ID=b.USERID
left join PRIVS_POSITION c on a.POSITIONID=c.ID where a.ID = '{id}'";
DataTable dt = dbContext.getDataTableResult(sql);
DataTable dtRole = dbContext.getDataTableResult($@"select a.*,b.Name from PRIVS_USER_ROLE a
left Join PRIVS_ROLE b on a.ROLEID = b.ID
where a.USERID ='{id}'");
return(JsonHelper.SerializeObject(new { User = dt, Role = dtRole }));
}
public string ExportFuncTree(List <FuncTree> listFuncTree)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var listSql = new List <string>()
{
"delete from PRIVS_FUNCPRIVS"
};
var sqlTemplate = @"insert into PRIVS_FUNCPRIVS(ID,NAME,PID,DESCRIPTION,INDEXOFORDER,
ARGS,GROUPNAME,SYSTEMID,CJSJ)values('{0}','{1}','{2}','{3}','{4}','{5}','{6}','{7}','{8}')";
SetFuncListSql(listFuncTree, listSql, sqlTemplate);
var b = dbContext.executeTransactionSQLList(listSql);
return(JsonHelper.SerializeObject(new ResultModel(b, b?"导入功能树成功":"导入功能树失败")));
}
protected override ToolResult ExecuteBody()
{
using (var service = new ServiceController(_serviceName, _machineName))
{
service.Start();
service.WaitForStatus(ServiceControllerStatus.Running, new TimeSpan(Timeout));
var result = new ToolResult
{
DidSucceed = true,
State = ErrorStatuses.Contains(service.Status)
? Core.SeverityState.Error
: WarningStatuses.Contains(service.Status)
? Core.SeverityState.Warning
: Core.SeverityState.Normal
};
return(result);
};
}
public string GetDepartmentList(string keywords, int page, int num)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sqlstringbuilder = new StringBuilder(@"select b.Name as PARENTNANE,a.* from PRIVS_DEPARTMENT a
left join PRIVS_DEPARTMENT b on a.PARENTID=b.ID where 1=1");
if (!string.IsNullOrEmpty(keywords))
{
sqlstringbuilder.AppendFormat(" and (a.NAME like '%{0}%' or a.ALIASNAME like '%{0}%') ", keywords);
}
sqlstringbuilder.AppendFormat(" order by a.CJSJ desc");
var busness = new CommonBaseBusiness();
var pageModel = busness.Select(sqlstringbuilder.ToString(), (page - 1) * num, num);
return(JsonHelper.SerializeObject(pageModel));
}
public string GetRoleList(string keyword, int page, int num)
{
var dbContext = DBHelperPool.Instance.GetDbHelper();
if (dbContext == null)
{
return(JsonHelper.SerializeObject(ToolResult.Failure("数据连接异常!")));
}
var sql = "select * from PRIVS_ROLE where 1=1 ";
var sqlstringbuilder = new StringBuilder(sql);
if (!string.IsNullOrEmpty(keyword))
{
sqlstringbuilder.AppendFormat(" and (NAME like '%{0}%' or ALIASNAME like '%{0}%') ", keyword);
}
sqlstringbuilder.AppendFormat(" order by CJSJ desc");
var busness = new CommonBaseBusiness();
var pageModel = busness.Select(sqlstringbuilder.ToString(), (page - 1) * num, num);
return(JsonHelper.SerializeObject(pageModel));
}
public string GetFunByRole(string roleID)
{
var sql =
$@"
select b.NAME,b.ID,b.PID,a.ARGS from PRIVS_ROLE_FUNCPRIVS a
left join PRIVS_FUNC b on a.PRIVSID = b.id where a.roleID='{roleID}'";
var context = DBHelperPool.Instance.GetDbHelper();
if (context == null)
{
return(JsonHelper.SerializeObject(new ResultModel(false, "数据库连接错误!")));
}
var dt = context.getDataTableResult(sql);
var entList = dt.ToEntList <FuncTree>();
var el = entList.Where(e => e.PID == null).ToList();
foreach (var item in el)
{
GetFunC(entList, item);
}
return(JsonHelper.SerializeObject(ToolResult.Success(el)));
}
/// <ToBeCompleted></ToBeCompleted>
public ToolExecutedEventArgs(Tool tool, ToolResult eventType)
: base() {
if (tool == null) throw new ArgumentNullException("tool");
this.tool = tool;
this.eventType = eventType;
}
