protected void btnSave_Click(object sender, EventArgs e) { try { lblSaveMsg.Text = ""; string outMsg = ""; if (ViewState["EditType"].ToString() == "1")//新增Insert { DAL.WareHouse newModel = new WareHouse(); bool getNewOK = GetNewModel(out newModel, out outMsg); if (getNewOK == false) { lblSaveMsg.Text = "新增失败![" + outMsg + "]"; return; } using (GoldEntities context = new GoldEntities()) { context.WareHouse.AddObject(newModel); int AffectRowsCount = context.SaveChanges(); lblSaveMsg.Text = "保存成功"; } } else//更新Update { using (GoldEntities context = new GoldEntities()) { string EditID = ViewState["EditID"].ToString(); DAL.WareHouse updateModel = (from r in context.WareHouse where r.WHCode == EditID select r).FirstOrDefault(); bool getUpdateOK = GetUpdateModel(ref updateModel, out outMsg); if (getUpdateOK == false) { lblSaveMsg.Text = "更新失败![" + outMsg + "]"; return; } //context.WareHouse.Attach(updateModel); int AffectRowsCount = context.SaveChanges(); lblSaveMsg.Text = "保存成功"; } } } catch (Exception ex) { lblSaveMsg.Text = "更新失败![" + Utility.LogHelper.GetExceptionMsg(ex) + "]"; } }
protected void btnDelete_Click(object sender, EventArgs e) { try { lblCheckMsg.Text = ""; lblGridViewMsg.Text = ""; List <string> checkedDelList = GetCheckItemID(); if (checkedDelList.Count <= 0) { //lblCheckMsg.Text = "请先选中待删除的项"; ShowMessageBox("请先选中待删除的项"); return; } using (GoldEntities context = new GoldEntities()) { foreach (string delCode in checkedDelList) { DAL.WareHouse delObject = (from r in context.WareHouse where r.WHCode.Equals(delCode) select r).FirstOrDefault(); context.DeleteObject(delObject); } int delRow = context.SaveChanges(); if (delRow > 0) { //lblCheckMsg.Text = "删除成功![已删除" + delRow.ToString() + "项]"; ShowMessageBox("删除成功![已删除" + delRow.ToString() + "项]"); } else { //lblCheckMsg.Text = "删除失败!"; ShowMessageBox("删除失败!"); } GridViewBind();//删除后重新绑定数据 } } catch (Exception ex) { //lblCheckMsg.Text = "删除出现异常!"; //lblGridViewMsg.Text = Utility.LogHelper.GetExceptionMsg(ex); ShowMessageBox("删除失败!", ex); } }