コード例 #1
0
 //public FPInfoAttribute(string dataType)
 public PropertyInfoAttribute(System.Data.SqlDbType dataType)
 {
     DataType = dataType;
     PrimaryKey = false;// Default value.
     UniqueKey = false;
     SecondaryKey = false;
     IsNull = true;
 }
コード例 #2
0
ファイル: SqlDebugging.cs プロジェクト: AgentTy/General
        private static bool IsText(System.Data.SqlDbType type)
        {
            switch (type)
            {
            case System.Data.SqlDbType.VarChar:
            case System.Data.SqlDbType.Text:
            case System.Data.SqlDbType.NVarChar:
            case System.Data.SqlDbType.NText:
            case System.Data.SqlDbType.NChar:
            case System.Data.SqlDbType.Char:
            case System.Data.SqlDbType.DateTime:
            case System.Data.SqlDbType.SmallDateTime:
            case System.Data.SqlDbType.Timestamp:
            case System.Data.SqlDbType.UniqueIdentifier:
                return(true);

            default:
                return(false);
            }
        }
コード例 #3
0
        /// <summary>
        /// 将字符串转化成 enum
        /// </summary>
        /// <param name="type"></param>
        /// <returns></returns>
        public static System.Data.SqlDbType ToSqlDbType(string type)
        {
            System.Data.SqlDbType rtn = System.Data.SqlDbType.VarChar;

            if (type.ToLower().Trim() == "numeric")
            {
                return(System.Data.SqlDbType.Decimal);
            }

            string[] s = Enum.GetNames(typeof(System.Data.SqlDbType));
            for (int i = 0; i < s.Length; i++)
            {
                if (s[i].ToLower() == type.ToLower())
                {
                    rtn = (System.Data.SqlDbType)Enum.Parse(typeof(System.Data.SqlDbType), type, true);
                    break;
                }
            }
            return(rtn);
        }
コード例 #4
0
 public Boolean ADD_OUTPUT_PARAMATER(string proc_variable, System.Data.SqlDbType data_type, object variable_value)
 {
     if (Command != null)
     {
         try
         {
             Command.Parameters.Add(proc_variable, data_type).Value = variable_value;
             Command.Parameters[proc_variable].Direction            = System.Data.ParameterDirection.Output;
             return(true);
         }
         catch (Exception e)
         {
             throw e;
         }
     }
     else
     {
         throw new Exception("Command Not Initialized");
     }
 }
コード例 #5
0
        public static string ToPSQLString(this System.Data.SqlDbType type)
        {
            switch (type)
            {
            case System.Data.SqlDbType.NVarChar:
                return("VarChar");

            case System.Data.SqlDbType.NText:
                return("Text");

            case System.Data.SqlDbType.NChar:
                return("Char");

            case  SqlDbType.DateTime:
                return("TIMESTAMP");

            default:
                return(type.ToString());
            }
        }
コード例 #6
0
ファイル: Utils.cs プロジェクト: bbakermmc/sqlservertoazure
        internal static void PushSingleRecordResult(object result, System.Data.SqlDbType sqlDBType)
        {
            //SqlContext.Pipe.Send("Response output:\n");
            //SqlContext.Pipe.Send(result.ToString());

            SqlDataRecord record = null;

            switch (sqlDBType)
            {
            case System.Data.SqlDbType.NVarChar:
            case System.Data.SqlDbType.VarChar:
                record = new SqlDataRecord(new SqlMetaData[] { new SqlMetaData("Result", sqlDBType, -1) });
                record.SetString(0, result.ToString());
                break;

            case System.Data.SqlDbType.Xml:
                record = new SqlDataRecord(new SqlMetaData[] { new SqlMetaData("Result", sqlDBType) });

                SqlXml xml;
                using (System.Xml.XmlReader reader = System.Xml.XmlReader.Create(new System.IO.StringReader(result.ToString())))
                {
                    xml = new SqlXml(reader);
                }

                record.SetSqlXml(0, xml);
                break;

            case System.Data.SqlDbType.Int:
                record = new SqlDataRecord(new SqlMetaData[] { new SqlMetaData("Result", sqlDBType) });
                record.SetInt32(0, (Int32)result);
                break;

            default:
                throw new ArgumentException("SqlDbType " + sqlDBType.ToString() + " is not supported by PushSingleRecordResult.");
            }

            SqlContext.Pipe.SendResultsStart(record);
            SqlContext.Pipe.SendResultsRow(record);
            SqlContext.Pipe.SendResultsEnd();
        }
