protected void btnAdd_Click(object sender, EventArgs e)
{
Workflow_NodeOperatorDetailEntity _NodeOperatorDetailEntity = new Workflow_NodeOperatorDetailEntity();
_NodeOperatorDetailEntity.RuleID = 0;
_NodeOperatorDetailEntity.NodeID = DNTRequest.GetInt("id", 0);
_NodeOperatorDetailEntity.RuleType = Convert.ToInt32(ddlOperatorTypeDetail.SelectedValue);
_NodeOperatorDetailEntity.RuleCondition = "(1=1)";
if (rblOperatorType.SelectedValue == "10")
{
_NodeOperatorDetailEntity.ObjectValue = txtObjectValue.Value;
_NodeOperatorDetailEntity.RuleName = txtObjectValueN.Text;
}
else if (rblOperatorType.SelectedValue == "20" || rblOperatorType.SelectedValue == "30" || rblOperatorType.SelectedValue == "50")
{
_NodeOperatorDetailEntity.ObjectValue = ddlObjectValue.SelectedValue;
_NodeOperatorDetailEntity.RuleName = ddlObjectValue.SelectedItem.Text;
}
else if (rblOperatorType.SelectedValue == "40")
{
_NodeOperatorDetailEntity.ObjectValue = "";
_NodeOperatorDetailEntity.RuleName = ddlOperatorTypeDetail.SelectedItem.Text;
}
_NodeOperatorDetailEntity.RuleSeq = txtRuleSeq.Text != "" ? Convert.ToInt32(txtRuleSeq.Text) : 10;
_NodeOperatorDetailEntity.SecurityStart = 0;
_NodeOperatorDetailEntity.SecurityEnd = 100;
_NodeOperatorDetailEntity.LevelStart = txtLevelS.Text != "" ? Convert.ToInt32(txtLevelS.Text) : 5;
_NodeOperatorDetailEntity.LevelEnd = txtLevelE.Text != "" ? Convert.ToInt32(txtLevelE.Text) : 1;
_NodeOperatorDetailEntity.SignType = chkSignType.Checked ? 1 : 0;
DbHelper.GetInstance().AddWorkflow_NodeOperatorDetail(_NodeOperatorDetailEntity);
string NodeID = DNTRequest.GetString("id");
Workflow_FlowNodeEntity _FlowNodeEntity = DbHelper.GetInstance().GetWorkflow_FlowNodeEntityByKeyCol(NodeID);
DbHelper.GetInstance().sp_GeneratorWorkflowCreatorList(_FlowNodeEntity.WorkflowID.ToString());
BindGridView();
}
private Workflow_NodeOperatorDetailEntity GetWorkflow_NodeOperatorDetailFromIDataReader(DbDataReader dr)
{
Workflow_NodeOperatorDetailEntity dt = new Workflow_NodeOperatorDetailEntity();
if (dr.FieldCount > 0)
{
if (dr["RuleID"].ToString() != "" || dr["RuleID"] != null) dt.RuleID = Int32.Parse(dr["RuleID"].ToString());
if (dr["NodeID"].ToString() != "" || dr["NodeID"] != null) dt.NodeID = Int32.Parse(dr["NodeID"].ToString());
if (dr["RuleType"].ToString() != "" || dr["RuleType"] != null) dt.RuleType = Int32.Parse(dr["RuleType"].ToString());
dt.RuleCondition = dr["RuleCondition"].ToString();
dt.ObjectValue = dr["ObjectValue"].ToString();
dt.RuleName = dr["RuleName"].ToString();
if (dr["RuleSeq"].ToString() != "" || dr["RuleSeq"] != null) dt.RuleSeq = Int32.Parse(dr["RuleSeq"].ToString());
if (dr["SecurityStart"].ToString() != "" || dr["SecurityStart"] != null) dt.SecurityStart = Int32.Parse(dr["SecurityStart"].ToString());
if (dr["SecurityEnd"].ToString() != "" || dr["SecurityEnd"] != null) dt.SecurityEnd = Int32.Parse(dr["SecurityEnd"].ToString());
if (dr["LevelStart"].ToString() != "" || dr["LevelStart"] != null) dt.LevelStart = Int32.Parse(dr["LevelStart"].ToString());
if (dr["LevelEnd"].ToString() != "" || dr["LevelEnd"] != null) dt.LevelEnd = Int32.Parse(dr["LevelEnd"].ToString());
if (dr["SignType"].ToString() != "" || dr["SignType"] != null) dt.SignType = Int32.Parse(dr["SignType"].ToString());
dr.Close();
return dt;
}
dr.Close();
return null;
}
/// <summary>
/// 修改信息
/// </summary>
/// <param name="_Workflow_NodeOperatorDetailEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string UpdateWorkflow_NodeOperatorDetail(Workflow_NodeOperatorDetailEntity _Workflow_NodeOperatorDetailEntity)
{
DbParameter[] pramsUpdate = {
MakeInParam("@RuleID",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.RuleID ),
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.NodeID ),
MakeInParam("@RuleType",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.RuleType ),
MakeInParam("@RuleCondition",(DbType)SqlDbType.VarChar,2000,_Workflow_NodeOperatorDetailEntity.RuleCondition ),
MakeInParam("@ObjectValue",(DbType)SqlDbType.VarChar,2000,_Workflow_NodeOperatorDetailEntity.ObjectValue ),
MakeInParam("@RuleName",(DbType)SqlDbType.VarChar,200,_Workflow_NodeOperatorDetailEntity.RuleName ),
MakeInParam("@RuleSeq",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.RuleSeq ),
MakeInParam("@SecurityStart",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.SecurityStart ),
MakeInParam("@SecurityEnd",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.SecurityEnd ),
MakeInParam("@LevelStart",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.LevelStart ),
MakeInParam("@LevelEnd",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.LevelEnd ),
MakeInParam("@SignType",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.SignType ),
};
StringBuilder sb = new StringBuilder();
sb.Append("Update [dbo].[Workflow_NodeOperatorDetail]");
sb.Append(" set ");
sb.Append(" [NodeID]=@NodeID,");
sb.Append(" [RuleType]=@RuleType,");
sb.Append(" [RuleCondition]=@RuleCondition,");
sb.Append(" [ObjectValue]=@ObjectValue,");
sb.Append(" [RuleName]=@RuleName,");
sb.Append(" [RuleSeq]=@RuleSeq,");
sb.Append(" [SecurityStart]=@SecurityStart,");
sb.Append(" [SecurityEnd]=@SecurityEnd,");
sb.Append(" [LevelStart]=@LevelStart,");
sb.Append(" [LevelEnd]=@LevelEnd,");
sb.Append(" [SignType]=@SignType ");
sb.Append(" where [RuleID]=@RuleID ");
return ExecuteNonQuery(CommandType.Text, sb.ToString(), pramsUpdate).ToString();
}
/// <summary>
/// 新增信息
/// </summary>
/// <param name="_Workflow_NodeOperatorDetailEntity"></param>
/// <returns>返回string "-1"表示该已经存在，否则成功 </returns>
public string AddWorkflow_NodeOperatorDetail(Workflow_NodeOperatorDetailEntity _Workflow_NodeOperatorDetailEntity)
{
DbParameter[] pramsInsert = {
MakeInParam("@NodeID",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.NodeID ),
MakeInParam("@RuleType",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.RuleType ),
MakeInParam("@RuleCondition",(DbType)SqlDbType.VarChar,2000,_Workflow_NodeOperatorDetailEntity.RuleCondition ),
MakeInParam("@ObjectValue",(DbType)SqlDbType.VarChar,2000,_Workflow_NodeOperatorDetailEntity.ObjectValue ),
MakeInParam("@RuleName",(DbType)SqlDbType.VarChar,200,_Workflow_NodeOperatorDetailEntity.RuleName ),
MakeInParam("@RuleSeq",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.RuleSeq ),
MakeInParam("@SecurityStart",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.SecurityStart ),
MakeInParam("@SecurityEnd",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.SecurityEnd ),
MakeInParam("@LevelStart",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.LevelStart ),
MakeInParam("@LevelEnd",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.LevelEnd ),
MakeInParam("@SignType",(DbType)SqlDbType.Int,4,_Workflow_NodeOperatorDetailEntity.SignType ),
};
StringBuilder sb = new StringBuilder();
sb.Append("INSERT INTO [dbo].[Workflow_NodeOperatorDetail]");
sb.Append("(");
sb.Append(" [NodeID]");
sb.Append(",[RuleType]");
sb.Append(",[RuleCondition]");
sb.Append(",[ObjectValue]");
sb.Append(",[RuleName]");
sb.Append(",[RuleSeq]");
sb.Append(",[SecurityStart]");
sb.Append(",[SecurityEnd]");
sb.Append(",[LevelStart]");
sb.Append(",[LevelEnd]");
sb.Append(",[SignType]");
sb.Append(") ");
sb.Append(" VALUES (");
sb.Append("@NodeID,");
sb.Append("@RuleType,");
sb.Append("@RuleCondition,");
sb.Append("@ObjectValue,");
sb.Append("@RuleName,");
sb.Append("@RuleSeq,");
sb.Append("@SecurityStart,");
sb.Append("@SecurityEnd,");
sb.Append("@LevelStart,");
sb.Append("@LevelEnd,");
sb.Append("@SignType )");
sb.Append("select @@identity;");
return ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert).ToString();
}