コード例 #1
0
ファイル: MailSettings.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SystemInfo.MailSettings model)
        {
            StringBuilder strSql = new StringBuilder();
            //strSql.Append("DECLARE @Sequence int");
            //strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_mailsettings]");
            //strSql.Append(" if @Sequence is NULL");
            //strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_mailsettings](");
            strSql.Append("[SmtpServerIP],[SmtpServerPort],[MailId],[MailPassword]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@smtpserverip,@smtpserverport,@mailid,@mailpassword");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@smtpserverip", SqlDbType.VarChar,50),
					new SqlParameter("@smtpserverport", SqlDbType.Int,4),
					new SqlParameter("@mailid", SqlDbType.VarChar,100),
					new SqlParameter("@mailpassword", SqlDbType.VarChar,50)};
            parameters[0].Value = model.SmtpServerIP;
            parameters[1].Value = model.SmtpServerPort;
            parameters[2].Value = model.MailId;
            parameters[3].Value = model.MailPassword;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #2
0
ファイル: MailSettings.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Add or update one record
 /// </summary>
 public void AddOrUpdate(Johnny.CMS.OM.SystemInfo.MailSettings model)
 {
     if (!dal.IsExist(1))
         dal.Add(model);
     else
         dal.Update(model);
 }
コード例 #3
0
ファイル: Channel.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SeH.Channel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [seh_channel]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [seh_channel](");
            strSql.Append("[ChannelName],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@channelname,@Sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@channelname", SqlDbType.NVarChar,50)};
            parameters[0].Value = model.ChannelName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #4
0
ファイル: UtilityHelper.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Creates the GetXxx method to use for the specified column.
 /// </summary>
 /// <param name="column">The column to retrieve data for.</param>
 /// <returns>The name of the method to call on a SqlDataReader for the specified column.</returns>
 internal static string GetXxxMethod(Johnny.CodeGenerator.Core.ColumnInfo column)
 {
     switch (column.DataType.ToLower())
     {
         case "binary":
             return "GetBytes";
         case "bigint":
             return "GetInt64";
         case "bit":
             return "GetBoolean";
         case "char":
             return "GetString";
         case "datetime":
             return "GetDateTime";
         case "decimal":
             return "GetDecimal";
         case "float":
             return "GetFloat";
         case "image":
             return "GetBytes";
         case "int":
             return "GetInt32";
         case "money":
             return "GetDecimal";
         case "nchar":
             return "GetString";
         case "ntext":
             return "GetString";
         case "nvarchar":
             return "GetString";
         case "numeric":
             return "GetDecimal";
         case "real":
             return "GetDecimal";
         case "smalldatetime":
             return "GetDateTime";
         case "smallint":
             return "GetIn16";
         case "smallmoney":
             return "GetFloat";
         case "sql_variant":
             return "GetBytes";
         case "sysname":
             return "GetString";
         case "text":
             return "GetString";
         case "timestamp":
             return "GetDateTime";
         case "tinyint":
             return "GetByte";
         case "varbinary":
             return "GetBytes";
         case "varchar":
             return "GetString";
         case "uniqueidentifier":
             return "GetGuid";
         default:  // Unknow data type
             throw (new Exception("Invalid SQL Server data type specified: " + column.DataType));
     }
 }
コード例 #5
0
ファイル: Navigator.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SystemInfo.Navigator model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_navigator]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_navigator](");
            strSql.Append("[NavigatorId],[NavigatorName],[Url],[ParentId]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@navigatorid,@navigatorname,@url,@parentid");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@navigatorid", SqlDbType.Int,4),
					new SqlParameter("@navigatorname", SqlDbType.NVarChar,50),
					new SqlParameter("@url", SqlDbType.VarChar,200),
					new SqlParameter("@parentid", SqlDbType.Int,4)};
            parameters[-1].Value = model.NavigatorId;
            parameters[0].Value = model.NavigatorName;
            parameters[1].Value = model.Url;
            parameters[2].Value = model.ParentId;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #6
0
ファイル: Role.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.Access.Role model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_role]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_role](");
            strSql.Append("[RoleName],[Description],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@rolename,@description,@Sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@rolename", SqlDbType.NVarChar,50),
					new SqlParameter("@description", SqlDbType.NVarChar,200)};
            parameters[0].Value = model.RoleName;
            parameters[1].Value = model.Description;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #7