コード例 #7
0
ファイル: Parameter.cs プロジェクト: jignesh2588/Prius
 public IParameter Initialize(
     string name,
     Type type,
     long size,
     System.Data.SqlDbType dbType,
     ParameterDirection direction,
     Object value,
     Action <IParameter> storeOutputValue = null)
 {
     if (string.IsNullOrEmpty(name))
     {
         throw new PriusException("Parameter name can not be blank");
     }
     Name             = name[0] == '@' ? name.Substring(1) : name;
     Type             = type;
     Size             = size;
     DbType           = dbType;
     Direction        = direction;
     Value            = value;
     StoreOutputValue = storeOutputValue ?? NoOutputValue;
     return(this);
 }
コード例 #8
0
        public override void XmlLoad(XmlNode node)
        {
            try
            {
                _key             = XmlHelper.GetAttributeValue(node, "key", string.Empty);
                this.Generated   = XmlHelper.GetAttributeValue(node, "generated", _def_generated);
                this.Name        = XmlHelper.GetAttributeValue(node, "name", string.Empty);
                this.CodeFacade  = XmlHelper.GetAttributeValue(node, "codeFacade", _def_codefacade);
                this.Description = XmlHelper.GetAttributeValue(node, "description", _description);
                var relationshipRefNode = node.SelectSingleNode("relationshipRef");
                if (relationshipRefNode != null)
                {
                    RelationshipRef = new Reference(this.Root);
                    RelationshipRef.XmlLoad(relationshipRefNode);
                }

                this.Default = XmlHelper.GetAttributeValue(node, "default", _def_default);
                this.Length  = XmlHelper.GetAttributeValue(node, "length", _length);
                this.ResetId(XmlHelper.GetAttributeValue(node, "id", _id));
                this.SortOrder = XmlHelper.GetAttributeValue(node, "sortOrder", _sortOrder);

                var parentTableRefNode = node.SelectSingleNode("parentTableRef");
                ParentTableRef = new Reference(this.Root);
                ParentTableRef.XmlLoad(parentTableRefNode);

                _dataType = (System.Data.SqlDbType)XmlHelper.GetAttributeValue(node, "type", (int)_def_type);

                this.AllowNull         = XmlHelper.GetAttributeValue(node, "allowNull", _allowNull);
                this.IsOutputParameter = XmlHelper.GetAttributeValue(node, "isOutputParameter", _isOutputParameter);

                this.Dirty = false;
            }
            catch (Exception ex)
            {
                throw;
            }
        }
コード例 #9
0
 public System.Data.DataTable FiltrarDatos(string sNombreSP, string sNombreParametro, System.Data.SqlDbType DbType, string sValorParametro, ref string sMsjError)
 {
     BLL_LetsGO.svc_Cat_Mat.FiltrarDatosRequest inValue = new BLL_LetsGO.svc_Cat_Mat.FiltrarDatosRequest();
     inValue.sNombreSP        = sNombreSP;
     inValue.sNombreParametro = sNombreParametro;
     inValue.DbType           = DbType;
     inValue.sValorParametro  = sValorParametro;
     inValue.sMsjError        = sMsjError;
     BLL_LetsGO.svc_Cat_Mat.FiltrarDatosResponse retVal = ((BLL_LetsGO.svc_Cat_Mat.ILetsGo_Interface)(this)).FiltrarDatos(inValue);
     sMsjError = retVal.sMsjError;
     return(retVal.FiltrarDatosResult);
 }
コード例 #10
0
 public System.Data.DataTable FiltrarDatos(string sNombreSP, string sNombreParametro, System.Data.SqlDbType DbType, string sValrParametro, ref string SMsError)
 {
     AmazonFake_SITE.AmazonFakeServiceAlt.FiltrarDatosRequest inValue = new AmazonFake_SITE.AmazonFakeServiceAlt.FiltrarDatosRequest();
     inValue.sNombreSP        = sNombreSP;
     inValue.sNombreParametro = sNombreParametro;
     inValue.DbType           = DbType;
     inValue.sValrParametro   = sValrParametro;
     inValue.SMsError         = SMsError;
     AmazonFake_SITE.AmazonFakeServiceAlt.FiltrarDatosResponse retVal = ((AmazonFake_SITE.AmazonFakeServiceAlt.I_Base_Datos)(this)).FiltrarDatos(inValue);
     SMsError = retVal.SMsError;
     return(retVal.FiltrarDatosResult);
 }
