Example #1
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            string[] RuleDetail = GetRuleDetail();
            try
            {
                DbHelper.GetInstance().ExecSqlText(string.Format(" select {0} from Workflow_Form where RequestID=0", RuleDetail[0]));
            }
            catch
            {
                ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "add", "alert('赋值表达式不正确,无法添加');", true);
                return;
            }

            DataTable dtComputeRoute = (DataTable)ViewState["dtComputeRoute"];
            Workflow_NodeAddInOperation_Type0_SpParameterEntity _Type0_SpParameterEntity = new Workflow_NodeAddInOperation_Type0_SpParameterEntity();
            _Type0_SpParameterEntity.AddInOPID = DNTRequest.GetInt("opid", 0);
            _Type0_SpParameterEntity.SpParameter = ddlParameterList.SelectedValue;
            _Type0_SpParameterEntity.TartgetValue = GetRuleDetail()[0];
            DbHelper.GetInstance().UpdateWorkflow_NodeAddInOperation_Type0_SpParameter(_Type0_SpParameterEntity, dtComputeRoute);
            dtComputeRoute.Rows.Clear();
            lblExpression.Text = "";
            BindGridView();
            System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
        }
Example #2
0
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            Workflow_FieldDictEntity _FieldDictEntity = DbHelper.GetInstance().GetWorkflow_FieldDictEntityByKeyCol(ddlFieldIDTo.SelectedValue);
            string[] RuleDetail = GetRuleDetail();
            if (_FieldDictEntity.HTMLTypeID != 8 && rblAddInOperationType.SelectedValue == "1")
            {
                try
                {
                    DbHelper.GetInstance().ExecSqlText(string.Format(" select {0} from Workflow_Form where RequestID=0", RuleDetail[0]));
                }
                catch
                {
                    BindGridView();
                    ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "add", "alert('赋值表达式不正确,无法添加');", true);
                    return;
                }
            }

            DataTable dtComputeRouteOperation = (DataTable)ViewState["dtComputeRouteOperation"];
            DataTable dtComputeRouteOperation2;
            Workflow_NodeAddInOperation_Type0Entity _Type0Entity = new Workflow_NodeAddInOperation_Type0Entity();
            _Type0Entity.AddInOPID = txtAddInOPID.Value != "" ? Convert.ToInt32(txtAddInOPID.Value) : 0;
            _Type0Entity.NodeID = DNTRequest.GetInt("id", 0);
            _Type0Entity.OPTime = DNTRequest.GetInt("t", 0);
            _Type0Entity.TargetFieldID = Int32.Parse(ddlFieldIDTo.SelectedValue);
            if (_FieldDictEntity.HTMLTypeID == 8)
            {
                dtComputeRouteOperation2 = dtComputeRouteOperation.Clone();
                _Type0Entity.CaculateType = 2;
                _Type0Entity.CaculateValue = txtBrowseValue.Value;
            }
            else
            {
                dtComputeRouteOperation2 = dtComputeRouteOperation;
                _Type0Entity.CaculateType = Int32.Parse(rblAddInOperationType.SelectedValue);
                _Type0Entity.CaculateValue = RuleDetail[0];
            }
            _Type0Entity.DataSetID = txtDataSetID.Value != "" ? Int32.Parse(txtDataSetID.Value) : 0;
            _Type0Entity.ValueField = ddlValueColumn.SelectedValue;
            _Type0Entity.DataSourceID = txtDataSourceID.Value != "" ? Int32.Parse(txtDataSourceID.Value) : 0;
            _Type0Entity.StorageProcedure = ddlStorageProcedure.SelectedValue;
            _Type0Entity.OutputParameter = ddlOutputParameter.SelectedValue;
            _Type0Entity.OPCondition = "(1=1)";
            _Type0Entity.CreateSID = userEntity.UserSerialID;
            _Type0Entity.CreateDate = DateTime.Now;
            string AddInOPID = DbHelper.GetInstance().AddWorkflow_NodeAddInOperation_Type0(_Type0Entity, dtComputeRouteOperation2);
            dtComputeRouteOperation.Rows.Clear();
            lblExpression.Text = "";
            if (rblAddInOperationType.SelectedValue == "4")
            {
                DataTable dtSpParameter = DbHelper.GetInstance().GetAllStoredProcedureParameters(_Type0Entity.DataSourceID, _Type0Entity.StorageProcedure);
                for (int i = 0; i < dtSpParameter.Rows.Count; i++)
                {
                    if ("ReturnValue" == dtSpParameter.Rows[i]["ParameterDirection"].ToString())
                    {
                        continue;
                    }
                    Workflow_NodeAddInOperation_Type0_SpParameterEntity _Type0_SpParameterEntity = new Workflow_NodeAddInOperation_Type0_SpParameterEntity();
                    _Type0_SpParameterEntity.AddInOPID = Int32.Parse(AddInOPID);
                    _Type0_SpParameterEntity.SpParameter = dtSpParameter.Rows[i]["ParameterName"].ToString();
                    _Type0_SpParameterEntity.ParameterType = dtSpParameter.Rows[i]["ParameterType"].ToString();
                    _Type0_SpParameterEntity.ParameterSize = Convert.ToInt32(dtSpParameter.Rows[i]["ParameterSize"]);
                    _Type0_SpParameterEntity.ParameterDirection = dtSpParameter.Rows[i]["ParameterDirection"].ToString();
                    _Type0_SpParameterEntity.TartgetValue = "";
                    DbHelper.GetInstance().AddWorkflow_NodeAddInOperation_Type0_SpParameter(_Type0_SpParameterEntity);
                }
            }
            BindGridView();

            System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
        }
