//添加EXCEL列号(A,B,C...) private void UpdatePrex() { int i = 0; for (; i < lbxColsRight.Items.Count; i++) { COLINFO cl = (COLINFO)lbxColsRight.Items[i]; if (cl.CI_NAME.IndexOf("]") != -1) { cl.CI_NAME = cl.CI_NAME.Substring(cl.CI_NAME.IndexOf("]") + 1); } lbxColsRight.Items[i] = new COLINFO { CI_ID = cl.CI_ID, CI_COLNAME = cl.CI_COLNAME, CI_NAME = "[" + SysUtil.GetExcelColumnName(i + 1) + "]" + cl.CI_NAME }; if (cl.CI_NAME == "效益年终奖") { } } for (i = 0; i < lbxColsLeft.Items.Count; i++) { COLINFO cl = (COLINFO)lbxColsLeft.Items[i]; if (cl.CI_NAME.IndexOf("]") != -1) { cl.CI_NAME = cl.CI_NAME.Substring(cl.CI_NAME.IndexOf("]") + 1); } lbxColsLeft.Items[i] = new COLINFO { CI_ID = cl.CI_ID, CI_COLNAME = cl.CI_COLNAME, CI_NAME = cl.CI_NAME }; } }
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); } }