コード例 #11
0
        public override void XmlLoad(XmlNode node)
        {
            try
            {
                _key = XmlHelper.GetAttributeValue(node, "key", string.Empty);
                this.Generated = XmlHelper.GetAttributeValue(node, "generated", _def_generated);
                this.Name = XmlHelper.GetAttributeValue(node, "name", string.Empty);
                this.CodeFacade = XmlHelper.GetAttributeValue(node, "codeFacade", _def_codefacade);
                this.Description = XmlHelper.GetAttributeValue(node, "description", _def_description);
                this.FriendlyName = XmlHelper.GetAttributeValue(node, "dataFieldFriendlyName", _def_friendlyName);
                this.UIVisible = XmlHelper.GetAttributeValue(node, "dataFieldVisibility", _def_UIVisible);
                this.SortOrder = XmlHelper.GetAttributeValue(node, "dataFieldSortOrder", _def_sortOrder);
                var relationshipRefNode = node.SelectSingleNode("relationshipRef");
                if (relationshipRefNode != null)
                {
                    RelationshipRef = new Reference(this.Root);
                    RelationshipRef.XmlLoad(relationshipRefNode);
                }

                this.Default = XmlHelper.GetAttributeValue(node, "default", _def_default);
                this.Length = XmlHelper.GetAttributeValue(node, "length", _length);
                this.ResetId(XmlHelper.GetAttributeValue(node, "id", _id));

                var parentViewRefNode = node.SelectSingleNode("parentTableRef");
                ParentViewRef = new Reference(this.Root);
                if (parentViewRefNode != null)
                    ParentViewRef.XmlLoad(parentViewRefNode);

                var typeString = node.Attributes["type"].Value;
                if (!string.IsNullOrEmpty(typeString))
                    _dataType = (System.Data.SqlDbType)int.Parse(typeString);

                this.AllowNull = XmlHelper.GetAttributeValue(node, "allowNull", _allowNull);

                this.Dirty = false;
            }
            catch (Exception ex)
            {
                throw;
            }

        }
コード例 #12
0
ファイル: Extensions.cs プロジェクト: aTiKhan/nHydrate
        public static string GetPostgresDefault(this System.Data.SqlDbType dataType, string defaultValue)
        {
            var retval = string.Empty;

            if ((dataType == System.Data.SqlDbType.DateTime) || (dataType == System.Data.SqlDbType.SmallDateTime))
            {
                if (defaultValue == "getdate")
                {
                    //retval = defaultValue;
                }
                else if (defaultValue == "sysdatetime")
                {
                    //retval = defaultValue;
                }
                else if (defaultValue == "getutcdate")
                {
                    //retval = defaultValue;
                }
                else if (defaultValue.StartsWith("getdate+"))
                {
                    //Do Nothing - Cannot calculate
                }
                //else if (daatType == System.Data.SqlDbType.SmallDateTime)
                //{
                //  defaultValue = String.Format("new DateTime(1900, 1, 1)", this.PascalName);
                //}
                //else
                //{
                //  defaultValue = String.Format("new DateTime(1753, 1, 1)", this.PascalName);
                //}
            }
            else if (dataType == System.Data.SqlDbType.Char)
            {
                retval = "' '";
                if (defaultValue.Length == 1)
                {
                    retval = "'" + defaultValue[0].ToString().DoubleTicks() + "'";
                }
            }
            else if (dataType.IsBinaryType())
            {
                //Do Nothing - Cannot calculate
            }
            //else if (dataType == System.Data.SqlDbType.DateTimeOffset)
            //{
            //  defaultValue = "DateTimeOffset.MinValue";
            //}
            //else if (this.IsDateType)
            //{
            //  defaultValue = "System.DateTime.MinValue";
            //}
            //else if (dataType == System.Data.SqlDbType.Time)
            //{
            //  defaultValue = "0";
            //}
            else if (dataType == System.Data.SqlDbType.UniqueIdentifier)
            {
                //Do Nothing
                //if ((StringHelper.Match(defaultValue, "newid", true)) || (StringHelper.Match(defaultValue, "newid()", true)))
                //  retval = "newid";
                //else if (defaultValue.IsEmpty())
                //  retval = string.Empty;
                //else
                //{
                //  Guid g;
                //  if (Guid.TryParse(defaultValue, out g))
                //    retval = "'" + g.ToString() + "'";
                //}
            }
            else if (dataType.IsIntegerType())
            {
                if (int.TryParse(defaultValue, out _))
                {
                    retval = defaultValue;
                }
            }
            else if (dataType.IsNumericType())
            {
                if (double.TryParse(defaultValue, out _))
                {
                    retval = defaultValue;
                }
            }
            else if (dataType == System.Data.SqlDbType.Bit)
            {
                if (defaultValue == "0" || defaultValue == "1")
                {
                    retval = (defaultValue == "1") ? "true" : "false";
                }
            }
            else
            {
                if (dataType.IsTextType() && !defaultValue.IsEmpty())
                {
                    retval = "'" + defaultValue.DoubleTicks() + "'";
                }
            }
            return(retval);
        }
コード例 #13
0
ファイル: SQLServer.cs プロジェクト: alex23121987/cosapinoweb
        public static System.Data.SqlClient.SqlParameter CreateParameterOutput(string ParameterName, System.Data.SqlDbType SqlDbType, int Size)
        {
            var SqlParameter = new System.Data.SqlClient.SqlParameter
            {
                ParameterName = string.Concat("@", ParameterName),
                Direction     = System.Data.ParameterDirection.Output,
                SqlDbType     = SqlDbType,
                Size          = Size
            };

            return(SqlParameter);
        }
