MedicalInsurance/GuiYang_YinHai/GuiYangMI/Forms/AddSignleDirectory.cs

using Newtonsoft.Json.Linq;
using PTMedicalInsurance.Helper;
using PTMedicalInsurance.Variables;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace PTMedicalInsurance
{


    public partial class AddSingleDirectory : Form
    {
        private int direcType ;
        public JObject joPamam = new JObject();
        private string chargeItemLevel;
        private string chargeItemLevelName;
        private string categoryCode;
        private string categoryName;
        public AddSingleDirectory()
        {
            InitializeComponent();
        }

        public AddSingleDirectory(int direcType)
        {
            InitializeComponent();
            this.direcType = direcType;
            cbxDirecType.SelectedIndex = this.direcType;
            initForm();
        }

        public AddSingleDirectory(int direcType,DataRow dr)
        {
            InitializeComponent();
            this.direcType = direcType;
            cbxDirecType.SelectedIndex = this.direcType;
            initForm();
            setValue(dr);

        }

        private void pnlClient_Paint(object sender, PaintEventArgs e)
        {

        }

        private void btnNo_Click(object sender, EventArgs e)
        {
            DialogResult = DialogResult.Cancel;
        }

        private void setTextBoxEnabled(bool b)
        {
            Control.ControlCollection sonControls = pnlClient.Controls;
            //遍历所有控件
            foreach (Control control in sonControls)
            {
                if (control is TextBox) control.Enabled = b;
            }
        }
        private bool getFlag(string value)
        {
            if (value == "")
            {
                return false;
            }

            if (value == "1")
            {
                return true;
            }
            else
            {
                return false;
            }
        }


        private void initForm()
        {
            setTextBoxEnabled(true);
            switch (direcType)
            {
                case 0:
                    {
                        initDrugForm();
                        break;
                    }
                case 2:
                    {
                        initDrugForm();
                        break;
                    }
            }
        }
        //private void setValue(DataRow dr)
        //{
        //    switch (direcType)
        //    {
        //        case 0:
        //            {
        //                setDrugInfo(dr);
        //                break;
        //            }
        //    }
        //}
        private void setValue(DataRow dr)
        {
            try
            {
                tbCode.Text = dr["Code"].ToString();
                tbName.Text = dr["Name"].ToString();
                tbLocateCode.Text = dr["LocateCode"].ToString();
                tbSafetyCode.Text = dr["DrugSafetyStandardCode"].ToString();
                tbDosageName.Text = dr["DosageFormName"].ToString();
                tbDosageCode.Text = dr["DosageFormCode"].ToString();
                categoryCode = dr["CategoryCode"].ToString();
                DataTable dt = (DataTable)dblkcbxCategory.DataSource;
                for (int i = 0; i < dt.Rows.Count; i++)
                {
                    if (dt.Rows[i]["Code"].ToString() == categoryCode)
                    {
                        dblkcbxChargeItemType.Text=dblkcbxCategory.Text = categoryName =dt.Rows[i]["Name"].ToString();
                    }
                }

                tbSpecification.Text = dr["Specification"].ToString();
                tbUnitOfPackag.Text = dr["UnitOfPackag"].ToString();
                tbUnitOfValuation.Text = dr["UnitOfValuation"].ToString();
                tbStartDate.Text = dr["StartDate"].ToString();
                tbEndDate.Text = dr["EndDate"].ToString();
                tbPinyinSearchCode.Text = dr["PinyinSearchCode"].ToString();
                rtbInstructions.Text = dr["Instructions"].ToString();
                rtbExceptContent.Text = dr["ExceptContent"].ToString();
                rtbConnotation.Text = dr["Connotation"].ToString();
                rtbLimitRange.Text = dr["LimitRange"].ToString();
                tbNote.Text = dr["Note"].ToString();
                tbApprovalNO.Text = dr["ApprovalNO"].ToString();
                tbVersionNO.Text = dr["VersionNO"].ToString();
                tbVersionName.Text = dr["VersionName"].ToString();
                cbUseFlag.Checked = getFlag(dr["UseFlag"].ToString());
                cbSpecialFlag.Checked = getFlag(dr["SpecialFlag"].ToString());
                cbLimitFlag.Checked = getFlag(dr["LimitFlag"].ToString());
                cbValidFlag.Checked = getFlag(dr["ValidFlag"].ToString());
                tbUniqueRecordNO.Text = dr["UniqueRecordNO"].ToString();
                tbNationalCode.Text = dr["NationalCode"].ToString();
                tbNationalName.Text = dr["NationalName"].ToString();
                tbManufacturers.Text = dr["Manufacturers"].ToString();
                if (dr["ChargeItemLevel"].ToString() != "")
                {
                    chargeItemLevel = dr["ChargeItemLevel"].ToString();
                    DataTable dt1 = (DataTable)dblkcbxChargeItemLevel.DataSource;
                    for (int i = 0; i < dt1.Rows.Count; i++)
                    {
                        if (dt1.Rows[i]["Code"].ToString() == categoryCode)
                        {
                            dblkcbxChargeItemLevel.Text = chargeItemLevelName = dt1.Rows[i]["Name"].ToString();
                        }
                    }
                }
                else
                {
                    dblkcbxChargeItemLevel.Text = "";
                }
                
                //tbCompany.Text = dr["Company"].ToString();
            }
            catch (Exception ex)
            {
                MessageBox.Show("setDrugInfo" + ex.Message);
            }
        }
        private void AssignToJoParam()
        {
            string hisTypeName = cbxDirecType.Text;


            string pym = tbPinyinSearchCode.Text;
            if (tbPinyinSearchCode.Text == "")
            {
                pym = "";
            }

            joPamam.Add("Code",tbCode.Text);
            joPamam.Add("Name", tbName.Text);
            joPamam.Add("HisType",direcType + 1);
            joPamam.Add("HisTypeName", hisTypeName);
            joPamam.Add("LocateCode", tbLocateCode.Text);
            joPamam.Add("LocateName", tbLocateName.Text);
            joPamam.Add("DrugSafetyStandardCode", tbSafetyCode.Text);
            joPamam.Add("DosageFormCode", tbDosageCode.Text);
            joPamam.Add("DosageFormName", tbDosageName.Text);
            joPamam.Add("CategoryCode", categoryCode);
            joPamam.Add("CategoryName", categoryName);
            joPamam.Add("Specification", tbSpecification.Text);
            joPamam.Add("SpecificationCode", "");
            joPamam.Add("UnitOfPackag", tbUnitOfPackag.Text);
            joPamam.Add("UnitOfValuation", tbUnitOfValuation.Text);
            joPamam.Add("StartDate", tbStartDate.Text);
            joPamam.Add("EndDate", tbEndDate.Text);
            joPamam.Add("PinyinSearchCode", pym);
            joPamam.Add("Instructions", rtbInstructions.Text);
            joPamam.Add("ExceptContent", rtbExceptContent.Text);
            joPamam.Add("Connotation", rtbConnotation.Text);
            joPamam.Add("Note", tbNote.Text);
            joPamam.Add("ValidFlag", Convert.ToInt32(cbValidFlag.Checked));
            joPamam.Add("ApprovalNO", tbApprovalNO.Text);
            joPamam.Add("VersionNO", tbVersionNO.Text);
            joPamam.Add("VersionName", tbVersionName.Text);
            joPamam.Add("UseFlag", Convert.ToInt32(cbUseFlag.Checked));
            joPamam.Add("SpecialFlag", Convert.ToInt32(cbSpecialFlag.Checked));
            joPamam.Add("LimitFlag", Convert.ToInt32(cbLimitFlag.Checked));
            joPamam.Add("LimitRange", rtbLimitRange.Text);
            joPamam.Add("UniqueRecordNO", tbUniqueRecordNO.Text);
            joPamam.Add("NationalCode", tbNationalCode.Text);
            joPamam.Add("NationalName", tbNationalName.Text);
            joPamam.Add("Manufacturers", tbManufacturers.Text);
            joPamam.Add("UpdateTime", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
            joPamam.Add("ChargeItemType", categoryCode);
            joPamam.Add("ChargeItemLevel", chargeItemLevel);
            joPamam.Add("ChargeItemLevelName", chargeItemLevelName);
            joPamam.Add("Company", tbCompany.Text);
        }
        private void initDrugForm()
        {
            lbApprovalNO.ForeColor = Color.Red;
            lbSpecification.ForeColor = Color.Red;
            lbManufacturers.ForeColor = Color.Red;
            lbUnitOfPackag.ForeColor = Color.Red;
            lbCompany.ForeColor = Color.Red;

            //字典类，目录类查询都用区域医保对应的接口目录DR
            string sqlCondition = " and A.Interface_Dr = '" + Global.inf.InsuRegionInterfaceDr.ToString() + "'";
            //大类编码，收费项目类别
            string sqlStr = "SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr  WHERE A.InsuCode = 'medChrgitmType'" + sqlCondition;
            SetDBLKCombox(ref dblkcbxCategory, sqlStr);
            SetDBLKCombox(ref dblkcbxChargeItemType, sqlStr);
            // 收费项目等级（统计类型）
            sqlStr = "SELECT B.Code,B.Descripts AS Name FROM HB_Dictionary A JOIN HB_DictionaryDataDetail B ON A.ID = B.HBDictionary_Dr  WHERE A.InsuCode = 'chrgitmLv'" + sqlCondition;
            SetDBLKCombox(ref dblkcbxChargeItemLevel, sqlStr);
        }

        private void SetDBLKCombox(ref PTControl.DBLookupCombox dblcbx, string sqlStr)
        {
            dblcbx.sDisplayField = "Code,Name,SearchCode";
            dblcbx.sDisplayMember = "名称";
            dblcbx.sKeyWords = "Code,SearchCode";
            dblcbx.DataSource = GetDBLKComboxTable(sqlStr);
            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;
        }

        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 = "编码";
            //dt.Columns[1].ColumnName = "名称";
            //dt.Columns[2].ColumnName = "拼音查找码";
            return dt;
        }

        private void btnYes_Click(object sender, EventArgs e)
        {
            AssignToJoParam();
            DialogResult = DialogResult.OK;
        }

        private void dblkcbxCategory_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            categoryCode = dataRow["Code"].ToString().Trim();
            categoryName = dataRow["Name"].ToString().Trim();
        }

        private void dblkcbxChargeItemLevel_AfterSelector(object sender, PTControl.AfterSelectorEventArgs e)
        {
            DataGridViewRow row = e.Value as DataGridViewRow;
            DataRowView dataRow = row.DataBoundItem as DataRowView;

            chargeItemLevel = dataRow["Code"].ToString().Trim();
            chargeItemLevelName = dataRow["Name"].ToString().Trim();
        }
    }
}