Òä·çµÄ²©¿Í

Àý£º

using System;
using System.Collections;
using System.Workflow.ComponentModel.Compiler;
using System.Workflow.ComponentModel.Serialization;
using System.Workflow.ComponentModel;
using System.Workflow.ComponentModel.Design;
using System.Workflow.Runtime;
using System.Workflow.Activities;
using System.Workflow.Activities.Rules;
using System.Reflection;

using Microsoft.Crm.Workflow;
using Microsoft.Crm.Sdk;
using Microsoft.Crm.SdkTypeProxy;
using Microsoft.Crm.Sdk.Query;

using System.Data.SqlClient;

namespace zz_zywqjActivityLibrary
{
    [CrmWorkflowActivity("»ñÈ¡µ±Ç°ÒµÎñÆÚ¼ä", "×Ô¶¨Ò幤×÷Á÷³Ì")]
    public partial class huoqueywqj : Activity
 {
        protected override ActivityExecutionStatus Execute(ActivityExecutionContext executionContext)
        {
            try
            {
                SqlConnection conn = new SqlConnection(clsCn.GetCnCrm());
                conn.Open();
                SqlCommand cmd = new SqlCommand("select zz_zywqjid,zz_name from zz_zywqj where Zz_ywlx="+clsCn.GetPackListValue("zz_zywqj","zz_ywlx",ÒµÎñÀàÐÍ)+" and Zz_sfdqqj=1",conn);
                SqlDataReader dr = cmd.ExecuteReader();
                if (dr.Read())
                {
                    string csid = dr["zz_zywqjid"].ToString();
                    ywqj = new Lookup("zz_zywqj", new Guid(csid));
                    string tyw=dr["zz_name"].ToString();
                    ÒµÎñÆÚ¼ä = tyw;
                }
                conn.Close();
            }
            catch
            {
            }
            return base.Execute(executionContext);
        }

        public static DependencyProperty ÒµÎñÀàÐÍProperty =
           DependencyProperty.Register("ÒµÎñÀàÐÍ",
           typeof(String),
           typeof(huoqueywqj));

        [CrmInput("ÒµÎñÀàÐÍ")]
        public String ÒµÎñÀàÐÍ
        {
            get
            {
                return (String)base.GetValue(ÒµÎñÀàÐÍProperty);
            }
            set
            {
                base.SetValue(ÒµÎñÀàÐÍProperty, value);
            }

        }

        public static DependencyProperty ywqjProperty =
            DependencyProperty.Register("ywqj",
            typeof(Lookup),
            typeof(huoqueywqj));

        [CrmOutput("ywqj")]
        [CrmReferenceTarget("zz_zywqj")]
        public Lookup ywqj
        {
            get
            {
                return (Lookup)base.GetValue(ywqjProperty);
            }
            set
            {
                base.SetValue(ywqjProperty, value);
            }
        }

        public static DependencyProperty ÒµÎñÆÚ¼äProperty =
            DependencyProperty.Register("ÒµÎñÆÚ¼ä",
            typeof(String),
            typeof(huoqueywqj));

        [CrmOutput("ÒµÎñÆÚ¼ä")]
        public String ÒµÎñÆÚ¼ä
        {
            get
            {
                return (String)base.GetValue(ÒµÎñÆÚ¼äProperty);
            }
            set
            {
                base.SetValue(ÒµÎñÆÚ¼äProperty, value);
            }
        }
 }
}