Example #1
0
        /// <summary>
        /// 删除数据方法
        /// </summary>
        /// <param name="id"></param>
        /// <returns></returns>
        private bool deleteData(decimal setno)
        {
            try
            {
                int               nodeno, workflowno;
                BLL.WORKFLOWSET   workflowsetBll = new BLL.WORKFLOWSET();
                Model.WORKFLOWSET workflowsetMdl = new Model.WORKFLOWSET();

                BLL.STU_WORKFLOW stu_workflowBll = new BLL.STU_WORKFLOW();

                workflowsetMdl = workflowsetBll.GetModel(setno);
                nodeno         = (int)workflowsetMdl.NODENO;
                workflowno     = (int)workflowsetMdl.WORKFLOWNO;

                int recordCount = stu_workflowBll.GetRecordCount("and STU_WORKFLOW.nodeno = " + nodeno.ToString() + " and TEA_STU.workflowno = " + workflowno.ToString());
                if (recordCount > 0)
                {
                    MessageBox.Show("该设置信息已经被使用,不能被删除!", "提示信息");
                    return(false);
                }
                else
                {
                    workflowsetBll.Delete(setno);
                    return(true);
                }
            }
            catch (Exception exception)
            {
                MessageBox.Show("删除失败!", exception.Message);
                return(false);
            }
        }
Example #2
0
        /// <summary>
        /// 查询数据
        /// </summary>
        private void ReadData(string workflowname)
        {
            string condition = "";

            BLL.WORKFLOW   workflowBll = new BLL.WORKFLOW();
            Model.WORKFLOW workflowMdl = new Model.WORKFLOW();
            workflowMdl = workflowBll.GetModel(workflowname);
            int workflowno = workflowMdl.WORKFLOWNO;

            if (workflowno > 0)
            {
                BLL.WORKFLOWSET workflowsetBll = new BLL.WORKFLOWSET();
                condition = " WORKFLOWSET.WORKFLOWNO = " + workflowno.ToString();
                this.gc_workflowset.DataSource = workflowsetBll.GetList(condition).Tables[0];
                this.gridView1.BestFitColumns();
                DBUtility.ToolHelper.DrawRowIndicator(gridView1, 40);
                DBUtility.ToolHelper.SetLineColorofGridView(this.gridView1);
            }
        }
Example #3
0
 /// <summary>
 /// 删除数据方法
 /// </summary>
 /// <param name="id"></param>
 /// <returns></returns>
 private bool deleteData(int id)
 {
     try
     {
         BLL.WORKFLOWSET workflowsetbll = new BLL.WORKFLOWSET();
         int             recordCount    = workflowsetbll.GetRecordCount("workflowno = " + id.ToString());
         if (recordCount > 0)
         {
             MessageBox.Show("该工作节点信息已经被使用,不能被删除!", "提示信息");
             return(false);
         }
         else
         {
             BLL.WORKNODE worknodebll = new BLL.WORKNODE();
             worknodebll.Delete(id);
             return(true);
         }
     }
     catch (Exception exception)
     {
         MessageBox.Show("删除失败!", exception.Message);
         return(false);
     }
 }
        /// <summary>
        /// 保存数据方法
        /// </summary>
        /// <returns></returns>
        private bool saveData()
        {
            try
            {
                BLL.WORKFLOWSET   workflowsetbll = new BLL.WORKFLOWSET();
                Model.WORKFLOWSET workflowsetmdl = new Model.WORKFLOWSET();

                BLL.WORKNODE   worknodeBll = new BLL.WORKNODE();
                Model.WORKNODE worknodeMdl = new Model.WORKNODE();

                BLL.WORKFLOW   workflowBll = new BLL.WORKFLOW();
                Model.WORKFLOW workflowMdl = new Model.WORKFLOW();

                if (this.cbb_nodename.Text == "")
                {
                    MessageBox.Show("工作节点不能为空!", "提示信息");
                    return(false);
                }

                if (this.cbb_nodeorder.Text == "")
                {
                    MessageBox.Show("节点顺序不能为空!", "提示信息");
                    return(false);
                }

                if (this.de_begintime.Text == "")
                {
                    MessageBox.Show("开始日期不能为空!", "提示信息");
                    return(false);
                }

                if (this.de_endtime.Text == "")
                {
                    MessageBox.Show("截止日期不能为空!", "提示信息");
                    return(false);
                }
                if (this._enumStatus == StatusClass.AddNew)  //新增工作流节点
                {
                    //获取工作流编号
                    workflowMdl = workflowBll.GetModel(workflowsetaddMdl.WORKFLOWNAME);
                    int workflowno = workflowMdl.WORKFLOWNO;
                    workflowsetmdl.WORKFLOWNO = workflowno;

                    //获取工作节点编号
                    worknodeMdl           = worknodeBll.GetModel(this.cbb_nodename.Text);
                    workflowsetmdl.NODENO = worknodeMdl.NODENO;

                    workflowsetmdl.NODEORDER = ToolHelper.ConvertToInt(this.cbb_nodeorder.Text);
                    workflowsetmdl.BEGINTIME = ToolHelper.ConvertToDateTime(this.de_begintime.Text);
                    workflowsetmdl.ENDTIME   = ToolHelper.ConvertToDateTime(this.de_endtime.Text);

                    workflowsetbll.Add(workflowsetmdl);
                    return(true);
                }
                else if (this._enumStatus == StatusClass.Edit)  //修改工作节点
                {
                    //获取工作流编号
                    workflowMdl = workflowBll.GetModel(workflowsetaddMdl.WORKFLOWNAME);
                    int workflowno = workflowMdl.WORKFLOWNO;
                    workflowsetmdl.WORKFLOWNO = workflowno;
                    worknodeMdl              = worknodeBll.GetModel(this.cbb_nodename.Text);
                    workflowsetmdl.NODENO    = worknodeMdl.NODENO;
                    workflowsetmdl.NODEORDER = ToolHelper.ConvertToInt(this.cbb_nodeorder.Text);
                    workflowsetmdl.BEGINTIME = ToolHelper.ConvertToDateTime(this.de_begintime.Text);
                    workflowsetmdl.ENDTIME   = ToolHelper.ConvertToDateTime(this.de_endtime.Text);
                    workflowsetmdl.SETNO     = setno;

                    workflowsetbll.Update(workflowsetmdl);
                    return(true);
                }
                return(true);
            }
            catch (Exception exception)
            {
                MessageBox.Show("保存失败!", exception.Message);
                return(false);
            }
        }