コード例 #14
0
        protected List <T> GetAllByColumnValue(string columnName, object value, System.Data.SqlDbType type)
        {
            SqlParameter parameter = MakeSqlParameter(columnName, value, type);

            return(IdenticalMatch(new SqlParameter[] { parameter }));
        }
コード例 #15
0
 public static void RegisterKeyInitializer <T>(string beforInsert, string afterInsert, bool setInInsert, System.Data.SqlDbType sqlDbType, T emptyValue)
 {
     keyInitializer.Add(typeof(T), new KeyInitializer(beforInsert, afterInsert, setInInsert, sqlDbType, emptyValue));
 }
コード例 #16
0
 /// <summary>
 /// Adds a <see cref="Parameter"/> to the collection.
 /// </summary>
 /// <param name="name">The name of the parameter.</param>
 /// <param name="type">The parameter System.Data.SqlDbType.</param>
 /// <param name="typename">The type name for a table valued parameter.</param>
 /// <param name="value">The value of the parameter.</param>
 public ParameterCollection Add(string name, System.Data.SqlDbType type, string typename, object value)
 {
     return(Add(name, type, -1, typename, System.Data.ParameterDirection.Input, value));
 }
コード例 #17
0
        private string CreateParameters(object value, System.Reflection.MemberInfo p, EntityProcedureAttribute custType, out System.Data.SqlClient.SqlParameter sqlParameter)
        {
            string resultCmd     = string.Empty;
            string parameterName = string.Empty;

            #region ActionContent
            //判斷如果value是NULL預設值時,給Null值
            if (custType.DefaultOrNullValue != null && value != null)
            {
                if (value.ToString() == custType.DefaultOrNullValue.ToString())
                {
                    value = null;
                }
            }


            System.Data.SqlDbType PropertyType = System.Data.SqlDbType.NVarChar;
            if (custType != null)
            {
                int length = 0;
                if (custType.Size.HasValue)
                {
                    var hasLen = int.TryParse(custType.Size.Value.ToString(), out length);
                    if (hasLen)
                    {
                        if (value != null)
                        {
                            if (value.ToString().Length > length)
                            {
                                value = value.ToString().Substring(0, length);
                            }
                        }
                    }
                }
                //取得
                PropertyType = (System.Data.SqlDbType)custType.AttrType;



                sqlParameter           = new System.Data.SqlClient.SqlParameter();
                sqlParameter.SqlDbType = PropertyType;

                if (custType.Size.HasValue)
                {
                    sqlParameter.Size = custType.Size.Value;
                }

                if ((
                        (custType.Direction.HasValue &&
                         (custType.Direction == System.Data.ParameterDirection.Input ||
                          custType.Direction == System.Data.ParameterDirection.InputOutput
                         )
                        )
                        ||
                        custType.Direction.HasValue == false
                        ))
                {
                    if (value == null)
                    {
                        sqlParameter.Value      = DBNull.Value;
                        sqlParameter.IsNullable = true;
                    }
                    else
                    {
                        sqlParameter.Value = value;
                    }
                }

                if (string.IsNullOrWhiteSpace(custType.ParameterName) == false)
                {
                    parameterName = sqlParameter.ParameterName = custType.ParameterName.Replace("@", string.Empty);
                }
                else
                {
                    parameterName = sqlParameter.ParameterName = p.Name;
                }

                string Cmd = " @{0} = @{0} {1}";
                if (custType.Direction.HasValue)
                {
                    sqlParameter.Direction = custType.Direction.Value;
                    switch (custType.Direction.Value)
                    {
                    case System.Data.ParameterDirection.Output:
                    case System.Data.ParameterDirection.InputOutput:
                        resultCmd = string.Format(Cmd, parameterName, "Output");
                        break;

                    default:
                        resultCmd = string.Format(Cmd, parameterName, string.Empty);
                        break;
                    }
                }
                else
                {
                    resultCmd = string.Format(Cmd, parameterName, string.Empty);
                }
            }
            else
            {
                throw new EntityProcedureAttributeException(p.Name + "屬性找不到EntityProcedureAttribute,請確定是否已定義此設定。");
            }


            #endregion

            return(resultCmd);
        }
コード例 #18
0
 //setear parametros del store procedure, dando un vector de parametros, el nombre del paramtro, su tipo de dato en la base de datos y el valor que contiene
 public void agregarParametroSP(SqlParameter[] vectorParam, int pos, string parametro, System.Data.SqlDbType dbType, object valor)
 {
     vectorParam[pos]       = new SqlParameter(parametro, dbType);
     vectorParam[pos].Value = valor;
 }