0
ファイル: AdminRole.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.Access.AdminRole model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_adminrole]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_adminrole](");
            strSql.Append("[AdminId],[RoleId],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@adminid,@roleid,@Sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@adminid", SqlDbType.Int,4),
					new SqlParameter("@roleid", SqlDbType.Int,4)};
            parameters[0].Value = model.AdminId;
            parameters[1].Value = model.RoleId;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #8
0
ファイル: PageBinding.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SystemInfo.PageBinding model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_pagebinding]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_pagebinding](");
            strSql.Append("[Title],[MenuCategoryId],[ListMenuId],[AddMenuId]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@title,@menucategoryid,@listmenuid,@addmenuid");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@title", SqlDbType.NVarChar,50),
					new SqlParameter("@menucategoryid", SqlDbType.Int,4),
					new SqlParameter("@listmenuid", SqlDbType.Int,4),
					new SqlParameter("@addmenuid", SqlDbType.Int,4)};
            parameters[0].Value = model.Title;
            parameters[1].Value = model.MenuCategoryId;
            parameters[2].Value = model.ListMenuId;
            parameters[3].Value = model.AddMenuId;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #9
0
ファイル: TopMenu.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SystemInfo.TopMenu model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_topmenu]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_topmenu](");
            strSql.Append("[TopMenuName],[toolTip],[PageLink],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@topmenuname,@toolTip,@pagelink,@Sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@topmenuname", SqlDbType.NVarChar,50),
					new SqlParameter("@toolTip", SqlDbType.NVarChar,50),
					new SqlParameter("@pagelink", SqlDbType.VarChar,100)};
            parameters[0].Value = model.TopMenuName;
            parameters[1].Value = model.ToolTip;
            parameters[2].Value = model.PageLink;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #10
0
ファイル: Administrator.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.Access.Administrator model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_administrator]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_administrator](");
            strSql.Append("[AdminName],[Password],[FullName],[Gender],[Tel],[Email],[ValidFrom],[ValidTo],[IsActivated],[LoginTimes],[CreatedTime],[CreatedById],[CreatedByName],[UpdatedTime],[UpdatedById],[UpdatedByName],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@adminname,@password,@fullname,@gender,@tel,@email,@validfrom,@validto,@isactivated,@logintimes,@createdtime,@createdbyid,@createdbyname,@updatedtime,@updatedbyid,@updatedbyname,@sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@adminname", SqlDbType.VarChar,50),
					new SqlParameter("@password", SqlDbType.VarChar,32),
					new SqlParameter("@fullname", SqlDbType.NVarChar,50),
					new SqlParameter("@gender", SqlDbType.Bit),
					new SqlParameter("@tel", SqlDbType.VarChar,50),
					new SqlParameter("@email", SqlDbType.VarChar,50),
					new SqlParameter("@validfrom", SqlDbType.DateTime),
					new SqlParameter("@validto", SqlDbType.DateTime),
					new SqlParameter("@isactivated", SqlDbType.Bit),
					new SqlParameter("@logintimes", SqlDbType.Int,4),
					new SqlParameter("@createdtime", SqlDbType.DateTime),
					new SqlParameter("@createdbyid", SqlDbType.Int,4),
					new SqlParameter("@createdbyname", SqlDbType.VarChar,50),
					new SqlParameter("@updatedtime", SqlDbType.DateTime),
					new SqlParameter("@updatedbyid", SqlDbType.Int,4),
					new SqlParameter("@updatedbyname", SqlDbType.VarChar,50)};
            parameters[0].Value = model.AdminName;
            parameters[1].Value = model.Password;
            parameters[2].Value = model.FullName;
            parameters[3].Value = model.Gender;
            parameters[4].Value = model.Tel;
            parameters[5].Value = model.Email;
            parameters[6].Value = model.ValidFrom;
            parameters[7].Value = model.ValidTo;
            parameters[8].Value = model.IsActivated;
            parameters[9].Value = model.LoginTimes;
            parameters[10].Value = model.CreatedTime;
            parameters[11].Value = model.CreatedById;
            parameters[12].Value = model.CreatedByName;
            parameters[13].Value = model.UpdatedTime;
            parameters[14].Value = model.UpdatedById;
            parameters[15].Value = model.UpdatedByName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #11
