/// <summary>
/// 设定
/// </summary>
/// <param name="pym"></param>
public bool setListData(string str, string code)
{
codepoara = code;
//按照拼音码取得疾病诊断
listboxFormBll listbox = new listboxFormBll();
DataTable dt = listbox.GetMoHuList(string.Format("and YLJGBM = '{0}'", UserInfo.Yybm), code);
if (dt != null && dt.Rows.Count > 0)
{
int length = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (length < dt.Rows[i]["czmc"].ToString().Length)
{
length = dt.Rows[i]["czmc"].ToString().Length;
}
}
checkedListBox_cz.ColumnWidth = length * 18 < 100 ? 100 : length * 18;
checkedListBox_cz.DataSource = dt;
checkedListBox_cz.DisplayMember = "czmc";
checkedListBox_cz.ValueMember = "czbm";
//设定选中项目
setItemSelect(str);
return(true);
}
else
{
this.Close();
return(false);
}
}
/// <summary>
/// 窗体初始化
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void Form_txmSet_Load(object sender, EventArgs e)
{
listboxFormBll listbox = new listboxFormBll();
isinit = true;
//条码初始化
DataTable dt_tm = listbox.GetMoHuList(string.Format("and YLJGBM='{0}' order by TMBM ", UserInfo.Yybm), "sql030");
if (dt_tm != null && dt_tm.Rows.Count > 0)
{
this.checkedListBox_tm.DataSource = dt_tm;
this.checkedListBox_tm.ValueMember = "TMBM";
this.checkedListBox_tm.DisplayMember = "TMMC";
}
//条码明细初始化
DataTable dt_mx = listbox.GetMoHuList(string.Format("and yybm='{0}' order by item_code ", UserInfo.Yybm), "sql_t_jk_lisitems_select");
if (dt_mx != null && dt_mx.Rows.Count > 0)
{
this.checkedListBox_MX.DataSource = dt_mx;
this.checkedListBox_MX.ValueMember = "item_code";
this.checkedListBox_MX.DisplayMember = "item_name";
}
//套餐初始化
DataTable dt_TC = listbox.GetMoHuList(string.Format("and yybm = '{0}' order by barcode ", UserInfo.Yybm), "sql_t_jk_barcodeclass_select");
if (dt_TC != null && dt_TC.Rows.Count > 0)
{
this.checkedListBox_TC.DataSource = dt_TC;
this.checkedListBox_TC.ValueMember = "BARCODE";
this.checkedListBox_TC.DisplayMember = "BARNAME";
for (int i = 0; i < dt_TC.Rows.Count; i++)
{
string BARCODE = dt_TC.Rows[i]["BARCODE"].ToString();
string ISDEFAUT = dt_TC.Rows[i]["ISDEFAUT"] != null?dt_TC.Rows[i]["ISDEFAUT"].ToString():"";
if (ISDEFAUT.Equals("1") == true)
{
//设定套餐选中状态
setItemSelectTc(BARCODE);
//设定条码选中状态
setItemSelectTm(BARCODE);
//设定条码明细
setItemSelectTm();
break;
}
}
}
isinit = false;
}
/// <summary>
/// 设定诊断信息
/// </summary>
/// <param name="pym"></param>
public bool setListData(string strWhere, string code)
{
//按照拼音码取得疾病诊断
listboxFormBll listbox = new listboxFormBll();
DataTable dt = listbox.GetMoHuList(string.Format("and pym like '%{0}%'", strWhere), code);
if (dt != null && dt.Rows.Count > 0)
{
listBox_com.DataSource = dt;
listBox_com.DisplayMember = "Name";
listBox_com.ValueMember = "Code";
return(true);
}
else
{
this.Close();
return(false);
}
}
/// <summary>
/// 设定诊断信息
/// </summary>
/// <param name="pym"></param>
public bool setListData(string strWhere, string code, Control textpara)
{
text = textpara;
//按照拼音码取得疾病诊断
listboxFormBll listbox = new listboxFormBll();
DataTable dt = listbox.GetMoHuList(strWhere, code);
if (dt != null && dt.Rows.Count > 0)
{
listBox_com.DataSource = dt;
listBox_com.DisplayMember = "ZDMC";
listBox_com.ValueMember = "ZDBM";
return(true);
}
else
{
//this.Close();
return(false);
}
}
/// <summary>
/// 设定选中条码
/// </summary>
/// <param name="BARCODE">套餐编码</param>
public void setItemSelectTm(string BARCODE)
{
listboxFormBll listbox = new listboxFormBll();
//条码初始化
DataTable dt = (DataTable)checkedListBox_tm.DataSource;
if (dt != null && dt.Rows.Count > 0)
{
for (int i = 0; i < dt.Rows.Count; i++)
{
checkedListBox_tm.SetItemCheckState(i, System.Windows.Forms.CheckState.Unchecked);
}
}
if (BARCODE == null || BARCODE.Length == 0)
{
return;
}
//条码初始化
DataTable dt_tm_tc = listbox.GetMoHuList(string.Format("and yybm='{0}' and barcode='{1}' order by bar_code ", UserInfo.Yybm, BARCODE), "sql_t_jk_barcodeclass_barcodeitem_select");
//string[] selectList = selectvalue.ToString().Split(new char[] { ',' });
if (dt_tm_tc == null || dt_tm_tc.Rows.Count == 0)
{
return;
}
for (int i = 0; i < dt_tm_tc.Rows.Count; i++)
{
for (int j = 0; j < dt.Rows.Count; j++)
{
if (dt_tm_tc.Rows[i]["BAR_CODE"].Equals(dt.Rows[j]["tmbm"].ToString()))
{
checkedListBox_tm.SetItemChecked(j, true);
break;
}
}
}
}
/// <summary>
/// 查询
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void button_select_Click(object sender, EventArgs e)
{
//按照拼音码取得疾病诊断
listboxFormBll listbox = new listboxFormBll();
string strwhere = "";
if (textBox_mc.Text.Trim().Length > 0)
{
strwhere = string.Format(" and T_BS_CUNZHUANG.B_NAME like '%{0}%'", textBox_mc.Text.Trim());
}
DataTable dt = listbox.GetMoHuList(string.Format("and YLJGBM = '{0}' {1}", UserInfo.Yybm, strwhere), codepoara);
if (dt != null && dt.Rows.Count > 0)
{
checkedListBox_cz.DataSource = null;
int length = 0;
for (int i = 0; i < dt.Rows.Count; i++)
{
if (length < dt.Rows[i]["czmc"].ToString().Length)
{
length = dt.Rows[i]["czmc"].ToString().Length;
}
}
checkedListBox_cz.ColumnWidth = length * 18 < 100 ? 100 : length * 18;
checkedListBox_cz.DataSource = dt;
checkedListBox_cz.DisplayMember = "czmc";
checkedListBox_cz.ValueMember = "czbm";
}
else
{
MessageBox.Show("没有查询到数据！");
}
}
private void Form_downLoad_Load(object sender, EventArgs e)
{
//progressBar_xz.Visible = false;
//取得前以页面传递的数据
//DataTable dtPara = (DataTable)((jktj)this.Owner).Tag;
//用户id
userId = dt_para_sys.Rows[0]["userId"].ToString();
//工作组
yhfz = dt_para_sys.Rows[0]["gzz"].ToString();
//医疗机构
yljg = dt_para_sys.Rows[0]["yljg"].ToString();
//取得医疗机构编码
Form_yljgBll Form_yljg = new Form_yljgBll();
DataTable dtYljg = Form_yljg.GetMoHuList("", "sql039");
//绑定医疗机构
comboBox_yljg.DataSource = dtYljg;
comboBox_yljg.DisplayMember = "mc";
comboBox_yljg.ValueMember = "bm";
comboBox_yljg.SelectedValue = yljg;
comboBox_yljg.Enabled = false;
//取得村庄
listboxFormBll listbox = new listboxFormBll();
DataTable dtCunzhuang = listbox.GetMoHuList(string.Format("and YLJGBM = '{0}'", UserInfo.Yybm), "sql038");
//绑定医疗机构
comboBox_cunzhuang.DataSource = dtCunzhuang;
comboBox_cunzhuang.DisplayMember = "czmc";
comboBox_cunzhuang.ValueMember = "czbm";
comboBox_cunzhuang.Focus();
}
/// <summary>
/// 窗体加载事件
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void AddForm_Load(object sender, EventArgs e)
{
//禁用列表自动创建列
dataGridView_list.AutoGenerateColumns = false;
DBAccess dBAccess = new DBAccess();
//取得村庄
// string sqlCunzhaung = @"SELECT T_BS_CUNZHUANG.B_RGID, T_BS_CUNZHUANG.B_NAME
// FROM T_TJ_YLJG_XIANGZHEN INNER JOIN T_BS_CUNZHUANG ON T_TJ_YLJG_XIANGZHEN.XZBM = left(T_BS_CUNZHUANG.B_RGID,len(T_TJ_YLJG_XIANGZHEN.XZBM))
//
// where T_TJ_YLJG_XIANGZHEN.YLJGBM='{YLJGBM}'
// order by T_BS_CUNZHUANG.B_RGID;";
// DataTable dtCunzhuang = dBAccess.ExecuteQueryBySql(sqlCunzhaung.Replace("{YLJGBM}", UserInfo.Yybm));
//AddFormBll addformbll_cz = new AddFormBll();
//DataTable dtCunzhuang = addformbll_cz.GetMoHuList(string.Format(" and YLJGBM='{0}' ", UserInfo.Yybm), "sql038_cunzhuang");
listboxFormBll listbox = new listboxFormBll();
DataTable dtCunzhuang = listbox.GetMoHuList(string.Format("and YLJGBM = '{0}'", UserInfo.Yybm), "sql038");
//绑定村庄
DataRow dtRow = dtCunzhuang.NewRow();
//dtRow["B_RGID"] = "";
//dtRow["B_NAME"] = "--请选择--";
dtRow["czbm"] = "";
dtRow["czmc"] = "--请选择--";
dtCunzhuang.Rows.InsertAt(dtRow, 0);
comboBox_cunzhuang.DataSource = dtCunzhuang;
//comboBox_cunzhuang.DisplayMember = "B_NAME";
//comboBox_cunzhuang.ValueMember = "B_RGID";
comboBox_cunzhuang.DisplayMember = "czmc";
comboBox_cunzhuang.ValueMember = "czbm";
comboBox_cunzhuang.SelectedValue = czbm;
comboBox_cunzhuang.Focus();
}
/// <summary>
/// 套餐条码明细改变处理
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void checkedListBox_MX_SelectedValueChanged(object sender, EventArgs e)
{
if (isinit == true)
{
return;
}
//条码编码
string selectstr = checkedListBox_tm.SelectedValue.ToString();
//明细编码
string selectstr_mx = checkedListBox_MX.SelectedValue.ToString();
CheckState checkResult_clieck = CheckState.Indeterminate;
if (dt_tc_mx != null && dt_tc_mx.Rows.Count > 0)
{
string str = checkedListBox_MX.GetItemText(((CheckedListBox)sender).SelectedItem);
//获取当前选项的状态 是否是选中
for (int i = 0; i < checkedListBox_MX.Items.Count; i++)
{
if (checkedListBox_MX.GetItemText(checkedListBox_MX.Items[i]).Equals(str) == true)
{
checkResult_clieck = checkedListBox_MX.GetItemCheckState(i);
}
}
//处理数据
if (checkResult_clieck != CheckState.Indeterminate)
{
bool isexist = false;
for (int i = 0; i < dt_tc_mx.Rows.Count; i++)
{
//存在选中的条码
if (dt_tc_mx.Rows[i]["item_code"].ToString().Equals(selectstr_mx))
{
//条码已经存在了
isexist = true;
//0:没有变化 1：增加 2：删除
//没有选中
if (checkResult_clieck == CheckState.Unchecked)
{
dt_tc_mx.Rows[i]["zt"] = "2";
}
else if (checkResult_clieck == CheckState.Checked) //选中
{
dt_tc_mx.Rows[i]["zt"] = "1";
}
}
}
//新选中的条码在套餐中不存在，添加到套餐中
if (isexist == false && checkResult_clieck == CheckState.Checked)
{
string yybm = UserInfo.Yybm;
string barcode = checkedListBox_TC.SelectedValue.ToString(); //套餐编码
string tmbm = checkedListBox_tm.SelectedValue.ToString(); //条码编码
string tmmc = checkedListBox_tm.GetItemText(((CheckedListBox)sender).SelectedItem); //条码名称
listboxFormBll listbox = new listboxFormBll();
DataTable dt_tm_mx = listbox.GetMoHuList(string.Format("and yybm='{0}' order by item_code ", UserInfo.Yybm), "sql_t_jk_lisitems_select");
if (dt_tm_mx != null && dt_tm_mx.Rows.Count > 0)
{
for (int i = 0; i < dt_tm_mx.Rows.Count; i++)
{
//明细编码
string item_code = dt_tm_mx.Rows[i]["item_code"].ToString();; //明细编码
string item_name = dt_tm_mx.Rows[i]["item_name"].ToString();; //明细名称
string shortname = dt_tm_mx.Rows[i]["shortname"].ToString();; //简称
//条码编码
// string tc_mc_tmbm = dt_tm_mx.Rows[i]["tmbm"].ToString();
//string tc_mc_tmmc = dt_tm_mx.Rows[i]["tmmc"].ToString();
if (item_code.Equals(selectstr_mx) == true)
{
dt_tc_mx.Rows.Add();
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["yybm"] = yybm;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["barcode"] = barcode;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["tmbm"] = tmbm;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["tmmc"] = tmmc;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["item_code"] = item_code;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["item_name"] = item_name;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["shortname"] = shortname;
dt_tc_mx.Rows[dt_tc_mx.Rows.Count - 1]["zt"] = "1";
break;
}
}
}
}
}
//setItemSelectTm();
}
}
/// <summary>
/// 设定条码明细
/// </summary>
/// <param name="BARCODE">套餐编码</param>
public void setItemSelectTm()
{
listboxFormBll listbox = new listboxFormBll();
//checkedListBox_MX.Items.Clear();
//条码明细初始化
DataTable dt_mx = listbox.GetMoHuList(string.Format("and yybm='{0}' order by item_code ", UserInfo.Yybm), "sql_t_jk_lisitems_select");
if (dt_mx != null && dt_mx.Rows.Count > 0)
{
this.checkedListBox_MX.DataSource = dt_mx;
this.checkedListBox_MX.ValueMember = "item_code";
this.checkedListBox_MX.DisplayMember = "item_name";
}
//条码明细
DataTable dt_tm_mx = listbox.GetMoHuList(string.Format("and yljgbm='{0}' order by item_code ", UserInfo.Yybm), "sql_tm_mx_select");
if (dt_tm_mx != null && dt_tm_mx.Rows.Count > 0)
{
for (int i = 0; i < dt_tm_mx.Rows.Count; i++)
{
//明细编码
string tc_mc_item_code = dt_tm_mx.Rows[i]["item_code"].ToString();
//条码编码
string tc_mc_tmbm = dt_tm_mx.Rows[i]["tmbm"].ToString();
string tc_mc_tmmc = dt_tm_mx.Rows[i]["tmmc"].ToString();
for (int j = 0; j < dt_mx.Rows.Count; j++)
{
if (tc_mc_item_code.Equals(dt_mx.Rows[j]["item_code"].ToString()) == true)
{
//设定选中状态
dt_mx.Rows[j]["item_name"] = dt_mx.Rows[j]["item_name"] + " | " + tc_mc_tmmc;
}
}
}
}
////条码初始化
//DataTable dt_MX = (DataTable)checkedListBox_MX.DataSource;
//if (dt_MX != null && dt_MX.Rows.Count > 0)
//{
// for (int i = 0; i < dt_MX.Rows.Count; i++)
// {
// checkedListBox_MX.SetItemCheckState(i, System.Windows.Forms.CheckState.Unchecked);
// }
//}
//套餐编码
string BARCODE = checkedListBox_TC.SelectedValue.ToString();
//条码编码
string tmbm = checkedListBox_tm.SelectedValue.ToString();
//套餐条码明细
if (dt_tc_mx == null)
{
DataTable dt_mx_TC = listbox.GetMoHuList(string.Format("and yybm='{0}' and barcode='{1}' order by tmbm ", UserInfo.Yybm, BARCODE), "sql_tc_tm_mx_select");
if (dt_mx_TC != null && dt_mx_TC.Rows.Count > 0)
{
if (dt_mx_TC.Columns.Contains("zt") == false)
{
DataColumn dtc = new DataColumn();
//0:没有变化 1：增加 2：删除
dtc.DefaultValue = "0";
dtc.ColumnName = "zt";
dt_mx_TC.Columns.Add(dtc);
}
dt_tc_mx = dt_mx_TC.Copy();
}
}
//dt_mx_TC = dt_TC;
if (dt_tc_mx != null && dt_tc_mx.Rows.Count > 0)
{
for (int i = 0; i < dt_tc_mx.Rows.Count; i++)
{
//明细编码
string tc_mc_item_code = dt_tc_mx.Rows[i]["item_code"].ToString();
//条码编码
string tc_mc_tmbm = dt_tc_mx.Rows[i]["tmbm"].ToString();
string tc_mc_tmmc = dt_tc_mx.Rows[i]["tmmc"].ToString();
string tc_mc_zt = dt_tc_mx.Rows[i]["zt"].ToString();
for (int j = 0; j < dt_mx.Rows.Count; j++)
{
if (tc_mc_item_code.Equals(dt_mx.Rows[j]["item_code"].ToString()) == true)
{
//设定选中状态
//dt_mx.Rows[j]["item_name"] = dt_mx.Rows[j]["item_name"] + " | " + tc_mc_tmmc;
if (tmbm.Equals(tc_mc_tmbm) == true)
{
if (tc_mc_zt.Equals("2") == true)
{
checkedListBox_MX.SetItemCheckState(j, System.Windows.Forms.CheckState.Unchecked);
}
else
{
checkedListBox_MX.SetItemCheckState(j, System.Windows.Forms.CheckState.Checked);
}
}
else
{
if (tc_mc_zt.Equals("2") == true)
{
checkedListBox_MX.SetItemCheckState(j, System.Windows.Forms.CheckState.Unchecked);
}
else
{
checkedListBox_MX.SetItemCheckState(j, System.Windows.Forms.CheckState.Indeterminate);
}
}
}
}
}
}
////条码初始化
//DataTable dt_tm_tc = listbox.GetMoHuList(string.Format("and yybm='{0}' and barcode='{1}' order by bar_code ", UserInfo.Yybm, BARCODE), "sql_t_jk_barcodeclass_barcodeitem_select");
////string[] selectList = selectvalue.ToString().Split(new char[] { ',' });
//if (dt_tm_tc == null || dt_tm_tc.Rows.Count == 0)
//{
// return;
//}
//for (int i = 0; i < dt_tm_tc.Rows.Count; i++)
//{
// for (int j = 0; j < dt.Rows.Count; j++)
// if (dt_tm_tc.Rows[i]["BAR_CODE"].Equals(dt.Rows[j]["tmbm"].ToString()))
// {
// checkedListBox_tm.SetItemChecked(j, true);
// break;
// }
//}
}