コード例 #19
0
ファイル: SQLServer.cs プロジェクト: alex23121987/cosapinoweb
        public static System.Data.SqlClient.SqlParameter CreateParameter(string ParameterName, System.Data.SqlDbType SqlDbType, Object Value)
        //public static System.Data.SqlClient.SqlParameter CreateParameter(string ParameterName, System.Data.SqlDbType SqlDbType, int Size, Object Value)
        {
            var SqlParameter = new System.Data.SqlClient.SqlParameter
            {
                ParameterName = string.Concat("@", ParameterName),
                Direction     = System.Data.ParameterDirection.Input,
                SqlDbType     = SqlDbType,
                Value         = Value
            };

            //SqlParameter.Size = Size;
            return(SqlParameter);
        }
コード例 #20
0
        public int SetNewPassword(string SpName, string stringOldPassword, string stringNewPassword, System.Data.SqlDbType SqlType = System.Data.SqlDbType.UniqueIdentifier)
        {
            var items = new List <AutoItem>();

            items.Add(new AutoItem
            {
                Name    = "UserId",
                Value   = ModelCore.UserId,
                SqlType = SqlType
            });
            items.Add(new AutoItem
            {
                Name    = "stringOldPassword",
                Value   = Lambda.Framework.AutoEncrypt.MD5Hash(stringOldPassword),
                SqlType = System.Data.SqlDbType.NVarChar
            });
            items.Add(new AutoItem
            {
                Name    = "stringNewPassword",
                Value   = Lambda.Framework.AutoEncrypt.MD5Hash(stringNewPassword),
                SqlType = System.Data.SqlDbType.NVarChar
            });
            return(Model.SetAutoObject(new AutoObject {
                SpName = SpName, Items = items
            }));
        }
コード例 #21
0
        public static System.Data.DbType ToDbType(System.Data.SqlDbType sqlDbType)
        {
            switch (sqlDbType)
            {
            case System.Data.SqlDbType.BigInt:
                return(System.Data.DbType.Int64);

            case System.Data.SqlDbType.Binary:
                return(System.Data.DbType.Binary);

            case System.Data.SqlDbType.Bit:
                return(System.Data.DbType.Boolean);

            case System.Data.SqlDbType.Char:
                return(System.Data.DbType.String);

            case System.Data.SqlDbType.Date:
                return(System.Data.DbType.Date);

            case System.Data.SqlDbType.DateTime:
                return(System.Data.DbType.DateTime);

            case System.Data.SqlDbType.DateTime2:
                return(System.Data.DbType.DateTime2);

            case System.Data.SqlDbType.DateTimeOffset:
                return(System.Data.DbType.DateTimeOffset);

            case System.Data.SqlDbType.Decimal:
                return(System.Data.DbType.Decimal);

            case System.Data.SqlDbType.Float:
                return(System.Data.DbType.VarNumeric);

            case System.Data.SqlDbType.Image:
                return(System.Data.DbType.Object);

            case System.Data.SqlDbType.Int:
                return(System.Data.DbType.Int32);

            case System.Data.SqlDbType.Money:
                return(System.Data.DbType.Currency);

            case System.Data.SqlDbType.NChar:
                return(System.Data.DbType.String);

            case System.Data.SqlDbType.NText:
                return(System.Data.DbType.String);

            case System.Data.SqlDbType.NVarChar:
                return(System.Data.DbType.String);

            case System.Data.SqlDbType.Real:
                return(System.Data.DbType.VarNumeric);

            case System.Data.SqlDbType.SmallDateTime:
                return(System.Data.DbType.DateTime);

            case System.Data.SqlDbType.SmallInt:
                return(System.Data.DbType.Int16);

            case System.Data.SqlDbType.SmallMoney:
                return(System.Data.DbType.Currency);

            case System.Data.SqlDbType.Structured:
                return(System.Data.DbType.Object);

            case System.Data.SqlDbType.Text:
                return(System.Data.DbType.String);

            case System.Data.SqlDbType.Time:
                return(System.Data.DbType.Time);

            case System.Data.SqlDbType.Timestamp:
                return(System.Data.DbType.DateTimeOffset);

            case System.Data.SqlDbType.TinyInt:
                return(System.Data.DbType.Byte);

            case System.Data.SqlDbType.Udt:
                return(System.Data.DbType.Object);

            case System.Data.SqlDbType.UniqueIdentifier:
                return(System.Data.DbType.Guid);

            case System.Data.SqlDbType.VarBinary:
                return(System.Data.DbType.Binary);

            case System.Data.SqlDbType.VarChar:
                return(System.Data.DbType.String);

            case System.Data.SqlDbType.Variant:
                return(System.Data.DbType.Object);

            case System.Data.SqlDbType.Xml:
                return(System.Data.DbType.Xml);

            default:
                return(System.Data.DbType.String);
            }
        }
