//确认修改信息 public Task <string> ReviseInfo(ReviseInfo reviseinfo) { using (OracleConnection con = new OracleConnection(ConString.conString)) { using (OracleCommand cmd = con.CreateCommand()) { try { con.Open(); cmd.BindByName = true; //var commandText = "insert into PERSON (ID,PEOPLE_TROUERSCOLOR,CAR_NUMBER,CAMERA,PEOPLE_JACKETTYPE,IMG_ID) values(23,'hong', 'ss', 'ss' ,'ss','ss132' )"; cmd.CommandText = "UPDATE USERS SET USER_NAME = '" + reviseinfo.NewUserName + "' , PASSWORD = '******' WHERE USER_ID = '" + reviseinfo.UserID + "'"; cmd.ExecuteNonQuery(); if (reviseinfo.NewIntroduction.Length > 0) { cmd.CommandText = "UPDATE COMMON_USER SET INTRODUCTION = '" + reviseinfo.NewIntroduction + "' WHERE USER_ID = '" + reviseinfo.UserID + "'"; cmd.ExecuteNonQuery(); } con.Close(); } catch (Exception ex) { string e = ex.Message; int i = 0; return(Task.FromResult(e)); } return(Task.FromResult("Succed")); } } }
/** * Revise Items * * @param revisionIds Map of Revsion IDs * @param itemRevs Array of ItemRevisons * * @return Map of Old ItemRevsion(key) to new ItemRevision(value) * * @throws ServiceException If any partial errors are returned */ public void reviseItems(Hashtable revisionIds, ItemRevision[] itemRevs) //throws ServiceException { // Get the service stub DataManagementService dmService = DataManagementService.getService(Session.getConnection()); ReviseInfo[] reviseInfo = new ReviseInfo[itemRevs.Length]; for (int i = 0; i < itemRevs.Length; i++) { RevisionIds rev = (RevisionIds)revisionIds[i]; reviseInfo[i] = new ReviseInfo(); reviseInfo[i].BaseItemRevision = itemRevs[i]; reviseInfo[i].ClientId = itemRevs[i].Uid + "--" + i; reviseInfo[i].Description = "describe testRevise"; reviseInfo[i].Name = "testRevise"; reviseInfo[i].NewRevId = rev.NewRevId; } // ***************************** // Execute the service operation // ***************************** ReviseResponse2 revised = dmService.Revise2(reviseInfo); // before control is returned the ChangedHandler will be called with // newly created Item and ItemRevisions // The AppXPartialErrorListener is logging the partial errors returned // In this simple example if any partial errors occur we will throw a // ServiceException if (revised.ServiceData.sizeOfPartialErrors() > 0) { throw new ServiceException("DataManagementService.revise returned a partial error."); } }
public async Task <IActionResult> Revise(ReviseInfo reviseinfo) { reviseinfo.UserID = User.FindFirst(ClaimTypes.NameIdentifier).Value; string nowAvatar = User.FindFirstValue("Avatar"); await HttpContext.SignOutAsync(); var claimIdentity = new ClaimsIdentity("Cookie"); claimIdentity.AddClaim(new Claim(ClaimTypes.NameIdentifier, reviseinfo.UserID)); claimIdentity.AddClaim(new Claim(ClaimTypes.Name, reviseinfo.NewUserName)); claimIdentity.AddClaim(new Claim("Avatar", nowAvatar)); claimIdentity.AddClaim(new Claim(ClaimTypes.Role, "Commom")); var claimsPrincipal = new ClaimsPrincipal(claimIdentity); await HttpContext.SignInAsync(claimsPrincipal); string Result = await PersonInfoservice.ReviseInfo(reviseinfo); ViewBag.Result = Result; return(Redirect("/PersonInfo/Index/" + reviseinfo.UserID)); }
public void reviseItem(ModelObject obj) //throws ServiceException { DataManagementService dmService = DataManagementService.getService(Session.getConnection()); ReviseInfo rev = new ReviseInfo(); rev.BaseItemRevision = new ItemRevision(null, obj.Uid); rev.ClientId = "Maxtt_Test" + "--" + "01"; rev.Description = "describe testRevise"; rev.Name = "testRevise"; rev.NewRevId = "01"; //额外的表单属性 PropertyNameValueInfo info = new PropertyNameValueInfo(); info.PropertyName = "object_desc"; info.PropertyValues = new string[] { "newid1" }; rev.NewItemRevisionMasterProperties.PropertyValueInfo = new PropertyNameValueInfo[] { info }; //rev.NewItemRevisionMasterProperties.Form = new Teamcenter.Soa.Client.Model.Strong.Form(null, obj.Uid); // ***************************** // Execute the service operation // ***************************** ReviseResponse2 revised = dmService.Revise2(new ReviseInfo[] { rev }); // before control is returned the ChangedHandler will be called with // newly created Item and ItemRevisions // The AppXPartialErrorListener is logging the partial errors returned // In this simple example if any partial errors occur we will throw a // ServiceException if (revised.ServiceData.sizeOfPartialErrors() > 0) { throw new ServiceException("DataManagementService.revise returned a partial error."); } }
public void reviseItem(ModelObject obj, String Name, String longDetail, String productionType, String item_revision_id) //throws ServiceException { String newVersionNumber = (int.Parse(item_revision_id) + 1).ToString().PadLeft(2, '0'); DataManagementService dmService = DataManagementService.getService(Session2.getConnection()); ReviseInfo rev = new ReviseInfo(); rev.BaseItemRevision = new ItemRevision(null, obj.Uid); rev.ClientId = Name + "/" + newVersionNumber; rev.Description = ""; rev.Name = Name; rev.NewRevId = newVersionNumber; //额外的表单属性 PropertyNameValueInfo info = new PropertyNameValueInfo(); info.PropertyName = cfg.get("exAttr_productionType"); info.PropertyValues = new string[] { productionType }; PropertyNameValueInfo info2 = new PropertyNameValueInfo(); info2.PropertyName = cfg.get("exAttr_detail"); info2.PropertyValues = new string[] { longDetail }; rev.NewItemRevisionMasterProperties.PropertyValueInfo = new PropertyNameValueInfo[] { info, info2 }; // ***************************** ReviseResponse2 revised = dmService.Revise2(new ReviseInfo[] { rev }); if (revised.ServiceData.sizeOfPartialErrors() > 0) { throw new ServiceException("DataManagementService.revise returned a partial error." + revised.ServiceData.GetPartialError(0).Messages[0]); } }
public long AddItemRevise(ReviseInfo info) { return(AddItemRevise(info.reviseField, info.reviseValue, info.reviseMode, info.computeMode, info.duration)); }