Decimal赋值DBNull

最新推荐文章于 2024-02-02 09:50:42 发布

Karl_zhujt

最新推荐文章于 2024-02-02 09:50:42 发布

阅读量4.2k

点赞数

分类专栏： Oracle 文章标签： exception string null cmd

本文链接：https://blog.csdn.net/mh942408056/article/details/7072785

版权

Oracle 专栏收录该内容

29 篇文章 1 订阅

订阅专栏

private static void PrepareCommand(SqlCommand cmd, SqlConnection conn, SqlTransaction trans, string cmdText, SqlParameter[] cmdParms)
        {
            if (conn.State != ConnectionState.Open)
            {
                conn.Open();
            }
            cmd.Connection = conn;
            cmd.CommandText = cmdText;
            if (trans != null)
                cmd.Transaction = trans;
            cmd.CommandType = CommandType.Text;//cmdType;
            if (cmdParms != null)
            {
                foreach (SqlParameter parm in cmdParms)
                {
                    if (parm.SqlDbType == SqlDbType.DateTime && parm.Value != DBNull.Value)
                    {
                        if ((DateTime)parm.Value == DateTime.MinValue)
                            parm.Value = System.DBNull.Value;
                    }
                    if (parm.SqlDbType == SqlDbType.Decimal && parm.Value != DBNull.Value)
                    {
                        try
                        {
                            decimal dd = (decimal)parm.Value;

                            if ((decimal)parm.Value == decimal.MinValue)
                                parm.Value = System.DBNull.Value;
                        }
                        catch (Exception ex)
                        {
                            string ss = "";
                            //parm.Value = System.DBNull.Value;
                        }
                    }

                    cmd.Parameters.Add(parm);
                }
            }
        }