/// <summary> /// 简单属性的类型转换 /// 将移动对应的实体的字符串类型统一转换为指定的数据类型 /// </summary> /// <param name="sourceType">原数据类型</param> /// <param name="businessTypeService">业务服务接口</param> /// <returns></returns> public DependencyObjectType ConvertToDependencyObjectType(IDataEntityType sourceType, IBusinessTypeService businessTypeService) { DependencyObjectType newType = new DependencyObjectType(sourceType.Name); foreach (DependencyProperty property in sourceType.SimpleProperties) { if (_dateTimeProperties.Contains(property.Name)) { newType.RegisterSimpleProperty(property.Name, typeof(DateTime), OrmDataOption.EmptyDateTime , false, new Attribute[] { new SimplePropertyAttribute(GeneralDBType.DateTime) }); } else if (_decimalProperties.Contains(property.Name)) { newType.RegisterSimpleProperty(property.Name, businessTypeService.SimpleQuantityType, 0m , false, new Attribute[] { businessTypeService.SimpleQuantity }); } else if (_intProperties.Contains(property.Name)) { newType.RegisterSimpleProperty(property.Name, typeof(int), 0 , false, new Attribute[] { new SimplePropertyAttribute(GeneralDBType.Int32) }); } else { newType.RegisterSimpleProperty(property.Name, typeof(string), string.Empty , false, new Attribute[] { new SimplePropertyAttribute(GeneralDBType.String) }); } } return(newType); }
static Customer() { // DefaultType DefaultType = new DependencyObjectType("Customer", new Attribute[] { new DataEntityAttribute("ID"), new Digiwin.Common.Services.DatabaseDataEntityTypeAttribute() }); // ID SimplePropertyAttribute simplePropertyAttribute0 = new SimplePropertyAttribute(GeneralDBType.Guid); simplePropertyAttribute0.Description = "PrimaryKey"; IDProperty = DefaultType.RegisterSimpleProperty("ID", typeof(System.Guid), null, false, new Attribute[] { simplePropertyAttribute0 }); // CODE SimplePropertyAttribute simplePropertyAttribute1 = new SimplePropertyAttribute(GeneralDBType.String); simplePropertyAttribute1.Description = "单据类型编号"; simplePropertyAttribute1.Size = 10; CODEProperty = DefaultType.RegisterSimpleProperty("CODE", typeof(string), null, false, new Attribute[] { simplePropertyAttribute1 }); // NAME SimplePropertyAttribute simplePropertyAttribute2 = new SimplePropertyAttribute(GeneralDBType.String); simplePropertyAttribute2.Description = "单据类型名称"; simplePropertyAttribute2.Size = 20; NAMEProperty = DefaultType.RegisterSimpleProperty("NAME", typeof(string), null, false, new Attribute[] { simplePropertyAttribute2 }); }
private DependencyObjectCollection GetPickListDataource(string pickListName, bool allowCheck) { IPickListDataService plDataSrv = this.GetService <IPickListDataService>(); DependencyObjectType type = new DependencyObjectType(pickListName); type.RegisterSimpleProperty("Value", typeof(string)); type.RegisterSimpleProperty("DisplayName", typeof(string)); if (allowCheck) { type.RegisterSimpleProperty("Select", typeof(bool)); } DependencyObjectCollection items = new DependencyObjectCollection(type); if (!allowCheck) { DependencyObject first = items.AddNew(); first["Value"] = ""; first["DisplayName"] = "--空白值--"; } foreach (var item in plDataSrv.GetPickListSortedData(pickListName)) { DependencyObject obj = items.AddNew(); obj["Value"] = item.Id; obj["DisplayName"] = item.DisplayName; if (allowCheck) { obj["Select"] = false; } } return(items); }
/// <summary> /// 存储所需修改IssueReceiptD的数据集合的临时表 /// </summary> private IDataEntityType CreateDTmpTable(IQueryService qrySrv) { string typeName = "Temp_UpdateSalesIssueD_" + DateTime.Now.ToString("HHmmssfff");// 临时表表名的处理 DependencyObjectType defaultType = new DependencyObjectType(typeName, new Attribute[] { }); IBusinessTypeService businessSrv = this.GetServiceForThisTypeKey <IBusinessTypeService>(); #region 字段 defaultType.RegisterSimpleProperty("item_no", businessSrv.SimpleItemCodeType, string.Empty, false, new Attribute[] { businessSrv.SimpleItemCode }); defaultType.RegisterSimpleProperty("item_feature_no", businessSrv.SimpleItemFeatureType, string.Empty, false, new Attribute[] { businessSrv.SimpleItemFeature }); defaultType.RegisterSimpleProperty("picking_unit_no", businessSrv.SimpleUnitCodeType, string.Empty, false, new Attribute[] { businessSrv.SimpleUnitCode }); defaultType.RegisterSimpleProperty("doc_no", businessSrv.SimpleDocNoType, string.Empty, false, new Attribute[] { businessSrv.SimpleDocNo }); SimplePropertyAttribute tempAttr = new SimplePropertyAttribute(GeneralDBType.Int32); defaultType.RegisterSimpleProperty("seq", typeof(Int32), 0, false, new Attribute[] { tempAttr }); defaultType.RegisterSimpleProperty("warehouse_no", businessSrv.GetBusinessType("WarehouseCode"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("WarehouseCode") }); defaultType.RegisterSimpleProperty("storage_spaces_no", businessSrv.GetBusinessType("Bin"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("Bin") }); defaultType.RegisterSimpleProperty("lot_no", businessSrv.SimpleLotCodeType, string.Empty, false, new Attribute[] { businessSrv.SimpleLotCode }); defaultType.RegisterSimpleProperty("picking_qty", businessSrv.SimpleQuantityType, 0M, false, new Attribute[] { businessSrv.SimpleQuantity }); tempAttr = new SimplePropertyAttribute(GeneralDBType.String, 1000); defaultType.RegisterSimpleProperty("barcode_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); #endregion qrySrv.CreateTempTable(defaultType); return(defaultType); }
/// <summary> /// 构建attrib_list返回值 /// </summary> /// <returns></returns> private DependencyObjectType StructureAttribList() { DependencyObjectType type = new DependencyObjectType("attrib_list"); type.RegisterSimpleProperty("attrib_value", typeof(decimal)); //测量值 type.RegisterSimpleProperty("result_type", typeof(string)); //判定状态 return(type); }
/// <summary> /// 构建reason_list返回值 /// </summary> /// <returns></returns> private DependencyObjectType StructureReasonList() { DependencyObjectType type = new DependencyObjectType("reason_list"); type.RegisterSimpleProperty("reason_no", typeof(string)); //缺点原因编号 type.RegisterSimpleProperty("reason_code_name", typeof(string)); //缺点原因 type.RegisterSimpleProperty("defect_qty", typeof(decimal)); //缺点数量 return(type); }
/// <summary> /// 创建存储传入参数集合的临时表 /// </summary> private void CreateTemp() { IBusinessTypeService businessSrv = this.GetServiceForThisTypeKey <IBusinessTypeService>(); string typeName = "Temp_Scan" + DateTime.Now.ToString("HHmmssfff");// 临时表表名的处理 DependencyObjectType defaultType = new DependencyObjectType(typeName, new Attribute[] { }); #region 单头 defaultType.RegisterSimpleProperty("ID", businessSrv.SimplePrimaryKeyType, Maths.GuidDefaultValue(), false, new Attribute[] { businessSrv.SimplePrimaryKey }); //人员 defaultType.RegisterSimpleProperty("employee_no", businessSrv.GetBusinessType("BusinessCode"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("BusinessCode") }); SimplePropertyAttribute tempAttr = new SimplePropertyAttribute(GeneralDBType.String); tempAttr.Size = 10; //部门 defaultType.RegisterSimpleProperty("picking_department_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //工厂编号 defaultType.RegisterSimpleProperty("site_no", businessSrv.GetBusinessType("Factory"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("Factory") }); //信息批号 tempAttr.Size = 30; defaultType.RegisterSimpleProperty("info_lot_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); _tempScan = defaultType; _qurService.CreateTempTable(_tempScan); #endregion typeName = "Temp_ScanDetail" + DateTime.Now.ToString("HHmmssfff");// 临时表表名的处理 defaultType = new DependencyObjectType(typeName, new Attribute[] { }); #region 单身 defaultType.RegisterSimpleProperty("ID", businessSrv.SimplePrimaryKeyType, Maths.GuidDefaultValue(), false, new Attribute[] { businessSrv.SimplePrimaryKey }); //信息批号 tempAttr.Size = 30; defaultType.RegisterSimpleProperty("info_lot_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //序号 tempAttr = new SimplePropertyAttribute(GeneralDBType.Int32); defaultType.RegisterSimpleProperty("SequenceNumber", typeof(Int32), 0, false, new Attribute[] { tempAttr }); //品号 defaultType.RegisterSimpleProperty("item_no", businessSrv.GetBusinessType("ItemCode"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("ItemCode") }); //特征码 defaultType.RegisterSimpleProperty("item_feature_no", businessSrv.GetBusinessType("ItemFeature"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("ItemFeature") }); //单位 defaultType.RegisterSimpleProperty("picking_unit_no", businessSrv.GetBusinessType("UnitCode"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("UnitCode") }); //仓库 defaultType.RegisterSimpleProperty("warehouse_no", businessSrv.GetBusinessType("WarehouseCode"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("WarehouseCode") }); //库位 defaultType.RegisterSimpleProperty("storage_spaces_no", businessSrv.GetBusinessType("Bin"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("Bin") }); //批号 defaultType.RegisterSimpleProperty("lot_no", businessSrv.GetBusinessType("LotCode"), string.Empty, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("LotCode") }); //拣货数量 defaultType.RegisterSimpleProperty("picking_qty", businessSrv.GetBusinessType("Quantity"), 0M, false, new Attribute[] { businessSrv.GetSimplePropertyAttribute("Quantity") }); //条码编号 tempAttr = new SimplePropertyAttribute(GeneralDBType.String); tempAttr.Size = 1000; defaultType.RegisterSimpleProperty("barcode_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); _tempScanDetail = defaultType; _qurService.CreateTempTable(_tempScanDetail); #endregion }
/// <summary> /// 异常服务返回集合 /// </summary> /// <returns></returns> public static DependencyObjectCollection CreateExceptionReturnCollection() { DependencyObjectType type = new DependencyObjectType("ReturnCollection"); type.RegisterSimpleProperty("code", typeof(int)); type.RegisterSimpleProperty("sql_code", typeof(string)); type.RegisterSimpleProperty("description", typeof(string)); type.RegisterSimpleProperty("report_no", typeof(string)); DependencyObjectCollection Rtn = new DependencyObjectCollection(type); return(Rtn); }
/// <summary> /// 获取企业信息 /// </summary> /// <returns></returns> public Hashtable GetCompany() { DependencyObjectType type = new DependencyObjectType("enterprise_detail"); type.RegisterSimpleProperty("enterprise_no", typeof(string)); type.RegisterSimpleProperty("enterprise_name", typeof(string)); DependencyObjectCollection enterpriseDetail = new DependencyObjectCollection(type); const string company = "99"; DependencyObject entity = enterpriseDetail.AddNew(); entity["enterprise_no"] = company; entity["enterprise_name"] = company; return(new Hashtable { { "enterprise_detail", enterpriseDetail } }); }
/// <summary> /// 组建空记录 /// </summary> /// <returns></returns> private DependencyObjectCollection CreateEmptyCollection() { string[] columnNames = new string[] { "item_no", "item_name", "item_spec", "item_feature_no", "item_feature_name", "inventory_unit", "enterprise_no", "site_no", "warehouse_no", "storage_spaces_no", "last_transaction_date" //"result", //"message" }; DependencyObjectType rtnType = new DependencyObjectType("resultItem"); foreach (string item in columnNames) { rtnType.RegisterSimpleProperty(item, typeof(string)); } DependencyObjectCollection rtnColl = new DependencyObjectCollection(rtnType); return(rtnColl); }
/// <summary> /// 移除不需要的列 /// </summary> /// <param name="entity">实体集合</param> /// <param name="excludeColumns">需要移除的列</param> /// <returns></returns> private DependencyObjectCollection RemoveObjectType(DependencyObjectCollection entity, string[] excludeColumns) { DependencyObjectType cloneObjectType = new DependencyObjectType("collection1_clone"); IDataEntityType dataEntityType = entity.ItemDependencyObjectType; foreach (ISimpleProperty property in dataEntityType.SimpleProperties) { if (!excludeColumns.Contains(property.Name)) { cloneObjectType.RegisterSimpleProperty(property.Name, property.PropertyType); } } DependencyObjectCollection cloneObject = new DependencyObjectCollection(cloneObjectType);//克隆对象 foreach (DependencyObject item in entity) { var newItem = cloneObject.AddNew(); foreach (ISimpleProperty property in ((IDataEntityType)item.DependencyObjectType).SimpleProperties) { if (newItem.DependencyObjectType.Properties.Contains(property.Name)) { newItem[property.Name] = item[property.Name]; } } } return(cloneObject); }
/// <summary> /// 创建服务返回集合 /// </summary> /// <returns></returns> private DependencyObjectCollection CreateReturnCollection() { DependencyObjectType type = new DependencyObjectType("ReturnCollection"); type.RegisterSimpleProperty("doc_no", typeof(string)); DependencyObjectCollection Rtn = new DependencyObjectCollection(type); return(Rtn); }
/// <summary> /// 创建服务返回集合 /// </summary> /// <returns></returns> public DependencyObjectCollection CreateReturnCollection() { DependencyObjectType type = new DependencyObjectType("ReturnCollection"); type.RegisterSimpleProperty("doc_no", typeof(string)); DependencyObjectCollection collDepObj = new DependencyObjectCollection(type); return(collDepObj); }
/// <summary> /// 创建空的服务返回集合 /// </summary> /// <returns></returns> private DependencyObjectCollection CreateReturnCollectionForItemDetail() { DependencyObjectType type = new DependencyObjectType("item_detail"); type.RegisterSimpleProperty("item_no", typeof(string)); type.RegisterSimpleProperty("item_name", typeof(string)); type.RegisterSimpleProperty("item_spec", typeof(string)); type.RegisterSimpleProperty("warehouse_no", typeof(string)); type.RegisterSimpleProperty("item_feature_no", typeof(string)); type.RegisterSimpleProperty("item_feature_name", typeof(string)); type.RegisterSimpleProperty("storage_spaces_no", typeof(string)); type.RegisterSimpleProperty("lot_no", typeof(string)); type.RegisterSimpleProperty("inventory_unit", typeof(string)); type.RegisterSimpleProperty("inventory_qty", typeof(decimal)); DependencyObjectCollection rtn = new DependencyObjectCollection(type); return(rtn); }
/// <summary> /// 创建空的服务返回集合 /// </summary> /// <returns></returns> private DependencyObjectCollection CreateReturnCollection() { DependencyObjectType type = new DependencyObjectType("barcode_detail"); type.RegisterSimpleProperty("barcode_no", typeof(string)); type.RegisterSimpleProperty("item_no", typeof(string)); type.RegisterSimpleProperty("item_feature_no", typeof(string)); //20170329 add by wangrm for P001-170316001 type.RegisterSimpleProperty("item_feature_name", typeof(string)); //20170329 add by wangrm for P001-170316001 type.RegisterSimpleProperty("warehouse_no", typeof(string)); type.RegisterSimpleProperty("storage_spaces_no", typeof(string)); type.RegisterSimpleProperty("lot_no", typeof(string)); type.RegisterSimpleProperty("inventory_unit", typeof(string)); type.RegisterSimpleProperty("inventory_qty", typeof(decimal)); DependencyObjectCollection rtn = new DependencyObjectCollection(type); return(rtn); }
/// <summary> /// 创建界面绑定view /// </summary> /// <returns></returns> private DependencyObjectView CreateDataSource() { DependencyObjectType type = new DependencyObjectType("Type"); type.RegisterSimpleProperty("Function", typeof(string)); foreach (ParaEntity para in CurrentFunction.ParaList) { type.RegisterSimpleProperty(para.ConditionName, typeof(string)); type.RegisterSimpleProperty(para.Name, para.ParaType); if (para.ParaTypeFlag == ParaTypeEnum.SelectControl) { type.RegisterSimpleProperty(para.Name.Replace("_ID", "_NAME"), typeof(string)); type.RegisterSimpleProperty(para.Name.Replace("_ID", "_CODE"), typeof(string)); } } DependencyObject obj = new DependencyObject(type); DependencyObjectView view = new DependencyObjectView(obj); return(view); }
public void creatTmp(string TypeKey, out DataTable dt, out DependencyObjectType targetType) { dt = null; targetType = null; string[] spiltTypeKeys = null; bool isColls = false; string primaryKey = string.Empty; if (TypeKey.Contains(@".")) { spiltTypeKeys = TypeKey.Split(new[] { '.' }); TypeKey = spiltTypeKeys[0]; primaryKey = spiltTypeKeys[spiltTypeKeys.Length - 2]; isColls = true; } ICreateService createSrv = Provider.GetService(typeof(ICreateService), TypeKey) as ICreateService; if (createSrv == null) { return; } var entity = createSrv.Create() as DependencyObject; DependencyObjectType toType = entity.DependencyObjectType; if (isColls && spiltTypeKeys != null) { spiltTypeKeys.ToList().ForEach(key => { if (!key.Equals(TypeKey)) { toType = ((ICollectionProperty)(toType.Properties[key])).ItemDataEntityType as DependencyObjectType; } }); } IBusinessTypeService businessTypeSrv = Provider.GetService(typeof(IBusinessTypeService), CallContext.TypeKey) as IBusinessTypeService; targetType = RegiesterType(toType, targetType); if (isColls) { string primaryKeyName = primaryKey + "_ID"; targetType.RegisterSimpleProperty(primaryKeyName, businessTypeSrv.SimplePrimaryKeyType, null, false, new Attribute[] { businessTypeSrv.SimplePrimaryKey }); } dt = CreateDt(targetType, dt); }
/// <summary> /// 移动应用自动产生批号服务 /// </summary> /// <param name="program_job_no">作业编号</param> /// <param name="status">执行动作</param> /// <param name="item_no">料件编号</param> /// <param name="item_feature_no">产品特征</param> /// <param name="site_no">营运据点</param> /// <param name="object_no">供货商编号//作業編號=1.2.3為必要輸入</param> /// <param name="action">动作:Q.查询 I.新增</param> /// <param name="lot_no">批号:当动作=Q时,为必输</param> /// <returns></returns> public Hashtable LotNoAndSerialNoCoding(string program_job_no, string status, string item_no, string item_feature_no, string site_no, string object_no, string action, string lot_no) //20170109 modi by wangyq for P001-170118001 添加后两个参数 //20170109 add by wangyq for P001-170118001 =============begin============== { if (action == "Q" && string.IsNullOrEmpty(lot_no)) { throw new ArgumentNullException("lot_no"); } //20170109 add by wangyq for P001-170118001 =============end============== string[] convertJobNos = new string[] { "1", "2", "3", "9" }; DependencyObjectType resultType = new DependencyObjectType("lot_detail"); resultType.RegisterSimpleProperty("lot_no", typeof(string)); resultType.RegisterSimpleProperty("item_no", typeof(string)); resultType.RegisterSimpleProperty("item_feature_no", typeof(string)); //20170109 add by wangyq for P001-170118001 =============begin============== resultType.RegisterSimpleProperty("lot_description", typeof(string)); resultType.RegisterSimpleProperty("effective_date", typeof(string)); resultType.RegisterSimpleProperty("effective_deadline", typeof(string)); resultType.RegisterSimpleProperty("remarks", typeof(string)); //20170109 add by wangyq for P001-170118001 =============end============== DependencyObjectCollection sourceDocDetail = new DependencyObjectCollection(resultType); IdEntity idEntity = ConvertToId(item_no, item_feature_no, site_no, object_no); if (action == "I") //新增逻辑20170109 add by wangyq for P001-170118001 { if (convertJobNos.Contains(program_job_no)) { Digiwin.ERP.Common.Business.ILotNoAndSerialNoCodingService commonLotSerialService = this.GetServiceForThisTypeKey <Digiwin.ERP.Common.Business.ILotNoAndSerialNoCodingService>(); DependencyObject commonLotResult = commonLotSerialService.LotNoAndSerialNoCoding("1", idEntity.PlantId, idEntity.ItemId, idEntity.SupplierId, idEntity.ItemFeatureId, DateTime.Now.Date, true);//20170410 modi by wangrm 启萌口述新需求 OLD:false->true DependencyObject resultObj = sourceDocDetail.AddNew(); resultObj["lot_no"] = commonLotResult["LOT_CODE"]; resultObj["item_no"] = item_no; resultObj["item_feature_no"] = item_feature_no; //20170109 add by wangyq for P001-170118001 =============begin============== //resultObj["lot_description"] = commonLotResult["LOT_CODE"];//20170509 modi by liwei1 for B001-170505004 resultObj["lot_description"] = string.Empty;//20170509 add by liwei1 for B001-170505004 resultObj["effective_date"] = commonLotResult["EFFECTIVE_DATE"].ToDate().ToString("yyyy-MM-dd"); resultObj["effective_deadline"] = commonLotResult["INEFFECTIVE_DATE"].ToDate().ToString("yyyy-MM-dd"); resultObj["remarks"] = string.Empty; //20170109 add by wangyq for P001-170118001 =============end============== InsertItemLot(commonLotResult, idEntity.ItemId, idEntity.ItemFeatureId);//20170106 add by wangyq for P001-161230002 增加批号的新增数据库逻辑 } } else if (action == "Q") //20170109 add by wangyq for P001-170118001 =============begin============== { QueryNode node = OOQL.Select(OOQL.CreateProperty("ITEM_LOT.LOT_CODE"), OOQL.CreateProperty("ITEM_LOT.LOT_DESCRIPTION"), OOQL.CreateProperty("ITEM_LOT.EFFECTIVE_DATE"), OOQL.CreateProperty("ITEM_LOT.INEFFECTIVE_DATE"), OOQL.CreateProperty("ITEM_LOT.REMARK")) .From("ITEM_LOT", "ITEM_LOT") .Where(OOQL.AuthFilter("ITEM_LOT", "ITEM_LOT") & (OOQL.CreateProperty("ITEM_LOT.ITEM_ID") == OOQL.CreateConstants(idEntity.ItemId) & OOQL.CreateProperty("ITEM_LOT.ITEM_FEATURE_ID") == OOQL.CreateConstants(idEntity.ItemFeatureId) & OOQL.CreateProperty("ITEM_LOT.LOT_CODE") == OOQL.CreateConstants(lot_no))); DependencyObjectCollection lotColl = this.GetService <IQueryService>().ExecuteDependencyObject(node); foreach (DependencyObject lotObj in lotColl) { DependencyObject resultObj = sourceDocDetail.AddNew(); resultObj["lot_no"] = lotObj["LOT_CODE"]; resultObj["item_no"] = item_no; resultObj["item_feature_no"] = item_feature_no; resultObj["lot_description"] = lotObj["LOT_DESCRIPTION"]; resultObj["effective_date"] = lotObj["EFFECTIVE_DATE"].ToDate().ToString("yyyy-MM-dd"); resultObj["effective_deadline"] = lotObj["INEFFECTIVE_DATE"].ToDate().ToString("yyyy-MM-dd"); resultObj["remarks"] = lotObj["REMARK"]; } } //20170109 add by wangyq for P001-170118001 =============end============== //组合返回结果 Hashtable result = new Hashtable(); //添加单据下载数据 result.Add("lot_detail", sourceDocDetail); return(result); }
/// <summary> /// 构建reason_list返回值 /// </summary> /// <returns></returns> private DependencyObjectType StructureReceiptList() { DependencyObjectType receiptListType = new DependencyObjectType("receipt_list"); receiptListType.RegisterSimpleProperty("seq", typeof(int)); receiptListType.RegisterSimpleProperty("item_no", typeof(string)); receiptListType.RegisterSimpleProperty("item_name", typeof(string)); receiptListType.RegisterSimpleProperty("item_spec", typeof(string)); receiptListType.RegisterSimpleProperty("item_feature_no", typeof(string)); receiptListType.RegisterSimpleProperty("item_feature_name", typeof(string)); receiptListType.RegisterSimpleProperty("unit_no", typeof(string)); receiptListType.RegisterSimpleProperty("receipt_qty", typeof(decimal)); receiptListType.RegisterSimpleProperty("ok_qty", typeof(decimal)); receiptListType.RegisterSimpleProperty("unqualified_qty", typeof(decimal)); //20170801 add by liwei1 for P001-170717001 receiptListType.RegisterSimpleProperty("checkdestroy_qty", typeof(decimal)); //20170801 add by liwei1 for P001-170717001reason_no receiptListType.RegisterSimpleProperty("result_type", typeof(string)); receiptListType.RegisterSimpleProperty("qc_group", typeof(string)); receiptListType.RegisterSimpleProperty("qc_degree", typeof(string)); receiptListType.RegisterSimpleProperty("qc_level", typeof(string)); receiptListType.RegisterSimpleProperty("qc_type", typeof(string)); receiptListType.RegisterCollectionProperty("qc_list", StructureQcList()); return(receiptListType); }
private void CreateTempTable() { IBusinessTypeService businessTypeSrv = GetServiceForThisTypeKey <IBusinessTypeService>(); #region 单头临时表 string tempName = "Table_scan" + "_" + DateTime.Now.ToString("HHmmssfff"); DependencyObjectType defaultType = new DependencyObjectType(tempName, new Attribute[] { null }); SimplePropertyAttribute tempAttr = new SimplePropertyAttribute(GeneralDBType.String); #region 字段 //营运据点 defaultType.RegisterSimpleProperty("site_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //条码编号 defaultType.RegisterSimpleProperty("barcode_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //料件编号 defaultType.RegisterSimpleProperty("item_no", businessTypeSrv.GetBusinessType("ItemCode"), string.Empty, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("ItemCode") }); //产品特征 defaultType.RegisterSimpleProperty("item_feature_no", businessTypeSrv.GetBusinessType("ItemFeature"), string.Empty, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("ItemFeature") }); //库位编号 defaultType.RegisterSimpleProperty("warehouse_no", businessTypeSrv.GetBusinessType("WarehouseCode"), string.Empty, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("WarehouseCode") }); //储位编号 defaultType.RegisterSimpleProperty("storage_spaces_no", businessTypeSrv.GetBusinessType("Bin"), string.Empty, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("Bin") }); //批号 defaultType.RegisterSimpleProperty("lot_no", businessTypeSrv.GetBusinessType("LotCode"), string.Empty, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("LotCode") }); //盘点数量 defaultType.RegisterSimpleProperty("qty", businessTypeSrv.GetBusinessType("Quantity"), 0M, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("Quantity") }); //盘点人员 defaultType.RegisterSimpleProperty("employee_no", businessTypeSrv.GetBusinessType("BusinessCode"), string.Empty, false, new Attribute[] { businessTypeSrv.GetSimplePropertyAttribute("BusinessCode") }); //盘点日期 defaultType.RegisterSimpleProperty("complete_date", typeof(DateTime), OrmDataOption.EmptyDateTime, false, new Attribute[] { new SimplePropertyAttribute(GeneralDBType.Date) }); //交易对象类型 defaultType.RegisterSimpleProperty("transaction_type", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); tempAttr.Size = 10; //交易对象编号 defaultType.RegisterSimpleProperty("transaction_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); #endregion _Table_scan = defaultType; _qurService.CreateTempTable(_Table_scan); #endregion }
/// <summary> /// /// </summary> /// <param name="employee_no">扫描人员</param> /// <param name="scan_type">扫描类型1.有箱条码 2.无箱条码</param> /// <param name="report_datetime">上传时间</param> /// <param name="picking_department_no">部门</param> /// <param name="recommended_operations">建议执行作业</param> /// <param name="recommended_function">A.新增 S.过帐</param> /// <param name="scan_doc_no">扫描单号</param> /// <param name="collScan"></param> public DependencyObjectCollection InertTransactionDoc(string employee_no, string scan_type, DateTime report_datetime, string picking_department_no, string recommended_operations, string recommended_function, string scan_doc_no, DependencyObjectCollection scanColl) { IInfoEncodeContainer InfoEncodeSrv = this.GetService <IInfoEncodeContainer>(); if (Maths.IsEmpty(recommended_operations)) { throw new BusinessRuleException(InfoEncodeSrv.GetMessage("A111201", "recommended_operations"));//‘入参【recommended_operations】未传值’ } if (Maths.IsEmpty(recommended_function)) { throw new BusinessRuleException(InfoEncodeSrv.GetMessage("A111201", "recommended_function"));//‘入参【recommended_function】未传值’ } DependencyObjectType type = new DependencyObjectType("ReturnCollection"); type.RegisterSimpleProperty("doc_no", typeof(string)); DependencyObjectCollection Rtn = new DependencyObjectCollection(type); if (scanColl.Count > 0) { string stockAction = string.Empty; string view = string.Empty; if (recommended_operations.StartsWith("11")) { stockAction = "-1"; view = "TRANSACTION_DOC.I02"; } else if (recommended_operations.StartsWith("12")) { stockAction = "1"; view = "TRANSACTION_DOC.I01"; } DependencyObjectCollection docColl = ValidateDocSet(stockAction, scanColl[0]["site_no"].ToStringExtension()); if (docColl.Count <= 0) { throw new BusinessRuleException(InfoEncodeSrv.GetMessage("A111275")); } DataTable dtScan = CreateDtScan(); DataTable dtScanDetail = CreateDtScanDetail(); PrepareDtForInsertScan(employee_no, picking_department_no, scanColl, dtScan, dtScanDetail); using (IConnectionService connService = this.GetService <IConnectionService>()) { _qurService = this.GetService <IQueryService>(); CreateTemp(); InsertTemp(dtScan, dtScanDetail); List <DependencyObject> saveEntities = AddEntity(docColl[0]["DOC_ID"], docColl[0]["SEQUENCE_DIGIT"].ToInt32(), report_datetime, stockAction); if (saveEntities.Count > 0) { using (ITransactionService transService = this.GetService <ITransactionService>()) { InsertBCLine(report_datetime);//20170413 add by wangyq for P001-170412001 需要在保存服务之前,保存自动审核会需要回写 //保存单据 ISaveService saveSrv = this.GetService <ISaveService>("TRANSACTION_DOC"); saveSrv.Save(saveEntities.ToArray()); UpdateTD();//更新 //InsertBCLine(report_datetime);//20170413 mark by wangyq for P001-170412001 //EFNET签核 foreach (DependencyObject item in saveEntities) { IEFNETStatusStatusService efnetSrv = this.GetService <IEFNETStatusStatusService>(); efnetSrv.GetFormFlow(view, item["DOC_ID"], ((DependencyObject)item["Owner_Org"])["ROid"], new object[] { item["TRANSACTION_DOC_ID"] }); } transService.Complete(); } foreach (DependencyObject item in saveEntities) { DependencyObject obj = Rtn.AddNew(); obj["doc_no"] = item["DOC_NO"]; } } } } return(Rtn); }
/// <summary> /// 构建reason_list返回值 /// </summary> /// <returns></returns> private DependencyObjectType StructureQcList() { DependencyObjectType qcListType = new DependencyObjectType("qc_list"); qcListType.RegisterSimpleProperty("qc_seq", typeof(int)); qcListType.RegisterSimpleProperty("test_no", typeof(string)); qcListType.RegisterSimpleProperty("test_name", typeof(string)); qcListType.RegisterSimpleProperty("defect_level", typeof(string)); qcListType.RegisterSimpleProperty("reject_qty", typeof(decimal)); qcListType.RegisterSimpleProperty("test_qty", typeof(decimal)); qcListType.RegisterSimpleProperty("reason_qty", typeof(decimal)); qcListType.RegisterSimpleProperty("acceptable_qty", typeof(decimal)); //20170801 add by liwei1 for P001-170717001 qcListType.RegisterSimpleProperty("rejected_qty", typeof(decimal)); //20170801 add by liwei1 for P001-170717001 qcListType.RegisterSimpleProperty("return_qty", typeof(decimal)); qcListType.RegisterSimpleProperty("reason_no", typeof(string)); //缺点原因 qcListType.RegisterSimpleProperty("measure_max", typeof(decimal)); qcListType.RegisterSimpleProperty("measure_min", typeof(decimal)); qcListType.RegisterSimpleProperty("result_type", typeof(string)); qcListType.RegisterCollectionProperty("reason_list", StructureReasonList()); qcListType.RegisterCollectionProperty("attrib_list", StructureAttribList()); return(qcListType); }
/// <summary> /// 检验单获取质检方案相关抽样数量 /// </summary> /// <param name="paraInspectionPlanId">质检方案id</param> /// <param name="paraInspectionItemId">检验项目</param> /// <param name="paraQty">送检批量</param> /// <param name="paraDegree">宽严程度</param> /// <returns></returns> public DependencyObject GetInspectionQty(object paraInspectionPlanId, object paraInspectionItemId, decimal paraQty, string paraDegree) { IQueryService querySrv = GetService <IQueryService>(); DependencyObject queryPlan = null; QueryNode node = OOQL.Select((Formulas.Case(null, OOQL.CreateProperty("A.MI_AQL"), OOQL.CreateCaseArray( OOQL.CreateCaseItem( OOQL.CreateProperty("B.DEFECT_CLASS") == OOQL.CreateConstants("1"), OOQL.CreateProperty("A.CR_AQL")), OOQL.CreateCaseItem( OOQL.CreateProperty("B.DEFECT_CLASS") == OOQL.CreateConstants("2"), OOQL.CreateProperty("A.MA_AQL"))), "AQL")), (Formulas.Case(null, OOQL.CreateProperty("A.MI_LQ"), OOQL.CreateCaseArray( OOQL.CreateCaseItem( OOQL.CreateProperty("B.DEFECT_CLASS") == OOQL.CreateConstants("1"), OOQL.CreateProperty("A.CR_LQ")), OOQL.CreateCaseItem( OOQL.CreateProperty("B.DEFECT_CLASS") == OOQL.CreateConstants("2"), OOQL.CreateProperty("A.MA_LQ"))), "LQ")), (Formulas.Case(null, OOQL.CreateProperty("A.MI_RQL"), OOQL.CreateCaseArray( OOQL.CreateCaseItem( OOQL.CreateProperty("B.DEFECT_CLASS") == OOQL.CreateConstants("1"), OOQL.CreateProperty("A.CR_RQL")), OOQL.CreateCaseItem( OOQL.CreateProperty("B.DEFECT_CLASS") == OOQL.CreateConstants("2"), OOQL.CreateProperty("A.MA_RQL"))), "RQL")), OOQL.CreateProperty("A.INSPECTION_TIMES", "INSPECTION_TIMES"), OOQL.CreateProperty("B.IL", "IL"), OOQL.CreateProperty("B.DL", "DL"), OOQL.CreateProperty("A.INSPECTION_METHOD", "INSPECTION_METHOD"), OOQL.CreateProperty("A.AI_STANDARD", "AI_STANDARD"), OOQL.CreateProperty("A.VI_STANDARD", "VI_STANDARD"), OOQL.CreateProperty("A.CUSTOM_STANDARD_ID", "CUSTOM_STANDARD_ID"), OOQL.CreateProperty("B.DEFECT_CLASS", "DEFECT_CLASS"), OOQL.CreateProperty("A.INSPECTION_PLAN_ID", "INSPECTION_PLAN_ID"), OOQL.CreateProperty("B.INSPECTION_ITEM_ID", "INSPECTION_ITEM_ID"), OOQL.CreateProperty("A.MODE", "MODE")) .From("INSPECTION_PLAN", "A") .LeftJoin("INSPECTION_PLAN.INSPECTION_PLAN_D", "B") .On(OOQL.CreateProperty("A.INSPECTION_PLAN_ID") == OOQL.CreateProperty("B.INSPECTION_PLAN_ID")) .Where(OOQL.AuthFilter("INSPECTION_PLAN", "A") & OOQL.CreateProperty("A.INSPECTION_PLAN_ID") == OOQL.CreateConstants(paraInspectionPlanId) & OOQL.CreateProperty("B.INSPECTION_ITEM_ID") == OOQL.CreateConstants(paraInspectionItemId)); DependencyObjectCollection coll = querySrv.ExecuteDependencyObject(node); if (coll != null && coll.Count > 0) { queryPlan = coll[0]; } if (queryPlan == null) { return(null); } //6.2 根据抽样标准call不同的服务 //6.2.1 全检 DependencyObject result; if (queryPlan["INSPECTION_METHOD"].ToInt32() == 2) { return(null); } INumberedSampleTestService numberedSampleTestService = GetService <INumberedSampleTestService>("AI_STANDARD"); if (queryPlan["AI_STANDARD"].Equals("1") || queryPlan["AI_STANDARD"].Equals("4")) { result = numberedSampleTestService.GetNumberStandard(paraQty, paraDegree, queryPlan["IL"].ToString(), queryPlan["AQL"].ToString(), queryPlan["INSPECTION_TIMES"].ToString()); } else if (queryPlan["AI_STANDARD"].Equals("2")) { if (queryPlan["MODE"].Equals("1")) { result = numberedSampleTestService.GetNumberStandard(paraQty, queryPlan["LQ"].ToString(), queryPlan["INSPECTION_TIMES"].ToString()); } else { result = numberedSampleTestService.GetNumberStandard(paraQty, queryPlan["LQ"].ToString(), queryPlan["INSPECTION_TIMES"].ToString(), queryPlan["IL"].ToString()); } } else if (queryPlan["AI_STANDARD"].Equals("0")) { result = numberedSampleTestService.GetNumberStandard(queryPlan["DL"].ToString(), queryPlan["RQL"].ToString()); } else { return(null); } //6.2.4 抽检GB2829(暂不实现) //6.2.5 抽检自定义 if (!Maths.IsEmpty(queryPlan["CUSTOM_STANDARD_ID"])) { ICustomTestService customTestService = GetService <ICustomTestService>("CUSTOM_STANDARD"); DependencyObject obj = customTestService.GetCustomStandard(queryPlan["CUSTOM_STANDARD_ID"], paraQty); result["SAMPLE_SIZE_1ST"] = Convert.ToInt32(obj["SAMPLE_SIZE"].ToDecimal()); result["AC_1ST"] = Convert.ToInt32(obj["AC"].ToDecimal()); result["RE_1ST"] = Convert.ToInt32(obj["RE"].ToDecimal()); result["Result"] = obj["Result"].ToBoolean(); } //6.2.6 回传处理,如果样本量大于送检量,则样本量等于送检数量 zhufei //(/ / / /)>送检量(paraQty) decimal sampleSize1St = result["SAMPLE_SIZE_1ST"].ToDecimal(); decimal sampleSize2Nd = result["SAMPLE_SIZE_2ND"].ToDecimal(); decimal sampleSize3Rd = result["SAMPLE_SIZE_3RD"].ToDecimal(); decimal sampleSize4Th = result["SAMPLE_SIZE_4TH"].ToDecimal(); decimal sampleSize5Th = result["SAMPLE_SIZE_5TH"].ToDecimal(); if (result["SAMPLE_SIZE_1ST"].ToDecimal() > paraQty) { sampleSize1St = paraQty; } if (result["SAMPLE_SIZE_2ND"].ToDecimal() > paraQty) { sampleSize2Nd = paraQty; } if (result["SAMPLE_SIZE_3RD"].ToDecimal() > paraQty) { sampleSize3Rd = paraQty; } if (result["SAMPLE_SIZE_4TH"].ToDecimal() > paraQty) { sampleSize4Th = paraQty; } if (result["SAMPLE_SIZE_5TH"].ToDecimal() > paraQty) { sampleSize5Th = paraQty; } DependencyObjectType root01 = new DependencyObjectType("INSPECTION_QTY"); root01.RegisterSimpleProperty("SAMPLE_SIZE_1ST", typeof(decimal)); root01.RegisterSimpleProperty("AC_1ST", typeof(decimal)); root01.RegisterSimpleProperty("RE_1ST", typeof(decimal)); root01.RegisterSimpleProperty("SAMPLE_SIZE_2ND", typeof(decimal)); root01.RegisterSimpleProperty("AC_2ND", typeof(decimal)); root01.RegisterSimpleProperty("RE_2ND", typeof(decimal)); root01.RegisterSimpleProperty("SAMPLE_SIZE_3RD", typeof(decimal)); root01.RegisterSimpleProperty("AC_3RD", typeof(decimal)); root01.RegisterSimpleProperty("RE_3RD", typeof(decimal)); root01.RegisterSimpleProperty("SAMPLE_SIZE_4TH", typeof(decimal)); root01.RegisterSimpleProperty("AC_4TH", typeof(decimal)); root01.RegisterSimpleProperty("RE_4TH", typeof(decimal)); root01.RegisterSimpleProperty("SAMPLE_SIZE_5TH", typeof(decimal)); root01.RegisterSimpleProperty("AC_5TH", typeof(decimal)); root01.RegisterSimpleProperty("RE_5TH", typeof(decimal)); root01.RegisterSimpleProperty("Result", typeof(Boolean)); root01.RegisterSimpleProperty("Msg", typeof(String)); DependencyObject collection = new DependencyObject(root01); collection["SAMPLE_SIZE_1ST"] = sampleSize1St; // result["SAMPLE_SIZE_1ST"]; collection["AC_1ST"] = result["AC_1ST"]; collection["RE_1ST"] = result["RE_1ST"]; collection["SAMPLE_SIZE_2ND"] = sampleSize2Nd; // result["SAMPLE_SIZE_2ND"]; collection["AC_2ND"] = result["AC_2ND"]; collection["RE_2ND"] = result["RE_2ND"]; collection["SAMPLE_SIZE_3RD"] = sampleSize3Rd; // result["SAMPLE_SIZE_3RD"]; collection["AC_3RD"] = result["AC_3RD"]; collection["RE_3RD"] = result["RE_3RD"]; collection["SAMPLE_SIZE_4TH"] = sampleSize4Th; // result["SAMPLE_SIZE_4TH"]; collection["AC_4TH"] = result["AC_4TH"]; collection["RE_4TH"] = result["RE_4TH"]; collection["SAMPLE_SIZE_5TH"] = sampleSize5Th; // result["SAMPLE_SIZE_5TH"]; collection["AC_5TH"] = result["AC_5TH"]; collection["RE_5TH"] = result["RE_5TH"]; collection["Result"] = result["Result"]; collection["Msg"] = result["Msg"]; return(collection); }
/// <summary> /// 创建临时表#Table_scan_detail /// </summary> /// <returns></returns> private void CreateTempTableScanDetail() { string tempName = "TEMP_SCAN_DETAIL" + "_" + DateTime.Now.ToString("HHmmssfff"); DependencyObjectType defaultType = new DependencyObjectType(tempName, new Attribute[] { }); SimplePropertyAttribute tempAttr = new SimplePropertyAttribute(GeneralDBType.String); #region 字段 ////主键 //defaultType.RegisterSimpleProperty("Table_scan_detail_ID", _businessTypeSrv.SimplePrimaryKeyType, // Maths.GuidDefaultValue(), false, // new Attribute[] { _businessTypeSrv.SimplePrimaryKey }); //信息批号 defaultType.RegisterSimpleProperty("info_lot_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); // 转入仓库 defaultType.RegisterSimpleProperty("site_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //条码编号 defaultType.RegisterSimpleProperty("barcode_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //料件编号 defaultType.RegisterSimpleProperty("item_no", _businessTypeSrv.SimpleItemCodeType, string.Empty, false, new Attribute[] { _businessTypeSrv.SimpleItemCode }); // 产品特征 defaultType.RegisterSimpleProperty("item_feature_no", _businessTypeSrv.SimpleItemFeatureType, string.Empty, false, new Attribute[] { _businessTypeSrv.SimpleItemFeature }); // 仓库 defaultType.RegisterSimpleProperty("warehouse_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //库位 defaultType.RegisterSimpleProperty("storage_spaces_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //批号 defaultType.RegisterSimpleProperty("lot_no", _businessTypeSrv.SimpleLotCodeType, string.Empty, false, new Attribute[] { _businessTypeSrv.SimpleLotCode }); //拣货数量 defaultType.RegisterSimpleProperty("picking_qty", _businessTypeSrv.SimpleQuantityType, 0m, false, new Attribute[] { _businessTypeSrv.SimpleQuantity }); //拣货单位 defaultType.RegisterSimpleProperty("picking_unit_no", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //单号 defaultType.RegisterSimpleProperty("doc_no", _businessTypeSrv.SimpleDocNoType, string.Empty, false, new Attribute[] { _businessTypeSrv.SimpleDocNo }); //来源序号 tempAttr = new SimplePropertyAttribute(GeneralDBType.Int32); defaultType.RegisterSimpleProperty("seq", typeof(int), 0, false, new Attribute[] { tempAttr }); #endregion _TEMP_SCAN_DETAIL = defaultType; _querySrv.CreateTempTable(defaultType); }
/// <summary> /// 存储所需修改IssueReceiptD的数据集合的临时表 /// </summary> private IDataEntityType CreateIssueReceiptDTmpTable(IQueryService qrySrv) { string typeName = "Temp_UpdateIssueReceiptD_" + DateTime.Now.ToString("HHmmssfff");// 临时表表名的处理 DependencyObjectType defaultType = new DependencyObjectType(typeName, new Attribute[] { }); IBusinessTypeService businessSrv = this.GetServiceForThisTypeKey <IBusinessTypeService>(); SimplePropertyAttribute simplePrimaryAttri = businessSrv.SimplePrimaryKey; SimplePropertyAttribute qtyAttri = businessSrv.SimpleQuantity; SimplePropertyAttribute tempAttr; #region 字段 //单号 tempAttr = new SimplePropertyAttribute(GeneralDBType.String); defaultType.RegisterSimpleProperty("DOC_NO", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //序号 tempAttr = new SimplePropertyAttribute(GeneralDBType.Int32); defaultType.RegisterSimpleProperty("SequenceNumber", typeof(int), 0, false, new Attribute[] { tempAttr }); //拣货数量 //该数量等价于规格中的picking_qty defaultType.RegisterSimpleProperty("ISSUE_RECEIPT_QTY", businessSrv.SimpleQuantityType, 0m, false, new Attribute[] { qtyAttri }); //工厂编号 tempAttr = new SimplePropertyAttribute(GeneralDBType.String); defaultType.RegisterSimpleProperty("PLANT_CODE", typeof(string), string.Empty, false, new Attribute[] { tempAttr }); //品号 defaultType.RegisterSimpleProperty("ITEM_CODE", businessSrv.SimpleItemCodeType, "", false, new Attribute[] { businessSrv.SimpleItemCode }); //特征码 defaultType.RegisterSimpleProperty("ITEM_FEATURE_CODE", businessSrv.SimpleItemFeatureType, "", false, new Attribute[] { businessSrv.SimpleItemFeature }); tempAttr = new SimplePropertyAttribute(GeneralDBType.String); //单位编号 defaultType.RegisterSimpleProperty("UNIT_CODE", typeof(string), "", false, new Attribute[] { tempAttr }); //仓库编号 defaultType.RegisterSimpleProperty("WAREHOUSE_CODE", typeof(string), "", false, new Attribute[] { tempAttr }); //库位编号 defaultType.RegisterSimpleProperty("BIN_CODE", typeof(string), "", false, new Attribute[] { tempAttr }); //批号 defaultType.RegisterSimpleProperty("LOT_CODE", businessSrv.SimpleLotCodeType, "", false, new Attribute[] { businessSrv.SimpleLotCode }); //条码 defaultType.RegisterSimpleProperty("BARCODE_NO", typeof(string), "", false, new Attribute[] { tempAttr }); #endregion qrySrv.CreateTempTable(defaultType); return(defaultType); }