public override object Authenticate(IObjectSpace objectSpace) { string systemUserName = WindowsIdentity.GetCurrent().Name; string enteredUserName = ((AuthenticationStandardLogonParameters)LogonParameters).UserName; if (string.IsNullOrEmpty(enteredUserName)) { throw new ArgumentException(SecurityExceptionLocalizer.GetExceptionMessage(SecurityExceptionId.UserNameIsEmpty)); } if (!String.Equals(systemUserName, enteredUserName)) { throw new AuthenticationException(enteredUserName, "Invalid user name"); } object user = objectSpace.FindObject(UserType, new BinaryOperator("UserName", systemUserName)); if (user == null) { user = objectSpace.CreateObject(UserType); ((IAuthenticationActiveDirectoryUser)user).UserName = systemUserName; bool strictSecurityStrategyBehavior = SecurityModule.StrictSecurityStrategyBehavior; SecurityModule.StrictSecurityStrategyBehavior = false; objectSpace.CommitChanges(); SecurityModule.StrictSecurityStrategyBehavior = strictSecurityStrategyBehavior; } if (!((IAuthenticationStandardUser)user).ComparePassword(((AuthenticationStandardLogonParameters)LogonParameters).Password)) { throw new AuthenticationException(systemUserName, SecurityExceptionLocalizer.GetExceptionMessage(SecurityExceptionId.RetypeTheInformation)); } return user; }
public override object Authenticate(IObjectSpace objectSpace) { object user = objectSpace.FindObject(UserType, findUserCriteria); if (user == null) { throw new AuthenticationException(findUserCriteria.ToString()); } return user; }
private object AuthenticateActiveDirectory(IObjectSpace objectSpace) { var windowsIdentity = WindowsIdentity.GetCurrent(); if (windowsIdentity != null) { string userName = windowsIdentity.Name; var user = (IAuthenticationActiveDirectoryUser)objectSpace.FindObject(UserType, new BinaryOperator("UserName", userName)); if (user == null) { if (_createUserAutomatically) { var args = new CustomCreateUserEventArgs(objectSpace, userName); if (!args.Handled) { user = (IAuthenticationActiveDirectoryUser)objectSpace.CreateObject(UserType); user.UserName = userName; if (Security != null) { //Security.InitializeNewUser(objectSpace, user); Security.CallMethod("InitializeNewUser", new object[]{objectSpace, user}); } } objectSpace.CommitChanges(); } } if (user == null) { throw new AuthenticationException(userName); } return user; } return null; }
public static void CreateDummyUsers(IObjectSpace ObjectSpace) { var adminRole = ObjectSpace.FindObject<SecuritySystemRole>(new BinaryOperator("Name", SecurityStrategy.AdministratorRoleName)); if (adminRole == null) { adminRole = ObjectSpace.CreateObject<SecuritySystemRole>(); adminRole.Name = SecurityStrategy.AdministratorRoleName; adminRole.IsAdministrative = true; adminRole.Save(); } var userRole = ObjectSpace.FindObject<SecuritySystemRole>(new BinaryOperator("Name", "User")); if (userRole == null) { userRole = ObjectSpace.CreateObject<SecuritySystemRole>(); userRole.Name = "User"; var userTypePermission = ObjectSpace.CreateObject<SecuritySystemTypePermissionObject>(); userTypePermission.TargetType = typeof(SecuritySystemUser); var currentUserObjectPermission = ObjectSpace.CreateObject<SecuritySystemObjectPermissionsObject>(); currentUserObjectPermission.Criteria = "[Oid] = CurrentUserId()"; currentUserObjectPermission.AllowNavigate = true; currentUserObjectPermission.AllowRead = true; userTypePermission.ObjectPermissions.Add(currentUserObjectPermission); userRole.TypePermissions.Add(userTypePermission); } var user1 = ObjectSpace.FindObject<SecuritySystemUser>( new BinaryOperator("UserName", "Sam")); if (user1 == null) { user1 = ObjectSpace.CreateObject<SecuritySystemUser>(); user1.UserName = "******"; // Set a password if the standard authentication type is used user1.SetPassword(""); } // If a user named 'John' doesn't exist in the database, create this user var user2 = ObjectSpace.FindObject<SecuritySystemUser>( new BinaryOperator("UserName", "John")); if (user2 == null) { user2 = ObjectSpace.CreateObject<SecuritySystemUser>(); user2.UserName = "******"; // Set a password if the standard authentication type is used user2.SetPassword(""); } user1.Roles.Add(adminRole); user2.Roles.Add(userRole); }
public override object Authenticate(IObjectSpace objectSpace) { object user = objectSpace.FindObject(UserType, workflowWorkerUserCriteria); if (user == null) { throw new AuthenticationException("", "Cannot find workflow worker user."); } return user; }
private object AuthenticateStandard(IObjectSpace objectSpace) { if (string.IsNullOrEmpty(logonParameters.UserName)) throw new ArgumentException(SecurityExceptionLocalizer.GetExceptionMessage(SecurityExceptionId.UserNameIsEmpty)); var user = (IAuthenticationStandardUser)objectSpace.FindObject(UserType, new BinaryOperator("UserName", logonParameters.UserName)); if (user == null || !user.ComparePassword(logonParameters.Password)) { throw new AuthenticationException(logonParameters.UserName, SecurityExceptionLocalizer.GetExceptionMessage(SecurityExceptionId.RetypeTheInformation)); } return user; }
public override object Authenticate(IObjectSpace objectSpace) { if (string.IsNullOrEmpty(parameters.UserName)) throw new ArgumentException(SecurityExceptionLocalizer.GetExceptionMessage(SecurityExceptionId.UserNameIsEmpty)); var user = (IAuthenticationStandardUser)objectSpace.FindObject(UserType,CriteriaOperator.Parse("UserName = ?", parameters.UserName)); if (user == null ||!user.ComparePassword(parameters.Password)){ throw new AuthenticationException(parameters.UserName, SecurityExceptionLocalizer.GetExceptionMessage(SecurityExceptionId.RetypeTheInformation)); } return user; }
public static IFirstLaunchParameters GetInstance(IObjectSpace objectSpace) { var parameters = objectSpace.FindObject<IFirstLaunchParameters>(null); if (parameters == null) { parameters = objectSpace.CreateObject<IFirstLaunchParameters>(); parameters.DummyObjectsCreated = false; } return parameters; }
/// <summary> /// Gets the session. /// </summary> /// <param name="objectSpace">The object space.</param> /// <param name="packageSession">The package session.</param> /// <returns>New external protocol session</returns> public static ExternalProtocolSession GetSession(IObjectSpace objectSpace, PackageSession packageSession) { var result = objectSpace.FindObject<ExternalProtocolSession>( CriteriaOperator.Parse("SessionId = ?", packageSession.SessionId), true); if(result == null) { result = objectSpace.CreateObject<ExternalProtocolSession>(); result.SessionId = packageSession.SessionId; result.Route = packageSession.Route; result.StartedOn = packageSession.StartedOn; result.CommitedOn = packageSession.CommitedOn; if (packageSession.Parent != null) result.Parent = GetSession(objectSpace, packageSession.Parent); } return result; }
protected virtual object GetObjectCore(IModelDetailView modelView, object objectKey, IObjectSpace objectSpace) { Type type = modelView.ModelClass.TypeInfo.Type; object obj; if (XafTypesInfo.CastTypeToTypeInfo(type).IsPersistent) { if (objectKey != null && !(objectKey is CriteriaOperator)) obj = objectSpace.GetObjectByKey(type, objectKey); else { obj = objectSpace.FindObject(type, (CriteriaOperator)objectKey) ?? objectSpace.CreateObject(type); if (!(objectSpace.IsNewObject(obj))) ((IXafApplication)_application).AfterViewShown += OnAfterViewShown; } } else { obj = (type.GetConstructor(new[] { typeof(Session) }) != null) ? objectSpace.CreateObject(type) : Activator.CreateInstance(type); } return obj; }
public static NameSpace CreateNameSpace(string ns,IObjectSpace ObjectSpace) { var find = ObjectSpace.FindObject<NameSpace>(new BinaryOperator("FullName", ns)); if (find == null) { var part = ns.Split('.'); if (part.Length > 0) { find = ObjectSpace.CreateObject<NameSpace>(); find.名称 = part[part.Length - 1]; if (part.Length > 1) { find.Parent = CreateNameSpace(string.Join(".", part.Take(part.Length - 1)), ObjectSpace); } } } return find; }
public static BusinessObject AddBusinessObject(Type type, string caption, NameSpace nameSpace, string description, bool isRuntimeDefine,IObjectSpace ObjectSpace) { var t = ObjectSpace.FindObject<BusinessObject>(new BinaryOperator("FullName", type.FullName),true); if (t == null) { t = ObjectSpace.CreateObject<BusinessObject>(); t.DisableCreateGenericParameterValues = true; t.Category = nameSpace; t.名称 = type.Name; t.Caption = caption; t.Description = description; t.FullName = type.FullName; //t.CanCustomLogic = typeof(ICustomLogic).IsAssignableFrom(type); t.IsGenericTypeDefine = type.IsGenericType; t.IsRuntimeDefine = isRuntimeDefine; } return t; }
public void Process(XafApplication application,IObjectSpace objectSpace) { var user = objectSpace.FindObject(XpandModuleBase.UserType, new GroupOperator(GroupOperatorType.Or,new BinaryOperator("UserName", UserName),new BinaryOperator("Email",Email)),true) as IAuthenticationStandardUser; if (user != null&&!objectSpace.IsNewObject(user)) throw new ArgumentException(CaptionHelper.GetLocalizedText(XpandSecurityModule.XpandSecurity, "AlreadyRegistered")); var securityUserWithRoles = objectSpace.IsNewObject(user)? (ISecurityUserWithRoles) user : (ISecurityUserWithRoles)objectSpace.CreateObject(XpandModuleBase.UserType); User = securityUserWithRoles; var userTypeInfo = application.TypesInfo.FindTypeInfo(XpandModuleBase.UserType); var modelRegistration = (IModelRegistration)((IModelOptionsRegistration)application.Model.Options).Registration; AddRoles(modelRegistration, userTypeInfo, securityUserWithRoles, objectSpace); userTypeInfo.FindMember("UserName").SetValue(securityUserWithRoles,UserName); userTypeInfo.FindMember("IsActive").SetValue(securityUserWithRoles,modelRegistration.ActivateUser); modelRegistration.EmailMember.MemberInfo.SetValue(securityUserWithRoles,Email); var activationLinkMember = modelRegistration.ActivationIdMember; if (activationLinkMember!=null) { activationLinkMember.MemberInfo.SetValue(securityUserWithRoles, Guid.NewGuid().ToString()); } securityUserWithRoles.CallMethod("SetPassword", Password); objectSpace.CommitChanges(); }
public static DataTable ImportReceiveCaseBase(DataTable dtExcelData, IObjectSpace objectSpace) { var dtFormatData = dtExcelData.Copy(); dtFormatData.Columns.Add("导入结果"); dtFormatData.Columns.Add("相关信息"); if (!dtFormatData.Columns.Contains("我方卷号")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在我方卷号列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("新申请")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在新申请列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("转入案")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在转入案列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("特殊案")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在特殊案列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("分案")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在分案列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } foreach (DataRow drData in dtFormatData.Rows) { try { if (string.IsNullOrWhiteSpace(drData["我方卷号"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "我方卷号为空"; continue; } var caseBase = objectSpace.FindObject <CaseBase>(CriteriaOperator.Parse($"s_OurNo = '{drData["我方卷号"]}'")) ?? objectSpace.CreateObject <CaseBase>(); caseBase.s_OurNo = drData["我方卷号"]?.ToString().Trim(); caseBase.b_IsApplication = drData["新申请"]?.ToString().Trim().ToUpper() == "Y"; caseBase.b_IsDivCase = drData["分案"]?.ToString().Trim().ToUpper() == "Y"; caseBase.b_IsMiddle = drData["转入案"]?.ToString().Trim().ToUpper() == "Y"; caseBase.b_IsSepcial = drData["特殊案"]?.ToString().Trim().ToUpper() == "Y"; caseBase.GetCaseInfo(); caseBase.Save(); objectSpace.CommitChanges(); drData["导入结果"] = "成功"; } catch (Exception e) { drData["导入结果"] = "失败"; drData["相关信息"] = e.ToString(); objectSpace.Rollback(); } } return(dtFormatData); }
/// <summary> /// 导入方法 /// </summary> /// <param name="dtExcelData"></param> /// <param name="objectSpace"></param> /// <returns></returns> public static DataTable ImportDataOld(DataTable dtExcelData, IObjectSpace objectSpace) { var dtFormatData = dtExcelData.Copy(); dtFormatData.Columns.Add("导入结果"); dtFormatData.Columns.Add("相关信息"); //dtFormatData.Columns["导入结果"].SetOrdinal(0); //dtFormatData.Columns.Add("相关信息").SetOrdinal(0); foreach (DataRow drData in dtFormatData.Rows) { try { if (string.IsNullOrWhiteSpace(drData["卷号"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "卷号为空"; continue; } if (string.IsNullOrWhiteSpace(drData["内容"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "内容为空"; continue; } if (string.IsNullOrWhiteSpace(drData["日期"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "日期为空"; continue; } string sInterNo = null; var internalType = EnumsAll.InternalType.其他; if (!string.IsNullOrWhiteSpace(drData["开草单日期"]?.ToString()) && !string.IsNullOrWhiteSpace(drData["草单编号"]?.ToString())) { sInterNo = drData["开草单日期"].ToString() + drData["草单编号"]; if (sInterNo.Length < 8) { drData["导入结果"] = "失败"; drData["相关信息"] = "草单编号不合法"; continue; } var oldInterNo = objectSpace.FindObject <InternalInvoice>(new BinaryOperator("InternalNo", sInterNo)); if (oldInterNo != null) { drData["导入结果"] = "失败"; drData["相关信息"] = "存在相同编号的草单"; continue; } var sCondition = $"OurNo = '{drData["卷号"]}' And Content = '{drData["内容"]}' "; switch (sInterNo[6].ToString()) { case "1": sCondition += $" And InternalType = '{(int)EnumsAll.InternalType.中间}'"; break; case "2": sCondition += $" And InternalType = '{(int)EnumsAll.InternalType.OA}'"; break; case "3": sCondition += $" And InternalType = '{(int)EnumsAll.InternalType.年费}'"; break; case "4": sCondition += $" And InternalType = '{(int)EnumsAll.InternalType.新申请}'"; break; case "7": sCondition += $" And InternalType = '{(int)EnumsAll.InternalType.其他}'"; break; default: drData["导入结果"] = "失败"; drData["相关信息"] = "草单类型解析错误"; continue; } oldInterNo = objectSpace.FindObject <InternalInvoice>(CriteriaOperator.Parse(sCondition)); if (oldInterNo != null) { drData["导入结果"] = "失败"; drData["相关信息"] = "存在相同案卷&内容&类型的草单"; continue; } switch (sInterNo[6].ToString()) { case "1": internalType = EnumsAll.InternalType.中间; break; case "2": internalType = EnumsAll.InternalType.OA; break; case "3": internalType = EnumsAll.InternalType.年费; break; case "4": internalType = EnumsAll.InternalType.新申请; break; } } var internalInvoice = objectSpace.CreateObject <InternalInvoice>(); internalInvoice.InternalNo = sInterNo; internalInvoice.OurNo = drData["卷号"].ToString(); internalInvoice.SetCaseInfo(drData["卷号"].ToString()); internalInvoice.CreateDate = Convert.ToDateTime(drData["日期"].ToString()); internalInvoice.SendDate = internalInvoice.CreateDate.AddDays(3); internalInvoice.Deadline = internalInvoice.CreateDate.AddDays(7); internalInvoice.Type = drData["类别"].ToString(); internalInvoice.Content = drData["内容"].ToString(); internalInvoice.PermissionPolicyUser = objectSpace.GetObjectByKey <SysUser>(SecuritySystem.CurrentUserId); internalInvoice.InternalType = internalType; internalInvoice.Save(); objectSpace.CommitChanges(); drData["导入结果"] = "成功"; } catch (Exception e) { drData["导入结果"] = "失败"; drData["相关信息"] = e.ToString(); objectSpace.Rollback(); } } return(dtFormatData); }
public static IBusinessObject Exist(IObjectSpace os, string name) { return(os.FindObject <IBusinessObject>(new BinaryOperator("Name", name))); }
[Route("SendOrder/{Send_No}")] // ใส่ OIDSendOrderSeed ใบนำส่ง /SendOrder/226-0011 //[JwtAuthentication] public IHttpActionResult SendOrderSeedDetail_ByOrderSeedID() { object Send_No = string.Empty; object ReceiveOrgOid = string.Empty; Approve_Model sendDetail = new Approve_Model(); SendOrderSeed_Model Model = new SendOrderSeed_Model(); try { if (HttpContext.Current.Request.Form["Send_No"].ToString() != null) { Send_No = HttpContext.Current.Request.Form["Send_No"].ToString(); } if (HttpContext.Current.Request.Form["ReceiveOrgOid"].ToString() != null) { ReceiveOrgOid = HttpContext.Current.Request.Form["ReceiveOrgOid"].ToString(); } XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeed)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc); List <Approve_Model> list = new List <Approve_Model>(); List <SendOrderSeed_Model> list_detail = new List <SendOrderSeed_Model>(); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); SendOrderSeed sendOrderSeed; sendOrderSeed = ObjectSpace.FindObject <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus = 2 and SendNo=? and ReceiveOrgOid=? ", Send_No, ReceiveOrgOid)); //sendOrderSeed = ObjectSpace.GetObject<SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus = 2 and ReceiveOrgOid=? ", null)); if (Send_No != null) { double sum = 0; sendDetail.Send_No = sendOrderSeed.SendNo; sendDetail.SendDate = Convert.ToDateTime(sendOrderSeed.SendDate).ToString("dd-MM-yyyy", new CultureInfo("us-US")); sendDetail.SendOrgName = sendOrderSeed.SendOrgOid.SubOrganizeName; sendDetail.ReceiveOrgName = sendOrderSeed.ReceiveOrgOid.SubOrganizeName; sendDetail.Remark = sendOrderSeed.Remark; sendDetail.SendStatus = sendOrderSeed.SendStatus.ToString(); sendDetail.FinanceYear = sendOrderSeed.FinanceYearOid.YearName; //if (sendOrderSeed.CancelMsg == null) //{ // sendDetail.CancelMsg = "ไม่"; //} //else //{ // sendDetail.CancelMsg = sendOrderSeed.CancelMsg; //} foreach (SendOrderSeedDetail row in sendOrderSeed.SendOrderSeedDetails) { SendOrderSeed_Model send_Detail = new SendOrderSeed_Model(); send_Detail.LotNumber = row.LotNumber.LotNumber; send_Detail.WeightUnit = row.WeightUnitOid.UnitName; send_Detail.AnimalSeedCode = row.AnimalSeedCode; send_Detail.AnimalSeedLevel = row.AnimalSeedLevel; send_Detail.AnimalSeedName = row.AnimalSeeName; send_Detail.BudgetSource = row.BudgetSourceOid.BudgetName; send_Detail.Weight = row.Weight.ToString(); send_Detail.Used = row.Used.ToString(); if (row.SendOrderSeed != null) { send_Detail.SendOrderSeed = row.SendOrderSeed.SendNo; } send_Detail.AnimalSeedOid = row.AnimalSeedOid.SeedName; send_Detail.AnimalSeedLevelOid = row.AnimalSeedLevelOid.SeedLevelName; send_Detail.SeedTypeOid = row.SeedTypeOid.SeedTypeName; send_Detail.Amount = row.Amount; sum = sum + row.Weight; list_detail.Add(send_Detail); } sendDetail.Weight_All = sum.ToString() + " " + "กิโลกรัม"; sendDetail.objSeed = list_detail; return(Ok(sendDetail)); } else { return(BadRequest("NoData")); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(BadRequest(ex.Message)); } }
public InitWMSDataController() { this.components = new System.ComponentModel.Container(); this.TargetWindowType = WindowType.Main; var initData = new SimpleAction(this.components); initData.Category = "Tools"; initData.Caption = "生成默认数据"; initData.Id = "InitData"; initData.Execute += (snd, e) => { ObjectSpace = Application.CreateObjectSpace(); var inited = ObjectSpace.GetObjectsCount(typeof(产品), null) > 0; var tdch = new CIIP.Module.DatabaseUpdate.TestDataGeneratorHelper(); if (!inited) { var t = CreateUnit("台"); var g = CreateUnit("个"); CreateProduct("Surface 3 64G 2G", t, 2000, 2999); CreateProduct("Surface 3 128G 4G", t, 2000, 4888); CreateProduct("Surface Pro 3 I3 64G 4G", t, 3000, 4499); CreateProduct("Surface Pro 3 I5 128G 4G", t, 4500, 5699); CreateProduct("Surface Pro 3 I5 256G 8G", t, 6388, 6999); CreateProduct("Surface Pro 3 I7 256G 8G", t, 7000, 8888); CreateProduct("Surface Pro 3 I7 512G 8G", t, 8000, 9999); CreateProduct("Surface Pro 4 CoreM 128G 8G", t, 5688, 6688); CreateProduct("Surface Pro 4 I5 128G 8G", t, 6388, 7388); CreateProduct("Surface Pro 4 I5 256G 8G", t, 6388, 9688); CreateProduct("Surface Pro 4 I7 256G 16G", t, 6388, 13388); CreateProduct("Surface Notebook I5 128G 8G", t, 10000, 11088); CreateProduct("Surface Notebook I5 256G 16G", t, 10000, 14088); CreateProduct("Surface Notebook I7 256G 16G", t, 13000, 15588); CreateProduct("Surface Notebook I7 512G 16G", t, 15000, 20088); var microsoft = CreateCompany("Microsoft", "比尔.盖茨", "13800001111", "徐家汇", true, true); var google = CreateCompany("Google", "拉里·佩奇", "13988881111", "徐家汇", true, true); var baidu = CreateCompany("Baidu", "李彦宏", "13900001111", "陆家嘴", true, true); var tencent = CreateCompany("Tencent", "15912111211", "马化腾", "陆家嘴", true, true); var ali = CreateCompany("Alibaba", "15612121212", "马云", "陆家嘴", true, true); //500个客户 } var area = ObjectSpace.FindObject<省份>(null); if (area == null) { var js = CreateSF("江苏"); CreateCity(js, "苏州", "姑苏区,相城区,吴中区,虎丘区,工业园区,吴江区,张家港市,常熟市,太仓巿,昆山市"); CreateCity(js, "南京", "鼓楼区,白下区,玄武区,秦淮区,建邺区,下关区,雨花台区,栖霞区,高淳县,溧水县,六合区,浦口区,江宁区"); var tjs = CreateSF("天津"); CreateCity(tjs, "天津", "和平区,河东区,河西区,南开区,河北区,红桥区,滨海新区,东丽区,西青区,津南区,北辰区,武清区,宝坻区,宁河区,静海区,蓟县"); var cqs = CreateSF("重庆"); CreateCity(cqs, "重庆", "渝中区,大渡口区,江北区,沙坪坝区,九龙坡区,南岸区,北碚区,渝北区,巴南区,涪陵区,綦江区,大足区,长寿区,江津区,合川区,永川区,南川区,璧山区,铜梁区,潼南区,荣昌区,万州区,梁平县,城口县,丰都县,垫江县,忠县,开县,云阳县,奉节县,巫山县,巫溪县,黔江区,武隆县,石柱土家族自治县,秀山土家族苗族自治县,酉阳土家族苗族自治县,彭水苗族土家族自治县"); var zjs = CreateSF("浙江"); CreateCity(zjs, "杭州", "市区,上城区,下城区,江干区,拱墅区,西湖区,滨江区,萧山区,余杭区,富阳区,桐庐县,淳安县,建德市,临安市"); var scs = CreateSF("四川"); CreateCity(scs, "成都", "武侯区,锦江区,青羊区,金牛区,成华区,龙泉驿区,温江区,新都区,青白江区,双流区,郫县,蒲江县,大邑县,金堂县,新津县,都江堰市,彭州市,邛崃市,崇州市"); var gds = CreateSF("广东"); CreateCity(gds, "广州", "越秀区,荔湾区,海珠区,天河区,白云区,黄埔区,番禺区,花都区,南沙区,增城区,从化区"); var szs = CreateSF("深圳"); CreateCity(szs, "深圳", "福田区,罗湖区,南山区,盐田区,宝安区,龙岗区"); var shs = CreateSF("上海"); CreateCity(shs, "上海", "黄浦区,浦东新区,徐汇区,长宁区,静安区,普陀区,虹口区,杨浦区,闵行区,宝山区,嘉定区,金山区,松江区,青浦区,奉贤区,崇明县"); var bjs = CreateSF("北京"); CreateCity(bjs, "北京", "东城区,西城区,海淀区,朝阳区,丰台区,石景山区,门头沟区,通州区,顺义区,房山区,大兴区,昌平区,怀柔区,平谷区,密云区,延庆区"); ObjectSpace.CommitChanges(); var s = ObjectSpace.GetObjects<销售区域>(); var customers = tdch.GetRandomNames(500); var rnd = new Random(); foreach (var customer in customers) { CreateCompany(customer, customer, "13900005555", "中国", false, true, s[rnd.Next(s.Count - 1)]); } } }; this.Actions.Add(initData); this.RegisterActions(this.components); // Target required Views (via the TargetXXX properties) and create their Actions. }
public override object Authenticate(IObjectSpace objectSpace) { if(string.IsNullOrEmpty(logonParameters.UserName)) { throw new UserFriendlyException("The 'User' field must not be empty."); } object user = objectSpace.FindObject<SecurityDemoUser>(new DevExpress.Data.Filtering.BinaryOperator("UserName", logonParameters.UserName)); if(user == null) { throw new AuthenticationException(logonParameters.UserName); } return user; }
static public void ImportBuhData(IObjectSpace os, fmCAVTInvoiceRegister register) { UInt32 seq_num = 1; IList <fmCAVTInvoiceType> inv_types = os.GetObjects <fmCAVTInvoiceType>(); IList <fmCAVTInvoiceTransferType> inv_transfer_types = os.GetObjects <fmCAVTInvoiceTransferType>(); IList <fmCAVTInvoiceOperationType> inv_oper_types = os.GetObjects <fmCAVTInvoiceOperationType>(); foreach (var invrec in register.BookBuhImport.BookBuhRecords. Where(rec => rec.BookType == "P" && (rec.RecordType == "PAY" || rec.RecordType == "AIN" || rec.RecordType == "EAT") || rec.BookType == "B" && (rec.RecordType == "PAY")). GroupBy(rec => new { rec.AVTInvoicePartyCode, rec.AVTInvoiceType, rec.AVTInvoiceNumber, rec.AVTInvoiceDate }). OrderBy(rec => rec.Key.AVTInvoiceDate.ToString("yyyyMMdd") + rec.Key.AVTInvoiceNumber)) { if (String.IsNullOrEmpty(invrec.Key.AVTInvoiceNumber.Trim()) || String.IsNullOrEmpty(invrec.Key.AVTInvoicePartyCode.Trim())) { continue; } if (invrec.Key.AVTInvoiceType != "явт" && invrec.Key.AVTInvoiceType != "ятю" && invrec.Key.AVTInvoiceType != "ятб") { continue; } crmCParty party = os.GetObjects <crmCParty>(new BinaryOperator("Code", invrec.Key.AVTInvoicePartyCode)).FirstOrDefault(); fmCAVTInvoiceBase invoice = os.FindObject <fmCAVTInvoiceBase>( CriteriaOperator.And(new BinaryOperator("Number", invrec.Key.AVTInvoiceNumber), new BinaryOperator("Date", invrec.Key.AVTInvoiceDate.Date, BinaryOperatorType.GreaterOrEqual), new BinaryOperator("Date", invrec.Key.AVTInvoiceDate.Date.AddDays(1), BinaryOperatorType.Less), new BinaryOperator("Supplier", register.Party)), true // , new BinaryOperator("Customer", party)) ); if (invoice == null && invrec.Key.AVTInvoiceType == "явт") { invoice = os.CreateObject <fmCAVTInvoiceBase>(); invoice.Number = invrec.Key.AVTInvoiceNumber; invoice.Date = invrec.Key.AVTInvoiceDate; invoice.Supplier = register.Party; invoice.Customer = party; } if (invoice != null) { if (invoice.InvoiceType == null && invoice.Number != null && invoice.Number.Length > 0) { foreach (fmCAVTInvoiceType inv_type in inv_types) { if (inv_type.InvoiceDirection == fmAVTInvoiceDirection.AVTInvoiceOut && inv_type.Prefix == invoice.Number.Substring(0, 1)) { invoice.InvoiceType = inv_type; } } } fmCAVTInvoiceRegisterLine line_check = os.FindObject <fmCAVTInvoiceRegisterLine>( CriteriaOperator.And(new BinaryOperator("InvoiceVersion", invoice.Current)), true); if (line_check != null) { continue; } // if (invrec.Key.AVTInvoiceType != "ятб") { // foreach (fmCAVTBookBuhRecord rec in invrec) { // invoice.SummAVT = invoice.SummAVT + rec.SummVAT; // invoice.SummCost = invoice.SummCost + rec.SummAll - rec.SummVAT; // } // } if (invoice.Customer == null) { invoice.Customer = party; } if (invrec.Key.AVTInvoiceNumber.StartsWith("5")) { invoice.Customer = invoice.Customer; } if (invoice.SummAVT == 0 && invoice.SummCost == 0) { foreach (fmCAVTBookBuhRecord rec in invrec) { decimal summ_vat = rec.SummVAT + rec.SummVATCost + rec.SummVATCost + rec.SummVATExp; invoice.SummAVT = invoice.SummAVT + summ_vat; if (rec.NDSRate == "2") { invoice.SummCost = invoice.SummCost + Decimal.Round(summ_vat * 100m / 18m, 2); } else if (rec.NDSRate == "3") { invoice.SummCost = invoice.SummCost + Decimal.Round(summ_vat * 100m / 10m, 2); } } } fmCAVTInvoiceRegisterLine line = register.OutLines.Where(rec => rec.Invoice == invoice).FirstOrDefault(); if (line == null) { line = os.CreateObject <fmCAVTInvoiceRegisterLine>(); register.OutLines.Add(line); } line.SequenceNumber = seq_num++; line.DateTransfer = invoice.Date; line.Invoice = invoice; line.TransferType = inv_transfer_types.Where(rec => rec.Code == "1").FirstOrDefault(); if (invrec.Key.AVTInvoiceType == "явт") { line.OperationType = inv_oper_types.Where(rec => rec.Code == "01").FirstOrDefault(); } if (invrec.Key.AVTInvoiceType == "ятю") { line.OperationType = inv_oper_types.Where(rec => rec.Code == "02").FirstOrDefault(); } if (invrec.Key.AVTInvoiceType == "ятб") { if (invrec.Where(rec => rec.RecordType == "SMN").Count() != 0) { line.OperationType = inv_oper_types.Where(rec => rec.Code == "08").FirstOrDefault(); } if (invrec.Where(rec => rec.RecordType == "EAT").Count() != 0) { line.OperationType = inv_oper_types.Where(rec => rec.Code == "07").FirstOrDefault(); } } } } seq_num = 1; foreach (var invrec in register.BookBuhImport.BookBuhRecords. Where(rec => rec.BookType == "B" && (rec.RecordType == "BAY" || rec.RecordType == "AON") || rec.BookType == "P" && (rec.RecordType == "BAY")). GroupBy(rec => new { rec.AVTInvoicePartyCode, rec.AVTInvoiceType, rec.AVTInvoiceRegNumber, rec.AVTInvoiceNumber, rec.AVTInvoiceDate }). OrderBy(rec => rec.Key.AVTInvoiceDate.ToString("yyyyMMdd") + rec.Key.AVTInvoiceRegNumber)) { if (String.IsNullOrEmpty(invrec.Key.AVTInvoiceNumber.Trim()) || String.IsNullOrEmpty(invrec.Key.AVTInvoicePartyCode.Trim())) { continue; } if (invrec.Key.AVTInvoiceType != "явт" && invrec.Key.AVTInvoiceType != "ятб") { continue; } crmCParty party = os.FindObject <crmCParty>(new BinaryOperator("Code", invrec.Key.AVTInvoicePartyCode)); fmCAVTInvoiceBase invoice = os.FindObject <fmCAVTInvoiceBase>( CriteriaOperator.And(new BinaryOperator("Number", invrec.Key.AVTInvoiceNumber), new BinaryOperator("Date", invrec.Key.AVTInvoiceDate.Date, BinaryOperatorType.GreaterOrEqual), new BinaryOperator("Date", invrec.Key.AVTInvoiceDate.Date.AddDays(1), BinaryOperatorType.Less), new BinaryOperator("Supplier", party)), true // , new BinaryOperator("Customer", party)) ); // if (invoice == null) { invoice = os.CreateObject <fmCAVTInvoiceBase>(); invoice.RegNumber = invrec.Key.AVTInvoiceRegNumber; invoice.Number = invrec.Key.AVTInvoiceNumber; invoice.Date = invrec.Key.AVTInvoiceDate; invoice.Supplier = party; invoice.Customer = register.Party; } else { fmCAVTInvoiceRegisterLine line_check = os.FindObject <fmCAVTInvoiceRegisterLine>( CriteriaOperator.And(new BinaryOperator("InvoiceVersion", invoice.Current)), true); if (line_check != null) { continue; } } Decimal SummVAT_18 = invrec.Where(buhrec => buhrec.NDSRate == "2").Sum(buhrec => buhrec.SummVATCost + buhrec.SummVATExp + buhrec.SummVAT); Decimal SummVAT_10 = invrec.Where(buhrec => buhrec.NDSRate == "3").Sum(buhrec => buhrec.SummVATCost + buhrec.SummVATExp + buhrec.SummVAT); Decimal SummNoVAT = invrec.Where(buhrec => buhrec.NDSRate == "5").Sum(buhrec => buhrec.SummAll); // Decimal SummCost_18 = Decimal.Round(SummVAT_18 * 100m / 18m, 2); // Decimal SummCost_10 = Decimal.Round(SummVAT_10 * 100m / 10m, 2); // SummCost_NoVAT = SummCost_NoVAT + // Decimal.Round(SummNoVAT_18 * 118m / 18m, 2) + // Decimal.Round(SummNoVAT_10 * 110m / 10m, 2); invoice.SummAVT = SummVAT_18 + SummVAT_10; invoice.SummCost = SummNoVAT + Decimal.Round(SummVAT_18 * 100m / 18m, 2) + Decimal.Round(SummVAT_10 * 100m / 10m, 2); fmCAVTInvoiceRegisterLine line = register.InLines.Where(rec => rec.Invoice == invoice).FirstOrDefault(); if (line == null) { line = os.CreateObject <fmCAVTInvoiceRegisterLine>(); register.InLines.Add(line); } line.SequenceNumber = seq_num++; // line_doc.DateTransfer = invoice.Date; line.Invoice = invoice; line.TransferType = inv_transfer_types.Where(rec => rec.Code == "1").FirstOrDefault(); line.DateTransfer = invrec.Select(rec => rec.BuhDocDate).Min(); if (line.DateTransfer < DateTime.ParseExact("20130101", "yyyyMMdd", null)) { line.DateTransfer = DateTime.ParseExact("20130131", "yyyyMMdd", null); } if (line.DateTransfer < line.Invoice.Date) { line.DateTransfer = line.Invoice.Date; } if (invrec.Key.AVTInvoiceType == "явт") { line.OperationType = inv_oper_types.Where(rec => rec.Code == "01").FirstOrDefault(); } if (invrec.Key.AVTInvoiceType == "ятб") { if (invrec.Where(rec => rec.RecordType == "AON").Count() != 0) { line.OperationType = inv_oper_types.Where(rec => rec.Code == "02").FirstOrDefault(); } if (invrec.Where(rec => rec.RecordType == "SMN").Count() != 0) { line.OperationType = inv_oper_types.Where(rec => rec.Code == "08").FirstOrDefault(); } if (invrec.Where(rec => rec.RecordType == "EAT").Count() != 0) { line.OperationType = inv_oper_types.Where(rec => rec.Code == "07").FirstOrDefault(); } } } }
public static void AfterConstruction(IExamination examination, IObjectSpace os) { examination.Examiner = os.GetObjectByKey<Employee>(SecuritySystem.CurrentUserId); examination.Anamnesis = String.Empty; examination.Description = String.Empty; examination.Drugs = String.Empty; examination.IsPopulatedConclusion = false; if (examination.ConclusionFile == null) { //examination.ConclusionFile = os.CreateObject<FileSystemStoreObject>(); examination.ConclusionFile = os.CreateObject<ConclusionFile>(); var conclusion = examination.ConclusionFile; conclusion.FileName = "Conclusion.rtf"; conclusion.OwnerId = (examination as DevExpress.ExpressApp.DC.DCBaseObject).Oid; var organization = os.FindObject<IOrganization>(null); if (organization != null) { var template = organization.ConclusionTemplate; if (template != null) { CreateFromTemplate(template, conclusion); } } examination.ExaminationNotes = os.CreateObject<IExaminationNotes>(); } }
private void EnviaC() { Anuncio obj = View.CurrentObject as Anuncio; Correo cfg = obj.Session.FindObject <Correo>(null); Empresa emp = obj.Session.FindObject <Empresa>(null); if (obj != null && cfg != null) { CorreoBase objCorreo = View.ObjectSpace.CreateObject <CorreoBase>(); objCorreo.Cuenta = cfg.Cuenta; objCorreo.Identificdr = cfg.Identificdr; objCorreo.Passw = cfg.Passw; objCorreo.Puerto = cfg.Puerto; objCorreo.SegurdSSL = cfg.SegurdSSL; objCorreo.ServidorSMTP = cfg.ServidorSMTP; objCorreo.Usuario = cfg.Usuario; objCorreo.Asunto = "Anuncio iCPAC"; objCorreo.Mensaje1 = obj.Mensaje; //CorreoSend.MandaCorreo(cfg, "*****@*****.**", obj.Mensaje, "iCPAC"); MemoryStream mLogo = null; if (emp != null && emp.Logo != null) { JpegStorageConverter jpeg = new JpegStorageConverter(); Byte[] arr = jpeg.ConvertToStorageType(emp.Logo) as Byte[]; mLogo = new MemoryStream(arr); } // string paramValue = e.ParameterCurrentValue as string; CorreoSend.Client(objCorreo); // CorreoSend.MailMssg(objCorreo, objCorreo.Asunto, "iCPAC", mLogo); if (!string.IsNullOrEmpty(ParamValue)) { IObjectSpace objectSpace = Application.CreateObjectSpace(); Cliente cli = objectSpace.FindObject <Cliente>(new BinaryOperator("Clave", Cliente.ClaveFto(ParamValue))); List <string> arRcpt = new List <string>(); if (cli != null && cli.Compania != null && cli.Compania.Direccion != null && !string.IsNullOrEmpty(cli.Compania.Direccion.Email)) { objCorreo.Mensaje1 = string.Format("{0}{1} <br/> <br />{2}", !string.IsNullOrEmpty(cli.Als) ? cli.Als : string.Empty, Environment.NewLine, obj.Mensaje); CorreoSend.MailMssg(objCorreo, objCorreo.Asunto, "iCPAC", mLogo); arRcpt.Add(cli.Compania.Direccion.Email); CorreoSend.MandaCorreo2(objCorreo, arRcpt); } } else { IObjectSpace objectSpace = Application.CreateObjectSpace(); IList <Cliente> clientes = objectSpace.GetObjects <Cliente> (new BinaryOperator("Status", EStatusPrvdClnt /*StatusTipo*/.Activo)); List <string> arRcpt = new List <string>(); foreach (Cliente cli in clientes) { if (cli != null && cli.Compania != null && cli.Compania.Direccion != null && !string.IsNullOrEmpty(cli.Compania.Direccion.Email)) { if (cli.Status != Cap.Clientes.BusinessObjects.Generales.EStatusPrvdClnt.Suspendido /* Cap.Clientes.BusinessObjects.Generales.StatusTipo.Suspendido*/) { // CorreoSend.MandaCorreo2(objCorreo, cli.Compania.Direccion.Email); if (!string.IsNullOrEmpty(cli.Als)) { objCorreo.Mensaje1 = string.Format("{0}{1} <br/> <br />{2}", cli.Als, Environment.NewLine, obj.Mensaje); } else { objCorreo.Mensaje1 = obj.Mensaje; } arRcpt.Add(cli.Compania.Direccion.Email); CorreoSend.MsgAltClear(); CorreoSend.MailMssg(objCorreo, objCorreo.Asunto, "iCPAC", mLogo); CorreoSend.MandaCorreo2(objCorreo, /*cli.Compania.Direccion.Email*/ arRcpt); arRcpt.Clear(); } } } /* * if (arRcpt.Count > 0) * CorreoSend.MandaCorreo2(objCorreo, / *cli.Compania.Direccion.Email* /arRcpt);*/ } objCorreo.Mensaje1 = objCorreo.Mensaje2 = string.Empty; if (mLogo != null) { mLogo.Dispose(); } } }
public static ISecurityUserWithRoles GetUser(this IObjectSpace objectSpace, string userName, string passWord = "", params ISecurityRole[] roles) => (ISecurityUserWithRoles)objectSpace.FindObject(SecuritySystem.UserType, new BinaryOperator("UserName", userName)) ?? CreateUser(objectSpace, userName, passWord, roles);
// public override void UpdateDatabaseBeforeUpdateSchema() { // base.UpdateDatabaseBeforeUpdateSchema(); // if (this.CurrentDBVersion != new Version("1.1.1.240")) // return; //// ExecuteNonQueryCommand("DROP TABLE \"FmFinPlanDoc\", \"FmFinPlanPlan\", \"FmFinPlanOperation\", \"FmFinPlanJournal\" CASCADE;", false); // } public override void UpdateDatabaseAfterUpdateSchema() { base.UpdateDatabaseAfterUpdateSchema(); if (this.CurrentDBVersion != new Version("1.1.1.240")) { return; } using (IObjectSpace os = ObjectSpace.CreateNestedObjectSpace()) { HrmDepartmentStruct dep_struct = os.CreateObject <HrmDepartmentStruct>(); dep_struct._Code = "УУ"; HrmDepartmentStructItem item = null; item = os.CreateObject <HrmDepartmentStructItem>(); item._StructType = HrmStructItemType.HRM_STRUCT_KB; dep_struct.Items.Add(item); item = os.CreateObject <HrmDepartmentStructItem>(); item._StructType = HrmStructItemType.HRM_STRUCT_ORION; dep_struct.Items.Add(item); item = os.CreateObject <HrmDepartmentStructItem>(); item._StructType = HrmStructItemType.HRM_STRUCT_OZM; dep_struct.Items.Add(item); item = os.CreateObject <HrmDepartmentStructItem>(); item._StructType = HrmStructItemType.HRM_STRUCT_CONTRACT; dep_struct.Items.Add(item); IList <fmCostItem> cost_items = os.GetObjects <fmCostItem>(); fmCostItem cost_item = null; fmCFinIndex fin_index = null; fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "ФОТ")); fin_index.CodeBuh = 4; fin_index.Code = fin_index.Name; fin_index.SortOrder = 2; cost_item = cost_items.FirstOrDefault(x => x.Code == "2000"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2001"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2002"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2003"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2004"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2005"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2006"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2007"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2008"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2011"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2021"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Командировки")); fin_index.CodeBuh = 9; fin_index.Code = fin_index.Name; fin_index.SortOrder = 2; cost_item = cost_items.FirstOrDefault(x => x.Code == "2100"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2101"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2102"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2103"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Накладные")); fin_index.CodeBuh = 8; fin_index.Code = fin_index.Name; fin_index.SortOrder = 2; cost_item = cost_items.FirstOrDefault(x => x.Code == "3001"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "4001"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "4010"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "3002"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "4002"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "4011"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Соц.Страх.")); fin_index.CodeBuh = 8; fin_index.Code = fin_index.Name; fin_index.SortOrder = 2; cost_item = cost_items.FirstOrDefault(x => x.Code == "5003"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2012"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "2022"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Материалы")); fin_index.CodeBuh = 1; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "6000"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "6001"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "6002"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "6004"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "6005"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "6007"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "6009"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Оборудование")); fin_index.CodeBuh = 1; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "6003"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Оборудование")); fin_index.CodeBuh = 1; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "6006"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Смежники")); fin_index.CodeBuh = 1; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "6003"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7001"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Прочие прямые")); fin_index.CodeBuh = 24; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "5005"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "5006"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "5007"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "5008"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "5009"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "5010"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "5011"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7002"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7003"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7004"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7005"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7006"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7007"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7008"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7009"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7010"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7011"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7012"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7013"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7014"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7015"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7016"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } cost_item = cost_items.FirstOrDefault(x => x.Code == "7025"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Выручка")); fin_index.CodeBuh = 94; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "1000"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // // fin_index = os.FindObject <fmCFinIndex>(new BinaryOperator("Name", "Выручка")); fin_index.CodeBuh = 94; fin_index.Code = fin_index.Name; fin_index.SortOrder = 1; cost_item = cost_items.FirstOrDefault(x => x.Code == "1000"); if (cost_item != null) { fin_index.CostItems.Add(cost_item); } // os.CommitChanges(); } }
public HttpResponseMessage RegisterCusService_ByCitizenID() { string CitizenID = string.Empty; try { if (HttpContext.Current.Request.Form["CitizenID"].ToString() != null) { CitizenID = HttpContext.Current.Request.Form["CitizenID"].ToString(); } if (CitizenID != "") { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(RegisterCusService)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); RegicusService_Model RegisterCusServicer_Info = new RegicusService_Model(); RegisterCusService RegisterCusService_; RegisterCusService_ = ObjectSpace.FindObject <RegisterCusService>(CriteriaOperator.Parse("GCRecord is null and CitizenID = ? ", CitizenID)); string TempSubDistrict = "", TempDistrict = ""; if (RegisterCusService_ != null) { RegicusService_Model item = new RegicusService_Model(); item.RegicusServiceOid = RegisterCusService_.Oid.ToString(); item.OrganizationOid = RegisterCusService_.OrganizationOid.Oid.ToString(); item.RegisterDate = RegisterCusService_.RegisterDate.ToString("dd/MM/yyyy"); item.CitizenID = RegisterCusService_.CitizenID; item.TitleOid = RegisterCusService_.TitleOid.Oid.ToString(); item.TitleName = RegisterCusService_.TitleOid.TitleName; item.FirstNameTH = RegisterCusService_.FirstNameTH; item.LastNameTH = RegisterCusService_.LastNameTH; if (RegisterCusService_.GenderOid != null) { item.GenderOid = RegisterCusService_.GenderOid.Oid.ToString(); item.Gender = RegisterCusService_.GenderOid.GenderName; } if (RegisterCusService_.BirthDate != null) { item.BirthDate = RegisterCusService_.BirthDate.ToString("dd/MM/yyyy"); } if (RegisterCusService_.Tel != null) { item.Tel = RegisterCusService_.Tel; } if (RegisterCusService_.Email != null) { item.Email = RegisterCusService_.Email; } item.FullName = item.TitleName + item.FirstNameTH + " " + item.LastNameTH; if (RegisterCusService_.Address != "") { item.Address = RegisterCusService_.Address; } if (RegisterCusService_.Moo != "") { item.Moo = RegisterCusService_.Moo; } if (RegisterCusService_.Soi != " ") { item.Soi = RegisterCusService_.Soi; } if (RegisterCusService_.Road != "") { item.Road = RegisterCusService_.Road; } if (RegisterCusService_.ProvinceOid != null) { item.ProvinceOid = RegisterCusService_.ProvinceOid.Oid.ToString(); item.ProvinceName = RegisterCusService_.ProvinceOid.ProvinceNameTH; if (RegisterCusService_.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempSubDistrict = "แขวง"; } else { TempSubDistrict = "ตำบล"; }; if (RegisterCusService_.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempDistrict = "เขต"; } else { TempDistrict = "อำเภอ"; }; } if (RegisterCusService_.DistrictOid != null) { item.DistrictOid = RegisterCusService_.DistrictOid.Oid.ToString(); item.DistrictName = RegisterCusService_.DistrictOid.DistrictNameTH; } if (RegisterCusService_.SubDistrictOid != null) { item.SubDistrictOid = RegisterCusService_.SubDistrictOid.Oid.ToString(); item.SubDistrictName = RegisterCusService_.SubDistrictOid.SubDistrictNameTH; } if (RegisterCusService_.ZipCode != null) { item.ZipCode = RegisterCusService_.ZipCode; } else { TempDistrict = "อำเภอ"; }; item.FullAddress = "เลขที่" + " " + RegisterCusService_.Address + " หมู่ที่" + " " + checknull(RegisterCusService_.Moo) + " ถนน" + " " + checknull(RegisterCusService_.Road) + " " + TempSubDistrict + " " + RegisterCusService_.SubDistrictOid.SubDistrictNameTH + " " + TempDistrict + " " + RegisterCusService_.DistrictOid.DistrictNameTH + " " + "จังหวัด" + " " + RegisterCusService_.ProvinceOid.ProvinceNameTH + " รหัสไปรษณีย์ " + RegisterCusService_.ZipCode; if (RegisterCusService_.Remark != null) { item.Remark = RegisterCusService_.Remark; } item.IsActive = RegisterCusService_.IsActive; directProvider.Dispose(); return(Request.CreateResponse(HttpStatusCode.OK, item)); } else { return(Request.CreateResponse(HttpStatusCode.NotFound, "NoData")); } } else { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = "กรุณาระบุเลขบัตรประชาชน"; // Return resual return(Request.CreateResponse(HttpStatusCode.NotFound, err)); } } catch (Exception ex) { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
private int LoadScan(Dictionary <string, string> ScanDecodeDictionary, ObjectChangedEventArgs e) { bool addCount = false; string pstring; ScanDecodeDictionary.TryGetValue("01", out pstring); string pItemnumber = pstring; ScanDecodeDictionary.TryGetValue("17", out pstring); string pExpDt = pstring; ScanDecodeDictionary.TryGetValue("10", out pstring); string pLot = pstring; ScanDecodeDictionary.TryGetValue("21", out pstring); string pSerialNumber = pstring; int cc = 0; cc = cc++; IObjectSpace objectSpace = Application.CreateObjectSpace(); SOHeader SOH = objectSpace.CreateObject <SOHeader>(); SOH = objectSpace.GetObject <SOHeader>((SOHeader)View.CurrentObject); SOItemDistibution SID = new SOItemDistibution(SOH.Session); // lets see if the serial number exists in so CriteriaOperator SerialCriteria = CriteriaOperator.Parse("[ItemNumber] = ? and [SerialNumber] = ?", pItemnumber, pSerialNumber); SOPackingSerialNo SOPSN = (SOPackingSerialNo)objectSpace.FindObject(typeof(SOPackingSerialNo), SerialCriteria); if (SOPSN != null) { return(-1); } else // Lets add the serial number in the serial packing list { SOPSN = new SOPackingSerialNo(SOH.Session); SOPSN.SalesOrder = SOH; SOPSN.ItemNumber = pItemnumber.Substring(3); SOPSN.ShipQty = 1; SOPSN.Lot = pLot; SOPSN.ShipQty = 1; SOPSN.SerialNumber = pSerialNumber; SOPSN.Lot = pLot; SOPSN.DateEntered = System.DateTime.Today; SOPSN.UserName = SecuritySystem.CurrentUserName; SOPSN.ExpirationDate = DateTime.ParseExact(pExpDt, "yyMMdd", CultureInfo.CurrentCulture); SOPSN.Save(); SOH.Session.CommitTransaction(); addCount = true; } // lets see if item exists on the SO Packing table CriteriaOperator ItemCriteria = CriteriaOperator.Parse("[ItemNumber] = ? ", pItemnumber); SOPacking SOP = (SOPacking)objectSpace.FindObject(typeof(SOPacking), ItemCriteria); if (addCount) { if (SOP != null) { SOP.ItemQty = SOP.ItemQty++; } else { SOP = new SOPacking(SOH.Session); SOP.ItemNumber = pItemnumber; SOP.SalesOrder = SOH; SOP.ItemQty = 1; } SOP.Save(); } SOH.Save(); SOH.Session.CommitTransaction(); SOH.Reload(); SOH.SOPacking.Reload(); SOH.SoPackingSerialNumbers.Reload(); SOH.Scan = null; return(0); }
public IHttpActionResult RegisterOrgeService() { string TempService_ = string.Empty; registerOrgeService Regi_Orge = new registerOrgeService(); try { string requestString = Request.Content.ReadAsStringAsync().Result; JObject jObject = (JObject)JsonConvert.DeserializeObject(requestString); if (jObject != null) { Regi_Orge.OrganizationOid = jObject.SelectToken("OrganizationOid").Value <string>(); Regi_Orge.OrgeServiceName = jObject.SelectToken("OrgeServiceName").Value <string>(); Regi_Orge.Tel = jObject.SelectToken("Tel").Value <string>(); Regi_Orge.Email = jObject.SelectToken("Email").Value <string>(); Regi_Orge.Address = jObject.SelectToken("Address").Value <string>(); Regi_Orge.Moo = jObject.SelectToken("Moo").Value <string>(); Regi_Orge.Soi = jObject.SelectToken("Soi").Value <string>(); Regi_Orge.Road = jObject.SelectToken("Road").Value <string>(); //Regi_subscriber.Tel = jObject.SelectToken("Tel").Value<string>(); //Regi_subscriber.Email = jObject.SelectToken("Email").Value<string>(); //Regi_subscriber.DisPlayName = jObject.SelectToken("DisPlayName").Value<string>(); //if (jObject.SelectToken("Moo") == null) //{ // Regi_subscriber.Moo = string.Empty; //} //else //{ // Regi_subscriber.Moo = jObject.SelectToken("Moo").Value<string>(); //} //if (jObject.SelectToken("Soi") == null) //{ // Regi_subscriber.Soi = string.Empty; //} //else //{ // Regi_subscriber.Soi = jObject.SelectToken("Soi").Value<string>(); //} //if (jObject.SelectToken("Road") == null) //{ // Regi_subscriber.Road = string.Empty; //} //else //{ // Regi_subscriber.Road = jObject.SelectToken("Road").Value<string>(); //} Regi_Orge.ProvinceOid = jObject.SelectToken("ProvinceOid").Value <string>(); Regi_Orge.DistrictOid = jObject.SelectToken("DistrictOid").Value <string>(); Regi_Orge.SubDistrictOid = jObject.SelectToken("SubDistrictOid").Value <string>(); Regi_Orge.ZipCode = jObject.SelectToken("ZipCode").Value <string>(); //Regi_subscriber.FullAddress = jObject.SelectToken("FullAddress").Value<string>(); } XpoTypesInfoHelper.GetXpoTypeInfoSource(); XPObjectSpaceProvider osProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace objectSpace = osProvider.CreateObjectSpace(); nutrition.Module.OrgeService Regi_OrgeService; XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.OrgeService)); Regi_OrgeService = objectSpace.CreateObject <OrgeService>(); Regi_OrgeService.OrganizationOid = objectSpace.FindObject <Organization>(CriteriaOperator.Parse("GCRecord is null and Status = 1 ", Regi_Orge.OrganizationOid)); Regi_OrgeService.OrgeServiceName = Regi_Orge.OrgeServiceName; Regi_OrgeService.Tel = Regi_Orge.Tel; Regi_OrgeService.Email = Regi_Orge.Email; Regi_OrgeService.Address = Regi_Orge.Address; Regi_OrgeService.Moo = Regi_Orge.Moo; Regi_OrgeService.Soi = Regi_Orge.Soi; Regi_OrgeService.Road = Regi_Orge.Road; Regi_OrgeService.ProvinceOid = objectSpace.FindObject <Province>(CriteriaOperator.Parse("GCRecord is null and Status = 1 ", Regi_Orge.ProvinceOid)); Regi_OrgeService.DistrictOid = objectSpace.FindObject <District>(CriteriaOperator.Parse("GCRecord is null and Status = 1 ", Regi_Orge.DistrictOid)); Regi_OrgeService.SubDistrictOid = objectSpace.FindObject <SubDistrict>(CriteriaOperator.Parse("GCRecord is null and Status = 1 ", Regi_Orge.SubDistrictOid)); objectSpace.CommitChanges(); return(Ok(true)); { return(BadRequest()); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.status = "ผิดพลาด"; err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(BadRequest(ex.Message)); } }
public static DataTable ImportData(DataTable dtExcelData, IObjectSpace objectSpace) { var dtFormatData = dtExcelData.Copy(); dtFormatData.Columns.Add("导入结果"); dtFormatData.Columns.Add("相关信息"); DataColumn dcInternalType = null; if (dtFormatData.Columns.Contains("草单类型")) { dcInternalType = dtFormatData.Columns["草单类型"]; } DataColumn dcType = null; if (dtFormatData.Columns.Contains("类别")) { dcType = dtFormatData.Columns["类别"]; } DataColumn dcFInvoiceNo = null; if (dtFormatData.Columns.Contains("外所账单编号")) { dcFInvoiceNo = dtFormatData.Columns["外所账单编号"]; } if (!dtFormatData.Columns.Contains("我方卷号")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在我方卷号列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("记录日")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在记录日列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } foreach (DataRow drData in dtFormatData.Rows) { try { if (string.IsNullOrWhiteSpace(drData["我方卷号"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "我方卷号为空"; continue; } if (string.IsNullOrWhiteSpace(drData["记录日"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "记录日为空"; continue; } EnumsAll.InternalType sInternalType; if (dcInternalType != null && !string.IsNullOrWhiteSpace(drData["草单类型"]?.ToString())) { if (!Enum.TryParse(drData["草单类型"]?.ToString(), out sInternalType)) { drData["导入结果"] = "失败"; drData["相关信息"] = "草单类型解析错误"; continue; } } else if (dcType != null && !string.IsNullOrWhiteSpace(drData["类别"]?.ToString())) { switch (drData["类别"]?.ToString()) { case "E-A": case "E-B": case "E-U": case "SE": case "U": case "A": case "B": sInternalType = EnumsAll.InternalType.新申请; break; case "E-D": case "D": sInternalType = EnumsAll.InternalType.中间; break; case "E-E": case "E": case "E-F": case "F": case "E-X": case "X": case "E-W": case "W": sInternalType = EnumsAll.InternalType.OA; break; case "C": case "E-S": case "S": sInternalType = EnumsAll.InternalType.年费; break; case "DJ": sInternalType = EnumsAll.InternalType.特殊案件; break; case "P": sInternalType = EnumsAll.InternalType.国外申请; break; case "E-G": case "G": sInternalType = EnumsAll.InternalType.其他; break; default: drData["导入结果"] = "失败"; drData["相关信息"] = "类别解析错误"; continue; } } else { drData["导入结果"] = "失败"; drData["相关信息"] = "缺少类别或草单类型"; continue; } if (dcFInvoiceNo != null && !string.IsNullOrWhiteSpace(drData["外所账单编号"]?.ToString())) { var internalNo = objectSpace.FindObject <InternalInvoice>(CriteriaOperator.Parse($"FirmNo = '{drData["外所账单编号"]}' And OurNo = '{drData["我方卷号"]}'")); if (internalNo != null) { drData["导入结果"] = "失败"; drData["相关信息"] = "存在相同案卷&外所账单编号的草单"; continue; } } var internalNo1 = objectSpace.FindObject <InternalInvoice>(CriteriaOperator.Parse($"InternalType = '{sInternalType}' And OurNo = '{drData["我方卷号"]}' And Content = ' '")); if (internalNo1 != null) { drData["导入结果"] = "失败"; drData["相关信息"] = "存在相同案卷&草单类型&内容的草单"; continue; } var internalInvoice = objectSpace.CreateObject <InternalInvoice>(); internalInvoice.OurNo = drData["我方卷号"].ToString(); internalInvoice.SetCaseInfo(drData["我方卷号"].ToString()); internalInvoice.CreateDate = Convert.ToDateTime(drData["记录日"].ToString()); internalInvoice.SendDate = internalInvoice.CreateDate.AddDays(3); internalInvoice.Deadline = internalInvoice.CreateDate.AddDays(7); internalInvoice.Content = " "; internalInvoice.PermissionPolicyUser = objectSpace.GetObjectByKey <SysUser>(SecuritySystem.CurrentUserId); internalInvoice.InternalType = sInternalType; if (dcFInvoiceNo != null && !string.IsNullOrWhiteSpace(drData["外所账单编号"]?.ToString())) { internalInvoice.FirmNo = drData["外所账单编号"].ToString(); //internalInvoice.IsFAgencyInvoice = true; } internalInvoice.Save(); objectSpace.CommitChanges(); drData["导入结果"] = "成功"; } catch (Exception e) { drData["导入结果"] = "失败"; drData["相关信息"] = e.ToString(); objectSpace.Rollback(); } } return(dtFormatData); }
public HttpResponseMessage OrgeCustomer_All() { string OrgeServiceName = string.Empty; try { if (HttpContext.Current.Request.Form["OrgeServiceName"].ToString() != null) { OrgeServiceName = HttpContext.Current.Request.Form["OrgeServiceName"].ToString(); } XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(OrgeService)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); OrgeService_info Customer_Info = new OrgeService_info(); List <OrgeService_info> list = new List <OrgeService_info>(); List <OrgeServiceDetail_Model> list_detail = new List <OrgeServiceDetail_Model>(); OrgeService OrgeService_; OrgeService_ = ObjectSpace.FindObject <OrgeService>(CriteriaOperator.Parse("GCRecord is null and OrgeServiceName = ? ", OrgeServiceName)); DataSet ds = SqlHelper.ExecuteDataset(scc, CommandType.Text, "select OrgeServiceName from OrgeService where OrgeServiceName = '" + OrgeServiceName + "'"); if (ds.Tables[0].Rows.Count != 0) { //Customer_Info.OrganizationOid = row.OrganizationOid.OrganizeNameTH; // Customer_Info.OrgeServiceID = row.or Customer_Info.OrgeServiceName = OrgeService_.OrgeServiceName; Customer_Info.Tel = OrgeService_.Tel; if (OrgeService_.Email == null) { Customer_Info.Email = "ไม่พบข้อมูลอีเมล์"; } else { Customer_Info.Email = OrgeService_.Email; } if (OrgeService_.Address == null) { Customer_Info.Address = "ไม่พบมูลบ้านเลขที่"; } else { Customer_Info.Address = OrgeService_.Address; } if (OrgeService_.Moo == null) { Customer_Info.Moo = "ไม่พบข้อมูลหมู่"; } else { Customer_Info.Moo = OrgeService_.Moo; } if (OrgeService_.Soi == null) { Customer_Info.Soi = "ไม่พบข้อมูลซอย"; } else { Customer_Info.Soi = OrgeService_.Soi; } if (OrgeService_.Road == null) { Customer_Info.Road = "ไม่พบข้อมูลถนน"; } else { Customer_Info.Road = OrgeService_.Road; } if (OrgeService_.ProvinceOid == null) { Customer_Info.ProvinceName = "ไม่พบข้อมูลจังหวัด"; } else { Customer_Info.ProvinceName = OrgeService_.ProvinceOid.ProvinceNameTH; } if (OrgeService_.DistrictOid == null) { Customer_Info.DistrictName = "ไม่พบข้อมูลอำเภอ"; } else { Customer_Info.DistrictName = OrgeService_.DistrictOid.DistrictNameTH; } if (OrgeService_.SubDistrictOid == null) { Customer_Info.SubDistrictName = "ไม่พบข้อมูลตำบล"; } else { Customer_Info.SubDistrictName = OrgeService_.SubDistrictOid.SubDistrictNameTH; } if (OrgeService_.ZipCode == null) { Customer_Info.ZipCode = "ไม่พบข้อมูลรหัสไปรษณีย์"; } else { Customer_Info.ZipCode = OrgeService_.ZipCode; } string TempSubDistrict, TempDistrict; if (OrgeService_.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempSubDistrict = "แขวง"; } else { TempSubDistrict = "ตำบล"; }; if (OrgeService_.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempDistrict = "เขต"; } else { TempDistrict = "อำเภอ"; }; Customer_Info.FullAddress = "เลขที่" + " " + Customer_Info.Address + " หมู่ที่" + " " + checknull(Customer_Info.Moo) + " ถนน" + " " + checknull(Customer_Info.Road) + " " + TempSubDistrict + " " + Customer_Info.SubDistrictName + " " + TempDistrict + " " + Customer_Info.DistrictName + " " + "จังหวัด" + " " + Customer_Info.ProvinceName + " รหัสไปรษณีย์ " + Customer_Info.ZipCode; foreach (OrgeServiceDetail row in OrgeService_.OrgeServiceDetails) { OrgeServiceDetail_Model Model = new OrgeServiceDetail_Model(); Model.OrgeServiceOid = row.OrgeServiceOid.OrgeServiceName; Model.ServiceTypeOid = row.ServiceTypeOid.ServiceTypeName; Model.SubServiceTypeOid = row.SubServiceTypeOid.ServiceTypeName; list_detail.Add(Model); } Customer_Info.OrgeServiceDetails = list_detail; return(Request.CreateResponse(HttpStatusCode.OK, Customer_Info)); } else { return(Request.CreateResponse(HttpStatusCode.BadRequest, "NoData")); } } catch (Exception ex) { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
public static ModuleArtifact CreateArtifact(IObjectSpace objectSpace, Type artifactType){ var assemblyName = artifactType.Assembly.GetName().Name; var moduleChild = objectSpace.FindObject<ModuleChild>(child => child.AssemblyName == assemblyName); var moduleArtifactType = GetModuleArtifactType(artifactType); return CreateArtifact(moduleChild, moduleArtifactType,objectSpace, artifactType); }
/// <summary> /// Imports the ticket. /// </summary> /// <param name="objectSpace">The object space.</param> /// <param name="source">The source.</param> /// <returns>Imported ticket</returns> public static Ticket ImportTicket(IObjectSpace objectSpace, byte[] source) { Ticket result = null; if (source != null && source.Length > 0) { source = XafDeltaModule.Instance.PackService.UnpackBytes(source, ""); using (var ms = new MemoryStream(source)) using (var xml = XmlReader.Create(ms)) { xml.MoveToContent(); try { xml.ReadStartElement(); var ticketDateTime = DateTime.ParseExact(xml.ReadElementString("TicketDateTime"), "R", null).ToLocalTime(); var ticketNodeId = xml.ReadElementString("TicketNodeId"); var eventType = (PackageEventType) Enum.Parse(typeof (PackageEventType), xml.ReadElementString("EventType")); var packageFileName = xml.ReadElementString("PackageFileName"); var comments = xml.ReadElementString("Comments"); var userName = xml.ReadElementString("UserName"); xml.ReadEndElement(); var package = objectSpace.FindObject<Package>(CriteriaOperator.Parse("FileName = ?", packageFileName)); if (package != null) { result = objectSpace.CreateObject<Ticket>(); result.Package = package; result.Comments = comments; result.TicketDateTime = ticketDateTime; result.TicketNodeId = ticketNodeId; result.PackageEventType = eventType; result.UserName = userName; result.ProcessingDateTime = DateTime.UtcNow; } } finally { xml.Close(); ms.Close(); } } } return result; }
public static void GetData(IObjectSpace Space) { Exchange CurrentExchange = Space.FindObject <Exchange>(new BinaryOperator("Name", "Bitfinex")); OrderType OrderTypeSell = Space.FindObject <OrderType>(new BinaryOperator("Name", "Sell")); OrderType OrderTypeBuy = Space.FindObject <OrderType>(new BinaryOperator("Name", "Buy")); float currentAsk = 0; float currentBid = 0; var doneEvent = new AutoResetEvent(false); using (var ws = new WebSocketSharp.WebSocket("wss://api.bitfinex.com/ws/")) { string message = "{\"event\":\"ping\"}"; string getUSDOrderBookRAW = "{\"event\":\"subscribe\",\"channel\":\"book\",\"pair\":\"BTCUSD\",\"prec\":\"R0\"}"; string getusdorderbook = "{\"event\":\"subscribe\",\"channel\":\"book\",\"pair\":\"BTCUSD\",\"prec\":\"P0\",\"freq\":\"F0\",\"count\":1}"; ws.OnMessage += (sender, e) => { try { // Console.WriteLine("drag0n says: " + e.Data); dynamic queryData = JsonConvert.DeserializeObject(e.Data); float price = queryData[1]; float amount = queryData[3]; if (amount > 0) { //new bid order added // currentBid = price; // Console.WriteLine("Bid " + price + " " + amount); Order newSell = Space.CreateObject <Order>(); newSell.OrderType = OrderTypeBuy; newSell.Amount = Convert.ToDecimal(amount); newSell.Price = Convert.ToDecimal(price); CurrentExchange.CurrentOrder.Add(newSell); Space.CommitChanges(); // CreateArbTrade((decimal)0.5, "BitStamp", "quadrigacx.com", Space); ArbitrageTradeHelper.CreateArbTrade((decimal)0.5, "quadrigacx.com", "Bitfinex", Space); } else if (amount < 0) { //new ask order added // Console.WriteLine("Ask " + price + " " + amount); Order newSell = Space.CreateObject <Order>(); newSell.OrderType = OrderTypeSell; newSell.Amount = Convert.ToDecimal(amount * -1); newSell.Price = Convert.ToDecimal(price); CurrentExchange.CurrentOrder.Add(newSell); Space.CommitChanges(); ArbitrageTradeHelper.CreateArbTrade((decimal)0.5, "Bitfinex", "quadrigacx.com", Space); // CreateArbTrade((decimal)0.5, "BitStamp", "quadrigacx.com", Space); // Console.WriteLine("Ask " + price + " " + amount); } } catch (Exception ex) { // Console.WriteLine(ex.Message); } }; ws.Connect(); ws.Send(getusdorderbook); // Console.Read(); doneEvent.WaitOne(); } }
/// <summary> /// Gets the instance. /// </summary> /// <param name="objectSpace">The object space.</param> /// <returns>Package marker singleton for specified object space</returns> public static PackageMarker GetInstance(IObjectSpace objectSpace) { return objectSpace.FindObject<PackageMarker>(null, true); }
public static Int32 GetNextNumber(IObjectSpace os, TrwPartyKppSequenceType seq_type, Guid party_oid) { var cur_num = os.FindObject <TrwPartyKppSequence>( new BinaryOperator("SequenceType", seq_type) & new BinaryOperator("IsCurrent", true), true); if (cur_num == null) { cur_num = os.CreateObject <TrwPartyKppSequence>(); switch (seq_type) { case TrwPartyKppSequenceType.PARTY_TYPE_OTHER_CUSTOMER: cur_num.Number = 1; break; case TrwPartyKppSequenceType.PARTY_TYPE_OTHER_SUPPLIER: cur_num.Number = 2; break; case TrwPartyKppSequenceType.PARTY_TYPE_SINGLE_DEAL: cur_num.Number = 50; break; case TrwPartyKppSequenceType.PARTY_TYPE_INTERNAL: cur_num.Number = 3; break; case TrwPartyKppSequenceType.PARTY_TYPE_MARKET2: cur_num.Number = 2000; break; case TrwPartyKppSequenceType.PARTY_TYPE_MARKET1: cur_num.Number = 100; break; case TrwPartyKppSequenceType.PARTY_TYPE_PAY_INTERMEDIA: cur_num.Number = 1000; break; } cur_num.SequenceType = seq_type; cur_num.IsCurrent = true; cur_num.TrwPartyOid = party_oid; os.CommitChanges(); return(cur_num.Number); } var num = os.FindObject <TrwPartyKppSequence>( new BinaryOperator("TrwPartyOid", party_oid) & new BinaryOperator("SequenceType", seq_type), true); if (num != null) { return(num.Number); } switch (seq_type) { case TrwPartyKppSequenceType.PARTY_TYPE_OTHER_CUSTOMER: case TrwPartyKppSequenceType.PARTY_TYPE_OTHER_SUPPLIER: case TrwPartyKppSequenceType.PARTY_TYPE_SINGLE_DEAL: throw new InvalidOperationException("Can be only single"); case TrwPartyKppSequenceType.PARTY_TYPE_INTERNAL: case TrwPartyKppSequenceType.PARTY_TYPE_MARKET1: case TrwPartyKppSequenceType.PARTY_TYPE_MARKET2: num = os.CreateObject <TrwPartyKppSequence>(); num.SequenceType = seq_type; num.IsCurrent = true; num.Number = cur_num.Number + 1; num.TrwPartyOid = party_oid; cur_num.IsCurrent = null; os.CommitChanges(); return(num.Number); default: throw new ArgumentOutOfRangeException("Unknow"); } }
public IHttpActionResult ApprovalSend_SupplierUseProduct(string Send_No) { SendOrderSeed_Model Model = new SendOrderSeed_Model(); try { XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); sendSeed_info sendDetail = new sendSeed_info(); XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeed)); SendOrderSeed ObjMaster; ObjMaster = ObjectSpace.FindObject <SendOrderSeed>(CriteriaOperator.Parse("SendNo=?", Send_No)); List <SendOrderSeed_Model> list_detail = new List <SendOrderSeed_Model>(); ; //SendOrderSeed sendOrderSeed; //sendOrderSeed = ObjectSpace.FindObject<SendOrderSeed>(CriteriaOperator.Parse("SendNo=?", Send_No)); DataSet ds = SqlHelper.ExecuteDataset(scc, CommandType.Text, "select SendNo from SendOrderSeed where SendNo = '" + Send_No + "'"); if (ds.Tables[0].Rows.Count != 0) { double sum = 0; //sendDetail.Oid = sendOrderSeed.Oid; //sendDetail.Send_No = sendOrderSeed.SendNo; //sendDetail.SendDate = Convert.ToDateTime(sendOrderSeed.SendDate).ToString("dd-MM-yyyy", new CultureInfo("us-US")); //sendDetail.SendOrgOid = sendOrderSeed.SendOrgOid.Oid; //sendDetail.SendOrgName = sendOrderSeed.SendOrgOid.SubOrganizeName; //sendDetail.ReceiveOrgoid = sendOrderSeed.ReceiveOrgOid.Oid; //sendDetail.ReceiveOrgName = sendOrderSeed.ReceiveOrgOid.SubOrganizeName; //sendDetail.FinanceYearOid = sendOrderSeed.FinanceYearOid; //sendDetail.FinanceYear = sendOrderSeed.FinanceYearOid.YearName; SendOrderSeed_Model objsend_Detail = new SendOrderSeed_Model(); foreach (SendOrderSeedDetail row in ObjMaster.SendOrderSeedDetails) { objsend_Detail.LotNumber = row.LotNumber.Oid; objsend_Detail.WeightUnit = row.WeightUnitOid.UnitName; objsend_Detail.AnimalSeedLevelOid = row.AnimalSeedLevelOid; objsend_Detail.BudgetSourceOid = row.BudgetSourceOid; objsend_Detail.BudgetSource = row.BudgetSourceOid.BudgetName; objsend_Detail.Weight = row.Weight.ToString(); objsend_Detail.Used = row.Used.ToString(); objsend_Detail.AnimalSeedOid = row.AnimalSeedOid; objsend_Detail.AnimalSeedLevelOid = row.AnimalSeedLevelOid; objsend_Detail.SeedTypeOid = row.SeedTypeOid.SeedTypeName; objsend_Detail.Amount = row.Amount; sum = sum + row.Weight; list_detail.Add(objsend_Detail); } nutrition.Module.StockSeedInfo ObjStockSeedInfoInfo; var objSupplierProduct = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("Oid =?", objsend_Detail.LotNumber)); var objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? ", ObjMaster.SendOrgOid.Oid, ObjMaster.FinanceYearOid, objsend_Detail.BudgetSourceOid, objsend_Detail.AnimalSeedOid , objsend_Detail.AnimalSeedLevelOid, objsend_Detail.LotNumber)); if (objStockSeedInfo == null) { //var stockSeedInfos = from Item in objStockSeedInfo // orderby Item.StockDate descending // select Item; XafTypesInfo.Instance.RegisterEntity(typeof(StockSeedInfo)); ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); ObjStockSeedInfoInfo.StockDate = DateTime.Now; ObjStockSeedInfoInfo.OrganizationOid = ObjMaster.SendOrgOid; ObjStockSeedInfoInfo.FinanceYearOid = ObjMaster.FinanceYearOid; ObjStockSeedInfoInfo.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; ObjStockSeedInfoInfo.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; ObjStockSeedInfoInfo.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; ObjStockSeedInfoInfo.StockDetail = "ส่งเมล็ดพันธุ์ Lot Number: " + objSupplierProduct.LotNumber; ObjStockSeedInfoInfo.TotalForward = (double)objSupplierProduct.Weight; ObjStockSeedInfoInfo.TotalChange = 0 - Convert.ToDouble(objsend_Detail.Weight); ObjStockSeedInfoInfo.StockType = 0; ObjStockSeedInfoInfo.SeedTypeOid = objSupplierProduct.SeedTypeOid; ObjStockSeedInfoInfo.ReferanceCode = objSupplierProduct.LotNumber; ObjectSpace.CommitChanges(); } ObjMaster.SendStatus = EnumSendOrderSeedStatus.Approve; ObjectSpace.CommitChanges(); return(Ok(true)); } else { return(BadRequest()); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(BadRequest(ex.Message)); } }
/// <summary> /// Метод создает в БД новое обследование /// </summary> private IExamination CreateNewExamination(IObjectSpace os, IPatient patient, Guid id, ExaminationType type = null, bool allowEmptyFile = false) { IExamination examination = os.CreateObject<IExamination>(); examination.ExaminationSoftType = os.FindObject<ExaminationSoftType>(CriteriaOperator.Parse("ExaminationSoftTypeId = ?", id)); examination.Patient = os.GetObject<IPatient>(patient); examination.AllowEmptyOrNotExistsFile = allowEmptyFile; examination.TimeStart = DateTime.Now; // Создается новое обследование поэтому файла еще нет if (examination.ExaminationFile == null) { // заводим в базе файл //examination.ExaminationFile = os.CreateObject<FileSystemStoreObject>(); examination.ExaminationFile = os.CreateObject<ExaminationFile>(); examination.ExaminationFile.OwnerId = (examination as DevExpress.ExpressApp.DC.DCBaseObject).Oid; if (type != null) { examination.ExaminationType = os.GetObjectByKey<ExaminationType>(type.Oid); //FindObject<ExaminationType>(CriteriaOperator.Parse("ExaminationTypeId = ?", type.)); } // Применяем изменения os.CommitChanges(); if (String.IsNullOrEmpty(examination.ObjectCode) == false) { string fileName = examination.ObjectCode; string fileExtension = examination.ExaminationSoftType.ExaminationFileExtension; examination.ExaminationFile.FileName = Converters.GetFileNameWithoutInvalidChars(fileName, fileExtension); } else throw new Exception("Examination invalid params"); } os.CommitChanges(); // здесь создается пустой файл обследования while (os.IsCommitting) { Thread.Sleep(1000); } // ждем пока применятся изменения, не знаю зачем... //// Заполняем созданный файл заключения //// !!! ЗАПОЛНЯТЬ ЗАКЛЮЧЕНИЕ ПРИ СОЗДАНИИ НЕ НАДО !!! //ConclusionViewController conclusionController = Frame.GetController<ConclusionViewController>(); //if (conclusionController != null) //{ // conclusionController.PopulateConclusionFile(examination); //} return examination; }
public static BusinessObject FindBusinessObject(this IObjectSpace os, Type type) { return(os.FindObject <BusinessObject>(new BinaryOperator("FullName", type.FullName))); }
IEmailTemplate EmailTemplateObject(IModelApplicationEmail modelApplication, EmailRule emailRule, IObjectSpace objectSpace) { var modelEmailTemplate =modelApplication.Email.EmailTemplateContexts.First( emailTemplate => emailTemplate.GetValue<string>("Id") == emailRule.TemplateContext); return (IEmailTemplate)objectSpace.FindObject(modelEmailTemplate.EmailTemplate.TypeInfo.Type, CriteriaOperator.Parse(modelEmailTemplate.Criteria)); }
/// <summary> /// Получаем объект организация /// </summary> public static IOrganization GetInstance(IObjectSpace objectSpace) { var organization = objectSpace.FindObject<IOrganization>(null); if (organization == null) { organization = objectSpace.CreateObject<IOrganization>(); organization.OrganizationName = String.Empty; organization.OrganizationId = String.Empty; organization.Logo = null; //Assembly assembly = typeof(MitsarDataStudio.Configuration.IResource).Assembly; //AssemblyName name = assembly.GetName(); //string resource = string.Format("{0}.{1}", name.Name, "Resources.Templates.TitleTemplate.rtf"); //Stream stream = assembly.GetManifestResourceStream(resource); string file = Path.Combine(Configuration.Config.TemplatesPath, "TitleTemplate.rtf"); if (File.Exists(file) == true) { Stream stream = File.OpenRead(file); organization.ConclusionTemplate = objectSpace.CreateObject<FileSystemStoreObject>(); SaveConclusionTemplate(organization.ConclusionTemplate, stream); } } return organization; }
public void Process(XafApplication application,IObjectSpace objectSpace) { var user = objectSpace.FindObject(XpandModuleBase.UserType, CriteriaOperator.Parse("Email = ?", Email)) as IAuthenticationStandardUser; if (user == null) throw new ArgumentException("Cannot find registered users by the provided email address!"); User = user; var randomBytes = new byte[6]; new RNGCryptoServiceProvider().GetBytes(randomBytes); Password = Convert.ToBase64String(randomBytes); user.SetPassword(Password); user.ChangePasswordOnFirstLogon = true; objectSpace.CommitChanges(); }
public static DataTable ImportInvoiceNo(DataTable dtExcelData, IObjectSpace objectSpace) { var dtFormatData = dtExcelData.Copy(); dtFormatData.Columns.Add("导入结果"); dtFormatData.Columns.Add("相关信息"); if (!dtFormatData.Columns.Contains("草单编号")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在草单编号列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("账单编号")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在账单编号列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("账单记录日")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在账单记录日列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } foreach (DataRow drData in dtFormatData.Rows) { try { if (string.IsNullOrWhiteSpace(drData["草单编号"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "草单编号为空"; continue; } if (string.IsNullOrWhiteSpace(drData["账单编号"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "账单编号为空"; continue; } var internalNo = objectSpace.FindObject <InternalInvoice>(CriteriaOperator.Parse($"InternalNo = '{drData["草单编号"]}'")); if (internalNo == null) { drData["导入结果"] = "失败"; drData["相关信息"] = "系统中不存在该草单。"; continue; } if (!string.IsNullOrWhiteSpace(internalNo.InvoiceNo) && internalNo.InvoiceNo != drData["账单编号"].ToString()) { var messageResult = XtraMessageBox.Show($"{drData["草单编号"]}该草单下已存在账单编号,原账单编号:{internalNo.InvoiceNo};新账单编号:{drData["账单编号"]},是否执行覆盖?", "提示", MessageBoxButtons.OKCancel); if (messageResult != DialogResult.OK) { drData["导入结果"] = "失败"; drData["相关信息"] = $"{drData["草单编号"]}该草单下已存在账单编号,原账单编号:{internalNo.InvoiceNo};新账单编号:{drData["账单编号"]},已执行跳过"; continue; } } internalNo.InvoiceNo = drData["账单编号"].ToString(); internalNo.InvoiceLogDate = string.IsNullOrWhiteSpace(drData["账单记录日"]?.ToString()) ? DateTime.Now : Convert.ToDateTime(drData["账单记录日"]); internalNo.NoNeedInvoice = false; internalNo.Save(); objectSpace.CommitChanges(); drData["导入结果"] = "成功"; } catch (Exception e) { drData["导入结果"] = "失败"; drData["相关信息"] = e.ToString(); objectSpace.Rollback(); } } return(dtFormatData); }
public static CompanyInformation GetInstance(IObjectSpace objectSpace) { CompanyInformation result = objectSpace.FindObject<CompanyInformation>(null); if (result == null) { result = new CompanyInformation(((XPObjectSpace)objectSpace).Session); result.CompanyName = "My Company"; result.CompanySlogan = "My Company Slogan"; result.Save(); } return result; }
public static DataTable ImportTransferCaseBase(DataTable dtExcelData, IObjectSpace objectSpace) { var dtFormatData = dtExcelData.Copy(); dtFormatData.Columns.Add("导入结果"); dtFormatData.Columns.Add("相关信息"); if (!dtFormatData.Columns.Contains("我方卷号")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在我方卷号列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("发出日期")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在发出日期列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("申请人指定")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在申请人指定列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("外代理编码")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在外代理编码列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } if (!dtFormatData.Columns.Contains("外代理名称")) { var drData = dtFormatData.NewRow(); drData["导入结果"] = "失败"; drData["相关信息"] = "导入表中不存在外代理名称列"; dtFormatData.Rows.InsertAt(drData, 0); return(dtFormatData); } foreach (DataRow drData in dtFormatData.Rows) { try { if (string.IsNullOrWhiteSpace(drData["我方卷号"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "我方卷号为空"; continue; } if (string.IsNullOrWhiteSpace(drData["发出日期"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "发出日期为空"; continue; } if (string.IsNullOrWhiteSpace(drData["外代理编码"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "外代理编码为空"; continue; } if (string.IsNullOrWhiteSpace(drData["外代理名称"]?.ToString())) { drData["导入结果"] = "失败"; drData["相关信息"] = "外代理名称为空"; continue; } var caseBase = objectSpace.FindObject <CaseBase>(CriteriaOperator.Parse($"s_OurNo = '{drData["我方卷号"]}'")) ?? objectSpace.CreateObject <CaseBase>(); caseBase.s_OurNo = drData["我方卷号"]?.ToString().Trim(); caseBase.b_IsAppDemand = drData["申请人指定"]?.ToString().Trim().ToUpper() == "Y"; caseBase.dt_TransferDate = Convert.ToDateTime(drData["发出日期"]); caseBase.GetCaseInfo(); caseBase.Agency = objectSpace.FindObject <Corporation>(CriteriaOperator.Parse($"Code = '{drData["外代理编码"]}'")); if (caseBase.Agency == null) { caseBase.Agency = objectSpace.CreateObject <Corporation>(); caseBase.Agency.Name = drData["外代理名称"].ToString(); caseBase.Agency.Code = drData["外代理编码"].ToString(); } caseBase.Save(); objectSpace.CommitChanges(); drData["导入结果"] = "成功"; } catch (Exception e) { drData["导入结果"] = "失败"; drData["相关信息"] = e.ToString(); objectSpace.Rollback(); } } return(dtFormatData); }
public HttpResponseMessage UpdateSendOrderSeed() { QualityAnalysis objQualityAnalysis = null; // object objStockAnimalInfo = null; HistoryWork ObjHistory = null; IList <StockSeedInfo> objStockSeedInfo = null; string Username = "******"; try { string RefNo = HttpContext.Current.Request.Form["RefNo"].ToString(); //ข้อมูลเลขที่อ้างอิง string Status = HttpContext.Current.Request.Form["Status"].ToString(); //สถานะ string CancelMsg = HttpContext.Current.Request.Form["CancelMsg"].ToString(); //หมายเหตุ Username = HttpContext.Current.Request.Form["Username"].ToString(); if (RefNo != "" && Status != "") { string[] arr = RefNo.Split('|'); string _refno = arr[0]; //เลขที่อ้างอิง string _org_oid = arr[1]; //oid หน่วยงาน string _type = arr[2]; //ประเภทส่ง(2)-รับ(1) XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SendOrderSeed)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.StockSeedInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.QualityAnalysis)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.HistoryWork)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModifyDetail)); XafTypesInfo.Instance.RegisterEntity(typeof(nutrition.Module.SupplierProductModify)); XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(ReceiveLotNumber)); List <SendOrderSeed> list = new List <SendOrderSeed>(); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); UserInfo objUserInfo = ObjectSpace.FindObject <UserInfo>(CriteriaOperator.Parse("[UserName]=?", Username)); SendOrderSeed ObjMaster = ObjectSpace.FindObject <SendOrderSeed>(CriteriaOperator.Parse("SendNo=?", _refno)); if (_type == "1") //รับ { if (Status == "1") { //Approve foreach (SendOrderSeedDetail row in ObjMaster.SendOrderSeedDetails) { SupplierProductModifyDetail objSupplierProduct = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("Oid=?", row.LotNumber.Oid)); if (objSupplierProduct != null) { objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? and StockType=1 and ReferanceCode=? ", ObjMaster.ReceiveOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid, row.LotNumber.LotNumberFactory)); if (objStockSeedInfo.Count > 0) { var ObjSubStockCardSource = (from Item in objStockSeedInfo orderby Item.StockDate descending select Item).First().TotalWeight; var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); ObjStockSeedInfoInfo.StockDate = DateTime.Today; ObjStockSeedInfoInfo.OrganizationOid = ObjMaster.ReceiveOrgOid; ObjStockSeedInfoInfo.FinanceYearOid = ObjMaster.FinanceYearOid; ObjStockSeedInfoInfo.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; ObjStockSeedInfoInfo.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; ObjStockSeedInfoInfo.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; ObjStockSeedInfoInfo.StockDetail = "รับเมล็ดพันธุ์ Lot Number : " + row.LotNumber.LotNumberFactory + "(Mobile Application)"; ObjStockSeedInfoInfo.TotalForward = ObjSubStockCardSource; ObjStockSeedInfoInfo.TotalChange = row.Weight; ObjStockSeedInfoInfo.StockType = EnumStockType.ReceiveProduct; ObjStockSeedInfoInfo.SeedTypeOid = objSupplierProduct.SeedTypeOid; ObjStockSeedInfoInfo.ReferanceCode = row.LotNumber.LotNumberFactory; ObjStockSeedInfoInfo.Description = "รับเมล็ดพันธุ์จาก : " + ObjMaster.SendOrgOid.SubOrganizeName + "(Mobile Application)"; ObjStockSeedInfoInfo.UseNo = ObjMaster.SendNo; ObjectSpace.CommitChanges(); } else { var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); ObjStockSeedInfoInfo.StockDate = DateTime.Now; ObjStockSeedInfoInfo.OrganizationOid = ObjMaster.ReceiveOrgOid; ObjStockSeedInfoInfo.FinanceYearOid = ObjMaster.FinanceYearOid; ObjStockSeedInfoInfo.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; ObjStockSeedInfoInfo.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; ObjStockSeedInfoInfo.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; ObjStockSeedInfoInfo.StockDetail = "รับเมล็ดพันธุ์ Lot Number : " + row.LotNumber.LotNumberFactory + "(Mobile Application)"; ObjStockSeedInfoInfo.TotalForward = 0; ObjStockSeedInfoInfo.TotalChange = row.Weight; ObjStockSeedInfoInfo.StockType = EnumStockType.ReceiveProduct; ObjStockSeedInfoInfo.SeedTypeOid = objSupplierProduct.SeedTypeOid; ObjStockSeedInfoInfo.ReferanceCode = row.LotNumber.LotNumberFactory; ObjStockSeedInfoInfo.Description = "รับเมล็ดพันธุ์จาก : " + ObjMaster.SendOrgOid.SubOrganizeName + "(Mobile Application)"; ObjStockSeedInfoInfo.UseNo = ObjMaster.SendNo; ObjectSpace.CommitChanges(); } SupplierProductModifyDetail objAddSupplierProductModifyDetail = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("LotNumberFactory=? and OrganizationOid=?", objSupplierProduct.LotNumberFactory, ObjMaster.ReceiveOrgOid.Oid)); if (objAddSupplierProductModifyDetail != null) { objAddSupplierProductModifyDetail = ObjectSpace.CreateObject <SupplierProductModifyDetail>(); objAddSupplierProductModifyDetail.LotNumber = objSupplierProduct.LotNumber; objAddSupplierProductModifyDetail.LotNumberFactory = objSupplierProduct.LotNumberFactory; objAddSupplierProductModifyDetail.FactoryName = objSupplierProduct.FactoryName; objAddSupplierProductModifyDetail.WeightSend = objSupplierProduct.WeightSend; objAddSupplierProductModifyDetail.SendUnitOid = objSupplierProduct.SendUnitOid; objAddSupplierProductModifyDetail.WeightBefore = objSupplierProduct.WeightBefore; objAddSupplierProductModifyDetail.BeforeUnitOid = objSupplierProduct.BeforeUnitOid; objAddSupplierProductModifyDetail.WeightAfter = objSupplierProduct.WeightAfter; objAddSupplierProductModifyDetail.AfterUnitOid = objSupplierProduct.AfterUnitOid; objAddSupplierProductModifyDetail.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; objAddSupplierProductModifyDetail.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; objAddSupplierProductModifyDetail.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; objAddSupplierProductModifyDetail.Moisture = objSupplierProduct.Moisture; objAddSupplierProductModifyDetail.Purity = objSupplierProduct.Purity; objAddSupplierProductModifyDetail.OtherSeed = objSupplierProduct.OtherSeed; objAddSupplierProductModifyDetail.Weight = objSupplierProduct.Weight; objAddSupplierProductModifyDetail.UnitOid = objSupplierProduct.UnitOid; objAddSupplierProductModifyDetail.Germination = objSupplierProduct.Germination; objAddSupplierProductModifyDetail.SeedTypeOid = objSupplierProduct.SeedTypeOid; objAddSupplierProductModifyDetail.OrganizationOid = ObjMaster.ReceiveOrgOid; } } Organization objOrganizationOid = ObjectSpace.FindObject <Organization>(CriteriaOperator.Parse("Oid=?", objUserInfo.Organization.Oid.ToString())); ReceiveLotNumber objReceiveLotNumber = ObjectSpace.FindObject <ReceiveLotNumber>(CriteriaOperator.Parse("OrganizationOid=? and LotNumber=? and [IsActive]=1", objOrganizationOid.Oid, row.LotNumber.LotNumberFactory)); if (objReceiveLotNumber != null) { objReceiveLotNumber = ObjectSpace.CreateObject <ReceiveLotNumber>(); SupplierProductModifyDetail objModifyDetail = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("LotNumberFactory=?", row.LotNumber.LotNumberFactory)); objReceiveLotNumber.AnimalSeedOid = objModifyDetail.AnimalSeedOid; objReceiveLotNumber.AnimalSeedLevelOid = objModifyDetail.AnimalSeedLevelOid; objReceiveLotNumber.BudgetSourceOid = ObjectSpace.GetObject <BudgetSource>(row.BudgetSourceOid); objReceiveLotNumber.OrganizationOid = objOrganizationOid; objReceiveLotNumber.LotNumber = row.LotNumber.LotNumberFactory; objReceiveLotNumber.SeedTypeOid = objSupplierProduct.SeedTypeOid; objReceiveLotNumber.IsActive = true; } } ObjHistory = ObjectSpace.CreateObject <HistoryWork>(); // ประวัติ ObjHistory.RefOid = ObjMaster.Oid.ToString(); ObjHistory.FormName = "เมล็ดพันธุ์"; ObjHistory.Message = "อนุมัติ (รับเมล็ดพันธุ์จากหน่วยงานในสังกัด (Mobile Application)) เลขที่ส่ง : " + ObjMaster.SendNo; ObjHistory.CreateBy = SecuritySystem.CurrentUserName; ObjHistory.CreateDate = DateTime.Now; ObjectSpace.CommitChanges(); ObjMaster.ReceiveStatus = EnumReceiveOrderSeedStatus.Approve; ObjectSpace.CommitChanges(); } else if (Status == "2") { //Reject if (ObjMaster.SendStatus == EnumSendOrderSeedStatus.Approve) { foreach (SendOrderSeedDetail row in ObjMaster.SendOrderSeedDetails) { SupplierProductModifyDetail objSupplierProduct = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("Oid=?", row.LotNumber.Oid)); if (objSupplierProduct != null) { objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? and StockType=1 and ReferanceCode=? ", ObjMaster.ReceiveOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid, row.LotNumber.LotNumberFactory)); if (objStockSeedInfo.Count > 0) { var ObjStockAnimalInfo_DetailSource = (from Item in objStockSeedInfo orderby Item.StockDate descending select Item).First().TotalWeight; var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); // ObjMaster.ReceiveOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid)) var withBlock = ObjStockSeedInfoInfo; withBlock.StockDate = DateTime.Now; withBlock.OrganizationOid = ObjMaster.ReceiveOrgOid; withBlock.FinanceYearOid = ObjMaster.FinanceYearOid; withBlock.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; withBlock.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; withBlock.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; withBlock.StockDetail = "ไม่อนุมัติการรับเมล็ดพันธุ์จากหน่วยงานในสังกัด (Mobile Application) Lot Number : " + row.LotNumber.LotNumberFactory; withBlock.TotalForward = ObjStockAnimalInfo_DetailSource; withBlock.TotalChange = 0 - row.Weight; withBlock.StockType = EnumStockType.ReceiveProduct; withBlock.SeedTypeOid = objSupplierProduct.SeedTypeOid; withBlock.ReferanceCode = row.LotNumber.LotNumberFactory; ObjectSpace.CommitChanges(); } } } foreach (SendOrderSeedDetail row in ObjMaster.SendOrderSeedDetails) { SupplierProductModifyDetail objSupplierProduct = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("Oid=?", row.LotNumber.Oid)); if (objSupplierProduct != null) { objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? and StockType=0 and ReferanceCode=? ", ObjMaster.SendOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid, row.LotNumber.LotNumberFactory)); if (objStockSeedInfo.Count > 0) { var ObjSubStockCardSource = (from Item in objStockSeedInfo orderby Item.StockDate descending select Item).First().TotalWeight; var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); // ObjMaster.ReceiveOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid)) var withBlock1 = ObjStockSeedInfoInfo; withBlock1.StockDate = DateTime.Now; withBlock1.OrganizationOid = ObjMaster.SendOrgOid; withBlock1.FinanceYearOid = ObjMaster.FinanceYearOid; withBlock1.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; withBlock1.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; withBlock1.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; withBlock1.StockDetail = "รับเมล็ดพันธุ์คืนเนื่องจากไม่ได้รับการอนุมัติ (Mobile Application) สาเหตุ : " + CancelMsg; withBlock1.TotalForward = ObjSubStockCardSource; withBlock1.TotalChange = row.Weight; withBlock1.StockType = EnumStockType.ModifyProduct; withBlock1.SeedTypeOid = objSupplierProduct.SeedTypeOid; withBlock1.ReferanceCode = row.LotNumber.LotNumberFactory; ObjectSpace.CommitChanges(); } } objQualityAnalysis = ObjectSpace.FindObject <QualityAnalysis>(CriteriaOperator.Parse("[LotNumber]=? and [AnalysisType]=0 and [OrganizationOid]=?", row.LotNumber.LotNumberFactory, row.SendOrderSeed.SendOrgOid)); if (objQualityAnalysis != null) { objQualityAnalysis.Weight += row.Weight; } QualityAnalysis objQualityAnalysisType1 = ObjectSpace.FindObject <QualityAnalysis>(CriteriaOperator.Parse("[LotNumber]=? and [AnalysisType]=1 and [OrganizationOid]=?", row.LotNumber.LotNumberFactory, row.SendOrderSeed.ReceiveOrgOid)); if (objQualityAnalysisType1 != null) { objQualityAnalysisType1.Weight -= row.Weight; } } } ObjectSpace.CommitChanges(); ObjHistory = ObjectSpace.CreateObject <HistoryWork>(); // ประวัติ ObjHistory.RefOid = ObjMaster.Oid.ToString(); ObjHistory.FormName = "เมล็ดพันธุ์"; ObjHistory.Message = "ไม่อนุมัติ (รับเมล็ดพันธุ์จากหน่วยงานในสังกัด (Mobile Application)) เลขที่ส่ง : " + ObjMaster.SendNo; ObjHistory.CreateBy = Username; ObjHistory.CreateDate = DateTime.Now; ObjectSpace.CommitChanges(); ObjMaster.SendStatus = EnumSendOrderSeedStatus.Eject; //4 ObjMaster.ReceiveStatus = EnumReceiveOrderSeedStatus.Eject; //4 ObjMaster.CancelMsg = CancelMsg; ObjectSpace.CommitChanges(); } } else if (_type == "2") //ส่ง { if (Status == "1") { //Approve foreach (SendOrderSeedDetail row in ObjMaster.SendOrderSeedDetails) { SupplierProductModifyDetail objSupplierProduct = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("Oid=?", row.LotNumber.Oid)); if (objSupplierProduct != null) { if (ObjMaster.SendOrgOid.IsFactory == true) { objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? and StockType=0 and ReferanceCode=? ", ObjMaster.SendOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid, row.LotNumber.LotNumberFactory)); } else { objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? and StockType=1 and ReferanceCode=? ", ObjMaster.SendOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid, row.LotNumber.LotNumberFactory)); } if (objStockSeedInfo.Count > 0) { var ObjSubStockCardSource = (from Item in objStockSeedInfo orderby Item.StockDate descending select Item).First().TotalWeight; var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); // ObjMaster.ReceiveOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid)) var withBlock = ObjStockSeedInfoInfo; withBlock.StockDate = DateTime.Now; withBlock.OrganizationOid = ObjMaster.SendOrgOid; withBlock.FinanceYearOid = ObjMaster.FinanceYearOid; withBlock.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; withBlock.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; withBlock.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; withBlock.StockDetail = "ส่งเมล็ดพันธุ์ Lot Number (Mobile Application): " + row.LotNumber.LotNumberFactory; withBlock.TotalForward = ObjSubStockCardSource; withBlock.TotalChange = 0 - row.Weight; if (ObjMaster.SendOrgOid.IsFactory == true) { withBlock.StockType = EnumStockType.ModifyProduct; } else { withBlock.StockType = EnumStockType.ReceiveProduct; } withBlock.SeedTypeOid = objSupplierProduct.SeedTypeOid; withBlock.ReferanceCode = row.LotNumber.LotNumberFactory; withBlock.Description = "ส่งเมล็ดพันธุ์ให้ : " + "" + ObjMaster.ReceiveOrgOid.SubOrganizeName + "" + "(Mobile Application)"; withBlock.UseNo = ObjMaster.SendNo; ObjectSpace.CommitChanges(); } } else { var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); var withBlock = ObjStockSeedInfoInfo; withBlock.StockDate = DateTime.Now; withBlock.OrganizationOid = ObjMaster.SendOrgOid; withBlock.FinanceYearOid = ObjMaster.FinanceYearOid; withBlock.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; withBlock.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; withBlock.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; withBlock.StockDetail = "ส่งเมล็ดพันธุ์ Lot Number : " + "" + row.LotNumber.LotNumberFactory + "" + "(Mobile Application)"; withBlock.TotalForward = 0; withBlock.TotalChange = 0 - row.Weight; if (ObjMaster.SendOrgOid.IsFactory == true) { withBlock.StockType = EnumStockType.ModifyProduct; } else { withBlock.StockType = EnumStockType.ReceiveProduct; } withBlock.SeedTypeOid = objSupplierProduct.SeedTypeOid; withBlock.ReferanceCode = row.LotNumber.LotNumberFactory; withBlock.Description = "ส่งเมล็ดพันธุ์ให้ : " + "" + ObjMaster.ReceiveOrgOid.SubOrganizeName + "" + "(Mobile Application)"; withBlock.UseNo = ObjMaster.SendNo; ObjectSpace.CommitChanges(); } objQualityAnalysis = ObjectSpace.FindObject <QualityAnalysis>(CriteriaOperator.Parse("[LotNumber]=? and [AnalysisType]=0 and [OrganizationOid]=?", row.LotNumber.LotNumberFactory, row.SendOrderSeed.SendOrgOid)); if (objQualityAnalysis != null) { objQualityAnalysis.Weight -= row.Weight; } QualityAnalysis objQualityAnalysisType1 = ObjectSpace.FindObject <QualityAnalysis>(CriteriaOperator.Parse("[LotNumber]=? and [AnalysisType]=1 and [OrganizationOid]=?", row.LotNumber.LotNumberFactory, row.SendOrderSeed.ReceiveOrgOid)); if (objQualityAnalysisType1 != null) { objQualityAnalysisType1.Weight += row.Weight; } else { var ObjQualityAnalysisInfo = ObjectSpace.CreateObject <QualityAnalysis>(); SupplierProductModifyDetail objSupplierProductModifyDetail = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("LotNumberFactory=?", row.LotNumber.LotNumberFactory)); var withBlock = ObjQualityAnalysisInfo; withBlock.AnimalSeedOid = objSupplierProductModifyDetail.AnimalSeedOid; withBlock.AnimalSeedLevelOid = objSupplierProductModifyDetail.AnimalSeedLevelOid; withBlock.SeedTypeOid = objSupplierProductModifyDetail.SeedTypeOid; withBlock.LotNumber = objSupplierProductModifyDetail.LotNumberFactory; withBlock.Weight = row.Weight; withBlock.Moisture = objSupplierProductModifyDetail.Moisture; withBlock.Germination = objSupplierProductModifyDetail.Germination; withBlock.AnalysisType = 1.ToString(); withBlock.OrganizationOid = ObjMaster.ReceiveOrgOid; ObjectSpace.CommitChanges(); } } ObjHistory = ObjectSpace.CreateObject <HistoryWork>(); // ประวัติ ObjHistory.RefOid = ObjMaster.Oid.ToString(); ObjHistory.FormName = "เมล็ดพันธุ์"; ObjHistory.Message = "อนุมัติ (ส่งเมล็ดพันธุ์ให้หน่วยงานในสังกัด (Mobile Application)) เลขที่ส่ง : " + ObjMaster.SendNo; ObjHistory.CreateBy = Username; ObjHistory.CreateDate = DateTime.Now; ObjectSpace.CommitChanges(); ObjMaster.SendStatus = EnumSendOrderSeedStatus.Approve; //2 ObjMaster.ReceiveStatus = EnumReceiveOrderSeedStatus.InProgess; //1 ObjMaster.Remark = CancelMsg; ObjectSpace.CommitChanges(); } else if (Status == "2") //ไม่อนุมัติ ฝั่งส่ง { //Reject ObjMaster.CancelMsg = CancelMsg; foreach (SendOrderSeedDetail row in ObjMaster.SendOrderSeedDetails) { SupplierProductModifyDetail objSupplierProduct = ObjectSpace.FindObject <SupplierProductModifyDetail>(CriteriaOperator.Parse("Oid=?", row.LotNumber.Oid)); if (objSupplierProduct != null) { objStockSeedInfo = ObjectSpace.GetObjects <StockSeedInfo>(CriteriaOperator.Parse("OrganizationOid= ? and FinanceYearOid=? and BudgetSourceOid=? and AnimalSeedOid=? and AnimalSeedLevelOid=? and StockType=0 and ReferanceCode=? ", ObjMaster.SendOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid, row.LotNumber.LotNumberFactory)); if (objStockSeedInfo.Count > 0) { var ObjStockAnimalInfo_DetailSource = (from Item in objStockSeedInfo orderby Item.StockDate descending select Item).First().TotalWeight; var ObjStockSeedInfoInfo = ObjectSpace.CreateObject <StockSeedInfo>(); // ObjMaster.ReceiveOrgOid.Oid, ObjMaster.FinanceYearOid.Oid, objSupplierProduct.BudgetSourceOid, objSupplierProduct.AnimalSeedOid.Oid, objSupplierProduct.AnimalSeedLevelOid.Oid)) var withBlock = ObjStockSeedInfoInfo; withBlock.StockDate = DateTime.Now; withBlock.OrganizationOid = ObjMaster.SendOrgOid; withBlock.FinanceYearOid = ObjMaster.FinanceYearOid; withBlock.BudgetSourceOid = objSupplierProduct.BudgetSourceOid; withBlock.AnimalSeedOid = objSupplierProduct.AnimalSeedOid; withBlock.AnimalSeedLevelOid = objSupplierProduct.AnimalSeedLevelOid; withBlock.StockDetail = "ไม่อนุมัติการส่งเมล็ดพันธุ์ (Mobile Application) สาเหตุ :" + CancelMsg; withBlock.TotalForward = ObjStockAnimalInfo_DetailSource; withBlock.TotalChange = row.Weight; withBlock.StockType = EnumStockType.ModifyProduct; withBlock.SeedTypeOid = objSupplierProduct.SeedTypeOid; withBlock.ReferanceCode = row.LotNumber.LotNumberFactory; ObjectSpace.CommitChanges(); } } } ObjHistory = ObjectSpace.CreateObject <HistoryWork>(); // ประวัติ ObjHistory.RefOid = ObjMaster.Oid.ToString(); ObjHistory.FormName = "เมล็ดพันธุ์"; ObjHistory.Message = "ไม่อนุมัติ (ส่งเมล็ดพันธุ์ให้หน่วยงานในสังกัด (Mobile Application)) เลขที่ส่ง : " + ObjMaster.SendNo; ObjHistory.CreateBy = Username; ObjHistory.CreateDate = DateTime.Now; ObjectSpace.CommitChanges(); ObjMaster.SendStatus = EnumSendOrderSeedStatus.Eject; //4 ObjectSpace.CommitChanges(); } } UpdateResult ret = new UpdateResult(); ret.status = "true"; ret.message = "บันทึกข้อมูลเสร็จเรียบร้อยแล้ว"; return(Request.CreateResponse(HttpStatusCode.OK, ret)); } else { UserError err = new UserError(); err.status = "false"; err.code = "-1"; err.message = "ไม่พบข้อมูล"; return(Request.CreateResponse(HttpStatusCode.NotFound, err)); } } catch (Exception ex) { UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } finally { SqlConnection.ClearAllPools(); } }
public static IList <WeeklyInventory> GetThisWeeksInventroy(DateTime StartDate, DateTime EndDate, IObjectSpace space) { IList <WeeklyInventory> weeklyInventory = new List <WeeklyInventory>(); // IObjectSpace space = AppHelper.Application.CreateObjectSpace(); //get the list of locations IList <Location> locationList = space.GetObjects <Location>(); bool groupCheck = false; foreach (Location loc in locationList) { //filter the measures by LDC and date if (loc.Name.Contains("IPS")) { Console.Write('s'); } WeeklyInventory WeekI = new WeeklyInventory(); WeekI.Location = loc; XPCollection <Move> moves = loc.MoveFrom; // BetweenOperator betOp = new BetweenOperator("MoveDate", DateTime.Now.AddDays(-97), DateTime.Now.AddDays(-90)); BetweenOperator betOp = new BetweenOperator("MoveDate", StartDate, EndDate); NotOperator notOP = new NotOperator(new NullOperator("Appliance")); GroupOperator grpOP = new GroupOperator(); grpOP.OperatorType = GroupOperatorType.And; grpOP.Operands.Add(betOp); grpOP.Operands.Add(notOP); moves.Filter = grpOP; // moves.Filter = betOp; List <InventoryItem> invList = new List <InventoryItem>(); //loc.MoveFrom[0].Appliance foreach (Move mov in moves) { FastFileLineItem item = space.FindObject <FastFileLineItem>(new BinaryOperator("Move.Oid", mov.Oid.ToString())); foreach (InventoryItem inv in invList) { if (item.HAPApplication != null && mov.Appliance.SageName == inv.Appliance.SageName && mov.LocationTo.Name == inv.LocationTo.Name && item.HAPApplication.BasicScheduledDate.ToString("dd/MM/yyyy") == inv.InstallDate.ToString("dd/MM/yyyy")) { inv.Quantity += mov.Quantity; groupCheck = true; } else if (item.ENBLIApplication != null && mov.Appliance.SageName == inv.Appliance.SageName && mov.LocationTo.Name == inv.LocationTo.Name && item.ENBLIApplication.TAPSAssessmentDate.ToString("dd/MM/yyyy") == inv.InstallDate.ToString("dd/MM/yyyy")) { inv.Quantity += mov.Quantity; groupCheck = true; } else if (item.ENBLIApplication != null && mov.Appliance.SageName == inv.Appliance.SageName && mov.LocationTo.Name == inv.LocationTo.Name && item.ENBLIApplication.ENBLIADate.ToString("dd/MM/yyyy") == inv.InstallDate.ToString("dd/MM/yyyy")) { inv.Quantity += mov.Quantity; groupCheck = true; } } if (!groupCheck) { if (item.HAPApplication != null) { InventoryItem invItem = new InventoryItem(); invItem.Appliance = mov.Appliance; invItem.LocationTo = mov.LocationTo; invItem.Quantity = mov.Quantity; invItem.InstallDate = item.HAPApplication.BasicScheduledDate; invList.Add(invItem); } else if (item.ENBLIApplication != null) { InventoryItem invItem = new InventoryItem(); invItem.Appliance = mov.Appliance; invItem.LocationTo = mov.LocationTo; invItem.Quantity = mov.Quantity; if (item.ENBLIApplication.TAPSAssessmentDate != null && item.ENBLIApplication.TAPSAssessmentDate != DateTime.MinValue) { invItem.InstallDate = item.ENBLIApplication.TAPSAssessmentDate; } else { invItem.InstallDate = item.ENBLIApplication.ENBLIADate; } invList.Add(invItem); } } groupCheck = false; } if (invList.Count > 0) { WeekI.InventoryItemList = invList; weeklyInventory.Add(WeekI); } } return(weeklyInventory); }
public static void OnSaving(IFirstLaunchParameters parameter, IObjectSpace objectSpace) { if (parameter.DummyObjectsCreated == false) { var name = parameter.OrganizationName; if (string.IsNullOrEmpty(name) == false) { var organization = OrganizationLogic.GetInstance(objectSpace); organization.OrganizationName = parameter.OrganizationName; } var user = parameter.EmployeeName; if (string.IsNullOrEmpty(user) == false) { var exist = objectSpace.FindObject<Employee>(new BinaryOperator("UserName", user)); if (exist == null) { var employee = objectSpace.CreateObject<Employee>(); employee.UserName = parameter.EmployeeName; employee.SetPassword(string.Empty); employee.IsActive = true; var role = objectSpace.FindObject<ExtendedSecurityRole>(new BinaryOperator("BuiltInIdentifier", "Doctor")); employee.Roles.Add(role); } } } }
public static DBNumerator GetNumerator(IObjectSpace os, XPClassInfo classInfo, IDepartment department) { if (os == null) { throw new InvalidOperationException("Missing session"); } if (classInfo == null) { throw new InvalidOperationException("Missing class type"); } DBNumerator reg = null; while ((classInfo != null ? classInfo.IsPersistent : false) && reg == null) { reg = os.FindObject<DBNumerator>(CriteriaOperator.Parse(/*"TargetType = ? and Department = ?"*/"TargetType = ?", classInfo.ClassType, department)); if (reg == null) { reg = os.FindObject<DBNumerator>(CriteriaOperator.Parse(/*"TargetType = ? and Department is null"*/"TargetType = ?", classInfo.ClassType)); } classInfo = classInfo.BaseClass; } if (reg == null) { reg = os.FindObject<DBNumerator>(CriteriaOperator.Parse(/*"TargetType = ? and Department is null"*/"TargetType = ?", typeof(ISerialDataObject))); } return reg; }
public static XAFBootstrapConfiguration Configuration(IObjectSpace ObjectSpace) { var configuration = ObjectSpace.FindObject<XAFBootstrapConfiguration>(null, true); if (configuration == null) { configuration = ObjectSpace.CreateObject<XAFBootstrapConfiguration>(); configuration.Theme = "Paper"; } return configuration; }
public static void AfterConstruction(IDepartment department, IObjectSpace objectSpace) { department.allowTodel = true; var organization = objectSpace.FindObject<IOrganization>(null); if (organization != null) { department.Organization = organization; } }
static public void ImportAvansData(IObjectSpace os, String file_name) { fmCAVTInvoiceType inv_type = os.GetObjects <fmCAVTInvoiceType>().FirstOrDefault(x => x.Prefix == "ю"); FileHelperEngine <fmCAVTInvoiceAvansImport> engine = new FileHelperEngine <fmCAVTInvoiceAvansImport>(); engine.Options.IgnoreFirstLines = 1; fmCAVTInvoiceAvansImport[] avans = engine.ReadFile(file_name); foreach (fmCAVTInvoiceAvansImport avan in avans) { avan.VO_CODE = avan.VO_CODE.Trim(); avan.SF_NUMBER = avan.SF_NUMBER.Trim(); avan.PP_NUMBER = avan.PP_NUMBER.Trim(); avan.TEXT = avan.TEXT.Trim(); fmCAVTInvoiceBase invoice = os.FindObject <fmCAVTInvoiceBase>( XPQuery <fmCAVTInvoiceBase> .TransformExpression( ((ObjectSpace)os).Session, rec => rec.Customer.Code == avan.VO_CODE && rec.Number == avan.SF_NUMBER && rec.Date >= avan.SF_DATE.Date && rec.Date <= avan.SF_DATE.Date.AddDays(1) )); fmCAVTInvoiceLine line = null; if (invoice == null) { invoice = os.CreateObject <fmCAVTInvoiceBase>(); invoice.Number = avan.SF_NUMBER; invoice.Date = avan.SF_DATE.Date; invoice.Customer = os.GetObjects <crmCParty>(new BinaryOperator("Code", avan.VO_CODE)).FirstOrDefault(); invoice.Supplier = os.GetObjects <crmCParty>(new BinaryOperator("Code", "2518")).FirstOrDefault(); } if (invoice != null) { invoice.InvoiceType = inv_type; if (invoice.Lines.Count > 0) { line = invoice.Lines[0]; } if (line == null) { line = os.CreateObject <fmCAVTInvoiceLine>(); invoice.Lines.Add(line); } line.NomenclatureText = avan.TEXT; line.AVTSumm = avan.SUMM_VAT; line.Cost = avan.SUMM_ALL - avan.SUMM_VAT; // fmCAVTInvoiceVersion.Payment pay = new fmCAVTInvoiceVersion.Payment() { fmCAVTInvoiceVersion.fmCAVTInvoicePayment pay = null; if (invoice.PaymentsList.Count > 0) { pay = invoice.PaymentsList[0]; } if (pay == null) { pay = os.CreateObject <fmCAVTInvoiceVersion.fmCAVTInvoicePayment>(); invoice.PaymentsList.Add(pay); } pay.Number = avan.PP_NUMBER; pay.Date = avan.PP_DATE; } } }
private void processItems(IEnumerable <Item> findResults, IObjectSpace objectSpace, Identificadores config, List <ParPersonaDireccionDireccion> paresDirecciones) { foreach (var item in findResults) { if (!(item is Contact)) { continue; } var contact = item as Contact; var persona = objectSpace.FindObject <Persona>(new BinaryOperator(EWSModule.PropertyCodigoEWS, item.Id.UniqueId)) ?? objectSpace.CreateObject <Persona>( ); var modifEWS = ( DateTime? )persona.GetMemberValue(EWSModule.PropertyModifFechaEWS); if (modifEWS.HasValue && modifEWS.Value == item.LastModifiedTime) { continue; } persona.SetMemberValue(EWSModule.PropertyCodigoEWS, item.Id.UniqueId); persona.SetMemberValue(EWSModule.PropertyModifFechaEWS, item.LastModifiedTime); persona.Grupo = CoreAppLogonParameters.Instance.GrupoActual(persona.Session); if (persona.Oid == -1) //Persona nueva { persona.Tipo = TipoPersona.Juridica; //si tiene asignado un apellido, o un telefono celular, inducimos que probablemente es una persona fisica if (!string.IsNullOrEmpty(contact.CompleteName.Surname) || contact.PhoneNumbers.Contains(PhoneNumberKey.MobilePhone)) { persona.Tipo = TipoPersona.Fisica; } } persona.Nombre = contact.CompleteName.FullName; persona.Tratamiento = contact.CompleteName.Title; persona.NombrePila = contact.CompleteName.GivenName; persona.SegundoNombre = contact.CompleteName.MiddleName; persona.ApellidosPaterno = contact.CompleteName.Surname; persona.NombreFantasia = contact.CompleteName.NickName; DateTime?birthday; if (contact.TryGetProperty(ContactSchema.Birthday, out birthday)) { persona.NacimientoFecha = birthday; } persona.Notas = contact.Notes; DateTime?anniversary; if (contact.TryGetProperty(ContactSchema.WeddingAnniversary, out anniversary)) { persona.AniversarioFecha = contact.WeddingAnniversary; } SyncIdentificacion(persona, config.IdentificacionTipoWebTrabajo, objectSpace, contact.BusinessHomePage, "BusinessHomePage"); SyncPropiedad(persona, config.PropiedadPuesto, objectSpace, contact.JobTitle, "JobTitle"); SyncPropiedad(persona, config.PropiedadDepartamento, objectSpace, contact.Department, "Department"); SyncPropiedad(persona, config.PropiedadAsistente, objectSpace, contact.AssistantName, "AssistantName"); SyncPropiedad(persona, config.PropiedadProfesion, objectSpace, contact.Profession, "Profession"); SyncPropiedad(persona, config.PropiedadEsposo, objectSpace, contact.SpouseName, "SpouseName"); SyncIM(ImAddressKey.ImAddress1, config.IdentificacionTipoIM, contact, persona, objectSpace); SyncIM(ImAddressKey.ImAddress2, config.IdentificacionTipoIM, contact, persona, objectSpace); SyncIM(ImAddressKey.ImAddress3, config.IdentificacionTipoIM, contact, persona, objectSpace); SyncDireccion(PhysicalAddressKey.Home, config.DireccionTipoParticular, contact, persona, objectSpace, paresDirecciones); SyncDireccion(PhysicalAddressKey.Business, config.DireccionTipoLaboral, contact, persona, objectSpace, paresDirecciones); SyncDireccion(PhysicalAddressKey.Other, config.DireccionTipoOtra, contact, persona, objectSpace, paresDirecciones); SyncTelefono(PhoneNumberKey.AssistantPhone, config.IdentificacionTipoTelAsistente, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.BusinessFax, config.IdentificacionTipoTelFaxTrabajo, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.BusinessPhone, config.IdentificacionTipoTelTrabajo, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.BusinessPhone2, config.IdentificacionTipoTelTrabajo, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.Callback, config.IdentificacionTipoTelDevLlamada, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.CarPhone, config.IdentificacionTipoTelAuto, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.CompanyMainPhone, config.IdentificacionTipoTelPpalCia, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.HomeFax, config.IdentificacionTipoFaxParticular, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.HomePhone, config.IdentificacionTipoTelParticular, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.HomePhone2, config.IdentificacionTipoTelParticular, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.Isdn, config.IdentificacionTipoTelISDN, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.MobilePhone, config.IdentificacionTipoTelMovil, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.OtherFax, config.IdentificacionTipoFaxOtro, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.OtherTelephone, config.IdentificacionTipoTelOtro, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.Pager, config.IdentificacionTipoTelPager, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.PrimaryPhone, config.IdentificacionTipoTelPrimario, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.RadioPhone, config.IdentificacionTipoTelRadio, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.Telex, config.IdentificacionTipoTelex, contact, persona, objectSpace, config); SyncTelefono(PhoneNumberKey.TtyTddPhone, config.IdentificacionTipoTTY, contact, persona, objectSpace, config); SyncEmail(EmailAddressKey.EmailAddress1, config.IdentificacionTipoEmail, contact, persona, objectSpace); SyncEmail(EmailAddressKey.EmailAddress2, config.IdentificacionTipoEmail, contact, persona, objectSpace); SyncEmail(EmailAddressKey.EmailAddress3, config.IdentificacionTipoEmail, contact, persona, objectSpace); //TODO: buscar otro mecanismo para cargar la foto (manual, con un boton on-demand?) //es demasiado pesado para que sea automatico /*var hasPicture = false; * contact.TryGetProperty( ContactSchema.HasPicture, out hasPicture ); * * if ( hasPicture ) * { * //contact.Load( new PropertySet( ItemSchema.Attachments ) ); * var pictureAttachment = contact.GetContactPictureAttachment( ); * if ( pictureAttachment != null ) * { * var ms = new MemoryStream( ); * pictureAttachment.Load( ms ); * p.Imagen = Image.FromStream( ms ); * } * }*/ persona.Save( ); Thread.Sleep(1); } }
private void showNavigationItemController_CustomShowNavigationItem(object sender, CustomShowNavigationItemEventArgs e) { ViewShortcut viewShortcut = e.ActionArguments.SelectedChoiceActionItem.Data as ViewShortcut; string listViewId = Application.FindListViewId(typeof(NavigationObject)); if (viewShortcut != null) { if (viewShortcut.ViewId == listViewId) { IObjectSpace objectSpace = Application.CreateObjectSpace(typeof(NavigationObject)); DetailView detailView = Application.CreateDetailView(objectSpace, objectSpace.FindObject(typeof(NavigationObject), null)); detailView.ViewEditMode = DevExpress.ExpressApp.Editors.ViewEditMode.Edit; e.ActionArguments.ShowViewParameters.CreatedView = detailView; e.ActionArguments.ShowViewParameters.TargetWindow = TargetWindow.Current; e.Handled = true; } } }
private object AuthenticateActiveDirectory(IObjectSpace objectSpace) { string userName = WindowsIdentity.GetCurrent().Name; IAuthenticationActiveDirectoryUser user = (IAuthenticationActiveDirectoryUser)objectSpace.FindObject(UserType, new BinaryOperator("UserName", userName)); if (user == null) { if (createUserAutomatically) { CustomCreateUserEventArgs args = new CustomCreateUserEventArgs(objectSpace, userName); if (!args.Handled) { user = (IAuthenticationActiveDirectoryUser)objectSpace.CreateObject(UserType); user.UserName = userName; //if (base.Security is ICanInitializeNewUser) { // ((ICanInitializeNewUser)base.Security).InitializeNewUser(objectSpace, user); //} if (Security is SecurityStrategyBase) { System.Reflection.MethodInfo mi = typeof(SecurityStrategyBase).GetMethod("InitializeNewUserCore", System.Reflection.BindingFlags.Instance | System.Reflection.BindingFlags.NonPublic); mi.Invoke(Security, new object[] { objectSpace, user }); } } objectSpace.CommitChanges(); } } if (user == null) { throw new AuthenticationException(userName); } return(user); }
static public void ImportInvoices(IObjectSpace os, fmCAVTInvoiceRegister register, String file_name) { // OpenFileDialog dialog = new OpenFileDialog(); // if (dialog.ShowDialog() == DialogResult.OK) { FixedFileEngine engine = new FixedFileEngine(typeof(fmCAVTInvoiceImport)); fmCAVTInvoiceImport[] imp_res = (fmCAVTInvoiceImport[])engine.ReadFile(file_name); IList <fmCAVTInvoiceType> inv_types = os.GetObjects <fmCAVTInvoiceType>(); IList <fmCAVTInvoiceTransferType> inv_transfer_types = os.GetObjects <fmCAVTInvoiceTransferType>(); IList <fmCAVTInvoiceOperationType> inv_oper_types = os.GetObjects <fmCAVTInvoiceOperationType>(); Int32 count = 0; UInt32 seq_num = 0; foreach (fmCAVTInvoiceImport imp_rec in imp_res) { imp_rec.SF_VO_CODE = imp_rec.SF_VO_CODE.Trim(); imp_rec.SF_INT_NUMBER = imp_rec.SF_INT_NUMBER.Trim(); imp_rec.SF_NUMBER = imp_rec.SF_NUMBER.Trim(); Decimal summ_cost = Decimal.Parse(imp_rec.SUMM_COST.Trim().Replace('.', ',')); Decimal summ_nds = Decimal.Parse(imp_rec.SUMM_NDS.Trim().Replace('.', ',')); Decimal summ_sub_cost = Decimal.Parse(imp_rec.SUMM_SUB_COST.Trim().Replace('.', ',')); Decimal summ_sub_nds = Decimal.Parse(imp_rec.SUMM_SUB_NDS.Trim().Replace('.', ',')); DateTime sf_date = default(DateTime); DateTime.TryParseExact(imp_rec.SF_DATE.Trim(), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out sf_date); fmCAVTInvoiceBase invoice = os.FindObject <fmCAVTInvoiceBase>( XPQuery <fmCAVTInvoiceBase> .TransformExpression( ((ObjectSpace)os).Session, rec => rec.Supplier.Code == imp_rec.SF_VO_CODE && rec.RegNumber == imp_rec.SF_INT_NUMBER && rec.Date >= sf_date && rec.Date < sf_date.AddDays(1) )); //if (invoice == null) { // count++; // System.Console.WriteLine(imp_rec.SF_INT_NUMBER + " " + imp_rec.SF_NUMBER + " " + imp_rec.SF_DATE + " " + summ_cost + " " + summ_nds); //} if (invoice == null) { crmCParty party = os.GetObjects <crmCParty>(new BinaryOperator("Code", imp_rec.SF_VO_CODE)).FirstOrDefault(); invoice = os.CreateObject <fmCAVTInvoiceBase>(); invoice.RegNumber = imp_rec.SF_INT_NUMBER; invoice.Number = imp_rec.SF_NUMBER; invoice.Date = sf_date; invoice.Supplier = party; invoice.Customer = register.Party; invoice.SummAVT = Decimal.Parse(imp_rec.SUMM_NDS.Trim().Replace('.', ',')); invoice.SummCost = Decimal.Parse(imp_rec.SUMM_COST.Trim().Replace('.', ',')); } else { invoice.SummAVT = Decimal.Parse(imp_rec.SUMM_NDS.Trim().Replace('.', ',')); invoice.SummCost = Decimal.Parse(imp_rec.SUMM_COST.Trim().Replace('.', ',')); fmCAVTInvoiceRegisterLine line_check = os.FindObject <fmCAVTInvoiceRegisterLine>( CriteriaOperator.And(new BinaryOperator("InvoiceVersion", invoice.Current)), true); if (line_check != null) { continue; } } fmCAVTInvoiceRegisterLine line = register.InLines.Where(rec => rec.Invoice == invoice).FirstOrDefault(); if (line == null) { line = os.CreateObject <fmCAVTInvoiceRegisterLine>(); register.InLines.Add(line); } line.SequenceNumber = seq_num++; // line_doc.DateTransfer = invoice.Date; line.Invoice = invoice; line.TransferType = inv_transfer_types.Where(rec => rec.Code == "1").FirstOrDefault(); if (String.IsNullOrEmpty(imp_rec.SF_TRANS_DATE.Trim())) { DateTime trans_date = default(DateTime); DateTime.TryParseExact(imp_rec.SF_TRANS_DATE.Trim(), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out trans_date); line.DateTransfer = trans_date; } if (line.DateTransfer < sf_date) { line.DateTransfer = sf_date; } line.OperationType = inv_oper_types.Where(rec => rec.Code == imp_rec.SF_OPER_TYPE.Trim() || rec.Code == '0' + imp_rec.SF_OPER_TYPE.Trim()).FirstOrDefault(); } System.Console.WriteLine("All " + count); }
/// <summary> /// Finds the application object by replication key. /// </summary> /// <param name="classType">Type of the class.</param> /// <param name="reference">The reference.</param> /// <param name="objectSpace">The object space.</param> /// <returns>Application object</returns> private static object findApplicationObjectByReplicationKey(Type classType, IObjectReference reference, IObjectSpace objectSpace) { object result = null; var modelClass = XafDeltaModule.XafApp.FindModelClass(classType); if (modelClass != null && reference.ReplicationKey != null) { var replicationKeyMember = ExtensionsHelper.GetReplicationKeyMember(modelClass.TypeInfo); var replicationKeyIsCaseInsensitive = modelClass.ReplicationKeyIsCaseInsensitive(); var replicationKeyIsSpaceInsensitive = modelClass.ReplicationKeyIsSpaceInsensitive(); if (replicationKeyMember != null) { CriteriaOperator opLeft = new OperandProperty(replicationKeyMember.Name); CriteriaOperator opRight = new OperandValue(reference.ReplicationKey); if (replicationKeyIsCaseInsensitive) { opLeft = new FunctionOperator(FunctionOperatorType.Upper, opLeft); opRight = new FunctionOperator(FunctionOperatorType.Upper, opRight); } if (replicationKeyIsSpaceInsensitive) { opLeft = new FunctionOperator(FunctionOperatorType.Replace, opLeft, new OperandValue(" "), new OperandValue(String.Empty)); opRight = new FunctionOperator(FunctionOperatorType.Replace, opRight, new OperandValue(" "), new OperandValue(String.Empty)); } var keyCriteria = new BinaryOperator(opLeft, opRight, BinaryOperatorType.Equal); if(replicationKeyMember.MemberInfo.IsAliased) { var list = objectSpace.CreateCollection(modelClass.TypeInfo.Type); result = (from c in list.Cast<object>() let objKeyValue = replicationKeyMember.MemberInfo.GetValue(c) where keysMatches(objKeyValue, reference.ReplicationKey, replicationKeyIsCaseInsensitive, replicationKeyIsSpaceInsensitive) select c).FirstOrDefault(); } else result = objectSpace.FindObject(classType, keyCriteria, true); } } return result; }
public override IEnumerable <FileManagerFolder> GetFolders(FileManagerFolder parentFolder) { //1.根据ListView的Model找到设置 var list = new List <FileManagerFolder>(); //不是根目录? var parent = FindFolder(parentFolder.RelativeName); bool isRoot = string.IsNullOrEmpty(parentFolder.RelativeName); if (isRoot) { #region 根级别 //是否是根级别 foreach (var m in CategoryMembers) { if (m.CategoryPropertyAttribute.CategoryType == CategoryType.Group) { //分组的,可以展开查看 var root = new FileManagerFolder(this, parentFolder, "按[" + m.Member.Caption + "]分组"); AddFolderCache(true, m, root, parentFolder); list.Add(root); } else { //树形的,把根结点加入 var rootNode = _objectSpace.FindObject(m.Member.Type, CriteriaOperator.Parse("Parent is Null")) as IName; if (rootNode != null) { var root = new FileManagerFolder(this, parentFolder, rootNode.Name); AddFolderCache(true, m, root, parentFolder); //Folders.Add(root.RelativeName, new Folder() {Member = m, FullName = root.RelativeName, Parent = parentFolder.RelativeName}); list.Add(root); } } } #endregion } else { #region 非根 if (parent.HasChildren) { IList nodes; bool haveChildren = true; if (parent.Member.CategoryPropertyAttribute.CategoryType == CategoryType.Group) { nodes = _objectSpace.GetObjects(parent.Member.Member.Type, null); haveChildren = false; } else { nodes = _objectSpace.GetObjects(parent.Member.Member.Type, CriteriaOperator.Parse("Parent.Name=?", parentFolder.Name)); } foreach (IName n in nodes) { var root = new FileManagerFolder(this, parentFolder, n.Name); AddFolderCache(haveChildren, parent.Member, root, parentFolder); list.Add(root); } } #endregion } return(list); }
public override object Authenticate(object logonParameters, IObjectSpace objectSpace) { SecurityDemoAuthenticationLogonParameters securityDemoAuthenticationLogonParameters = logonParameters as SecurityDemoAuthenticationLogonParameters; if(string.IsNullOrEmpty(securityDemoAuthenticationLogonParameters.UserName)) { throw new ArgumentNullException("User"); } return objectSpace.FindObject<SecurityDemoUser>(new DevExpress.Data.Filtering.BinaryOperator("UserName", securityDemoAuthenticationLogonParameters.UserName)); //return objectSpace.GetObject(securityDemoAuthenticationLogonParameters.User); }
static public void ImportInvoices(IObjectSpace os, String file_name) { // OpenFileDialog dialog = new OpenFileDialog(); // if (dialog.ShowDialog() == DialogResult.OK) { FixedFileEngine engine = new FixedFileEngine(typeof(InvoiceImport)); InvoiceImport[] imp_res = (InvoiceImport[])engine.ReadFile(file_name); IList <fmCAVTInvoiceType> inv_types = os.GetObjects <fmCAVTInvoiceType>(); IList <fmCAVTInvoiceTransferType> inv_transfer_types = os.GetObjects <fmCAVTInvoiceTransferType>(); IList <fmCAVTInvoiceOperationType> inv_oper_types = os.GetObjects <fmCAVTInvoiceOperationType>(); Int32 count = 0; fmCAVTInvoiceType sf_sfz_type = os.GetObjects <fmCAVTInvoiceType>().First(x => x.Prefix == "Z"); foreach (InvoiceImport imp_rec in imp_res) { imp_rec.SF_VO_CODE = imp_rec.SF_VO_CODE.Trim(); imp_rec.SF_INT_NUMBER = imp_rec.SF_INT_NUMBER.Trim(); imp_rec.SF_NUMBER = imp_rec.SF_NUMBER.Trim(); Decimal summ_cost = Decimal.Parse(imp_rec.SUMM_COST.Trim().Replace('.', ',')); Decimal summ_nds = Decimal.Parse(imp_rec.SUMM_NDS.Trim().Replace('.', ',')); Decimal summ_sub_cost = Decimal.Parse(imp_rec.SUMM_SUB_COST.Trim().Replace('.', ',')); Decimal summ_sub_nds = Decimal.Parse(imp_rec.SUMM_SUB_NDS.Trim().Replace('.', ',')); DateTime sf_date = default(DateTime); DateTime.TryParseExact(imp_rec.SF_DATE.Trim(), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out sf_date); crmCParty party = os.GetObjects <crmCParty>(new BinaryOperator("Code", imp_rec.SF_VO_CODE)).FirstOrDefault(); if (party == null) { System.Console.WriteLine("SF " + imp_rec.SF_NUMBER + " party not found (" + imp_rec.SF_VO_CODE + ")"); continue; } Основание.ТипИсточника ts; if (imp_rec.SF_IO_TYPE == "I") { ts = Основание.ТипИсточника.ВХОДЯЩИЙ; } else if (imp_rec.SF_IO_TYPE == "O") { ts = Основание.ТипИсточника.ИСХОДЯЩИЙ; } else { throw new ArgumentOutOfRangeException("SF " + imp_rec.SF_NUMBER + " неопределен тип входящий/исходящий"); } Основание.ТипОснования tsf; switch (imp_rec.SF_TYPE) { case "СЧФ": tsf = Основание.ТипОснования.СЧФ; break; case "УПД": tsf = Основание.ТипОснования.УПД; break; case "СФА": tsf = Основание.ТипОснования.СФА; break; case "СФЗ": tsf = Основание.ТипОснования.СФЗ; break; case "СЧГ": tsf = Основание.ТипОснования.СЧГ; break; case "БЖД": tsf = Основание.ТипОснования.БЖД; break; case "СФВ": tsf = Основание.ТипОснования.СФВ; break; case "БСО": tsf = Основание.ТипОснования.БСО; break; case "ЧЕК": tsf = Основание.ТипОснования.ЧЕК; break; default: System.Console.WriteLine("SF: " + imp_rec.SF_NUMBER + " странный тип (" + imp_rec.SF_TYPE + ")"); continue; } String inn = ""; String kpp = ""; ЛицоТип party_type = ЛицоТип.НЕЗАДАН; if (party.Person != null) { if (party.Person.Address.Country.CodeAlfa2 == "RU") { // Type party.ComponentTypeComponentObject.GetType(); if (party.ComponentType == typeof(crmCLegalPerson) || party.ComponentType == typeof(crmCLegalPersonUnit)) { party_type = ЛицоТип.ЮР_ЛИЦО; inn = party.INN; if (inn.Length == 9) { inn = "0" + inn; } kpp = party.KPP; if (inn.Length == 8) { kpp = "0" + kpp; } if (inn.Length != 10) { System.Console.WriteLine("Party: " + party.Code + " fail INN (" + inn + ")"); continue; } if (kpp.Length != 9) { System.Console.WriteLine("Party: " + party.Code + " fail KPP (" + kpp + ")"); continue; } } else { if (party.ComponentType == typeof(crmCBusinessman)) { party_type = ЛицоТип.ПРЕДПРИНИМАТЕЛЬ; inn = party.INN; if (inn.Length == 11) { inn = "0" + inn; } if (inn.Length != 12) { System.Console.WriteLine("Party: " + party.Code + " fail INN (" + inn + ")"); continue; } } else if (party.ComponentType == typeof(crmCPhysicalParty)) { party_type = ЛицоТип.ФИЗ_ЛИЦО; } } } else { party_type = ЛицоТип.ИНО_ПАРТНЕР; System.Console.WriteLine("Party: " + party.Code + " инопартнер "); } } if (party.Code == "2706") { party_type = ЛицоТип.ОЗНИЦА; } // String sale_inn = "5012039795"; if (ts == Основание.ТипИсточника.ВХОДЯЩИЙ) { sale_inn = inn; } // !!!!!!!!!!!!!!!!!!!!!!!!!! // Выбраковываем СФ if (String.IsNullOrEmpty(sale_inn) || String.IsNullOrEmpty(imp_rec.SF_REGNUM.Trim()) && tsf != Основание.ТипОснования.СФЗ) { continue; } // !!!!!!!!!!!!!!!!!!!!!!!!!! Основание sf = os.FindObject <Основание>( XPQuery <Основание> .TransformExpression( ((ObjectSpace)os).Session, rec => rec.ИннПродавца == sale_inn && rec.Номер == imp_rec.SF_NUMBER && rec.Дата >= sf_date && rec.Дата < sf_date.AddDays(1) )); if (sf == null) { sf = os.CreateObject <Основание>(); sf.Источник = ts; sf.ИНН = inn; sf.Номер = imp_rec.SF_NUMBER; sf.Дата = sf_date; sf.КПП = kpp; } sf.Корректировка = Основание.ТипПодчиненности.ОСНОВНОЙ; sf.Источник = ts; sf.Тип = tsf; sf.ЛицоТип = party_type; ОснованиеДокумент sfdoc = null; String sfdoc_sver = imp_rec.SF_PRAV_NUMBER.Trim(); if (String.IsNullOrEmpty(sfdoc_sver)) { sfdoc_sver = "0"; } UInt16 sfdoc_ver = 0; UInt16.TryParse(sfdoc_sver, out sfdoc_ver); DateTime sfdoc_date = default(DateTime); DateTime.TryParseExact(imp_rec.SF_DATE.Trim(), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out sfdoc_date); foreach (ОснованиеДокумент doc in sf.Документы) { if (doc.НомерИсправления == sfdoc_ver) { sfdoc = doc; break; } } if (sfdoc == null) { sfdoc = os.CreateObject <ОснованиеДокумент>(); sf.Документы.Add(sfdoc); sfdoc.НомерИсправления = sfdoc_ver; if (sf.ДействующийДокумент.НомерИсправления < sfdoc.НомерИсправления) { sf.ДействующийДокумент = sfdoc; } } sfdoc.ДатаИсправления = sfdoc_date; sfdoc.егНомер = imp_rec.SF_REGNUM.Trim(); if (sf.Тип == Основание.ТипОснования.СФЗ && String.IsNullOrEmpty(sfdoc.егНомер)) { Int32 IntNumber = fmCAVTInvoiceNumberGenerator.GenerateNumber(((ObjectSpace)os).Session, sf.ДействующийДокумент.CID, sf_sfz_type, sf.Дата, 0); sfdoc.егНомер = sf_sfz_type.Prefix + sf.Дата.ToString("yyyyMM").Substring(2, 4) + IntNumber.ToString("00000"); } sfdoc.КодПартнера = party.Code; sfdoc.НаименКонтрагента = party.Name; sfdoc.СуммаВсего = summ_cost + summ_nds; sfdoc.СуммаНДС = summ_nds; sfdoc.СуммаВсегоУвел = sfdoc.СуммаВсего + summ_sub_cost; sfdoc.СуммаНДСУвел = sfdoc.СуммаНДС + summ_sub_nds; //fmCAVTInvoiceBase invoice = os.FindObject<fmCAVTInvoiceBase>( // XPQuery<fmCAVTInvoiceBase>.TransformExpression( // ((ObjectSpace)os).Session, // rec => rec.Supplier.Code == imp_rec.SF_VO_CODE && // rec.RegNumber == imp_rec.SF_INT_NUMBER && // rec.Date >= sf_date && // rec.Date < sf_date.AddDays(1) // )); ////if (invoice == null) { //// count++; //// System.Console.WriteLine(imp_rec.SF_INT_NUMBER + " " + imp_rec.SF_NUMBER + " " + imp_rec.SF_DATE + " " + summ_cost + " " + summ_nds); ////} //if (invoice == null) { // crmCParty party = os.GetObjects<crmCParty>(new BinaryOperator("Code", imp_rec.SF_VO_CODE)).FirstOrDefault(); // invoice = os.CreateObject<fmCAVTInvoiceBase>(); // invoice.RegNumber = imp_rec.SF_INT_NUMBER; // invoice.Number = imp_rec.SF_NUMBER; // invoice.Date = sf_date; // invoice.Supplier = party; // invoice.Customer = register.Party; // invoice.SummAVT = Decimal.Parse(imp_rec.SUMM_NDS.Trim().Replace('.', ',')); // invoice.SummCost = Decimal.Parse(imp_rec.SUMM_COST.Trim().Replace('.', ',')); //} //else { // invoice.SummAVT = Decimal.Parse(imp_rec.SUMM_NDS.Trim().Replace('.', ',')); // invoice.SummCost = Decimal.Parse(imp_rec.SUMM_COST.Trim().Replace('.', ',')); // fmCAVTInvoiceRegisterLine line_check = os.FindObject<fmCAVTInvoiceRegisterLine>( // CriteriaOperator.And(new BinaryOperator("InvoiceVersion", invoice.Current)), true); // if (line_check != null) continue; //} //fmCAVTInvoiceRegisterLine line = register.InLines.Where(rec => rec.Invoice == invoice).FirstOrDefault(); //if (line == null) { // line = os.CreateObject<fmCAVTInvoiceRegisterLine>(); // register.InLines.Add(line); //} //line.SequenceNumber = seq_num++; //// line_doc.DateTransfer = invoice.Date; //line.Invoice = invoice; //line.TransferType = inv_transfer_types.Where(rec => rec.Code == "1").FirstOrDefault(); //if (String.IsNullOrEmpty(imp_rec.SF_TRANS_DATE.Trim())) { // DateTime trans_date = default(DateTime); // DateTime.TryParseExact(imp_rec.SF_TRANS_DATE.Trim(), "yyyyMMdd", null, System.Globalization.DateTimeStyles.None, out trans_date); // line.DateTransfer = trans_date; //} //if (line.DateTransfer < sf_date) // line.DateTransfer = sf_date; //line.OperationType = inv_oper_types.Where(rec => rec.Code == imp_rec.SF_OPER_TYPE.Trim() || // rec.Code == '0' + imp_rec.SF_OPER_TYPE.Trim()).FirstOrDefault(); } System.Console.WriteLine("All " + count); }
public IActionResult GenGRN([FromBody] JObject values) { try { GenHelper.WriteLog("[Log]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); GenHelper.WriteLog("[Json]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + Environment.NewLine + values.ToString() + Environment.NewLine + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); // //JsonParser.ParseJObjectXPO<PurchaseDelivery>(values, employee, objectSpace); string temp = ""; JToken token; PurchaseDelivery employee = objectSpace.CreateObject <PurchaseDelivery>(); token = values["CardCode"]; temp = token["BoKey"].ToString(); employee.CardCode = objectSpace.FindObject <vwBusinessPartners>(CriteriaOperator.Parse("BoKey=?", temp)); employee.NumAtCard = values["NumAtCard"].ToString(); //JsonPopulateObjectHelper.PopulateObjectWODetail(values.ToString(), employee.Session, employee); string detalclassname = "PurchaseDeliveryDetail"; int intkeyvalue = -1; JArray jarray = (JArray)values[detalclassname]; int cnt = 0; foreach (JObject Jdtl in jarray.Children()) { if (Jdtl.ContainsKey("Oid")) { if (int.TryParse(Jdtl["Oid"].ToString(), out intkeyvalue)) { PurchaseDeliveryDetail dtl = objectSpace.GetObjectByKey <PurchaseDeliveryDetail>(intkeyvalue); cnt++; dtl.VisOrder = cnt; dtl.VerNo = 1; employee.PurchaseDeliveryDetail.Add(dtl); } else { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Details Key value is invalid][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception("Details Key value is invalid"); } } else { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Details Key Column Not found][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception("Details Key Column Not found"); } } if (employee.DocTypeSeries == null) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[Document series is not found][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception("Document series is not found"); } employee.DocStatus.AddDocStatus(DocStatus.Accepted, "WebApi Generated"); employee.DocStatus.CurrDocStatus = DocStatus.Accepted; employee.VerNo = 1; employee.AssignDocNumber(); objectSpace.CommitChanges(); return(Ok(employee.DocNum)); } catch (Exception ex) { GenHelper.WriteLog("[Error]", "[" + securityProvider.GetUserName() + "]" + controllername + "-GenGRN:[" + ex.Message + "][" + DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss tt") + "]"); throw new Exception(ex.Message); } }
private void popupWindowShowActionPresupuestoReal_Execute(object sender, DevExpress.ExpressApp.Actions.PopupWindowShowActionExecuteEventArgs e) { PresupuestoFiltro obj = e.PopupWindowViewCurrentObject as PresupuestoFiltro; if (obj != null) { IObjectSpace objectSpace = Application.CreateObjectSpace(); List <MovimientoB> lista; GroupOperator fil = new GroupOperator(); Presupuesto prsu = objectSpace.FindObject <Presupuesto>(null); if (prsu != null) { decimal suma; foreach (ConceptoP cp in prsu.Partidas) { if (cp.Concepto != null) { fil.Operands.Clear(); fil.Operands.Add(CriteriaOperator.And(new BinaryOperator("FechaAplicacion", obj.FchIncl, BinaryOperatorType.GreaterOrEqual), new BinaryOperator("FechaAplicacion", obj.FchFnl, BinaryOperatorType.LessOrEqual))); fil.Operands.Add(new BinaryOperator("Concepto", cp.Concepto)); IList col = objectSpace.CreateCollection(typeof(MovimientoB), fil); lista = col.Cast <MovimientoB>().ToList(); if (lista != null && lista.Count > 0) { suma = lista.Sum(item => item.Monto); cp.MntRl = suma; } else { cp.MntRl = 0; } } } IList lis = objectSpace.CreateCollection(typeof(ConceptoB)); foreach (ConceptoB cpt in lis) { prsu.Partidas.Filter = new BinaryOperator("Concepto", cpt); if (prsu.Partidas.Count == 0) { fil.Operands.Clear(); fil.Operands.Add(CriteriaOperator.And(new BinaryOperator("FechaAplicacion", obj.FchIncl, BinaryOperatorType.GreaterOrEqual), new BinaryOperator("FechaAplicacion", obj.FchFnl, BinaryOperatorType.LessOrEqual))); fil.Operands.Add(new BinaryOperator("Concepto", cpt)); IList col = objectSpace.CreateCollection(typeof(MovimientoB), fil); lista = col.Cast <MovimientoB>().ToList(); if (lista != null && lista.Count > 0) { suma = lista.Sum(item => item.Monto); ConceptoP cp = objectSpace.CreateObject <ConceptoP>(); cp.Concepto = cpt; cp.MntRl = suma; prsu.Partidas.Add(cp); } } } objectSpace.CommitChanges(); View.Refresh(true); } } }