示例#1
0
 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) + "]";
     }
 }
示例#2
0
        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);
            }
        }