protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { if (CurrentRights.Contains(PageRight)) { foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Title")) continue; var name = values["Title"].ToString(); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Update: var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Resource.Where(o => o.Id == id).Update(o => new Homory.Model.Resource { Title = name, State = state }); HomoryContext.Value.SaveChanges(); LogOp(state); break; } } Notify(panel, "操作成功", "success"); } else { Notify(panel, "无权限编辑", "warn"); } }
protected void gridX_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Name")) continue; var ordinal = Get(values, "Ordinal", 99); var name = Get(values, "Name", string.Empty); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Insert: var range = bool.Parse(values["Range"].ToString()); CourseAdd(HomoryContext.Value, name, state, ordinal, range); LogOp(OperationType.新增); break; case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); CourseUpdate(HomoryContext.Value, id, state, ordinal); LogOp(state); } break; } } grid.Rebind(); Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { try { var values = command.NewValues; var ordinal = Get(values, "Ordinal", 99); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Update: var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Group.Where(o => o.Id == id).Update(o => new Group { Ordinal = ordinal, State = state, }); HomoryContext.Value.SaveChanges(); LogOp(state); break; } } // ReSharper disable EmptyGeneralCatchClause catch // ReSharper restore EmptyGeneralCatchClause { } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { try { var values = command.NewValues; if (NotSet(values, "Credit")) continue; var credit = Get(values, "Credit", 0); switch (command.Type) { case GridBatchEditingCommandType.Update: var range = Get(values, "PrizeRange", ResourcePrizeRange.其他); var level = Get(values, "PrizeLevel", ResourcePrizeLevel.其他); HomoryContext.Value.PrizeCredit.Where(o => o.PrizeRange == range && o.PrizeLevel == level).Update(o => new PrizeCredit { Credit = credit }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.编辑); break; } } // ReSharper disable EmptyGeneralCatchClause catch // ReSharper restore EmptyGeneralCatchClause { } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var value = "ObjectId".Query(); if (value.None()) { Response.Redirect("~/Depot/Home.aspx"); return; } var objId = value.GlobalId(); var obj = DataContext.DepotObject.Single(o => o.Id == objId); foreach (var command in e.Commands) { var values = command.NewValues; var place = values["Place"].ToString(); switch (command.Type) { case GridBatchEditingCommandType.Update: { var id = values["Id"].ToString().GlobalId(); var @fixed = bool.Parse(values["Fixed"].ToString()); var @in = DataContext.DepotInX.SingleOrDefault(o => o.Id == id); @in.Place = place; if (!obj.Single) { @in.DepotIn.Place = @in.Place; } DataContext.SaveChanges(); } break; } } DataContext.SaveChanges(); view.Rebind(); }
protected void RadGridInvoiceItems_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { command.NewValues["InvoiceId"] = InvoiceId; var standardPrice = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["StandardPrice"]))) ? 0 : Convert.ToDecimal(command.NewValues["StandardPrice"]); var studentPrice = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["StudentPrice"]))) ? 0 : Convert.ToDecimal(command.NewValues["StudentPrice"]); var agencyPrice = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["AgencyPrice"]))) ? 0 : Convert.ToDecimal(command.NewValues["AgencyPrice"]); var invoiceCoaItem = (new CInvoiceCoaItem()).Get(Convert.ToInt32(command.NewValues["InvoiceCoaItemId"])); if (invoiceCoaItem != null) { standardPrice = Math.Abs(standardPrice) * invoiceCoaItem.ItemType; studentPrice = Math.Abs(studentPrice) * invoiceCoaItem.ItemType; agencyPrice = Math.Abs(agencyPrice) * invoiceCoaItem.ItemType; } command.NewValues["StandardPrice"] = standardPrice; command.NewValues["StudentPrice"] = studentPrice; command.NewValues["AgencyPrice"] = agencyPrice; command.NewValues["CreatedId"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["CreatedId"]))) ? 0 : Convert.ToInt32(command.NewValues["CreatedId"]); command.NewValues["CreatedDate"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["CreatedDate"]))) ? DateTime.Now : command.NewValues["CreatedDate"]; } } ViewState["IsSaveChanged"] = true; }
protected void RadGridVacationSchema_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { var totalDays = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["TotalDays"]))) ? 0 : Convert.ToDouble(command.NewValues["TotalDays"]); var date = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Date"]))) ? DateTime.Now : Convert.ToDateTime(command.NewValues["Date"]); command.NewValues["UserId"] = Id; command.NewValues["TotalDays"] = totalDays; command.NewValues["Date"] = date; if (command.NewValues["VacationSchemaId"] == null) { command.NewValues["CreatedId"] = CurrentUserId.ToString(); command.NewValues["CreatedDate"] = DateTime.Now; } else { command.NewValues["UpdatedId"] = CurrentUserId.ToString(); command.NewValues["UpdatedDate"] = DateTime.Now; } } } }
protected void RadGridHoliday_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { command.NewValues["IsActive"] = command.NewValues["IsActive"].ToString() == "1" ? false : true; DateTime Dob = Convert.ToDateTime(command.NewValues["HolidayDate"]); var Years = Dob.Year; command.NewValues["Year"] = Years; if (command.Type.ToString() == "Insert") { command.NewValues["CreatedDate"] = DateTime.Now; command.NewValues["CreatedId"] = CurrentUserId; } else if (command.Type.ToString() == "Update") { command.NewValues["UpdatedDate"] = DateTime.Now; command.NewValues["UpdatedId"] = CurrentUserId; } } } }
protected void RadGridUserStatus_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { var date = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["IssuedDate"]))) ? DateTime.Now : Convert.ToDateTime(command.NewValues["IssuedDate"]); command.NewValues["UserId"] = Id; command.NewValues["IssuedDate"] = date; if (command.NewValues["UserStatusId"] == null) { command.NewValues["CreatedId"] = CurrentUserId.ToString(); command.NewValues["CreatedDate"] = DateTime.Now; } else { command.NewValues["UpdatedId"] = CurrentUserId.ToString(); command.NewValues["UpdatedDate"] = DateTime.Now; } } } }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { Guid? parentId = Guid.Parse(tree.SelectedNode.Value); if (parentId == Guid.Empty) { parentId = null; } foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Name")) continue; var name = values["Name"].ToString(); var ordinal = Get(values, "Ordinal", 99); var state = Get(values, "State", State.启用); var audit = Get(values, "Audit", false); var auditEditable = Get(values, "AuditEditable", true); switch (command.Type) { case GridBatchEditingCommandType.Insert: { HomoryContext.Value.Catalog.Add(new Catalog { Id = HomoryContext.Value.GetId(), Name = name, ParentId = parentId, Ordinal = ordinal, State = state, Type = CatalogType.文章, Audit = audit.Value, AuditEditable = auditEditable.Value, AuditUsers = "" }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; } case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Catalog.Where(o => o.Id == id).Update(o => new Catalog { Name = name, Ordinal = ordinal, State = state, Audit = audit.Value, AuditEditable = auditEditable.Value }); HomoryContext.Value.SaveChanges(); LogOp(state); } break; } } RebindBatch(); Notify(panel, "操作成功", "success"); }
protected override void OnBatchEditCommand(GridBatchEditingEventArgs e) { GridEditableItem dataItem = e.Item as GridEditableItem; if (dataItem != null) { this.OnCommandChanged(dataItem, GridCrudCommandType.Batch); } base.OnBatchEditCommand(e); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { if (CurrentRights.Contains(HomoryCoreConstant.RightGlobal)) { foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Name")) continue; if (NotSet(values, "Ordinal")) continue; var name = values["Name"].ToString(); var ordinal = Get(values, "Ordinal", 99); var description = Get(values, "Description", ""); var url = Get(values, "Url", ""); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Insert: var nid = HomoryContext.Value.GetId(); HomoryContext.Value.ResourceRoom.Add(new Homory.Model.ResourceRoom { Id = nid, Name = name, Description = description, Url = url, Ordinal = ordinal, State = state, }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; case GridBatchEditingCommandType.Update: var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.ResourceRoom.Where(o => o.Id == id).Update(o => new Homory.Model.ResourceRoom { Name = name, Description = description, Url = url, Ordinal = ordinal, State = state, }); HomoryContext.Value.SaveChanges(); LogOp(state); break; } } Notify(panel, "操作成功", "success"); } else { Notify(panel, "无权限设定直播间", "warn"); } }
protected void RadGridGrade_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { command.NewValues["UpdatedId"] = CurrentUserId.ToString(); command.NewValues["UpdatedDate"] = DateTime.Now; } } }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { try { var values = command.NewValues; if (NotSet(values, "Name")) continue; var name = values["Name"].ToString(); var ordinal = Get(values, "Ordinal", 99); var state = Get(values, "State", State.启用); var home = Get(values, "Home", string.Empty); switch (command.Type) { case GridBatchEditingCommandType.Insert: var newId = HomoryContext.Value.GetId(); HomoryContext.Value.Application.Add(new Application { Id = newId, Name = name, Type = ApplicationType.平台, Icon = "~/Common/默认/群组.png", Ordinal = ordinal, State = state, Home = home }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; case GridBatchEditingCommandType.Update: var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Application.Where(o => o.Id == id).Update(o => new Application { Name = name, Ordinal = ordinal, State = state, Home = home }); HomoryContext.Value.SaveChanges(); LogOp(state); break; } } // ReSharper disable EmptyGeneralCatchClause catch // ReSharper restore EmptyGeneralCatchClause { } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var value = "ObjectId".Query(); if (value.None()) { Response.Redirect("~/Depot/Home"); return; } var objId = value.GlobalId(); var obj = DataContext.DepotObject.Single(o => o.Id == objId); foreach (var command in e.Commands) { var values = command.NewValues; var place = values["Place"].ToString(); var number = values["Number"]; var numberx = values["NumberX"]; if (number.None()) continue; switch (command.Type) { case GridBatchEditingCommandType.Update: { var id = values["Id"].ToString().GlobalId(); var @fixed = bool.Parse(values["Fixed"].ToString()); var @in = DataContext.DepotInX.SingleOrDefault(o => o.Id == id); @in.Place = place; var ___px = new DepotPlace { Code = @in.Code, Place = place, Time = DateTime.Now }; DataContext.DepotPlace.Add(___px); if (!obj.Single) { @in.DepotIn.Place = @in.Place; @in.DepotIn.Note = number.ToString(); } if (!number.None()) { var @inx = DataContext.DepotIn.SingleOrDefault(o => o.Id == id); @inx.Note = numberx.ToString(); } DataContext.SaveChanges(); } break; } } DataContext.SaveChanges(); grid.Rebind(); }
protected void RadGridTuition_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { //List<ProgramTuition> programTuitionList = new List<ProgramTuition>(); //foreach (GridDataItem item in RadGridTuition.Items) //{ // // hours index // for (int i = 4; i <= 11; i++) // { // if (item.Cells[i].Text != string.Empty && item.Cells[i].Text != " ") // { // programTuitionList.Add(new ProgramTuition() // { // SiteLocationId = CurrentSiteLocationId, // IsActive = true, // Weeks = Convert.ToInt32(item.Cells[4].Text), // UpdatedDate = DateTime.Now, // UpdatedId = CurrentUserId, // ProgramId = Convert.ToInt32(Grid.SelectedValue), // HrsStatus = Convert.ToInt32(item.Cells[i].Text), // CountryMarketId = Convert.ToInt32(RadComboBoxCountryMarket.SelectedValue), // Tuition = Convert.ToInt32(item.Cells[i].Text) // }); // } // } //} //if (programTuitionList.Count > 0) //{ // CProgramTuition programTuition = new CProgramTuition(); // // del // programTuition.DelProgramTuition(CurrentSiteLocationId, Convert.ToInt32(Grid.SelectedValue), Convert.ToInt32(RadComboBoxCountryMarket.SelectedValue)); // // add // programTuition.SetProgramTuitionList(programTuitionList); //} command.NewValues["ProgramId"] = Convert.ToInt32(Grid.SelectedValue); command.NewValues["CountryMarketId"] = Convert.ToInt32(RadComboBoxCountryMarket.SelectedValue); command.NewValues["IsActive"] = true; command.NewValues["CreatedId"] = CurrentUserId; command.NewValues["CreatedDate"] = DateTime.Now; return; } } }
protected void RadGrid1_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { ArrayList al = new ArrayList(); foreach (GridBatchEditingCommand command in e.Commands) { Hashtable newValues = command.NewValues; Hashtable oldValues = command.OldValues; al.Add(oldValues["unique_id"].ToString() + "!" + newValues["rate_amount"].ToString() + "!" + newValues["employer_split"].ToString() + "!" + newValues["rate_override1"].ToString()); } ViewState["save"] = al; DoSave(); //lblScript.Text = "<Script>Javascript:CheckSave()</script>"; }
protected void RadGridFlight_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Cancel") { command.NewValues["BusinessTripId"] = Convert.ToInt32(ViewState["NewIndex"]); command.NewValues["AirDate"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["AirDate"]))) ? new DateTime(9999, 12, 31) : command.NewValues["AirDate"]; command.NewValues["AirRate"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["AirRate"]))) ? 0 : Convert.ToDecimal(command.NewValues["AirRate"]); command.NewValues["CreatedId"] = CurrentUserId; command.NewValues["CreatedDate"] = DateTime.Now; } } }
protected void RadGridPurchaseOrderDetail_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Cancel") { command.NewValues["PurchaseOrderId"] = Convert.ToInt32(ViewState["NewIndex"]); command.NewValues["Quantity"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Quantity"]))) ? 1 : Convert.ToInt32(command.NewValues["Quantity"]); command.NewValues["Price"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Price"]))) ? 0 : Convert.ToDecimal(command.NewValues["Price"]); command.NewValues["CreatedId"] = CurrentUserId; command.NewValues["CreatedDate"] = DateTime.Now; } } }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { try { var values = command.NewValues; if (NotSet(values, "Title")) continue; var title = values["Title"].ToString(); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Insert: var newId = HomoryContext.Value.GetId(); HomoryContext.Value.Notice.Add(new Notice { Id = newId, UserId = CurrentUser.Id, Title = title, Content = string.Empty, State = state, Time = DateTime.Now }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; case GridBatchEditingCommandType.Update: var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Notice.Where(o => o.Id == id).Update(o => new Notice { Title = title, State = state, }); HomoryContext.Value.SaveChanges(); LogOp(state); break; } } // ReSharper disable EmptyGeneralCatchClause catch // ReSharper restore EmptyGeneralCatchClause { } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var item = c.SelectedItem; if (item == null) return; var cv = Guid.Parse(item.Value); foreach (var command in e.Commands) { try { var values = command.NewValues; if (NotSet(values, "ProviderId")) continue; var providerId = values["ProviderId"].ToString(); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Insert: HomoryContext.Value.Api.Add(new Api { Id = cv, State = state, ProviderId = providerId, ProviderKey = Guid.NewGuid() }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; case GridBatchEditingCommandType.Update: var providerIdE = values["ProviderId"].ToString(); HomoryContext.Value.Api.Where(o => o.Id == cv && o.ProviderId == providerIdE).Update(o => new Api { State = state }); HomoryContext.Value.SaveChanges(); LogOp(state); break; } } // ReSharper disable EmptyGeneralCatchClause catch // ReSharper restore EmptyGeneralCatchClause { } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var parentId = Guid.Parse(tree.SelectedNode.Value); foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Name")) continue; var name = values["Name"].ToString(); var ordinal = Get(values, "Ordinal", 99); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Insert: { HomoryContext.Value.Catalog.Add(new Catalog { Id = HomoryContext.Value.GetId(), Name = name, ParentId = parentId, TopId = CurrentGroup.Id, Ordinal = ordinal, State = state, Type = CatalogType.团队_名师 }); HomoryContext.Value.SaveChanges(); break; } case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Catalog.Where(o => o.Id == id).Update(o => new Catalog { Name = name, Ordinal = ordinal, State = state, }); HomoryContext.Value.SaveChanges(); } break; } } RebindBatch(); Notify(panel, "操作成功", "success"); }
private void NsGrid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var dataWidget = Widget as GridView; if (dataWidget != null && dataWidget.DataSource != null) { var ds = dataWidget.DataSource; foreach (var item in e.Commands) { if (item.Type == GridBatchEditingCommandType.Update) { var id = item.Item.GetDataKeyValue("Id"); var obiekt = ds.GetObjectById(id.ToString()); obiekt.UpdateValuesFromHashtable(item.NewValues); ds.Update(obiekt); } } } }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { var values = command.NewValues; var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Update: { var key = Get(values, "Id", Guid.Empty); HomoryContext.Value.User.Where(o => o.Id == key).Update(o => new User { State = state }); HomoryContext.Value.SaveChanges(); LogOp(state); } break; } } Notify(panel, "操作成功", "success"); }
protected void RadGridGrade_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Delete") { command.NewValues["GradeSchemaId"] = RadGridGradeName.SelectedValue; if (command.NewValues["GradeSchemaItemId"] == null) { command.NewValues["CreatedId"] = CurrentUserId.ToString(); command.NewValues["CreatedDate"] = DateTime.Now; } else { command.NewValues["UpdatedId"] = CurrentUserId.ToString(); command.NewValues["UpdatedDate"] = DateTime.Now; } } } }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Name")) continue; var ordinal = Get(values, "Ordinal", 1); var name = Get(values, "Name", string.Empty); var state = Get(values, "State", State.启用); switch (command.Type) { case GridBatchEditingCommandType.Insert: { var role = new Role { Id = HomoryContext.Value.GetId(), Name = name, State = state, Ordinal = ordinal }; HomoryContext.Value.Role.Add(role); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); } break; case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); var role = HomoryContext.Value.Role.Single(o => o.Id == id); role.Name = name; role.State = state; role.Ordinal = ordinal; HomoryContext.Value.SaveChanges(); LogOp(state); } break; } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { var values = command.NewValues; var number = values["Number"] == null ? "" : values["Number"].ToString(); switch (command.Type) { case GridBatchEditingCommandType.Update: { var id = values["Id"].ToString().GlobalId(); var @in = DataContext.DepotIn.SingleOrDefault(o => o.Id == id); @in.Note = number; DataContext.SaveChanges(); } break; } } DataContext.SaveChanges(); grid.Rebind(); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var gid = Guid.Parse(combo.SelectedValue); var id = combo.SelectedValue.ToUpper(); using (IStorageEngine engine = STSdb.FromFile(Server.MapPath(string.Format("App_Data/Housing_{0}.record", id)))) { var table = engine.OpenXTablePortable<HousingKey, HousingValue>("Record"); foreach (var command in e.Commands) { var values = command.NewValues; var key = new HousingKey { 学校 = gid, 姓名 = values["姓名"].V(), 住址 = values["住址"].V(), 入学年份 = values["入学年份"].V(), 户籍 = values["户籍"].V(), 身份证号 = values["身份证号"].V() }; var value = new HousingValue { 班号 = values["班号"].V(), 备注 = values["备注"].V(), 时间 = DateTime.Now }; switch (command.Type) { case GridBatchEditingCommandType.Insert: { table[key] = value; engine.Commit(); break; } case GridBatchEditingCommandType.Update: { var old = command.OldValues; var okey = new HousingKey { 学校 = gid, 姓名 = old["姓名"].V(), 住址 = old["住址"].V(), 入学年份 = old["入学年份"].V(), 户籍 = old["户籍"].V(), 身份证号 = old["身份证号"].V() }; table.Delete(okey); table[key] = value; engine.Commit(); break; } case GridBatchEditingCommandType.Delete: { table.Delete(key); engine.Commit(); break; } } } } grid.Rebind(); }
protected void RadGrid1_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (GridBatchEditingCommand command in e.Commands) { Hashtable newValues = command.NewValues; Hashtable oldValues = command.OldValues; string New_status = newValues["status"].ToString(); string Post_ID = oldValues["Id"].ToString(); Post_Model P_ModelOBJ = new Post_Model(); P_ModelOBJ.Status = Convert.ToBoolean(New_status); P_ModelOBJ.ID = Convert.ToInt32(Post_ID); bool _res = Post.UpdatePost_status(P_ModelOBJ); if (!_res) { Alert("Error", "Status has not been saved! Please try again"); } } }
protected void RadGridExpenseDetail_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Cancel") { command.NewValues["ExpenseId"] = Convert.ToInt32(ViewState["NewIndex"]); command.NewValues["Date"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Date"]))) ? new DateTime(9999, 12, 31) : command.NewValues["Date"]; command.NewValues["Office"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Office"]))) ? 0 : Convert.ToDecimal(command.NewValues["Office"]); command.NewValues["Lodging"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Lodging"]))) ? 0 : Convert.ToDecimal(command.NewValues["Lodging"]); command.NewValues["Ground"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Ground"]))) ? 0 : Convert.ToDecimal(command.NewValues["Ground"]); command.NewValues["Meals"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Meals"]))) ? 0 : Convert.ToDecimal(command.NewValues["Meals"]); command.NewValues["Advertising"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Advertising"]))) ? 0 : Convert.ToDecimal(command.NewValues["Advertising"]); command.NewValues["Mail"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Mail"]))) ? 0 : Convert.ToDecimal(command.NewValues["Mail"]); command.NewValues["Telephone"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Telephone"]))) ? 0 : Convert.ToDecimal(command.NewValues["Telephone"]); command.NewValues["Km"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Km"]))) ? 0 : Convert.ToDecimal(command.NewValues["Km"]); command.NewValues["Kilometrage"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Kilometrage"]))) ? 0 : Convert.ToDecimal(command.NewValues["Kilometrage"]); command.NewValues["Miscellaneous"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Miscellaneous"]))) ? 0 : Convert.ToDecimal(command.NewValues["Miscellaneous"]); command.NewValues["CreatedId"] = CurrentUserId; command.NewValues["CreatedDate"] = DateTime.Now; } } }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var gradeId = Guid.Parse(grade.SelectedItem.Value); var courseId = Guid.Parse(course.SelectedItem.Value); foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Title")) continue; var title = values["Title"].ToString(); var ordinal = Get(values, "Ordinal", 99); var defaultState = HomoryContext.Value.AssessTable.Count(o => o.GradeId == gradeId && o.CourseId == courseId && o.State == State.启用) == 0 ? State.启用 : State.停用; var state = Get(values, "State", defaultState); switch (command.Type) { case GridBatchEditingCommandType.Insert: { var newId = HomoryContext.Value.GetId(); HomoryContext.Value.AssessTable.Add(new AssessTable { Id = newId, Title = title, GradeId = gradeId, CourseId = courseId, Content = (new List<AssessItem>()).ToJson(), State = state, Ordinal = ordinal, Time = DateTime.Now }); if (state == State.启用) { HomoryContext.Value.AssessTable.Where(o => o.GradeId == gradeId && o.CourseId == courseId && o.Id != newId && o.State == State.启用).Update(o => new AssessTable { State = State.停用, }); } HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; } case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.AssessTable.Where(o => o.Id == id).Update(o => new AssessTable { Title = title, Ordinal = ordinal, State = state, }); if (state == State.启用) { HomoryContext.Value.AssessTable.Where(o => o.GradeId == gradeId && o.CourseId == courseId && o.Id != id && o.State == State.启用).Update(o => new AssessTable { State = State.停用, }); } HomoryContext.Value.SaveChanges(); LogOp(state); } break; } } Notify(panel, "操作成功", "success"); }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { if (CurrentRights.Contains(HomoryCoreConstant.RightGlobal)) { foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Name")) continue; var name = values["Name"].ToString(); var code = Get(values, "Code", ""); var ordinal = Get(values, "Ordinal", 99); var state = Get(values, "State", State.启用); var classType = Get(values, "ClassType", ClassType.其他); var buildType = Get(values, "BuildType", BuildType.教育部门社会集体办); var dingKey = Get(values, "DingKey", ""); if (!string.IsNullOrEmpty(dingKey)) { string __k, __s; dingKey = HomoryCryptor.Encrypt(dingKey, out __k, out __s); } switch (command.Type) { case GridBatchEditingCommandType.Insert: var nid = HomoryContext.Value.GetId(); var d = new Department { Id = nid, Name = name, TopId = nid, DisplayName = name, Level = 0, Hidden = false, Ordinal = ordinal, State = state, Code = code, BuildType = buildType, ClassType = classType, Type = DepartmentType.学校, DingKey = dingKey }; HomoryContext.Value.Department.Add(d); try { DepartmentHelper.InsertCampus(nid.ToString().ToUpper(), name, ordinal); } catch { Notify(panel, "办公平台学校新增失败", "warn"); } HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; case GridBatchEditingCommandType.Update: var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Department.Where(o => o.Id == id).Update(o => new Homory.Model.Department { Name = name, DisplayName = name, Ordinal = ordinal, Code = code, State = state, BuildType = buildType, ClassType = classType, DingKey = dingKey }); try { DepartmentHelper.UpdateCampus(id.ToString().ToUpper(), name, ordinal, state); } catch { Notify(panel, "办公平台学校更新失败", "warn"); } HomoryContext.Value.SaveChanges(); LogOp(state); break; } } Notify(panel, "操作成功", "success"); } else { Notify(panel, "无权限设定学校", "warn"); } }
protected void RadGrid1_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { }
protected void gridValidity_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { using (OracleConnection connection = new OracleConnection(connString)) { string strSQL = @"update cdma_individual_data_gap23 set FIRST_NAME = :first_name,MIDDLE_NAME = :middle_name,LAST_NAME = :lastname,DOB = :dob,GENDER = :gender, OCCUPATION = :occupation,MINOR_FLAG = :minor_flag,MARITAL_STATUS = :marital_status,NATIONALITY = :nationality where record_id = :record_id"; try { connection.Open(); OracleCommand oracmd = new OracleCommand(strSQL, connection); oracmd.BindByName = true; oracmd.CommandType = System.Data.CommandType.Text; foreach (GridBatchEditingCommand command in e.Commands) { // For Update if ((command.Type == GridBatchEditingCommandType.Update)) { Hashtable newValues = command.NewValues; Hashtable oldValues = command.OldValues; //CIF_ID,FIRST_NAME,MIDDLE_NAME,LAST_NAME,DOB,GENDER,OCCUPATION,MINOR_FLAG,MARITAL_STATUS,NATIONALITY string ID = newValues["RECORD_ID"].ToString(); //string cifId = newValues["CIF_ID"].ToString(); string fname = newValues["FIRST_NAME"] == null ? "" : newValues["FIRST_NAME"].ToString(); string midname = newValues["MIDDLE_NAME"] == null ? "" : newValues["MIDDLE_NAME"].ToString(); string lname = newValues["LAST_NAME"] == null ? "" : newValues["LAST_NAME"].ToString(); string dob = newValues["DOB"] == null ? "" : newValues["DOB"].ToString(); string gender = newValues["GENDER"] == null ? "" : newValues["GENDER"].ToString(); string occupation = newValues["OCCUPATION"] == null ? "" : newValues["OCCUPATION"].ToString(); string minor = newValues["MINOR_FLAG"] == null ? "" : newValues["MINOR_FLAG"].ToString(); string maritalstat = newValues["MARITAL_STATUS"] == null ? "" : newValues["MARITAL_STATUS"].ToString(); string nation = newValues["NATIONALITY"] == null ? "" : newValues["NATIONALITY"].ToString(); oracmd.Parameters.Add(":record_id", OracleDbType.Int32).Value = ID; oracmd.Parameters.Add(":first_name", OracleDbType.Varchar2).Value = fname; oracmd.Parameters.Add(":middle_name", OracleDbType.Varchar2).Value = midname; oracmd.Parameters.Add(":lastname", OracleDbType.Varchar2).Value = lname; oracmd.Parameters.Add(":dob", OracleDbType.Varchar2).Value = dob; oracmd.Parameters.Add(":gender", OracleDbType.Varchar2).Value = gender; oracmd.Parameters.Add(":occupation", OracleDbType.Varchar2).Value = occupation; oracmd.Parameters.Add(":minor_flag", OracleDbType.Varchar2).Value = minor; oracmd.Parameters.Add(":marital_status", OracleDbType.Varchar2).Value = maritalstat; oracmd.Parameters.Add(":nationality", OracleDbType.Varchar2).Value = nation; oracmd.ExecuteNonQuery(); oracmd.Parameters.Clear(); } } } catch (Exception ex) { NotifyUser("Unable to update " + ex.Message); ErrorSignal.FromCurrentContext().Raise(ex); } } gridValidity.Rebind(); SavedChangesList.Visible = true; }
protected void grid_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var campusId = Guid.Parse(tree.SelectedNode.ParentNode.ParentNode.Value); var classId = Guid.Parse(tree.SelectedNode.Value); dynamic result = new ExpandoObject(); result.Ok = true; result.Message = string.Empty; foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "RealName") || NotSet(values, "IDCard") || NotSet(values, "Ordinal")) continue; var idCard = Get(values, "IDCard", (string)null); var name = values["RealName"].ToString(); if (string.IsNullOrWhiteSpace(idCard)) { result.Message += string.Format("姓名为\"{0}\"的学生由于身份证号不正确未保存。", name); result.Ok = false; continue; } var ordinal = Get(values, "Ordinal", 50); var state = Get(values, "State", State.启用); var gender = Get(values, "Gender", (bool?)null); var birthday = Get(values, "Birthday", (DateTime?)null); var uniqueId = Get(values, "UniqueId", (string)null); var nationality = Get(values, "Nationality", (string)null); var birthplace = Get(values, "Birthplace", (string)null); var address = Get(values, "Address", (string)null); var charger = Get(values, "Charger", (string)null); var chargerContact = Get(values, "ChargerContact", (string)null); switch (command.Type) { case GridBatchEditingCommandType.Insert: { StudentAdd(HomoryContext.Value, campusId, classId, ordinal, name, idCard, idCard.Substring(12), state, uniqueId, idCard, gender, birthday, nationality, birthplace, address, charger, chargerContact); LogOp(OperationType.新增); break; } case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); if (!StudentUpdate(HomoryContext.Value, id, ordinal, name, idCard, state, uniqueId, idCard, gender, birthday, nationality, birthplace, address, charger, chargerContact)) { result.Ok = false; result.Message = "学生的身份证号不能重复,请检查!"; } LogOp(state); break; } } } RebindBatch(); Notify(panel, result.Ok ? "操作成功" : result.Message, result.Ok ? "success" : "warn"); }
protected void RadGrid1_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { btnSave_Click(null, null); }
protected void grdTelefone_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { try { for (int i = 0; i < e.Commands.Count; i++) { var currentCommand = e.Commands[i]; if (currentCommand.Type.ToString() == "Insert") { if (!string.IsNullOrEmpty(Request["EntidadeID"])) { Telefone _telefone = new Telefone(); _telefone.EntidadeID = int.Parse(Request["EntidadeID"]); _telefone.TelefoneTipoID = int.Parse(currentCommand.NewValues["TelefoneTipoID"].ToString()); _telefone.DDD = int.Parse(currentCommand.NewValues["DDD"].ToString()); _telefone.Numero = int.Parse(currentCommand.NewValues["Numero"].ToString()); _telefone.DataCriacao = DateTime.Now; _telefone.UsuarioCriadorID = int.Parse(Session["ssnLoggedUserID"].ToString()); _telefone.DataModificacao = DateTime.Now; _telefone.UsuarioModificadorID = int.Parse(Session["ssnLoggedUserID"].ToString()); using (UnitOfWork oUnitOfWork = new UnitOfWork()) { // Persistindo o obj. telefone na base de dados oUnitOfWork.TelefoneREP.Adicionar(_telefone); oUnitOfWork.Save(); // Se o telefone, os outros não podem ser "não principais" if (bool.Parse(currentCommand.NewValues["IsPrincipal"].ToString())) { oUnitOfWork.TelefoneREP.AplicarRegistroPrincipal(_telefone); oUnitOfWork.Save(); } else { oUnitOfWork.TelefoneREP.RemoverRegistroPrincipal(_telefone); oUnitOfWork.Save(); } } } else { Utils.Notificar(ntfGeral, "Entidade desconhecida. Selecione uma entidade para adicionar canais de comunicação.", Enums.TipoNotificacao.Alerta); } } if (currentCommand.Type.ToString() == "Update") { using (UnitOfWork oUnitOfWork = new UnitOfWork()) { if (!string.IsNullOrEmpty(Request["EntidadeID"])) { Telefone _telefone = oUnitOfWork.TelefoneREP.BuscarPorID(int.Parse(currentCommand.NewValues["TelefoneID"].ToString())); _telefone.TelefoneTipoID = int.Parse(currentCommand.NewValues["TelefoneTipoID"].ToString()); _telefone.DDD = int.Parse(currentCommand.NewValues["DDD"].ToString()); _telefone.Numero = int.Parse(currentCommand.NewValues["Numero"].ToString()); _telefone.DataModificacao = DateTime.Now; _telefone.UsuarioModificadorID = int.Parse(Session["ssnLoggedUserID"].ToString()); oUnitOfWork.TelefoneREP.Atualizar(_telefone); oUnitOfWork.Save(); // Se o telefone, os outros devem ser "não principais" if (bool.Parse(currentCommand.NewValues["IsPrincipal"].ToString())) { oUnitOfWork.TelefoneREP.AplicarRegistroPrincipal(_telefone); oUnitOfWork.Save(); } else { oUnitOfWork.TelefoneREP.RemoverRegistroPrincipal(_telefone); oUnitOfWork.Save(); } } else { Utils.Notificar(ntfGeral, "Entidade desconhecida. Selecione uma entidade para adicionar canais de comunicação.", Enums.TipoNotificacao.Alerta); } } } if (currentCommand.Type.ToString() == "Delete") { using (UnitOfWork oUnitOfWork = new UnitOfWork()) { if (!string.IsNullOrEmpty(Request["EntidadeID"])) { Telefone _telefone = oUnitOfWork.TelefoneREP.BuscarPorID(int.Parse(currentCommand.NewValues["TelefoneID"].ToString())); // Se o telefone, o primeiro canal que sobrar deve tomar o posto de canal principal if (_telefone.IsPrincipal) { oUnitOfWork.TelefoneREP.RemoverRegistroPrincipal(_telefone); } oUnitOfWork.TelefoneREP.Remover(_telefone); oUnitOfWork.Save(); } else { Utils.Notificar(ntfGeral, "Entidade desconhecida. Selecione uma entidade para excluir.", Enums.TipoNotificacao.Alerta); } } } } Utils.Notificar(ntfGeral, "Registros de telefone atualizados.", Enums.TipoNotificacao.Informacao); } catch (Exception ex) { Log.Trace(ex, true); Utils.Notificar(ntfGeral, "Falha ao salvar.", Enums.TipoNotificacao.Erro); } }
protected void gridX_BatchEditCommand(object sender, GridBatchEditingEventArgs e) { var parentId = Guid.Parse(tree.SelectedNode.Value); var campusId = Guid.Parse(tree.SelectedNode.ParentNode.Value); var level = tree.SelectedNode.Level + 1; foreach (var command in e.Commands) { var values = command.NewValues; if (NotSet(values, "Ordinal")) continue; var ordinal = Get(values, "Ordinal", 1); var name = string.Format("({0})班", ordinal); var state = Get(values, "State", State.启用); var displayName = Get(values, "DisplayName", name); switch (command.Type) { case GridBatchEditingCommandType.Insert: { HomoryContext.Value.Department.Add(new Homory.Model.Department { Id = HomoryContext.Value.GetId(), ParentId = parentId, TopId = campusId, Name = name, DisplayName = displayName, Level = level, Hidden = false, Ordinal = ordinal, State = state, Type = DepartmentType.班级, Code = string.Empty, BuildType = BuildType.无, ClassType = ClassType.无, Ding = false, DingKey = "" }); HomoryContext.Value.SaveChanges(); LogOp(OperationType.新增); break; } case GridBatchEditingCommandType.Update: { var id = Get(values, "Id", Guid.Empty); HomoryContext.Value.Department.Where(o => o.Id == id).Update(o => new Homory.Model.Department { Name = name, DisplayName = name, Ordinal = ordinal, State = state, }); HomoryContext.Value.SaveChanges(); LogOp(state); } break; } } RebindBatch(); Notify(panel, "操作成功", "success"); }
protected void RadGridCorporateCreditCardDetail_OnBatchEditCommand(object sender, GridBatchEditingEventArgs e) { foreach (var command in e.Commands) { if (command.Type.ToString() != "Cancel") { command.NewValues["CorporateCreditCardId"] = Convert.ToInt32(ViewState["NewIndex"]); command.NewValues["Date"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Date"]))) ? new DateTime(9999, 12, 31) : command.NewValues["Date"]; command.NewValues["SiteLocationId"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["SiteLocationId"]))) ? CurrentSiteLocationId : Convert.ToInt32(command.NewValues["SiteLocationId"]); command.NewValues["Web"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Web"]))) ? 0 : Convert.ToDecimal(command.NewValues["Web"]); command.NewValues["Ground"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Ground"]))) ? 0 : Convert.ToDecimal(command.NewValues["Ground"]); command.NewValues["Office"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Office"]))) ? 0 : Convert.ToDecimal(command.NewValues["Office"]); command.NewValues["Meals"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Meals"]))) ? 0 : Convert.ToDecimal(command.NewValues["Meals"]); command.NewValues["Promotion"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Promotion"]))) ? 0 : Convert.ToDecimal(command.NewValues["Promotion"]); command.NewValues["Membership"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Membership"]))) ? 0 : Convert.ToDecimal(command.NewValues["Mail"]); command.NewValues["Mail"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Mail"]))) ? 0 : Convert.ToDecimal(command.NewValues["Mail"]); command.NewValues["Legal"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Legal"]))) ? 0 : Convert.ToDecimal(command.NewValues["Legal"]); command.NewValues["Student"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Student"]))) ? 0 : Convert.ToDecimal(command.NewValues["Student"]); command.NewValues["Miscellaneous"] = (string.IsNullOrEmpty(Convert.ToString(command.NewValues["Miscellaneous"]))) ? 0 : Convert.ToDecimal(command.NewValues["Miscellaneous"]); command.NewValues["CreatedId"] = CurrentUserId; command.NewValues["CreatedDate"] = DateTime.Now; } } }