private void btnDelSel_Click(object sender, EventArgs e)
{
if (lstByWord.SelectedIndex < 0)
{
MessageBox.Show("请选择要删除的数据！", "温馨提示：");
return;
}
int nValID = lisVal[lstByWord.SelectedIndex].ID;
lstByWord.BeginUpdate();
bool bRs = IdexItemMag.DelKeyVal(nValID);
if (bRs)
{
this.lstByWord.SelectedValueChanged -= this.lstByWord_SelectedIndexChanged;
lisVal.RemoveAt(lstByWord.SelectedIndex);
lstByWord.DataSource = null;
lstByWord.DataSource = lisVal;
lstByWord.ValueMember = "id";
lstByWord.DisplayMember = "val";
MessageBox.Show("删除成功！", "温馨提示：");
this.lstByWord.SelectedIndexChanged += new System.EventHandler(this.lstByWord_SelectedIndexChanged);
}
else
{
MessageBox.Show("删除失败，请重试！", "温馨提示：");
}
lstByWord.EndUpdate();
}
private void InitData()
{
lisVal = IdexItemMag.getVal(nKeyId);
lstByWord.DataSource = lisVal;
lstByWord.ValueMember = "id";
lstByWord.DisplayMember = "val";
}
private void btnUpKeyName_Click(object sender, EventArgs e)
{
bool bRs = IdexItemMag.UpdateKey(txbByItemName.Text.Trim(), BLL.SysMag.Login.StrLoginUserID, nKeyId.ToString());
if (bRs)
{
MessageBox.Show("修改成功！", "温馨提示：");
}
else
{
MessageBox.Show("修改失败，请重试！", "温馨提示：");
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (lstByWord.SelectedIndex < 0)
{
MessageBox.Show("请选择要修改的数据！", "温馨提示：");
return;
}
string strByWord = this.txbWord.Text.ToString().Trim(); //获取标引词
if (strByWord == "") //判断是否为空
{
MessageBox.Show("请填写标引词！", "温馨提示：");
txbWord.Focus();
return;
}
foreach (var item in lstByWord.Items)
{
if (((DAL.IDXVAL)item).VAL.Equals(strByWord))
{
MessageBox.Show("该标引词已存在,请确认！", "温馨提示：");
txbWord.Focus();
return;
}
}
bool bRs = IdexItemMag.UpdateVal(strByWord, BLL.SysMag.Login.StrLoginUserID, lisVal[lstByWord.SelectedIndex].ID.ToString());
if (bRs)
{
this.lstByWord.SelectedValueChanged -= this.lstByWord_SelectedIndexChanged;
lstByWord.BeginUpdate();
lisVal[lstByWord.SelectedIndex].VAL = strByWord;
lstByWord.DataSource = null;
lstByWord.DataSource = lisVal;
lstByWord.ValueMember = "id";
lstByWord.DisplayMember = "val";
lstByWord.EndUpdate();
MessageBox.Show("修改成功！", "温馨提示：");
this.lstByWord.SelectedIndexChanged += new System.EventHandler(this.lstByWord_SelectedIndexChanged);
}
else
{
MessageBox.Show("修改失败，请重试！", "温馨提示：");
}
}
private void InitByTree()
{
trvByItmes.Nodes.Clear();
//序号,a.id,a.idx_key as 标引项,b.Lname as 创建人, 标引词
DataTable dt = IdexItemMag.getSysKey("", "", 1, int.MaxValue);
if (dt == null || dt.Rows.Count == 0)
{
return;
}
foreach (DataRow drItem in dt.Rows)
{
}
}
private void button3_Click(object sender, EventArgs e)
{
string strByWord = this.txbWord.Text.ToString().Trim(); //获取标引词
if (strByWord == "") //判断是否为空
{
MessageBox.Show("请填写标引词！", "温馨提示：");
txbWord.Focus();
return;
}
foreach (var item in lstByWord.Items)
{
if (((DAL.IDXVAL)item).VAL.Equals(strByWord))
{
MessageBox.Show("该标引词已存在,请确认！", "温馨提示：");
txbWord.Focus();
return;
}
}
int nOutValID = -1;
bool bRs = IdexItemMag.AddNewVal(txbWord.Text.Trim(), nKeyId.ToString(), BLL.SysMag.Login.StrLoginUserID, out nOutValID);
if (bRs)
{
this.lstByWord.SelectedValueChanged -= this.lstByWord_SelectedIndexChanged;
lstByWord.BeginUpdate();
DAL.IDXVAL valItem = new DAL.IDXVAL();
valItem.ID = nOutValID;
valItem.VAL = txbWord.Text.Trim();
lisVal.Add(valItem);
lstByWord.DataSource = null;
lstByWord.DataSource = lisVal;
lstByWord.ValueMember = "id";
lstByWord.DisplayMember = "val";
lstByWord.EndUpdate();
MessageBox.Show("添加成功！", "温馨提示：");
this.lstByWord.SelectedIndexChanged += new System.EventHandler(this.lstByWord_SelectedIndexChanged);
}
else
{
MessageBox.Show("添加失败，请重试！", "温馨提示：");
}
}
private void 除ToolStripMenuItem_Click(object sender, EventArgs e)
{
this.Cursor = Cursors.WaitCursor;
DataGridViewCell cell = (DataGridViewCell)dgvListData.SelectedRows[0].Cells["Idx"];
string strPID = cell.Value.ToString();
if (IdexItemMag.DelKey(int.Parse(strPID)))
{
MessageBox.Show("数据删除成功！", "温馨提示：");
LoadData(true);
}
else
{
MessageBox.Show("数据删除失败,请重试！", "温馨提示：");
}
this.Cursor = Cursors.Default;
}
private void SaveRgIdx()
{
List <IDXKeyVAL> idxKeyVal = new List <IDXKeyVAL>();
foreach (Control cItem in tabRgby.Controls)
{
if (!(cItem is GroupBox))
{
continue;
}
GroupBox grb = (GroupBox)cItem;
CheckedListBox chkboxTmp = (CheckedListBox)grb.Controls[0];
foreach (IDXVAL idxValItem in chkboxTmp.CheckedItems)
{
idxKeyVal.Add(new IDXKeyVAL()
{
IDXUser = int.Parse(BLL.SysMag.Login.StrLoginUserID),
KeyID = idxValItem.KeyID.Value,
Valid = idxValItem.ID,
SiD = strSidKey,
ZID = int.Parse(strZtId),
IDXDate = DateTime.Now
});
}
}
if (IdexItemMag.UpdateKeyVal(strSidKey, int.Parse(strZtId), idxKeyVal))
{
MessageBox.Show("数据修改成功！", "温馨提示：");
}
else
{
MessageBox.Show("数据修改失败,请重试！", "温馨提示：");
}
}
private void btnOk_Click(object sender, EventArgs e)
{
string strByName = this.txbByItemName.Text.ToString().Trim();//获取标引项名称
string strByWords = "";
if (strByName == "")//判断是否为空
{
MessageBox.Show("请填写标引项名称！", "温馨提示：");
txbByItemName.Focus();
return;
}
if (lstByWord.Items.Count == 0)//判断是否为空
{
MessageBox.Show("请添加标引词！", "温馨提示：");
txbWord.Focus();
return;
}
List <string> lstVal = new List <string>();
foreach (var item in lstByWord.Items)
{
lstVal.Add(item.ToString());
}
bool bRs = IdexItemMag.AddNewKey(strByName, lstVal, BLL.SysMag.Login.StrLoginUserID);
if (bRs)
{
MessageBox.Show("添加成功！", "温馨提示：");
}
else
{
MessageBox.Show("添加失败，请重试！", "温馨提示：");
}
this.DialogResult = DialogResult.OK;
}
private void BingData(int nPageidx, int nPageSize)
{
if (nPageCount == 0)
{
return;
}
if (nPageidx > nPageCount)
{
nPageidx = nPageCount;
}
else if (nPageidx < 1)
{
nPageidx = 1;
}
btnSY.Enabled = true;
btnPre.Enabled = true;
btnNext.Enabled = true;
btnEnd.Enabled = true;
if (nPageidx == 1)
{
btnSY.Enabled = false;
btnPre.Enabled = false;
}
if (nPageidx == nPageCount)
{
btnNext.Enabled = false;
btnEnd.Enabled = false;
}
dgvListData.DataSource = IdexItemMag.getSysKey("", "", nPageidx, nPageSize);
nCuurentPage = nPageidx;
groupBox2.Text = string.Format("共{0}条数据,第{1}页/共{2}页.", nPtCount, nCuurentPage, nPageCount);
}
private void LoadData(bool isRefresh)
{
nPtCount = IdexItemMag.getSysKeyCount("");
nPageCount = Convert.ToInt32(Math.Ceiling(Convert.ToDouble(nPtCount) / Convert.ToDouble(nPageSize)));
if (nPageCount < 1)
{
nCuurentPage = 0;
btnSY.Enabled = false;
btnPre.Enabled = false;
btnNext.Enabled = false;
btnEnd.Enabled = false;
groupBox2.Text = string.Format("共{0}条数据", nPtCount, nCuurentPage, nPageCount);
dgvListData.DataSource = null;
dgvListData.Refresh();
}
else
{
nCuurentPage = isRefresh ? nCuurentPage : 1;
BingData(nCuurentPage, nPageSize);
}
}
private void InitRgByData()
{
foreach (Control cItem in tabRgby.Controls)
{
if (!(cItem is GroupBox))
{
continue;
}
GroupBox grb = (GroupBox)cItem;
CheckedListBox chkboxTmp = (CheckedListBox)grb.Controls[0];
for (int i = 0; i < chkboxTmp.Items.Count; i++)
{
chkboxTmp.SetItemChecked(i, false);
}
}
List <IDXKeyVAL> lstKeyVal = IdexItemMag.getListKeyVal(strSidKey, int.Parse(strZtId));
foreach (var item in lstKeyVal)
{
CheckedListBox chkboxTmp = (CheckedListBox)(tabRgby.Controls.Find(item.KeyID.Value.ToString(), false)[0].Controls[0]);
for (int i = 0; i < chkboxTmp.Items.Count; i++)
{
IDXVAL ValItem = (IDXVAL)chkboxTmp.Items[i];
if (item.Valid.Value == ValItem.ID)
{
chkboxTmp.SetItemChecked(i, true);
}
}
}
}
private void InitTag()
{
switch (strDbType)
{
case "CPRS":
this.Height = 696;
this.Width = 771;
tabEnBaseInfo.Parent = null;
tabEnAutoIdxInfor.Parent = null;
#region Cn自动标引
txbBySl.Tag = "byz_sum|int";
txbCLzs.Tag = "cls_char_sum|int";
txbGkn.Tag = "pdy|int";
txbGknc.Tag = "pdy_def|int";
cbxSfgwlh.Tag = "isguowai|int";
cbxSfgz.Tag = "isgongzhi|int";
cbxSfhzsq.Tag = "ishezuo|int";
txbGj.Tag = "gj|str";
txbSheng.Tag = "sheng|str";
txbSheng2.Tag = "sheng1|str";
txbQx.Tag = "quxian|str";
txbShi.Tag = "shi|str";
txbSqn.Tag = "gdy|int";
txbSqn1.Tag = "ady|int";
txbSqnc.Tag = "gdy_def|int";
txbYzSl.Tag = "yz_sum|int";
txbZcpc.Tag = "f_cpc|str";
txbZfmr.Tag = "f_in|str";
txbZIpc.Tag = "f_ipc|str";
txbZj.Tag = "zhou|str";
txbZlLx.Tag = "type|str";
txbZllx2.Tag = "type1|str";
txbZlnl.Tag = "age|int";
txbZsqr.Tag = "f_pa|str";
txbZsqrLx.Tag = "f_pa_type|str";
txbZzflzt.Tag = "lg|str";
txbCpcSl.Tag = "cpc_sum|int";
txbIpcSl.Tag = "ipc_sum|int";
txbfmrSl.Tag = "in_sum|int";
txbSqrSl.Tag = "pa_sum|int";
txbJjqq.Tag = "quyu|str";
txbFljzn.Tag = "lg|str";
#endregion
break;
case "WPI":
case "EPODOC":
this.Height = 621;
this.Width = 771;
tabCprsBaseInfor.Parent = null;
tabAutoIdxInfor.Parent = null;
#region En自动标引
txbEnAdy.Tag = "ady|int";
txbEnPdY.Tag = "pdy|int";
txbEnPrY.Tag = "";
txbEnOldPrY.Tag = "opdy|int";
txbEnPnYC.Tag = "pdy_def|int";
txbEnGnYC.Tag = "gdy_def|int";
txbEnFmlNm.Tag = "fml_sum|int";
txbEnCcNm.Tag = "gj_sum|int";
txbEnYzNm.Tag = "yz_sum|int";
txbEnPA1.Tag = "f_pa|str";
txbEnPaNm.Tag = "pa_sum|int";
cbxEnSfhzSq.Tag = "ishezuo|int";
txbEnIn1.Tag = "f_in|str";
txbEnInNm.Tag = "in_sum|int";
txbEnZj.Tag = "zhou|str";
cbxEnSf3J.Tag = "issanju|int";
cbxEnSf5j.Tag = "iswuju|int";
txbEnOldPrC.Tag = "oprc|str";
txbEnIpc1.Tag = "f_ipc|str";
txbEnCpc1.Tag = "f_cpc|str";
txbEnDmc1.Tag = "f_dmc|str";
txbEnIpcNm.Tag = "ipc_sum|int";
txbEnCpcNm.Tag = "cpc_sum|int";
txbEnDmcNm.Tag = "dmc_sum|int";
txbEnEndLg.Tag = "lg|str";
txbEnZlNl.Tag = "age|int";
//cbxEnGzjs.Tag = "isgongzhi|int";
//txbEnZlWcY.Tag = "";
txbEnAp_gjs.Tag = "ap_gjs|str";
txbEnPn_gjs.Tag = "Pn_gjs|str";
#endregion
break;
}
#region 人工标引控制初始化
//序号,a.id,a.idx_key as 标引项,b.Lname as 创建人, 标引词
DataTable dt = IdexItemMag.getSysKey("", "", 1, int.MaxValue);
tabRgby.Controls.Clear();
int nPoint_Y_Step = 73;
int nTmp = 12 - nPoint_Y_Step;
foreach (DataRow drItem in dt.Rows)
{
GroupBox grb = new GroupBox();
grb.Name = drItem["id"].ToString();
grb.Text = drItem["标引项"].ToString();
grb.Height = 61;
grb.Width = 736;
tabRgby.Controls.Add(grb);
nTmp += nPoint_Y_Step;
grb.Location = new Point(8, nTmp);
CheckedListBox chkLbx = new CheckedListBox();
grb.Controls.Add(chkLbx);
chkLbx.Dock = DockStyle.Fill;
chkLbx.MultiColumn = true;
chkLbx.HorizontalScrollbar = true;
List <DAL.IDXVAL> lisVal = IdexItemMag.getVal(int.Parse(drItem["id"].ToString()));
chkLbx.DataSource = lisVal;
chkLbx.ValueMember = "id";
chkLbx.DisplayMember = "val";
#endregion
}
}
