//private void cobODPNo_SelectedIndexChanged(object sender, EventArgs e) //{ // btnQueryByProjectId_Click(null, null); //} /// <summary> /// 修改计划菜单 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void tsmiEditDrawingPlan_Click(object sender, EventArgs e) { if (dgvDrawingPlan.RowCount == 0) { return; } if (dgvDrawingPlan.CurrentRow == null) { MessageBox.Show("请选中需要修改的计划条目", "提示信息"); return; } string drawingPlanId = dgvDrawingPlan.CurrentRow.Cells["DrawingPlanId"].Value.ToString(); DrawingPlan objDrawingPlan = objDrawingPlanService.GetDrawingPlanById(drawingPlanId); //初始化修改信息 grbEditDrawingPlan.Visible = true;//显示修改框 IniModel(cobEditModel); IniODPNo(cobEditODPNo); txtEditDrawingPlanId.Text = objDrawingPlan.DrawingPlanId.ToString(); txtEditItem.Text = objDrawingPlan.Item; txtEditModuleNo.Text = objDrawingPlan.ModuleNo.ToString(); cobEditModel.Text = objDrawingPlan.Model; cobEditODPNo.Text = objDrawingPlan.ODPNo; txtEditSubTotalWorkload.Text = objDrawingPlan.SubTotalWorkload.ToString(); dtpEditDrReleaseTarget.Text = objDrawingPlan.DrReleaseTarget.ToShortDateString(); dtpEditAddedDate.Text = objDrawingPlan.AddedDate.ToShortDateString(); }
/// <summary> /// 根据计划编号返回单条计划记录 /// </summary> /// <param name="drawingPlanId"></param> /// <returns></returns> public DrawingPlan GetDrawingPlanById(string drawingPlanId) { string sql = "select DrawingPlanId,UserAccount,DrawingPlan.ProjectId,ODPNo,Item,Model,ModuleNo,DrReleaseTarget,SubTotalWorkload,DrawingPlan.AddedDate,ProjectName from DrawingPlan"; sql += " inner join Projects on DrawingPlan.ProjectId=Projects.ProjectId"; sql += " inner join Users on Users.UserId=Projects.UserId"; sql += string.Format(" where DrawingPlanId = {0}", drawingPlanId); SqlDataReader objReader = SQLHelper.GetReader(sql); DrawingPlan objDrawingPlan = null; if (objReader.Read()) { objDrawingPlan = new DrawingPlan() { DrawingPlanId = Convert.ToInt32(objReader["DrawingPlanId"]), UserAccount = objReader["UserAccount"].ToString(), ProjectId = Convert.ToInt32(objReader["ProjectId"]), ODPNo = objReader["ODPNo"].ToString(), ProjectName = objReader["ProjectName"].ToString(), Item = objReader["Item"].ToString(), Model = objReader["Model"].ToString(), ModuleNo = Convert.ToInt32(objReader["ModuleNo"]), DrReleaseTarget = Convert.ToDateTime(objReader["DrReleaseTarget"]), SubTotalWorkload = Convert.ToDecimal(objReader["SubTotalWorkload"]), AddedDate = Convert.ToDateTime(objReader["AddedDate"]) }; } objReader.Close(); return(objDrawingPlan); }
/// <summary> /// 修改制图计划记录 /// </summary> /// <param name="objDrawingPlan"></param> /// <returns></returns> public int EditDrawingPlan(DrawingPlan objDrawingPlan) { string sql = "update DrawingPlan set ProjectId={0},Item='{1}',Model='{2}',ModuleNo='{3}',"; sql += "DrReleasetarget='{4}',SubTotalWorkload='{5}',AddedDate='{6}' where DrawingPlanId={7}"; sql = string.Format(sql, objDrawingPlan.ProjectId, objDrawingPlan.Item, objDrawingPlan.Model, objDrawingPlan.ModuleNo, objDrawingPlan.DrReleaseTarget, objDrawingPlan.SubTotalWorkload, objDrawingPlan.AddedDate, objDrawingPlan.DrawingPlanId); try { return(SQLHelper.Update(sql)); } catch (SqlException ex) { throw new Exception("数据库操作出现异常:" + ex.Message); } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加制图计划 /// </summary> /// <param name="objDrawingPlan"></param> /// <returns></returns> public int AddDraingPlan(DrawingPlan objDrawingPlan) { string sql = "insert into DrawingPlan (ProjectId,Item,Model,ModuleNo,DrReleasetarget,SubTotalWorkload)"; sql += " values({0},'{1}','{2}','{3}','{4}','{5}');select @@identity"; sql = string.Format(sql, objDrawingPlan.ProjectId, objDrawingPlan.Item, objDrawingPlan.Model, objDrawingPlan.ModuleNo, objDrawingPlan.DrReleaseTarget, objDrawingPlan.SubTotalWorkload); try { return(Convert.ToInt32(SQLHelper.GetSingleResult(sql))); } catch (SqlException ex) { throw new Exception("添加制图计划时数据库访问异常" + ex.Message); } catch (Exception ex) { throw ex; } }
/// <summary> /// 提交修改 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnEditDrawingPlan_Click(object sender, EventArgs e) { #region 数据验证 if (cobEditModel.SelectedIndex == -1) { MessageBox.Show("请选择烟罩型号", "验证信息"); cobEditModel.Focus(); return; } if (txtEditModuleNo.Text.Trim().Length == 0) { MessageBox.Show("请输烟罩分段数量", "验证信息"); txtEditModuleNo.Focus(); return; } if (cobEditODPNo.SelectedIndex == -1) { MessageBox.Show("请输入选择或输入项目编号,如果没有,请到项目列表中添加后再选择", "验证信息"); cobEditODPNo.Focus(); return; } //验证数量是数字 if (!DataValidate.IsInteger(txtEditModuleNo.Text.Trim())) { MessageBox.Show("烟罩分段数量必须是数字", "验证信息"); txtEditModuleNo.Focus(); txtEditModuleNo.SelectAll(); return; } //验证计划日期大于添加日期 if (DateTime.Compare(dtpEditDrReleaseTarget.Value, dtpEditAddedDate.Value) < 0) { MessageBox.Show("计划发图日期必须大于添加日期,请认真检查", "验证信息"); return; } #endregion //封装制图计划对象 DrawingPlan objDrawingPlan = new DrawingPlan() { DrawingPlanId = Convert.ToInt32(txtEditDrawingPlanId.Text), ProjectId = Convert.ToInt32(cobEditODPNo.SelectedValue), Item = txtEditItem.Text.Trim(), Model = cobEditModel.Text, ModuleNo = Convert.ToInt32(txtEditModuleNo.Text.Trim()), DrReleaseTarget = Convert.ToDateTime(dtpEditDrReleaseTarget.Text), SubTotalWorkload = Convert.ToDecimal(txtEditSubTotalWorkload.Text.Trim()), AddedDate = Convert.ToDateTime(dtpEditAddedDate.Text.Trim()) }; //调用后台方法修改对象 try { if (objDrawingPlanService.EditDrawingPlan(objDrawingPlan) == 1) { MessageBox.Show("修改计划成功!", "提示信息"); grbEditDrawingPlan.Visible = false; btnQueryAllPlan_Click(null, null);//同步刷新显示数据 } } catch (Exception ex) { MessageBox.Show(ex.Message); } }
/// <summary> /// 添加计划记录 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> private void btnAddDrawingPlan_Click(object sender, EventArgs e) { #region 数据验证 if (cobModel.SelectedIndex == -1) { MessageBox.Show("请选择烟罩型号", "验证信息"); cobModel.Focus(); return; } if (txtModuleNo.Text.Trim().Length == 0) { MessageBox.Show("请输烟罩分段数量", "验证信息"); txtModuleNo.Focus(); return; } if (cobODPNo.SelectedIndex == -1) { MessageBox.Show("请输入选择或输入项目编号,如果没有,请到项目列表中添加后再选择", "验证信息"); cobODPNo.Focus(); return; } //验证数量是数字 if (!DataValidate.IsInteger(txtModuleNo.Text.Trim())) { MessageBox.Show("烟罩分段数量必须是数字", "验证信息"); txtModuleNo.Focus(); txtModuleNo.SelectAll(); return; } #endregion //封装制图计划对象 DrawingPlan objDrawingPlan = new DrawingPlan() { ProjectId = Convert.ToInt32(cobODPNo.SelectedValue), Item = txtItem.Text.Trim(), Model = cobModel.Text, ModuleNo = Convert.ToInt32(txtModuleNo.Text.Trim()), DrReleaseTarget = Convert.ToDateTime(dtpDrReleaseTarget.Text), SubTotalWorkload = Convert.ToDecimal(txtSubTotalWorkload.Text.Trim()) }; //提交添加 try { int drawingPlanId = objDrawingPlanService.AddDraingPlan(objDrawingPlan); if (drawingPlanId > 1) { //提示添加成功 MessageBox.Show("制图计划添加成功", "提示信息"); //刷新显示 btnQueryByProjectId_Click(null, null); //清空内容 //cobUserId.SelectedIndex = -1;//不清空制图人员 //cobModel.SelectedIndex = -1;//不清空型号 //foreach (Control item in Controls) //{ // if (item == txtODPNo) return;//不清空ODPNo,方便查询 // if (item is TextBox) // { // item.Text = ""; // } //} txtSubTotalWorkload.Text = ""; txtModuleNo.Text = ""; txtItem.Text = ""; txtItem.Focus(); } } catch (Exception ex) { MessageBox.Show(ex.Message); } }