Example #1
0
        protected void btnDelDomain_Click(object sender, EventArgs e)
        {
            DomainSynchroHistoryVO info = new DomainSynchroHistoryVO();

            info.ClientIp     = "";
            info.CreateDate   = DateTime.Now;
            info.CreateUserId = Account.UserId;
            info.DomainPath   = txtWebPath.Text;
            info.Domains      = txtDomains.Text;
            info.MainDomain   = txtMainDomain.Text;
            info.Name         = ddlServer.SelectedValue;
            info.OperType     = 2;
            info.ServerId     = 0;
            info.SynchroDate  = DateTime.Now;
            info.UserId       = Account.UserId;

            DomainSynchroHistoryBLL.Instance.Add(info);
            lblMsg.Text = "域名同步数据提交,服务器正在同步处理。";
        }
Example #2
0
        public override bool Edit(DomainSynchroHistoryVO m)
        {
            CodeCommand command = new CodeCommand();

            command.CommandText = EDIT;

            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@ServerId", Value = ParameterHelper.ConvertValue(m.ServerId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@MainDomain", Value = ParameterHelper.ConvertValue(m.MainDomain)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@DomainPath", Value = ParameterHelper.ConvertValue(m.DomainPath)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@OperType", Value = ParameterHelper.ConvertValue(m.OperType)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@IsSynchro", Value = ParameterHelper.ConvertValue(m.IsSynchro)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@SynchroDate", Value = ParameterHelper.ConvertValue(m.SynchroDate)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@IsDelete", Value = ParameterHelper.ConvertValue(m.IsDelete)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Id", Value = ParameterHelper.ConvertValue(m.Id)
            });


            int result = DbProxyFactory.Instance.Proxy.ExecuteNonQuery(command);

            if (result >= 1)
            {
                return(true);
            }

            return(false);
        }
Example #3
0
        public override int InsertIdentityId(DomainSynchroHistoryVO m)
        {
            CodeCommand command = new CodeCommand();

            command.CommandText = INSERT + "; select @@Identity";

            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@ServerId", Value = ParameterHelper.ConvertValue(m.ServerId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Name", Value = ParameterHelper.ConvertValue(m.Name)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@MainDomain", Value = ParameterHelper.ConvertValue(m.MainDomain)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@Domains", Value = ParameterHelper.ConvertValue(m.Domains)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@DomainPath", Value = ParameterHelper.ConvertValue(m.DomainPath)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@OperType", Value = ParameterHelper.ConvertValue(m.OperType)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@IsSynchro", Value = ParameterHelper.ConvertValue(m.IsSynchro)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@SynchroDate", Value = ParameterHelper.ConvertValue(m.SynchroDate)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@ClientIp", Value = ParameterHelper.ConvertValue(m.ClientIp)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateDate", Value = ParameterHelper.ConvertValue(m.CreateDate)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@CreateUserId", Value = ParameterHelper.ConvertValue(m.CreateUserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@UserId", Value = ParameterHelper.ConvertValue(m.UserId)
            });
            command.Parameters.Add(new SqlParameter()
            {
                ParameterName = "@IsDelete", Value = ParameterHelper.ConvertValue(m.IsDelete)
            });


            var result = DbProxyFactory.Instance.Proxy.ExecuteScalar(command);

            return(int.Parse(result.ToString()));
        }
Example #4
0
 public override string GetOtherConditionByModel(DomainSynchroHistoryVO m)
 {
     return("");
 }
Example #5
0
 public override string GetOrderByModel(DomainSynchroHistoryVO m)
 {
     return("");
 }