private void tsbNew_Click(object sender, EventArgs e) { try { if (lbMethodName.FindString(tbName.Text) >= 0) { MessageBox.Show("名称重复,不允许新增。", "提示"); return; } DataOperItem doi = new DataOperItem(); doi.ItemName = tbName.Text; doi.DBAlias = cbxDBAlias.Text; doi.ProcessContext = rtbContext.Text; doi.ReturnName = txtReturnName.Text; ItemBind ib = new ItemBind(doi.ItemName, doi.ItemName); ib.Tag = doi; lbMethodName.Items.Add(ib); } catch (Exception ex) { MsgBox.ShowException(ex, this); } }
private void lbMethodName_SelectedIndexChanged(object sender, EventArgs e) { try { tbName.Text = ""; cbxDBAlias.Text = ""; rtbContext.Text = ""; txtReturnName.Text = ""; if (lbMethodName.SelectedItem == null) { return; } ItemBind ib = lbMethodName.SelectedItem as ItemBind; DataOperItem doi = ib.Tag as DataOperItem; tbName.Text = doi.ItemName; cbxDBAlias.Text = doi.DBAlias; rtbContext.Text = doi.ProcessContext; txtReturnName.Text = doi.ReturnName; } catch (Exception ex) { MsgBox.ShowException(ex, this); } }
private void tsbUpdate_Click(object sender, EventArgs e) { try { if (lbMethodName.SelectedItem == null) { return; } int fIndex = lbMethodName.FindString(tbName.Text); if (fIndex < 0 || fIndex == lbMethodName.Items.IndexOf(lbMethodName.SelectedItem)) { ItemBind ib = lbMethodName.SelectedItem as ItemBind; ib.Name = tbName.Text; ib.Value = tbName.Text; DataOperItem doi = ib.Tag as DataOperItem; doi.ItemName = tbName.Text; doi.DBAlias = cbxDBAlias.Text; doi.ProcessContext = rtbContext.Text; doi.ReturnName = txtReturnName.Text; } else { MessageBox.Show("名称存在重复,不能进行更新。", "提示"); } } catch (Exception ex) { MsgBox.ShowException(ex, this); } }
public override bool ExecuteAction(string callModuleName, ISysDesign callModule, object sender, string actName, string tag, IBizDataItems bizDatas, object eventArgs = null) { try { _returnData = null; if (_dbHelpers == null) { _dbHelpers = new Dictionary <string, IDBQuery>(); foreach (DataOperItem doi in _dataOperDesign.DataOperItems) { if (_dbHelpers.ContainsKey(doi.DBAlias)) { continue; } string strErr = ""; IDBQuery thridDbHelper = null; thridDbHelper = SqlHelper.GetThridDBHelper(doi.DBAlias, _dbQuery, ref strErr); if (thridDbHelper == null) { MessageBox.Show("数据处理项 [" + doi.ItemName + "] 对应数据源实例化失败:" + strErr, "提示"); return(false); } _dbHelpers.Add(doi.DBAlias, thridDbHelper); } } _curBizData = null; if (bizDatas != null) { _curBizData = bizDatas[0] as BizDataItem; } IDBQuery curDBHelper = null; switch (actName) { case DataOperActionDefine.RunProcess: _returnData = new BizDataItems(); BizDataItem returnItem = new BizDataItem(); if (string.IsNullOrEmpty(tag)) { using (TransactionScope ts = new TransactionScope()) { foreach (DataOperItem doi in _dataOperDesign.DataOperItems) { if (string.IsNullOrEmpty(doi.DBAlias)) { curDBHelper = _dbQuery; } else { curDBHelper = _dbHelpers[doi.DBAlias]; } DataTable dtResult = SqlHelper.GetDataSource(doi.ProcessContext, curDBHelper, QueryParValueEvent); returnItem.Add(doi.ReturnName, dtResult); } ts.Complete(); } } else { int index = _dataOperDesign.DataOperItems.FindIndex(T => T.ItemName == tag); if (index < 0) { MessageBox.Show("未找到指定处理项的配置信息。", "提示"); return(false); } DataOperItem doiProcess = _dataOperDesign.DataOperItems[index]; if (string.IsNullOrEmpty(doiProcess.DBAlias)) { curDBHelper = _dbQuery; } else { curDBHelper = _dbHelpers[doiProcess.DBAlias]; } DataTable dtResult = SqlHelper.GetDataSource(doiProcess.ProcessContext, curDBHelper, QueryParValueEvent); returnItem.Add(doiProcess.ReturnName, dtResult); } _returnData.Add(returnItem); return(true); default: break; } return(true); } catch (Exception ex) { MsgBox.ShowException(ex, this); return(false); } }