コード例 #22
0
 public IParameter Create(string name, System.Data.SqlDbType dbType, ParameterDirection direction)
 {
     return(new Parameter().Initialize(name, typeof(object), 0, dbType, direction, null));
 }
コード例 #23
0
ファイル: Datacolum.cs プロジェクト: John-Shaw/HoneyPot
 public Datacolumn(string name, System.Data.SqlDbType type)
 {
     Name = name;
     DataType = type;
 }
コード例 #24
0
 public KeyInitializer(string beforInsert, string afterInsert, bool setInInsert, System.Data.SqlDbType sqlDbType, object emptyValue)
 {
     _beforInsert = beforInsert;
     _afterInsert = afterInsert;
     _emptyValue  = emptyValue;
     _setInInsert = setInInsert;
     _sqlDbType   = sqlDbType;
 }
コード例 #25
0
ファイル: Datacolum.cs プロジェクト: John-Shaw/HoneyPot
 public Datacolumn(string name,System.Data.SqlDbType type,short length)
 {
     Name = name;
     DataType = type;
     Length = length;
 }
コード例 #26
0
 /// <summary>
 /// Adds a <see cref="Parameter"/> to the collection.
 /// </summary>
 /// <param name="name">The name of the parameter.</param>
 /// <param name="type">The parameter System.Data.SqlDbType.</param>
 /// <param name="size">The maximum size of the data within the column.</param>
 /// <param name="typename">The type name for a table valued parameter.</param>
 /// <param name="direction">The direction of the parameter.</param>
 /// <param name="value">The value of the parameter.</param>
 public ParameterCollection Add(string name, System.Data.SqlDbType type, int size, string typename, System.Data.ParameterDirection direction, object value)
 {
     return(Add(new Parameter(name, type, size, typename, direction, value)));
 }
コード例 #27
0
ファイル: CommandData.cs プロジェクト: buibup/Assignment-1
 public void SetParameter(string parameterName, System.Data.SqlDbType dbType)
 {
     SetParameter(parameterName, dbType, null);
 }
コード例 #28
0
        public static SqlParameter AddOutputParameter(this SqlParameterCollection sqlParameters, string parameterName, System.Data.SqlDbType dbType)
        {
            var outputParam = new SqlParameter(parameterName, dbType)
            {
                Direction = System.Data.ParameterDirection.Output
            };

            sqlParameters.Add(outputParam);
            return(outputParam);
        }
コード例 #29
0
ファイル: CommandData.cs プロジェクト: buibup/Assignment-1
 public void SetParameter(string parameterName, System.Data.SqlDbType dbType, object vals)
 {
     System.Data.SqlClient.SqlParameter param = new System.Data.SqlClient.SqlParameter(parameterName, dbType);
     param.Value = vals;
     this.command.Parameters.Add(param);
 }
コード例 #30
0
        public static Type ToNetType(System.Data.SqlDbType sqlDbType)
        {
            switch (sqlDbType)
            {
            case System.Data.SqlDbType.BigInt:
                return(typeof(Int64));

            case System.Data.SqlDbType.Binary:
                return(typeof(Byte));

            case System.Data.SqlDbType.Bit:
                return(typeof(Boolean));

            case System.Data.SqlDbType.Char:
                return(typeof(String));

            case System.Data.SqlDbType.Date:
                return(typeof(DateTime));

            case System.Data.SqlDbType.DateTime:
                return(typeof(DateTime));

            case System.Data.SqlDbType.DateTime2:
                return(typeof(DateTime));

            case System.Data.SqlDbType.DateTimeOffset:
                return(typeof(TimeSpan));

            case System.Data.SqlDbType.Decimal:
                return(typeof(Decimal));

            case System.Data.SqlDbType.Float:
                return(typeof(Double));

            case System.Data.SqlDbType.Image:
                return(typeof(Byte));

            case System.Data.SqlDbType.Int:
                return(typeof(Int32));

            case System.Data.SqlDbType.Money:
                return(typeof(Decimal));

            case System.Data.SqlDbType.NChar:
                return(typeof(String));

            case System.Data.SqlDbType.NText:
                return(typeof(String));

            case System.Data.SqlDbType.NVarChar:
                return(typeof(String));

            case System.Data.SqlDbType.Real:
                return(typeof(Single));

            case System.Data.SqlDbType.SmallDateTime:
                return(typeof(DateTime));

            case System.Data.SqlDbType.SmallInt:
                return(typeof(Int16));

            case System.Data.SqlDbType.SmallMoney:
                return(typeof(Decimal));

            case System.Data.SqlDbType.Structured:
                return(typeof(Object));

            case System.Data.SqlDbType.Text:
                return(typeof(String));

            case System.Data.SqlDbType.Time:
                return(typeof(DateTime));

            case System.Data.SqlDbType.Timestamp:
                return(typeof(Byte));

            case System.Data.SqlDbType.TinyInt:
                return(typeof(Byte));

            case System.Data.SqlDbType.Udt:
                return(typeof(Object));

            case System.Data.SqlDbType.UniqueIdentifier:
                return(typeof(Guid));

            case System.Data.SqlDbType.VarBinary:
                return(typeof(Byte));

            case System.Data.SqlDbType.VarChar:
                return(typeof(String));

            case System.Data.SqlDbType.Variant:
                return(typeof(Object));

            case System.Data.SqlDbType.Xml:
                return(typeof(Object));

            default:
                return(typeof(String));
            }
        }
