/// <summary>
/// Init
/// </summary>
internal void Init()
{
#region dic
DataTable dt = null;
DataSourceDuty = new List <EntityCodeDuty>();
DataSourceClass = new List <EntityCodeOperatorClass>();
DataSourceRole = new List <EntityCodeRole>();
using (ProxyEntityFactory proxy = new ProxyEntityFactory())
{
dt = proxy.Service.SelectFullTable(new EntityCodeDuty());
DataSourceDuty.AddRange(EntityTools.ConvertToEntityList <EntityCodeDuty>(dt));
dt = proxy.Service.SelectFullTable(new EntityCodeOperatorClass());
DataSourceClass.AddRange(EntityTools.ConvertToEntityList <EntityCodeOperatorClass>(dt));
dt = proxy.Service.SelectFullTable(new EntityCodeRole());
DataSourceRole.AddRange(EntityTools.ConvertToEntityList <EntityCodeRole>(dt));
}
#endregion
isInit = true;
LoadList();
InitLue();
SetEditValueChangedEvent(Viewer.plMain);
CreateTreeDept();
LoadDataSourceDept();
isInit = false;
}
/// <summary>
/// Init
/// </summary>
internal void Init()
{
try
{
Viewer.Location = new Point(Viewer.Location.X, 0);
Viewer.Height = Screen.PrimaryScreen.WorkingArea.Height;
uiHelper.BeginLoading(Viewer);
#region 参数
using (ProxyEntityFactory proxy = new ProxyEntityFactory())
{
ContagionParmData = EntityTools.ConvertToEntityList <EntityRptContagionParm>(proxy.Service.SelectFullTable(new EntityRptContagionParm()));
}
#endregion
// 传染病报表
if (ContagionParmData != null)
{
if (ContagionParmData.Any(t => t.reportId == this.ContagionDisplayVo.reportId && t.keyId == "templateId"))
{
this.formId = Function.Dec(ContagionParmData.FirstOrDefault(t => t.reportId == this.ContagionDisplayVo.reportId && t.keyId == "templateId").keyValue);
}
}
if (this.formId > 0)
{
using (ProxyFormDesign proxy = new ProxyFormDesign())
{
proxy.Service.GetForm((int)this.formId, out FormDesignVo);
}
}
if (FormDesignVo == null)
{
FormDesignVo = new EntityFormDesign();
}
if (Function.Dec(this.ContagionDisplayVo.rptId) > 0)
{
using (ProxyContagion proxy = new ProxyContagion())
{
EntityRptContagion vo = proxy.Service.GetContagion(Function.Dec(this.ContagionDisplayVo.rptId));
#region patientInfo
Viewer.rdoFlag.SelectedIndex = vo.patType - 1;
Viewer.rdoFlag.Properties.ReadOnly = true;
Viewer.txtCardNo.Text = vo.patNo;
#endregion
LoadForm(FormDesignVo.Layout, vo.xmlData);
GetPatient();
}
}
else
{
LoadForm(FormDesignVo.Layout, null);
}
}
finally
{
uiHelper.CloseLoading(Viewer);
}
}
/// <summary>
/// GetQnList
/// </summary>
/// <returns></returns>
public List <EntityDicQnSummary> GetQnList()
{
List <EntityDicQnSummary> dataSource = new List <EntityDicQnSummary>();
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
List <EntityDicQnSummary> tmpData = EntityTools.ConvertToEntityList <EntityDicQnSummary>(svc.Select(new EntityDicQnSummary()));
foreach (EntityDicQnSummary item in tmpData)
{
if (item.isParent == 1)
{
dataSource.Add(item);
}
}
List <EntityDicQnSummary> subData = null;
foreach (EntityDicQnSummary item in dataSource)
{
subData = tmpData.FindAll(t => t.parentFieldId == item.fieldId);
if (subData != null && subData.Count > 0)
{
int num = 0;
foreach (EntityDicQnSummary item2 in subData)
{
item.qnItemsDesc += Convert.ToString(++num) + "、" + item2.fieldName + "; ";
}
item.qnItemsDesc = item.qnItemsDesc.Trim().TrimEnd(';');
}
}
return(dataSource);
}
/// <summary>
/// 获取.表单打印模板
/// </summary>
/// <param name="templateId"></param>
/// <returns></returns>
public EntityEmrPrintTemplate GetFormPrintTemplate(int idType, string templateId)
{
SqlHelper svc = null;
EntityEmrPrintTemplate vo = null;
try
{
DataTable dt = null;
svc = new SqlHelper(EnumBiz.onlineDB);
vo = new EntityEmrPrintTemplate();
if (idType == 1)
{
vo.templateId = Function.Dec(templateId);
dt = svc.SelectPk(vo);
}
else if (idType == 2)
{
vo.templateCode = templateId;
dt = svc.Select(vo, EntityEmrPrintTemplate.Columns.templateCode);
}
if (dt != null && dt.Rows.Count > 0)
{
vo = EntityTools.ConvertToEntityList <EntityEmrPrintTemplate>(dt)[0];
}
}
catch (Exception ex)
{
ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
}
finally
{
svc = null;
}
return(vo);
}
/// <summary>
/// 表格明细
/// </summary>
/// <param name="tableCode"></param>
/// <returns></returns>
public List <EntityEmrTableFieldInfo> GetTableFieldInfo(string tableCode)
{
List <EntityEmrTableFieldInfo> data = new List <EntityEmrTableFieldInfo>();
EntityEmrTableFieldInfo vo = null;
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
vo = new EntityEmrTableFieldInfo();
vo.tableCode = tableCode;
DataTable dt = svc.Select(vo, EntityEmrTableFieldInfo.Columns.tableCode);
DataView dv = new DataView(dt);
dv.Sort = "sortNo";
data = EntityTools.ConvertToEntityList <EntityEmrTableFieldInfo>(dv.ToTable());
}
catch (Exception ex)
{
ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
}
finally
{
svc = null;
}
return(data);
}
/// <summary>
/// 系统参数
/// </summary>
/// <param name="parmID"></param>
/// <returns></returns>
private string SysParameter(int parmID)
{
string paraValue = string.Empty;
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
try
{
EntitySysParameter voSysPara = new EntitySysParameter();
voSysPara.Parmid = parmID;
voSysPara.Parmstatus = 1;
List <EntitySysParameter> lstSysPara = EntityTools.ConvertToEntityList <EntitySysParameter>(svc.Select(voSysPara, new List <string> {
EntitySysParameter.Columns.Parmid, EntitySysParameter.Columns.Parmstatus
}));
if (lstSysPara != null && lstSysPara.Count > 0)
{
paraValue = lstSysPara[0].Parmvalue;
}
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
}
finally
{
svc = null;
}
return(paraValue);
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <KeyReq <int> >();
if (req == null || req.Key <= 0)
{
return(ResultModel.GetParamErrorModel());
}
var conn = appSetting.GetMysqlConn(context);
var result = await DapperTools.Edit(conn, EntityTools.GetTableName <AttentionInfo>(), new[]
{
$"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.AttentionUser))}={req.Key}",
$"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.UserId))}={userId}",
$"{nameof(BaseModel.ValidFlag)}={(int)ValidFlagMenu.UnUseFul}"
},
new[]
{
$"{nameof(BaseModel.ValidFlag)}=@{nameof(BaseModel.ValidFlag)}",
$"{nameof(BaseModel.UpdateTime)}=@{nameof(BaseModel.UpdateTime)}",
},
new
{
ValidFlag = ValidFlagMenu.UnUseFul,
UpdateTime = DateTime.Now,
});
return(ResultModel.GetSuccessModel(result));
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context)
{
//解析参数
var pageModel = acceptParam.AnalyzeParam <PageModel <FilterReq> >();
if (pageModel == null)
{
return(ResultModel.GetNullErrorModel(string.Empty));
}
//动态sql
// StringBuilder whereBuilder = new StringBuilder();
List <string> whereList = new List <string>();
if (pageModel.Result.ValidFlag != null && pageModel.Result.ValidFlag >= 0)
{
// whereBuilder.Append($@"
//{SqlCharConst.WHERE} {EntityTools.GetField<ArticleTag>(nameof(ArticleTag.ValidFlag))} = {pageModel.Result.ValidFlag}
//");
whereList.Add($"{EntityTools.GetField<ArticleTag>(nameof(ArticleTag.ValidFlag))} = {pageModel.Result.ValidFlag}");
}
//获取连接
var mysqlConn = appSetting.GetMysqlConn();
var dbConnection = context.GetConnection(mysqlConn.FlagKey, mysqlConn.ConnStr);
//采用工具类分页查询
var pageList = await DapperTools.GetPageList <ArticleTag>(pageModel.PageNo, pageModel.PageSize, dbConnection,
whereList);
//返回结果集
return(ResultModel.GetSuccessModel(string.Empty, pageList));
}
public override IEnumerable <string> GetWhereEnumerable(AcceptParam acceptParam, out PageModel <object> page,
out string msg)
{
var param = acceptParam.AnalyzeParam <PageModel <long> >();
if (param == null || param.Result <= 0)
{
msg = "参数异常！";
}
msg = string.Empty;
page = new PageModel <object>()
{
PageNo = param.PageNo,
PageSize = param.PageSize,
};
return(new[]
{
$"{EntityTools.GetField<CommentInfo>(nameof(CommentInfo.JoinKey))} = {param.Result}",
$"{EntityTools.GetField<CommentInfo>(nameof(CommentInfo.CommentType))} = {(int)CommentTypeMenu.Article}",
// $"{EntityTools.GetField<CommentInfo>(nameof(CommentInfo.ReplyId))} = {0}",//只查评论 不差回复评论
$"{EntityTools.GetField<CommentInfo>(nameof(CommentInfo.ValidFlag))} = {(int)ValidFlagMenu.UseFul}",
});
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <KeyReq <long> >();
if (req == null || req.Key <= 0)
{
return(ResultModel.GetParamErrorModel());
}
var dbConnection = appSetting.GetMysqlConn(context);
var result = await DapperTools.Edit(dbConnection, EntityTools.GetTableName <ArticleInfo>(), new[]
{
$"{EntityTools.GetField<BaseModel>(nameof(BaseModel.Id))} = {req.Key} ",
$"{EntityTools.GetField<ArticleInfo>(nameof(ArticleInfo.UserId))} = {userId}",
}, new[]
{
$"{nameof(BaseModel.ValidFlag)} = {((int) ValidFlagMenu.UnUseFul)}",
$"{nameof(BaseModel.UpdateTime)} = @{nameof(BaseModel.UpdateTime)}"
}, new
{
UpdateTime = DateTime.Now
});
// var result = await dbConnection.ExecuteAsync($@"
//{SqlCharConst.UPDATE} {EntityTools.GetTableName<ArticleInfo>()}
//{SqlCharConst.SET} {EntityTools.GetField<BaseModel>(nameof(BaseModel.ValidFlag))} = {((int) ValidFlagMenu.UseFul)}
//{SqlCharConst.WHERE} {EntityTools.GetField<BaseModel>(nameof(BaseModel.Id))} = {req.Key}
//{SqlCharConst.AND} {EntityTools.GetField<ArticleInfo>(nameof(ArticleInfo.UserId))} = {userId}
//");
return(ResultModel.GetSuccessModel(result));
}
/// <summary>
/// 用户修改密码
/// </summary>
/// <param name="empNo">用户工号</param>
/// <param name="oldPassWord">旧密码</param>
/// <param name="newPassWord">新密码</param>
/// <returns></returns>
public int ChangePassword(string empNo, string oldPassWord, string newPassWord)
{
int intRet = 0;
string SQL = string.Empty;
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
try
{
EntityCodeOperator voEmp = new EntityCodeOperator();
voEmp.disable = "F";
voEmp.operCode = empNo;
List <EntityCodeOperator> lstEmp = EntityTools.ConvertToEntityList <EntityCodeOperator>(svc.Select(voEmp, new List <string> {
EntityCodeOperator.Columns.disable, EntityCodeOperator.Columns.operCode
}));
if (lstEmp != null && lstEmp.Count > 0)
{
string strDBPwd = string.Empty;
bool blnNull = false;
if (string.IsNullOrEmpty(lstEmp[0].pwd))
{
blnNull = true;
}
if (blnNull)
{
}
else
{
strDBPwd = lstEmp[0].pwd; //ESCryptography.Decrypt(lstEmp[0].pwd);
}
if (blnNull || strDBPwd == oldPassWord)
{
Dictionary <string, object> dicSet = new Dictionary <string, object>();
Dictionary <string, object> dicWhere = new Dictionary <string, object>();
dicSet.Add(EntityCodeOperator.Columns.pwd, newPassWord);//ESCryptography.Decrypt(newPassWord));
//dicSet.Add(EntityCodeOperator.Columns.Pwdusedate, DateTime.Now);
dicWhere.Add(EntityCodeOperator.Columns.disable, "F");
dicWhere.Add(EntityCodeOperator.Columns.operCode, empNo);
intRet = svc.Commit(svc.GetUpdateParm(voEmp, dicSet, dicWhere));
}
else
{
intRet = 0;
}
}
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
intRet = -1;
}
finally
{
svc = null;
}
return(intRet);
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var updateUserDto = acceptParam.AnalyzeParam <UpdateUserReq>();
if (updateUserDto == null)
{
return(ResultModel.GetNullErrorModel());
}
var msg = updateUserDto.ValidInfo();
if (msg != string.Empty)
{
return(ResultModel.GetParamErrorModel(msg));
}
var dbConnection = appSetting.GetMysqlConn(context);
var result = await DapperTools.Edit(dbConnection, EntityTools.GetTableName <UserInfo>(), new List <string>()
{
$"{nameof(BaseModel.Id)} = {userId}"
}, null, updateUserDto);
// var result = await dbConnection.ExecuteAsync($@"
//{SqlCharConst.UPDATE} {EntityTools.GetTableName<UserInfo>()}
//{SqlCharConst.SET} {string.Join(",", updateUserDto.GetType().GetProperties().Select(u => $"{u.Name} = @{u.Name}"))}
//{SqlCharConst.WHERE} {nameof(BaseModel.Id)} = {userId}
//",updateUserDto);
return(ResultModel.GetSuccessModel(result));
}
/// <summary>
/// 获取报表文件
/// </summary>
/// <param name="rptId"></param>
/// <returns></returns>
public EntitySysReport GetReport(decimal rptId)
{
SqlHelper svc = null;
try
{
EntitySysReport vo = new EntitySysReport();
vo.rptId = rptId;
svc = new SqlHelper(EnumBiz.onlineDB);
List <EntitySysReport> lstRpt = EntityTools.ConvertToEntityList <EntitySysReport>(svc.Select(vo, new List <string> {
EntitySysReport.Columns.rptId
}));
if (lstRpt != null && lstRpt.Count > 0)
{
return(lstRpt[0]);
}
}
catch (Exception ex)
{
ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
}
finally
{
svc = null;
}
return(null);
}
/// <summary>
/// NewOperRole
/// </summary>
internal void NewOperRole()
{
EntityCodeOperator vo = GetOperOrig();
if (vo == null)
{
DialogBox.Msg("请先保存职工主信息。");
return;
}
frmNew frm = new frmNew(EntityTools.ConvertToDataTable <EntityCodeRole>(DataSourceRole), "roleCode", "roleCode", "roleName");
if (frm.ShowDialog() == DialogResult.OK)
{
if (frm.lstNo.Count > 0)
{
foreach (int index in frm.lstNo)
{
EntityDefOperatorRole vo1 = new EntityDefOperatorRole();
vo1.operCode = vo.operCode;
vo1.roleCode = DataSourceRole[index].roleCode;
using (ProxyDictionary proxy = new ProxyDictionary())
{
if (proxy.Service.SaveOperatorRole(vo1) < 0)
{
DialogBox.Msg("保存职工所属角色失败。");
return;
}
}
}
LoadOperRole(vo.operCode);
}
}
}
/// <summary>
/// 获取传染病实例(vo)
/// </summary>
/// <param name="rptId"></param>
/// <returns></returns>
internal EntityRptContagion GetContagion(decimal rptId)
{
EntityRptContagion vo = new EntityRptContagion();
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
vo.rptId = rptId;
vo = EntityTools.ConvertToEntity <EntityRptContagion>(svc.SelectPk(vo));
EntityRptContagionData dataVo = new EntityRptContagionData();
dataVo.rptId = rptId;
dataVo = EntityTools.ConvertToEntity <EntityRptContagionData>(svc.SelectPk(dataVo));
vo.xmlData = dataVo.xmlData;
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
}
finally
{
svc = null;
}
return(vo);
}
public override IEnumerable <string> GetFieldEnumerable(TableMapperAttribute tableMapper)
{
var list = EntityTools.GetFields <CommentInfo>().ToList();
// list.Add($@"
//(
// {SqlCharConst.SELECT} {SqlCharConst.COUNT}(0)
// {SqlCharConst.FROM} {EntityTools.GetTableName<CommentInfo>()}
// {SqlCharConst.WHERE} {EntityTools.GetField<CommentInfo>(nameof(CommentInfo.ReplyId))} = {tableMapper.Alias}.{nameof(BaseModel.Id)}
// {SqlCharConst.AND} {EntityTools.GetField<CommentInfo>(nameof(CommentInfo.ValidFlag))} = {(int)ValidFlagMenu.UseFul}
// {SqlCharConst.AND} {EntityTools.GetField<CommentInfo>(nameof(CommentInfo.CommentType))} = {(int)CommentTypeMenu.Article}
//)
// AS {EntityTools.GetField<CommentDto>(nameof(CommentDto.ReplyCount))}
//");
list.Add($@"
(
SELECT displayName FROM user_info
WHERE id = (
SELECT actionUser FROM comment_info
WHERE id = {tableMapper.Alias}.replyId
)
) AS {nameof(CommentDto.ReplyUserName)}
");
return(list);
}
/// <summary>
/// 系统参数
/// </summary>
/// <returns></returns>
public Dictionary <int, string> SysParameter()
{
Dictionary <int, string> dicSysParam = new Dictionary <int, string>();
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
try
{
EntitySysParameter voSysPara = new EntitySysParameter();
voSysPara.Parmstatus = 1;
List <EntitySysParameter> lstSysPara = EntityTools.ConvertToEntityList <EntitySysParameter>(svc.Select(voSysPara, new List <string> {
EntitySysParameter.Columns.Parmstatus
}));
if (lstSysPara != null && lstSysPara.Count > 0)
{
foreach (EntitySysParameter vo in lstSysPara)
{
if (!dicSysParam.ContainsKey(Function.Int(vo.Parmid)))
{
dicSysParam.Add(Function.Int(vo.Parmid), vo.Parmvalue);
}
}
}
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
}
finally
{
svc = null;
}
return(dicSysParam);
}
/// <summary>
/// 表格明细
/// </summary>
/// <param name="tableCode"></param>
/// <returns></returns>
public List <EntityEmrTableFieldInfo> GetTableFieldInfo(string tableCode)
{
List <EntityEmrTableFieldInfo> data = new List <EntityEmrTableFieldInfo>();
EntityEmrTableFieldInfo vo = null;
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
vo = new EntityEmrTableFieldInfo();
vo.tableCode = tableCode;
DataTable dt = svc.Select(vo, EntityEmrTableFieldInfo.Columns.tableCode);
DataView dv = new DataView(dt);
dv.Sort = "sortNo";
data = EntityTools.ConvertToEntityList <EntityEmrTableFieldInfo>(dv.ToTable());
}
catch (Exception e)
{
ExceptionLog.OutPutException(e);
}
finally
{
svc = null;
}
return(data);
}
/// <summary>
/// 载入元素内容联动信息
/// </summary>
private void LoadLinkage(object value)
{
txtContent_vchr.ClearText();
//标记是否原有数据,以便在保存时根据情况执行不同操作
txtContent_vchr.Tag = null;
if (value != null)
{
EntityElementTemplateLinkage vo = new EntityElementTemplateLinkage();
vo.elementId = Function.Int(value);
vo.status = 1;
ProxyEntityFactory proxy = new ProxyEntityFactory();
vo = EntityTools.ConvertToEntity <EntityElementTemplateLinkage>(proxy.Service.Select(vo, new List <string> {
EntityElementTemplateLinkage.Columns.elementId, EntityElementTemplateLinkage.Columns.status
}));
proxy = null;
if (vo != null)
{
txtContent_vchr.SetXmlText(vo.colContentRtf, vo.colContentXml, false);
txtContent_vchr.Tag = vo;
m_mthOpenLinkedPage();
}
else
{
if (m_intFlags == 0)
{
m_mthCloseLinkedPage();
}
}
proxy = null;
}
}
private void EditValueChanged(string empNo)
{
if (!string.IsNullOrEmpty(empNo))
{
EntityCodeOperator vo = new EntityCodeOperator();
vo.disable = "F";
vo.operCode = empNo;
using (ProxyEntityFactory proxy = new ProxyEntityFactory())
{
vo = EntityTools.ConvertToEntity <EntityCodeOperator>(proxy.Service.Select(vo, new List <string> {
EntityCodeOperator.Columns.disable, EntityCodeOperator.Columns.operCode
}));
//this.CaKeyId = ?
if (empNo != vo.operCode)
{
this.txtEmpName.Text = string.Empty;
this.lblInfo.Visible = true;
}
else
{
this.txtEmpName.Text = vo.operName;
CurrPwd = vo.pwd;
empNo = vo.operCode;
EmpName = vo.operName;
this.lblInfo.Visible = false;
}
}
}
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <CreateArticleReq>();
if (req == null)
{
return(ResultModel.GetNullErrorModel(string.Empty));
}
string msg;
if ((msg = req.ValidInfo()) != string.Empty)
{
return(ResultModel.GetNullErrorModel(string.Empty, msg));
}
var createArticleParam = (CreateArticleParam)req;
createArticleParam.UserId = userId;
var mysqlConn = appSetting.GetMysqlConn();
var dbConnection = context.GetConnection(mysqlConn.FlagKey, mysqlConn.ConnStr);
var result =
await DapperTools.CreateItem(dbConnection, EntityTools.GetTableName <ArticleInfo>(), createArticleParam);
return(ResultModel.GetSuccessModel(string.Empty, result));
}
private void GetSet(bool ignoreCase)
{
var obj = new DataObjectModel();
IDataObject objIDataObject = obj as IDataObject;
object glocalInstance = obj;
string propertyName = "Name";
var func = (Func <DataObjectModel, string>)Delegate.CreateDelegate(typeof(Func <DataObjectModel, string>), typeof(DataObjectModel).GetMethod("get_Name"));
TestCase tester = new TestCase();
tester.Watcher = (i, name, sw) =>
{
Trace.WriteLine(string.Format("{0}:{1}", name, sw.Elapsed));
};
tester.Build("直接调用时", () => { obj.NameField = obj.Name; });
tester.Build("委托调用时", () => { var value = func(obj); });
tester.Build("接口调用时", () => { objIDataObject.SetValue(propertyName, ignoreCase, objIDataObject.GetValue(propertyName, ignoreCase)); });
tester.Build("工具调用时", () => { EntityTools <DataObjectModel> .SetValue(obj, propertyName, ignoreCase, EntityTools <DataObjectModel> .GetValue(obj, propertyName, ignoreCase)); });
tester.Build("字符串工具", () => { EntityTools <DataObjectModel> .SetValueString(obj, propertyName, ignoreCase, EntityTools <DataObjectModel> .GetValueString(obj, propertyName, ignoreCase)); });
tester.Build("虚接口调用", () => { obj.SetEntityValue(propertyName, ignoreCase, obj.GetEntityValue(propertyName, ignoreCase)); });
tester.StepWatcher = i =>
{
Trace.WriteLine(string.Format("执行{0:###,###,###}次的结果: ", i));
};
int times = 10000;
tester.Execute(1000 * times);
}
/// <summary>
/// 表格主表
/// </summary>
/// <param name="tableCode"></param>
/// <returns></returns>
public EntityEmrTableBasicInfo GetGetTableMainInfo(string tableCode)
{
SqlHelper svc = null;
try
{
svc = new SqlHelper(EnumBiz.onlineDB);
EntityEmrTableBasicInfo vo = new EntityEmrTableBasicInfo();
vo.tableCode = tableCode;
DataTable dt = svc.Select(vo, EntityEmrTableBasicInfo.Columns.tableCode);
if (dt != null && dt.Rows.Count > 0)
{
return(EntityTools.ConvertToEntityList <EntityEmrTableBasicInfo>(dt)[0]);
}
}
catch (Exception ex)
{
ExceptionLog.OutPutException(Function.GetExceptionCaption(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.FullName, System.Reflection.MethodBase.GetCurrentMethod().Name, ex.Message));
}
finally
{
svc = null;
}
return(null);
}
public void TestStruct()
{
DataObjectModel obj = new DataObjectModel();
obj.StructTest.MyEnum = Day.A2;
obj.StructTest.MyInt32 = 123;
obj.StructTest.MyString = "temp";
MyStruct m;
m.MyEnum = Day.A5;
m.MyInt32 = 999;
m.MyString = "testStruct";
EntityTools <DataObjectModel> .SetValue(obj, "StructTest", false, m);
Assert.AreEqual(m.MyEnum, obj.StructTest.MyEnum);
Assert.AreEqual(m.MyInt32, obj.StructTest.MyInt32);
Assert.AreEqual(m.MyString, obj.StructTest.MyString);
MyStruct d = (MyStruct)EntityTools <DataObjectModel> .GetValue(obj, "STRUCTTEST", true);
Assert.AreEqual(m.MyEnum, d.MyEnum);
Assert.AreEqual(m.MyInt32, d.MyInt32);
Assert.AreEqual(m.MyString, d.MyString);
}
/// <summary>
/// 重载实现过滤效果
/// </summary>
protected override void DoFilter()
{
DataTable dtNewSource = EntityTools.ConvertToDataTable <EntityCodeOperator>(GlobalDic.DataSourceEmployee);
dtNewSource.BeginLoadData();
DataColumn filterCol = new DataColumn("superFilterCol", Type.GetType("System.String"));
dtNewSource.Columns.Add(filterCol);
foreach (DataRow dr in dtNewSource.Rows)
{
string filterValue = "";
foreach (PopupTreeColumn col in base.columns)
{
filterValue += dr[col.FieldName].ToString() + "^";
}
dr[filterCol] = filterValue;
}
dtNewSource.EndLoadData();
string filter = this.Text.Trim().Replace("'", "''").Replace("[", "[[]");
dtNewSource.DefaultView.RowFilter = "superFilterCol like '%" + filter + "%'";
dtNewSource = dtNewSource.DefaultView.ToTable();
this.DataSource = dtNewSource;
if (dtNewSource.Rows.Count > 0)
{
base.ctlTreeList.FocusedNode = ctlTreeList.FindNodeByFieldValue(base.ValueMember, dtNewSource.Rows[0][base.ValueMember]);
}
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context)
{
var keyDto = acceptParam.AnalyzeParam <KeyReq <long> >();
if (keyDto == null || keyDto.Key <= 0)
{
return(ResultModel.GetParamErrorModel(string.Empty, "参数异常！"));
}
var idField = EntityTools.GetField <ArticleInfo>(nameof(ArticleInfo.Id));
var whereArr = new List <string>
{
SqlCharConst.DefaultWhere,
$"{idField} = {keyDto.Key}"
// $"Id = @Id"
};
var conn = context.GetConnection(appSetting.GetMysqlConn().FlagKey, appSetting.GetMysqlConn().ConnStr);
// var info = await DapperTools.GetItem<ArticleInfo>(conn, EntityTools.GetTableName<ArticleInfo>(), whereArr, new { Id = keyDto.Key});
var info = await DapperTools.GetItem <ArticleInfo>(conn, EntityTools.GetTableName <ArticleInfo>(), whereArr);
if (info == null)
{
return(ResultModel.GetParamErrorModel(string.Empty, "此文章不存在或已删除！"));
}
return(ResultModel.GetSuccessModel(String.Empty, info));
}
/// <summary>
/// GetQnSetting
/// </summary>
/// <returns></returns>
public List <EntityQnSetting> GetQnSetting(decimal qnId)
{
List <EntityQnSetting> data = null;
SqlHelper svc = new SqlHelper(EnumBiz.onlineDB);
List <EntityDicQnSetting> lstSet = EntityTools.ConvertToEntityList <EntityDicQnSetting>(svc.Select(new EntityDicQnSetting()
{
qnId = qnId
}, EntityDicQnSetting.Columns.qnId));
if (lstSet != null && lstSet.Count > 0)
{
data = new List <EntityQnSetting>();
// 获取题目
List <EntityDicQnSetting> lstTopic = lstSet.FindAll(t => t.isParent == 1);
if (lstTopic != null && lstTopic.Count > 0)
{
EntityQnSetting qnVo = null;
List <EntityDicQnSetting> lstItems = null;
foreach (EntityDicQnSetting item in lstTopic)
{
string qnDesc = " ";
lstItems = lstSet.FindAll(t => !string.IsNullOrEmpty(t.parentFieldId) && t.parentFieldId.Trim() != "" && t.parentFieldId == item.fieldId);
if (lstItems != null && lstItems.Count > 0)
{
lstItems.Sort();
int i = 0;
foreach (EntityDicQnSetting item2 in lstItems)
{
qnDesc += Convert.ToString(++i) + "、" + item2.fieldName + " ";
}
}
qnVo = new EntityQnSetting();
qnVo.qnId = item.qnId;
qnVo.isCheck = 0;
if (item.typeId == "1")
{
qnVo.className = "单选题";
}
else if (item.typeId == "2")
{
qnVo.className = "多选题";
}
else if (item.typeId == "3")
{
qnVo.className = "填空题";
}
else
{
qnVo.className = "其他";
}
qnVo.fieldId = item.fieldId;
qnVo.fieldName = " " + item.fieldName;
qnVo.sortNo = item.sortNo;
qnVo.qnDesc = qnDesc;
data.Add(qnVo);
}
}
}
return(data);
}
public async Task <ResultModel> Run(AcceptParam acceptParam, AppSetting appSetting, HttpContext context, long userId)
{
var req = acceptParam.AnalyzeParam <KeyReq <int> >();
if (req == null || req.Key <= 0)
{
return(ResultModel.GetParamErrorModel());
}
if (userId == req.Key)
{
return(ResultModel.GetParamErrorModel("查询人与被关注人相同"));
}
var conn = appSetting.GetMysqlConn(context);
var isExists = await DapperTools.IsExists(conn, EntityTools.GetTableName <AttentionInfo>(),
new[]
{
$"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.AttentionUser))} ={req.Key}",
$"{EntityTools.GetField<AttentionInfo>(nameof(AttentionInfo.UserId))} ={userId}",
$"{nameof(BaseModel.ValidFlag)}={(int) ValidFlagMenu.UseFul}"
});
return(ResultModel.GetSuccessModel(isExists));
}
/// <summary>
/// 转换IDataObject对象类型
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="objInput"></param>
/// <returns></returns>
public static T ChangeType <T>(IDataObject objInput) where T : IDataObject, new()
{
T t = new T();
Dictionary <string, MemberInfo> oldType = EntityTools.GetFieldListFromCache(objInput.GetType());
foreach (string s in oldType.Keys)
{
try
{
object o = objInput.GetValue(s);
if (o != null)
{
t.SetValue(s, o);
}
}
catch (Exception ex)
{
logger.Error(ex, "IDataObject转换类型错误");
}
}
return(t);
}
/// <summary>
/// 病理分类
/// </summary>
void LoadPisClass()
{
try
{
using (ProxyEntityFactory proxy = new ProxyEntityFactory())
{
GlobalParm.PisClass = EntityTools.ConvertToEntityList <EntityPisClass>(proxy.Service.SelectFullTable(new EntityPisClass()));
if (GlobalParm.PisClass == null)
{
GlobalParm.PisClass = new List <EntityPisClass>();
}
else
{
List <EntityFormDesign> data = EntityTools.ConvertToEntityList <EntityFormDesign>(proxy.Service.SelectFullTable(new EntityFormDesign()));
foreach (EntityPisClass item in GlobalParm.PisClass)
{
if (data.Any(t => t.Formid == (int)item.formId))
{
item.layout = data.FirstOrDefault(t => t.Formid == (int)item.formId).Layout;
}
}
}
}
}
catch (Exception e)
{
throw e;
}
}
