前端代码:
// 加载事件
OnLoad:function(){
var self=this;
//向后台发送请求获取医院信息
$.SmartForm.PostForm("searchHospital",{},
function(res){
// console.log(res);
if(res.Successful == true){
self.hospitalname.ClearItems();//清空
var hospitalList = [];
hospitalList = res.ReturnData.hospitalList;
//渲染下拉列表
hospitalList.map((item,index)=>{
self.hospitalname.AddItem(item.ValueTable.hospitalname)
})
}
},
function(err){
$.IShowError( "错误" + err);
},false);
后端代码:
protected override void OnSubmit(string actionName, H3.SmartForm.SmartFormPostValue postValue, H3.SmartForm.SubmitSmartFormResponse response)
{
///查询医院列表
if(actionName == "searchHospital")
{
///获取当前登录用户ID
string userid = this.Request.UserContext.UserId;
///编写SQL
string sql = "select hospitalname from i_D000867hospital";
///执行SQL语句
System.Data.DataTable dtAcount = this.Engine.Query.QueryTable(sql, null);
///声明集合
List < H3.Data.Serialization.VirtualObject > virtualList = new List<H3.Data.Serialization.VirtualObject>();
///判断table不为空
if(!Convert.IsDBNull(dtAcount))
{
///循环table行
foreach(System.Data.DataRow row in dtAcount.Rows)
{
///创建虚拟对象
H3.Data.Serialization.VirtualObject obj = new H3.Data.Serialization.VirtualObject();
///赋值医院名称
obj.ValueTable["hospitalname"] = row["hospitalname"].ToString();
///添加到集合
virtualList.Add(obj);
}
}
response.Message = "查询医院列表";
///声明response.ReturnData
response.ReturnData = new Dictionary<string, object>();
///添加到response.ReturnData中
response.ReturnData.Add("hospitalList", virtualList);
}