コード例 #31
0
ファイル: Parameter.cs プロジェクト: nHydrate/nHydrate
        public override void XmlLoad(XmlNode node)
        {
            try
            {
                _key = XmlHelper.GetAttributeValue(node, "key", string.Empty);
                this.Generated = XmlHelper.GetAttributeValue(node, "generated", _def_generated);
                this.Name = XmlHelper.GetAttributeValue(node, "name", string.Empty);
                this.CodeFacade = XmlHelper.GetAttributeValue(node, "codeFacade", _def_codefacade);
                this.Description = XmlHelper.GetAttributeValue(node, "description", _description);
                var relationshipRefNode = node.SelectSingleNode("relationshipRef");
                if (relationshipRefNode != null)
                {
                    RelationshipRef = new Reference(this.Root);
                    RelationshipRef.XmlLoad(relationshipRefNode);
                }

                this.Default = XmlHelper.GetAttributeValue(node, "default", _def_default);
                this.Length = XmlHelper.GetAttributeValue(node, "length", _length);
                this.ResetId(XmlHelper.GetAttributeValue(node, "id", _id));
                this.SortOrder = XmlHelper.GetAttributeValue(node, "sortOrder", _sortOrder);

                var parentTableRefNode = node.SelectSingleNode("parentTableRef");
                ParentTableRef = new Reference(this.Root);
                ParentTableRef.XmlLoad(parentTableRefNode);

                _dataType = (System.Data.SqlDbType)XmlHelper.GetAttributeValue(node, "type", (int)_def_type);

                this.AllowNull = XmlHelper.GetAttributeValue(node, "allowNull", _allowNull);
                this.IsOutputParameter = XmlHelper.GetAttributeValue(node, "isOutputParameter", _isOutputParameter);

                this.Dirty = false;
            }
            catch (Exception ex)
            {
                throw;
            }

        }
コード例 #32
0
ファイル: Extensions.cs プロジェクト: aTiKhan/nHydrate
 /// <summary>
 /// Determines if the type is a number wither floating point or integer
 /// </summary>
 /// <param name="type"></param>
 /// <returns></returns>
 public static bool IsNumericType(this System.Data.SqlDbType type)
 {
     return(IsDecimalType(type) || IsIntegerType(type) || IsMoneyType(type));
 }
コード例 #33
0
        public void Adapt(ref Cls_BD_DAL Obj_bd_DAL)
        {
            try
            {
                Obj_bd_DAL.scadena      = ConfigurationManager.ConnectionStrings["Win_aut"].ToString().Trim();
                Obj_bd_DAL.Obj_conexion = new SqlConnection(Obj_bd_DAL.scadena);
                if (Obj_bd_DAL.Obj_conexion.State == System.Data.ConnectionState.Closed)
                {
                    Obj_bd_DAL.Obj_conexion.Open();
                    Obj_bd_DAL.Obj_adpt = new SqlDataAdapter(Obj_bd_DAL.ssentencia, Obj_bd_DAL.Obj_conexion);
                    if (Obj_bd_DAL.Obj_dtparam.Rows.Count >= 1)
                    {
                        System.Data.SqlDbType Obj_tipo_dato = System.Data.SqlDbType.NVarChar;
                        foreach (System.Data.DataRow dr in Obj_bd_DAL.Obj_dtparam.Rows)
                        {
                            switch (dr[1].ToString())
                            {
                            case "1":
                                Obj_tipo_dato = System.Data.SqlDbType.NVarChar;
                                break;

                            case "2":
                                Obj_tipo_dato = System.Data.SqlDbType.Char;
                                break;

                            case "3":
                                Obj_tipo_dato = System.Data.SqlDbType.Int;
                                break;

                            case "4":
                                Obj_tipo_dato = System.Data.SqlDbType.DateTime;
                                break;

                            case "5":
                                Obj_tipo_dato = System.Data.SqlDbType.Decimal;
                                break;

                            default:
                                break;
                            }
                            Obj_bd_DAL.Obj_adpt.SelectCommand.Parameters.Add(dr[0].ToString(), Obj_tipo_dato).Value = dr[2].ToString();
                        }
                    }
                    Obj_bd_DAL.Obj_adpt.SelectCommand.CommandType = System.Data.CommandType.StoredProcedure;
                    Obj_bd_DAL.Obj_adpt.Fill(Obj_bd_DAL.dst, Obj_bd_DAL.snombretabla);
                }
                Obj_bd_DAL.smsjerror = string.Empty;
            }
            catch (SqlException e)
            {
                Obj_bd_DAL.smsjerror = e.ToString().Trim();
            }
            finally
            {
                if (Obj_bd_DAL.Obj_conexion != null)
                {
                    if (Obj_bd_DAL.Obj_conexion.State == System.Data.ConnectionState.Open)
                    {
                        Obj_bd_DAL.Obj_conexion.Close();
                    }
                    Obj_bd_DAL.Obj_conexion.Dispose();
                }
            }
        }
