示例#1
0
 /// <summary>
 /// 新增信息
 /// </summary>
 /// <param name="_Workflow_NodeTriggerConditionEntity"></param>
 /// <returns>返回string "-1"表示该已经存在,否则成功 </returns>
 public string AddWorkflow_NodeTriggerCondition(Workflow_NodeTriggerConditionEntity _Workflow_NodeTriggerConditionEntity)
 {
     DbParameter[] pramsInsert = {
                                MakeInParam("@ConditionID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerConditionEntity.ConditionID ),
                                MakeInParam("@BatchSeq",(DbType)SqlDbType.TinyInt ,1,_Workflow_NodeTriggerConditionEntity.BatchSeq ),
                                MakeInParam("@BranchBatchSeq",(DbType)SqlDbType.TinyInt,1,_Workflow_NodeTriggerConditionEntity.BranchBatchSeq ),
                                MakeInParam("@TriggerID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerConditionEntity.TriggerID ),
                                MakeInParam("@FieldID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerConditionEntity.FieldID ),
                                MakeInParam("@SymbolCode",(DbType)SqlDbType.VarChar,50,_Workflow_NodeTriggerConditionEntity.SymbolCode ),
                             //    MakeInParam("@CompareFieldID",(DbType)SqlDbType.Int,4,_Workflow_NodeTriggerConditionEntity. ),
                                MakeInParam("@CompareToValue",(DbType)SqlDbType.VarChar,200,_Workflow_NodeTriggerConditionEntity.CompareToValue ),
                                MakeInParam("@AndOr",(DbType)SqlDbType.VarChar,20,_Workflow_NodeTriggerConditionEntity.AndOr )
                                      };
     StringBuilder sb = new StringBuilder();
     sb.Append("INSERT INTO [dbo].[Workflow_NodeTriggerCondition]");
     sb.Append("(");
     sb.Append("[BatchSeq]");
     sb.Append(",[BranchBatchSeq]");
     sb.Append(",[TriggerID]");
     sb.Append(",[FieldID]");
     sb.Append(",[SymbolCode]");
     //   sb.Append(",[CompareFieldID]");
     sb.Append(",[CompareToValue]");
     sb.Append(",[AndOr]");
     sb.Append(") ");
     sb.Append(" VALUES (");
     sb.Append("@BatchSeq,");
     sb.Append("@BranchBatchSeq,");
     sb.Append("@TriggerID,");
     sb.Append("@FieldID,");
     sb.Append("@SymbolCode,");
     // sb.Append("@CompareFieldID,");
     sb.Append("@CompareToValue,");
     sb.Append("@AndOr");
     sb.Append("); ");
     sb.Append("select @@identity;");
     return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
 }
示例#2
0
 private Workflow_NodeTriggerConditionEntity GetWorkflow_NodeTriggerConditionFromIDataReader(DbDataReader dr)
 {
     Workflow_NodeTriggerConditionEntity dt = new Workflow_NodeTriggerConditionEntity();
     if (dr.FieldCount > 0)
     {
         if (dr["ConditionID"].ToString() != "" || dr["ConditionID"] != null) dt.ConditionID = Int32.Parse(dr["ConditionID"].ToString());
         dt.BatchSeq = Convert.ToByte(dr["BatchSeq"]);
         dt.BranchBatchSeq = Convert.ToByte(dr["BranchBatchSeq"]);
         if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString());
         if (dr["FieldID"].ToString() != "" || dr["FieldID"] != null) dt.FieldID = Int32.Parse(dr["FieldID"].ToString());
         dt.SymbolCode = dr["SymbolCode"].ToString();
         dt.CompareToValue = dr["CompareToValue"].ToString();
         dt.AndOr = dr["AndOr"].ToString();
         dr.Close();
         return dt;
     }
     dr.Close();
     return null;
 }
示例#3
0
文件: GG500501.aspx.cs 项目: pcstx/OA
        protected void btnAdd_Click(object sender, EventArgs e)
        {
            DataTable dtConditonSeq = (DataTable)ViewState["dtConditonSeq"];
            Workflow_NodeTriggerConditionEntity _NodeConditionEntity = new Workflow_NodeTriggerConditionEntity();
            _NodeConditionEntity.TriggerID  = DNTRequest.GetInt("id", 0);
            DataTable dtMaxSeq = DbHelper.GetInstance().GetDBRecords("MaxBatchSeq=isnull(max(BatchSeq),0)+1", "Workflow_NodeTriggerCondition", "TriggerID=" + DNTRequest.GetString("id"), "");
            _NodeConditionEntity.BatchSeq = Convert.ToByte (dtMaxSeq.Rows[0]["MaxBatchSeq"]);
            for (int i = 0; i < dtConditonSeq.Rows.Count; i++)
            {
            _NodeConditionEntity.BranchBatchSeq = Convert.ToByte(dtConditonSeq.Rows[i]["BranchBatchSeq"]);
                _NodeConditionEntity.FieldID = Convert.ToInt32(dtConditonSeq.Rows[i]["FieldID"]);
                _NodeConditionEntity.SymbolCode = dtConditonSeq.Rows[i]["SymbolCode"].ToString();
                _NodeConditionEntity.CompareToValue = dtConditonSeq.Rows[i]["CompareToValue"].ToString();
                _NodeConditionEntity.AndOr = dtConditonSeq.Rows[i]["AndOr"].ToString();

                DbHelper.GetInstance().AddWorkflow_NodeTriggerCondition (_NodeConditionEntity);
            }
            dtConditonSeq.Rows.Clear();
            DataRow dr = dtConditonSeq.NewRow();
            dr["BranchBatchSeq"] = 1;
            dr["FieldID"] = 0;
            dr["SymbolCode"] = "";
            dr["CompareToValue"] = "";
            dr["AndOr"] = "";
            dtConditonSeq.Rows.Add(dr);
            BindGridView();
            BindGridView2();
            UpdateSqlCondition();
        }