protected override void Dispose(bool disposing) { base.Dispose(disposing); if (disposing) { if (objectSpaceProvider != null) { objectSpaceProvider.Dispose(); objectSpaceProvider = null; } } }
public HttpResponseMessage Count_NumberAccepet() { try { string OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString(); SqlConnection objConn = new SqlConnection(scc); if (objConn.State != ConnectionState.Open) { objConn.Open(); } DataSet ds = SqlHelper.ExecuteDataset(scc, CommandType.StoredProcedure, "SP_CountNumber_Approve", new SqlParameter("@OrganizationOid", OrganizationOid)); if (ds.Tables[0].Rows.Count > 0) { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(Organization)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); Organization Organization = ObjectSpace.FindObject <Organization>(CriteriaOperator.Parse("GCRecord is null and Oid =?", OrganizationOid)); Count_Number number = new Count_Number(); number.OrganizationName = Organization.OrganizeNameTH; number.CountNumber = (int)ds.Tables[0].Rows[0]["Count_Total"]; directProvider.Dispose(); ObjectSpace.Dispose(); return(Request.CreateResponse(HttpStatusCode.OK, number)); } else { UserError err = new UserError(); err.code = "-1"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ 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)); } }
public HttpResponseMessage RodBreedList() { try { string Org = HttpContext.Current.Request.Form["organizationOid"].ToString(); // string type = HttpContext.Current.Request.Form["type"].ToString(); XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(SupplierRodBreedUseProduct)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); List <Rodbreed_model> Detail = new List <Rodbreed_model>(); IList <SupplierRodBreedUseProduct> collection = ObjectSpace.GetObjects <SupplierRodBreedUseProduct>(CriteriaOperator.Parse(" GCRecord is null and Status = 1 and OrganizationOid = ? ", Org)); var query = from Q in collection orderby Q.UseNo select Q; if (collection.Count > 0) { foreach (SupplierRodBreedUseProduct row in query) { Rodbreed_model item = new Rodbreed_model(); item.SupplierRodBreedUseProductOid = row.Oid.ToString(); item.FinanceYearOid = row.FinanceYearOid.Oid.ToString(); item.FinanceYear = row.FinanceYearOid.YearName; item.ActivityNameOid = row.ActivityOid.Oid.ToString(); item.ActivityName = row.ActivityOid.ActivityName; if (row.SubActivityLevelOid != null) { item.SubActivityLevelOid = row.SubActivityLevelOid.Oid.ToString(); item.SubActivityLevelName = row.SubActivityLevelOid.ActivityName; } item.FinanceYearOid = row.FinanceYearOid.Oid.ToString(); item.FinanceYear = row.FinanceYearOid.YearName; item.UseNo = row.UseNo; item.UseDate = row.UseDate.ToString("dd/MM/yy"); item.OrganizationOid = row.OrganizationOid.Oid.ToString(); item.OrganizationName = row.OrganizationOid.SubOrganizeName; if (row.EmployeeOid != null) { item.EmployeeOid = row.EmployeeOid.Oid.ToString(); item.EmployeeName = row.EmployeeOid.FullName; } if (row.RegisCusServiceOid != null) { item.RegisCusServiceOid = row.RegisCusServiceOid.Oid.ToString(); item.FullName = row.RegisCusServiceOid.DisPlayName; item.FullAddress = row.RegisCusServiceOid.FullAddress; } if (row.OrgeServiceOid != null) { item.OrgeServiceOid = row.OrgeServiceOid.Oid.ToString(); item.FullName = row.OrgeServiceOid.OrgeServiceName; item.FullAddress = row.OrgeServiceOid.FullAddress; } item.ServiceCount = row.ServiceCount; item.TotalWeight = row.SupplierRodBreedUseProductDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม"; Detail.Add(item); } directProvider.Dispose(); ObjectSpace.Dispose(); //lists.Receive = ReceiveItems; return(Request.CreateResponse(HttpStatusCode.OK, Detail)); } else { UserError err2 = new UserError(); err2.status = "false"; err2.code = "-9"; err2.message = "ไม่มีข้อมูลรายการ การใช้ท่อนพันธุ์"; return(Request.CreateResponse(HttpStatusCode.BadRequest, err2)); } } catch (Exception ex) { UserError err = new UserError(); err.status = "false"; err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.ToString(); return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
/// <summary> /// ฟังชั่นเช็ค user password ให้ถูกต้องตามรหัส xaf ที่สมัครไว้ /// </summary> /// <param name="Username"></param> /// <param name="Password"></param> /// <returns></returns> public WebApi.Jwt.Models.user.User_info CheckLogin_XAF(string Username, string Password) // value1 = Username, value2 = Password จาก class อื่น { user.User_info objUser_info = new user.User_info(); try { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(UserInfo)); XafTypesInfo.Instance.RegisterEntity(typeof(RoleInfo)); WebApi.Jwt.Models.user.member_info_Shot user2 = new WebApi.Jwt.Models.user.member_info_Shot(); //XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc); using (XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc)) { using (IObjectSpace ObjectSpace = directProvider.CreateObjectSpace()) { UserInfo User; nutrition.Module.Organization DLD; User = ObjectSpace.FindObject <UserInfo>(new BinaryOperator("UserName", Username)); // UserInfo = ObjectSpace.FindObject<RoleInfo>(new BinaryOperator("Name", Username)); PasswordCryptographer.EnableRfc2898 = true; PasswordCryptographer.SupportLegacySha512 = false; if (User.ComparePassword(Password) == true) { objUser_info.User_Name = User.UserName; objUser_info.DisplayName = User.DisplayName; objUser_info.OrganizationOid = User.Organization.Oid; objUser_info.OrganizationNameTH = User.Organization.OrganizeNameTH; objUser_info.SubOrganizeName = User.Organization.SubOrganizeName; objUser_info.Tel = User.Organization.Tel; objUser_info.Email = User.Organization.Email; objUser_info.Address = User.Organization.Address; objUser_info.Moo = User.Organization.Moo; objUser_info.Soi = User.Organization.Soi; objUser_info.Road = User.Organization.Road; if (objUser_info.ProvinceNameTH == "") { objUser_info.ProvinceNameTH = "ไม่มีข้อมูลศูนย์"; } else if (objUser_info.ProvinceNameTH != "") { objUser_info.ProvinceNameTH = User.Organization.ProvinceOid.ProvinceNameTH; } if (objUser_info.DistrictNameTH == "") { objUser_info.DistrictNameTH = "ไม่มีข้อมูลศูนย์"; } else if (objUser_info.DistrictNameTH != "") { objUser_info.DistrictNameTH = User.Organization.DistrictOid.DistrictNameTH; } if (objUser_info.SubDistrictNameTH == "") { objUser_info.SubDistrictNameTH = "ไม่มีข้อมูลศูนย์"; } else if (objUser_info.SubDistrictNameTH != "") { objUser_info.SubDistrictNameTH = User.Organization.SubDistrictOid.SubDistrictNameTH; } string TempSubDistrict, TempDistrict; if (User.Organization.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempSubDistrict = "แขวง"; } else { TempSubDistrict = "ตำบล"; }; if (User.Organization.ProvinceOid.ProvinceNameTH.Contains("กรุงเทพ")) { TempDistrict = "เขต"; } else { TempDistrict = "อำเภอ"; }; objUser_info.FullAddress = User.Organization.Address + " หมู่ที่" + " " + checknull(User.Organization.Moo) + " ถนน" + checknull(User.Organization.Road) + " " + TempSubDistrict + User.Organization.SubDistrictOid.SubDistrictNameTH + " " + TempDistrict + User.Organization.DistrictOid.DistrictNameTH + " " + "จังหวัด" + User.Organization.ProvinceOid.ProvinceNameTH + " " + User.Organization.DistrictOid.PostCode; DLD = ObjectSpace.FindObject <nutrition.Module.Organization>(new BinaryOperator("Oid", User.Organization.MasterOrganization)); if (DLD == null) { objUser_info.DLDName = "ไม่มีเขต"; } else if (DLD != null) { objUser_info.DLDName = DLD.OrganizeNameTH; } objUser_info.DLDZone = User.Organization.ProvinceOid.DLDZone.Oid.ToString(); objUser_info.Latitude = User.Organization.Latitude; objUser_info.Longitude = User.Organization.Longitude; TokenController token = new TokenController(); objUser_info.Description = "ระบบ Login"; objUser_info.Token_key = token.Get(Username, Password); objUser_info.Status = 1; objUser_info.Message = "เข้าสู่ระบบสำเร็จ"; string AcName = ""; foreach (RoleInfo row2 in User.UserRoles) { switch (row2.Name) { case "Approver": if (AcName == "") { AcName = "Approve"; } else { AcName = AcName + "," + "Approve"; } break; case "Operator": if (AcName == "") { AcName = "Edit"; } else if (AcName.Contains("Edit") != true) { AcName = AcName + "," + "Edit"; } break; case "Administrator": if (AcName == "") { AcName = "EditAdmin"; } else if (AcName.Contains("EditAdmin") != true) { AcName = AcName + "," + "EditAdmin"; } //else //{ // AcName = AcName + "," + "Edit"; //} break; case "EditAdmin": if (AcName == "") { AcName = "EditAdmin"; } else if (AcName.Contains("EditAdmin") != true) { AcName = AcName + "," + "EditAdmin"; } break; default: if (AcName == "") { AcName = "ReadOnly"; } else { if (AcName.Contains("ReadOnly") == false) { AcName = AcName + "," + "ReadOnly"; } } break; } } objUser_info.ActionName = AcName; //List<WebApi.Jwt.Models.user.Roles_info> objListRoles_info = new List<WebApi.Jwt.Models.user.Roles_info>(); //if (AcName.Contains("Edit") == true || AcName.Contains("Administrator") == true ) //{ // objUser_info.ActionName = "Edit"+ "Administrator"; //} //else //{ // objUser_info.ActionName = AcName; //} } else if (User.ComparePassword(Password) == false) { objUser_info.User_Name = User.UserName; objUser_info.DisplayName = User.DisplayName; objUser_info.OrganizationNameTH = User.Organization.OrganizeNameTH; objUser_info.Tel = User.Organization.Tel; objUser_info.Status = 0; objUser_info.Message = "เข้าสู่ระบบไม่สำเร็จ"; } } directProvider.Dispose(); } //IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); } catch (Exception ex) { objUser_info.Status = 6; objUser_info.Message = ex.Message; } return(objUser_info); }
protected void Page_Unload(object sender, EventArgs e) { objectSpace.Dispose(); security.Dispose(); objectSpaceProvider.Dispose(); }
public void TearDown() { directProvider.Dispose(); objectSpace.Dispose(); // generator.Dispose(); }
public HttpResponseMessage ManageSubAnimalSupplierList() { List <AnimalProductDetail> animalDatail = new List <AnimalProductDetail>(); AnimalProductDetail animal = new AnimalProductDetail(); try { // string QuotaName = HttpContext.Current.Request.Form["QuotaName"].ToString(); string OrganizationOid = HttpContext.Current.Request.Form["OrganizationOid"].ToString(); //string AnimalSupplieOid = HttpContext.Current.Request.Form["AnimalSupplieOid"].ToString(); //string AnimalSupplieTypeOid = HttpContext.Current.Request.Form["AnimalSupplieTypeOid"].ToString(); string QuotaTypeOid = HttpContext.Current.Request.Form["QuotaTypeOid"].ToString(); List <QuotaType_Model> listquo = new List <QuotaType_Model>(); QuotaType_Model quota = new QuotaType_Model(); XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(QuotaType)); XafTypesInfo.Instance.RegisterEntity(typeof(ManageAnimalSupplier)); XafTypesInfo.Instance.RegisterEntity(typeof(ManageSubAnimalSupplier)); XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); List <ManageAnimalSupplier_Model2> list = new List <ManageAnimalSupplier_Model2>(); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); QuotaType quotaType; // var ManageSubAnimalSupplierOid = null; quotaType = ObjectSpace.FindObject <QuotaType>(CriteriaOperator.Parse("GCRecord is null and IsActive = 1 and Oid = '" + QuotaTypeOid + "' ", null)); ManageAnimalSupplier ObjManageAnimalSupplier = ObjectSpace.FindObject <ManageAnimalSupplier>(CriteriaOperator.Parse("[OrganizationOid]=? and Status=1", OrganizationOid)); if (ObjManageAnimalSupplier != null) { switch (quotaType.QuotaName) { case "โควตาสำนัก": animal.QuotaName = "โควตาสำนัก"; //ผิด animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString(); animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName; break; case "โควตาศูนย์ฯ": animal.QuotaName = "โควตาศูนย์ฯ"; animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString(); animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName; animal.QuotaQTY = ObjManageAnimalSupplier.CenterQTY; break; case "โควตาปศุสัตว์เขต": animal.QuotaName = "โควตาปศุสัตว์เขต"; animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString(); animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName; animal.QuotaQTY = ObjManageAnimalSupplier.ZoneQTY; break; //case "โควตาปศุสัตว์จังหวัด": // animal.QuotaName = "โควตาปศุสัตว์จังหวัด"; // animal.AnimalSupplieTypeOid = ObjectSpace.FindObject<AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString(); // animal.AnimalSupplieTypeName = ObjectSpace.FindObject<AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName; // animal.QuotaQTY = ObjManageAnimalSupplier.ZoneQTY; // break; case "โควตาอื่นๆ": animal.QuotaName = "โควตาอื่นๆ"; animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString(); animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName; animal.QuotaQTY = ObjManageAnimalSupplier.OtherQTY; break; case "โควตาปศุสัตว์จังหวัด": if (ObjManageAnimalSupplier != null) { animal.AnimalSupplieTypeOid = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).Oid.ToString(); animal.AnimalSupplieTypeName = ObjectSpace.FindObject <AnimalSupplieType>(CriteriaOperator.Parse("[SupplietypeName]='หญ้าแห้ง'", null)).SupplietypeName; animal.manageSubAnimalSupplierOid = ObjManageAnimalSupplier.Oid.ToString(); List <ManageSubAnimalSupplier_Province> Detail2 = new List <ManageSubAnimalSupplier_Province>(); IList <ManageSubAnimalSupplier> objmanageSubAnimalSupplier = ObjectSpace.GetObjects <ManageSubAnimalSupplier>(CriteriaOperator.Parse("[ManageAnimalSupplierOid]= '" + ObjManageAnimalSupplier.Oid + "' ", null)); if (objmanageSubAnimalSupplier.Count > 0) { foreach (ManageSubAnimalSupplier row2 in objmanageSubAnimalSupplier) { ManageSubAnimalSupplier_Province subanimal = new ManageSubAnimalSupplier_Province(); subanimal.ManageAnimalSupplierOid = row2.ManageAnimalSupplierOid.Oid.ToString(); subanimal.ManageSubAnimalSupplierOid = row2.Oid.ToString(); subanimal.ProvinceOid = row2.ProvinceOid.Oid.ToString(); subanimal.ProvinceName = row2.ProvinceOid.ProvinceNameTH; Detail2.Add(subanimal); } animal.QuotaName = quotaType.QuotaName; animal.ObjProvinceName = Detail2; } } break; } directProvider.Dispose(); ObjectSpace.Dispose(); return(Request.CreateResponse(HttpStatusCode.OK, animal)); } else { UserError err2 = new UserError(); err2.code = "3"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err2.message = "ไม่พบข้อมูล"; return(Request.CreateResponse(HttpStatusCode.BadRequest, err2)); } } catch (Exception ex) { //Error case เกิดข้อผิดพลาด UserError err = new UserError(); err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = ex.Message; // Return resual return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } }
public HttpResponseMessage RegisterCusService_ByCitizenID() { string CitizenID = string.Empty; try { if (HttpContext.Current.Request.Form["CitizenID"].ToString() != null) { CitizenID = HttpContext.Current.Request.Form["CitizenID"].ToString(); } RegisterFarmerController best = new RegisterFarmerController(); if (best.CheckCitizenID(CitizenID) == false) { return(Request.CreateResponse(HttpStatusCode.BadRequest, "หมายเลขบัตรประชาชนไม่ถูกต้อง กรุณาตรวจสอบ")); } 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; } item.FullAddress = RegisterCusService_.FullAddress; 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)); } }
public HttpResponseMessage GetSendOrderSeed() { try { string org_oid = HttpContext.Current.Request.Form["Org_Oid"].ToString(); string type = HttpContext.Current.Request.Form["type"].ToString(); //รับ=1/ส่ง=2 if (org_oid != "" && type != "") { XpoTypesInfoHelper.GetXpoTypeInfoSource(); XafTypesInfo.Instance.RegisterEntity(typeof(SendOrderSeed)); List <SendOrderSeedType> SendItems = new List <SendOrderSeedType>(); List <ReceiveOrderSeedType> ReceiveItems = new List <ReceiveOrderSeedType>(); SendOrderSeedModel lists = new SendOrderSeedModel(); lists.org_oid = org_oid; XPObjectSpaceProvider directProvider = new XPObjectSpaceProvider(scc, null); IObjectSpace ObjectSpace = directProvider.CreateObjectSpace(); if (type == "2") { //หน่วยส่ง IList <SendOrderSeed> collection = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus=1 and [SendOrgOid.Oid]='" + org_oid + "'", null)); var query = from Q in collection orderby Q.SendNo select Q; if (collection.Count > 0) { foreach (SendOrderSeed row in query) { SendOrderSeedType item = new SendOrderSeedType(); item.SendNo = row.SendNo; item.SendDate = row.SendDate.ToString("dd/MM/yyyy"); item.SendOrgOid = row.SendOrgOid.Oid.ToString(); item.SendOrgName = row.SendOrgOid.SubOrganizeName; item.SendOrgFullName = row.SendOrgOid.OrganizeNameTH; item.Remark = row.Remark; item.SendStatus = row.SendStatus.ToString(); item.FinanceYear = row.FinanceYearOid.YearName; item.CancelMsg = row.CancelMsg; item.ReceiveOrgOid = row.ReceiveOrgOid.Oid.ToString(); item.ReceiveOrgName = row.ReceiveOrgOid.SubOrganizeName; item.ReceiveOrgFullName = row.ReceiveOrgOid.OrganizeNameTH; item.RefNo = row.SendNo + "|" + row.SendOrgOid.Oid.ToString() + "|2"; item.TotalWeight = row.SendOrderSeedDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม"; SendItems.Add(item); } } //lists.Sender = null; //SendItems; return(Request.CreateResponse(HttpStatusCode.OK, SendItems)); } else if (type == "1") { //รับ IList <SendOrderSeed> collection2 = ObjectSpace.GetObjects <SendOrderSeed>(CriteriaOperator.Parse("GCRecord is null and SendStatus = 2 and ReceiveStatus=1 and ReceiveOrgOid.Oid='" + org_oid + "'", null)); var query = from Q in collection2 orderby Q.SendNo select Q; if (collection2.Count > 0) { foreach (SendOrderSeed row in query) { ReceiveOrderSeedType item = new ReceiveOrderSeedType(); item.SendNo = row.SendNo; item.SendDate = row.SendDate.ToString("dd/MM/yyyy"); item.SendOrgOid = row.SendOrgOid.Oid.ToString(); item.SendOrgName = row.SendOrgOid.SubOrganizeName; item.SendOrgFullName = row.SendOrgOid.OrganizeNameTH; item.Remark = row.Remark; item.ReceiveOrderStatus = row.ReceiveStatus.ToString(); item.FinanceYear = row.FinanceYearOid.YearName; item.CancelMsg = row.CancelMsg; item.ReceiveOrgOid = row.ReceiveOrgOid.Oid.ToString(); item.ReceiveOrgName = row.ReceiveOrgOid.SubOrganizeName; item.ReceiveOrgFullName = row.ReceiveOrgOid.OrganizeNameTH; item.RefNo = row.SendNo + "|" + row.ReceiveOrgOid.Oid.ToString() + "|1"; item.TotalWeight = row.SendOrderSeedDetails.Sum((c => c.Weight)).ToString() + " กิโลกรัม"; ReceiveItems.Add(item); } directProvider.Dispose(); ObjectSpace.Dispose(); //lists.Receive = ReceiveItems; return(Request.CreateResponse(HttpStatusCode.OK, ReceiveItems)); } } //invalid UserError err = new UserError(); err.status = "false"; err.code = "0"; err.message = "กรุณาใส่ข้อมูล Org_Oid และ type ให้เรียบร้อยก่อน"; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } else { UserError err = new UserError(); err.status = "false"; err.code = "0"; err.message = "กรุณาใส่ข้อมูล Org_Oid ให้เรียบร้อยก่อน"; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } } catch (Exception ex) { UserError err = new UserError(); err.status = "false"; err.code = "6"; // error จากสาเหตุอื่นๆ จะมีรายละเอียดจาก system แจ้งกลับ err.message = "ไม่พบข้อมูล"; return(Request.CreateResponse(HttpStatusCode.BadRequest, err)); } finally { SqlConnection.ClearAllPools(); } }