/// <summary> /// 国别选中后,更新模板,货币与数据表项 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void cbxAgentCs_SelectedIndexChanged(object sender, EventArgs e) { AGENT_COUNTRY ac = (AGENT_COUNTRY)cbxAgentCs.SelectedItem; // 国别信息 Added by CYQ 2018-07-12 lblCurrent.Text = "1" + ac.AC_CURRENCY + "="; // 设置国别对应的货币 ACID = ac.AC_ID; // 国别ID Added by CYQ 2018-07-12 TIID = (int)db.AGENT_COUNTRies.SingleOrDefault(a => a.AC_ID == ac.AC_ID).AC_TIID; // 国别模板ID Modified by CYQ 2018-07-12 TEMPLATE_INFO ti = db.TEMPLATE_INFOs.SingleOrDefault(a => a.TI_ID == TIID); // 获取国别对应的模板信息 Added by CYQ 2018-07-12 if (ti == null) { MessageBox.Show("此国别尚未设置导入模板", this.funName, MessageBoxButtons.OK); return; } BuildColumns(ti); // 根据模板构建表格显示的列结构 Added by CYQ 2018-07-12 }
/// <summary> /// 新建或更改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnNew_Click(object sender, EventArgs e) { if (!checkInput()) { MessageBox.Show("请检查输入项", this.funName, MessageBoxButtons.OK); return; } if (this.Flag == "NEW") { var d = db.AGENT_COUNTRies.SingleOrDefault(a => (a.AC_AIID == ((AGENT_INFO)cbxAgents.SelectedItem).AI_ID && a.AC_NAME == txtCountry.Text.Trim())); if (d != null) { MessageBox.Show("此条记录已存在,请检查"); return; } AGENT_COUNTRY ac = new AGENT_COUNTRY { AC_AIID = ((AGENT_INFO)cbxAgents.SelectedItem).AI_ID, AC_ISDEL = false, AC_CURRENCY = ((CURRENCY)cbxCurrency.SelectedItem).C_NAME, AC_NAME = txtCountry.Text.Trim(), AC_TIID = ((TEMPLATE_INFO)cbxTempName.SelectedItem).TI_ID, }; db.AGENT_COUNTRies.InsertOnSubmit(ac); db.SubmitChanges(); MessageBox.Show("添加成功", this.funName, MessageBoxButtons.OK); this.DialogResult = System.Windows.Forms.DialogResult.OK; } else { AGENT_COUNTRY ac = db.AGENT_COUNTRies.Where(a => a.AC_ID == ACID).SingleOrDefault(); ac.AC_CURRENCY = ((CURRENCY)cbxCurrency.SelectedItem).C_NAME; ac.AC_NAME = txtCountry.Text.Trim(); ac.AC_TIID = ((TEMPLATE_INFO)cbxTempName.SelectedItem).TI_ID; db.SubmitChanges(); MessageBox.Show("修改成功", this.funName, MessageBoxButtons.OK); this.DialogResult = System.Windows.Forms.DialogResult.OK; } }