private void btnUpdate_Click(object sender, EventArgs e) { string test = "A+B-(C-D)+Abs(E)"; if (FormulaC.IsValid(test)) { string x = FormulaC.GetFormula(test); } }
private bool CheckInput() { try { if (FormulaC.IsValid(txtSalF.Text.Trim()) == false) { return(false); } string s = FormulaC.GetFormula(txtSalF.Text.Trim()); return(true); } catch (Exception ex) { return(false); } }
private bool InsertNewTemplate(ref int tmpid) { try { List <COLINFO> lRight = lbxColsRight.Items.Cast <COLINFO>().ToList(); var x = lRight.SingleOrDefault(a => a.CI_NAME.IndexOf(txtNameCol.Text.Trim() + "]") == 1); string s = lRight.Where(a => a.CI_NAME.IndexOf(txtNameCol.Text.Trim() + "]") == 1).SingleOrDefault().ToString(); //模板相关信息 TEMPLATE_INFO ti = new TEMPLATE_INFO { TI_NAME = txtTempName.Text.Trim(), TI_ISVALID = true, TI_COLSINORDER = String.Join(",", lRight.Select(o => o.CI_COLNAME)), TI_COLHEADERINORDER = String.Join(",", lRight.Select(o => o.CI_NAME.Substring(o.CI_NAME.IndexOf("]") + 1))), TI_SALF = FormulaC.GetFormula(txtSalF.Text.Trim()), TI_SALFRAW = txtSalF.Text.Trim(), TI_ANNUCOL = txtYearAnnu.Text.Trim(), TI_VERFYFRAW = txtVerify.Text.Trim(), TI_HEARDERROW = cbxHeaderRow.SelectedIndex + 1, TI_DATAROW = cbxDataRow.SelectedIndex + 1, TI_COLSCOUNT = lbxColsRight.Items.Count, TI_NAMECOL = txtNameCol.Text.Trim(), TI_BONUSCOL = txtBonusCol.Text.Trim(), TI_MONTHCOL = txtMonthCol.Text.Trim(), TI_REALCOL = txtRealCol.Text.Trim() }; if (txtVerify.Text.Trim() != string.Empty) { ti.TI_VERFYF = FormulaC.GetFormula(txtVerify.Text.Trim()); } db.TEMPLATE_INFOs.InsertOnSubmit(ti); db.SubmitChanges(); tmpid = ti.TI_ID; //模板列信息 int idex = 0; foreach (var i in lbxColsRight.Items) { idex++; //insert tmplate cols COLINFO ci = (COLINFO)i; TEMPLATE_COLUMN tc = new TEMPLATE_COLUMN { TC_CIID = ci.CI_ID, TC_TIID = ti.TI_ID, TC_ORDER = idex, }; db.TEMPLATE_COLUMNs.InsertOnSubmit(tc); } //update agentcurrcy set tmpID to new ID db.SubmitChanges(); return(true); } catch (Exception ex) { MessageBox.Show(ex.Message, this.funName, MessageBoxButtons.OK); return(false); } }