MARKUS

using KCOMDataModel.Common;

using KCOMDataModel.DataModel;

using System;

using System.Collections.Generic;

using System.IO;

using System.Linq;

using System.Text;

namespace MarkupToPDF.Common

{

    public class GetUserSign

    {

        public string GetSign(string UserID)

        {

            var ModelWFConnectionString = ConnectStringBuilder.ProjectCIConnectString("000000").ToString();

            using (CIEntities entity = new CIEntities(ModelWFConnectionString))

            {

                var _sign = entity.SIGN_INFO.Where(sin => sin.MEMBER_USER_ID == UserID);

                if (_sign.Count() > 0)

                {

                    return _sign.First().SIGN_STR;

                }

                else

                {

                    return null;

                }

            }

        }

    }

}