Example #3
0
        /// <summary>
        /// 更新信息
        /// </summary>
        /// <param name="_Type0_SpParameterEntity"></param>
        /// <param name="dtComputeRoute"></param>
        /// <returns></returns>
        public string UpdateWorkflow_NodeAddInOperation_Type0_SpParameter(Workflow_NodeAddInOperation_Type0_SpParameterEntity _Type0_SpParameterEntity, DataTable dtComputeRoute)
        {
            DbParameter[] pramsUpdate = {
                                       MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type0_SpParameterEntity.AddInOPID ),
                                       MakeInParam("@SpParameter",(DbType)SqlDbType.VarChar,50,_Type0_SpParameterEntity.SpParameter ),
                                       MakeInParam("@TartgetValue",(DbType)SqlDbType.VarChar,2000,_Type0_SpParameterEntity.TartgetValue ),
                                             };
            StringBuilder sb = new StringBuilder();
            sb.Append("Update [dbo].[Workflow_NodeAddInOperation_Type0_SpParameter]");
            sb.Append(" set ");
            sb.Append(" [TartgetValue]=@TartgetValue ");
            sb.Append(" where [AddInOPID]=@AddInOPID and [SpParameter]=@SpParameter ");
            ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString();

            DbParameter[] pramsDelete = {
                                             MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type0_SpParameterEntity.AddInOPID ),
                                             MakeInParam("@SpParameter",(DbType)SqlDbType.VarChar,50,_Type0_SpParameterEntity.SpParameter ),
                                         };
            string sql = @"
            delete from [dbo].[Workflow_ComputeRouteSpParameter0] where AddInOPID=@AddInOPID and SpParameter=@SpParameter;
            ";
            ExecuteNonQuery(CommandType.Text, sql, pramsDelete).ToString();

            for (int i = 0; i < dtComputeRoute.Rows.Count; i++)
            {
                DbParameter[] pramsRouteInsert = {
                                       MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type0_SpParameterEntity.AddInOPID ),
                                       MakeInParam("@SpParameter",(DbType)SqlDbType.VarChar,50,_Type0_SpParameterEntity.SpParameter ),
                                       MakeInParam("@ComputeType",(DbType)SqlDbType.Int,4,dtComputeRoute.Rows[i]["ComputeType"] ),
                                       MakeInParam("@RouteValue",(DbType)SqlDbType.VarChar,50,dtComputeRoute.Rows[i]["RouteValue"] ),
                                       MakeInParam("@RouteOrder",(DbType)SqlDbType.Int,4,dtComputeRoute.Rows[i]["RouteOrder"] ),
                                                  };
                string sqlInsert = @" insert into Workflow_ComputeRouteSpParameter0(AddInOPID,SpParameter,ComputeType,RouteValue,RouteOrder)values(@AddInOPID,@SpParameter,@ComputeType,@RouteValue,@RouteOrder) ";
                ExecuteScalar(CommandType.Text, sqlInsert, pramsRouteInsert);
            }

            return "1";
        }
