Esempio n. 1
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(LPWeb.Model.Company_Web model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Company_Web(");
            strSql.Append("EmailAlertsEnabled,EmailRelayServer,DefaultAlertEmail,EmailInterval,LPCompanyURL,BorrowerURL,BorrowerGreeting,HomePageLogo,LogoForSubPages,HomePageLogoData,SubPageLogoData,EnableEmailAuditTrail,SendEmailViaEWS,EwsUrl,SMTP_Port,AuthReq,AuthEmailAccount,AuthPassword,SMTP_EncryptMethod,EWS_Version,EWS_Domain)");
            strSql.Append(" values (");
            strSql.Append("@EmailAlertsEnabled,@EmailRelayServer,@DefaultAlertEmail,@EmailInterval,@LPCompanyURL,@BorrowerURL,@BorrowerGreeting,@HomePageLogo,@LogoForSubPages,@HomePageLogoData,@SubPageLogoData,@EnableEmailAuditTrail,@SendEmailViaEWS,@EwsUrl,@SMTP_Port,@AuthReq,@AuthEmailAccount,@AuthPassword,@SMTP_EncryptMethod,@EWS_Version,@EWS_Domain)");
            SqlParameter[] parameters =
            {
                new SqlParameter("@EmailAlertsEnabled",    SqlDbType.Bit,         1),
                new SqlParameter("@EmailRelayServer",      SqlDbType.NVarChar,  255),
                new SqlParameter("@DefaultAlertEmail",     SqlDbType.NVarChar,  255),
                new SqlParameter("@EmailInterval",         SqlDbType.SmallInt,    2),
                new SqlParameter("@LPCompanyURL",          SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerURL",           SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerGreeting",      SqlDbType.NVarChar,  255),
                new SqlParameter("@HomePageLogo",          SqlDbType.NVarChar),
                new SqlParameter("@LogoForSubPages",       SqlDbType.NVarChar),
                new SqlParameter("@HomePageLogoData",      SqlDbType.Image),
                new SqlParameter("@SubPageLogoData",       SqlDbType.Image),
                new SqlParameter("@EnableEmailAuditTrail", SqlDbType.Bit),
                new SqlParameter("@SendEmailViaEWS",       SqlDbType.Bit,         1),
                new SqlParameter("@EwsUrl",                SqlDbType.NVarChar,  255),
                new SqlParameter("@SMTP_Port",             SqlDbType.Int),
                new SqlParameter("@AuthReq",               SqlDbType.Bit,         1),
                new SqlParameter("@AuthEmailAccount",      SqlDbType.NVarChar,  255),
                new SqlParameter("@AuthPassword",          SqlDbType.NVarChar,  255),
                new SqlParameter("@SMTP_EncryptMethod",    SqlDbType.NVarChar,  255),
                new SqlParameter("@EWS_Version",           SqlDbType.NVarChar,  255),
                new SqlParameter("@EWS_Domain",            SqlDbType.NVarChar, 255)
            };
            parameters[0].Value  = model.EmailAlertsEnabled;
            parameters[1].Value  = model.EmailRelayServer;
            parameters[2].Value  = model.DefaultAlertEmail;
            parameters[3].Value  = model.EmailInterval;
            parameters[4].Value  = model.LPCompanyURL;
            parameters[5].Value  = model.BorrowerURL;
            parameters[6].Value  = model.BorrowerGreeting;
            parameters[7].Value  = model.HomePageLogo;
            parameters[8].Value  = model.LogoForSubPages;
            parameters[9].Value  = model.HomePageLogoData;
            parameters[10].Value = model.SubPageLogoData;
            parameters[11].Value = model.EnableEmailAuditTrail;
            parameters[12].Value = model.SendEmailViaEWS;
            parameters[13].Value = model.EwsUrl;
            parameters[14].Value = model.SMTP_Port;
            parameters[15].Value = model.AuthReq;
            parameters[16].Value = model.AuthEmailAccount;
            parameters[17].Value = model.AuthPassword;
            parameters[18].Value = model.SMTP_EncryptMethod;
            parameters[19].Value = model.EWS_Version;
            parameters[20].Value = model.EWS_Domain;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
Esempio n. 2
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public LPWeb.Model.Company_Web GetModel()
        {
            //该表无主键信息,请自定义主键/条件字段
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 EmailAlertsEnabled,EmailRelayServer,DefaultAlertEmail,EmailInterval,LPCompanyURL,BorrowerURL,BorrowerGreeting,HomePageLogo,LogoForSubPages,HomePageLogoData,SubPageLogoData from Company_Web ");
            //strSql.Append(" where ");
            SqlParameter[] parameters =
            {
            };

            LPWeb.Model.Company_Web model = new LPWeb.Model.Company_Web();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["EmailAlertsEnabled"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["EmailAlertsEnabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["EmailAlertsEnabled"].ToString().ToLower() == "true"))
                    {
                        model.EmailAlertsEnabled = true;
                    }
                    else
                    {
                        model.EmailAlertsEnabled = false;
                    }
                }
                model.EmailRelayServer  = ds.Tables[0].Rows[0]["EmailRelayServer"].ToString();
                model.DefaultAlertEmail = ds.Tables[0].Rows[0]["DefaultAlertEmail"].ToString();
                if (ds.Tables[0].Rows[0]["EmailInterval"].ToString() != "")
                {
                    model.EmailInterval = int.Parse(ds.Tables[0].Rows[0]["EmailInterval"].ToString());
                }
                model.LPCompanyURL     = ds.Tables[0].Rows[0]["LPCompanyURL"].ToString();
                model.BorrowerURL      = ds.Tables[0].Rows[0]["BorrowerURL"].ToString();
                model.BorrowerGreeting = ds.Tables[0].Rows[0]["BorrowerGreeting"].ToString();
                model.HomePageLogo     = ds.Tables[0].Rows[0]["HomePageLogo"].ToString();
                model.LogoForSubPages  = ds.Tables[0].Rows[0]["LogoForSubPages"].ToString();
                if (ds.Tables[0].Rows[0]["HomePageLogoData"].ToString() != "")
                {
                    model.HomePageLogoData = (byte[])ds.Tables[0].Rows[0]["HomePageLogoData"];
                }
                if (ds.Tables[0].Rows[0]["SubPageLogoData"].ToString() != "")
                {
                    model.SubPageLogoData = (byte[])ds.Tables[0].Rows[0]["SubPageLogoData"];
                }
                return(model);
            }
            else
            {
                return(null);
            }
        }
Esempio n. 3
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(LPWeb.Model.Company_Web model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Company_Web set ");
            strSql.Append("EmailAlertsEnabled=@EmailAlertsEnabled,");
            strSql.Append("EmailRelayServer=@EmailRelayServer,");
            strSql.Append("DefaultAlertEmail=@DefaultAlertEmail,");
            strSql.Append("EmailInterval=@EmailInterval,");
            strSql.Append("LPCompanyURL=@LPCompanyURL,");
            strSql.Append("BorrowerURL=@BorrowerURL,");
            strSql.Append("BorrowerGreeting=@BorrowerGreeting,");
            strSql.Append("HomePageLogo=@HomePageLogo,");
            strSql.Append("LogoForSubPages=@LogoForSubPages,");
            strSql.Append("HomePageLogoData=@HomePageLogoData,");
            strSql.Append("SubPageLogoData=@SubPageLogoData");
            //strSql.Append(" where ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@EmailAlertsEnabled", SqlDbType.Bit,         1),
                new SqlParameter("@EmailRelayServer",   SqlDbType.NVarChar,  255),
                new SqlParameter("@DefaultAlertEmail",  SqlDbType.NVarChar,  255),
                new SqlParameter("@EmailInterval",      SqlDbType.SmallInt,    2),
                new SqlParameter("@LPCompanyURL",       SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerURL",        SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerGreeting",   SqlDbType.NVarChar,  255),
                new SqlParameter("@HomePageLogo",       SqlDbType.NVarChar),
                new SqlParameter("@LogoForSubPages",    SqlDbType.NVarChar),
                new SqlParameter("@HomePageLogoData",   SqlDbType.Image),
                new SqlParameter("@SubPageLogoData",    SqlDbType.Image)
            };
            parameters[0].Value  = model.EmailAlertsEnabled;
            parameters[1].Value  = model.EmailRelayServer;
            parameters[2].Value  = model.DefaultAlertEmail;
            parameters[3].Value  = model.EmailInterval;
            parameters[4].Value  = model.LPCompanyURL;
            parameters[5].Value  = model.BorrowerURL;
            parameters[6].Value  = model.BorrowerGreeting;
            parameters[7].Value  = model.HomePageLogo;
            parameters[8].Value  = model.LogoForSubPages;
            parameters[9].Value  = model.HomePageLogoData;
            parameters[10].Value = model.SubPageLogoData;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
Esempio n. 4
0
        /// <summary>
        /// 增加一条数据
        /// </summary>
        public void Add(LPWeb.Model.Company_Web model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("insert into Company_Web(");
            strSql.Append("EmailAlertsEnabled,EmailRelayServer,DefaultAlertEmail,EmailInterval,LPCompanyURL,BorrowerURL,BorrowerGreeting,HomePageLogo,LogoForSubPages,HomePageLogoData,SubPageLogoData)");
            strSql.Append(" values (");
            strSql.Append("@EmailAlertsEnabled,@EmailRelayServer,@DefaultAlertEmail,@EmailInterval,@LPCompanyURL,@BorrowerURL,@BorrowerGreeting,@HomePageLogo,@LogoForSubPages,@HomePageLogoData,@SubPageLogoData)");
            SqlParameter[] parameters =
            {
                new SqlParameter("@EmailAlertsEnabled", SqlDbType.Bit,         1),
                new SqlParameter("@EmailRelayServer",   SqlDbType.NVarChar,  255),
                new SqlParameter("@DefaultAlertEmail",  SqlDbType.NVarChar,  255),
                new SqlParameter("@EmailInterval",      SqlDbType.SmallInt,    2),
                new SqlParameter("@LPCompanyURL",       SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerURL",        SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerGreeting",   SqlDbType.NVarChar,  255),
                new SqlParameter("@HomePageLogo",       SqlDbType.NVarChar),
                new SqlParameter("@LogoForSubPages",    SqlDbType.NVarChar),
                new SqlParameter("@HomePageLogoData",   SqlDbType.Image),
                new SqlParameter("@SubPageLogoData",    SqlDbType.Image)
            };
            parameters[0].Value  = model.EmailAlertsEnabled;
            parameters[1].Value  = model.EmailRelayServer;
            parameters[2].Value  = model.DefaultAlertEmail;
            parameters[3].Value  = model.EmailInterval;
            parameters[4].Value  = model.LPCompanyURL;
            parameters[5].Value  = model.BorrowerURL;
            parameters[6].Value  = model.BorrowerGreeting;
            parameters[7].Value  = model.HomePageLogo;
            parameters[8].Value  = model.LogoForSubPages;
            parameters[9].Value  = model.HomePageLogoData;
            parameters[10].Value = model.SubPageLogoData;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
Esempio n. 5
0
        /// <summary>
        /// 更新一条数据
        /// </summary>
        public void Update(LPWeb.Model.Company_Web model)
        {
            StringBuilder strSql = new StringBuilder();

            strSql.Append("update Company_Web set ");
            strSql.Append("EmailAlertsEnabled=@EmailAlertsEnabled,");
            strSql.Append("EmailRelayServer=@EmailRelayServer,");
            strSql.Append("DefaultAlertEmail=@DefaultAlertEmail,");
            strSql.Append("EmailInterval=@EmailInterval,");
            strSql.Append("LPCompanyURL=@LPCompanyURL,");
            strSql.Append("BorrowerURL=@BorrowerURL,");
            strSql.Append("BorrowerGreeting=@BorrowerGreeting,");
            strSql.Append("HomePageLogo=@HomePageLogo,");
            strSql.Append("LogoForSubPages=@LogoForSubPages,");
            strSql.Append("HomePageLogoData=@HomePageLogoData,");
            strSql.Append("SubPageLogoData=@SubPageLogoData,");
            strSql.Append("EnableEmailAuditTrail=@EnableEmailAuditTrail,");
            strSql.Append("SendEmailViaEWS=@SendEmailViaEWS,");
            strSql.Append("EwsUrl=@EwsUrl,");
            strSql.Append("SMTP_Port=@SMTP_Port,");
            strSql.Append("AuthReq =@AuthReq,");
            strSql.Append("AuthEmailAccount =@AuthEmailAccount,");
            strSql.Append("AuthPassword =@AuthPassword,");
            strSql.Append("SMTP_EncryptMethod=@SMTP_EncryptMethod,");
            strSql.Append("EWS_Version=@EWS_Version,");
            strSql.Append("EWS_Domain=@EWS_Domain");
            //strSql.Append(" where ");
            SqlParameter[] parameters =
            {
                new SqlParameter("@EmailAlertsEnabled",    SqlDbType.Bit,         1),
                new SqlParameter("@EmailRelayServer",      SqlDbType.NVarChar,  255),
                new SqlParameter("@DefaultAlertEmail",     SqlDbType.NVarChar,  255),
                new SqlParameter("@EmailInterval",         SqlDbType.SmallInt,    2),
                new SqlParameter("@LPCompanyURL",          SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerURL",           SqlDbType.NVarChar,  255),
                new SqlParameter("@BorrowerGreeting",      SqlDbType.NVarChar,  255),
                new SqlParameter("@HomePageLogo",          SqlDbType.NVarChar),
                new SqlParameter("@LogoForSubPages",       SqlDbType.NVarChar),
                new SqlParameter("@HomePageLogoData",      SqlDbType.Image),
                new SqlParameter("@SubPageLogoData",       SqlDbType.Image),
                new SqlParameter("@EnableEmailAuditTrail", SqlDbType.Bit),
                new SqlParameter("@SendEmailViaEWS",       SqlDbType.Bit,         1),
                new SqlParameter("@EwsUrl",                SqlDbType.NVarChar,  255),
                new SqlParameter("@SMTP_Port",             SqlDbType.Int),
                new SqlParameter("@AuthReq",               SqlDbType.Bit,         1),
                new SqlParameter("@AuthEmailAccount",      SqlDbType.NVarChar,  255),
                new SqlParameter("@AuthPassword",          SqlDbType.NVarChar,  255),
                new SqlParameter("@SMTP_EncryptMethod",    SqlDbType.NVarChar,  255),
                new SqlParameter("@EWS_Version",           SqlDbType.NVarChar,  255),
                new SqlParameter("@EWS_Domain",            SqlDbType.NVarChar, 255)
            };
            parameters[0].Value  = model.EmailAlertsEnabled;
            parameters[1].Value  = model.EmailRelayServer;
            parameters[2].Value  = model.DefaultAlertEmail;
            parameters[3].Value  = model.EmailInterval;
            parameters[4].Value  = model.LPCompanyURL;
            parameters[5].Value  = model.BorrowerURL;
            parameters[6].Value  = model.BorrowerGreeting;
            parameters[7].Value  = model.HomePageLogo;
            parameters[8].Value  = model.LogoForSubPages;
            parameters[9].Value  = model.HomePageLogoData;
            parameters[10].Value = model.SubPageLogoData;
            parameters[11].Value = model.EnableEmailAuditTrail;
            parameters[12].Value = model.SendEmailViaEWS;
            parameters[13].Value = model.EwsUrl;
            parameters[14].Value = model.SMTP_Port;
            parameters[15].Value = model.AuthReq;
            parameters[16].Value = model.AuthEmailAccount;
            parameters[17].Value = model.AuthPassword;
            parameters[18].Value = model.SMTP_EncryptMethod;
            parameters[19].Value = model.EWS_Version;
            parameters[20].Value = model.EWS_Domain;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
Esempio n. 6
0
        /// <summary>
        /// 得到一个对象实体
        /// </summary>
        public LPWeb.Model.Company_Web GetModel()
        {
            //该表无主键信息,请自定义主键/条件字段
            StringBuilder strSql = new StringBuilder();

            strSql.Append("select  top 1 * from Company_Web ");
            //strSql.Append(" where ");
            SqlParameter[] parameters =
            {
            };

            LPWeb.Model.Company_Web model = new LPWeb.Model.Company_Web();
            DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);

            if (ds.Tables[0].Rows.Count > 0)
            {
                if (ds.Tables[0].Rows[0]["EmailAlertsEnabled"].ToString() != "")
                {
                    if ((ds.Tables[0].Rows[0]["EmailAlertsEnabled"].ToString() == "1") || (ds.Tables[0].Rows[0]["EmailAlertsEnabled"].ToString().ToLower() == "true"))
                    {
                        model.EmailAlertsEnabled = true;
                    }
                    else
                    {
                        model.EmailAlertsEnabled = false;
                    }
                }
                model.EmailRelayServer  = ds.Tables[0].Rows[0]["EmailRelayServer"].ToString();
                model.DefaultAlertEmail = ds.Tables[0].Rows[0]["DefaultAlertEmail"].ToString();
                if (ds.Tables[0].Rows[0]["EmailInterval"].ToString() != "")
                {
                    model.EmailInterval = int.Parse(ds.Tables[0].Rows[0]["EmailInterval"].ToString());
                }
                model.LPCompanyURL     = ds.Tables[0].Rows[0]["LPCompanyURL"].ToString();
                model.BorrowerURL      = ds.Tables[0].Rows[0]["BorrowerURL"].ToString();
                model.BorrowerGreeting = ds.Tables[0].Rows[0]["BorrowerGreeting"].ToString();
                model.HomePageLogo     = ds.Tables[0].Rows[0]["HomePageLogo"].ToString();
                model.LogoForSubPages  = ds.Tables[0].Rows[0]["LogoForSubPages"].ToString();
                if (ds.Tables[0].Rows[0]["HomePageLogoData"].ToString() != "")
                {
                    model.HomePageLogoData = (byte[])ds.Tables[0].Rows[0]["HomePageLogoData"];
                }
                if (ds.Tables[0].Rows[0]["SubPageLogoData"].ToString() != "")
                {
                    model.SubPageLogoData = (byte[])ds.Tables[0].Rows[0]["SubPageLogoData"];
                }
                model.BackgroundLoanAlertPage = ds.Tables[0].Rows[0]["BackgroundLoanAlertPage"].ToString();
                if (ds.Tables[0].Rows[0]["EnableEmailAuditTrail"] == DBNull.Value)
                {
                    model.EnableEmailAuditTrail = false;
                }
                else
                {
                    if (ds.Tables[0].Rows[0]["EnableEmailAuditTrail"].ToString() == "True")
                    {
                        model.EnableEmailAuditTrail = true;
                    }
                    else
                    {
                        model.EnableEmailAuditTrail = false;
                    }
                }

                model.BackgroundWCFURL = ds.Tables[0].Rows[0]["BackgroundWCFURL"].ToString();

                if (ds.Tables[0].Rows[0]["SendEmailViaEWS"] == DBNull.Value)
                {
                    model.SendEmailViaEWS = false;
                }
                else
                {
                    if (ds.Tables[0].Rows[0]["SendEmailViaEWS"].ToString() == "True")
                    {
                        model.SendEmailViaEWS = true;
                    }
                    else
                    {
                        model.SendEmailViaEWS = false;
                    }
                }

                model.EwsUrl = ds.Tables[0].Rows[0]["EwsUrl"].ToString();


                model.SMTP_Port = ds.Tables[0].Rows[0]["SMTP_Port"] != DBNull.Value ? Convert.ToInt32(ds.Tables[0].Rows[0]["SMTP_Port"]) : 25;

                model.AuthReq = ds.Tables[0].Rows[0]["AuthReq"] != DBNull.Value ? Convert.ToBoolean(ds.Tables[0].Rows[0]["AuthReq"]) : false;

                model.AuthEmailAccount = ds.Tables[0].Rows[0]["AuthEmailAccount"] != DBNull.Value ? ds.Tables[0].Rows[0]["AuthEmailAccount"].ToString() : "";

                model.AuthPassword = ds.Tables[0].Rows[0]["AuthPassword"] != DBNull.Value ? ds.Tables[0].Rows[0]["AuthPassword"].ToString() : "";

                model.SMTP_EncryptMethod = ds.Tables[0].Rows[0]["SMTP_EncryptMethod"] != DBNull.Value ? ds.Tables[0].Rows[0]["SMTP_EncryptMethod"].ToString() : "";

                model.EWS_Version = ds.Tables[0].Rows[0]["EWS_Version"] != DBNull.Value ? ds.Tables[0].Rows[0]["EWS_Version"].ToString() : "";
                model.EWS_Domain  = ds.Tables[0].Rows[0]["EWS_Domain"] != DBNull.Value ? ds.Tables[0].Rows[0]["EWS_Domain"].ToString() : "";
                return(model);
            }
            else
            {
                return(null);
            }
        }