protected void btnAdd_Click(object sender, EventArgs e) { Workflow_TriggerWFFieldMappingMainEntity _TFM = new Workflow_TriggerWFFieldMappingMainEntity(); _TFM.TriggerID = Convert.ToInt32(DNTRequest.GetString("TriggerID")); _TFM.TargetGroupID = Int32.Parse(rblGroupTo.SelectedValue); _TFM.OPCycleType = Convert.ToByte(ddlOPCycleType.SelectedValue); DbHelper.GetInstance().AddWorkflow_TriggerWFFieldMappingMain(_TFM); BindGridView(); System.Web.UI.ScriptManager.RegisterStartupScript(btnAdd, this.GetType(), "ButtonHideScript", strButtonHideScript, false); }
private Workflow_TriggerWFFieldMappingMainEntity GetWorkflow_TriggerWFFieldMappingMainFromIDataReader(DbDataReader dr) { Workflow_TriggerWFFieldMappingMainEntity dt = new Workflow_TriggerWFFieldMappingMainEntity(); if (dr.FieldCount > 0) { if (dr["MappingID"].ToString() != "" || dr["MappingID"] != null) dt.MappingID = Int32.Parse(dr["MappingID"].ToString()); if (dr["TriggerID"].ToString() != "" || dr["TriggerID"] != null) dt.TriggerID = Int32.Parse(dr["TriggerID"].ToString()); if (dr["TargetGroupID"].ToString() != "" || dr["TargetGroupID"] != null) dt.TargetGroupID = Int32.Parse(dr["TargetGroupID"].ToString()); if (dr["OPCycleType"].ToString() != "" || dr["OPCycleType"] != null) dt.MappingID = Convert.ToByte(dr["OPCycleType"].ToString()); dr.Close(); return dt; } dr.Close(); return null; }
/// <summary> /// 新增信息 /// </summary> /// <param name="_Workflow_TriggerWFFieldMappingMainEntity"></param> /// <returns>返回string "-1"表示该已经存在,否则成功 </returns> public string AddWorkflow_TriggerWFFieldMappingMain(Workflow_TriggerWFFieldMappingMainEntity _Workflow_TriggerWFFieldMappingMainEntity) { //判断该记录是否已经存在 DbParameter[] prams = { MakeInParam("@TriggerID",(DbType)SqlDbType.Int ,4,_Workflow_TriggerWFFieldMappingMainEntity.TriggerID ), MakeInParam("@TargetGroupID",(DbType)SqlDbType.Int,4,_Workflow_TriggerWFFieldMappingMainEntity.TargetGroupID) }; string sql = "select * from Workflow_TriggerWFFieldMappingMain where TriggerID=@TriggerID and TargetGroupID=@TargetGroupID"; if (ExecuteDataset(CommandType.Text, sql, prams).Tables[0].Rows.Count > 0) { return "-1";//该记录已经存在 } else { try { DbParameter[] pramsInsert = { MakeInParam("@TriggerID",(DbType)SqlDbType.Int,4,_Workflow_TriggerWFFieldMappingMainEntity.TriggerID ), MakeInParam("@TargetGroupID",(DbType)SqlDbType.Int,4,_Workflow_TriggerWFFieldMappingMainEntity.TargetGroupID ), MakeInParam("@OPCycleType",(DbType)SqlDbType.TinyInt ,1,_Workflow_TriggerWFFieldMappingMainEntity.OPCycleType ) }; StringBuilder sb = new StringBuilder(); sb.Append("INSERT INTO [dbo].[Workflow_TriggerWFFieldMappingMain]"); sb.Append("("); sb.Append("[TriggerID]"); sb.Append(",[TargetGroupID]"); sb.Append(",[OPCycleType]"); sb.Append(") "); sb.Append(" VALUES ("); sb.Append("@TriggerID,"); sb.Append("@TargetGroupID,"); sb.Append("@OPCycleType"); sb.Append("); "); sb.Append("select @@identity;"); int mappingID = Convert.ToInt32(ExecuteScalar(CommandType.Text, sb.ToString(), pramsInsert)); return mappingID.ToString(); } catch { return "0"; } finally { } } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { if (DNTRequest.GetString("MappingID") != "") { Workflow_TriggerWFFieldMappingMainEntity _TFM = new Workflow_TriggerWFFieldMappingMainEntity(); _TFM = DbHelper.GetInstance().GetWorkflow_TriggerWFFieldMappingMainEntityByKeyCol(DNTRequest.GetString("MappingID")); txtTriggerID.Value = _TFM.TriggerID.ToString(); ddlOPCycleType.SelectedValue = _TFM.OPCycleType.ToString(); //TargetFieldType:主字段,明细字段组 string tableName = @"( select 0 GroupID,GroupName='主字段' union select distinct f.GroupID,GroupName=g.GroupName from Workflow_NodeTriggerWorkflow t inner join Workflow_Base b on t.TriggerWFID=b.WorkflowID inner join Workflow_FormField f on b.FormID=f.FormID inner join Workflow_FormFieldGroup g on f.GroupID=g.GroupID where t.IsCancel=0 and t.TriggerID=" + _TFM.TriggerID + ")T"; rblGroupTo.DataSource = DbHelper.GetInstance().GetDBRecords("GroupID,GroupName", tableName, "1=1", "GroupID"); rblGroupTo.DataValueField = "GroupID"; rblGroupTo.DataTextField = "GroupName"; rblGroupTo.DataBind(); rblGroupTo.SelectedValue = _TFM.TargetGroupID.ToString() ; string tblName1 = @"Workflow_NodeTriggerWorkflow t inner join Workflow_Base b on t.TriggerWFID=b.WorkflowID inner join Workflow_FormField f on b.FormID=f.FormID inner join Workflow_FieldDict d on f.FieldID=d.FieldID"; DataTable dtMailField = DbHelper.GetInstance().GetDBRecords("f.FieldID,f.FieldLabel", tblName1, "t.IsCancel=0 and t.TriggerID=" + _TFM.TriggerID.ToString() + " and f.GroupID=" + _TFM.TargetGroupID.ToString(), "f.DisplayOrder"); ddlFieldIDTo.DataSource = dtMailField; ddlFieldIDTo.DataValueField = "FieldID"; ddlFieldIDTo.DataTextField = "FieldLabel"; ddlFieldIDTo.DataBind(); DataTable dtComputeType = DbHelper.GetInstance().GetDBRecords("ComputeTypeID, ComputeTypeName", "Workflow_ComputeType", "Useflag=1", "DisplayOrder"); lbFunctionType.DataSource = dtComputeType; lbFunctionType.DataValueField = "ComputeTypeID"; lbFunctionType.DataTextField = "ComputeTypeName"; lbFunctionType.DataBind(); //SourceFieldType:主字段,明细字段组 string tableName2 = @"( select 0 GroupID,GroupName='主字段' union select distinct f.GroupID,GroupName=g.GroupName from Workflow_NodeTriggerWorkflow t inner join Workflow_Base b on t.WorkflowID=b.WorkflowID inner join Workflow_FormField f on b.FormID=f.FormID inner join Workflow_FormFieldGroup g on f.GroupID=g.GroupID where t.IsCancel=0 and t.TriggerID=" + _TFM.TriggerID.ToString() + ")T"; rblFieldType.DataSource = DbHelper.GetInstance().GetDBRecords("GroupID,GroupName", tableName2, "1=1", "GroupID"); rblFieldType.DataValueField = "GroupID"; rblFieldType.DataTextField = "GroupName"; rblFieldType.DataBind(); rblFieldType.SelectedIndex = 0; BindSourceFieldList(); ReDisplayFunctionList(); DataTable dtExpression = DbHelper.GetInstance().GetDBRecords("ComputeType,ExpressionValue,ExpressionOrder", "Workflow_NodeTriggerExpression", "ExpressionID=0", "ExpressionOrder"); ViewState["dtExpression"] = dtExpression; BindGridView(); } } }