0
ファイル: WebSettings.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SystemInfo.WebSettings model)
        {
            StringBuilder strSql = new StringBuilder();           
            strSql.Append("INSERT INTO [cms_websettings](");
            strSql.Append("[WebsiteName],[WebsiteTitle],[ShortDescription],[Tel],[Fax],[Email],[WebsiteAddress],[WebsitePath],[FileSize],[LogoPath],[BannerPath],[Copyright],[MetaKeywords],[MetaDescription],[IsClosed],[ClosedInfo],[UserAgreement],[LoginType]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@websitename,@websitetitle,@shortdescription,@tel,@fax,@email,@websiteaddress,@websitepath,@filesize,@logopath,@bannerpath,@copyright,@metakeywords,@metadescription,@isclosed,@closedinfo,@useragreement,@logintype");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@websitename", SqlDbType.NVarChar,40),
					new SqlParameter("@websitetitle", SqlDbType.NVarChar,100),
                    new SqlParameter("@shortdescription", SqlDbType.VarChar,500),
					new SqlParameter("@tel", SqlDbType.VarChar,50),
					new SqlParameter("@fax", SqlDbType.VarChar,50),
					new SqlParameter("@email", SqlDbType.VarChar,50),
					new SqlParameter("@websiteaddress", SqlDbType.VarChar,200),
					new SqlParameter("@websitepath", SqlDbType.VarChar,50),
					new SqlParameter("@filesize", SqlDbType.Int,4),
					new SqlParameter("@logopath", SqlDbType.VarChar,100),
					new SqlParameter("@bannerpath", SqlDbType.VarChar,100),
					new SqlParameter("@copyright", SqlDbType.NVarChar,500),
					new SqlParameter("@metakeywords", SqlDbType.NVarChar,100),
					new SqlParameter("@metadescription", SqlDbType.NVarChar,400),
					new SqlParameter("@isclosed", SqlDbType.Bit),
					new SqlParameter("@closedinfo", SqlDbType.NVarChar,1000),
					new SqlParameter("@useragreement", SqlDbType.Text),
					new SqlParameter("@logintype", SqlDbType.Int,4)};
            parameters[0].Value = model.WebsiteName;
            parameters[1].Value = model.WebsiteTitle;
            parameters[2].Value = model.ShortDescription;
            parameters[3].Value = model.Tel;
            parameters[4].Value = model.Fax;
            parameters[5].Value = model.Email;
            parameters[6].Value = model.WebsiteAddress;
            parameters[7].Value = model.WebsitePath;
            parameters[8].Value = model.FileSize;
            parameters[9].Value = model.LogoPath;
            parameters[10].Value = model.BannerPath;
            parameters[11].Value = model.Copyright;
            parameters[12].Value = model.MetaKeywords;
            parameters[13].Value = model.MetaDescription;
            parameters[14].Value = model.IsClosed;
            parameters[15].Value = model.ClosedInfo;
            parameters[16].Value = model.UserAgreement;
            parameters[17].Value = model.LoginType;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #12
0
ファイル: Blog.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SeH.Blog model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [seh_blog]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [seh_blog](");
            strSql.Append("[Title],[BlogCategoryId],[Tag],[Content],[Hits],[IsDisplay],[CreatedTime],[CreatedById],[CreatedByName],[UpdatedTime],[UpdatedById],[UpdatedByName],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@title,@blogcategoryid,@tag,@content,@hits,@isdisplay,@createdtime,@createdbyid,@createdbyname,@updatedtime,@updatedbyid,@updatedbyname,@sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@title", SqlDbType.NVarChar,255),
					new SqlParameter("@blogcategoryid", SqlDbType.Int,4),
					new SqlParameter("@tag", SqlDbType.VarChar,100),
					new SqlParameter("@content", SqlDbType.Text),
					new SqlParameter("@hits", SqlDbType.Int,4),
					new SqlParameter("@isdisplay", SqlDbType.Bit),
					new SqlParameter("@createdtime", SqlDbType.DateTime),
					new SqlParameter("@createdbyid", SqlDbType.Int,4),
					new SqlParameter("@createdbyname", SqlDbType.VarChar,50),
					new SqlParameter("@updatedtime", SqlDbType.DateTime),
					new SqlParameter("@updatedbyid", SqlDbType.Int,4),
					new SqlParameter("@updatedbyname", SqlDbType.VarChar,50)};
            parameters[0].Value = model.Title;
            parameters[1].Value = model.BlogCategoryId;
            parameters[2].Value = model.Tag;
            parameters[3].Value = model.Content;
            parameters[4].Value = model.Hits;
            parameters[5].Value = model.IsDisplay;
            parameters[6].Value = model.CreatedTime;
            parameters[7].Value = model.CreatedById;
            parameters[8].Value = model.CreatedByName;
            parameters[9].Value = model.UpdatedTime;
            parameters[10].Value = model.UpdatedById;
            parameters[11].Value = model.UpdatedByName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #13
