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();
}
}
}