Example #4
0
        /// <summary>
        /// 新增信息
        /// </summary>
        /// <param name="_Type0_SpParameterEntity"></param>
        /// <returns></returns>
        public string AddWorkflow_NodeAddInOperation_Type0_SpParameter(Workflow_NodeAddInOperation_Type0_SpParameterEntity _Type0_SpParameterEntity)
        {
            //判断该记录是否已经存在

            DbParameter[] prams = {
                                      MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type0_SpParameterEntity.AddInOPID ),
                                      MakeInParam("@SpParameter",(DbType)SqlDbType.VarChar,100,_Type0_SpParameterEntity.SpParameter ),
                                  };
            string sql = " SELECT * from [dbo].[Workflow_NodeAddInOperation_Type0_SpParameter] where AddInOPID=@AddInOPID and SpParameter=@SpParameter";
            if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0)
            {
                return "-1";//该记录已经存在

            }
            else
            {
                DbParameter[] pramsInsert = {
                                       MakeInParam("@AddInOPID",(DbType)SqlDbType.Int,4,_Type0_SpParameterEntity.AddInOPID ),
                                       MakeInParam("@SpParameter",(DbType)SqlDbType.VarChar,100,_Type0_SpParameterEntity.SpParameter ),
                                       MakeInParam("@ParameterType",(DbType)SqlDbType.VarChar,50,_Type0_SpParameterEntity.ParameterType ),
                                       MakeInParam("@ParameterDirection",(DbType)SqlDbType.VarChar,50,_Type0_SpParameterEntity.ParameterDirection ),
                                       MakeInParam("@ParameterSize",(DbType)SqlDbType.Int,4,_Type0_SpParameterEntity.ParameterSize ),
                                       MakeInParam("@TartgetValue",(DbType)SqlDbType.VarChar,2000,_Type0_SpParameterEntity.TartgetValue ),
                                             };
                StringBuilder sb = new StringBuilder();
                sb.Append("INSERT INTO [dbo].[Workflow_NodeAddInOperation_Type0_SpParameter]");
                sb.Append("(");
                sb.Append(" [AddInOPID]");
                sb.Append(",[SpParameter]");
                sb.Append(",[ParameterType]");
                sb.Append(",[ParameterDirection]");
                sb.Append(",[ParameterSize]");
                sb.Append(",[TartgetValue]");
                sb.Append(") ");
                sb.Append(" VALUES (");
                sb.Append("@AddInOPID,");
                sb.Append("@SpParameter,");
                sb.Append("@ParameterType,");
                sb.Append("@ParameterDirection,");
                sb.Append("@ParameterSize,");
                sb.Append("@TartgetValue )");
                sb.Append("select @@identity;");
                return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
            }
        }
Example #5
0
 protected void btnDel_Click(object sender, EventArgs e)
 {
     for (int i = 0; i < GridView1.Rows.Count; i++)
     {
         CheckBox cb = this.GridView1.Rows[i].FindControl("Item") as CheckBox;
         if (cb.Checked)
         {
             string SpParameter = GridView1.DataKeys[i][0].ToString().Trim();
             Workflow_NodeAddInOperation_Type0_SpParameterEntity _Type0_SpParameterEntity = new Workflow_NodeAddInOperation_Type0_SpParameterEntity();
             _Type0_SpParameterEntity.AddInOPID = DNTRequest.GetInt("opid", 0);
             _Type0_SpParameterEntity.SpParameter = SpParameter;
             _Type0_SpParameterEntity.TartgetValue = "";
             DataTable dtComputeRoute = (DataTable)ViewState["dtComputeRoute"];
             DataTable dtComputeRoute2 = dtComputeRoute.Clone();
             DbHelper.GetInstance().UpdateWorkflow_NodeAddInOperation_Type0_SpParameter(_Type0_SpParameterEntity, dtComputeRoute2);
         }
     }
     BindGridView();
     System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false);
 }