0
ファイル: OpenSource.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SeH.OpenSource model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [seh_OpenSource]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [seh_OpenSource](");
            strSql.Append("[OpenSourceName],[ShortDescription],[Description],[URL],[Hits],[IsDisplay],[CreatedTime],[CreatedById],[CreatedByName],[UpdatedTime],[UpdatedById],[UpdatedByName],[Sequence]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@OpenSourcename,@shortdescription,@description,@url,@hits,@isdisplay,@createdtime,@createdbyid,@createdbyname,@updatedtime,@updatedbyid,@updatedbyname,@sequence");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@OpenSourcename", SqlDbType.NVarChar,50),
					new SqlParameter("@shortdescription", SqlDbType.NVarChar,200),
					new SqlParameter("@description", SqlDbType.Text),
					new SqlParameter("@url", SqlDbType.VarChar,200),
					new SqlParameter("@hits", SqlDbType.Int,4),
					new SqlParameter("@isdisplay", SqlDbType.Bit),
		            new SqlParameter("@createdtime", SqlDbType.DateTime),
					new SqlParameter("@createdbyid", SqlDbType.Int,4),
					new SqlParameter("@createdbyname", SqlDbType.VarChar,50),
					new SqlParameter("@updatedtime", SqlDbType.DateTime),
					new SqlParameter("@updatedbyid", SqlDbType.Int,4),
					new SqlParameter("@updatedbyname", SqlDbType.VarChar,50)};
            parameters[0].Value = model.OpenSourceName;
            parameters[1].Value = model.ShortDescription;
            parameters[2].Value = model.Description;
            parameters[3].Value = model.URL;
            parameters[4].Value = model.Hits;
            parameters[5].Value = model.IsDisplay;
            parameters[6].Value = model.CreatedTime;
            parameters[7].Value = model.CreatedById;
            parameters[8].Value = model.CreatedByName;
            parameters[9].Value = model.UpdatedTime;
            parameters[10].Value = model.UpdatedById;
            parameters[11].Value = model.UpdatedByName;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #14
0
        private void accountTree_AccountNodeSelectedEvent(object sender, Johnny.Kaixin.Controls.AccountTree.AccountEventArgs e)
        {
            try
            {
                //get the top form
                MainForm mainform = this.TopLevelControl as MainForm;
                if (mainform != null)
                    mainform.AccountNodeSelected(e.Account);

            }
            catch (Exception ex)
            {
                Program.ShowMessageBox("FrmAccountManager", ex);
            }
        }
コード例 #15
0
ファイル: FrmTaskManager.cs プロジェクト: jojozhuang/Projects
        private void taskTree_RootNodeSelectedEvent(object sender, Johnny.Kaixin.Controls.TaskTree.RootNodeEventArgs e)
        {
            try
            {
                //get the top form
                MainForm mainform = this.TopLevelControl as MainForm;
                if (mainform != null)
                    mainform.RootNodeSelected(e.Tasks);

            }
            catch (Exception ex)
            {
                Program.ShowMessageBox("FrmTaskManager", ex);
            }
        }
コード例 #16
0
        private void AnalyzeNode(SyntaxNodeAnalysisContext context)
        {
            var fss = (ForStatementSyntax)context.Node;

            var sem = context.SemanticModel;

            if (fss != null && fss.Declaration != null && sem != null)
            {
                var variables = fss.Declaration.Variables;

                if (variables != null)
                {
                    var symbols = new HashSet <ISymbol>(variables.Select(variable => sem.GetDeclaredSymbol(variable)));
                    var johnny  = new Johnny(context, sem, symbols);
                    johnny.Visit(fss.Statement);
                }
            }
        }
