/// <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;
}
}
