/// <summary> /// 新增按钮 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnAddNew_Click(object sender, EventArgs e) { if (Page.IsValid == false) { return; } //lblAddMsg.Text = ""; ClearTipMsgLabel();//清除提示信息 try { PackageStatistic newModel = null; string msg = ""; if (GetNewModel(out newModel, out msg) == false) { lblAddMsg.Text = msg; DAL.CommonConvert.ShowMessageBox(this.Page, msg); return; } using (DAL.GoldEntities context = new DAL.GoldEntities()) { context.PackageStatistic.AddObject(newModel); context.SaveChanges(); lblAddMsg.Text = "保存成功"; DAL.CommonConvert.ShowMessageBox(this.Page, "保存成功!"); gv_BinList.DataBind(); } } catch (Exception ex) { DAL.CommonConvert.ShowMessageBox(this.Page, "保存失败!"); lblAddMsg.Text = "保存失败!详细信息:" + Utility.LogHelper.GetExceptionMsg(ex); } }
/// <summary> /// 行命令触发前先清空界面消息提示 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void gv_BinList_RowCommand(object sender, GridViewCommandEventArgs e) { GridView senderGrid = sender as GridView; //更新或删除前对消息Label清空 if (e.CommandName == "Edit" || e.CommandName == "Update" || e.CommandName == "Delete") { //lblGridViewMsg.Text = ""; ClearTipMsgLabel();//清除提示信息 } else if (e.CommandName == "MyDefineUpdate") { lblGridViewMsg.Text = ""; if (senderGrid.EditIndex != -1) { int editBinCode = (int)senderGrid.DataKeys[senderGrid.EditIndex].Value; try { using (GoldEntities context = new GoldEntities()) { PackageStatistic updateModel = (from r in context.PackageStatistic where r.PSID == editBinCode select r).FirstOrDefault(); string msg = ""; if (GetUpdateModel(ref updateModel, senderGrid.Rows[senderGrid.EditIndex], out msg) == false) { lblGridViewMsg.Text = msg; DAL.CommonConvert.ShowMessageBox(this.Page, msg); return; } else { int result = context.SaveChanges(); if (result > 0) { lblGridViewMsg.Text = "更新成功!"; DAL.CommonConvert.ShowMessageBox(this.Page, "更新成功!"); senderGrid.EditIndex = -1;//取消编辑状态 } else { DAL.CommonConvert.ShowMessageBox(this.Page, "更新失败(影响行数为0)!"); lblGridViewMsg.Text = "更新失败(影响行数为0)"; } } } } catch (Exception ex) { DAL.CommonConvert.ShowMessageBox(this.Page, "更新失败!"); lblGridViewMsg.Text = "更新失败[" + Utility.LogHelper.GetExceptionMsg(ex) + "]"; } } } }
/// <summary> /// 获取新增界面中的数据 /// </summary> /// <param name="msg">异常消息</param> /// <returns></returns> private bool GetUpdateModel(ref PackageStatistic updateModel, GridViewRow editRow, out string msg) { msg = ""; try { if (null == editRow) { msg = "获取的编辑行为空!请重试!"; return(false); } TextBox tbxRowPackageTotalCount = null; TextBox tbxRowPackageNoStart = null; TextBox tbxRowPackageNoEnd = null; TextBox tbxRowComment = null; tbxRowPackageTotalCount = editRow.FindControl("tbxRowPackageTotalCount") as TextBox; tbxRowPackageNoStart = editRow.FindControl("tbxRowPackageNoStart") as TextBox; tbxRowPackageNoEnd = editRow.FindControl("tbxRowPackageNoEnd") as TextBox; tbxRowComment = editRow.FindControl("tbxRowComment") as TextBox; if (tbxRowComment == null || tbxRowPackageNoEnd == null || tbxRowPackageNoStart == null || tbxRowPackageTotalCount == null) { msg = "未能获取编辑的数据!"; return(false); } int packageTotalCount = 0; if (int.TryParse(tbxRowPackageTotalCount.Text, out packageTotalCount) == false) { msg = "总数量只能为数字!"; return(false); } updateModel.PackageTotalCount = packageTotalCount; updateModel.PackageNoStart = tbxRowPackageNoStart.Text.Trim(); updateModel.PackageNoEnd = tbxRowPackageNoEnd.Text.Trim(); updateModel.UpdateTime = DateTime.Now; updateModel.Remark = tbxRowComment.Text.Trim(); return(true); } catch (Exception ex) { msg = ex.Message.ToString(); return(false); } }
/// <summary> /// 多项删除按钮事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void btnDelete_Click(object sender, EventArgs e) { try { ClearTipMsgLabel();//清除提示信息 List <int> checkedDelList = GetCheckItemID(); if (checkedDelList.Count <= 0) { lblCheckMsg.Text = "请先选中待删除的项"; DAL.CommonConvert.ShowMessageBox(this.Page, "请先选中待删除的项!"); return; } using (GoldEntities context = new GoldEntities()) { foreach (int delCode in checkedDelList) { PackageStatistic delObject = (from r in context.PackageStatistic where r.PSID.Equals(delCode) select r).FirstOrDefault(); context.DeleteObject(delObject); } int delRow = context.SaveChanges(); if (delRow > 0) { DAL.CommonConvert.ShowMessageBox(this.Page, "删除成功![已删除" + delRow.ToString() + "项]"); lblCheckMsg.Text = "删除成功![已删除" + delRow.ToString() + "项]"; } else { DAL.CommonConvert.ShowMessageBox(this.Page, "删除失败!"); lblCheckMsg.Text = "删除失败!"; } //GridViewBind();//删除后重新绑定数据 gv_BinList.DataBind(); } } catch (Exception ex) { DAL.CommonConvert.ShowMessageBox(this.Page, "删除失败!"); lblGridViewMsg.Text = "删除失败[" + Utility.LogHelper.GetExceptionMsg(ex) + "]"; } }
public void UpdateSupportTypeFor(PackageStatistic stat, SupportType supportType) { Updates[stat.Name] = supportType; }
/// <summary> /// 获取新增界面中的数据 /// </summary> /// <param name="msg">异常消息</param> /// <returns></returns> private bool GetNewModel(out PackageStatistic newModel, out string msg) { msg = ""; newModel = null; try { if (string.IsNullOrEmpty(DropDownListNewWHCode.SelectedItem.Value) || string.IsNullOrEmpty(DropDownListNewPackage.SelectedItem.Value) || string.IsNullOrEmpty(tbxNewPackageTotalCount.Text.Trim())) { msg = "仓库、包装、总数量 均为必填项!请填写!"; return(false); } int tempTotalCount = 0; if (int.TryParse(tbxNewPackageTotalCount.Text, out tempTotalCount) == false) { msg = "总数量必须为数字!请重新填写!"; return(false); } string whCode = ""; string packageName = ""; newModel = new PackageStatistic(); newModel.WHCode = DropDownListNewWHCode.SelectedItem.Value; newModel.WHName = DropDownListNewWHCode.SelectedItem.Text; newModel.PackageName = DropDownListNewPackage.SelectedItem.Text; int tempPackageID = 0; if (int.TryParse(DropDownListNewPackage.SelectedItem.Value, out tempPackageID) == true) { newModel.PackageId = tempPackageID; } else { newModel.PackageId = null; } newModel.PackageNoStart = tbxNewPackageStart.Text.Trim(); newModel.PackageNoEnd = tbxNewPackageEnd.Text.Trim(); newModel.PackageTotalCount = tempTotalCount; newModel.Remark = tbxNewRemark.Text; newModel.UpdateTime = DateTime.Now; whCode = newModel.WHCode; packageName = newModel.PackageName.Trim(); using (GoldEntities context = new GoldEntities()) { var sameCode = (from r in context.PackageStatistic where (r.WHCode == whCode && r.PackageName.Trim() == packageName.Trim()) select r).ToList(); if (sameCode != null && sameCode.Count > 0) { msg += "系统中已经存在仓库为[" + whCode + "]、包装为[" + packageName + "]的记录,请重填或编辑现有记录!"; } if (msg.Length > 0) { return(false); } } return(true); } catch (Exception ex) { msg = Utility.LogHelper.GetExceptionMsg(ex); return(false); } }