コード例 #17
0
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.SystemInfo.BreviarySettings model)
        {
            StringBuilder strSql = new StringBuilder();
            //strSql.Append("DECLARE @Sequence int");
            //strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_breviarysettings]");
            //strSql.Append(" if @Sequence is NULL");
            //strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_breviarysettings](");
            strSql.Append("[Width],[Height],[PlusWatermark],[WatermarkType],[WatermarkImage],[ImageTransparent],[WatermarkText],[TextTransparent],[WatermarkPosition]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@width,@height,@pluswatermark,@watermarktype,@watermarkimage,@imagetransparent,@watermarktext,@texttransparent,@watermarkposition");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@width", SqlDbType.Int,4),
					new SqlParameter("@height", SqlDbType.Int,4),
					new SqlParameter("@pluswatermark", SqlDbType.Bit),
					new SqlParameter("@watermarktype", SqlDbType.Bit),
					new SqlParameter("@watermarkimage", SqlDbType.VarChar,800),
					new SqlParameter("@imagetransparent", SqlDbType.Int,4),
					new SqlParameter("@watermarktext", SqlDbType.NVarChar,50),
					new SqlParameter("@texttransparent", SqlDbType.Int,4),
					new SqlParameter("@watermarkposition", SqlDbType.Int,4)};
            parameters[0].Value = model.Width;
            parameters[1].Value = model.Height;
            parameters[2].Value = model.PlusWatermark;
            parameters[3].Value = model.WatermarkType;
            parameters[4].Value = model.WatermarkImage;
            parameters[5].Value = model.ImageTransparent;
            parameters[6].Value = model.WatermarkText;
            parameters[7].Value = model.TextTransparent;
            parameters[8].Value = model.WatermarkPosition;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #18
0
ファイル: AdminLoginLog.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.Access.AdminLoginLog model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("DECLARE @Sequence int");
            strSql.Append(" SELECT @Sequence=(max(Sequence)+1) FROM [cms_adminloginlog]");
            strSql.Append(" if @Sequence is NULL");
            strSql.Append(" Set @Sequence=1");
            strSql.Append("INSERT INTO [cms_adminloginlog](");
            strSql.Append("[Name],[Password],[LoginTime],[LogoutTime],[LoginIP],[HosterName],[LoginStatus]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@name,@password,@logintime,@logouttime,@loginip,@hostername,@loginstatus");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
            		new SqlParameter("@name", SqlDbType.VarChar,50),
					new SqlParameter("@password", SqlDbType.VarChar,32),
					new SqlParameter("@logintime", SqlDbType.DateTime),
					new SqlParameter("@logouttime", SqlDbType.DateTime),
					new SqlParameter("@loginip", SqlDbType.VarChar,50),
					new SqlParameter("@hostername", SqlDbType.VarChar,100),
					new SqlParameter("@loginstatus", SqlDbType.NVarChar,4000)};
            parameters[0].Value = model.Name;
            parameters[1].Value = model.Password;
            parameters[2].Value = model.LoginTime;
            parameters[3].Value = model.LogoutTime;
            parameters[4].Value = model.LoginIP;
            parameters[5].Value = model.HosterName;
            parameters[6].Value = model.LoginStatus;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #19
0
ファイル: AdminRole.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(Johnny.CMS.OM.Access.AdminRole model)
 {
     dal.Update(model);
 }
コード例 #20
0
ファイル: AdminRole.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Add one record
 /// </summary>
 public int Add(Johnny.CMS.OM.Access.AdminRole model)
 {
     return dal.Add(model);
 }
