private static void AddParams(DbCommand cmd, QueryCommand qry)         {             if(qry.Parameters != null)             {                 foreach(QueryParameter param in qry.Parameters)                 {                     DbParameter p = cmd.CreateParameter();                     p.ParameterName = param.ParameterName;                     p.Direction = param.Mode;                     p.DbType = param.DataType;                     /*                      * 修 改 人：Empty（AllEmpty）                      * 修改说明：修改提交的字符串长度过长产生的Bug                      * 异常信息：System.Data.SqlClient.SqlException (0x80131904): 传入的表格格式数据流(TDS)远程过程调用(RPC)协议流不正确。                      *           参数 4 ("@up_xxx"): 数据类型 0xA7 的数据长度或元数据长度无效。                      *********************************************/                     if (param.DataType.ToString() == "AnsiString")                     {                         p.Size = -1;                     }                     //output parameters need to define a size                     //our default is 50                     if(p.Direction == ParameterDirection.Output || p.Direction == ParameterDirection.InputOutput)                         p.Size = param.Size;                     //fix for NULLs as parameter values                     if(param.ParameterValue == null)                     {                         p.Value = DBNull.Value;                     }                     else if(param.DataType == DbType.Guid)                     {                         string paramValue = param.ParameterValue.ToString();                         if (!String.IsNullOrEmpty(paramValue))                         {                             if(!paramValue.Equals("DEFAULT", StringComparison.InvariantCultureIgnoreCase))                                 p.Value = new Guid(paramValue);                         }                         else                             p.Value = DBNull.Value;                     }                     else                         p.Value = param.ParameterValue;                     cmd.Parameters.Add(p);                 }             }         }