private void SetMemberValueOfItem(XPBaseObject item, IModelColumn column, ASPxEdit cellControl)
{
var edit = cellControl as ASPxSpinEdit;
if (edit != null && edit.NumberType == SpinEditNumberType.Integer)
{
item.SetMemberValue(column.PropertyName,
column.ModelMember.MemberInfo.MemberType == typeof(int)
? Convert.ToInt32(cellControl.Value)
: Convert.ToInt64(cellControl.Value));
}
else
{
if (typeof(XPBaseObject).IsAssignableFrom(column.ModelMember.MemberInfo.MemberType) &&
!typeof(IFileData).IsAssignableFrom(column.ModelMember.MemberInfo.MemberType))
{
object o = _objectSpace.GetObjectByKey(column.ModelMember.MemberInfo.MemberType, cellControl.Value);
item.SetMemberValue(column.PropertyName, o);
}
else
{
item.SetMemberValue(column.PropertyName, cellControl.Value);
}
}
}
void ImportProperties(UnitOfWork nestedUnitOfWork, XPBaseObject xpBaseObject, XElement element) {
ImportSimpleProperties(element, xpBaseObject);
ImportComplexProperties(element, nestedUnitOfWork,
(o, xElement) =>
xpBaseObject.SetMemberValue(xElement.Parent.GetAttributeValue("name"), o),
NodeType.Object);
ImportComplexProperties(element, nestedUnitOfWork,
(baseObject, element1) =>
((IList) xpBaseObject.GetMemberValue(element1.Parent.GetAttributeValue("name"))).Add(
baseObject), NodeType.Collection);
}
void CreateDatabaseAndDefaultData()
{
using (UnitOfWork dataSession = new UnitOfWork(dataStorage)) {
InitDataDictionary(dataSession);
dataSession.UpdateSchema(dataSession.GetClassInfo(null, "Customer"), dataSession.GetClassInfo(null, "Order"));
XPClassInfo classCustomer = dataSession.GetClassInfo("", "Customer");
XPBaseObject customer = (XPBaseObject)classCustomer.CreateNewObject(dataSession);
customer.SetMemberValue("FullName", "John Doe");
for (int i = 0; i < OrderCount; i++)
{
XPClassInfo classOrder = dataSession.GetClassInfo("", "Order");
XPBaseObject order = (XPBaseObject)classOrder.CreateNewObject(dataSession);
order.SetMemberValue("OrderDate", OrderDate);
order.SetMemberValue("Customer", customer);
}
dataSession.CommitChanges();
}
}
void ImportProperties(IObjectSpace nestedObjectSpace, XPBaseObject xpBaseObject, XElement element)
{
ImportSimpleProperties(element, xpBaseObject);
ImportComplexProperties(element, nestedObjectSpace,
(o, xElement) =>
xpBaseObject.SetMemberValue(xElement.Parent.GetAttributeValue("name"), o),
NodeType.Object);
ImportComplexProperties(element, nestedObjectSpace,
(baseObject, element1) =>
((IList)xpBaseObject.GetMemberValue(element1.Parent.GetAttributeValue("name"))).Add(
baseObject), NodeType.Collection);
}
void ImportSimpleProperties(XElement element, XPBaseObject xpBaseObject)
{
foreach (XElement simpleElement in element.Properties(NodeType.Simple))
{
string propertyName = simpleElement.GetAttributeValue("name");
XPMemberInfo xpMemberInfo = xpBaseObject.ClassInfo.FindMember(propertyName);
if (xpMemberInfo != null)
{
object value = GetValue(simpleElement, xpMemberInfo);
xpBaseObject.SetMemberValue(propertyName, value);
}
else
{
HandleError(simpleElement, FailReason.PropertyNotFound);
}
}
}
static void Main(string[] args)
{
IDataStore provider = new DevExpress.Xpo.DB.InMemoryDataStore();
//string connectionString = MSSqlConnectionProvider.GetConnectionString("localhost", "E1139");
//IDataStore provider = XpoDefault.GetConnectionProvider(connectionString, AutoCreateOption.DatabaseAndSchema);
XPDictionary dictionary = new ReflectionDictionary();
XPClassInfo myBaseClass = dictionary.GetClassInfo(typeof(MyBaseObject));
XPClassInfo myClassA = dictionary.CreateClass(myBaseClass, "MyObjectA");
myClassA.CreateMember("ID", typeof(int), new KeyAttribute(true));
myClassA.CreateMember("Name", typeof(string));
XpoDefault.Session = null;
XpoDefault.DataLayer = new SimpleDataLayer(dictionary, provider);
//XpoDefault.DataLayer = new ThreadSafeDataLayer(dictionary, provider);
using (Session session = new Session()) {
session.UpdateSchema(myClassA);
}
using (Session session = new Session()) {
Console.WriteLine("Create a new object:");
XPBaseObject obj = (XPBaseObject)myClassA.CreateNewObject(session);
obj.SetMemberValue("Name", String.Format("sample {0}", DateTime.UtcNow.Ticks));
obj.Save();
Console.WriteLine("ID:\t{0}, Name:\t{1}", obj.GetMemberValue("ID"), obj.GetMemberValue("Name"));
}
Console.WriteLine("----------------------------");
using (Session session = new Session()) {
XPCollection collection = new XPCollection(session, myClassA);
Console.WriteLine("Objects loaded. Total count: {0}", collection.Count);
foreach (XPBaseObject obj in collection)
{
Console.WriteLine("ID:\t{0}, Name:\t{1}", obj.GetMemberValue("ID"), obj.GetMemberValue("Name"));
}
}
Console.WriteLine("----------------------------");
Console.WriteLine("Press Enter to Exit");
Console.ReadLine();
}
void ImportSimpleProperties(XElement element, XPBaseObject xpBaseObject) {
foreach (var simpleElement in element.Properties(NodeType.Simple)){
string propertyName = simpleElement.GetAttributeValue("name");
XPMemberInfo xpMemberInfo = xpBaseObject.ClassInfo.FindMember(propertyName);
if (xpMemberInfo != null) {
object value = GetValue(simpleElement, xpMemberInfo);
xpBaseObject.SetMemberValue(propertyName, value);
}
}
}
void importSimpleProperties(XElement element, XPBaseObject xpBaseObject) {
IEnumerable<XElement> simpleElements =
element.Descendants("Property").Where(
xElement => xElement.GetAttributeValue("type") == NodeType.Simple.ToString().MakeFirstCharLower());
foreach (var simpleElement in simpleElements) {
string propertyName = simpleElement.GetAttributeValue("name");
XPMemberInfo xpMemberInfo = xpBaseObject.ClassInfo.GetMember(propertyName);
object value = GetValue(simpleElement, xpMemberInfo);
if (simpleElement.GetAttributeValue("isNaturalKey")=="true"&&!xpBaseObject.IsNewObject())
continue;
xpBaseObject.SetMemberValue(propertyName, value);
}
}
private void SetMemberValueOfItem(XPBaseObject item, IModelColumn column, ASPxEdit cellControl){
if (cellControl is ASPxSpinEdit && ((ASPxSpinEdit) cellControl).NumberType == SpinEditNumberType.Integer)
item.SetMemberValue(column.PropertyName,
column.ModelMember.MemberInfo.MemberType == typeof (int)
? Convert.ToInt32(cellControl.Value)
: Convert.ToInt64(cellControl.Value));
else{
if (typeof (XPBaseObject).IsAssignableFrom(column.ModelMember.MemberInfo.MemberType) &&
!typeof (IFileData).IsAssignableFrom(column.ModelMember.MemberInfo.MemberType)){
object o = _objectSpace.GetObjectByKey(column.ModelMember.MemberInfo.MemberType, cellControl.Value);
item.SetMemberValue(column.PropertyName, o);
}
else{
item.SetMemberValue(column.PropertyName, cellControl.Value);
}
}
}
private bool StartImport(Worksheet ws, IModelClass bo, IObjectSpace os)
{
//开始导入:
//1.先使用表头的标题找到属性名称
Dictionary <int, IModelMember> fields = new Dictionary <int, IModelMember>();
List <SheetRowObject> objs = new List <SheetRowObject>();
//var ws = _spreadsheet.Document.Worksheets[0];
var columnCount = ws.Columns.LastUsedIndex;
var updateImport = bo.TypeInfo.FindAttribute <UpdateImportAttribute>();
var findObjectProviderAttribute = bo.TypeInfo.FindAttribute <FindObjectProviderAttribute>();
if (findObjectProviderAttribute != null)
{
findObjectProviderAttribute.Reset();
}
var isUpdateImport = updateImport != null;
var keyColumn = 0;
var headerError = false;
IModelMember keyField = null;
for (int c = 1; c <= columnCount; c++)
{
var fieldCaption = ws.Cells[1, c].DisplayText;
var fieldName = bo.AllMembers.SingleOrDefault(x => x.Caption == fieldCaption);
if (fieldName != null)
{
fields.Add(c, fieldName);
if (isUpdateImport && fieldName.Name == updateImport.KeyMember)
{
keyColumn = c;
keyField = fieldName;
}
}
else
{
ws.Cells[1, c].FillColor = Color.Red;
headerError = true;
}
}
var sheetContext = new SheetContext(ws, fields.ToDictionary(x => x.Value.Name, x => x.Key));
var rowCount = ws.Rows.LastUsedIndex;
ws.Workbook.BeginUpdate();
//清理上次的结果.
for (int r = 2; r <= rowCount; r++)
{
//ws.Cells[r, 0].ClearContents();
for (int c = 1; c <= columnCount; c++)
{
var cel = ws.Cells[r, c];
if (cel.FillColor != Color.Empty)
{
cel.FillColor = Color.Empty;
}
if (cel.Font.Color != Color.Empty)
{
cel.Font.Color = Color.Empty;
}
}
var errorCell = ws.Cells[r, 0];
if (!errorCell.Value.IsEmpty)
{
errorCell.Clear();
}
}
ws.Workbook.EndUpdate();
if (headerError)
{
ws.Cells[0, 4].SetValue("表头有错误，请查看被标红色的表头，确认行中没有对应的数据。");
return(false);
}
var updateStep = rowCount / 100;
if (updateStep == 0)
{
updateStep = 1;
}
var numberTypes = new[]
{
typeof(Int16), typeof(Int32), typeof(Int64), typeof(UInt16), typeof(UInt32), typeof(UInt64), typeof(decimal), typeof(float), typeof(double),
typeof(byte), typeof(sbyte)
};
ws.Workbook.BeginUpdate();
for (int r = 2; r <= rowCount; r++)
{
XPBaseObject obj = null;
if (isUpdateImport)
{
var cdvalue = Convert.ChangeType(ws.Cells[r, keyColumn].Value.ToObject(), keyField.Type);
var cri = new BinaryOperator(updateImport.KeyMember, cdvalue);
if (findObjectProviderAttribute != null)
{
var t = findObjectProviderAttribute.FindObject(os, bo.TypeInfo.Type, cri, true);
if (t.Count > 0)
{
obj = t[0] as XPBaseObject;
}
else
{
t = null;
}
}
else
{
obj = os.FindObject(bo.TypeInfo.Type, cri) as XPBaseObject;
}
if (obj == null)
{
obj = os.CreateObject(bo.TypeInfo.Type) as XPBaseObject;
}
}
else
{
obj = os.CreateObject(bo.TypeInfo.Type) as XPBaseObject;
}
var result = new SheetRowObject(sheetContext)
{
Object = obj, Row = r, RowObject = ws.Rows[r]
};
//var vle = ws.Cells[r, c];
for (int c = 1; c <= columnCount; c++)
{
var field = fields[c];
var cell = ws.Cells[r, c];
if (!cell.Value.IsEmpty)
{
object value = null;
//引用类型
//兼容DC类型
var memberType = field.MemberInfo.MemberType;
if (memberType.IsValueType && memberType.IsGenericType)
{
if (memberType.GetGenericTypeDefinition() == typeof(Nullable <>))
{
memberType = memberType.GetGenericArguments()[0];
}
}
if (typeof(XPBaseObject).IsAssignableFrom(memberType) || field.MemberInfo.MemberTypeInfo.IsDomainComponent)
{
#region 引用类型
var conditionValue = cell.Value.ToObject();
//如果指定了查找条件，就直接使用
var idf = field.MemberInfo.FindAttribute <ImportDefaultFilterCriteria>();
var condition = idf == null ? "" : idf.Criteria;
#region 查找条件
if (string.IsNullOrEmpty(condition))
{
//没指定查找条件，主键不是自动生成的，必定为手工输入
if (!field.MemberInfo.MemberTypeInfo.KeyMember.IsAutoGenerate)
{
condition = field.MemberInfo.MemberTypeInfo.KeyMember.Name + " = ?";
}
}
if (string.IsNullOrEmpty(condition))
{
//还是没有，找设置了唯一规则的
var ufield =
field.MemberInfo.MemberTypeInfo.Members.FirstOrDefault(
x => x.FindAttribute <RuleUniqueValueAttribute>() != null
);
if (ufield != null)
{
condition = ufield.Name + " = ? ";
}
}
if (string.IsNullOrEmpty(condition))
{
//还是没有，用defaultproperty指定的
var ufield = field.MemberInfo.MemberTypeInfo.DefaultMember;
if (ufield != null)
{
condition = ufield.Name + " = ? ";
}
}
#endregion
#region p
if (string.IsNullOrEmpty(condition))
{
result.AddErrorMessage(
string.Format(
"错误，没有为引用属性{0}设置查找条件，查询过程中出现了错误，请修改查询询条!",
field.MemberInfo.Name), cell);
}
else
{
try
{
var @operator = CriteriaOperator.Parse(condition, new object[] { conditionValue });
IList list = null;
if (findObjectProviderAttribute != null)
{
list = findObjectProviderAttribute.FindObject(os, field.MemberInfo.MemberType,
@operator, true);
}
else
{
list = os.GetObjects(field.MemberInfo.MemberType, @operator, true);
}
if (field.Caption == "办事处")
{
Debug.WriteLine(list.Count + "," + field.Caption, @operator.ToString());
}
if (list.Count != 1)
{
result.AddErrorMessage(
string.Format(
"错误，在查找“{0}”时，使用查找条件“{1}”，输入值是：“{3}”，查询过程中出现了错误，请修改查询询条!错误详情:{2}",
field.MemberInfo.MemberType.FullName, condition,
"找到了" + list.Count + "条记录", conditionValue), cell);
}
else
{
value = list[0];
}
}
catch (Exception exception1)
{
result.AddErrorMessage(
string.Format("错误，在查找“{0}”时，使用查找条件“{1}”，查询过程中出现了错误，请修改查询询条!错误详情:{2}",
field.MemberInfo.MemberType.FullName, condition, exception1.Message),
cell);
}
}
#endregion
#endregion
}
else if (memberType == typeof(DateTime))
{
if (!cell.Value.IsDateTime)
{
result.AddErrorMessage(string.Format("字段:{0},要求输入日期!", field.Name), cell);
}
else
{
value = cell.Value.DateTimeValue;
}
}
else if (numberTypes.Contains(memberType))
{
if (!cell.Value.IsNumeric)
{
result.AddErrorMessage(string.Format("字段:{0},要求输入数字!", field.Name), cell);
}
else
{
value = Convert.ChangeType(cell.Value.NumericValue, field.MemberInfo.MemberType);
}
}
else if (memberType == typeof(bool))
{
if (!cell.Value.IsBoolean)
{
result.AddErrorMessage(string.Format("字段:{0},要求输入布尔值!", field.Name), cell);
}
else
{
value = cell.Value.BooleanValue;
}
}
else if (memberType == typeof(string))
{
var v = cell.Value.ToObject();
if (v != null)
{
value = v.ToString();
}
}
else if (memberType.IsEnum)
{
#region 枚举
if (cell.Value.IsNumeric)
{
#region 填写的是数字
var vle = Convert.ToInt64(cell.Value.NumericValue);
var any =
Enum.GetValues(field.MemberInfo.MemberType)
.OfType <object>()
.Any(
x =>
{
return(object.Equals(Convert.ToInt64(x), vle));
}
);
if (any)
{
value = Enum.ToObject(field.MemberInfo.MemberType, vle);
// cell.Value.NumericValue;
}
else
{
result.AddErrorMessage(string.Format("字段:{0},所填写的枚举值，没在定义中出现!", field.Name), cell);
}
#endregion
}
else
{
#region 填写的是字符
var names = field.MemberInfo.MemberType.GetEnumNames();
if (names.Contains(cell.Value.TextValue))
{
value = Enum.Parse(field.MemberInfo.MemberType, cell.Value.TextValue);
}
else
{
result.AddErrorMessage(string.Format("字段:{0},所填写的枚举值，没在定义中出现!", field.Name), cell);
}
#endregion
}
#endregion
}
else
{
value = cell.Value.ToObject();
}
obj.SetMemberValue(field.Name, value);
}
}
objs.Add(result);
if ((r - 2) % updateStep == 0)
{
Debug.WriteLine("Process:" + r);
if (DoApplicationEvent != null)
{
DoApplicationEvent();
this.option.Progress = ((r / (decimal)rowCount) + 0.01m);
//Debug.WriteLine(this.option.Progress);
//var progress = ws.Cells[r, 0];
//progress.SetValue("完成");
}
}
}
ws.Workbook.EndUpdate();
if (objs.All(x => !x.HasError))
{
try
{
Validator.RuleSet.ValidateAll(os, objs.Select(x => x.Object), "Save");
return(true);
}
catch (ValidationException msgs)
{
var rst = true;
ws.Workbook.BeginUpdate();
foreach (var item in msgs.Result.Results)
{
if (item.Rule.Properties.ResultType == ValidationResultType.Error && item.State == ValidationState.Invalid)
{
var r = objs.FirstOrDefault(x => x.Object == item.Target);
if (r != null)
{
r.AddErrorMessage(item.ErrorMessage, item.Rule.UsedProperties);
}
rst &= false;
}
}
ws.Workbook.EndUpdate();
return(rst);
}
}
return(false);
}