コード例 #21
0
ファイル: RolePermission.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(Johnny.CMS.OM.Access.RolePermission model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE [cms_rolepermission] SET ");
            strSql.Append("[PermissionId]=@permissionid");
            strSql.Append(" WHERE [RoleId]=@roleid ");
            SqlParameter[] parameters = {
            		new SqlParameter("@roleid", SqlDbType.Int,4),
					new SqlParameter("@permissionid", SqlDbType.Int,4)};
            parameters[0].Value = model.RoleId;
            parameters[1].Value = model.PermissionId;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
コード例 #22
0
ファイル: RolePermission.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Add one record
        /// </summary>
        public int Add(Johnny.CMS.OM.Access.RolePermission model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("INSERT INTO [cms_rolepermission](");
            strSql.Append("[RoleId],[PermissionId]");
            strSql.Append(")");
            strSql.Append(" VALUES (");
            strSql.Append("@roleid,");
            strSql.Append("@permissionid");
            strSql.Append(")");
            strSql.Append(";SELECT @@IDENTITY");
            SqlParameter[] parameters = {
                    new SqlParameter("@roleid", SqlDbType.Int,4),
            		new SqlParameter("@permissionid", SqlDbType.Int,4)};
            parameters[0].Value = model.RoleId;
            parameters[1].Value = model.PermissionId;

            object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
            if (obj == null)
            {
                return 1;
            }
            else
            {
                return Convert.ToInt32(obj);
            }
        }
コード例 #23
0
ファイル: Channel.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(Johnny.CMS.OM.SeH.Channel model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE [seh_channel] SET ");
            strSql.Append("[ChannelName]=@channelname");
            strSql.Append(" WHERE [ChannelId]=@channelid ");
            SqlParameter[] parameters = {
            		new SqlParameter("@channelid", SqlDbType.Int,4),
					new SqlParameter("@channelname", SqlDbType.NVarChar,50),
			};
            parameters[0].Value = model.ChannelId;
            parameters[1].Value = model.ChannelName;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
コード例 #24
0
ファイル: Bulletin.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(Johnny.CMS.OM.SeH.Bulletin model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE [seh_bulletin] SET ");
            strSql.Append("[Title]=@title,");
            strSql.Append("[Content]=@content,");
            strSql.Append("[URL]=@url,");
            strSql.Append("[Hits]=@hits,");
            strSql.Append("[IsDisplay]=@isdisplay,");
            //strSql.Append("[CreatedTime]=@createdtime,");
            //strSql.Append("[CreatedById]=@createdbyid,");
            //strSql.Append("[CreatedByName]=@createdbyname,");
            strSql.Append("[UpdatedTime]=@updatedtime,");
            strSql.Append("[UpdatedById]=@updatedbyid,");
            strSql.Append("[UpdatedByName]=@updatedbyname,");
            strSql.Append(" WHERE [BulletinId]=@bulletinid ");
            SqlParameter[] parameters = {
            		new SqlParameter("@bulletinid", SqlDbType.Int,4),
					new SqlParameter("@title", SqlDbType.NVarChar,200),
					new SqlParameter("@content", SqlDbType.Text),
					new SqlParameter("@url", SqlDbType.VarChar,200),
					new SqlParameter("@hits", SqlDbType.Int,4),
					new SqlParameter("@isdisplay", SqlDbType.Bit),
			        //new SqlParameter("@createdtime", SqlDbType.DateTime),
					//new SqlParameter("@createdbyid", SqlDbType.Int,4),
					//new SqlParameter("@createdbyname", SqlDbType.VarChar,50),
					new SqlParameter("@updatedtime", SqlDbType.DateTime),
					new SqlParameter("@updatedbyid", SqlDbType.Int,4),
					new SqlParameter("@updatedbyname", SqlDbType.VarChar,50),
			};
            parameters[0].Value = model.BulletinId;
            parameters[1].Value = model.Title;
            parameters[2].Value = model.Content;
            parameters[3].Value = model.URL;
            parameters[4].Value = model.Hits;
            parameters[5].Value = model.IsDisplay;
            //parameters[6].Value = model.CreatedTime;
            //parameters[7].Value = model.CreatedById;
            //parameters[8].Value = model.CreatedByName;
            parameters[6].Value = model.UpdatedTime;
            parameters[7].Value = model.UpdatedById;
            parameters[8].Value = model.UpdatedByName;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
コード例 #25
0
ファイル: MailSettings.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(Johnny.CMS.OM.SystemInfo.MailSettings model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE [cms_mailsettings] SET ");
            strSql.Append("[SmtpServerIP]=@smtpserverip,");
            strSql.Append("[SmtpServerPort]=@smtpserverport,");
            strSql.Append("[MailId]=@mailid,");
            strSql.Append("[MailPassword]=@mailpassword");
            //strSql.Append(" WHERE [Id]=@id ");
            SqlParameter[] parameters = {
            		new SqlParameter("@id", SqlDbType.Int,4),
					new SqlParameter("@smtpserverip", SqlDbType.VarChar,50),
					new SqlParameter("@smtpserverport", SqlDbType.Int,4),
					new SqlParameter("@mailid", SqlDbType.VarChar,100),
					new SqlParameter("@mailpassword", SqlDbType.VarChar,50)};
            parameters[0].Value = model.Id;
            parameters[1].Value = model.SmtpServerIP;
            parameters[2].Value = model.SmtpServerPort;
            parameters[3].Value = model.MailId;
            parameters[4].Value = model.MailPassword;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
コード例 #26
0
ファイル: Permission.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(Johnny.CMS.OM.Access.Permission model)
 {
     dal.Update(model);
 }
コード例 #27
0
ファイル: Permission.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Add one record
 /// </summary>
 public int Add(Johnny.CMS.OM.Access.Permission model)
 {
     return dal.Add(model);
 }
コード例 #28
0
ファイル: Navigator.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(Johnny.CMS.OM.SystemInfo.Navigator model)
 {
     dal.Update(model);
 }
コード例 #29
0
ファイル: Navigator.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Add one record
 /// </summary>
 public int Add(Johnny.CMS.OM.SystemInfo.Navigator model)
 {
     return dal.Add(model);
 }
コード例 #30
0
ファイル: Website.cs プロジェクト: jojozhuang/Projects
        /// <summary>
        /// Update one record
        /// </summary>
        public void Update(Johnny.CMS.OM.SeH.Website model)
        {
            StringBuilder strSql = new StringBuilder();
            strSql.Append("UPDATE [seh_website] SET ");
            strSql.Append("[WebsiteName]=@websitename,");
            strSql.Append("[WebsiteCategoryId]=@websitecategoryid,");
            strSql.Append("[Description]=@description,");
            strSql.Append("[URL]=@url,");
            strSql.Append("[Hits]=@hits,");
            strSql.Append("[IsDisplay]=@isdisplay,");
            //strSql.Append("[CreatedTime]=@createdtime,");
            //strSql.Append("[CreatedById]=@createdbyid,");
            //strSql.Append("[CreatedByName]=@createdbyname,");
            strSql.Append("[UpdatedTime]=@updatedtime,");
            strSql.Append("[UpdatedById]=@updatedbyid,");
            strSql.Append("[UpdatedByName]=@updatedbyname,");
            strSql.Append(" WHERE [WebsiteId]=@websiteid ");
            SqlParameter[] parameters = {
            		new SqlParameter("@websiteid", SqlDbType.Int,4),
					new SqlParameter("@websitename", SqlDbType.NVarChar,50),
					new SqlParameter("@websitecategoryid", SqlDbType.Int,4),
					new SqlParameter("@description", SqlDbType.NVarChar,100),
					new SqlParameter("@url", SqlDbType.VarChar,200),
					new SqlParameter("@hits", SqlDbType.Int,4),
					new SqlParameter("@isdisplay", SqlDbType.Bit),
					//new SqlParameter("@createdtime", SqlDbType.DateTime),
					//new SqlParameter("@createdbyid", SqlDbType.Int,4),
					//new SqlParameter("@createdbyname", SqlDbType.VarChar,50),
					new SqlParameter("@updatedtime", SqlDbType.DateTime),
					new SqlParameter("@updatedbyid", SqlDbType.Int,4),
					new SqlParameter("@updatedbyname", SqlDbType.VarChar,50),
			};
            parameters[0].Value = model.WebsiteId;
            parameters[1].Value = model.WebsiteName;
            parameters[2].Value = model.WebsiteCategoryId;
            parameters[3].Value = model.Description;
            parameters[4].Value = model.URL;
            parameters[5].Value = model.Hits;
            parameters[6].Value = model.IsDisplay;
            //parameters[7].Value = model.CreatedTime;
            //parameters[8].Value = model.CreatedById;
            //parameters[9].Value = model.CreatedByName;
            parameters[7].Value = model.UpdatedTime;
            parameters[8].Value = model.UpdatedById;
            parameters[9].Value = model.UpdatedByName;

            DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
        }
コード例 #31
0
ファイル: Website.cs プロジェクト: jojozhuang/Projects
 /// <summary>
 /// Update one record
 /// </summary>
 public void Update(Johnny.CMS.OM.SeH.Website model)
 {
     dal.Update(model);
 }