using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using PTMedicalInsurance.Common;
using PTMedicalInsurance.Helper;
using PTMedicalInsurance.Business;
using Newtonsoft.Json.Linq;
using System.Data;
using System.Windows.Forms;
namespace PTMedicalInsurance.FormSetter
{
class ComboxSetter
{
private InvokeHelper invoker = new InvokeHelper();
private HisIrisServices hIS = new HisIrisServices();
private MIIrisServices mIS = new MIIrisServices();
public void setCbxInterfaceDataSource(Sunny.UI.UIComboBox cbx)
{
DataTable dt = new DataTable();
JObject joRtn = mIS.getInterface();
JArray jaParams = new JArray();
jaParams = JArray.Parse(JsonHelper.getDestValue(joRtn, "result.data"));
if (jaParams.Count == 0)
{
DataTableSetter dts = new DataTableSetter();
dt = dts.setDgvInterfaceDataTable();
return;
}
else
{
dt = (DataTable)jaParams.ToObject(typeof(DataTable));
}
dt.AcceptChanges();
cbx.DataSource = dt;
cbx.DisplayMember = "InterfaceName";
cbx.ValueMember = "ID";
}
public void setCbxDictionaryDataSource(string interfaceDr, string dicType, Sunny.UI.UIComboBox cbx)
{
InsuServices iris = new InsuServices();
DataTable dt = new DataTable();
JObject joRtn = iris.getSpecDictionary(interfaceDr, dicType);
JArray jaParams = new JArray();
jaParams = JArray.Parse(JsonHelper.getDestValue(joRtn, "result.data"));
if (jaParams.Count == 0)
{
DataTableSetter dts = new DataTableSetter();
dt = dts.setDgvInterfaceDataTable();
return;
}
else
{
dt = (DataTable)jaParams.ToObject(typeof(DataTable));
//Global.inf.interfaceDr_Download = int.Parse(dt.Rows[0]["ID"].ToString());
}
dt.AcceptChanges();
cbx.DataSource = dt;
cbx.DisplayMember = "name";
cbx.ValueMember = "code";
}
public string getCbxSelectedValue(Sunny.UI.UIComboBox cbx, string selectedName)
{
try
{
DataTable dt = (DataTable)cbx.DataSource;
int a = cbx.SelectedIndex;
return dt.Rows[a][selectedName].ToString();
}
catch (Exception ex)
{
return "";
}
}
#region DBLookupCombox设置
private DataTable GetDBLKComboxTable(string sqlStr)
{
InvokeHelper invoker = new InvokeHelper();
dynamic joInparm = new JObject();
dynamic joTmp = new JObject();
joTmp.sqlStr = sqlStr;
JArray jaParams = new JArray();
jaParams.Add(joTmp);
joInparm.Add("params", JArray.FromObject(jaParams));
joInparm.code = "09010014";
string inParam = joInparm.ToString();
JObject joRtn = invoker.invokeInsuService(inParam, "获取下拉框消息");
//dynamic jsonRtn = JsonConvert.DeserializeObject(strRtn);
DataTable dt = (DataTable)joRtn["result"].ToObject(typeof(DataTable));
//dt.Columns[0].ColumnName = "编码";d
//dt.Columns[1].ColumnName = "名称";
//dt.Columns[2].ColumnName = "拼音查找码";
return dt;
}
public DataTable GetDBLKComboxTable(JObject jo,string path)
{
JArray ja = JArray.Parse(JsonHelper.getDestValue(jo,path));
DataTable dt = (DataTable)ja.ToObject(typeof(DataTable));
return dt;
}
public DataTable GetDBLKComboxTable(JArray ja)
{
DataTable dt = (DataTable)ja.ToObject(typeof(DataTable));
return dt;
}
private void SetDBLKCombox(ref PTControl.DBLookupCombox dblcbx, string sqlStr)
{
SetDBLKCombox(ref dblcbx, GetDBLKComboxTable(sqlStr));
}
public void SetDBLKCombox(ref PTControl.DBLookupCombox dblcbx, DataTable dt)
{
dblcbx.sDisplayField = "Code,Name,SearchCode";
dblcbx.sDisplayMember = "名称";
dblcbx.sKeyWords = "Code,SearchCode";
dblcbx.DataSource = dt;
dblcbx.RowFilterVisible = true;
dblcbx.TextBox.Width = 400;
dblcbx.DataGridView.Width = 400;
dblcbx.DataGridView.Columns[0].Name = "编码";
dblcbx.DataGridView.Columns[1].Name = "名称";
dblcbx.DataGridView.Columns[2].Name = "查找码";
dblcbx.DataGridView.Columns[0].Width = 100;
dblcbx.DataGridView.Columns[1].Width = 200;
}
///
/// 格式化combobox为下拉框指定格式
///
///
///
///
///
public DataTable FormatComboxDatasource(DataTable sourceTable, string code, string desc)
{
// 使用 LINQ 查询源 DataTable
var query = from row in sourceTable.AsEnumerable()
select new { Code = row.Field(code), Name = row.Field(desc) };
// 创建新的 DataTable
DataTable resultTable = new DataTable();
resultTable.Columns.Add("Code", typeof(string));
resultTable.Columns.Add("Name", typeof(string));
resultTable.Columns.Add("SearchCode", typeof(string));
// 将查询结果添加到新的 DataTable
foreach (var item in query)
{
resultTable.Rows.Add(item.Code, item.Name, item.Name);
}
return resultTable;
}
public void AfterSelector(object sender, PTControl.AfterSelectorEventArgs e, out string code, out string name)
{
DataGridViewRow row = e.Value as DataGridViewRow;
DataRowView dataRow = row.DataBoundItem as DataRowView;
code = dataRow["Code"].ToString().Trim();
name = dataRow["Name"].ToString().Trim();
}
#endregion
}
}