protected override bool BtnOkClick()
{
Model.Tb_tmp_xls_map old = this.modelObj as Model.Tb_tmp_xls_map;
Model.Tb_tmp_xls_map info = this.GetDataBind <Model.Tb_tmp_xls_map>(old);
//old.Var_Explain = info.Var_Explain;
//old.Field_Name = info.Field_Name;
//old.Field_Format = info.Field_Format;
if (Miles.Coro.ORM.Repository.SingleRepository.Update <Model.Tb_tmp_xls_map>()
.Set()
.AllFields(info)
.EndSet()
.Where()
.And(Model.Tb_tmp_xls_map.Table.Tmp_Id, old.Tmp_Id)
.And(Model.Tb_tmp_xls_map.Table.Var_Text, old.Var_Text)
.EndWhere()
.Save() < 1)
{
return(false);
}
this.DoSelectValueEvent(old);
return(true);
}
protected void ReplaceVar(object dataSource, bool isClearEmptyVar = true)
{
List <unvell.ReoGrid.Cell> cells = this.GetAllMergedCells();
foreach (unvell.ReoGrid.Cell cellFrom in cells)
{
string varText = FindVarString(cellFrom.DisplayText);
if (varText != null)
{
Miles.Coro.Common.MemberAccessor.DelegatedExpressionMemberAccessor memberAccessor = Miles.Coro.Common.MemberAccessor.DelegatedExpressionMemberAccessor.Instance;
Model.Tb_tmp_xls_map map = dicVarMap.ContainsKey(varText) ? dicVarMap[varText] : null;
if (map != null)
{
string dataField = map.Field_Name;
object value = memberAccessor.GetValue(dataSource, dataField);
unvell.ReoGrid.Cell cell = this.Sheet.Cells[cellFrom.Row, cellFrom.Column];
if (value != null)
{
SetCellFormatData(cell, value, map.Field_Format);
}
else
{
if (isClearEmptyVar)
{
SetCellFormatData(cell, "", null);
}
}
}
}
}
}
public FmMapXlsInfo(Model.Tb_tmp_xls_map info, string typeFullName)
: base(info)
{
InitializeComponent();
if (typeFullName != null)
{
d_field_Name.LoadData(typeFullName);
}
}
void mDataGrid1_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e)
{
if (this.mDataGrid1.CurrentRow == null)
{
return;
}
Model.Info_tmp_xls tmpXls = this.Tag as Model.Info_tmp_xls;
Model.Tb_tmp_xls_map info = mDataGrid1.GetCurrentEntity() as Model.Tb_tmp_xls_map;
FmMapXlsInfo fm = new FmMapXlsInfo(info, tmpXls.Source_Type);
fm.SelectValue += new SelectValueHandler(fm_SelectValue);
fm.ShowDialog();
}
protected void InsertItems(IList items, XlsItemGroup xlsItemGroup, int itemStartRow, int itemStartCol)
{
int itemCount = items.Count;
int rowCount = xlsItemGroup.RowCount;
if (itemCount > 1)
{
this.Sheet.InsertRows(itemStartRow + rowCount, rowCount * (itemCount - 1));
}
//按照插入行行的合并情况，循环列合并，新增加的行的列
for (int row = 1; row < itemCount; row++)
{
SetItemGroupMergedCell(this.Sheet, itemStartRow + row * rowCount, itemStartCol, xlsItemGroup.CellsTmp);
}
for (int row = 0; row < itemCount; row++)
{
object dataSource = items[row];
foreach (unvell.ReoGrid.Cell cellFrom in xlsItemGroup.CellsTmp)
{
int realRow = itemStartRow + row * rowCount;
unvell.ReoGrid.Cell cell = this.Sheet.Cells[cellFrom.Row + realRow, cellFrom.Column + itemStartCol];
string varText = FindVarString(cellFrom.DisplayText);
if (varText != null)
{
Miles.Coro.Common.MemberAccessor.DelegatedExpressionMemberAccessor memberAccessor = Miles.Coro.Common.MemberAccessor.DelegatedExpressionMemberAccessor.Instance;
Model.Tb_tmp_xls_map map = xlsItemGroup.DicVarMap.ContainsKey(varText) ? xlsItemGroup.DicVarMap[varText] : null;
if (map != null)
{
string dataField = map.Field_Name;
object value = memberAccessor.GetValue(dataSource, dataField);
if (value != null)
{
//根据格式来设置单元格值
SetCellFormatData(cell, value, map.Field_Format);
this.Sheet.AutoFitRowHeight(realRow);
}
}
}
else
{
cell.Data = cellFrom.Data;
}
}
}
}
void btnSyn_Click(object sender, EventArgs e)
{
Model.Info_tmp_xls tmpXls = this.Tag as Model.Info_tmp_xls;
long tmpId = tmpXls.Tmp_Id;
Miles.Coro.ORM.Repository repository = Miles.Coro.ORM.Repository.SingleRepository;
List <Model.Tb_tmp_xls_var> vars = repository
.Query()
.From <Model.Tb_tmp_xls_var>()
.ToSelect().EndSelect()
.ToWhere()
.And(Model.Tb_tmp_xls_var.Table.Tmp_Id, tmpId)
.EndWhere()
.ToQuery()
.ToList <Model.Tb_tmp_xls_var>();
List <Model.Tb_tmp_xls_map> mapList = mDataGrid1.GetDataSource <Model.Tb_tmp_xls_map>();
var mapVars = from v in mapList select v.Var_Text;
var quary = from item in vars
where !mapVars.Contains(item.Var_Text)
select item;
repository.DbManager.BeginTransaction();
foreach (var v in quary)
{
Model.Tb_tmp_xls_map map = new Model.Tb_tmp_xls_map();
map.Tmp_Id = tmpId;
map.Var_Text = v.Var_Text;
if (!repository.Add(map))
{
repository.DbManager.RollBack();
return;
}
}
repository.DbManager.Commit();
LoadAllParmMap();
}
void btnDelete_Click(object sender, EventArgs e)
{
if (this.mDataGrid1.CurrentRow == null)
{
return;
}
Model.Tb_tmp_xls_map info = mDataGrid1.GetCurrentEntity() as Model.Tb_tmp_xls_map;
string msg = string.Format("确定删除:{0}信息?", info.Var_Text);
if (Miles.Framework.UI.Function.Dialog.ShowQuestionYesNo(msg))
{
if (Miles.Coro.ORM.Repository.SingleRepository.Remove <Model.Tb_tmp_xls_map>()
.Where()
.And(Model.Tb_tmp_xls_map.Table.Tmp_Id, info.Tmp_Id)
.And(Model.Tb_tmp_xls_map.Table.Var_Text, info.Var_Text)
.EndWhere()
.Save() > 0)
{
LoadAllParmMap();
}
}
}
void fm_SelectValue(object obj)
{
Model.Tb_tmp_xls_map info = obj as Model.Tb_tmp_xls_map;
mDataGrid1.EditCurrentItem <Model.Tb_tmp_xls_map>(info);
}