Beispiel #1
0
        public string SaveRptStyle(ReportStyle rpt)
        {
            //要加入时间类型判断

            var rptId     = rpt.RptID;
            var rptName   = rpt.RptName;
            var rptStyle  = rpt.RptStyle;
            var orgId     = rpt.OrgId;
            var treeId    = rpt.TreeId;
            var styleType = rpt.styleType;

            string errMsg = string.Empty;

            switch (dbTypeValue)
            {
            case "SQL":
            {
                var sqlInsert = "INSERT INTO T_INFO_SISREPORT(REPORTTYPE,REPORTID,REPORTNAME,REPORTSTYLE,ORGID,TREEID) VALUES(@p1,@p2,@p3,@p4,@p5,@p6)";
                var sqlDelete = "DELETE FROM T_INFO_SISREPORT WHERE REPORTID=@p1 AND ORGID=@p2 AND TREEID=@p3";
                using (var conn = new SqlConnection(DBsql.GetConnectionstr()))
                {
                    conn.Open();
                    SqlTransaction transaction = conn.BeginTransaction();
                    var            pDel        = new[]
                    {
                        new SqlParameter("@p1", rptId),
                        new SqlParameter("@p2", orgId),
                        new SqlParameter("@p3", treeId)
                    };
                    var pIns = new[]
                    {
                        new SqlParameter("@p1", styleType),
                        new SqlParameter("@p2", rptId),
                        new SqlParameter("@p3", rptName),
                        new SqlParameter("@p4", rptStyle),
                        new SqlParameter("@p5", orgId),
                        new SqlParameter("@p6", treeId)
                    };
                    try
                    {
                        DBsql.ExecuteNonQuery(transaction, CommandType.Text, sqlDelete, pDel);
                        DBsql.ExecuteNonQuery(transaction, CommandType.Text, sqlInsert, pIns);
                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        errMsg = ex.Message;
                    }
                }
            }
            break;

            case "ORACLE":
            {
                //修改Oracle后按照SqlServer对照一次,否则出错
                var sqlInsert = "INSERT INTO T_INFO_SISREPORT(REPORTID,REPORTNAME,REPORTSTYLE,ORGID,TREEID,REPORTTYPE) VALUES(:p1,:p2,:p3,:p4,:p5,:p6)";
                var sqlDelete = "DELETE FROM T_INFO_SISREPORT WHERE REPORTNAME=:p1 AND ORGID=:p2 AND TREEID=:p3";
                var pDel      = new[]
                {
                    new OracleParameter(":p1", rptName),
                    new OracleParameter(":p2", orgId),
                    new OracleParameter(":p3", treeId)
                };
                var pIns = new[]
                {
                    new OracleParameter(":p1", rptId),
                    new OracleParameter(":p2", rptName),
                    new OracleParameter(":p3", rptStyle),
                    new OracleParameter(":p4", orgId),
                    new OracleParameter(":p5", treeId),
                    new OracleParameter(":p6", styleType)
                };

                using (var conn = new OracleConnection(OracleHelper.retStr()))
                {
                    conn.Open();
                    var transaction = conn.BeginTransaction();
                    try
                    {
                        SAC.DBOperations.OracleHelper.ExecuteNonQuery(transaction, CommandType.Text, sqlDelete, pDel);
                        SAC.DBOperations.OracleHelper.ExecuteNonQuery(transaction, CommandType.Text, sqlInsert, pIns);
                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        errMsg = ex.Message;
                    }
                }
            }
            break;

            default:    //db2
            {
                var sqlInsert = "INSERT INTO T_INFO_SISREPORT(REPORTID,REPORTNAME,REPORTSTYLE,ORGID,TREEID) VALUES(?,?,?,?,?)";
                var sqlDelete = "DELETE FROM T_INFO_SISREPORT WHERE REPORTNAME=? AND ORGID=? AND TREEID=?";

                var pDel = new[]
                {
                    new OleDbParameter("?", rptName),
                    new OleDbParameter("?", orgId),
                    new OleDbParameter("?", treeId)
                };
                var pIns = new[]
                {
                    new OleDbParameter("?", rptId),
                    new OleDbParameter("?", rptName),
                    new OleDbParameter("?", rptStyle),
                    new OleDbParameter("?", orgId),
                    new OleDbParameter("?", treeId)
                };
                using (var conn = DBdb2.GetConn())
                {
                    conn.Open();
                    var transaction = conn.BeginTransaction();
                    try
                    {
                        DBdb2.ExecuteNonQuery(transaction, CommandType.Text, sqlDelete, pDel);
                        DBdb2.ExecuteNonQuery(transaction, CommandType.Text, sqlInsert, pIns);

                        transaction.Commit();
                    }
                    catch (Exception ex)
                    {
                        transaction.Rollback();
                        errMsg = ex.Message;
                    }
                }
            }
            break;
            }

            return(errMsg);
        }