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