コード例 #34
0
ファイル: ColumnBase.cs プロジェクト: joangilabert/nHydrate
        public static int GetPredefinedSize(System.Data.SqlDbType dataType)
        {
            //Returns -1 if variable
            switch (dataType)
            {
            case System.Data.SqlDbType.BigInt:
                return(8);

            case System.Data.SqlDbType.Bit:
                return(1);

            case System.Data.SqlDbType.DateTime:
                return(8);

            case System.Data.SqlDbType.Date:
                return(3);

            case System.Data.SqlDbType.Time:
                return(5);

            case System.Data.SqlDbType.DateTimeOffset:
                return(10);

            case System.Data.SqlDbType.Float:
                return(8);

            case System.Data.SqlDbType.Int:
                return(4);

            case System.Data.SqlDbType.Money:
                return(8);

            case System.Data.SqlDbType.Real:
                return(4);

            case System.Data.SqlDbType.SmallDateTime:
                return(4);

            case System.Data.SqlDbType.SmallInt:
                return(2);

            case System.Data.SqlDbType.SmallMoney:
                return(4);

            case System.Data.SqlDbType.Timestamp:
                return(8);

            case System.Data.SqlDbType.TinyInt:
                return(1);

            case System.Data.SqlDbType.UniqueIdentifier:
                return(16);

            case System.Data.SqlDbType.Image:
            case System.Data.SqlDbType.Text:
            case System.Data.SqlDbType.NText:
            case System.Data.SqlDbType.Xml:
                return(1);

            default:
                return(-1);
            }
        }
コード例 #35
0
        public void Exe_NonQuery(ref Cls_BD_DAL Obj_bd_DAL)
        {
            try
            {
                Obj_bd_DAL.scadena      = ConfigurationManager.ConnectionStrings["Win_aut"].ToString();
                Obj_bd_DAL.Obj_conexion = new SqlConnection(Obj_bd_DAL.scadena);
                if (Obj_bd_DAL.Obj_conexion.State == System.Data.ConnectionState.Closed)
                {
                    Obj_bd_DAL.Obj_conexion.Open();
                    Obj_bd_DAL.Obj_sql_cmnd = new SqlCommand(Obj_bd_DAL.ssentencia, Obj_bd_DAL.Obj_conexion);

                    if (Obj_bd_DAL.Obj_dtparam.Rows.Count >= 1)
                    {
                        System.Data.SqlDbType Obj_tipo_dato = System.Data.SqlDbType.NVarChar;
                        foreach (System.Data.DataRow Celda in Obj_bd_DAL.Obj_dtparam.Rows)
                        {
                            switch (Celda[1].ToString())
                            {
                            case "1":
                                Obj_tipo_dato = System.Data.SqlDbType.NVarChar;
                                break;

                            case "2":
                                Obj_tipo_dato = System.Data.SqlDbType.Char;
                                break;

                            case "3":
                                Obj_tipo_dato = System.Data.SqlDbType.Int;
                                break;

                            case "4":
                                Obj_tipo_dato = System.Data.SqlDbType.DateTime;
                                break;

                            case "5":
                                Obj_tipo_dato = System.Data.SqlDbType.Decimal;
                                break;

                            default:
                                break;
                            }
                            Obj_bd_DAL.Obj_sql_cmnd.Parameters.Add(Celda[0].ToString(), Obj_tipo_dato).Value = Celda[2].ToString();
                        }
                    }
                    Obj_bd_DAL.Obj_sql_cmnd.CommandType = System.Data.CommandType.StoredProcedure;
                    Obj_bd_DAL.Obj_sql_cmnd.ExecuteNonQuery();
                }
                Obj_bd_DAL.smsjerror = string.Empty;
            }
            catch (SqlException error)
            {
                Obj_bd_DAL.smsjerror = error.ToString();
            }
            finally
            {
                if (Obj_bd_DAL.Obj_conexion != null)
                {
                    if (Obj_bd_DAL.Obj_conexion.State == System.Data.ConnectionState.Open)
                    {
                        Obj_bd_DAL.Obj_conexion.Close();
                    }
                }
                Obj_bd_DAL.Obj_conexion.Dispose();
            }
        }