//添加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);
}
}
