//public FPInfoAttribute(string dataType) public PropertyInfoAttribute(System.Data.SqlDbType dataType) { DataType = dataType; PrimaryKey = false;// Default value. UniqueKey = false; SecondaryKey = false; IsNull = true; }
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); } }
/// <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); }
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"); } }
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()); } }
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(); }
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); }
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; } }
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); }
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); }
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; } }
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); }
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); }
protected List <T> GetAllByColumnValue(string columnName, object value, System.Data.SqlDbType type) { SqlParameter parameter = MakeSqlParameter(columnName, value, type); return(IdenticalMatch(new SqlParameter[] { parameter })); }
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)); }
/// <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)); }
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); }
//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; }
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); }
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 })); }
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); } }
public IParameter Create(string name, System.Data.SqlDbType dbType, ParameterDirection direction) { return(new Parameter().Initialize(name, typeof(object), 0, dbType, direction, null)); }
public Datacolumn(string name, System.Data.SqlDbType type) { Name = name; DataType = type; }
public KeyInitializer(string beforInsert, string afterInsert, bool setInInsert, System.Data.SqlDbType sqlDbType, object emptyValue) { _beforInsert = beforInsert; _afterInsert = afterInsert; _emptyValue = emptyValue; _setInInsert = setInInsert; _sqlDbType = sqlDbType; }
public Datacolumn(string name,System.Data.SqlDbType type,short length) { Name = name; DataType = type; Length = length; }
/// <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))); }
public void SetParameter(string parameterName, System.Data.SqlDbType dbType) { SetParameter(parameterName, dbType, null); }
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); }
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); }
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)); } }
/// <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)); }
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(); } } }
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); } }
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(); } }